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