public void Update(Interface.IinvoiceCompany obj) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var updateing = dbContext.tblInvoiceCompanies.SingleOrDefault( x => x.Id == obj.Id); updateing.Active = obj.Active; updateing.OrderNr1 = obj.Order[0]; updateing.OrderNr2 = obj.Order[1]; updateing.OrderNr3 = obj.Order[2]; updateing.OrderNr4 = obj.Order[3]; updateing.OrderNr5 = obj.Order[4]; updateing.OrderNr6 = obj.Order[5]; updateing.OrderNr7 = obj.Order[6]; updateing.OrderNr8 = obj.Order[7]; updateing.OrderNr9 = obj.Order[8]; updateing.OrderNr10 = obj.Order[9]; updateing.OrderNr11 = obj.Order[10]; updateing.OrderNr12 = obj.Order[11]; updateing.OrderNr13 = obj.Order[12]; updateing.OrderNr14 = obj.Order[13]; updateing.OrderNr15 = obj.Order[14]; updateing.OrderNr16 = obj.Order[15]; updateing.OrderNr17 = obj.Order[16]; updateing.OrderNr18 = obj.Order[17]; updateing.OrderNr19 = obj.Order[18]; updateing.OrderNr20 = obj.Order[19]; dbContext.SubmitChanges(); } }
public void Add(Interface.IinvoiceCompany obj) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newInvoice = new tblInvoiceCompany() { Active = obj.Active, Id = obj.Id, OrderNr1 = obj.Order[0], OrderNr2 = obj.Order[1], OrderNr3 = obj.Order[2], OrderNr4 = obj.Order[3], OrderNr5 = obj.Order[4], OrderNr6 = obj.Order[5], OrderNr7 = obj.Order[6], OrderNr8 = obj.Order[7], OrderNr9 = obj.Order[8], OrderNr10 = obj.Order[9], OrderNr11 = obj.Order[10], OrderNr12 = obj.Order[11], OrderNr13 = obj.Order[12], OrderNr14 = obj.Order[13], OrderNr15 = obj.Order[14], OrderNr16 = obj.Order[15], OrderNr17 = obj.Order[16], OrderNr18 = obj.Order[17], OrderNr19 = obj.Order[18], OrderNr20 = obj.Order[19], }; dbContext.tblInvoiceCompanies.InsertOnSubmit(newInvoice); dbContext.SubmitChanges(); } }