Exemple #1
0
        /// <summary>
        /// To Update details of Shift in Shift table
        /// Created By : Chintan, 06-10-2015
        /// Modified By :
        /// </summary>
        public ApplicationResult Shift_Update(ShiftBo objShiftBo, string strFromTime, string strToTime)
        {
            try
            {
                pSqlParameter = new SqlParameter[6];


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

                pSqlParameter[1]           = new SqlParameter("@Name", SqlDbType.NVarChar);
                pSqlParameter[1].Direction = ParameterDirection.Input;
                pSqlParameter[1].Value     = objShiftBo.Name;

                pSqlParameter[2]           = new SqlParameter("@FromTime", SqlDbType.VarChar);
                pSqlParameter[2].Direction = ParameterDirection.Input;
                pSqlParameter[2].Value     = strFromTime;

                pSqlParameter[3]           = new SqlParameter("@ToTime", SqlDbType.VarChar);
                pSqlParameter[3].Direction = ParameterDirection.Input;
                pSqlParameter[3].Value     = strToTime;

                pSqlParameter[4]           = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
                pSqlParameter[4].Direction = ParameterDirection.Input;
                pSqlParameter[4].Value     = objShiftBo.LastModifiedBy;

                pSqlParameter[5]           = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime);
                pSqlParameter[5].Direction = ParameterDirection.Input;
                pSqlParameter[5].Value     = objShiftBo.LastModifiedDate;

                sSql = "usp_tbl_Shift_Update";

                DataTable dtResult = new DataTable();
                dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
                ApplicationResult objResults = new ApplicationResult(dtResult);
                objResults.Status = ApplicationResult.CommonStatusType.Success;
                return(objResults);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objShiftBo = null;
            }
        }
Exemple #2
0
 protected void btnSave_OnClick(object sender, EventArgs e)
 {
     try
     {
         ShiftBo objShiftBo  = new ShiftBo();
         ShiftBl objShiftBl  = new ShiftBl();
         string  strFromTime = string.Empty;
         string  strToTime   = string.Empty;
         objShiftBo.Name = txtName.Text.Trim();
         strFromTime     = txtFromTime.Text;
         strToTime       = txtToTime.Text;
         if (ViewState["Mode"].ToString() == "Save")
         {
             objShiftBo.CreatedBy   = Convert.ToInt32(Session[ApplicationSession.Userid]);
             objShiftBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
             var objResult = objShiftBl.Shift_Insert(objShiftBo, strFromTime, strToTime);
             if (objResult != null)
             {
                 if (objResult.ResultDt.Rows.Count > 0)
                 {
                     int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
                     if (intStatus == 0)
                     {
                         ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtName.Text + " is already exist.');</script>");
                     }
                     else
                     {
                         ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
                         ClearAll();
                         BindgvShift();
                         PanelVisibilityMode(true, false);
                     }
                 }
             }
         }
         else if (ViewState["Mode"].ToString() == "Edit")
         {
             objShiftBo.LastModifiedBy   = Convert.ToInt32(Session[ApplicationSession.Userid]);
             objShiftBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
             objShiftBo.ShiftId          = Convert.ToInt32(ViewState["ID"].ToString());
             var objResult = objShiftBl.Shift_Update(objShiftBo, strFromTime, strToTime);
             if (objResult != null)
             {
                 if (objResult.ResultDt.Rows.Count > 0)
                 {
                     int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
                     if (intStatus == 0)
                     {
                         ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtName.Text + " is already exist.');</script>");
                     }
                     else
                     {
                         ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
                         ClearAll();
                         BindgvShift();
                         PanelVisibilityMode(true, false);
                     }
                 }
             }
         }
     }
     catch (Exception ex)
     {
         log.Error("Error", ex);
         ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
     }
 }
Exemple #3
0
        /// <summary>
        /// To Insert details of Shift in Shift table
        /// Created By : Chintan, 06-10-2015
        /// Modified By :
        /// </summary>
        public ApplicationResult Shift_Insert(ShiftBo objShiftBo, string strFromTime, string strToTime)
        {
            try
            {
                pSqlParameter = new SqlParameter[6];


                pSqlParameter[0]           = new SqlParameter("@Name", SqlDbType.NVarChar);
                pSqlParameter[0].Direction = ParameterDirection.Input;
                pSqlParameter[0].Value     = objShiftBo.Name;

                pSqlParameter[1]           = new SqlParameter("@FromTime", SqlDbType.VarChar);
                pSqlParameter[1].Direction = ParameterDirection.Input;
                pSqlParameter[1].Value     = strFromTime;

                pSqlParameter[2]           = new SqlParameter("@ToTime", SqlDbType.VarChar);
                pSqlParameter[2].Direction = ParameterDirection.Input;
                pSqlParameter[2].Value     = strToTime;

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

                pSqlParameter[4]           = new SqlParameter("@CreatedDate", SqlDbType.DateTime);
                pSqlParameter[4].Direction = ParameterDirection.Input;
                pSqlParameter[4].Value     = objShiftBo.CreatedDate;

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


                sSql = "usp_tbl_Shift_Insert";
                //int iResult = Database.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;
                //}
                DataTable dtResult = new DataTable();
                dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
                ApplicationResult objResults = new ApplicationResult(dtResult);
                objResults.Status = ApplicationResult.CommonStatusType.Success;
                return(objResults);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objShiftBo = null;
            }
        }