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