public int SaveReworkCost(ReworkCostDB objDB, SqlTransaction objTrans)
{
int ID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_SaveReworkCost";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@MonthID", objDB.MonthID);
objCmd.Parameters.AddWithValue("@YearID", objDB.YearID);
objCmd.Parameters.AddWithValue("@ModelGroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@ReworkCost_I_Year", objDB.ReworkCost_I_Year);
objCmd.Parameters.AddWithValue("@ReworkCost_II_Year", objDB.ReworkCost_II_Year);
objCmd.Parameters.AddWithValue("@ModelCategoryID", objDB.ModelCategoryID);
objCmd.Parameters.AddWithValue("@HMR_Range", objDB.HMR_Range);
objCmd.Parameters.AddWithValue("@ID", SqlDbType.Int);
objCmd.Parameters["@ID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
ID = Convert.ToInt32(objCmd.Parameters["@ID"].Value);
return ID;
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveReworkCost(ReworkCostUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int ID = 0;
bool flagTransation = true;
ReworkCostDB objDB = new ReworkCostDB();
objDB.GroupID = objUI.GroupID;
objDB.MonthID = objUI.MonthID;
objDB.YearID = objUI.YearID;
objDB.ReworkCost_I_Year = objUI.ReworkCost_I_Year;
objDB.ReworkCost_II_Year = objUI.ReworkCost_II_Year;
objDB.ModelCategoryID = objUI.ModelCategoryID;
objDB.HMR_Range = objUI.HMR_Range;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ReworkCostManager objManager = new ReworkCostManager();
ID=objManager.SaveReworkCost(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return ID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
