Intersoft Community - WebDesktop - Error with batch update using client side binding and WebService

Error with batch update using client side binding and WebService

mmikaeel2 — Wed, 20 Oct 2010 18:19:44 GMT

You can do something like this, which works better too:

[WebMethod]    public object GetMembershipNotes(DataSourceSelectArguments selectArguments)
    {
        String[] strParameters = selectArguments.FilterExpression.Split(',');
        int nMembershipID = 0, nEntityTypeID = 0, nNoteType = 0;
        Int32.TryParse(strParameters[0], out nEntityTypeID);
        Int32.TryParse(strParameters[1], out nNoteType);
        Int32.TryParse(strParameters[2], out nMembershipID);
        
        ArrayList list = new ArrayList();
        foreach(Business.Note note in Business.NoteController.GetNotesForEntityAndNoteType(nEntityTypeID, nMembershipID, nNoteType) )
        {
            Note msNote         = new Note();
            msNote.NoteID       = note.NoteID;
            msNote.FullName     = note.User.LastName + ", " + note.User.FirstName;
            msNote.CreateDate   = note.CreateDate;
            msNote.Text         = note.Text;
            list.Add(msNote);
        }
        return list;
        throw new InvalidOperationException("Unsupported operation type!");
    }

On this example, I completely got the data from outside the LINQ and just stored it in list of LIN table.

For updates, you can do this:

[WebMethod]
    public TransactionResult UpdateMembershipCheque(MembershipCheque newObject, MembershipCheque originalObject)
    { 
        Business.MembershipCheque cheque = Business.MembershipChequeController.GetMembershipCheque(originalObject.MembershipChequeID);
        
        cheque.BatchNo      = newObject.BatchNo;
        cheque.ChequeNo     = newObject.ChequeNo;
        cheque.DepositDate  = newObject.DepositDate;
        cheque.DueDate      = newObject.DueDate;
        cheque.Save();
        MembershipDataContext context = new MembershipDataContext();
        return new TransactionResult()
        {
            OperationType = DataSourceOperation.Update,
            ReturnValue = true
        };
    }

So you can build your classes and functions normally outside the LINQ schema, you on that case will need linq to exchange the data that you already collcted it.

I hope that will help you better.

Thanks,

Maged

I hope that works good for you too.

Thanks,

Maged

Error with batch update using client side binding and WebService

mmikaeel2 — Wed, 20 Oct 2010 18:12:10 GMT

Hi Dave,

I found so limitation on LINQ sql, so I decide to take different root.

For example it doesn't support left join easily...etc

So you can simply run your own SQL statements on different classes/functions and from there you can collect data from different tables on store it on LINQ table on extra fields you can create manually, so next is example of that:

[WebMethod]
    public object GetMembershipTransactions(DataSourceSelectArguments selectArguments)
    {
        MembershipDataContext context = new MembershipDataContext();
        context.DeferredLoadingEnabled = false;
        context.ObjectTrackingEnabled = false;
        int nMembershipID = 0;
        Int32.TryParse(selectArguments.FilterExpression, out nMembershipID);
        var MembershipTransactions = from membershipTransaction in context.MembershipTransactions
                                     where membershipTransaction.MembershipID == nMembershipID
                                       select new
                                       {
                                           MembershipTransactionID  = membershipTransaction.MembershipTransactionID,
                                           TransactionDate          = membershipTransaction.TransactionDate,
                                           Amount                   = membershipTransaction.Amount,
                                           ChequeNo                 = GetChequeNo(membershipTransaction.MembershipChequeID),
                                           CreditCardNo             = GetCreditCardInfo(membershipTransaction.CreditCardID),
                                           Processed                = membershipTransaction.Processed,
                                           ProcessDate              = membershipTransaction.ProcessDate,
                                           ReferenceNo              = membershipTransaction.ReferenceNo,
                                           Note                     = membershipTransaction.Note
                                       };
        return MembershipTransactions.ToList();
        throw new InvalidOperationException("Unsupported operation type!");
    }

As you can see, the credit card no and cheque no, I got them from different table and function without the hasle of LINQ sql statements.

