private void sfButton2_Click(object sender, EventArgs e) { Category.ReportProjectInformation_Form5 frm = new Category.ReportProjectInformation_Form5(); frm.Show(); this.Hide(); }
private void sfButtonShowProjectInformation_Click(object sender, EventArgs e) { Category.ReportProjectInformation_Form5 FRM = new ReportProjectInformation_Form5(); FRM.Show(); this.Hide(); }
private void sfButtonNextPage_Click(object sender, EventArgs e) { calculateSa(); calculateSo(); if (MessageBox.Show("Are you sure From Data You Entered ?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (SQLiteConnection conn = new SQLiteConnection(config.DataSource)) using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.Connection = conn; conn.Open(); SQLiteHelper sh = new SQLiteHelper(cmd); // sh.Execute("DELETE FROM Site_and_Location"); var dic = new Dictionary <string, object>(); dic["id"] = lastId; dic["sa"] = TotalSafity; dic["so"] = TotalSocial; sh.Insert("safetyandsocialside", dic); conn.Close(); } getData(); BAC = projectdata[0]; Console.WriteLine("BAC=" + BAC); percentOfCompleate = projectdata[4]; Console.WriteLine("percentOfCompleate=" + (percentOfCompleate)); EV = BAC * (percentOfCompleate); Console.WriteLine("EV=" + EV); AC = projectdata[1]; Console.WriteLine("AC=" + AC); CPI = EV / AC; Console.WriteLine("CPI=" + CPI); contarctDuration = projectdata[2]; Console.WriteLine("contarctDuration=" + contarctDuration); PV = projectdata[5]; Console.WriteLine("PV=" + PV); SPI = (EV / PV); Console.WriteLine("SPI=" + (EV / PV)); #region Befor ETC = (BAC - EV) / CPI; EAC = ETC + AC; VAC = BAC - EAC; using (SQLiteConnection conn = new SQLiteConnection(config.DataSource)) using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.Connection = conn; conn.Open(); SQLiteHelper sh = new SQLiteHelper(cmd); // sh.Execute("DELETE FROM Site_and_Location"); var dic = new Dictionary <string, object>(); dic["id"] = lastId; dic["contractvalue"] = BAC; dic["actualcost"] = AC; dic["contractduration"] = contarctDuration; dic["actualduration"] = projectdata[3]; dic["percentageofcompleate"] = projectdata[4]; dic["PV"] = PV; dic["EV"] = EV; dic["CPI"] = CPI; dic["SPI"] = SPI; dic["ETC"] = ETC; dic["EAC"] = EAC; dic["VAC"] = VAC; sh.Insert("report1", dic); } #endregion #region After ETC = (BAC - EV) / (CPI + SPI + costandtime[0] + costandtime[1] + qualityandrisk[0] + qualityandrisk[1] + safetyandsocialside[0] + safetyandsocialside[1]); EAC = ETC + AC; VAC = BAC - EAC; using (SQLiteConnection conn = new SQLiteConnection(config.DataSource)) using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.Connection = conn; conn.Open(); SQLiteHelper sh = new SQLiteHelper(cmd); // sh.Execute("DELETE FROM Site_and_Location"); var dic2 = new Dictionary <string, object>(); dic2["id"] = lastId; dic2["CPI"] = CPI; dic2["SPI"] = SPI; dic2["CO"] = costandtime[0]; dic2["TI"] = costandtime[1]; dic2["QU"] = qualityandrisk[0]; dic2["RI"] = qualityandrisk[1]; dic2["SA"] = safetyandsocialside[0]; dic2["SO"] = safetyandsocialside[1]; dic2["ETC"] = ETC; dic2["EAC"] = EAC; dic2["VAC"] = VAC; sh.Insert("report2", dic2); #endregion conn.Close(); } Category.ReportProjectInformation_Form5 frm = new ReportProjectInformation_Form5(); frm.Show(); this.Hide(); } }