public JsonResult SetSingleSaleOrderLine(int Ids)
        {
            ComboBoxResult SaleOrderJson = new ComboBoxResult();

            var SaleOrderLine = from L in db.SaleOrderLine
                                join H in db.SaleOrderHeader on L.SaleOrderHeaderId equals H.SaleOrderHeaderId into SaleOrderHeaderTable
                                from SaleOrderHeaderTab in SaleOrderHeaderTable.DefaultIfEmpty()
                                where L.SaleOrderLineId == Ids
                                select new
            {
                SaleOrderLineId = L.SaleOrderLineId,
                SaleOrderNo     = L.Product.ProductName
            };

            SaleOrderJson.id   = SaleOrderLine.FirstOrDefault().ToString();
            SaleOrderJson.text = SaleOrderLine.FirstOrDefault().SaleOrderNo;

            return(Json(SaleOrderJson));
        }
Exemplo n.º 2
0
        public ActionResult SaleOrderCancelExcelImport()
        {
            int    i        = 0;
            var    file     = Request.Files[0];
            string filePath = Request.MapPath(ConfigurationManager.AppSettings["ExcelFilePath"] + file.FileName);

            file.SaveAs(filePath);
            var excel = new ExcelQueryFactory();

            //excel.FileName =ConfigurationManager.AppSettings["ExcelFilePath"]; //  @"C:\Users\guru\Downloads\PO.xls"; //TODO: Rempve hardcode
            excel.FileName = filePath;
            var SaleOrderCancelRecordList = from c in excel.Worksheet <SaleOrderCancelExcel>() select c;

            StringBuilder strSaleOrder         = new StringBuilder();
            StringBuilder strSaleOrderCancelNo = new StringBuilder();

            StringBuilder strOtherValidation = new StringBuilder();

            foreach (var SaleOrderCancelRecord in SaleOrderCancelRecordList)
            {
                if (_SaleOrderCancelHeaderService.FindByDocNo(SaleOrderCancelRecord.SaleOrderCancelNo) != null)
                {
                    if (!strSaleOrderCancelNo.ToString().Contains("" + SaleOrderCancelRecord.SaleOrderCancelNo))
                    {
                        strSaleOrderCancelNo.Append(" " + SaleOrderCancelRecord.SaleOrderCancelNo + ",");
                    }
                }

                if (_SaleOrderHeaderService.FindByDocNo(SaleOrderCancelRecord.SaleOrderNo) == null)
                {
                    if (!strSaleOrder.ToString().Contains("" + SaleOrderCancelRecord.SaleOrderNo))
                    {
                        strSaleOrder.Append(" " + SaleOrderCancelRecord.SaleOrderNo + ",");
                    }
                }


                //SaleOrderLine pol = _SaleOrderLineService.GetSaleOrderLineForSaleOrderAndProduct(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
                decimal balqty = _SaleOrderCancelLineService.GetSaleOrderBalanceQty(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
                if (balqty != null)
                {
                    i = i + 1;
                    if (balqty < SaleOrderCancelRecord.Quantity)
                    {
                        strOtherValidation.Append("SaleOrder Cancel qty is greater than Order qty for Sale Order " + SaleOrderCancelRecord.SaleOrderNo + " and Product " + SaleOrderCancelRecord.Product + "." + Environment.NewLine);
                    }
                }
            }


            if (!string.IsNullOrEmpty(strSaleOrderCancelNo.ToString()) || !string.IsNullOrEmpty(strSaleOrder.ToString()) || !string.IsNullOrEmpty(strOtherValidation.ToString()))
            {
                if (string.IsNullOrEmpty(strSaleOrderCancelNo.ToString()))
                {
                    ViewBag.SaleOrderCancelNo = null;
                }
                else
                {
                    ViewBag.SaleOrderCancelNo = strSaleOrderCancelNo;
                }

                if (string.IsNullOrEmpty(strSaleOrder.ToString()))
                {
                    ViewBag.SaleOrder = null;
                }
                else
                {
                    ViewBag.SaleOrder = strSaleOrder;
                }

                if (string.IsNullOrEmpty(strOtherValidation.ToString()))
                {
                    ViewBag.OtherValidation = null;
                }
                else
                {
                    ViewBag.OtherValidation = strOtherValidation;
                }

                return(View());
            }
            else
            {
                string previousRecord = null;
                int    count          = 0;

                SaleOrderCancelHeader Temp_SaleOrderCancelHeader = new SaleOrderCancelHeader();

                foreach (var SaleOrderCancelRecord in SaleOrderCancelRecordList)
                {
                    //Object for SaleOrderCancelLine Model
                    SaleOrderCancelLine sl = new SaleOrderCancelLine();
                    sl.CreatedBy               = User.Identity.Name;
                    sl.CreatedDate             = DateTime.Now;
                    sl.ModifiedBy              = User.Identity.Name;
                    sl.ModifiedDate            = DateTime.Now;
                    sl.SaleOrderCancelHeaderId = Temp_SaleOrderCancelHeader.SaleOrderCancelHeaderId;
                    sl.SaleOrderLineId         = _SaleOrderCancelLineService.GetSaleOrderLineIdForProductandSaleOrderDocNo(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
                    sl.Qty = SaleOrderCancelRecord.Quantity;


                    if (count == 0 || SaleOrderCancelRecord.SaleOrderCancelNo != previousRecord)
                    {
                        //Object for SaleOrderCancelHeader Model

                        SaleOrderCancelHeader sh = new SaleOrderCancelHeader();
                        sh.CreatedBy    = User.Identity.Name;
                        sh.CreatedDate  = DateTime.Now;
                        sh.DivisionId   = (int)System.Web.HttpContext.Current.Session["DivisionId"];
                        sh.SiteId       = (int)System.Web.HttpContext.Current.Session["SiteId"];
                        sh.DocDate      = SaleOrderCancelRecord.CancelDate;
                        sh.DocNo        = SaleOrderCancelRecord.SaleOrderCancelNo;
                        sh.DocTypeId    = new DocumentTypeService(_unitOfWork).FindByName(TransactionDocCategoryConstants.SaleOrderCancel).DocumentTypeId;
                        sh.ModifiedBy   = User.Identity.Name;
                        sh.ModifiedDate = DateTime.Now;
                        sh.Remark       = SaleOrderCancelRecord.Remark;
                        sh.ReasonId     = new ReasonService(_unitOfWork).FindByName(TransactionDocCategoryConstants.SaleOrderCancel).ReasonId;

                        int BuyerId = (from L in db.SaleOrderLine
                                       join H in db.SaleOrderHeader on L.SaleOrderHeaderId equals H.SaleOrderHeaderId into SaleOrderHeaderTable
                                       from SaleOrderHeaderTab in SaleOrderHeaderTable.DefaultIfEmpty()
                                       where L.SaleOrderLineId == sl.SaleOrderLineId
                                       select new { BuyerId = SaleOrderHeaderTab.SaleToBuyerId }).FirstOrDefault().BuyerId;
                        sh.BuyerId = BuyerId;


                        _SaleOrderCancelHeaderService.Create(sh);
                        Temp_SaleOrderCancelHeader = sh;
                    }


                    _SaleOrderCancelLineService.Create(sl);

                    count++;
                    previousRecord = SaleOrderCancelRecord.SaleOrderCancelNo;

                    //Saving DB::
                    try
                    {
                        _unitOfWork.Save();
                    }

                    catch (Exception ex)
                    {
                        string message = _exception.HandleException(ex);
                        ModelState.AddModelError("", message);
                        throw ex;
                    }
                }

                return(View("Sucess"));
            }
        }
        public decimal GetSaleOrderBalanceQty(string SaleOrderNo, string Product)
        {
            //return (
            //        from p in db.SaleOrderLine
            //        join bal in db.ViewSaleOrderBalance on p.SaleOrderLineId equals bal.SaleOrderLineId
            //        where p.SaleOrderHeader.DocNo == SaleOrderNo & p.Product.ProductName == Product
            //        select bal.BalanceQty
            //    ).FirstOrDefault();

            var SaleOrderLine1 = from L in db.SaleOrderLine
                                 join H in db.SaleOrderHeader on L.SaleOrderHeaderId equals H.SaleOrderHeaderId into SaleOrderHeaderTable
                                 from SaleOrderHeaderTab in SaleOrderHeaderTable.DefaultIfEmpty()
                                 join P in db.Product on L.ProductId equals P.ProductId into ProductTable
                                 from ProductTab in ProductTable.DefaultIfEmpty()
                                 where SaleOrderHeaderTab.DocNo == SaleOrderNo && ProductTab.ProductName == Product
                                 select new
            {
                SaleOrderLineId = L.SaleOrderLineId
            };

            var SaleOrderLine = (from L in db.SaleOrderLine
                                 join H in db.SaleOrderHeader on L.SaleOrderHeaderId equals H.SaleOrderHeaderId into SaleOrderHeaderTable
                                 from SaleOrderHeaderTab in SaleOrderHeaderTable.DefaultIfEmpty()
                                 join P in db.Product on L.ProductId equals P.ProductId into ProductTable
                                 from ProductTab in ProductTable.DefaultIfEmpty()
                                 where SaleOrderHeaderTab.DocNo == SaleOrderNo && ProductTab.ProductName == Product
                                 select new
            {
                SaleOrderLineId = L.SaleOrderLineId
            }).FirstOrDefault();



            if (SaleOrderLine != null)
            {
                try
                {
                    int SaleOrderLineId = SaleOrderLine.SaleOrderLineId;

                    var BalanceList = from L in db.ViewSaleOrderBalanceForCancellation
                                      join P in db.Product on L.ProductId equals P.ProductId
                                      where L.SaleOrderLineId == SaleOrderLineId
                                      select new
                    {
                        BalanceQty = L.BalanceQty
                    };

                    if (BalanceList != null)
                    {
                        return(BalanceList.FirstOrDefault().BalanceQty);
                    }
                    else
                    {
                        return(0);
                    }
                }
                catch (Exception e)
                {
                    string str = e.Message;
                    return(0);
                }
            }
            else
            {
                return(0);
            }
        }