Or you can even do something like this (even better:

Error with batch update using client side binding and WebService

dmcgoff — Wed, 20 Oct 2010 12:22:43 GMT

Hi Maged,

Again, thank you for solving this problem. I have another question...

As you know, Intersoft has a class ISNet.Data.Linq.WebGridDataProvider which has two methods that are very useful. The first is the Select(DataSourceSelectArguments selectArguments) method and the second is the BatchUpdate(List<ClientRowChanges> changes). When a grid displays data for an entity that is mapped to one table, both of these methods work very well. However, in our case, we want to display data from multiple tables.

I already asked you about BatchUpdate in my previous post. I am also interested in how you implemented the Select method. Below is my attempt. I create a query which joins the two tables and places the result in a custom class which I created manually. My solution works but is very inefficient because I have to enumerate the query and place the results into a list. If I don't, the select method throws the following exception:

"IntersoftWebApp1.BugWithOwner' is not a valid metadata type for type filtering operations.
Type filtering is only valid on entity types and complex types."

This is my code. Would you share your solution??

var datasource = from b in context.Bugs join o in context.Owners on b.BugId equals o.BugId into tl_j from j in tl_j.DefaultIfEmpty() select new BugWithOwner

{

BugId = b.BugId,

ChangeInLast = b.ChangeInLast,

Component = b.Component,

Dupe = b.Dupe,

OpSys = b.OpSys,

Severity = b.Severity,

Summary = b.Summary,

Target = b.Target,

OwnerId = j.OwnerId == null ? -1 : j.OwnerId,

OwnerName = j.OwnerName == null ? "" : j.OwnerName,

};

null ? -1 : j.OwnerId,

OwnerName = j.OwnerName == null ? "" : j.OwnerName,

};

null ? "" : j.OwnerName,

};

IList<BugWithOwner> l = new List<BugWithOwner>();

foreach (BugWithOwner p in datasource) l.Add(p);

WebGridDataProvider<BugWithOwner> provider = new WebGridDataProvider<BugWithOwner>(l.AsQueryable());

object data = provider.Select(selectArguments); if (data != null) return data; throw new InvalidOperationException("Unsupported operation type!");

Error with batch update using client side binding and WebService

dmcgoff — Tue, 19 Oct 2010 23:20:53 GMT

Hi Maged,

Your solution to the problem works great - thanks!!!

I'm assuming that you had to implement the "BatchUpdate" method that is provided by Intersoft because we are using multiple tables.

This is my implementation for the update, but it doesn't seem to work. Can you please provide your implementation??

[WebMethod] [GenerateScriptType(typeof(BugWithOwner))] public TransactionResult UpdateBugs(List<ClientRowChanges> changes)

