public IQueryable <ComboBoxResult> GetProductHelpList(int Id, string term)
{
var SaleDeliveryOrderCancel = new SaleDeliveryOrderCancelHeaderService(_unitOfWork).Find(Id);
var settings = new SaleDeliveryOrderSettingsService(_unitOfWork).GetSaleDeliveryOrderSettingsForDocument(SaleDeliveryOrderCancel.DocTypeId, SaleDeliveryOrderCancel.DivisionId, SaleDeliveryOrderCancel.SiteId);
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
//string[] ProductTypes = null;
//if (!string.IsNullOrEmpty(settings.filterProductTypes)) { ProductTypes = settings.filterProductTypes.Split(",".ToCharArray()); }
//else { ProductTypes = new string[] { "NA" }; }
var list = (from p in db.ViewSaleDeliveryOrderBalance
join sol in db.SaleOrderLine on p.SaleOrderLineId equals sol.SaleOrderLineId
join prod in db.Product on sol.ProductId equals prod.ProductId
where (string.IsNullOrEmpty(term) ? 1 == 1 : prod.ProductName.ToLower().Contains(term.ToLower())) &&
p.BuyerId == SaleDeliveryOrderCancel.BuyerId && p.SiteId == CurrentSiteId && p.DivisionId == CurrentDivisionId
//&& (string.IsNullOrEmpty(settings.filterProductTypes) ? 1 == 1 : ProductTypes.Contains(p.ProductGroup.ProductTypeId.ToString()))
group prod by prod.ProductId into g
orderby g.Max(m => m.ProductName)
select new ComboBoxResult
{
text = g.Max(m => m.ProductName),
id = g.Max(m => m.ProductId.ToString()),
});
return(list);
}
public IQueryable <ComboBoxResult> GetPendingSaleDeliveryOrderHelpList(int Id, string term)
{
var SaleDeliveryOrderCancel = new SaleDeliveryOrderCancelHeaderService(_unitOfWork).Find(Id);
var settings = new SaleDeliveryOrderSettingsService(_unitOfWork).GetSaleDeliveryOrderSettingsForDocument(SaleDeliveryOrderCancel.DocTypeId, SaleDeliveryOrderCancel.DivisionId, SaleDeliveryOrderCancel.SiteId);
//string[] contraDocTypes = null;
//if (!string.IsNullOrEmpty(settings.filterContraDocTypes)) { contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray()); }
//else { contraDocTypes = new string[] { "NA" }; }
//string[] contraSites = null;
//if (!string.IsNullOrEmpty(settings.filterContraSites)) { contraSites = settings.filterContraSites.Split(",".ToCharArray()); }
//else { contraSites = new string[] { "NA" }; }
//string[] contraDivisions = null;
//if (!string.IsNullOrEmpty(settings.filterContraDivisions)) { contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray()); }
//else { contraDivisions = new string[] { "NA" }; }
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var list = (from p in db.ViewSaleDeliveryOrderBalance
where (string.IsNullOrEmpty(term) ? 1 == 1 : p.SaleDeliveryOrderNo.ToLower().Contains(term.ToLower())) && p.BuyerId == SaleDeliveryOrderCancel.BuyerId && p.BalanceQty > 0
//&& (string.IsNullOrEmpty(settings.filterContraDocTypes) ? 1 == 1 : contraDocTypes.Contains(p.DocTypeId.ToString()))
&& p.SiteId == CurrentSiteId && p.DivisionId == CurrentDivisionId
group new { p } by p.SaleDeliveryOrderHeaderId into g
orderby g.Max(m => m.p.SaleDeliveryOrderNo)
select new ComboBoxResult
{
text = g.Max(m => m.p.SaleDeliveryOrderNo),
id = g.Key.ToString(),
});
return(list);
}
public IEnumerable <SaleDeliveryOrderLineListViewModel> GetPendingSaleDeliveryOrdersForOrderCancel(int ProductId, int SaleDeliveryOrderCancelHeaderId)//Product Id
{
var SaleDeliveryOrderCancel = new SaleDeliveryOrderCancelHeaderService(_unitOfWork).Find(SaleDeliveryOrderCancelHeaderId);
var settings = new SaleDeliveryOrderSettingsService(_unitOfWork).GetSaleDeliveryOrderSettingsForDocument(SaleDeliveryOrderCancel.DocTypeId, SaleDeliveryOrderCancel.DivisionId, SaleDeliveryOrderCancel.SiteId);
//string[] contraDocTypes = null;
//if (!string.IsNullOrEmpty(settings.filterContraDocTypes)) { contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray()); }
//else { contraDocTypes = new string[] { "NA" }; }
//string[] contraSites = null;
//if (!string.IsNullOrEmpty(settings.filterContraSites)) { contraSites = settings.filterContraSites.Split(",".ToCharArray()); }
//else { contraSites = new string[] { "NA" }; }
//string[] contraDivisions = null;
//if (!string.IsNullOrEmpty(settings.filterContraDivisions)) { contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray()); }
//else { contraDivisions = new string[] { "NA" }; }
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var tem = from p in db.ViewSaleDeliveryOrderBalance
join t in db.SaleDeliveryOrderLine on p.SaleDeliveryOrderLineId equals t.SaleDeliveryOrderLineId into table
from tab in table.DefaultIfEmpty()
join sol in db.SaleOrderLine on tab.SaleOrderLineId equals sol.SaleOrderLineId
where sol.ProductId == ProductId && p.BalanceQty > 0 && p.BuyerId == SaleDeliveryOrderCancel.BuyerId
//&& (string.IsNullOrEmpty(settings.filterContraDocTypes) ? 1 == 1 : contraDocTypes.Contains(p.DocTypeId.ToString()))
&& p.SiteId == CurrentSiteId &&
p.DivisionId == CurrentDivisionId
orderby p.SaleDeliveryOrderNo
select new SaleDeliveryOrderLineListViewModel
{
DocNo = p.SaleDeliveryOrderNo,
SaleDeliveryOrderLineId = p.SaleDeliveryOrderLineId,
Dimension1Name = sol.Dimension1.Dimension1Name,
Dimension2Name = sol.Dimension2.Dimension2Name,
};
return(tem);
}
