public void SaveInformation() { int MonthID = Convert.ToInt32(drpMonth.SelectedValue); int YearID = Convert.ToInt32(drpYear.SelectedValue); int ModelGroupID = Convert.ToInt32(drpModel.SelectedValue); double ReworkCost_I_Year = Convert.ToDouble(txtReworkCostIYear.Text.Trim()); double ReworkCost_II_Year = Convert.ToDouble(txtReworkCostIIYear.Text.Trim()); ReworkCostController objController = new ReworkCostController(); ReworkCostUI objUI = new ReworkCostUI(); objUI.MonthID = MonthID; objUI.YearID = YearID; objUI.GroupID = ModelGroupID; objUI.ReworkCost_I_Year = ReworkCost_I_Year; objUI.ReworkCost_II_Year = ReworkCost_II_Year; objUI.ModelCategoryID = Convert.ToInt32(rdoModelCategory.SelectedValue); objUI.HMR_Range = rdoHMR.SelectedItem.Text; int ID = 0; try { ID = objController.SaveReworkCost(objUI, null); if (ID >0) { string str = "<script language = 'javascript'>"; str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records Saved Successfully');"; str += "</script>"; Literal1.Text = str; } else { string str = "<script language = 'javascript'>"; str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records could not be Saved Successfully');"; str += "</script>"; Literal1.Text = str; } } catch { string str = "<script language = 'javascript'>"; str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records could not be Saved Successfully');"; str += "</script>"; Literal1.Text = str; } }
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(); } }