Пример #1
0
 protected void txtbarcode_TextChanged(object sender, EventArgs e)
 {
     try
     {
         if (hiddenCompanyType.Value.Trim() == "CENTRAL")
         {
             Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString());
             if (buyCentral != null)
             {
                 txtBalanceQty.Text = Convert.ToString(buyCentral.BalanceQuanity);
             }
             else
             {
                 txtBalanceQty.Text = "0";
             }
         }
         else
         {
             Inv_Buy invBuy = buyBll.GetBuyByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString());
             if (invBuy != null)
             {
                 txtBalanceQty.Text = Convert.ToString(invBuy.BalanceQuanity);
             }
             else
             {
                 txtBalanceQty.Text = "0";
             }
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
     }
 }
Пример #2
0
 internal int Update(int Id, Inv_Buy inv_BuyObj)
 {
     try
     {
         Inv_Buy buyObj = _context.Inv_Buy.First(x => x.Id == Id);
         buyObj.ChallanNo       = inv_BuyObj.ChallanNo;
         buyObj.CompanyId       = inv_BuyObj.CompanyId;
         buyObj.CompanyCode     = inv_BuyObj.CompanyCode;
         buyObj.CompanyName     = inv_BuyObj.CompanyName;
         buyObj.BarCode         = inv_BuyObj.BarCode;
         buyObj.ProductId       = inv_BuyObj.ProductId;
         buyObj.ProductGroup    = inv_BuyObj.ProductGroup;
         buyObj.ProductName     = inv_BuyObj.ProductName;
         buyObj.Brand           = inv_BuyObj.Brand;
         buyObj.StyleSize       = inv_BuyObj.StyleSize;
         buyObj.FloorName       = inv_BuyObj.FloorName;
         buyObj.UnitName        = inv_BuyObj.UnitName;
         buyObj.ReceiveQuantity = inv_BuyObj.ReceiveQuantity;
         buyObj.CPU             = inv_BuyObj.CPU;
         buyObj.RPU             = inv_BuyObj.RPU;
         buyObj.ExpireDate      = inv_BuyObj.ExpireDate;
         buyObj.BalanceQuanity  = inv_BuyObj.BalanceQuanity;
         buyObj.PurchaseDate    = inv_BuyObj.PurchaseDate;
         buyObj.EditDate        = inv_BuyObj.EditDate;
         buyObj.OCode           = inv_BuyObj.OCode;
         _context.SaveChanges();
         return(1);
     }
     catch (Exception)
     {
         throw;
     }
 }