{

BugTrackerModelDataContext context = new BugTrackerModelDataContext(); //WebGridDataProvider<Bug> provider = new WebGridDataProvider<Bug>(context.Bugs.AsQueryable()); //return provider.BatchUpdate(changes); foreach (ClientRowChanges change in changes)

{

BugWithOwner bugWithOwner = (BugWithOwner)change.NewObject; // ------------------ Bug Table -------------------------------------- Bug NewBug = new Bug

{

BugId = bugWithOwner.BugId,

Dupe = bugWithOwner.Dupe,

ChangeInLast = bugWithOwner.ChangeInLast,

Component = bugWithOwner.Component,

Severity = bugWithOwner.Severity,

OpSys = bugWithOwner.OpSys,

Target = bugWithOwner.Target,

Summary = bugWithOwner.Summary,

};

// Always returns a result Bug OriginalBug = context.Bugs.Where(b => b.BugId == bugWithOwner.BugId).Single(); // Update the values

OriginalBug.BugId = NewBug.BugId;

OriginalBug.Dupe = NewBug.Dupe;

OriginalBug.ChangeInLast = NewBug.ChangeInLast;

OriginalBug.Component = NewBug.Component;

OriginalBug.Severity = NewBug.Severity;

OriginalBug.OpSys = NewBug.OpSys;

OriginalBug.Target = NewBug.Target;

OriginalBug.Summary = NewBug.Summary;

// ----------------------- Owner Table ------------------------------------ Owner NewOwner = new Owner

{

BugId = bugWithOwner.BugId,

OwnerId = bugWithOwner.OwnerId,

OwnerName = bugWithOwner.OwnerName,

};

// Original data was a left join so this may be null/blank // Updating if (NewOwner.OwnerId != -1)

{

Owner OriginalOwner = context.Owners.Where(o => o.OwnerId == bugWithOwner.OwnerId).Single(); // Only field we can update

OriginalOwner.OwnerName = NewOwner.OwnerName;

}

else if ((NewOwner.OwnerId == -1) && (!string.IsNullOrEmpty(NewOwner.OwnerName)))

{

// Create New

context.Owners.Attach(NewOwner);

}

// Otherwise now Owner data to update

}

// Persist changes

context.SubmitChanges();

// Fake a transaction result TransactionResult tr = new TransactionResult

{

AffectedResults = 0,

Exception = null,

ExceptionHandled = false,

OperationType = DataSourceOperation.BatchUpdate,ReturnValue =

null,

ExceptionHandled = false,

OperationType = DataSourceOperation.BatchUpdate, ReturnValue =

false,

OperationType = DataSourceOperation.BatchUpdate,ReturnValue =

DataSourceOperation.BatchUpdate, ReturnValue = false, ViewName = null,

};

return tr;

}

Error with batch update using client side binding and WebService

mmikaeel2 — Tue, 19 Oct 2010 16:08:27 GMT

Hi Guys,

I was not correct on my previous message about the root cause of this error.

Now, I think I got it correct this time and I was able to even make it happen with the ClientBinding_BatchUpdate.aspx Intersoft sample.

So, in the BugTrackerModel.designer.cs, if you define

namespace DataSet

{

}

That will make the error happen too.

In ClientBinding_BatchUpdate.aspx we have this function:

function Bug()
        {
            this.__type = "Bug";
            this.BugId = -1;
            this.Dupe = null;
            this.ChangeInLast = null;
            this.Component = null;
            this.Severity = null;
            this.OpSys = null;
            this.Target = null;
            this.Summary = null;
        }

So to make it work again, change it to:

function Bug()
        {
            this.__type = "DataSet.Bug";
            this.BugId = -1;
            this.Dupe = null;
            this.ChangeInLast = null;
            this.Component = null;
            this.Severity = null;
            this.OpSys = null;
            this.Target = null;
            this.Summary = null;
        }

That set!

Damn, three days to find out that!

I guess Intersoft need to change their sample to match this scenario!

Maged Mikaeel

Error with batch update using client side binding and WebService

dmcgoff — Tue, 19 Oct 2010 14:59:14 GMT

Can you post the code edits you made to fix this?

Thanks,

Dave

Error with batch update using client side binding and WebService

mmikaeel2 — Tue, 19 Oct 2010 13:36:53 GMT

Okay, fixed ......

So there is always work around to fix errors.

But I believe you guys at Intersoft need to do something to fix this issue from your side instead of the work around that I implemented!

So here is the fix:

1- My grid doesn't have all the fields from the table, as I don't need to display them all.

2- I have another fields from different tables displayed on the same grid.

3- The main issues is, you need to pass an object from the GRID to the update function, and that object has to match exactly the fields in the grid.

4- I created a table class in my data context with properties exactly the same as the fields in the grid.

5- I changed the update function to have the send parameter with the new created class instead of the original table class from the database.

6- I used the original class to save the data.

7- returned fake transaction result for success.

That stopped this error of happening.

I still believe that Intersoft need to fox that from the engine instead of creating fake classes like that.

Thanks,

Maged

Error with batch update using client side binding and WebService

dmcgoff — Tue, 19 Oct 2010 00:22:51 GMT

Glenn,

Were you able to recreate my error using the sample I provided?

The error is a JavaScript error. The request never gets fired to the Web Service. Here is the error:

