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);
}
}
