public IEnumerable <ComboBoxResult> GetSaleInvoiceHelpListForProduct(int Id, string term)
{
var SaleInvoiceReturnHeader = new SaleInvoiceReturnHeaderService(_unitOfWork).Find(Id);
var settings = new SaleInvoiceSettingService(_unitOfWork).GetSaleInvoiceSettingForDocument(SaleInvoiceReturnHeader.DocTypeId, SaleInvoiceReturnHeader.DivisionId, SaleInvoiceReturnHeader.SiteId);
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"];
return(from VSib in db.ViewSaleInvoiceBalance
join L in db.SaleInvoiceLine on VSib.SaleInvoiceLineId equals L.SaleInvoiceLineId into SaleInvoiceLineTable
from SaleInvoiceLineTab in SaleInvoiceLineTable.DefaultIfEmpty()
where VSib.BalanceQty > 0 && SaleInvoiceLineTab.SaleInvoiceHeader.SaleToBuyerId == SaleInvoiceReturnHeader.BuyerId &&
(string.IsNullOrEmpty(settings.filterContraSites) ? VSib.SiteId == CurrentSiteId : contraSites.Contains(VSib.SiteId.ToString())) &&
(string.IsNullOrEmpty(settings.filterContraDivisions) ? VSib.DivisionId == CurrentDivisionId : contraDivisions.Contains(VSib.DivisionId.ToString())) &&
(string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.SaleInvoiceHeader.DocNo.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.SaleInvoiceHeader.DocType.DocumentTypeShortName.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.Product.ProductName.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.Dimension1.Dimension1Name.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.Dimension2.Dimension2Name.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.Dimension3.Dimension3Name.ToLower().Contains(term.ToLower()) ||
string.IsNullOrEmpty(term) ? 1 == 1 : SaleInvoiceLineTab.Dimension4.Dimension4Name.ToLower().Contains(term.ToLower())
)
select new ComboBoxResult
{
id = VSib.SaleInvoiceLineId.ToString(),
text = SaleInvoiceLineTab.SaleInvoiceHeader.DocType.DocumentTypeShortName + "-" + SaleInvoiceLineTab.SaleInvoiceHeader.DocNo,
TextProp1 = "Balance :" + VSib.BalanceQty,
TextProp2 = "Date :" + SaleInvoiceLineTab.SaleInvoiceHeader.DocDate,
AProp1 = SaleInvoiceLineTab.Product.ProductName,
AProp2 = ((SaleInvoiceLineTab.Dimension1.Dimension1Name == null) ? "" : SaleInvoiceLineTab.Dimension1.Dimension1Name) +
((SaleInvoiceLineTab.Dimension2.Dimension2Name == null) ? "" : "," + SaleInvoiceLineTab.Dimension2.Dimension2Name) +
((SaleInvoiceLineTab.Dimension3.Dimension3Name == null) ? "" : "," + SaleInvoiceLineTab.Dimension3.Dimension3Name) +
((SaleInvoiceLineTab.Dimension4.Dimension4Name == null) ? "" : "," + SaleInvoiceLineTab.Dimension4.Dimension4Name)
});
}
public JsonResult GetSaleInvoiceDetailJson(int SaleInvoiceLineId)
{
var temp = (from L in db.ViewSaleInvoiceBalanceForDelivery
join Dl in db.SaleInvoiceLine on L.SaleInvoiceLineId equals Dl.SaleInvoiceLineId into SaleInvoiceLineTable
from SaleInvoiceLineTab in SaleInvoiceLineTable.DefaultIfEmpty()
join P in db.Product on L.ProductId equals P.ProductId into ProductTable
from ProductTab in ProductTable.DefaultIfEmpty()
join U in db.Units on ProductTab.UnitId equals U.UnitId into UnitTable
from UnitTab in UnitTable.DefaultIfEmpty()
join D1 in db.Dimension1 on L.Dimension1Id equals D1.Dimension1Id into Dimension1Table
from Dimension1Tab in Dimension1Table.DefaultIfEmpty()
join D2 in db.Dimension2 on L.Dimension2Id equals D2.Dimension2Id into Dimension2Table
from Dimension2Tab in Dimension2Table.DefaultIfEmpty()
where L.SaleInvoiceLineId == SaleInvoiceLineId
select new
{
SaleInvoiceHeaderDocNo = L.SaleInvoiceNo,
UnitId = UnitTab.UnitId,
UnitName = UnitTab.UnitName,
DealUnitId = SaleInvoiceLineTab.DealUnitId,
UnitConversionMultiplier = SaleInvoiceLineTab.UnitConversionMultiplier,
ProductId = L.ProductId,
Dimension1Id = L.Dimension1Id,
Dimension1Name = Dimension1Tab.Dimension1Name,
Dimension2Id = L.Dimension2Id,
Dimension2Name = Dimension2Tab.Dimension2Name,
BalanceQty = L.BalanceQty
}).FirstOrDefault();
if (temp != null)
{
return(Json(temp));
}
else
{
return(null);
}
}
