public Int32 postSupplier() { try { 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 = TermId(); newSupplier.TIN = "n/a"; newSupplier.AccountId = AccountId(); 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) { return(0); } }
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); } }