//For SaleOrder::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
public ActionResult _ForSaleOrder(int id)
{
MaterialPlanCancelFilterViewModel vm = new MaterialPlanCancelFilterViewModel();
vm.DocTypeId = new MaterialPlanCancelHeaderService(_unitOfWork).Find(id).DocTypeId;
vm.MaterialPlanCancelHeaderId = id;
MaterialPlanCancelHeader Header = new MaterialPlanCancelHeaderService(_unitOfWork).Find(id);
MaterialPlanSettings Settings = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
vm.MaterialPlanSettings = Mapper.Map <MaterialPlanSettings, MaterialPlanSettingsViewModel>(Settings);
vm.DocumentTypeSettings = new DocumentTypeSettingsService(_unitOfWork).GetDocumentTypeSettingsForDocument(Header.DocTypeId);
return(PartialView("_Filters", vm));
}
public ActionResult _FilterPost(MaterialPlanCancelFilterViewModel vm)
{
string ValidationMsg = "";
List <MaterialPlanCancelLineViewModel> temp = _MaterialPlanCanceliLine.GetOrderPlanForFilters(vm).ToList();
MaterialPlanCancelLineListViewModel svm = new MaterialPlanCancelLineListViewModel();
var DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
svm.MaterialPlanSettings = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(vm.DocTypeId, DivisionId, SiteId);
svm.MaterialPlanCancelLineViewModel = temp;
return(PartialView("_Results", svm));
}
public IEnumerable <MaterialPlanCancelLineViewModel> GetOrderPlanForFilters(MaterialPlanCancelFilterViewModel vm)
{
var Header = new MaterialPlanCancelHeaderService(_unitOfWork).Find(vm.MaterialPlanCancelHeaderId);
var Settings = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(Settings.filterContraDocTypes))
{
contraDocTypes = Settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] ProductIdArr = null;
if (!string.IsNullOrEmpty(vm.ProductId))
{
ProductIdArr = vm.ProductId.Split(",".ToCharArray());
}
else
{
ProductIdArr = new string[] { "NA" };
}
string[] SaleOrderIdArr = null;
if (!string.IsNullOrEmpty(vm.MaterialPlanHeaderId))
{
SaleOrderIdArr = vm.MaterialPlanHeaderId.Split(",".ToCharArray());
}
else
{
SaleOrderIdArr = new string[] { "NA" };
}
string[] ProductGroupIdArr = null;
if (!string.IsNullOrEmpty(vm.ProductGroupId))
{
ProductGroupIdArr = vm.ProductGroupId.Split(",".ToCharArray());
}
else
{
ProductGroupIdArr = new string[] { "NA" };
}
string[] Dimension1IdArr = null;
if (!string.IsNullOrEmpty(vm.Dimension1Id))
{
Dimension1IdArr = vm.Dimension1Id.Split(",".ToCharArray());
}
else
{
Dimension1IdArr = new string[] { "NA" };
}
string[] Dimension2IdArr = null;
if (!string.IsNullOrEmpty(vm.Dimension2Id))
{
Dimension2IdArr = vm.Dimension2Id.Split(",".ToCharArray());
}
else
{
Dimension2IdArr = new string[] { "NA" };
}
string[] Dimension3IdArr = null;
if (!string.IsNullOrEmpty(vm.Dimension3Id))
{
Dimension3IdArr = vm.Dimension3Id.Split(",".ToCharArray());
}
else
{
Dimension3IdArr = new string[] { "NA" };
}
string[] Dimension4IdArr = null;
if (!string.IsNullOrEmpty(vm.Dimension4Id))
{
Dimension4IdArr = vm.Dimension4Id.Split(",".ToCharArray());
}
else
{
Dimension4IdArr = new string[] { "NA" };
}
string[] ProcessIdArr = null;
if (!string.IsNullOrEmpty(vm.ProcessId))
{
ProcessIdArr = vm.ProcessId.Split(",".ToCharArray());
}
else
{
ProcessIdArr = new string[] { "NA" };
}
var Query = db.ViewMaterialPlanBalance.AsQueryable()
.Join(db.MaterialPlanLine,
m => m.MaterialPlanLineId,
om => om.MaterialPlanLineId,
(m, p) => new { m, p })
.Join(db.Product, m => m.m.ProductId, t => t.ProductId,
(m, j) => new
{
MaterialPlanLineId = m.m.MaterialPlanLineId,
BalanceQty = m.m.BalanceQty,
MaterialPlanHeaderId = m.m.MaterialPlanHeaderId,
MaterialPlanNo = m.m.MaterialPlanNo,
ProductId = m.m.ProductId,
MaterialPlanDate = m.m.MaterialPlanDate,
DocTypeId = m.m.DocTypeId,
DocTypeName = m.m.DocType.DocumentTypeName,
ProductGroupId = j.ProductGroupId,
Dimension1Name = m.p.Dimension1.Dimension1Name,
Dimenstion2Name = m.p.Dimension2.Dimension2Name,
ProcessName = m.p.Process.ProcessName,
ProductName = j.ProductName,
Specification = m.p.Specification,
unitDecimalPlaces = j.Unit.DecimalPlaces,
UnitId = j.UnitId,
MaterialPlanDocNo = m.m.MaterialPlanNo,
UnitName = j.Unit.UnitName,
BuyerId = m.p.MaterialPlanHeader.BuyerId,
Dimension1Id = m.p.Dimension1Id,
Dimension2Id = m.p.Dimension2Id,
Dimension3Id = m.p.Dimension3Id,
Dimension4Id = m.p.Dimension4Id,
ProcessId = m.p.ProcessId,
});
if (!string.IsNullOrEmpty(Settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
if (!string.IsNullOrEmpty(vm.ProductId))
{
Query = Query.Where(m => ProductIdArr.Contains(m.ProductId.ToString()));
}
if (!string.IsNullOrEmpty(vm.MaterialPlanHeaderId))
{
Query = Query.Where(m => SaleOrderIdArr.Contains(m.MaterialPlanHeaderId.ToString()));
}
if (!string.IsNullOrEmpty(vm.ProductGroupId))
{
Query = Query.Where(m => ProductGroupIdArr.Contains(m.ProductGroupId.ToString()));
}
if (!string.IsNullOrEmpty(vm.Dimension1Id))
{
Query = Query.Where(m => Dimension1IdArr.Contains(m.Dimension1Id.ToString()));
}
if (!string.IsNullOrEmpty(vm.Dimension2Id))
{
Query = Query.Where(m => Dimension2IdArr.Contains(m.Dimension2Id.ToString()));
}
if (!string.IsNullOrEmpty(vm.Dimension3Id))
{
Query = Query.Where(m => Dimension3IdArr.Contains(m.Dimension3Id.ToString()));
}
if (!string.IsNullOrEmpty(vm.Dimension4Id))
{
Query = Query.Where(m => Dimension4IdArr.Contains(m.Dimension4Id.ToString()));
}
if (!string.IsNullOrEmpty(vm.ProcessId))
{
Query = Query.Where(m => ProcessIdArr.Contains(m.ProcessId.ToString()));
}
var Result = Query.Where(m => m.BuyerId == Header.BuyerId).Select(m => new MaterialPlanCancelLineViewModel
{
BalanceQty = m.BalanceQty,
Dimension1Name = m.Dimension1Name,
Dimension2Name = m.Dimenstion2Name,
MaterialPlanCancelHeaderDocNo = Header.DocNo,
MaterialPlanDocNo = m.MaterialPlanDocNo,
MaterialPlanCancelHeaderId = Header.MaterialPlanCancelHeaderId,
MaterialPlanLineId = m.MaterialPlanLineId,
ProcessName = m.ProcessName,
ProductName = m.ProductName,
Qty = m.BalanceQty,
Specification = m.Specification,
unitDecimalPlaces = m.unitDecimalPlaces,
UnitId = m.UnitId,
UnitName = m.UnitName
});
return(Result);
}
