public tb_NewStandardMOH ProcessData(int year, string byUser)
{
Database db = AppEnvironment.CreateDatabase();
try
{
db.BeginTrans();
tb_NewStandardMOH result = StoreProcedure.sp_ACS340_Process_CalculateStandardMOH(db, year, byUser);
db.CommitTrans();
return(result);
}
catch (Exception ex)
{
if (db.HasTransaction)
{
db.RollbackTrans();
}
throw;
}
finally
{
db.Close();
}
}
private void ProcessData()
{
int Year = txtYear.IntValue;
tb_NewStandardMOH result = m_bizProcess.ProcessData(Year, AppEnvironment.UserLogin);
if (result == null)
{
txtActualMOH.DecimalValue = 0;
txtActualCapacity.DecimalValue = 0;
txtActualMOHRate.DecimalValue = 0;
}
else
{
txtActualMOH.DecimalValue = result.TotalMOH.GetValueOrDefault(0);
txtActualCapacity.DecimalValue = result.TotalCapacity.GetValueOrDefault(0);
txtActualMOHRate.DecimalValue = result.MOHRate.GetValueOrDefault(0);
}
MessageDialog.ShowInformationMsg("Process Completed.");
}
