示例#1
0
        public HttpResponseMessage postCostumer(Entites.Costmuer addCostumer)
        {
            try
            {
                //var LastId= from d in db.MstCostumers.OrderByDescending
                Data.MstCostumer newCostumer = new Data.MstCostumer();
                newCostumer.Fname         = addCostumer.Fname != null ? addCostumer.Fname : "NA";
                newCostumer.Mname         = addCostumer.Mname;
                newCostumer.Lname         = addCostumer.Lname != null ? addCostumer.Lname : "NA";
                newCostumer.Addres        = addCostumer.Address != null ? addCostumer.Address : "NA";
                newCostumer.ContactNumber = addCostumer.ContactNumber != null ? addCostumer.ContactNumber : "NA";
                newCostumer.CreditLimit   = addCostumer.CreditLimit;



                db.MstCostumers.InsertOnSubmit(newCostumer);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }
示例#2
0
        public HttpResponseMessage update(String id, Entites.Costmuer item)
        {
            try
            {
                var ItemId = Convert.ToInt32(id);
                var costID = from d in db.MstCostumers where d.ID == ItemId select d;


                if (costID.Any())
                {
                    var updateCost = costID.FirstOrDefault();

                    updateCost.Fname         = item.Fname;
                    updateCost.Mname         = item.Mname;
                    updateCost.Lname         = item.Lname;
                    updateCost.Addres        = item.Address;
                    updateCost.ContactNumber = item.ContactNumber;
                    updateCost.CreditLimit   = item.CreditLimit;

                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }