public static List <Repairs> GetRepairHistory(int repairID) { string q = "select updateDate, updatenote from core.RepairUpdateNote " + " where repairID = " + repairID.ToString() + " order by UpdateDate desc"; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); List <Repairs> r = new List <Repairs>(); if (dt.Rows.Count > 0) { DataRow d = dt.Rows[0]; if (d[0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { DateTime logged = new DateTime(); if (dr[0] != DBNull.Value) { logged = Convert.ToDateTime(dr[0]); } r.Add(new Repairs { RaisedDate = logged, RaisedDatestr = Controls.DateString(logged), UpdateNote = dr[1].ToString() }); } } } return(r); }
public static PurchaseOrders GetPurchaseOrderByID(int ID) { string q = "Select * from core.PurchaseOrders where ID = " + ID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); PurchaseOrders po = new PurchaseOrders(); if (dt.Rows.Count > 0) { DataRow d = dt.Rows[0]; if (d[0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { PurchaseOrders p = new PurchaseOrders { ID = Convert.ToInt32(dr[0]), }; } } } return(po); }
public static List <Properties> GetAllOwnedProperties(int CustomerID) { string q = "select Core.Units.FlatOrApt, Core.Units.UnitNumber, Core.Units.Address1, Core.Units.Address2, Core.Units.Address3, " + "Core.Units.Address4, Core.Units.Address5, Core.Units.ID FROM CORE.Units inner join core.PropertyOwnership on core.PropertyOwnership.UnitID = " + "core.Units.ID where core.PropertyOwnership.OwnerID = " + CustomerID.ToString(); List <Properties> rList = new List <Properties>(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); foreach (DataRow dr in dt.Rows) { int id = 0; if (dr[7] != DBNull.Value) { id = Convert.ToInt32(dr[7]); } string Add1 = SetAddress1(dr[0].ToString(), dr[1].ToString(), dr[2].ToString()); rList.Add(new Properties(PropertyTypes.Unit) { ID = id, Address1 = Add1, Address2 = dr[3].ToString(), Address3 = dr[4].ToString(), Address4 = dr[5].ToString(), Address5 = dr[6].ToString(), FullAddress = SetAddressString(Add1, dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString()) }); } return(rList); }
public static Contractors ContractorDetailsByPO(int PONumber) { string q = " select core.Contractors.Name from core.Contractors " + "inner join core.PurchaseOrders on core.Contractors.id = core.PurchaseOrders.SupplierID " + "where core.PurchaseOrders.ID = " + PONumber.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); Contractors returnC = new Contractors(); returnC.Name = ""; if (dt.Rows.Count > 0) { if (dt.Rows[0][0] != DBNull.Value || dt.Rows[0][0].ToString() != "Error") { Contractors c = new Contractors { Name = dt.Rows[0][0].ToString() }; returnC = c; } } return(returnC); }
public static List <Properties> GetAllUnitsowners(int UnitID) { string q = "select Core.leaseholders.title, Core.leaseholders.firstname," + "core.leaseholders.surname, Core.leaseholders.Address_1, Core.leaseholders.Address_2, " + "Core.leaseholders.Address_3, " + "Core.leaseholders.Address_4, Core.leaseholders.Address_5, Core.leaseholders.ID " + "FROM CORE.leaseholders " + "inner join core.PropertyOwnership on core.Leaseholders.ID = core.PropertyOwnership.OwnerID " + "where core.PropertyOwnership.UnitID = " + UnitID.ToString() + " and core.propertyownership.currentowner = 1"; List <Properties> rList = new List <Properties>(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { int id = 0; if (dr[8] != DBNull.Value) { id = Convert.ToInt32(dr[8]); } string Add1 = SetAddress1(dr[0].ToString(), dr[1].ToString(), dr[2].ToString()); rList.Add(new Properties(PropertyTypes.Owner) { ID = id, Address1 = Add1, FullAddress = Add1 }); } } return(rList); }
public static List <OwnerNotesProperties> GetAllOwnerNotes(int unitID, int customerID) { List <OwnerNotesProperties> rlist = new List <OwnerNotesProperties>(); string q = "select core.OwnerNotes.AddedDate, core.OwnerNotes.userID, core.OwnerNotes.details " + "from core.OwnerNotes where unitID = " + unitID.ToString() + "and OwnerID = " + customerID.ToString() + "and PortalViewable = 1 order by AddedDate desc"; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); foreach (DataRow dr in dt.Rows) { rlist.Add(new OwnerNotesProperties { dateAdded = Convert.ToDateTime(dr[0]), addedby = dr[1].ToString(), details = dr[2].ToString() }); } if (rlist.Count == 0) { rlist.Add(new OwnerNotesProperties { details = "No history items exist for this property." }); } return(rlist); }
public static double GetApportionment(int budgetID, string scheduleName, int PropertyID) { string q = "Select Apportionment from core.ServiceChargeBudgetApportionments where " + "budgetID = " + budgetID.ToString() + " and ScheduleName = '" + scheduleName + "' and " + " unitID = " + PropertyID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); double r = 0; foreach (DataRow dr in dt.Rows) { if (dr[0].ToString() != "Error") { if (dr[0] != DBNull.Value) { string h = dr[0].ToString(); r = Convert.ToDouble(dr[0]); } } } return(r); }
public static List <Properties> GetAllEstates() { string q = "select * FROM CORE.Estates where _statusID = 1"; List <Properties> rList = new List <Properties>(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); foreach (DataRow dr in dt.Rows) { int id = 0; if (dr[0] != DBNull.Value) { id = Convert.ToInt32(dr[0]); } string Add1 = SetAddress1(dr[0].ToString(), dr[1].ToString(), dr[2].ToString()); rList.Add(new Properties(PropertyTypes.Estate) { ID = id, Address1 = dr[1].ToString(), Address2 = dr[2].ToString(), Address3 = dr[3].ToString(), Address4 = dr[4].ToString(), Address5 = dr[5].ToString(), FullAddress = SetAddressString(dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString()) }); } return(rList); }
//from prop level private static AccountDetails.ContactPreferences SetContactPreferences(int CustomerID, int PropertyID) { string q = "Select Postonly, emailonly, PostAndEmail from core.LeaseholderContactPreferences where CustomerID = " + CustomerID.ToString() + " and PropertyID = " + PropertyID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); AccountDetails.ContactPreferences ad = new AccountDetails.ContactPreferences(); ad = AccountDetails.ContactPreferences.postandemail; //sets default //set first to compare if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (dr[0] != DBNull.Value) { ad = AccountDetails.ContactPreferences.Post; } if (dr[1] != DBNull.Value) { ad = AccountDetails.ContactPreferences.email; } if (dr[2] != DBNull.Value) { ad = AccountDetails.ContactPreferences.postandemail; } } return(ad); }
public static List <BankAccount> BankAccountListByEstate(int EstateID) { List <BankAccount> r = new List <BankAccount>(); string q = "select distinct core.EstateBankAccounts.id, core.EstateBankAccounts.AccountName, core.EstateBankAccounts.AccountNumber, core.EstateBankAccounts.SortCode from core.EstateBankAccounts " + "inner join core.EstateBudgetBankAccounts on core.EstateBankAccounts.id = core.EstateBudgetBankAccounts.AccountID " + "inner join core.ServiceChargeBudgets on core.EstateBudgetBankAccounts.BudgetId = core.ServiceChargeBudgets.ID " + "where core.ServiceChargeBudgets.EstateID = " + EstateID.ToString(); dbConn.DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { int id = 0; int.TryParse(dr[0].ToString(), out id); r.Add(new BankAccount { ID = id, Name = dr[1].ToString(), AccountNumber = dr[2].ToString(), SortCode = dr[3].ToString() }); } } return(r); }
public static bool IsPasswordCorrect(string password, int CustomerID, int usertype) { bool r = false; try { List <string> ColNames = new List <string>(); ColNames.Add("core.CustomerPortal.PWord"); string q = "Select pword, salt from core.customerportal where customerID = " + CustomerID.ToString() + " and usertype = " + usertype.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); string pword = ""; string salt = ""; if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { pword = dt.Rows[0][0].ToString(); salt = dt.Rows[0][0].ToString(); } if (pword == BCrypt.Net.BCrypt.HashPassword(password, salt)) { r = true; } } catch { } return(r); }
public static void InsertReportUpdateFailure(int RepairID, int CustomerID) { List <string> c = new List <string>() { "repairID", "customerID", "_date" }; List <string> p = new List <string>() { "@repairID", "@customerID", "@_date" }; List <object> o = new List <object>() { RepairID, CustomerID, DateTime.Now }; DBConnectionObject db = GlobalVariables.GetConnection(); db.Connection.InsertCommandCurrent("core.RepairUpdateFailures", c, p, o); }
public static List <ServiceCharges> BudgetListByEstate(int EstateID) { string q = "select id, budgetname from core.ServiceChargeBudgets " + "where EstateID = " + EstateID.ToString() + " and _status = 'Completed' and not fundtypeid = 4 "; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); List <ServiceCharges> r = new List <ServiceCharges>(); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { int Bid = 0; int.TryParse(dr[0].ToString(), out Bid); r.Add(new ServiceCharges { BudgetID = Bid, BudgetName = dr[1].ToString() }); } } return(r); }
public void GetVisit(int id) { Visit = new AttendanceVisits.AttendanceVisits(); Visit = AttendanceVisits.AttendanceVisitsMethods.GetAttendanceObj(id, GlobalVariables.GetConnection()); // new AttendanceVisits.ImageParams { width = 300, height = 300 }); EstateName = EstatesDLL.EstateMethods.GetEstateNameByID(Visit.EstateID, GlobalVariables.GetConnection()); }
public static void Remove(int customerID, int RepairID) { string q = "delete from core.repairupdates where customerID = " + customerID.ToString() + " and repairID = " + RepairID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); db.Connection.ExecuteCommand(q); }
public static void AddNew(int customerId, int repairID) { string q = "insert into core.RepairUpdates values (" + customerId.ToString() + ", " + repairID.ToString() + ")"; DBConnectionObject db = GlobalVariables.GetConnection(); db.Connection.ExecuteCommand(q); }
public static List <ServiceCharges> ReplaceTransactionDateWithPaidDate(List <ServiceCharges> TransList) { //replaces the transaction date with the paid date for transactions that are payments //to reduce db calls loop creats the query string string PaidDateStr = "select transactionID, paiddate from core.paymentdata where transactionID = "; int c = 0; for (int i = 0; i <= TransList.Count - 1; i++) { if (TransList[i].TransType == "Payment") { if (c == 0) { PaidDateStr += TransList[i].ID.ToString(); } else { PaidDateStr += " or transactionid = " + TransList[i].ID.ToString(); } c += 1; } } DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dataTable = db.Connection.GetDataTable(PaidDateStr); if (dataTable.Rows.Count > 0 && dataTable.Rows[0][0].ToString() != "Error") { foreach (DataRow row in dataTable.Rows) { //get trans ID int id = Convert.ToInt32(row[0]); foreach (ServiceCharges tr in TransList) { if (tr.ID == id) { DateTime _date = Convert.ToDateTime(row[1]); tr.TransDate = _date; tr.TransDatestr = Controls.DateString(_date); break; } } } } return(TransList); }
//account details where property is selected public static AccountDetails OwnerAccountDetails(int CustomerID, int PropertyID) { string q = "Select * from core.LeaseholderContactPreferences " + "where core.LeaseholderContactPreferences.CustomerID = " + CustomerID.ToString() + " and UnitID = " + PropertyID.ToString(); AccountDetails r = new AccountDetails(); List <AccountDetails> rList = new List <AccountDetails>(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); foreach (DataRow dr in dt.Rows) { rList.Add(new AccountDetails { ContactAdd1 = dr[5].ToString(), ContactAdd2 = dr[6].ToString(), ContactAdd3 = dr[7].ToString(), ContactAdd4 = dr[8].ToString(), ContactAdd5 = dr[9].ToString(), phoneNumber = dr[11].ToString() }); if (dr[10] != DBNull.Value) { rList[0].Email = dr[10].ToString(); } if (dr[1] != DBNull.Value) { rList[0].PostOnly = Convert.ToBoolean(dr[1]); if (rList[0].PostOnly == true) { rList[0].ContactPref = AccountDetails.ContactPreferences.Post; } } if (dr[2] != DBNull.Value) { rList[0].EmailOnly = Convert.ToBoolean(dr[2]); if (rList[0].EmailOnly == true) { rList[0].ContactPref = AccountDetails.ContactPreferences.email; } } if (dr[3] != DBNull.Value) { rList[0].PostAndEmail = Convert.ToBoolean(dr[3]); if (rList[0].PostAndEmail == true) { rList[0].ContactPref = AccountDetails.ContactPreferences.postandemail; } } } if (rList.Count != 0) { r = rList[0]; } return(r); }
public static Repairs GetOutstandingRepairs(int EstateID) { string q = "select core.Repairs.ID, core.Repairs.ReportID, core.Repairs.RepairTitle, " + "core.Repairs.RepairDetails, core.Repairs.RaisedDate, " + "core.Repairs.TargetCompletionDate, core.RepairStatus.RepairStatus " + "from core.Repairs inner join core.RepairStatus on core.Repairs.RepairStatusID " + "= core.RepairStatus.id where core.repairs.EstateID = " + EstateID.ToString() + " and core.Repairs.RepairStatusId = 1 " + " order by core.repairs.raisedDate Asc"; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); Repairs repairs = new Repairs(); repairs.AllRepairs = new List <Repairs>(); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; if (row[0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { //raised date DateTime raised = new DateTime(); if (dr[4] != DBNull.Value) { raised = Convert.ToDateTime(dr[4]); } //Target Completion DateTime target = new DateTime(); if (dr[5] != DBNull.Value) { target = Convert.ToDateTime(dr[5]); } repairs.AllRepairs.Add(new Repairs { ID = Convert.ToInt32(dr[0]), Title = dr[2].ToString(), Details = dr[3].ToString(), RaisedDate = raised, RaisedDatestr = Controls.DateString(raised), TargetDate = target, TargetDatestr = Controls.DateString(target), Status = dr[6].ToString() }); } } } return(repairs); }
public static PortalLogins Login(object username, string password) { PortalLogins r = new PortalLogins(); try { string pcheck = ""; string salt = ""; int UserID = 0; int UserType = 0; //check email and password string q = "select PWord, salt, customerid, UserType from core.customerportal where username = '******'"; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { pcheck = dt.Rows[0][0].ToString(); salt = dt.Rows[0][1].ToString(); int.TryParse(dt.Rows[0][2].ToString(), out UserID); int.TryParse(dt.Rows[0][3].ToString(), out UserType); } if (pcheck == BCrypt.Net.BCrypt.HashPassword(password, salt)) { r.LoginVerified = true; r.UserType = UserType; r.CustomerID = UserID; //user id 1 = customer //user id 2 = NEM User string nameQ = ""; //get name if (UserType == 1) { nameQ = "select concat(title, ' ', firstname, ' ', surname) from core.Leaseholders " + " where id = " + r.CustomerID.ToString(); } else if (UserType == 2) { nameQ = "select concat(firstname, ' ', surname) from users.users where id = " + r.CustomerID.ToString(); } DataTable namedb = db.Connection.GetDataTable(nameQ); if (namedb.Rows.Count > 0 && namedb.Rows[0][0].ToString() != "Error") { r.customerName = namedb.Rows[0][0].ToString(); } } } catch { } return(r); }
public static int NumberOfOwnedProperties(int CustomerID) { string q = "select count(unitID) from core.PropertyOwnership where OwnerID = " + CustomerID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); int i = 0; if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { int.TryParse(dt.Rows[0][0].ToString(), out i); } return(i); }
public static Insurance GetInsuranceByPolicyID(int PolicyID) { string q = "select core.insurances.policyNumber, core.insurances.PolicyName, core.insurances.StartDate, " + "core.insurances.EndDate, core.insurances.ClaimInstructions, core.insurances.DocInstanceID, " + "core.insurances.premium, core.contractors.Name from core.insurances " + "inner join core.Contractors on core.Insurances.BrokerSUpplierID = core.Contractors.id " + "where core.Insurances.id = " + PolicyID.ToString(); Insurance r = new Insurance(); dbConn.DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { //start date DateTime st = new DateTime(); if (dr[2] != DBNull.Value) { st = Convert.ToDateTime(dr[2]); } //enddate DateTime en = new DateTime(); if (dr[3] != DBNull.Value) { en = Convert.ToDateTime(dr[3]); } //long.TryParse(dr[5].ToString(), out long doc); long doc = long.Parse(dr[5].ToString()); double p = Convert.ToDouble(dr[6]); r.PolicyID = PolicyID; r.PolicyNumber = dr[0].ToString(); r.PolicyName = dr[1].ToString(); r.StartDate = st; r.EndDate = en; r.ClaimInstructions = dr[4].ToString(); r.DocInstanceID = doc; r.PremiumAmount = p; r.BrokerName = dr[7].ToString(); } } return(r); }
public static void InsertNewUsage(int ActivityID, int CustomerID, string MiscData = null) { try { //0 =log data if (GlobalVariables.LogUsage == 0) { //int customerID = 0; //if (ActivityID != 3) //{ // customerID = CustomerID; //} List <string> c = new List <string>() { "CustomerID", "LogDate", "ActivityID" }; List <string> p = new List <string>() { "@CustomerID", "@LogDate", "@ActivityID" }; List <object> o = new List <object>() { CustomerID, DateTime.Now, ActivityID }; if (!string.IsNullOrWhiteSpace(MiscData)) { c.Add("MiscData"); p.Add("@MiscData"); o.Add(MiscData); } dbConn.DBConnectionObject db = GlobalVariables.GetConnection(); db.Connection.InsertCommandCurrent("Core.PortalUsageData", c, p, o); } } catch { } }
public static string PropertyAddress(int UnitID) { string q = "select Core.Units.FlatOrApt, Core.Units.UnitNumber, Core.Units.Address1 from " + " core.units where ID = " + UnitID.ToString(); string r = ""; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); foreach (DataRow dr in dt.Rows) { r = SetAddress1(dr[0].ToString(), dr[1].ToString(), dr[2].ToString()); } return(r); }
public static string GetPropertyName(int unitid) { string q = "select concat(flatorapt, ' ', UnitNumber, ' ', Address1) from core.Units where id = " + unitid.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); string r = ""; if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { r = dt.Rows[0][0].ToString(); } return(r); }
public static Documents GetDocumentByID(long DocID) { string q = "Select document from core.documents where id = " + DocID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); Documents r = new Documents(); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { r.Document = DataRowToByteArray(dt.Rows[0], 0); } return(r); }
public static List <Estates> GetServiceChargePeriodList(int EstateID) { List <Estates> rlist = new List <Estates>(); string q = "Select core.ServiceChargeBudgets.ID, core.ServiceChargeBudgets.startDate, " + "core.ServiceChargeBudgets.endDate, core.ServiceChargeBudgets._status, " + "core.ServiceChargeBudgets.chargePeriod, core.FundTypes.FundType, core.ServiceChargeBudgets.BudgetName " + "from core.ServiceChargeBudgets " + "inner join core.FundTypes on core.FundTypes.Id = core.ServiceChargeBudgets.FundTypeID " + "where core.ServiceChargeBudgets.EstateID = " + EstateID.ToString() + " and core.servicechargebudgets.fundtypeID = 2" + " and core.ServiceChargeBudgets._status <> 'Progress'"; DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { DateTime sdate = new DateTime(); if (dr[1] != DBNull.Value) { sdate = Convert.ToDateTime(dr[1]); } DateTime edate = new DateTime(); if (dr[2] != DBNull.Value) { edate = Convert.ToDateTime(dr[2]); } rlist.Add(new Estates() { BudgetId = Convert.ToInt32(dr[0]), SCStartDate = sdate.ToShortDateString(), SCEndDate = edate.ToShortDateString(), ServiceChargePeriod = SetServiceChargePeriod(sdate.ToShortDateString(), edate.ToShortDateString()), _status = dr[3].ToString(), FundName = dr[6].ToString(), EstatedID = EstateID }); } } return(rlist); }
public static void UpdateLoginEmail(string Email, int CustomerID) { List <string> colnames = new List <string>(); colnames.Add("Username"); List <string> PList = new List <string>(); PList.Add("@Username"); List <object> values = new List <object>(); values.Add(Email); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.UpdateCommand("core.CustomerPortal", colnames, PList, values, " where customerID = " + CustomerID.ToString()); }
public static List <string> GetPasswordandSalt(int customerID) { string q = "select PWord, Salt from core.customerportal where customerID = " + customerID.ToString(); DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); List <string> r = new List <string>(); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { r.Add(dt.Rows[0][0].ToString()); r.Add(dt.Rows[0][1].ToString()); } return(r); }
public static List <Insurance> GetInsuranceList(int unitID) { string q = "Select core.Insurances.id, core.Insurances.policyname, core.Insurances.startdate, enddate from core.Insurances " + "inner join core.Units on core.units.EstateID = core.Insurances.EstateID where core.Units.id = " + unitID.ToString(); dbConn.DBConnectionObject db = GlobalVariables.GetConnection(); DataTable dt = db.Connection.GetDataTable(q); List <Insurance> r = new List <Insurance>(); if (dt.Rows.Count > 0 && dt.Rows[0][0].ToString() != "Error") { foreach (DataRow dr in dt.Rows) { // int.TryParse(dr[0].ToString(), out int id); int id = Convert.ToInt32(dr[0]); //start date DateTime st = new DateTime(); if (dr[2] != DBNull.Value) { st = Convert.ToDateTime(dr[2]); } //enddate DateTime en = new DateTime(); if (dr[3] != DBNull.Value) { en = Convert.ToDateTime(dr[3]); } r.Add(new Insurance { PolicyID = id, PolicyName = dr[1].ToString(), StartDate = st, EndDate = en }); } } return(r); }