コード例 #1
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         #region  DELETE
         if (HfComplainCode.Value != string.Empty)
         {
             string str = JOB_COMPMASLogicLayer.DeleteJOB_COMPLAIN_MASDetailByID(HfComplainCode.Value);
             if (str.Contains("successfully"))
             {
                 lblmsg.Text      = "Record Deleted Successfully";
                 lblmsg.ForeColor = Color.Green;
             }
             else if (str.Contains("Cannot"))
             {
                 lblmsg.Text      = "Cannot Delete This Record It Used by Other Data";
                 lblmsg.ForeColor = Color.Red;
             }
             else
             {
                 lblmsg.Text      = "Error:Complain Master Not Deleted";
                 lblmsg.ForeColor = Color.Red;
             }
             clear();
             FillGrid(Session["COMP_CODE"].ToString());
             UserRights();
         }
         #endregion
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #2
0
        protected void BtncallUpd_Click(object sender, EventArgs e)
        {
            try
            {
                if (BtncallUpd.Text == "UPDATE")
                {
                    ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
                }

                else
                {
                    #region INSERT JOB COMPLAIN MASTER MASTER

                    JOB_COMPMASLogicLayer insert = new JOB_COMPMASLogicLayer();
                    insert.COMP_CODE      = Session["COMP_CODE"].ToString();
                    insert.COMPLAIN_CODE  = HfComplainCode.Value.Trim();
                    insert.BRANDTYPE_CODE = HfBrandTypeCode.Value.Trim();
                    insert.COMPLAIN_DESC  = TxtComplainDescription.Text.Trim().ToUpper();
                    insert.COMPLAIN_CHECK = TxtComplainChecklist.Text.Trim().ToUpper();
                    insert.INS_USERID     = Session["USERNAME"].ToString();
                    insert.INS_TERMINAL   = Session["PC"].ToString();
                    insert.INS_DATE       = "";
                    insert.UPD_USERID     = Session["USERNAME"].ToString();
                    insert.UPD_TERMINAL   = Session["PC"].ToString();
                    insert.UPD_DATE       = "";
                    #endregion

                    if (BtncallUpd.Text.Trim().ToUpper() == "SAVE")
                    {
                        string str = JOB_COMPMASLogicLayer.InsertJOB_COMPLAIN_MASDetail(insert);
                        if (str.Contains("successfully"))
                        {
                            lblmsg.Text      = "COMPALIN MASTER DETAIL ADD SUCCESSFULLY.";
                            lblmsg.ForeColor = Color.Green;
                            clear();
                            FillGrid(Session["COMP_CODE"].ToString());
                            UserRights();
                        }
                        else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
                        {
                            lblmsg.Text      = "COMPLAIN CODE ALREADY EXIST.";
                            lblmsg.ForeColor = Color.Red;
                        }
                        else
                        {
                            lblmsg.Text      = "ERROR : COMPLAIN MASTER DETAIL NOT SAVED";
                            lblmsg.ForeColor = Color.Red;
                        }
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #3
0
 public void FillDdlComaplainDescription()
 {
     try
     {
         DataTable Dt = JOB_COMPMASLogicLayer.GetAllJOB_COMPLAIN_MASDetialsFor_DDL();
         DdlComplainDescription.DataSource     = Dt;
         DdlComplainDescription.DataValueField = "COMPLAIN_CODE";
         DdlComplainDescription.DataTextField  = "COMPLAIN_DESC";
         DdlComplainDescription.DataBind();
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #4
0
        public void FillGrid(string CompCode)
        {
            try
            {
                DataTable Dt = new DataTable();

                Dt = JOB_COMPMASLogicLayer.GetAllJOB_COMPLAIN_MASDetails(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
                DataView Dv = new DataView(Dt);
                if (CompCode != string.Empty)
                {
                    Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString();
                }
                GvJobComplainMaster.DataSource = Dv.ToTable();
                GvJobComplainMaster.DataBind();
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #5
0
        protected void GvJobComplainMaster_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Deletea")
                {
                    #region DELETE
                    clear();
                    DataTable dt = JOB_COMPMASLogicLayer.GetAllIDWiseJOB_COMPLAIN_MASDetail(e.CommandArgument.ToString());
                    if (dt.Rows.Count > 0)
                    {
                        DivEntry.Visible = true;
                        DivView.Visible  = false;

                        HfBrandTypeCode.Value       = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
                        HfCompCode.Value            = dt.Rows[0]["COMP_CODE"].ToString();
                        HfComplainCode.Value        = dt.Rows[0]["COMPLAIN_CODE"].ToString();
                        TxtComplainDescription.Text = dt.Rows[0]["COMPLAIN_DESC"].ToString();
                        TxtComplainChecklist.Text   = dt.Rows[0]["COMPLAIN_CHECK"].ToString();
                    }
                    btnSave.Visible    = false;
                    btnDelete.Visible  = true;
                    Btncalldel.Visible = true;
                    BtncallUpd.Visible = false;
                    ControllerDisable();

                    #endregion
                }

                if (e.CommandName == "Edita")
                {
                    #region EDIT
                    clear();
                    DataTable dt = JOB_COMPMASLogicLayer.GetAllIDWiseJOB_COMPLAIN_MASDetail(e.CommandArgument.ToString());
                    if (dt.Rows.Count > 0)
                    {
                        DivEntry.Visible = true;
                        DivView.Visible  = false;

                        HfBrandTypeCode.Value       = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
                        HfCompCode.Value            = dt.Rows[0]["COMP_CODE"].ToString();
                        HfComplainCode.Value        = dt.Rows[0]["COMPLAIN_CODE"].ToString();
                        TxtComplainDescription.Text = dt.Rows[0]["COMPLAIN_DESC"].ToString();
                        TxtComplainChecklist.Text   = dt.Rows[0]["COMPLAIN_CHECK"].ToString();


                        BtncallUpd.Text = "UPDATE";

                        #endregion
                    }
                    #region CHECK UPDATE RIGHTS
                    if (Session["UPDATE"] != null)
                    {
                        if (Session["UPDATE"].ToString() == "Y")
                        {
                            ControllerEnable();
                        }
                        else
                        {
                            ControllerDisable();
                        }
                    }
                    #endregion
                    Btncalldel.Visible = false;
                    BtncallUpd.Visible = true;
                    btnSave.Visible    = true;
                    UserRights();
                }


                if (e.CommandName == "Viewa")
                {
                    #region SET TEXT ON VIEW
                    clear();
                    DataTable dt = JOB_COMPMASLogicLayer.GetAllIDWiseJOB_COMPLAIN_MASDetail(e.CommandArgument.ToString());
                    if (dt.Rows.Count > 0)
                    {
                        DivEntry.Visible = true;
                        DivView.Visible  = false;

                        HfBrandTypeCode.Value       = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
                        HfCompCode.Value            = dt.Rows[0]["COMP_CODE"].ToString();
                        HfComplainCode.Value        = dt.Rows[0]["COMPLAIN_CODE"].ToString();
                        TxtComplainDescription.Text = dt.Rows[0]["COMPLAIN_DESC"].ToString();
                        TxtComplainChecklist.Text   = dt.Rows[0]["COMPLAIN_CHECK"].ToString();


                        #endregion
                    }

                    ControllerDisable();
                    btnSave.Visible    = false;
                    Btncalldel.Visible = false;
                    BtncallUpd.Visible = false;
                    UserRights();
                }
            }
            catch (Exception ex)
            {
                lblmsg.Text = ex.Message.ToString();
            }
        }