public static int PumpAllPayrollItems(string Company)
{
Console.WriteLine("PayrollItemWage for Company " + Company);
string sql = "SELECT * FROM PayrollItemWage";
List <QBPayrollItem> payItems = new ODBCReaderToModel <QBPayrollItem>().CreateList(sql, Company);
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
dg.RunCommand("DELETE FROM PayrollItem WHERE QBFile='" + Company + "'");
}
if (payItems.Count > 0)
{
foreach (var QBpayItem in payItems)
{
if (QBpayItem.Name.Contains("00") || QBpayItem.Name.Contains("01") || QBpayItem.Name.Contains("02"))
{
PayrollItem payItem = QBpayItem.ConvertTo <PayrollItem>();
Console.WriteLine("PayrollItem " + payItem.Name);
payItem.QBFile = Company;
payItem.Branch = payItem.Name.Substring(0, 2);
new ModelToSQL <PayrollItem>().WriteInsertSQL("PayrollItem", payItem, "payItemID", CommonProcs.WCompanyConnStr);
}
}
}
return(payItems.Count);
}
public int PumpPayrollItems(string Company)
{
string sql = "SELECT * FROM PayrollItemWage WHERE TimeModified > " + CommonProcs.TimeStampString(DateTime.Now.AddDays(-1));
UpdateStatusBar("Opening Quickbooks", 10);
List <QBPayrollItem> payItems = new ODBCReaderToModel <QBPayrollItem>().CreateList(sql, Company);
if (payItems.Count > 0)
{
foreach (var QBpayItem in payItems)
{
if (QBpayItem.Name.Contains("00") || QBpayItem.Name.Contains("01") || QBpayItem.Name.Contains("02"))
{
UpdateStatusBar("Adding " + QBpayItem.Name, 1);
PayrollItem payItem = QBpayItem.ConvertTo <PayrollItem>();
payItem.QBFile = Company;
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
payItem.payItemID = dg.GetScalarInteger("SELECT payItemID FROM PayrollItem WHERE ListID='" + payItem.ListID + "' AND QBFile='" + Company + "'");
}
new ModelToSQL <PayrollItem>().WriteUpdateToSQL("PayrollItem", payItem, "payItemID", CommonProcs.WCompanyConnStr);
}
}
}
UpdateStatusBar("Done", progBar.Maximum);
return(payItems.Count);
}
