public usrImportBank() { InitializeComponent(); List <Building> buildingList = new Buildings(false).buildings; buildings = new Dictionary <string, Building>(); foreach (Building b in buildingList) { buildings.Add(b.Abbr, b); } trustPeriod = Methods.getPeriod(DateTime.Now); dh = new SqlDataHandler(); }
//private String getDebtorEmail(int buildingId) //{ // List<Building> testBuildings = new Buildings(false).buildings; // var b = testBuildings.Where(a => a.Bu) // String dEmail = ""; // foreach (Building b in testBuildings) // { // if (b.Name == buildingName) { dEmail = b.Debtor; } // } // return (dEmail != "" ? dEmail : Controller.user.email); //} private void SetBuildingStatement(String buildingName) { List <Building> testBuildings = new Buildings(false).buildings; int buildingID = 0; foreach (Building b in testBuildings) { if (b.Name == buildingName) { buildingID = b.ID; String query = "IF NOT EXISTS(SELECT id FROM tblDebtors WHERE buildingID = " + b.ID.ToString() + " AND completeDate = '" + DateTime.Now.ToString("yyyy/MM/dd") + "')"; query += " INSERT INTO tblDebtors(buildingID, completeDate, stmtprintemail) VALUES(" + b.ID.ToString() + ", '" + DateTime.Now.ToString("yyyy/MM/dd") + "', 'True')"; dh.SetData(query, null, out status); break; } } }
public usrIndStatements() { InitializeComponent(); List <Building> allBuildings = new Buildings(false).buildings; buildings = new List <Building>(); foreach (int bid in Controller.user.buildings) { foreach (Building b in allBuildings) { if (bid == b.ID && !buildings.Contains(b)) { buildings.Add(b); break; } } } buildings = buildings.OrderBy(c => c.Name).ToList(); }
private void usrCredits_Load(object sender, EventArgs e) { List <Building> allBuildings = new Buildings(false).buildings; LoadDefaultValues(); buildings = new List <Building>(); foreach (int bid in Controller.user.buildings) { foreach (Building b in allBuildings) { if (bid == b.ID && !buildings.Contains(b)) { buildings.Add(b); break; } } } buildings = buildings.OrderBy(c => c.Name).ToList(); LoadBuildings(); }
private void ProcessContents(List <Dictionary <String, String> > contents) { List <Building> buildings = new Buildings(false).buildings; processedLines = 0; int enterProcess = 0; foreach (Dictionary <String, String> content in contents) { enterProcess++; String errorKey = ""; try { errorKey = "building"; String building = content["BUILDING"].Trim(); errorKey = "unit"; String unit = content["UNIT"].Trim(); DateTime trnDate = DateTime.Now; errorKey = "date 1"; try { trnDate = DateTime.Parse(content["POST DATE"]); } catch (Exception ex) { MessageBox.Show("Error in post date: " + content["POST DATE"]); } //MessageBox.Show(trnDate.ToString()); errorKey = "type"; String description = content["TYPE"].Trim() + " "; errorKey = "reading"; description += content["READING"].Trim() + " "; String readDate = ""; errorKey = "date 2"; try { readDate = DateTime.Parse(content["READ DATE"]).ToString("dd/MM/yyyy"); } catch (Exception ex) { } description += readDate; errorKey = "fee"; String amt = content["FEE"].Trim(); errorKey = "contra"; String contra = content["CONTRA"].Trim(); String dataPath = String.Empty; int trustPeriod = 0; int buildPeriod = 0; int journalType = 0; foreach (Building b in buildings) { if (b.Abbr == building) { dataPath = b.DataPath; trustPeriod = Methods.getPeriod(trnDate, b.Period, out buildPeriod); journalType = b.Journal; break; } } if (String.IsNullOrEmpty(dataPath)) { continue; } String returner = String.Empty; String strIn; if (building == "RENT") { double amount = double.Parse(amt); amount = amount * -1; String supamt = amount.ToString(); PostLine(trnDate, dataPath, journalType, pastelPeriod, unit, "0000000", unit, description, amt, true, out strIn, out returner); PostLine(trnDate, dataPath, journalType, pastelPeriod, contra, "0000000", unit, description, supamt, false, out strIn, out returner); } else { PostLine(trnDate, dataPath, journalType, pastelPeriod, unit, contra.Replace("/", ""), unit, description, amt, true, out strIn, out returner); } if (returner != "0") { MessageBox.Show(enterProcess.ToString() + ": " + returner + " - " + strIn); } else { processedLines += 1; } } catch (Exception ex) { MessageBox.Show("key before = " + errorKey + " - " + ex.Message); } } }
public static Dictionary <String, Building2> GetReportBuildings() { String status; Dictionary <String, Building2> repBuildings = new Dictionary <string, Building2>(); repBuildings.Clear(); String centrecQuery = "SELECT centrec FROM tblSettings"; SqlDataHandler dh = new SqlDataHandler(); DataSet dsCentrec = dh.GetData(centrecQuery, null, out status); String centrecPath = ""; if (dsCentrec != null && dsCentrec.Tables.Count > 0 && dsCentrec.Tables[0].Rows.Count > 0) { centrecPath = dsCentrec.Tables[0].Rows[0]["centrec"].ToString(); } else { MessageBox.Show(status); } List <Building> buildings = new Buildings(false).buildings; //String myPath = ""; //String pastelTest = Controller.pastel.SetPath("CENTRE17", out myPath); //if (pastelTest != "0") { MessageBox.Show(myPath); } foreach (Building b in buildings) { try { int id = b.ID; String building = b.Name; String code = b.Abbr; String path = b.DataPath; int period = b.Period; int journal = b.Journal; String acc = b.Trust; String bank = b.Bank; String centrec_building = b.Centrec_Building.Replace("//", "").Replace("/", ""); String centrec = b.Centrec_Account.Replace("//", "").Replace("/", ""); String business = b.Business_Account; String cString = Controller.pastel.GetAccount(path, centrec_building); //MessageBox.Show(centrec_building); Account buildCentrec = (cString != "" && !cString.StartsWith("error") ? new Account(cString) : null); String aString = Controller.pastel.GetCustomer(centrecPath, centrec); //MessageBox.Show(centrec); Customer centrecBuild = (aString != "" && !aString.StartsWith("error") ? new Customer(aString) : null); if (buildCentrec != null && centrecBuild != null) { Building2 build = new Building2(id, building, code, path, period, journal, acc, centrec_building, centrec, business, buildCentrec, centrecBuild, bank); repBuildings.Add(building, build); } else { Building2 build = new Building2(id, building, code, path, period, journal, acc, centrec_building, centrec, business, new Account("NONE"), new Customer(true, "NONE"), bank); repBuildings.Add(building, build); } //break; } catch (Exception ex) { Controller.HandleError(ex); } } return(repBuildings); }