public Int32 postSupplier(Entities.MstSupplier supplier)
{
try
{
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
var accounts = from d in db.MstAccounts
select d;
var term = from d in db.MstTerms
select d;
//var tax = from d in db.MstTaxes
// select d;
//var unit = from d in db.MstUnits
// select d;
//var supplier = from d in db.MstSuppliers
// select d;
Data.MstSupplier newSupplier = new Data.MstSupplier();
newSupplier.Supplier = "n/a";
newSupplier.Address = "n/a";
newSupplier.TelephoneNumber = "n/a";
newSupplier.CellphoneNumber = "n/a";
newSupplier.FaxNumber = "n/a";
newSupplier.TermId = term.Select(m => m.Id).FirstOrDefault();
newSupplier.TIN = "n/a";
newSupplier.AccountId = accounts.Select(m => m.Id).FirstOrDefault();
newSupplier.EntryUserId = userId;
newSupplier.EntryDateTime = DateTime.Today;
newSupplier.UpdateUserId = userId;
newSupplier.UpdateDateTime = DateTime.Today;
newSupplier.IsLocked = false;
db.MstSuppliers.InsertOnSubmit(newSupplier);
db.SubmitChanges();
return(newSupplier.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public HttpResponseMessage putSupplier(String id, Entities.MstSupplier supplier)
{
try
{
var suppliers = from d in db.MstSuppliers where d.Id == Convert.ToInt32(id) select d;
if (suppliers.Any())
{
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
var updateSupplier = suppliers.FirstOrDefault();
updateSupplier.Supplier = supplier.Supplier;
updateSupplier.Address = supplier.Address;
updateSupplier.TelephoneNumber = supplier.TelephoneNumber;
updateSupplier.CellphoneNumber = supplier.CellphoneNumber;
updateSupplier.FaxNumber = supplier.FaxNumber;
updateSupplier.TermId = supplier.TermId;
updateSupplier.TIN = supplier.TIN;
updateSupplier.AccountId = supplier.AccountId;
updateSupplier.EntryUserId = supplier.EntryUserId;
updateSupplier.EntryDateTime = DateTime.Now;
updateSupplier.UpdateUserId = supplier.UpdateUserId;
updateSupplier.UpdateDateTime = DateTime.Now;
updateSupplier.IsLocked = supplier.IsLocked;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
