protected void btnSave_Click(object sender, EventArgs e) { string strMessage = ""; MonthOpenCloseController objController = new MonthOpenCloseController(); MonthOpenCloseUI objUI = new MonthOpenCloseUI(); try { int MonthID = Convert.ToInt16(drpMonth.SelectedValue); int YearID = Convert.ToInt16(drpYear.SelectedItem.Text); int Status = 0; if (chkOpenClose.Checked) { Status = 1; } else { Status = 0; } objUI.MonthID = MonthID; objUI.YearID = YearID; objUI.Status = Status; objController.SaveMonthOpenClose(objUI); strMessage = "Record saved successfully"; string strjscript = "<script language='javascript'>"; strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + strMessage + "' );"; strjscript += "</script" + ">"; Literal1.Text = strjscript; } catch(Exception ex) { strMessage = ex.Message; string strjscript = "<script language='javascript'>"; strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + strMessage + "' );"; strjscript += "</script" + ">"; Literal1.Text = strjscript; } }
public void SaveMonthOpenClose(MonthOpenCloseUI objUI) { bool flagTransation = true; MonthOpenCloseDB objDB = new MonthOpenCloseDB(); objDB.MonthID = objUI.MonthID; objDB.YearID = objUI.YearID; objDB.Status = objUI.Status; DataAccessLayer objDataAccess = new DataAccessLayer(); SqlTransaction objTrans = null; try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } MonthOpenCloseManager objManager = new MonthOpenCloseManager(); objManager.SaveMonthOpenClose(objDB, objTrans); if (!flagTransation) objTrans.Commit(); } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }