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); }