Example #1
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                #region INSERT OPENING STOCK MASTER

                OP_STOCK_BALLogicLayer insert = new OP_STOCK_BALLogicLayer();
                insert.COMP_CODE   = HfCompCode.Value.Trim();
                insert.BRANCH_CODE = HfBranchCode.Value.Trim();
                insert.TRAN_DATE   = Convert.ToDateTime(HfTransDate.Value.Trim().ToString()).ToString("MM-dd-yyyy"); //HfTransDate.Value.Trim();
                insert.TRAN_NO     = HfTransNo.Value.Trim();
                insert.YRDT1       = Convert.ToDateTime(HfYearDate1.Value.Trim()).ToString("yyyy-MM-dd");
                insert.TRNDT       = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");//TxtTranDate.Text.Trim();
                insert.SRNO        = HfSrNo.Value.Trim();
                insert.SCODE       = HfDetailSCode.Value.Trim().ToUpper();

                if (TxtQuantity.Text == string.Empty)
                {
                    insert.QTY = "0";
                }
                else
                {
                    insert.QTY = TxtQuantity.Text.Trim();
                }

                if (TxtRate.Text == string.Empty)
                {
                    insert.RATE = "0";
                }
                else
                {
                    insert.RATE = TxtRate.Text.Trim();
                }

                if (TxtAmount.Text == string.Empty)
                {
                    insert.AMT = "0";
                }
                else
                {
                    insert.AMT = TxtAmount.Text.Trim();
                }

                insert.REMARK       = "";
                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 (btnSave.Text.Trim().ToUpper() == "SAVE")
                {
                    string str = OP_STOCK_BALLogicLayer.InsertSTOCK_OP_BALDetail(insert);
                    if (str.Contains("successfully"))
                    {
                        lblmsg.Text      = "STOCK OPENING BALANCE 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      = "STOCK OPENING BALANCE MASTER ALREADY EXIST.";
                        lblmsg.ForeColor = Color.Red;
                    }
                    else
                    {
                        lblmsg.Text      = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED";
                        lblmsg.ForeColor = Color.Red;
                    }
                }
                else
                {
                    string str = OP_STOCK_BALLogicLayer.UpdateBRAND_COMPLAIN_MASDetail(insert);
                    if (str.Contains("successfully"))
                    {
                        lblmsg.Text      = "STOCK OPENING BALANCE DETAIL UPDATE SUCCESSFULLY.";
                        lblmsg.ForeColor = Color.Green;
                        clear();
                        FillGrid(Session["COMP_CODE"].ToString());
                        UserRights();
                    }
                    else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
                    {
                        lblmsg.Text      = "STOCK OPENING BALANCE MASTER ALREADY EXIST.";
                        lblmsg.ForeColor = Color.Red;
                    }
                    else
                    {
                        lblmsg.Text      = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED";
                        lblmsg.ForeColor = Color.Red;
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }