Update does not work in api controller call in asp.net .

Question

3.00/5 (2 votes)

See more:

I publish my project then upload it into server here update does not work but when i run it in visual studio 2012 its work.

C#

private bool UpdateShoppingCartItemByCustomerId(int CustId)
        {
            try
            {
                bool Return = false;
                ViewCartHelper objHelper = new ViewCartHelper();
                ViewCartModel model = new ViewCartModel();
                model.GuestCustomerId = _objCustomer.Id;
                model.CustomerId = CustId;
                HttpResponseMessage response = objHelper.Update("api/ViewCart/", model);  // Blocking call!
                if (response.IsSuccessStatusCode)
                {
                    Return = true;
                }
                return Return;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

this is my controller call

controler also given bellow

C#

public bool Put(ViewCartModel model)
        {
            return repository.Update(model);
        }

My linq code is given bellow

C#

public bool Update(ViewCartModel ProductItem)
        {
            try
            {
                bool bFlag = false;
                if (ProductItem == null)
                {
                    throw new ArgumentNullException("item");
                }
                //string dtDate = System.DateTime.Now.ToString();

                using (var contextDb = new AllVetMedDbEntities())
                {
                    var query = (from Item in contextDb.ShoppingCartItems
                                 where Item.Id == ProductItem.Id
                                 select Item).SingleOrDefault();

                    var original = contextDb.ShoppingCartItems.Find(ProductItem.Id);
                    if (ProductItem.GuestCustomerId > 0)
                    {
                        var SoppingCartList = (from objcartItem in contextDb.ShoppingCartItems
                                               where objcartItem.CustomerId == ProductItem.GuestCustomerId
                                               select objcartItem).ToList();
                        SoppingCartList.ForEach(x => x.CustomerId = ProductItem.CustomerId);

                        contextDb.SaveChanges();
                        bFlag = true;

                        contextDb.SaveChanges();
                        bFlag = true;

                    }
                    else
                    {
                        if (original != null)
                        {
                            original.Quantity = ProductItem.Quantity;
                            contextDb.SaveChanges();
                            bFlag = true;
                        }
                    }
                    //}
                }


                return bFlag;
            }
            catch(Exception ex) {
                throw ex;
            }
        }

Posted 8-Jan-14 23:24pm

Rajib Mahata

Updated 8-Jan-14 23:25pm

Bojjaiah

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajib Mahata · Answer 1 · 2014-01-14T02:15:00

Solution 2

XML

this problem has been solve by adding this on web.config file.
<modules runallmanagedmodulesforallrequests="true">
        <remove name="WebDAVModule"> **&lt;- add this**
    </remove></modules>

Posted 14-Jan-14 2:15am

Rajib Mahata

CBadger · Answer 2 · 2014-01-09T00:37:00

Make sure your naming conventions in your db is exactly the same as on the server. I might be wrong but looking over your code the only place I can see that it will update wrong is

C#

using (var contextDb = new AllVetMedDbEntities())
                {

It might be that the data is not updating in the db as it is not the same or does not comply with the same naming as on your pc (in debug)

_________________________EDIT______________________________________________

Also just have a look at the code in linq there is a duplicate

C#

contextDb.SaveChanges();
bFlag = true;

contextDb.SaveChanges();
bFlag = true;

You also never use the linq query...

C#

var query = (from Item in contextDb.ShoppingCartItems
             where Item.Id == ProductItem.Id
             select Item).SingleOrDefault();

But I do gather that you probably meant to do this...

C#

var query = (from Item in contextDb.ShoppingCartItems
             where Item.Id == ProductItem.Id
             select Item).SingleOrDefault();

             var original = contextDb.ShoppingCartItems.Find(query.Id);