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