public string DownloadMasterCustomers(DateTime dtCreated)
{
UploadManager CurUploadManager = new UploadManager();
MasterCustomerCollection customerCollection = CurUploadManager.DownloadMasterCustomers(dtCreated);
string json = JsonConvert.SerializeObject(customerCollection);
return(json);
}
public MasterCustomerCollection GetAllCustomersInColl(DateTime dtCreated)
{
MasterCustomerCollection customers = null;
if (this.TryConnection())
{
DatabaseParameters parameters = new DatabaseParameters();
string str = dtCreated.Year.ToString() + "-" + dtCreated.Month.ToString() + "-" + dtCreated.Day.ToString() + " 00:00:00";
base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.MasterCustomer.ActualTableName);
base.CurSQLFactory.SQL = base.CurSQLFactory.SQL + " WHERE dt_created >= CAST('" + str + "' AS DATETIME)";
DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL);
if (table == null)
{
return(customers);
}
customers = new MasterCustomerCollection();
foreach (DataRow row in table.Rows)
{
MasterCustomer customer = new MasterCustomer(row[this.DataStructrure.Tables.MasterCustomer.CustomerID.ActualFieldName].ToString())
{
cust_name1 = row[this.DataStructrure.Tables.MasterCustomer.Name1.ActualFieldName].ToString(),
cust_name2 = row[this.DataStructrure.Tables.MasterCustomer.Name2.ActualFieldName].ToString(),
cust_city = row[this.DataStructrure.Tables.MasterCustomer.City.ActualFieldName].ToString(),
cust_country = row[this.DataStructrure.Tables.MasterCustomer.Country.ActualFieldName].ToString(),
cust_currency = row[this.DataStructrure.Tables.MasterCustomer.Currency.ActualFieldName].ToString(),
cust_distrchannel = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(),
cust_division = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(),
cust_fax = row[this.DataStructrure.Tables.MasterCustomer.Fax.ActualFieldName].ToString(),
cust_incoterms = row[this.DataStructrure.Tables.MasterCustomer.Incoterms.ActualFieldName].ToString(),
cust_incoterms2 = row[this.DataStructrure.Tables.MasterCustomer.Incoterms2.ActualFieldName].ToString(),
cust_peymentterms = row[this.DataStructrure.Tables.MasterCustomer.PaymentTerms.ActualFieldName].ToString(),
cust_po = row[this.DataStructrure.Tables.MasterCustomer.PO.ActualFieldName].ToString(),
cust_region = row[this.DataStructrure.Tables.MasterCustomer.Region.ActualFieldName].ToString(),
cust_salesorg = row[this.DataStructrure.Tables.MasterCustomer.SalesOrg.ActualFieldName].ToString(),
cust_street = row[this.DataStructrure.Tables.MasterCustomer.Street.ActualFieldName].ToString(),
cust_tel1 = row[this.DataStructrure.Tables.MasterCustomer.Tel.ActualFieldName].ToString(),
dt_created = row[this.DataStructrure.Tables.MasterCustomer.dtCreated.ActualFieldName].ToString()
};
customers.Add(customer);
}
}
return(customers);
}
public string DownloadMasterDataFromSQL(DateTime dtCreated, string employeeID)
{
string json = "";
this.GeneralLogManager = new LogManager(tmp_config);
try
{
UploadManager CurUploadManager = new UploadManager();
MasterCauseCollection CausesCollection = CurUploadManager.DownloadMasterCauses(dtCreated);
if (CausesCollection != null)
{
json += "MasterCauses " + JsonConvert.SerializeObject(CausesCollection);
}
MasterDamageCollection DamagesCollection = CurUploadManager.DownloadMasterDamages(dtCreated);
if (DamagesCollection != null)
{
json += "MasterDamages" + JsonConvert.SerializeObject(DamagesCollection);
}
MasterCustomerCollection customerCollection = CurUploadManager.DownloadMasterCustomers(dtCreated);
if (customerCollection != null)
{
json += "MasterCustomers" + JsonConvert.SerializeObject(customerCollection);
}
MasterEquipmentCollection equipmentCollection = CurUploadManager.DownloadMasterEquipment(dtCreated);
if (equipmentCollection != null)
{
json += "MasterEquipment" + JsonConvert.SerializeObject(equipmentCollection);
}
MasterLookUpCollection lookUpCollection = CurUploadManager.DownloadMasterLookUp(dtCreated);
if (lookUpCollection != null)
{
json += "MasterLookUp" + JsonConvert.SerializeObject(lookUpCollection);
}
ApplicationUserCollection UserCollection = CurUploadManager.DownloadMasterUsersInColl(dtCreated);
if (UserCollection != null)
{
json += "MasterUsers" + JsonConvert.SerializeObject(UserCollection);
}
MasterQuickNotesCollection quickNotesCollection = CurUploadManager.DownloadQuickNotes();
if (quickNotesCollection != null)
{
json += "MasterQuickNotes" + JsonConvert.SerializeObject(quickNotesCollection);
}
MasterCheckListTypeCollection masterCheckListTypeColleaction = CurUploadManager.DownloadMasterCheckListType();
if (masterCheckListTypeColleaction != null)
{
json += "MasterCheckListType" + JsonConvert.SerializeObject(masterCheckListTypeColleaction);
}
MasterCheckListInCollection masterCheckListCollection = CurUploadManager.DownloadMasterCheckList();
if (masterCheckListCollection != null)
{
json += "MasterCheckList" + JsonConvert.SerializeObject(masterCheckListCollection);
}
MasterCheckListRelationCollection checkListRelationCollection = CurUploadManager.DownloadMasterCheckListRelation();
if (checkListRelationCollection != null)
{
json += "MasterCheckListRelation" + JsonConvert.SerializeObject(checkListRelationCollection);
}
if (json.Equals(""))
{
this.GeneralLogManager.LogAction("DownloadMasterDataFromSQL", employeeID, "Result :: null ");
}
else
{
this.GeneralLogManager.LogAction("DownloadMasterDataFromSQL", employeeID, "Result :: " + json);
}
}
catch (Exception e)
{
string ErrorID = SwissArmy.UniqueID();
this.CurLogManager.LogError(ErrorID, "DownloadMasterDataFromSQL: Error :: " + e.ToString(), employeeID);
json = "Error: " + e.ToString();
}
return(json);
}
