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