Пример #3
0
 public Inv_Buy GetBuy_DPT_Return(string Barcode, string StoreCode, string challanNo)
 {
     try
     {
         Inv_Buy buy = _context.Inv_Buy.Where(bc => bc.BarCode == Barcode && bc.Store_Code == StoreCode && bc.ChallanNo == challanNo).FirstOrDefault <Inv_Buy>();
         return(buy);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #4
0
 internal int Insert(Inv_Buy inv_BuyObj)
 {
     try
     {
         _context.Inv_Buy.AddObject(inv_BuyObj);
         _context.SaveChanges();
         return(1);
     }
     catch (Exception)
     {
         throw;
     }
 }
Пример #5
0
        internal int Update_Return_DptWise(int Id, string barcode, string StoreCode, string challanNo, Inv_Buy Inv_BuyObj)
        {
            try
            {
                Inv_Buy buyCentralObj = _context.Inv_Buy.First(x => x.Id == Id && x.BarCode == barcode && x.ChallanNo == challanNo && x.Store_Code == StoreCode);

                buyCentralObj.BalanceQuanity = Inv_BuyObj.BalanceQuanity;
                _context.SaveChanges();
                return(1);
            }
            catch (Exception)
            {
                throw;
            }
        }
Пример #6
0
 public Inv_Buy GetBuyBarcodeAndComanyCode(string Barcode, string CompanyCode)
 {
     using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities())
     {
         try
         {
             Inv_Buy buy = ctx.Inv_Buy.Where(bc => bc.BarCode == Barcode && bc.CompanyCode == CompanyCode).FirstOrDefault <Inv_Buy>();
             return(buy);
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #7
0
 internal int Update(Inv_Buy inv_BuyObj, int Id)
 {
     return(buyDal.Update(Id, inv_BuyObj));
 }
Пример #8
0
 internal int Insert(Inv_Buy inv_BuyObj)
 {
     return(buyDal.Insert(inv_BuyObj));
 }
Пример #9
0
        public Inv_Buy GetBuyByCompanyCodeAndBarcode(string barcode, string CompanyCode)
        {
            Inv_Buy buy = buyDal.GetBuyBarcodeAndComanyCode(barcode, CompanyCode);

            return(buy);
        }
Пример #10
0
 internal int Update_Return_DptWise(int Id, string barcode, string StoreCode, string challanNo, Inv_Buy Inv_BuyObj)
 {
     return(buyCentralDal.Update_Return_DptWise(Id, barcode, StoreCode, challanNo, Inv_BuyObj));
 }
        protected void BtnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string challanNo = txtChalanNo.Text.Trim();

                //string CType = hiddenCompanyType.Value;
                string CType = "CENTRAL";
                if (CType == "CENTRAL")
                {
                    Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString());
                    if (buyCentral == null)
                    { // Insert New
                        Inv_BuyCentral newBuyCentral = new Inv_BuyCentral();
                        newBuyCentral.ChallanNo    = txtChalanNo.Text;
                        newBuyCentral.CompanyId    = Convert.ToInt32(ddlCompanyCode.SelectedValue);
                        newBuyCentral.CompanyCode  = HiddenCompanyCode.Value;
                        newBuyCentral.CompanyName  = HiddenCompanyName.Value;
                        newBuyCentral.BarCode      = hdnBarCode.Value;
                        newBuyCentral.ProductId    = int.Parse(hdnBarCode.Value.ToString());
                        newBuyCentral.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
                        newBuyCentral.ProductName  = txtProduct.Text;
                        newBuyCentral.Brand        = txtBrand.Text;

                        //newBuyCentral.StyleSize = rchallan.StyleSize;
                        //newBuyCentral.FloorName = rchallan.FloorName;
                        newBuyCentral.UnitName        = txtUnit.Text;
                        newBuyCentral.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
                        //newBuyCentral.CPU = rchallan.CPU;
                        //newBuyCentral.RPU = rchallan.RPU;
                        //newBuyCentral.ExpireDate = rchallan.ExpireDate;
                        //newBuyCentral.BalanceQuanity = rchallan.BalanceQty;
                        try
                        {
                            newBuyCentral.PurchaseDate = DateTime.Parse(txtDate.Text);
                        }
                        catch
                        {
                            newBuyCentral.PurchaseDate = DateTime.Today;
                        }

                        newBuyCentral.EditDate = DateTime.Now;
                        newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
                        newBuyCentral.OCode    = ((SessionUser)Session["SessionUser"]).OCode;
                        buyCentralBll.Insert(newBuyCentral);
                    }
                    else
                    {
                        buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim());
                        //buyCentral.CPU = rchallan.CPU;
                        //buyCentral.RPU = rchallan.RPU;
                        //buyCentral.ExpireDate = rchallan.ExpireDate;
                        buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim());
                        buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id));
                    }

                    Inv_RChallan rchallan = new Inv_RChallan();
                    rchallan.ChallanNo    = txtChalanNo.Text;
                    rchallan.CompanyId    = Convert.ToInt32(ddlCompanyCode.SelectedValue);
                    rchallan.CompanyCode  = HiddenCompanyCode.Value;
                    rchallan.CompanyName  = HiddenCompanyName.Value;
                    rchallan.Barcode      = hdnBarCode.Value;
                    rchallan.ProductId    = int.Parse(hdnBarCode.Value.ToString());
                    rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
                    rchallan.ProductName  = txtProduct.Text;
                    rchallan.Brand        = txtBrand.Text;
                    //rchallan.StyleSize = rchallan.StyleSize;
                    //rchallan.FloorName = rchallan.FloorName;
                    rchallan.UnitName        = txtUnit.Text;
                    rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
                    //rchallan.CPU = rchallan.CPU;
                    //rchallan.RPU = rchallan.RPU;
                    //rchallan.ExpireDate = rchallan.ExpireDate;
                    //rchallan.BalanceQuanity = rchallan.BalanceQty;
                    try
                    {
                        rchallan.PurchaseDate = DateTime.Parse(txtDate.Text);
                    }
                    catch
                    {
                        rchallan.PurchaseDate = DateTime.Today;
                    }

                    rchallan.EditDate = DateTime.Now;
                    rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
                    rchallan.Ocode    = ((SessionUser)Session["SessionUser"]).OCode;
                    rChallanBll.Insert(rchallan);
                    PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text);
                    LoadPurchaseOrders();
                    // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
                    GenerateReport();
                    ClearForm();
                }
                else // obsolete // hiddenCompanyType = General
                {
                    Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString());

                    if (buy == null)
                    { // Insert New
                        Inv_Buy invBuy = new Inv_Buy();

                        invBuy.ChallanNo    = txtChalanNo.Text;
                        invBuy.CompanyId    = Convert.ToInt32(ddlCompanyCode.SelectedValue);
                        invBuy.CompanyCode  = HiddenCompanyCode.Value;
                        invBuy.CompanyName  = HiddenCompanyName.Value;
                        invBuy.BarCode      = hdnBarCode.Value;
                        invBuy.ProductId    = int.Parse(hdnBarCode.Value.ToString());
                        invBuy.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
                        invBuy.ProductName  = txtProduct.Text;
                        invBuy.Brand        = txtBrand.Text;
                        //newBuyCentral.StyleSize = rchallan.StyleSize;
                        //newBuyCentral.FloorName = rchallan.FloorName;
                        invBuy.UnitName        = txtUnit.Text;
                        invBuy.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
                        //newBuyCentral.CPU = rchallan.CPU;
                        //newBuyCentral.RPU = rchallan.RPU;
                        //newBuyCentral.ExpireDate = rchallan.ExpireDate;
                        //newBuyCentral.BalanceQuanity = rchallan.BalanceQty;
                        try
                        {
                            invBuy.PurchaseDate = DateTime.Parse(txtDate.Text);
                        }
                        catch
                        {
                            invBuy.PurchaseDate = DateTime.Today;
                        }

                        invBuy.EditDate = DateTime.Now;
                        invBuy.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
                        invBuy.OCode    = ((SessionUser)Session["SessionUser"]).OCode;
                        buyBll.Insert(invBuy);
                    }
                    else
                    {
                        buy.BalanceQuanity = buy.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim());
                        //buy.CPU = rchallan.CPU;
                        //buy.RPU = rchallan.RPU;
                        //buy.ExpireDate = rchallan.ExpireDate;
                        buy.ReceiveQuantity = buy.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim());
                        buyBll.Update(buy, Convert.ToInt32(buy.Id));
                    }

                    Inv_RChallan rchallan = new Inv_RChallan();
                    rchallan.ChallanNo    = txtChalanNo.Text;
                    rchallan.CompanyId    = Convert.ToInt32(ddlCompanyCode.SelectedValue);
                    rchallan.CompanyCode  = HiddenCompanyCode.Value;
                    rchallan.CompanyName  = HiddenCompanyName.Value;
                    rchallan.Barcode      = hdnBarCode.Value;
                    rchallan.ProductId    = int.Parse(hdnBarCode.Value.ToString());
                    rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString());
                    rchallan.ProductName  = txtProduct.Text;
                    rchallan.Brand        = txtBrand.Text;
                    //rchallan.StyleSize = rchallan.StyleSize;
                    //rchallan.FloorName = rchallan.FloorName;
                    rchallan.UnitName        = txtUnit.Text;
                    rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim());
                    //rchallan.CPU = rchallan.CPU;
                    //rchallan.RPU = rchallan.RPU;
                    //rchallan.ExpireDate = rchallan.ExpireDate;
                    //rchallan.BalanceQuanity = rchallan.BalanceQty;
                    try
                    {
                        rchallan.PurchaseDate = DateTime.Parse(txtDate.Text);
                    }
                    catch
                    {
                        rchallan.PurchaseDate = DateTime.Today;
                    }

                    rchallan.EditDate = DateTime.Now;
                    rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
                    rchallan.Ocode    = ((SessionUser)Session["SessionUser"]).OCode;
                    rChallanBll.Insert(rchallan);
                    PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text);
                    LoadPurchaseOrders();
                    //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
                }
                ClearForm();
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }
Пример #12
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                List <Inv_RChallan_Temp> staticPurchaseList = new List <Inv_RChallan_Temp>();
                string challanNo = txtChallanNo.Text.Trim();
                staticPurchaseList = rChallanBll.GetTempRChalan(((SessionUser)Session["SessionUser"]).OCode, challanNo);
                //staticPurchaseList = rChallanBll.GetTempRChalan("8989", challanNo);

                if (hiddenCompanyType.Value.Trim() == "CENTRAL")
                {
                    foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
                    {
                        Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode);
                        if (buyCentral == null)
                        {
                            // Insert New
                            Inv_BuyCentral newBuyCentral = new Inv_BuyCentral();
                            newBuyCentral.ChallanNo       = rchallan.ChallanNo;
                            newBuyCentral.CompanyId       = rchallan.CompanyId;
                            newBuyCentral.CompanyCode     = rchallan.CompanyCode;
                            newBuyCentral.CompanyName     = rchallan.CompanyName;
                            newBuyCentral.BarCode         = rchallan.BarCode;
                            newBuyCentral.ProductId       = Convert.ToInt32(rchallan.ProductId);
                            newBuyCentral.ProductGroup    = rchallan.ProductGroup;
                            newBuyCentral.ProductName     = rchallan.ProductName;
                            newBuyCentral.Brand           = rchallan.Brand;
                            newBuyCentral.StyleSize       = rchallan.StyleSize;
                            newBuyCentral.FloorName       = rchallan.FloorName;
                            newBuyCentral.UnitName        = rchallan.UnitName;
                            newBuyCentral.ReceiveQuantity = rchallan.ReceiveQuantity;
                            newBuyCentral.CPU             = rchallan.CPU;
                            newBuyCentral.RPU             = rchallan.RPU;
                            newBuyCentral.ExpireDate      = rchallan.ExpireDate;
                            newBuyCentral.BalanceQuanity  = rchallan.BalanceQuanity;
                            newBuyCentral.PurchaseDate    = rchallan.PurchaseDate;
                            newBuyCentral.EditDate        = rchallan.EditDate;
                            newBuyCentral.OCode           = rchallan.OCode;
                            newBuyCentral.OrderNo         = rchallan.OrderNo;
                            buyCentralBll.Insert(newBuyCentral);
                        }

                        else
                        {
                            buyCentral.BalanceQuanity  = buyCentral.BalanceQuanity + rchallan.ReceiveQuantity;
                            buyCentral.CPU             = rchallan.CPU;
                            buyCentral.RPU             = rchallan.RPU;
                            buyCentral.ExpireDate      = rchallan.ExpireDate;
                            buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + rchallan.ReceiveQuantity;
                            //buyCentral.Id = Convert.ToInt16(hidId.Value);
                            buyCentralBll.Update(buyCentral, buyCentral.Id);
                        }

                        rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
                        rChallanBll.DeleteTempChalanById(rchallan.Id);

                        //string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
                        //string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
                        //string Company_Code = "CMP201506051";
                        //string ModuleType = "Inventory";
                        //string VoucherType = "PAYMENT";

                        //rChallanBll.Enter_VoucherDetails(OCODE, Company_Code,Edit_User, ModuleType, VoucherType, ConvertTmpToRchallan(rchallan));

                        //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
                        gvPurchase.DataSource = null;
                        gvPurchase.DataBind();
                        ddlChalanNo.Items.Clear();
                    }
                    ClearForm();
                }

                else // hiddenCompanyType = General
                {
                    foreach (Inv_RChallan_Temp rchallan in staticPurchaseList)
                    {
                        Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode);

                        if (buy == null)
                        { // Insert New
                            Inv_Buy invBuy = new Inv_Buy();
                            invBuy.ChallanNo       = rchallan.ChallanNo;
                            invBuy.CompanyId       = rchallan.CompanyId;
                            invBuy.CompanyCode     = rchallan.CompanyCode;
                            invBuy.CompanyName     = rchallan.CompanyName;
                            invBuy.BarCode         = rchallan.BarCode;
                            invBuy.ProductId       = Convert.ToInt32(rchallan.ProductId);
                            invBuy.ProductGroup    = rchallan.ProductGroup;
                            invBuy.ProductName     = rchallan.ProductName;
                            invBuy.Brand           = rchallan.Brand;
                            invBuy.StyleSize       = rchallan.StyleSize;
                            invBuy.FloorName       = rchallan.FloorName;
                            invBuy.UnitName        = rchallan.UnitName;
                            invBuy.ReceiveQuantity = rchallan.ReceiveQuantity;
                            invBuy.CPU             = rchallan.CPU;
                            invBuy.RPU             = rchallan.RPU;
                            invBuy.ExpireDate      = rchallan.ExpireDate;
                            invBuy.BalanceQuanity  = rchallan.BalanceQuanity;
                            invBuy.PurchaseDate    = rchallan.PurchaseDate;
                            invBuy.DeliveryQty     = Convert.ToInt32(rchallan.DeliveryQty);
                            invBuy.EditDate        = rchallan.EditDate;
                            invBuy.OCode           = rchallan.OCode;
                            invBuy.OrderNo         = rchallan.OrderNo;
                            buyBll.Insert(invBuy);
                        }
                        else
                        {
                            buy.BalanceQuanity  = buy.BalanceQuanity + rchallan.ReceiveQuantity;
                            buy.CPU             = rchallan.CPU;
                            buy.RPU             = rchallan.RPU;
                            buy.ExpireDate      = rchallan.ExpireDate;
                            buy.ReceiveQuantity = buy.ReceiveQuantity + rchallan.ReceiveQuantity;
                            int Id = Convert.ToInt16(hidId.Value);
                            buyBll.Update(buy, Id);
                        }

                        rChallanBll.Insert(ConvertTmpToRchallan(rchallan));
                        rChallanBll.DeleteTempChalanById(rchallan.Id);
                        //  lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>";
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true);
                        ddlChalanNo.Items.Clear();
                    }
                    ClearForm();
                }


                // End of IF CENTRAL OR GENERAL
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }
        protected void btnConfirm_Click(object sender, EventArgs e)
        {
            try
            {
                DateTime date = DateTime.Today;
                GetNewChallanNo(date);
                string OCODE     = ((SessionUser)Session["SessionUser"]).OCode;
                string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
                Guid   UserId    = ((SessionUser)Session["SessionUser"]).UserId;

                List <Inv_Return_Temp> ReturnList = new List <Inv_Return_Temp>();
                string challanNo = txtChalanNoReturn.Text.Trim();
                ReturnList = rChallanBll.GetTempReturn(((SessionUser)Session["SessionUser"]).OCode, UserId);

                foreach (Inv_Return_Temp rchallan in ReturnList)
                {
                    if (ddlStoreName.SelectedValue == "CNT")
                    {
                        Inv_BuyCentral buyCentral = _BuyCentral.GetBuyForReturn(rchallan.BarCode, rchallan.Store_Code);

                        if (buyCentral != null)
                        {
                            // Kamruzzaman...........
                            Inv_Return _return = new Inv_Return();
                            _return.ChallanNo          = txtChalanNoReturn.Text;
                            _return.ChallanNo_To       = rchallan.ChallanNo_To;
                            _return.BarCode            = rchallan.BarCode;
                            _return.ProductId          = Convert.ToInt32(rchallan.ProductId);
                            _return.ProductGroup       = rchallan.ProductGroup;
                            _return.ProductName        = rchallan.ProductName;
                            _return.Remarks            = rchallan.Remarks;
                            _return.Brand              = rchallan.Brand;
                            _return.StyleSize          = rchallan.StyleSize;
                            _return.FloorName          = rchallan.FloorName;
                            _return.UnitName           = rchallan.UnitName;
                            _return.ReceiveQuantity    = rchallan.ReceiveQuantity;
                            _return.CPU                = rchallan.CPU;
                            _return.RPU                = rchallan.RPU;
                            _return.ExpireDate         = rchallan.ExpireDate;
                            _return.BalanceQuanity     = rchallan.BalanceQuanity;
                            _return.PurchaseDate       = rchallan.PurchaseDate;
                            _return.EditDate           = rchallan.EditDate;
                            _return.OCode              = rchallan.OCode;
                            _return.Store_Code         = rchallan.Store_Code;
                            _return.SupplierReturnQty  = rchallan.SupplierReturnQty;
                            _return.SupplierCode       = rchallan.SupplierCode;
                            _return.CurrentCompanyCode = rchallan.CurrentCompanyCode;
                            _return.PurchaseDate       = rchallan.PurchaseDate;
                            _return.EditDate           = DateTime.Today;
                            _return.EditUser           = rchallan.EditUser;
                            _return.OldCompanyCode     = rchallan.OldCompanyCode;
                            _return.ReturnDate         = DateTime.Today;
                            _return.ERetQty            = rchallan.ERetQty;
                            _return.OldCompanyName     = rchallan.OldCompanyName;
                            _return.OldCompanyId       = rchallan.OldCompanyId;
                            _return.ReturnType         = "StoreToCentral";
                            _return.EID                = rchallan.EID;
                            _return.DPT_CODE           = rchallan.DPT_CODE;
                            _return.ProgramId          = rchallan.ProgramId;

                            _BuyCentral.InsertReturn(_return);

                            // buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty;
                            buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ERetQty;
                            //buyCentral.Id = Convert.ToInt16(hidId.Value);
                            // _BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy);

                            _BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral);

                            _BuyCentral.DeleteReturn_Temp(rchallan.Id);
                        }

                        else
                        {
                        }
                    }
                    else
                    {
                        Inv_Buy buy = _BuyCentral.GetBuy_DPT_Return(rchallan.BarCode, rchallan.Store_Code, rchallan.ChallanNo_To);

                        if (buy != null)
                        {
                            // Kamruzzaman...........
                            Inv_Return _return = new Inv_Return();
                            _return.ChallanNo          = txtChalanNoReturn.Text;
                            _return.ChallanNo_To       = rchallan.ChallanNo_To;
                            _return.BarCode            = rchallan.BarCode;
                            _return.ProductId          = Convert.ToInt32(rchallan.ProductId);
                            _return.ProductGroup       = rchallan.ProductGroup;
                            _return.ProductName        = rchallan.ProductName;
                            _return.Brand              = rchallan.Brand;
                            _return.StyleSize          = rchallan.StyleSize;
                            _return.FloorName          = rchallan.FloorName;
                            _return.UnitName           = rchallan.UnitName;
                            _return.ReceiveQuantity    = rchallan.ReceiveQuantity;
                            _return.CPU                = rchallan.CPU;
                            _return.Remarks            = rchallan.Remarks;
                            _return.RPU                = rchallan.RPU;
                            _return.ExpireDate         = rchallan.ExpireDate;
                            _return.BalanceQuanity     = rchallan.BalanceQuanity;
                            _return.PurchaseDate       = rchallan.PurchaseDate;
                            _return.EditDate           = rchallan.EditDate;
                            _return.OCode              = rchallan.OCode;
                            _return.Store_Code         = rchallan.Store_Code;
                            _return.SupplierReturnQty  = rchallan.SupplierReturnQty;
                            _return.SupplierCode       = rchallan.SupplierCode;
                            _return.CurrentCompanyCode = rchallan.CurrentCompanyCode;
                            _return.PurchaseDate       = rchallan.PurchaseDate;
                            _return.EditDate           = DateTime.Today;
                            _return.EditUser           = rchallan.EditUser;
                            _return.OldCompanyCode     = rchallan.OldCompanyCode;
                            _return.ReturnDate         = DateTime.Today;
                            _return.ERetQty            = rchallan.ERetQty;
                            _return.OldCompanyName     = rchallan.OldCompanyName;
                            _return.OldCompanyId       = rchallan.OldCompanyId;
                            _return.ReturnType         = "StoreToStore";
                            _return.EID                = rchallan.EID;
                            _return.DPT_CODE           = rchallan.DPT_CODE;
                            _return.ProgramId          = rchallan.ProgramId;

                            _BuyCentral.InsertReturn(_return);

                            // buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty;
                            buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ERetQty;
                            //buyCentral.Id = Convert.ToInt16(hidId.Value);
                            _BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy);

                            // _BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral);

                            _BuyCentral.DeleteReturn_Temp(rchallan.Id);
                        }

                        else
                        {
                        }
                    }
                }

                grdTransfer.DataSource = null;
                grdTransfer.DataBind();
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Returned Successfully')", true);
                Response.Redirect(Request.RawUrl);
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }