public int PumpCustomers(string Company)
{
string sql = "SELECT * FROM Customer WHERE TimeModified > " + CommonProcs.TimeStampString(DateTime.Now.AddDays(-1));
UpdateStatusBar("Opening Quickbooks", 10);
List <QBCustomer> customers = new ODBCReaderToModel <QBCustomer>().CreateList(sql, Company);
if (customers.Count > 0)
{
progBar.Maximum = customers.Count;
foreach (var QBcust in customers)
{
UpdateStatusBar("Adding " + QBcust.Name, 1);
if (QBcust.Name.Contains("00") || QBcust.Name.Contains("01") || QBcust.Name.Contains("02"))
{
Customer cust = QBcust.ConvertTo <Customer>();
cust.QBFile = Company;
cust.Branch = cust.Name.Substring(0, 2);
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
cust.CustomerID = dg.GetScalarInteger("SELECT CustomerID FROM Customer WHERE ListID='" + cust.ListID + "' AND QBFile='" + Company + "'");
}
new ModelToSQL <Customer>().WriteUpdateToSQL("Customer", cust, "CustomerID", CommonProcs.WCompanyConnStr);
}
}
}
UpdateStatusBar("Done", progBar.Maximum);
return(customers.Count);
}
public static int PumpAllCustomers(string Company)
{
Console.WriteLine("Customers for Company " + Company);
string sql = "SELECT * FROM Customer";
List <QBCustomer> customers = new ODBCReaderToModel <QBCustomer>().CreateList(sql, Company);
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
dg.RunCommand("DELETE FROM Customer WHERE QBFile='" + Company + "'");
}
if (customers.Count > 0)
{
foreach (var QBcust in customers)
{
if (QBcust.Name.ToUpper().Contains("DO NOT USE"))
{
continue;
}
if (QBcust.ParentRefListID != null)
{
Customer cust = QBcust.ConvertTo <Customer>();
Console.WriteLine("Customer " + cust.Name);
cust.QBFile = Company;
cust.Branch = cust.Name.Substring(0, 2);
new ModelToSQL <Customer>().WriteInsertSQL("Customer", cust, "CustomerID", CommonProcs.WCompanyConnStr);
}
else
{
Customer cust = QBcust.ConvertTo <Customer>();
Console.WriteLine("Customer " + cust.Name);
cust.QBFile = Company;
cust.isParent = true;
new ModelToSQL <Customer>().WriteInsertSQL("Customer", cust, "CustomerID", CommonProcs.WCompanyConnStr);
}
}
}
return(customers.Count);
}
