Пример #1
0
        protected void BtncallUpd_Click(object sender, EventArgs e)
        {
            try
            {
                if (BtncallUpd.Text == "UPDATE")
                {
                    ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
                }
                else
                {
                    CHARGES_MASLogicLayer insert = new CHARGES_MASLogicLayer();
                    insert.COMP_CODE = Session["COMP_CODE"].ToString();
                    insert.NAME      = TxtChargesName.Text.Trim().ToUpper();
                    if (TxtRate.Text == string.Empty)
                    {
                        insert.PER = "0";
                    }
                    else
                    {
                        insert.PER = TxtRate.Text.Trim();
                    }
                    insert.SIGN  = DdlSign.SelectedValue.Trim().ToUpper();
                    insert.ACODE = DdlAccountName.SelectedValue.Trim().ToUpper();

                    if (TxtHSNCode.Text == string.Empty)
                    {
                        insert.HSN_NO = "0";
                    }
                    else
                    {
                        insert.HSN_NO = TxtHSNCode.Text.Trim();
                    }
                    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     = "";

                    if (BtncallUpd.Text.Trim().ToUpper() == "SAVE")
                    {
                        string str = CHARGES_MASLogicLayer.InsertCHARGESDetail(insert);
                        if (str.Length <= 8)
                        {
                            //INSERT CHARGE RATE
                            CHARGES_RATEMASLogicLayer InsertRate = new CHARGES_RATEMASLogicLayer();

                            InsertRate.CCODE     = str;
                            InsertRate.COMP_CODE = Session["COMP_CODE"].ToString();
                            InsertRate.YRDT1     = Convert.ToDateTime(Session["FIN_YEAR"]).ToString("yyyy-MM-dd");


                            if (TxtGST.Text == string.Empty)
                            {
                                InsertRate.GST_RATE = "0";
                            }
                            else
                            {
                                InsertRate.GST_RATE = TxtGST.Text.Trim();
                            }

                            if (TxtCGST.Text == string.Empty)
                            {
                                InsertRate.CGST_RATE = "0";
                            }
                            else
                            {
                                InsertRate.CGST_RATE = TxtCGST.Text.Trim();
                            }

                            if (TxtSGST.Text == string.Empty)
                            {
                                InsertRate.SGST_RATE = "0";
                            }
                            else
                            {
                                InsertRate.SGST_RATE = TxtSGST.Text.Trim();
                            }

                            if (TxtIGST.Text == string.Empty)
                            {
                                InsertRate.IGST_RATE = "0";
                            }
                            else
                            {
                                InsertRate.IGST_RATE = TxtIGST.Text.Trim();
                            }
                            InsertRate.INS_USERID   = Session["USERNAME"].ToString();
                            InsertRate.INS_TERMINAL = Session["PC"].ToString();
                            InsertRate.INS_DATE     = "";
                            InsertRate.UPD_USERID   = Session["USERNAME"].ToString();
                            InsertRate.UPD_TERMINAL = Session["PC"].ToString();
                            InsertRate.UPD_DATE     = "";
                            CHARGES_RATEMASLogicLayer.InsertCHARGES_RATEMASDetail(InsertRate);

                            lblmsg.Text      = "CHARGES 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      = "CHARGES CODE ALREADY EXIST.";
                            lblmsg.ForeColor = Color.Red;
                        }
                        else
                        {
                            lblmsg.Text      = "ERROR : CHARGES DETAIL NOT SAVED";
                            lblmsg.ForeColor = Color.Red;
                        }
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                #region INSERT _ UPDATE VALUE

                CHARGES_MASLogicLayer insert = new CHARGES_MASLogicLayer();
                insert.COMP_CODE = HfCompCode.Value.Trim();
                insert.CCODE     = HfChargesCode.Value.Trim();
                insert.NAME      = TxtChargesName.Text.Trim().ToUpper();

                if (TxtRate.Text == string.Empty)
                {
                    insert.PER = "0";
                }
                else
                {
                    insert.PER = TxtRate.Text.Trim();
                }
                insert.SIGN  = DdlSign.SelectedValue.Trim().ToUpper();
                insert.ACODE = DdlAccountName.SelectedValue.Trim().ToUpper();

                if (TxtHSNCode.Text == string.Empty)
                {
                    insert.HSN_NO = "0";
                }
                else
                {
                    insert.HSN_NO = TxtHSNCode.Text.Trim();
                }
                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 = CHARGES_MASLogicLayer.InsertCHARGESDetail(insert);
                    if (str.Length <= 8)
                    {
                        lblmsg.Text      = "CHARGES 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      = "CHARGES CODE ALREADY EXIST.";
                        lblmsg.ForeColor = Color.Red;
                    }
                    else
                    {
                        lblmsg.Text      = "ERROR : CHARGES DETAIL NOT SAVED";
                        lblmsg.ForeColor = Color.Red;
                    }
                }

                else
                {
                    string str = CHARGES_MASLogicLayer.UpdateCHARGESDetails(insert);
                    if (str.Contains("successfully"))
                    {
                        //INSERT CHARGE RATE
                        CHARGES_RATEMASLogicLayer InsertRate = new CHARGES_RATEMASLogicLayer();
                        InsertRate.CCODE     = HfChargesCode.Value.Trim();
                        InsertRate.COMP_CODE = HfCompCode.Value.Trim();
                        InsertRate.YRDT1     = Convert.ToDateTime(HfYearDate1.Value.Trim()).ToString("yyyy-MM-dd");

                        if (TxtGST.Text == string.Empty)
                        {
                            InsertRate.GST_RATE = "0";
                        }
                        else
                        {
                            InsertRate.GST_RATE = TxtGST.Text.Trim();
                        }

                        if (TxtCGST.Text == string.Empty)
                        {
                            InsertRate.CGST_RATE = "0";
                        }
                        else
                        {
                            InsertRate.CGST_RATE = TxtCGST.Text.Trim();
                        }

                        if (TxtSGST.Text == string.Empty)
                        {
                            InsertRate.SGST_RATE = "0";
                        }
                        else
                        {
                            InsertRate.SGST_RATE = TxtSGST.Text.Trim();
                        }

                        if (TxtIGST.Text == string.Empty)
                        {
                            InsertRate.IGST_RATE = "0";
                        }
                        else
                        {
                            InsertRate.IGST_RATE = TxtIGST.Text.Trim();
                        }
                        InsertRate.INS_USERID   = Session["USERNAME"].ToString();
                        InsertRate.INS_TERMINAL = Session["PC"].ToString();
                        InsertRate.INS_DATE     = "";
                        InsertRate.UPD_USERID   = Session["USERNAME"].ToString();
                        InsertRate.UPD_TERMINAL = Session["PC"].ToString();
                        InsertRate.UPD_DATE     = "";

                        CHARGES_RATEMASLogicLayer.UpdateCHARGES_RATEMASDetails(InsertRate);

                        lblmsg.Text      = "CHARGES DETAIL UPDATE SUCCESSFULLY.";
                        lblmsg.ForeColor = Color.Green;
                        clear();
                        FillGrid(Session["COMP_CODE"].ToString());
                        UserRights();
                    }
                    else if (str.Contains("Already"))
                    {
                        lblmsg.Text      = "CHARGES CODE ALREADY EXIST.";
                        lblmsg.ForeColor = Color.Red;
                    }
                    else
                    {
                        lblmsg.Text      = "ERROR :CHARGES DETAIL NOT SAVED";
                        lblmsg.ForeColor = Color.Red;
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }