public void GetPastelAccounts(String buildingCode) { String buildQ = "SELECT Building, DataPath FROM tblBuildings "; if (!String.IsNullOrEmpty(buildingCode)) { buildQ += "WHERE code = '" + buildingCode + "'"; } buildQ += " ORDER by Building"; String status = String.Empty; DataSet ds = DataHandler.getData(buildQ, out status); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { String buildingName = dr["Building"].ToString(); List <Customer> customers = frmMain.pastel.AddCustomers("", dr["DataPath"].ToString()); foreach (Customer c in customers) { CustomerConstruct cc = new CustomerConstruct(); cc.buildingName = buildingName; cc.acc = c.accNumber; cc.emails = c.Email; String email = ""; foreach (String e in c.Email) { email += e + ";"; } sw.WriteLine(buildingName + "," + c.accNumber + "," + email); } } } }
public void GetPastelAccounts(String buildingCode, bool showMe) { String buildQ = "SELECT Building, DataPath FROM tblBuildings "; if (!String.IsNullOrEmpty(buildingCode)) { buildQ += "WHERE code = '" + buildingCode + "'"; } buildQ += " ORDER by Building"; String status = String.Empty; DataSet ds = DataHandler.getData(buildQ, out status); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { String buildingName = dr["Building"].ToString(); List <Customer> customers = frmMain.pastel.AddCustomers("", dr["DataPath"].ToString()); foreach (Customer c in customers) { CustomerConstruct cc = new CustomerConstruct(); cc.buildingName = buildingName; cc.acc = c.accNumber; cc.emails = c.Email; allCustomers.Add(cc); } } } foreach (CustomerConstruct c in allCustomers) { DataConstruct dc = new DataConstruct(); dc.Building = c.buildingName; dc.Account = c.acc; String email = String.Empty; foreach (String e in c.emails) { if (!e.Contains("imp.ad-one")) { email += e + ";"; } } dc.Pastel_Emails = email; if (!dataCustomers.Keys.Contains(c.acc)) { dataCustomers.Add(c.acc, dc); } } if (showMe) { MessageBox.Show(dataCustomers.Count.ToString() + " customers retrieved"); } }