{"Message":"Operation is not valid due to the current state of the object.","StackTrace":" at System.Web.Script.Serialization.ObjectConverter.ConvertDictionaryToObject(IDictionary`2 dictionary, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeInternal(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeMain(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeDictionary(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeList(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeDictionary(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.BasicDeserialize(String input, Int32 depthLimit, JavaScriptSerializer serializer)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(JavaScriptSerializer serializer, String input, Type type, Int32 depthLimit)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize[T](String input)\r\n at System.Web.Script.Services.RestHandler.GetRawParamsFromPostRequest(HttpContext context, JavaScriptSerializer serializer)\r\n at System.Web.Script.Services.RestHandler.GetRawParams(WebServiceMethodData methodData, HttpContext context)\r\n at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)","ExceptionType":"System.InvalidOperationException"}

Error with batch update using client side binding and WebService

mmikaeel2 — Tue, 19 Oct 2010 00:20:18 GMT

That will not work, as the error is generated before we reach the update function it self, so I believe any change in the update function itself will not help, as the error still happening before we go there!

Error with batch update using client side binding and WebService

Glayaar — Tue, 19 Oct 2010 00:09:36 GMT

Have you trind manually updating the database instead of using WebGridDataProvider? After a successful operation, you will need to return TransactionResult object as detaild in the article "Transaction Operations (Insert, Update and Delete)" in the WebGrid documentation.

Here is the update snippet for a composite table, exception handling is not implemented:

[WebMethod]
[GenerateScriptType(typeof(BugCustom))]
public TransactionResult UpdateBugsCustom(List<ClientRowChanges> changes)
{
    BugTrackerEntities context = new BugTrackerEntities();

    BugTrackerModel.Bug bSingle = null;
    BugTrackerModel.Owner oSingle = null;

    foreach(ClientRowChanges change in changes)
    {
        BugCustom currRow = (BugCustom)change.NewObject;
        bSingle = context.Bugs.SingleOrDefault(b => b.BugId == currRow.BugId);
        bSingle.Summary = currRow.Summary;

        oSingle = context.Owners.SingleOrDefault(o => o.OwnerID == currRow.OwnerID);
        oSingle.OwnerName = currRow.OwnerName;
    }
        
    int saveResult = context.SaveChanges();

    return new TransactionResult(){
        AffectedResults = saveResult,
        OperationType = DataSourceOperation.BatchUpdate,
        ReturnValue = true  
    };
}

Error with batch update using client side binding and WebService

mmikaeel2 — Sun, 17 Oct 2010 01:00:32 GMT

I have a WebGrid, enabled batch update, client side binding using werbserive.

The reading works perfect and really fast.

My issue is with the write functionality, it always display an error which I really can't figure out!

I checked everything, all looks ok, so please help me on this!

The data context code was auto generated, so no mistake on that.

So this is the WebSerive update function:

WebMethod]
[GenerateScriptType(typeof(MembershipCheque))]
public TransactionResult BatchUpdateMembershipCheques(List<ClientRowChanges> changes)
    {
        MembershipDataContext context = new MembershipDataContext();
        WebGridDataProvider<MembershipCheque> provider = new WebGridDataProvider<MembershipCheque>(context.MembershipCheques.AsQueryable());
        return provider.BatchUpdate(changes);
    }

This is the error I got:

{"Message":"Operation is not valid due to the current state of the object.","StackTrace":" at System.Web.Script.Serialization.ObjectConverter.ConvertDictionaryToObject(IDictionary`2 dictionary, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeInternal(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeMain(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToType(Object o, Type type, JavaScriptSerializer serializer)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeDictionary(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeList(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeDictionary(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.BasicDeserialize(String input, Int32 depthLimit, JavaScriptSerializer serializer)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(JavaScriptSerializer serializer, String input, Type type, Int32 depthLimit)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize[T](String input)\r\n at System.Web.Script.Services.RestHandler.GetRawParamsFromPostRequest(HttpContext context, JavaScriptSerializer serializer)\r\n at System.Web.Script.Services.RestHandler.GetRawParams(WebServiceMethodData methodData, HttpContext context)\r\n at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)","ExceptionType":"System.InvalidOperationException"}