public FulfillmentViewModelBuilder GetViewModelItemBuilder(int?condition)
{
//if (condition.HasValue)
//{
// var item = this.contextSub.Fulfillment_V.Where(s => s.iEnable == true && s.vPOID == condition);
// {
// var viewModelBuilder = new FulfillmentViewModelBuilder
// {
// FulfillmentVs = item,
// Stores = new SelectList(this.contextSub.V3_GetStoreDDL(), "Id", "sName"),
// Suppliers = new SelectList(this.contextSub.SupplierForFulfill_DDL_V.OrderBy(s => s.vSupplierName), "bSupplierID", "vSupplierName")
// };
// return viewModelBuilder;
// }
//}
//else
//{
var viewModelBuilder = new FulfillmentViewModelBuilder
{
PurchaseOrder = new WAMS_PURCHASE_ORDER(),
//Stores = new SelectList(this.contextSub.V3_GetStoreDDL(), "Id", "sName"),
//Suppliers =
// new SelectList(
// this.contextSub.SupplierForFulfill_DDL_V.OrderBy(s => s.vSupplierName), "bSupplierID", "vSupplierName")
};
return(viewModelBuilder);
//}
}
//public IEnumerable<PoFulfill_DDL_V> PoDdlVs(string year, int month)
//{
// return
// this.contextSub.PoFulfill_DDL_V.AsEnumerable().Where(p => p.yYear == year && p.Month_Order == month)
// .OrderByDescending(p => p.yYear).ThenByDescending(p => p.Month_Order).ThenByDescending(p => p.vPOID);
//}
//public IEnumerable<PoFromSupplier_DDL_V> PoFromSupplierDdlVs(int suppId, int storeId)
//{
// return
// this.contextSub.PoFromSupplier_DDL_V.AsEnumerable().Where(p => p.bSupplierID == suppId && p.iStore == storeId && p.vPOStatus == "Open")
// .OrderByDescending(p => p.yYear).ThenByDescending(p => p.Month_Order).ThenByDescending(p => p.vPOID);
//}
public FulfillmentViewModelBuilder LoadDataList(int page, int size, int store, int poType, string po, int sup, string srv, string stock, string fd, string td)
{
var output = new ObjectParameter("ItemCount", typeof(int));
var data = this.contextSub.V3_StockIn_GetList(page, size, store, poType, po, sup, srv, stock, fd, td, 1, output).ToList();
var totalRecord = output.Value;
var totalTemp = Convert.ToDecimal(totalRecord) / Convert.ToDecimal(size);
var totalPages = Convert.ToInt32(Math.Ceiling(totalTemp));
var viewModel = new FulfillmentViewModelBuilder
{
FulfillmentVs = data,
TotalRecords = Convert.ToInt32(totalRecord),
TotalPages = totalPages,
CurrentPage = page,
PageSize = size
};
return(viewModel);
}
public FulfillmentViewModelBuilder GetViewModelIndex()
{
var viewModelBuilder = new FulfillmentViewModelBuilder
{
Stores = new SelectList(this.contextSub.V3_GetStoreDDL(), "Id", "sName"),
PoTypes =
new SelectList(this.contextSub.WAMS_PO_TYPE.OrderBy(s => s.vPOTypeName), "bPOTypeID", "vPOTypeName"),
Suppliers =
new SelectList(
this.contextSub.V3_GetSupplierDDL(),
"bSupplierID",
"vSupplierName"),
Projects =
new SelectList(
this.contextSub.V3_GetProjectDDL(),
"Id",
"vProjectName")
};
return(viewModelBuilder);
}
