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);
}
private void tsbSave_Click(object sender, EventArgs e)
{
bool saveresult = false;
//======== NEW CPW===========
CapitalWork cpw = new CapitalWork((string.IsNullOrEmpty(txtcpwid.Text) ? 0 : int.Parse(txtcpwid.Text)));
cpw.CapitalWorkJobCostNumber = txtJobCostNumber.Text;
DataRowView row;
row = (DataRowView)cboManager.SelectedItem;
if (row != null)
{
cpw.ManagerID = row["manager_id"].ToString();
}
cpw.CapitalWorkYear = txtFinYear.Text;
cpw.CapitalWorkMonth = OPGlobals.currentMonth;
row = (DataRowView)cboServicePlan.SelectedItem;
if (row != null)
{
cpw.ServicePlanID = row["id"].ToString();
}
row = (DataRowView)cboStrategyObj.SelectedItem;
if (row != null)
{
cpw.StrategyObjectiveID = row["id"].ToString();
}
cpw.Description = txtCPWDescription.Text;
double number;
if (Double.TryParse(txtCPWBudget.Text, out number))
{
cpw.OriginalBudget = number;
}
if (Double.TryParse(txtRevisedBudget.Text, out number))
{
cpw.RevisedBudget = number;
}
if (Double.TryParse(txtCarryOver.Text, out number))
{
cpw.CarryOverBudget = number;
}
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (DbTransaction trans = conn.BeginTransaction())
{
try
{
if (cpw.CapitalWorkID == 0)
{
saveresult = cpw.InsertCWP(db, conn, trans);
if (saveresult)
{
cpw.InsertCWPQBR(db, conn, trans);
}
}
else
{
saveresult = cpw.UpdateCWP(db, conn, trans);
if (saveresult)
{
cpw.UpdateCWPQBR(db, conn, trans);
}
}
trans.Commit();
MessageBox.Show("Capital Work Project has been saved/updated successfully", "OP MESSAGE", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
trans.Rollback();
MessageBox.Show("Data NOT Saved ..." + Environment.NewLine + ex.Message.ToString(), "OP ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
conn.Close();
if (saveresult == true)
{
UpdateDataGrid(cpw.CapitalWorkID);
}
}
