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