private void tdbgQuikUpdate_BeforeUpdate(object sender, C1.Win.C1TrueDBGrid.CancelEventArgs e)
{
DataRow dr = mdsUpdates.Tables[0].Rows[tdbgQuikUpdate.Bookmark];
int tmpID;
int tmpBM;
decimal bHrs;
decimal perc;
decimal eHrs;
decimal rHrs;
tmpBM = tdbgQuikUpdate.Bookmark;
// added to allow for the sort
CurrencyManager cm;
System.Data.DataView dv;
System.Data.DataRowView drv;
System.Data.DataRow dr2;
int row;
row = tdbgQuikUpdate.RowBookmark(tdbgQuikUpdate.Bookmark);
cm = (CurrencyManager)this.BindingContext[tdbgQuikUpdate.DataSource, tdbgQuikUpdate.DataMember];
dv = (DataView)cm.List;
drv = (System.Data.DataRowView)cm.List[row];
dr2 = drv.Row;
tmpID = Convert.ToInt32(dr["ID"]);
bHrs = Convert.ToDecimal(dr["BudgetHrs"]);
try //******************Try Catch block added 6/11/2015
{
rHrs = Convert.ToDecimal(dr["RemainingHrs"]);
}
catch
{ MessageBox.Show("Field Cannot be empty, default value=0");
return; }
int tmpID2 = Convert.ToInt32(dr2["ID"]);
decimal bHrs2 = Convert.ToDecimal(dr2["BudgetHrs"]);
decimal rHrs2 = Convert.ToDecimal(dr2["RemainingHrs"]);
//perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs);
//eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs);
//dr["PercentComplete"] = perc;
//dr["EarnedHrs"] = eHrs;
//CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs);
// changed to allow for the sort
perc = CBDrawingLog.GetPercentComplete(bHrs2, rHrs2);
eHrs = CBDrawingLog.GetEarnedHrs(bHrs2, rHrs2);
dr2["PercentComplete"] = perc;
dr2["EarnedHrs"] = eHrs;
CBDrawingLog.UpdateHours(tmpID2, bHrs2, perc, eHrs, rHrs2);
TotalHours();
}
private void GetThePercentComplete()
{
decimal budHrs;
decimal remHrs;
try
{
//budHrs = Convert.ToDecimal(txtBudgetHrs.Text);
budHrs = txtBudgetHrs.Text.Trim() == "" ? 0 : Convert.ToDecimal(txtBudgetHrs.Text);
remHrs = Convert.ToDecimal(txtRemainingHrs.Text);
}
catch
{
budHrs = 0;
remHrs = 0;
}
if (budHrs == 0)
{
txtPercentComplete.Text = "0.00";
}
else
{
txtPercentComplete.Text = CBDrawingLog.GetPercentComplete(budHrs, remHrs).ToString("#,##0.00");
}
decimal ernHrs = budHrs - remHrs;
txtEarnedHrs.Text = ernHrs.ToString("#,##0.00");
}
private void tdbgUpdate_AfterUpdate(object sender, EventArgs e)
{
DataRow dr = mdsUpdates.Tables[0].Rows[tdbgQuikUpdate.Bookmark];
int tmpID;
int tmpBM;
decimal bHrs;
decimal perc;
decimal eHrs;
decimal rHrs;
tmpBM = tdbgQuikUpdate.Bookmark;
// added to allow for the sort
CurrencyManager cm;
System.Data.DataView dv;
System.Data.DataRowView drv;
System.Data.DataRow dr2;
int row;
row = tdbgQuikUpdate.RowBookmark(tdbgQuikUpdate.Bookmark);
cm = (CurrencyManager)this.BindingContext[tdbgQuikUpdate.DataSource, tdbgQuikUpdate.DataMember];
dv = (DataView)cm.List;
drv = (System.Data.DataRowView)cm.List[row];
dr2 = drv.Row;
tmpID = Convert.ToInt32(dr["ID"]);
bHrs = Convert.ToDecimal(dr["BudgetHrs"]);
rHrs = Convert.ToDecimal(dr["RemainingHrs"]);
int tmpID2 = Convert.ToInt32(dr2["ID"]);
decimal bHrs2 = Convert.ToDecimal(dr2["BudgetHrs"]);
decimal rHrs2 = Convert.ToDecimal(dr2["RemainingHrs"]);
perc = CBDrawingLog.GetPercentComplete(bHrs2, rHrs2);
eHrs = CBDrawingLog.GetEarnedHrs(bHrs2, rHrs2);
dr2["PercentComplete"] = perc;
dr2["EarnedHrs"] = eHrs;
CBDrawingLog.UpdateHours(tmpID2, bHrs2, perc, eHrs, rHrs2);
//perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs);
//eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs);
//dr["PercentComplete"] = perc;
//dr["EarnedHrs"] = eHrs;
//CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs);
TotalHours();
}
private void SaveTimeChange(int rowIndx, int colIndx)
{
int tmpID;
decimal bHrs;
decimal perc;
decimal eHrs;
decimal rHrs;
tmpID = Convert.ToInt32(fgQuikUpdate[rowIndx, 2]);
bHrs = Convert.ToDecimal(fgQuikUpdate[rowIndx, 10]);
rHrs = Convert.ToDecimal(fgQuikUpdate[rowIndx, 14]);
perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs);
eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs);
fgQuikUpdate[rowIndx, 12] = perc;
fgQuikUpdate[rowIndx, 13] = eHrs;
CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs);
CreateSubtotals();
}
