private static void AddParms(ref DBAccess db, CampaignCompany rec)
{
var with_1 = rec;
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("CampaignID", with_1.CampaignID);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddGuid("ResponsibleID", with_1.ResponsibleID);
db.AddNVarChar("ResponsibleName", with_1.ResponsibleName, 50);
db.AddNVarChar("ResponsibleEmail", with_1.ResponsibleEmail, 255);
db.AddNVarChar("ContactPerson", with_1.ContactPerson, 50);
db.AddBoolean("ContactedByPhone", with_1.ContactedByPhone);
db.AddBoolean("MeetingHeld", with_1.MeetingHeld);
db.AddBoolean("CampaignSale", with_1.CampaignSale);
db.AddMoney("CampaignSaleAmount", (double)with_1.CampaignSaleAmount);
db.AddBoolean("ExpectedSale", with_1.ExpectedSale);
db.AddMoney("ExpectedSaleAmount", (double)with_1.ExpectedSaleAmount);
db.AddNVarChar("Notes", with_1.Notes, -1);
AddParmsStandard(db, rec);
}
private static void AddParms(ref DBAccess db, PurchaseOrder rec)
{
var with_1 = rec;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddNVarChar("OrderCreatedBy", with_1.OrderCreatedBy, 50);
db.AddDateTime("PurchaseDate", with_1.PurchaseDate);
db.AddInt("SupplierID", with_1.SupplierID);
db.AddNVarChar("SupplierEmail", with_1.SupplierEmail, 250);
db.AddNVarChar("PurchaseOrderEmailCopy", with_1.PurchaseOrderEmailCopy, 250);
db.AddInt("PaymentID", with_1.PaymentID);
db.AddInt("FreightID", with_1.FreightID);
db.AddInt("CurrencyID", with_1.CurrencyID);
db.AddMoney("FreightPrice", (double)with_1.FreightPrice);
db.AddMoney("TotalPurchaseOrder", (double)with_1.TotalPurchaseOrder);
db.AddNVarChar("ShipToEANno", with_1.ShipToEANno, 15);
db.AddNVarChar("ShipToName", with_1.ShipToName, 100);
db.AddNVarChar("ShipToAddress1", with_1.ShipToAddress1, 100);
db.AddNVarChar("ShipToAddress2", with_1.ShipToAddress2, 100);
db.AddNVarChar("ShipToZipCode", with_1.ShipToZipCode, 50);
db.AddNVarChar("ShipToCity", with_1.ShipToCity, 50);
db.AddNVarChar("ShipToState", with_1.ShipToState, 50);
db.AddNVarChar("ShipToCountry", with_1.ShipToCountry, 50);
db.AddNVarChar("ShipToAtt", with_1.ShipToAtt, 50);
db.AddNVarChar("ShipToRef", with_1.ShipToRef, 50);
AddParmsStandard(db, rec);
}
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, PurchaseOrderItem rec)
{
var with_1 = rec;
db.AddInt("PurchaseOrderID", with_1.PurchaseOrderID);
db.AddInt("Pos", with_1.Pos);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("ItemID", with_1.ItemID);
db.AddNVarChar("ItemName", with_1.ItemName, 100);
db.AddNVarChar("SupplierItemID", with_1.SupplierItemID, 50);
db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 250);
db.AddDecimal("Quantity", with_1.Quantity);
db.AddMoney("ItemPrice", (double)with_1.ItemPrice);
db.AddMoney("LinePrice", (double)with_1.LinePrice);
db.AddDateTime("ExpectedReceiptDate", with_1.ExpectedReceiptDate);
db.AddDateTime("ReceiptDate", with_1.ReceiptDate);
AddParmsStandard(db, rec);
}
private static void AddParms(ref DBAccess db, AED_Service c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("AED_FK", with_1.AED_FK);
db.AddInt("ServiceType", with_1.ServiceType);
db.AddBoolean("ServiceActive", with_1.ServiceActive);
db.AddDateTime("ServiceDueDate", with_1.ServiceDueDate);
db.AddDateTime("ServiceVisitedDate", with_1.ServiceVisitedDate);
db.AddInt("ServiceConsultantID", with_1.ServiceConsultantID);
db.AddNVarChar("ServiceConsultant", with_1.ServiceConsultant, 50);
db.AddMoney("ServicePrice", with_1.ServicePrice);
//
AddParmsStandard(db, c);
}