private static void AddParms(ref DBAccess db, Dokumenter d)
{
var with_1 = d;
db.AddBit("Aktiv", with_1.Aktiv);
db.AddDateTime("Dato", with_1.Dato);
db.AddDateTime("ExpireDate", with_1.ExpireDate);
db.AddNVarChar("Name", with_1.Name, 250);
db.AddNVarChar("Mime", with_1.Mime, 100);
db.AddNVarChar("Beskrivelse", with_1.Beskrivelse, -1);
db.AddInt("Type", with_1.Type);
db.AddInt("Category", with_1.Category);
db.AddInt("Owner", with_1.Owner);
db.AddInt("MedArbGrpID", with_1.MedArbGrpID);
db.AddNVarChar("Filename", with_1.Filename, 250);
db.AddNVarChar("Ext", with_1.Ext, 50);
db.AddInt("Size", with_1.Size);
db.AddInt("Width", with_1.Width);
db.AddInt("Height", with_1.Height);
db.AddNVarChar("UserID", with_1.UserID, 50);
db.AddBlob("Blob", d.Blob);
db.AddNVarChar("Clob", with_1.Clob, -1);
AddParmsStandard(db, d);
}
private static void AddParms(ref DBAccess db, Campaign rec)
{
db.AddInt("Status", (System.Int32)rec.Status);
db.AddBit("Active", rec.Active);
db.AddNVarChar("CampaignNo", rec.CampaignNo, 50);
db.AddNVarChar("Name", rec.Name, 255);
db.AddNVarChar("Description", rec.Description);
db.AddDateTime("StartDate", rec.StartDate);
db.AddDateTime("EndDate", rec.EndDate);
db.AddMoney("ExpectedImediateSale", (double)rec.ExpectedImediateSale);
db.AddMoney("ExpectedFollowUpSale", (double)rec.ExpectedFollowUpSale);
AddParmsStandard(db, rec);
}
private static void AddParms(ref DBAccess db, InvoiceHeader c)
{
db.AddInt("Status", (System.Int32)c.Status);
db.AddInt("CompanyID", c.CompanyID);
db.AddDateTime("InvoiceDate", c.InvoiceDate);
db.AddInt("PaymentID", c.PaymentID);
db.AddNVarChar("PaymentTerms", c.PaymentTerms, 50);
db.AddDateTime("PaymentDate", c.PaymentDate);
db.AddInt("ResponsibleID", c.ResponsibleID);
db.AddNVarChar("ResponsibleName", c.ResponsibleName, 50);
db.AddGuid("ResponsibleGUID", c.ResponsibleGUID);
db.AddNVarChar("ContactName", c.ContactName, 50);
db.AddNVarChar("ContactEmail", c.ContactEmail, 250);
db.AddNVarChar("Notes", c.Notes, -1);
db.AddNVarChar("InvoiceEANno", c.InvoiceEANno, 15);
db.AddNVarChar("InvoiceName", c.InvoiceName, 100);
db.AddNVarChar("InvoiceAddress1", c.InvoiceAddress1, 100);
db.AddNVarChar("InvoiceAddress2", c.InvoiceAddress2, 100);
db.AddNVarChar("InvoiceZipCode", c.InvoiceZipCode, 50);
db.AddNVarChar("InvoiceCity", c.InvoiceCity, 50);
db.AddNVarChar("InvoiceState", c.InvoiceState, 50);
db.AddNVarChar("InvoiceCountry", c.InvoiceCountry, 50);
db.AddNVarChar("InvoiceAtt", c.InvoiceAtt, 50);
db.AddNVarChar("InvoiceRef", c.InvoiceRef, 50);
db.AddNVarChar("DeleveryEANno", c.DeleveryEANno, 15);
db.AddNVarChar("DeleveryName", c.DeleveryName, 100);
db.AddNVarChar("DeleveryAddress1", c.DeleveryAddress1, 100);
db.AddNVarChar("DeleveryAddress2", c.DeleveryAddress2, 100);
db.AddNVarChar("DeleveryZipCode", c.DeleveryZipCode, 50);
db.AddNVarChar("DeleveryCity", c.DeleveryCity, 50);
db.AddNVarChar("DeleveryState", c.DeleveryState, 50);
db.AddNVarChar("DeleveryCountry", c.DeleveryCountry, 50);
db.AddNVarChar("DeleveryAtt", c.DeleveryAtt, 50);
db.AddNVarChar("DeleveryRef", c.DeleveryRef, 50);
db.AddInt("InvoiceLines", c.InvoiceLines);
db.AddInt("InvoiceLineItems", c.InvoiceLineItems);
db.AddDecimal("InvoiceLinesTotal", c.InvoiceLinesTotal);
db.AddDecimal("InvoiceTransport", c.InvoiceTransport);
db.AddDecimal("InvoiceTotal", c.InvoiceTotal);
db.AddDecimal("InvoiceVAT", c.InvoiceVAT);
db.AddDecimal("InvoiceTotalInclVAT", c.InvoiceTotalInclVAT);
db.AddBit("Paid", c.Paid);
db.AddDateTime("PaidDate", c.PaidDate);
db.AddNVarChar("OrderNo", c.OrderNo, 50);
db.AddNVarChar("YourRef", c.YourRef, 50);
db.AddInt("CreditnoteID", c.CreditnoteID);
db.AddBoolean("VATfree", c.VATfree);
db.AddBoolean("EANInvoice", c.EANInvoice);
db.AddInt("IncassoID", c.IncassoID);
AddParmsStandard(db, c);
}