public SaleEnquiryLineViewModel GetSaleEnquiryDetailForQuotation(int id)
{
return((from t in db.ViewSaleEnquiryBalanceForQuotation
join p in db.SaleEnquiryLine on t.SaleEnquiryLineId equals p.SaleEnquiryLineId into SaleEnquiryLineTable
from SaleEnquiryLineTab in SaleEnquiryLineTable.DefaultIfEmpty()
where t.SaleEnquiryLineId == id
select new SaleEnquiryLineViewModel
{
DealQty = SaleEnquiryLineTab.DealQty,
DealUnitId = SaleEnquiryLineTab.DealUnitId,
ProductId = SaleEnquiryLineTab.ProductId,
SaleEnquiryDocNo = t.SaleEnquiryNo,
Qty = t.BalanceQty,
Rate = SaleEnquiryLineTab.Rate,
Remark = SaleEnquiryLineTab.Remark,
Dimension1Id = SaleEnquiryLineTab.Dimension1Id,
Dimension2Id = SaleEnquiryLineTab.Dimension2Id,
Dimension3Id = SaleEnquiryLineTab.Dimension3Id,
Dimension4Id = SaleEnquiryLineTab.Dimension4Id,
Dimension1Name = SaleEnquiryLineTab.Dimension1.Dimension1Name,
Dimension2Name = SaleEnquiryLineTab.Dimension2.Dimension2Name,
Dimension3Name = SaleEnquiryLineTab.Dimension3.Dimension3Name,
Dimension4Name = SaleEnquiryLineTab.Dimension4.Dimension4Name,
Specification = SaleEnquiryLineTab.Specification,
UnitConversionMultiplier = SaleEnquiryLineTab.UnitConversionMultiplier,
UnitId = SaleEnquiryLineTab.Product.UnitId,
UnitName = SaleEnquiryLineTab.Product.Unit.UnitName,
}).FirstOrDefault());
}
public IQueryable <ComboBoxResult> GetBuyerSpecification3(string term, int filter)
{
var list = (from Le in db.SaleEnquiryLineExtended
join L in db.SaleEnquiryLine on Le.SaleEnquiryLineId equals L.SaleEnquiryLineId into SaleEnquiryLineTable
from SaleEnquiryLineTab in SaleEnquiryLineTable.DefaultIfEmpty()
join H in db.SaleEnquiryHeader on SaleEnquiryLineTab.SaleEnquiryHeaderId equals H.SaleEnquiryHeaderId into SaleEnquiryHeaderTable
from SaleEnquiryHeaderTab in SaleEnquiryHeaderTable.DefaultIfEmpty()
where SaleEnquiryHeaderTab.SaleToBuyerId == filter && Le.BuyerSpecification3 != null &&
(string.IsNullOrEmpty(term) ? 1 == 1 : Le.BuyerSpecification3.ToLower().Contains(term.ToLower()))
group new { Le } by new { Le.BuyerSpecification3 } into Result
orderby Result.Key.BuyerSpecification3
select new ComboBoxResult
{
id = Result.Key.BuyerSpecification3,
text = Result.Key.BuyerSpecification3
});
return(list);
}
public IQueryable <SaleEnquiryLineIndexViewModel> GetSaleEnquiryLineListForIndex()
{
var temp = from p in db.SaleEnquiryLine
join Pe in db.SaleEnquiryLineExtended on p.SaleEnquiryLineId equals Pe.SaleEnquiryLineId into SaleEnquiryLineTable
from SaleEnquiryLineTab in SaleEnquiryLineTable.DefaultIfEmpty()
join t1 in db.SaleEnquiryHeader on p.SaleEnquiryHeaderId equals t1.SaleEnquiryHeaderId into table1
from tab1 in table1.DefaultIfEmpty()
where p.ProductId == null
orderby p.SaleEnquiryLineId
select new SaleEnquiryLineIndexViewModel
{
SaleEnquiryLineId = p.SaleEnquiryLineId,
SaleEnquiryHeaderDocNo = tab1.DocNo,
SaleEnquiryHeaderDocDate = tab1.DocDate,
SaleToBuyerId = tab1.SaleToBuyerId,
SaleToBuyerName = tab1.SaleToBuyer.Name,
BuyerSpecification = SaleEnquiryLineTab.BuyerSpecification,
BuyerSpecification1 = SaleEnquiryLineTab.BuyerSpecification1,
BuyerSpecification3 = SaleEnquiryLineTab.BuyerSpecification3,
BuyerSpecification2 = SaleEnquiryLineTab.BuyerSpecification2,
};
return(temp);
}
public IQueryable <SaleEnquiryLineIndexViewModel> GetSaleEnquiryLineListForIndex(int SaleEnquiryHeaderId)
{
var temp = from p in db.SaleEnquiryLine
join Pe in db.SaleEnquiryLineExtended on p.SaleEnquiryLineId equals Pe.SaleEnquiryLineId into SaleEnquiryLineTable from SaleEnquiryLineTab in SaleEnquiryLineTable.DefaultIfEmpty()
join t in db.ViewSaleEnquiryBalance on p.SaleEnquiryLineId equals t.SaleEnquiryLineId into table from svb in table.DefaultIfEmpty()
join t1 in db.SaleEnquiryHeader on p.SaleEnquiryHeaderId equals t1.SaleEnquiryHeaderId into table1 from tab1 in table1.DefaultIfEmpty()
join pb in db.ViewProductBuyer on new { p.ProductId, BuyerId = tab1.SaleToBuyerId } equals new { pb.ProductId, BuyerId = pb.BuyerId } into table2
from tab2 in table2.DefaultIfEmpty()
orderby p.SaleEnquiryLineId
where p.SaleEnquiryHeaderId == SaleEnquiryHeaderId
select new SaleEnquiryLineIndexViewModel
{
BuyerSku = tab2.ProductName,
DealQty = p.DealQty,
DealUnitId = p.DealUnitId,
Specification = p.Specification,
Rate = p.Rate,
Amount = p.Amount,
DueDate = p.DueDate,
ProductName = tab2.ProductName,
BuyerSpecification = SaleEnquiryLineTab.BuyerSpecification,
BuyerSpecification1 = SaleEnquiryLineTab.BuyerSpecification1,
BuyerSpecification3 = SaleEnquiryLineTab.BuyerSpecification3,
BuyerSpecification2 = SaleEnquiryLineTab.BuyerSpecification2,
Dimension1Name = p.Dimension1.Dimension1Name,
Dimension2Name = p.Dimension2.Dimension2Name,
Dimension3Name = p.Dimension3.Dimension3Name,
Dimension4Name = p.Dimension4.Dimension4Name,
Qty = p.Qty,
SaleEnquiryHeaderId = p.SaleEnquiryHeaderId,
SaleEnquiryLineId = p.SaleEnquiryLineId,
Remark = p.Remark,
ProgressPerc = (p.Qty == 0 ? 0 : (int)((((p.Qty - ((decimal?)svb.BalanceQty ?? (decimal)0)) / p.Qty) * 100))),
unitDecimalPlaces = p.Unit.DecimalPlaces,
UnitId = p.UnitId,
};
return(temp);
}
