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