コード例 #1
0
        /// <summary>
        /// To Insert details of SectionT in SectionT table
        /// Created By : NafisaMulla, 12/6/2014
        /// Modified By :
        /// </summary>
        /// <param name="objSectionTBO"></param>
        /// <returns></returns>
        public ApplicationResult SectionT_Insert(SectionTBO objSectionTBO)
        {
            try
            {
                pSqlParameter = new SqlParameter[6];


                pSqlParameter[0]           = new SqlParameter("@SectionMID", SqlDbType.Int);
                pSqlParameter[0].Direction = ParameterDirection.Input;
                pSqlParameter[0].Value     = objSectionTBO.SectionMID;

                pSqlParameter[1]           = new SqlParameter("@SchoolMID", SqlDbType.Int);
                pSqlParameter[1].Direction = ParameterDirection.Input;
                pSqlParameter[1].Value     = objSectionTBO.SchoolMID;

                pSqlParameter[2]           = new SqlParameter("@MediumMID", SqlDbType.Int);
                pSqlParameter[2].Direction = ParameterDirection.Input;
                pSqlParameter[2].Value     = objSectionTBO.MediumMID;

                pSqlParameter[3]           = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
                pSqlParameter[3].Direction = ParameterDirection.Input;
                pSqlParameter[3].Value     = objSectionTBO.LastModifiedUserID;

                pSqlParameter[4]           = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
                pSqlParameter[4].Direction = ParameterDirection.Input;
                pSqlParameter[4].Value     = objSectionTBO.LastModifiedDate;

                pSqlParameter[5]           = new SqlParameter("@IsDeleted", SqlDbType.Int);
                pSqlParameter[5].Direction = ParameterDirection.Input;
                pSqlParameter[5].Value     = objSectionTBO.IsDeleted;


                sSql = "usp_tbl_Section_T_Insert";
                int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);

                if (iResult > 0)
                {
                    ApplicationResult objResults = new ApplicationResult();
                    objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
                    return(objResults);
                }
                else
                {
                    ApplicationResult objResults = new ApplicationResult();
                    objResults.status = ApplicationResult.CommonStatusType.FAILURE;
                    return(objResults);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objSectionTBO = null;
            }
        }
コード例 #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                ApplicationResult objResults    = new ApplicationResult();
                SectionBO         objSectionBO  = new SectionBO();
                SectionBL         objSectionBL  = new SectionBL();
                SectionTBO        objSectionTBO = new SectionTBO();

                objSectionBO.SectionName          = txtSectionName.Text;
                objSectionBO.SectionAvbbreviation = txtAbbreviation.Text;
                objSectionBO.Description          = txtSectionDesc.Text;
                objSectionBO.LastModifiedDate     = DateTime.UtcNow.AddHours(5.5).ToString();
                objSectionBO.LastModifiedUserID   = Convert.ToInt32(Session[ApplicationSession.USERID]);
                if (ValidateName() == true)
                {
                    ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Name or/and Section Abbrev " + txtSectionName.Text + "/" + txtAbbreviation.Text + " Already Exists.');</script>");
                    goto Exit;
                }
                #region RollBack Transaction Starts

                DatabaseTransaction.OpenConnectionTransation();
                if (ViewState["Mode"].ToString() == "Save")
                {
                    objResults = objSectionBL.Section_Insert(objSectionBO);
                    if (objResults != null)
                    {
                        if (objResults.resultDT.Rows.Count > 0)
                        {
                            ViewState["SectionMID"]          = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
                            objSectionTBO.SectionMID         = Convert.ToInt32(ViewState["SectionMID"].ToString());
                            objSectionTBO.SchoolMID          = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
                            objSectionTBO.MediumMID          = 1;
                            objSectionTBO.LastModifiedDate   = DateTime.UtcNow.AddHours(5.5).ToString();
                            objSectionTBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
                            objResults = objSectionBL.SectionT_Insert(objSectionTBO);
                            if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
                            {
                            }
                        }
                    }

                    ClearAll();
                    ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Created Successfully.');</script>");
                    //GridDataBind();
                    PanelGrid_VisibilityMode(1);
                }
                else
                {
                    ApplicationResult objResultsUpdate = new ApplicationResult();
                    objSectionBO.SectionMID = Convert.ToInt32(ViewState["SectionMID"].ToString());
                    objResultsUpdate        = objSectionBL.Section_Update(objSectionBO);
                    if (objResultsUpdate.status == ApplicationResult.CommonStatusType.SUCCESS)
                    {
                        ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Section updated successfully.');</script>");

                        ClearAll();
                    }
                }
                DatabaseTransaction.CommitTransation();
                GridDataBind();
                #endregion
                Exit :;
            }
            catch (Exception ex)
            {
                logger.Error("Error", ex);
                ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
            }
        }