public HttpResponseMessage putCustomer(String id, Entities.MstCustomer customer) { try { var customers = from d in db.MstCustomers where d.Id == Convert.ToInt32(id) select d; if (customers.Any()) { //var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id; var updateCustomers = customers.FirstOrDefault(); updateCustomers.Customer = customer.Customer; updateCustomers.Address = customer.Address; updateCustomers.ContactPerson = customer.ContactPerson; updateCustomers.ContactNumber = customer.ContactNumber; updateCustomers.CreditLimit = customer.CreditLimit; updateCustomers.TermId = customer.TermId; updateCustomers.TIN = customer.TIN; updateCustomers.WithReward = customer.WithReward; updateCustomers.RewardNumber = customer.RewardNumber; updateCustomers.RewardConversion = customer.RewardConversion; updateCustomers.AccountId = customer.AccountId; updateCustomers.EntryUserId = customer.EntryUserId; updateCustomers.EntryDateTime = DateTime.Now; updateCustomers.UpdateUserId = customer.UpdateUserId; updateCustomers.UpdateDateTime = DateTime.Now; updateCustomers.IsLocked = true; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 postCustomer(Entities.MstCustomer customer) { try { var term = from d in db.MstTerms select d; var account = from d in db.MstAccounts select d; var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id; Data.MstCustomer newCustomer = new Data.MstCustomer(); newCustomer.Customer = "n/a"; newCustomer.Address = "n/a"; newCustomer.ContactPerson = "n/a"; newCustomer.ContactNumber = "n/a"; newCustomer.CreditLimit = 0; newCustomer.TermId = term.Select(m => m.Id).FirstOrDefault(); newCustomer.TIN = "n/a"; newCustomer.WithReward = false; newCustomer.RewardNumber = "n/a"; newCustomer.RewardConversion = 0; newCustomer.AccountId = account.Select(m => m.Id).FirstOrDefault(); newCustomer.EntryUserId = userId; newCustomer.EntryDateTime = DateTime.Today; newCustomer.UpdateUserId = userId; newCustomer.UpdateDateTime = DateTime.Today; newCustomer.IsLocked = false; db.MstCustomers.InsertOnSubmit(newCustomer); db.SubmitChanges(); return(newCustomer.Id); } catch (Exception e) { Debug.WriteLine(e); return(0); } }