private void tsbSave_Click(object sender, EventArgs e)
{
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
CapitalWork cpw;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string msg = "";
using (DbTransaction trans = conn.BeginTransaction())
{
try
{
for (int i = 0; i < dgv01.Rows.Count; i++)
{
double number1, number2;
try
{ number1 = Double.Parse(dgv01.Rows[i].Cells[6].Value.ToString(), NumberStyles.Currency); }
catch (Exception ex) { number1 = 0; }
try
{ number2 = Double.Parse(dgv01.Rows[i].Cells[7].Value.ToString(), NumberStyles.Currency); }
catch (Exception ex) { number2 = 0; }
if (number1 != number2)
{
cpw = new CapitalWork(int.Parse(dgv01.Rows[i].Cells[1].Value.ToString()));
cpw.CapitalWorkYear = OPGlobals.currentYear;
cpw.CapitalWorkMonth = OPGlobals.currentMonth;
cpw.YearToDate = number1;
if (dgv01.Rows[i].Cells[8].Value.ToString() == "0")
{
cpw.InsertCWPYTD(db, conn, trans);
}
else
{
cpw.UpdateCWPYTD(db, conn, trans);
}
}
}
trans.Commit();
msg = "Capital Work YTD has been saved/updated successfully";
}
catch (Exception ex)
{
trans.Rollback();
msg = "Data NOT Saved ..." + Environment.NewLine + ex.Message;
}
}
conn.Close();
//msg += Environment.NewLine + "<<<<<<< OPERATION SUMMARY >>>>>>>";
MessageBox.Show(msg, "OPERATION PLAN", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void tsbSave_Click(object sender, EventArgs e)
{
int startIndex = CapitalWork.getNextCPWIndexStatic();
for (int dr = 0; dr < dg1.RowCount; dr++)
{
CapitalWork cpw = new CapitalWork(dr + startIndex);
cpw.CapitalWorkJobCostNumber = dg1.Rows[dr].Cells["JCNo"].Value.ToString();
cpw.Description = dg1.Rows[dr].Cells["Description"].Value.ToString();
cpw.OriginalBudget = Double.Parse(string.IsNullOrEmpty(dg1.Rows[dr].Cells["Org.Budget"].Value.ToString()) ? "0" : dg1.Rows[dr].Cells["Org.Budget"].Value.ToString(),
NumberStyles.AllowCurrencySymbol | NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands);
cpw.RevisedBudget = Double.Parse(string.IsNullOrEmpty(dg1.Rows[dr].Cells["Rev.Budget"].Value.ToString()) ? "0" : dg1.Rows[dr].Cells["Rev.Budget"].Value.ToString(),
NumberStyles.AllowCurrencySymbol | NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands);
cpw.ServicePlanID = dg1.Rows[dr].Cells["ServiceID"].Value.ToString();
cpw.ManagerID = dg1.Rows[dr].Cells["ManagerID"].Value.ToString();
cpw.CapitalWorkYear = OPGlobals.currentYear;
cpw.CapitalWorkMonth = OPGlobals.currentMonth;
cpw.YearToDate = Double.Parse(string.IsNullOrEmpty(dg1.Rows[dr].Cells["YTD"].Value.ToString()) ? "0" : dg1.Rows[dr].Cells["YTD"].Value.ToString(),
NumberStyles.AllowCurrencySymbol | NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (DbTransaction trans = conn.BeginTransaction())
{
try
{
bool saveresult = cpw.InsertCWP(db, conn, trans);
if (saveresult)
{
cpw.InsertCWPQBR(db, conn, trans);
cpw.InsertCWPYTD(db, conn, trans);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
MessageBox.Show("Data NOT Saved ..." + cpw.Description.ToString() + Environment.NewLine + ex.Message.ToString(), "OP ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
MessageBox.Show("Capital Work Project has been imported successfully", "OP MESSAGE", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
