public ResponseResult <GridResponse <PdtPlnItem> > SearchCriteria(string date, Enum line, GridSettings gridSettings)
{
string kndLine;
var result = _unitOfWork.PdtPlnRepository.GetAll();
if (!string.IsNullOrEmpty(date))
{
date = "01/" + date;
var mydate = ConvertHelper.ConvertToDateTimeFull(date);
var endDate = mydate.AddMonths(1);
result = result.Where(i => i.F39_KndEptBgnDate >= mydate && i.F39_KndEptBgnDate < endDate);
}
if (line != null)
{
kndLine = Constants.KndLine.Megabit.Equals(line) ? "0" : "1";
result = result.Where(i => i.F39_KneadingLine.Equals(kndLine));
}
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
//result = result.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize);
var lstResult = Mapper.Map <IEnumerable <TX39_PdtPln>, IEnumerable <PdtPlnItem> >(result.ToList());
var resultModel = new GridResponse <PdtPlnItem>(lstResult, itemCount);
return(new ResponseResult <GridResponse <PdtPlnItem> >(resultModel, true));
}
public ResponseResult <GridResponse <CommonSearchItem> > GetProductCode(string code, GridSettings gridSettings)
{
var result = _unitOfWork.ProductRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
result =
result.Where(
i =>
i.F09_ProductCode.ToUpper().Contains(code.ToUpper()) ||
i.F09_ProductDesp.ToUpper().Contains(code.ToUpper()));
}
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
F09_ProductCode = s.F09_ProductCode,
F09_ProductDesp = s.F09_ProductDesp
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
/// <summary>
/// Search kneading commands and gridize 'em
/// </summary>
/// <param name="gridSettings"></param>
/// <returns></returns>
public async Task <ResponseResult <GridResponse <object> > > SearchTabletisingKneadingCommands(
GridSettings gridSettings)
{
var pageIndex = gridSettings.PageIndex - 1;
if (pageIndex < 0)
{
pageIndex = 0;
}
var kneadingCommandResults =
await RetrieveTabletisingKneadingCommand(pageIndex, gridSettings.PageSize);
foreach (var kc in kneadingCommandResults.KneadingCommands)
{
if (kc.Status.Equals("4"))
{
kc.Status = "Yet";
}
if (kc.Status.Equals("7"))
{
kc.Status = "Command";
}
}
// Build a grid and respond to client.
var resultModel = new GridResponse <object>(kneadingCommandResults.KneadingCommands,
kneadingCommandResults.Total);
return(new ResponseResult <GridResponse <object> >(resultModel, true));
}
public virtual ActionResult GetChildren(GridRequest requst,
int market,
string marketplaceId,
int listingsMode,
string parentAsin)
{
try
{
LogI("GetChildren, parentAsin=" + parentAsin + ", market=" + market + ", marketplaceId=" + marketplaceId +
", listingsMode=" + listingsMode);
var items = ItemViewModel.GetAll(Db,
(MarketType)market,
marketplaceId,
parentAsin,
(ListingsModeType)listingsMode)
.ToList()
.OrderBy(i => i.StyleString)
.ThenBy(i => i.SizeIndex)
.ThenBy(i => i.Size)
.ThenBy(i => i.Color)
.ThenBy(i => i.SKU)
.ToList();
var data = new GridResponse <ItemViewModel>(items, items.Count);
return(JsonGet(data));
}
catch (Exception ex)
{
LogE("GetChildren", ex);
throw;
}
}
public JsonResult GetData()
{
try
{
var path = Path.Combine(Server.MapPath("~/Output/"), "Generated.csv");
var response = new List <Model1Response>();
if (System.IO.File.Exists(path))
{
using (TextReader fileReader = System.IO.File.OpenText(path))
{
var csv = new CsvReader(fileReader);
csv.Configuration.HasHeaderRecord = true;
response = csv.GetRecords <Model1Response>().ToList();
}
}
var gridRes = new GridResponse <Model1Response>();
gridRes.current = 1;
gridRes.rowCount = new int[1];
gridRes.rowCount[0] = -1;
gridRes.total = response.Count;
gridRes.rows = response;
return(Json(gridRes));
}
catch (Exception ex)
{
log.Error(ex);
return(Json(ex));
}
}
public ResponseResult <GridResponse <CommonSearchItem> > GetShelfNo(string code, GridSettings gridSettings)
{
gridSettings.SortField = "F37_ShelfStatus";
var result = _unitOfWork.PreProductShelfStatusRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
result =
result.Where(
i =>
i.F37_ShelfStatus.Contains(code) ||
i.F37_ShelfBay.Contains(code) ||
i.F37_ShelfLevel.Contains(code));
}
//result.Where(
// i => i.F37_ShelfStatus.Contains(string.Format("{0}", Constants.F37_ShelfStatus.EmptyShelf))
// && i.F37_LowTmpCls.Equals(string.Format("{0}", Constants.F37_lowtmpcls.One)));
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
ShelfNo = s.F37_ShelfRow + '-' + s.F37_ShelfBay + '-' + s.F37_ShelfLevel
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
public ResponseResult <GridResponse <KneadingCommandItem> > SearchCriteria(string productCode,
GridSettings gridSettings)
{
var result = _unitOfWork.KneadingCommandRepository.GetAll();
var productsheft = _unitOfWork.ProductShelfRepository.GetAll();
var productsheftstock = _unitOfWork.ProductShelfStockRepository.GetAll();
if (!string.IsNullOrEmpty(productCode))
{
result = result.Where(x => x.F42_KndCmdNo.Trim() == productCode.Trim()).OrderBy(x => x.F42_LotSeqNo);
var result1 = result.Select(x => new KneadingCommandItem()
{
F42_PrePdtLotNo = x.F42_PrePdtLotNo,
F42_KndBgnDate = x.F42_KndBgnDate,
F42_TrwEndDate = x.F42_TrwEndDate,
F42_KndEndDate = x.F42_KndEndDate,
F42_StgCtnAmt = x.F42_StgCtnAmt,
F42_Status = x.F42_Status.Trim().Equals("0") ? "Not Kneaded" : x.F42_Status.Trim().Equals("1") ? "Kneading" : x.F42_Status.Trim().Equals("2") ? "Completed" : x.F42_Status.Trim().Equals("3") ? "Forced Completed" : x.F42_Status.Trim().Equals("4") ? "Stored" : x.F42_Status.Trim().Equals("5") ? "Tabletised" : x.F42_Status.Trim().Equals("6") ? "Knead Command" : x.F42_Status.Trim().Equals("7") ? "Tablet Command" : x.F42_Status.Trim().Equals("8") ? "Forced Retrieving" : "Forced Retrieved",
F42_LotSeqNo = x.F42_LotSeqNo,
F42_ThrowAmount = x.F42_ThrowAmount
});
var itemCount = result1.Count();
if (gridSettings != null)
{
OrderByAndPaging(ref result1, gridSettings);
}
//total = result.Sum(i => i.F43_LayinginAmount);
var resultModel = new GridResponse <KneadingCommandItem>(result1, itemCount);
return(new ResponseResult <GridResponse <KneadingCommandItem> >(resultModel, true));
}
else
{
var result1 = result.Select(x => new KneadingCommandItem()
{
F42_PrePdtLotNo = x.F42_PrePdtLotNo,
F42_KndBgnDate = x.F42_KndBgnDate,
F42_TrwEndDate = x.F42_TrwEndDate,
F42_KndEndDate = x.F42_KndEndDate,
F42_StgCtnAmt = x.F42_StgCtnAmt,
F42_Status = x.F42_Status.Trim().Equals("0") ? "Not Kneaded" : x.F42_Status.Trim().Equals("1") ? "Kneading" : x.F42_Status.Trim().Equals("2") ? "Completed" : x.F42_Status.Trim().Equals("3") ? "Forced Completed" : x.F42_Status.Trim().Equals("4") ? "Stored" : x.F42_Status.Trim().Equals("5") ? "Tabletised" : x.F42_Status.Trim().Equals("6") ? "Knead Command" : x.F42_Status.Trim().Equals("7") ? "Tablet Command" : x.F42_Status.Trim().Equals("8") ? "Forced Retrieving" : "Forced Retrieved",
F42_LotSeqNo = x.F42_LotSeqNo,
F42_ThrowAmount = x.F42_ThrowAmount
});
var itemCount = result.Count();
if (gridSettings != null)
{
OrderByAndPaging(ref result1, gridSettings);
}
//total = result.Sum(i => i.F43_LayinginAmount);
var resultModel = new GridResponse <KneadingCommandItem>(result1, itemCount);
return(new ResponseResult <GridResponse <KneadingCommandItem> >(resultModel, true));
}
//var itemCount = lstResult.Count();
//var pdtPlnItems = lstResult.AsQueryable();
//OrderByAndPaging(ref pdtPlnItems, gridSettings);
//var resultModel = new GridResponse<PdtPlnItem>(pdtPlnItems, itemCount);
//return new ResponseResult<GridResponse<PdtPlnItem>>(resultModel, true);
}
public ResponseResult <GridResponse <object> > Search(GridSettings gridSettings)
{
var lstMaterial = _unitOfWork.MaterialRepository.GetAll();
var lstMaterialShelfStock = _unitOfWork.MaterialShelfStockRepository.GetAll();
var lstMterialSheldStatus = _unitOfWork.MaterialShelfStatusRepository.GetAll();
var result =
lstMaterialShelfStock.Join(lstMaterial, tx33MtrShfStk => tx33MtrShfStk.F33_MaterialCode,
material => material.F01_MaterialCode, (tx33MtrShfStk, material) => new { tx33MtrShfStk, material })
.Join(lstMterialSheldStatus, @t => @t.tx33MtrShfStk.F33_PalletNo,
tx31MtrShfStse => tx31MtrShfStse.F31_PalletNo, (@t, tx31MtrShfStse) => new { @t, tx31MtrShfStse })
.OrderBy(@t => @[email protected]_MaterialCode)
.OrderBy(@t => @[email protected]_MaterialLotNo)
.GroupBy(@t => new { @t.t.material.F01_MaterialCode, @[email protected]_MaterialDsp })
.Select(
i =>
new
{
i.Key.F01_MaterialCode,
i.Key.F01_MaterialDsp,
F31_Amount = i.Sum(t => t.tx31MtrShfStse.F31_Amount),
unit = "Kg"
});
var itemCount = result.Count();
if (gridSettings != null)
{
OrderByAndPaging(ref result, gridSettings);
}
var resultModel = new GridResponse <object>(result, itemCount);
return(new ResponseResult <GridResponse <object> >(resultModel, true));
}
public ResponseResult <GridResponse <PreProductPlanItem> > SearchCriteria(string date, GridSettings gridSettings)
{
var result = _unitOfWork.PreProductPlanRepository.GetAll();
if (!string.IsNullOrEmpty(date))
{
date = "01/" + date;
DateTime myDate = ConvertHelper.ConvertToDateTimeFull(date);
result = result.Where(i => i.F94_YearMonth.Equals(myDate));
}
var itemCount = result.Count();
if (gridSettings != null)
{
OrderByAndPaging(ref result, gridSettings);
}
var lstPreproduct = _unitOfWork.PreProductRepository.GetAll();
var preproductPlan =
result.Select(
i =>
new PreProductPlanItem()
{
F94_PrepdtCode = i.F94_PrepdtCode,
F94_YearMonth = i.F94_YearMonth,
F94_amount = i.F94_amount,
PreProductName = lstPreproduct.FirstOrDefault(o => o.F03_PreProductCode == i.F94_PrepdtCode).F03_PreProductName
});
var resultModel = new GridResponse <PreProductPlanItem>(preproductPlan, itemCount);
return(new ResponseResult <GridResponse <PreProductPlanItem> >(resultModel, true));
}
public ResponseResult <GridResponse <CommonSearchItem> > GetProductPalletNo(string code, GridSettings gridSettings)
{
var stockFlag = Constants.F40_StockFlag.TX40_StkFlg_NotStk;
var result = _unitOfWork.ProductShelfStockRepository.GetMany(i => i.F40_StockFlag.Equals(stockFlag));
if (!string.IsNullOrEmpty(code))
{
result =
result.Where(
i => i.F40_PalletNo.Trim().Equals(code));
}
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
F40_PalletNo = s.F40_PalletNo
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
/// <summary>
/// Find a list of Reception by using pNo and partial delivery information with pagination.
/// </summary>
/// <param name="gridSettings"></param>
/// <param name="pNo"></param>
/// <param name="partialDelivery"></param>
/// <returns></returns>
public ResponseResult <GridResponse <object> > SearchRawMaterial(GridSettings gridSettings, string pNo,
string partialDelivery)
{
// Find the list of receptions.
var receptions = _unitOfWork.ReceptionRepository.GetAll();
// Filter reception by using specific conditions.
receptions = FindRawMaterials(receptions, pNo, partialDelivery);
// Find all materials in database.
var materials = _unitOfWork.MaterialRepository.GetAll();
// Join material and select reception to get the list of materials which need delivering.
var deliveredMaterials = from reception in receptions
from material in materials
where reception.F30_MaterialCode.Equals(material.F01_MaterialCode)
select new
{
reception.F30_ExpectDate,
reception.F30_PrcOrdNo,
reception.F30_PrtDvrNo,
reception.F30_MaterialCode,
material.F01_MaterialDsp,
reception.F30_ExpectAmount,
reception.F30_StoragedAmount
};
// Do ordering and pagination.
OrderByAndPaging(ref deliveredMaterials, gridSettings);
// Build a grid and respond to client.
var resultModel = new GridResponse <object>(deliveredMaterials, receptions.Count());
return(new ResponseResult <GridResponse <object> >(resultModel, true));
}
public ResponseResult <GridResponse <CommonSearchItem> > GetMaterialCode(string code, GridSettings gridSettings)
{
var result = _unitOfWork.MaterialRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
result =
result.Where(
i =>
i.F01_MaterialCode.ToUpper().Contains(code.ToUpper()) ||
i.F01_MaterialDsp.ToUpper().Contains(code.ToUpper()));
}
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
F01_MaterialCode = s.F01_MaterialCode,
F01_MaterialDsp = s.F01_MaterialDsp,
F01_Unit = s.F01_Unit,
F01_RtrPosCls = s.F01_RtrPosCls,
F01_EntrustedClass = s.F01_EntrustedClass,
F01_PackingUnit = s.F01_PackingUnit,
F01_LiquidClass = EnumsHelper.GetDescription <Constants.Liquid>(ConvertHelper.ToInteger(s.F01_LiquidClass))
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
public void Load(GridResponse res)
{
PageSize = res.Request.Rows.Value;
PageNumber = res.Request.Page.Value;
Total = res.Total;
PageCount = res.PageCount;
}
public ResponseResult <GridResponse <CommonSearchItem> > GetProductLotNoWithProductCode(string code, GridSettings gridSettings, string productCode = null)
{
var result = _unitOfWork.ProductShelfStockRepository.GetAll().Where(i => i.F40_StockFlag.Trim() == "3");
if (!string.IsNullOrEmpty(productCode))
{
result = result.Where(i => i.F40_ProductCode.Trim().Equals(productCode.Trim()));
}
if (!string.IsNullOrEmpty(code))
{
result = result.Where(i => i.F40_ProductLotNo.ToUpper().Contains(code.ToUpper()));
}
// Sort and paging
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(i => i.F40_ProductLotNo).Distinct().Select(s => new CommonSearchItem
{
F40_ProductLotNo = s
});
var itemCount = resultLst.Count();
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
public ResponseResult <GridResponse <CommonSearchItem> > GetShippingNo(string code, GridSettings gridSettings)
{
var result = _unitOfWork.ShippingPlanRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
result = result.Where(i => i.F44_ShipCommandNo.ToUpper().Contains(code.ToUpper()));
}
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
ShippingNo = s.F44_ShipCommandNo,
ProductCode = s.F44_ProductCode,
EndUserName =
_unitOfWork.EndUserRepository.Get(e => e.F10_EndUserCode.Equals(s.F44_EndUserCode)).F10_EndUserName
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
public ResponseResult <GridResponse <CommonSearchItem> > GetEndUserCode(string code, GridSettings gridSettings)
{
var result = _unitOfWork.EndUserRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
result =
result.Where(
i =>
i.F10_EndUserCode.ToUpper().Contains(code.ToUpper()) ||
i.F10_EndUserName.ToUpper().Contains(code.ToUpper()));
}
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
F10_EndUserCode = s.F10_EndUserCode,
F10_EndUserName = s.F10_EndUserName
});
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
//----------------------------------------------------------------------------------------------------
private static void Helper1__PopulateAdditionalTableName(GridResponse rtn)
{
rtn.TableName_FullSQLName = String.Format("[{0}].[{1}]", rtn.Schema, rtn.TableName);
if (rtn.Schema.Contains(" ") && rtn.TableName.Contains(" "))
{
rtn.TableName_FullNameLabel = String.Format("[{0}].[{1}]", rtn.Schema, rtn.TableName);
}
else if (rtn.Schema.Contains(" "))
{
rtn.TableName_FullNameLabel = String.Format("[{0}].{1}", rtn.Schema, rtn.TableName);
}
else if (rtn.TableName.Contains(" "))
{
rtn.TableName_FullNameLabel = String.Format("{0}.[{1}]", rtn.Schema, rtn.TableName);
}
else
{
rtn.TableName_FullNameLabel = String.Format("{0}.{1}", rtn.Schema, rtn.TableName);
}
bool hideSchemaPrefix = false; // to be pulled from settings
if (hideSchemaPrefix)
{
rtn.TableName_FullNameLabel = rtn.TableName;
}
}
public ResponseResult <GridResponse <PdtPlnItem> > SearchCriteriaSelected(string selectedValue,
GridSettings gridSettings)
{
var result = new List <TX39_PdtPln>();
var lstPdtPln = _unitOfWork.PdtPlnRepository.GetAll();
string[] s = selectedValue.TrimEnd('#').Split('#');
for (int i = 0; i < s.Length; i++)
{
var date = ConvertHelper.ConvertToDateTimeFull(s[i].Split(',')[0]);
var preProductCode = s[i].Split(',')[1];
result.Add(lstPdtPln.FirstOrDefault(c => c.F39_KndEptBgnDate == date && c.F39_PreProductCode.Trim() == preProductCode.Trim()));
}
var lstResult = new List <PdtPlnItem>();
foreach (var prtPln in result.ToList())
{
var prdPlnItem = new PdtPlnItem();
var preProductItem = _unitOfWork.PreProductRepository.GetMany(i => i.F03_PreProductCode == prtPln.F39_PreProductCode).FirstOrDefault();
var kndCmdItem = _unitOfWork.KneadingCommandRepository.GetMany(i => i.F42_PreProductCode == prtPln.F39_PreProductCode && i.F42_KndEptBgnDate == prtPln.F39_KndEptBgnDate).FirstOrDefault();
prdPlnItem.F39_KndEptBgnDate = prtPln.F39_KndEptBgnDate;
prdPlnItem.F39_PreProductCode = prtPln.F39_PreProductCode;
prdPlnItem.F39_PrePdtLotAmt = prtPln.F39_PrePdtLotAmt;
prdPlnItem.F39_Status = prtPln.F39_Status;
prdPlnItem.F39_AddDate = prtPln.F39_AddDate;
if (preProductItem != null)
{
prdPlnItem.Quantity = preProductItem.F03_BatchLot;
prdPlnItem.F39_PreProductName = preProductItem.F03_PreProductName;
prdPlnItem.YieldDrate = preProductItem.F03_YieldRate;
prdPlnItem.MaterialAmount = preProductItem.F03_AllMtrAmtPerBth;
}
if (kndCmdItem != null)
{
prdPlnItem.CmdNo = kndCmdItem.F42_KndCmdNo;
prdPlnItem.LotNo = kndCmdItem.F42_PrePdtLotNo;
prdPlnItem.CommandSequenceNo = kndCmdItem.F42_CommandSeqNo;
}
lstResult.Add(prdPlnItem);
}
var itemCount = lstResult.Count();
var queryable = lstResult.AsQueryable();
//OrderByAndPaging(ref queryable, gridSettings);
queryable = queryable.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize);
var resultModel = new GridResponse <PdtPlnItem>(queryable, itemCount);
return(new ResponseResult <GridResponse <PdtPlnItem> >(resultModel, true));
}
public ResponseResult <GridResponse <RetrievalOfPreProductItem> > SearchCriteria(GridSettings gridSettings)
{
var notTablet = Constants.F41_Status.NotTablet;
var containerSet = Constants.F41_Status.ContainerSet;
var containerSetWait = Constants.F41_Status.ContainerSetWait;
var containerSetError = Constants.F41_Status.ContainerSetError;
//find TX41_TbtCmd record with f41_tblcntamt > f41_rtrendcntamt
var tabletCommands = _unitOfWork
.TabletCommandRepository
.GetMany(i => (i.F41_Status.Equals(notTablet) || i.F41_Status.Equals(containerSet) || i.F41_Status.Equals(containerSetWait) || i.F41_Status.Equals(containerSetError)) && (i.F41_TblCntAmt > i.F41_RtrEndCntAmt));
//find TX42_KndCmd record with f42_outsideclass = tx42_outsidecls_prepdt(0) and f42_status =stored(4)
var outSiteClass = Constants.F42_OutSideClass.PreProduct.ToString("D");
var f42_status = Constants.F42_Status.TX42_Sts_Tbtcmd;
var kneadingCommands =
_unitOfWork.KneadingCommandRepository.GetMany(i => i.F42_OutSideClass.Equals(outSiteClass) && i.F42_Status.Equals(f42_status));
//find TM03_PreProduct records
var preProducts = _unitOfWork.PreProductRepository.GetAll();
var results = from tabletCommand in tabletCommands
from kneadingCommand in kneadingCommands
from preProduct in preProducts
where tabletCommand.F41_KndCmdNo.Trim().Equals(kneadingCommand.F42_KndCmdNo.Trim()) &&
tabletCommand.F41_PrePdtLotNo.Trim().Equals(kneadingCommand.F42_PrePdtLotNo.Trim()) &&
tabletCommand.F41_PreproductCode.Trim().Equals(kneadingCommand.F42_PreProductCode.Trim()) &&
tabletCommand.F41_PreproductCode.Trim().Equals(preProduct.F03_PreProductCode.Trim())
orderby
tabletCommand.F41_KndCmdNo,
kneadingCommand.F42_LotSeqNo
select new RetrievalOfPreProductItem
{
F41_KndCmdNo = tabletCommand.F41_KndCmdNo,
F41_PreproductCode = tabletCommand.F41_PreproductCode,
PreProductName = preProduct.F03_PreProductName,
F41_PrePdtLotNo = tabletCommand.F41_PrePdtLotNo,
ThrowAmount = kneadingCommand.F42_ThrowAmount,
F41_TabletLine = tabletCommand.F41_TabletLine,
F41_TblCntAmt = tabletCommand.F41_TblCntAmt,
F41_RtrEndCntAmt = tabletCommand.F41_RtrEndCntAmt,
LotSeqNo = kneadingCommand.F42_LotSeqNo,
Line = tabletCommand.F41_TabletLine.Substring(tabletCommand.F41_TabletLine.Trim().Length - 2, 2),
ContQuanty = tabletCommand.F41_TblCntAmt - tabletCommand.F41_RtrEndCntAmt
};
var itemCount = results.Count();
// Sort and paging
OrderByAndPaging(ref results, gridSettings);
var lstResult =
Mapper.Map <IEnumerable <TX41_TbtCmd>, IEnumerable <RetrievalOfPreProductItem> >(
results);
var resultModel = new GridResponse <RetrievalOfPreProductItem>(lstResult, itemCount);
return(new ResponseResult <GridResponse <RetrievalOfPreProductItem> >(resultModel, true));
}
public JsonResult GetAuditLogs(GridRequest <AuditLogVM> model)
{
var records = _auditLogService.GetAuditLogs();
GridResponse tableResult = new GridResponse(model.draw, records.Data, records.Data.Count, records.Data.Count);
return(Json(tableResult, JsonRequestBehavior.AllowGet));
}
public ResponseResult <GridResponse <object> > SearchDataWindow2(DateTime inputDate, DateTime dateData, string location, GridSettings gridSettings)
{
var lstTe80 = _unitOfWork.EnvMespRepository.GetMany(i => DbFunctions.AddDays(i.F80_D_From, -1) >= inputDate && DbFunctions.AddDays(i.F80_D_To, -1) <= dateData);
var itemCount = lstTe80.Count();
var resultModel = new GridResponse <object>(lstTe80, itemCount);
return(new ResponseResult <GridResponse <object> >(resultModel, true));
}
/// <summary>
/// Find list of out of plan of product.
/// </summary>
/// <param name="productCode"></param>
/// <param name="gridSettings"></param>
/// <returns></returns>
public ResponseResult <GridResponse <OutOfPlanProductItem> > FindOutOfPlanProduct(string productCode,
GridSettings gridSettings)
{
var outPlanProducts = _unitOfWork.OutOfPlanProductRepository.GetAll();
var products = _unitOfWork.ProductRepository.GetAll();
var result = from outPlanProduct in outPlanProducts
join product in products on outPlanProduct.F58_ProductCode.Trim() equals product.F09_ProductCode.Trim()
where outPlanProduct.F58_StorageAmt.Equals(0)
orderby new
{
outPlanProduct.F58_PrePdtLotNo,
outPlanProduct.F58_ProductCode
}
select new
{
outPlanProduct.F58_ProductCode,
product.F09_ProductDesp,
outPlanProduct.F58_PrePdtLotNo,
outPlanProduct.F58_ProductLotNo,
outPlanProduct.F58_TbtCmdEndPackAmt, //Pack Qty
outPlanProduct.F58_TbtCmdEndFrtAmt, //Fraction
outPlanProduct.F58_TbtEndDate //Tabletising
};
if (!string.IsNullOrEmpty(productCode))
{
result = result.Where(x => x.F58_ProductCode.Trim().StartsWith(productCode));
}
var lstResult = new List <OutOfPlanProductItem>();
foreach (var item in result)
{
var storageOfProductItem = new OutOfPlanProductItem();
storageOfProductItem.F58_ProductCode = item.F58_ProductCode;
storageOfProductItem.ProductName = item.F09_ProductDesp;
storageOfProductItem.F58_PrePdtLotNo = item.F58_PrePdtLotNo;
storageOfProductItem.F58_ProductLotNo = item.F58_ProductLotNo;
storageOfProductItem.F58_TbtCmdEndPackAmt = item.F58_TbtCmdEndPackAmt;
storageOfProductItem.F58_TbtCmdEndFrtAmt = item.F58_TbtCmdEndFrtAmt;
storageOfProductItem.F58_TbtEndDate = item.F58_TbtEndDate;
lstResult.Add(storageOfProductItem);
}
var itemCount = lstResult.Count();
var lsResult = lstResult.AsQueryable();
if (gridSettings != null)
{
OrderByAndPaging(ref lsResult, gridSettings);
}
var resultModel = new GridResponse <OutOfPlanProductItem>(lsResult, itemCount);
return(new ResponseResult <GridResponse <OutOfPlanProductItem> >(resultModel, true));
}
/// <summary>
/// Load kneading commands from database.
/// </summary>
/// <param name="gridSettings"></param>
/// <param name="kneadingCommandline"></param>
/// <returns></returns>
public async Task <ResponseResult <GridResponse <object> > > LoadKneadingCommands(GridSettings gridSettings,
Constants.KndLine kneadingCommandline)
{
var kneadingLineMegabit = Constants.KndLine.Megabit.ToString("D");
// Find all kneading commands (TX42_KndCmd)
var kneadingCommands = _unitOfWork.PdtPlnRepository.GetAll();
// Find all Preproducts (TM03_PreProduct)
var preProducts = _unitOfWork.PreProductRepository.GetAll();
if (kneadingCommandline == Constants.KndLine.Conventional)
{
kneadingCommands = kneadingCommands.Where(x => x.F39_KneadingLine.Trim().Equals("1"));
}
else
{
kneadingCommands = kneadingCommands.Where(x => x.F39_KneadingLine.Trim().Equals("0"));
}
kneadingCommands = kneadingCommands.Where(x => x.F39_Status.Trim() != "0");
var loadKneadingCommandsResult = from kneadingCommand in kneadingCommands
join preproduct in preProducts on
kneadingCommand.F39_PreProductCode.Trim() equals preproduct.F03_PreProductCode.Trim()
select new PdtPlnItem1
{
F39_KndCmdNo = kneadingCommand.F39_KndCmdNo,
F39_PreProductCode = kneadingCommand.F39_PreProductCode,
F03_PreProductName = preproduct.F03_PreProductName,
LotNo = kneadingCommand.F39_StartLotNo,
MaterialAmount = kneadingCommand.F39_PrePdtLotAmt,
F39_Status = kneadingCommand.F39_Status == "0" ? "Yet" : kneadingCommand.F39_Status == "1"? "Command": kneadingCommand.F39_Status == "2" ? "Produce" : kneadingCommand.F39_Status == "3" ? "End" : kneadingCommand.F39_Status == "4" ? "F End" : kneadingCommand.F39_Status == "5" ? "Stopped" : kneadingCommand.F39_Status == "6" ? "Stopping" : ""
};
//Ascending order by: [F39_commandseqno], then [F39_lotseqno]
loadKneadingCommandsResult = loadKneadingCommandsResult.OrderBy(x => new
{
x.F39_KndCmdNo
});
// Count the total record which matches with the conditions.
var totalRecords = await loadKneadingCommandsResult.CountAsync();
var realPageIndex = gridSettings.PageIndex - 1;
// Do pagination.
loadKneadingCommandsResult = loadKneadingCommandsResult.Skip(realPageIndex * gridSettings.PageSize)
.Take(gridSettings.PageSize);
// Build a grid and respond to client.
var resultModel = new GridResponse <object>(loadKneadingCommandsResult, totalRecords);
return(new ResponseResult <GridResponse <object> >(resultModel, true));
}
public async Task <ResponseResult <GridResponse <ProductListingBusinessModel> > > Search(SearchCriteriaModel model, GridSettings gridSettings)
{
var items = from p in _iTemoUnitOfWork.ProductRepository.GetAll()
join c in _iTemoUnitOfWork.CategoryRepository.GetAllNonDelete()
on p.CategoryId equals c.Id into data
from item in data.DefaultIfEmpty()
select new ProductListingBusinessModel
{
Id = p.Id,
Name = p.Name,
Code = p.Code,
Description = p.Description,
Qty = p.Qty,
Status = p.Status,
Category = item.Name,
IsDeleted = p.IsDeleted,
CreatedById = p.CreatedById
};
switch (model.ViewName)
{
case Constants.ProductViewType.InActiveProducts:
items = items.Where(r => r.IsDeleted);
break;
case Constants.ProductViewType.MyProducts:
items = items.Where(r => r.CreatedById != null);
break;
case Constants.ProductViewType.AllProducts:
items = items.Where(r => !r.IsDeleted);
break;
default:
items = items.Where(r => !r.IsDeleted);
break;
}
if (!string.IsNullOrEmpty(model.Keyword))
{
items = items.Where(r => r.Name.Contains(model.Keyword) ||
r.Description.Contains(model.Keyword) ||
r.Code.Contains(model.Keyword) ||
r.Status.Contains(model.Keyword) ||
r.Category.Contains(model.Keyword));
}
var totalItems = await items.CountAsync();
OrderBy(ref items, gridSettings);
Paging(ref items, gridSettings);
var results = new GridResponse <ProductListingBusinessModel>(await items.ToListAsync(), totalItems);
return(new ResponseResult <GridResponse <ProductListingBusinessModel> >(results, true));
}
public virtual ActionResult GetAll(GridRequest request)
{
LogI("GetAll");
var searchFilter = new StyleSearchFilterViewModel();
var items = StyleLiteCountingViewModel.GetAll(Db, searchFilter).ToList();
var data = new GridResponse <StyleLiteCountingViewModel>(items, items.Count, Time.GetAppNowTime());
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ResponseResult <GridResponse <CommonSearchItem> > GetPONo(string materialCode, string code, GridSettings gridSettings)
{
var receptions = _unitOfWork.ReceptionRepository.GetAll().Where(i => i.F30_StoragedAmount < i.F30_ExpectAmount);
var materials = _unitOfWork.MaterialRepository.GetAll();
if (!string.IsNullOrEmpty(materialCode))
{
receptions =
receptions.Where(
i =>
i.F30_MaterialCode.Trim().Equals(materialCode.Trim()));
}
if (!string.IsNullOrEmpty(code))
{
receptions =
receptions.Where(
i =>
i.F30_PrcOrdNo.ToUpper().Contains(code.ToUpper()) ||
i.F30_PrtDvrNo.ToUpper().Contains(code.ToUpper()));
}
var result = from reception in receptions
join material in materials on reception.F30_MaterialCode equals material.F01_MaterialCode
//where
//(
// reception.F30_MaterialCode = material.F01_MaterialCode
//)
select new
{
material.F01_MaterialCode,
material.F01_MaterialDsp,
material.F01_PackingUnit,
reception.F30_PrcOrdNo,
reception.F30_PrtDvrNo
};
// Sort and paging
var itemCount = result.Count();
OrderByAndPaging(ref result, gridSettings);
var resultLst = result.ToList().Select(s => new CommonSearchItem
{
F30_PrcOrdNo = s.F30_PrcOrdNo,
F30_PrtDvrNo = s.F30_PrtDvrNo,
F33_MaterialCode = s.F01_MaterialCode,
MaterialName = s.F01_MaterialDsp,
F01_PackingUnit = s.F01_PackingUnit
});
//var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList());
var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
//return result;
}
public ResponseResult <GridResponse <CommonSearchItem> > GetPalletNoWithStockFlag(string code, GridSettings gridSettings)
{
var stockFlag = Constants.F33_StockFlag.TX33_StkFlg_NotStk;
var materialShelfStocks = _unitOfWork.MaterialShelfStockRepository.GetMany(i => i.F33_StockFlag.Equals(stockFlag));
var materials = _unitOfWork.MaterialRepository.GetAll();
//var productShelfStatuses = _unitOfWork.ProductShelfStatusRepository.GetAll();
if (!string.IsNullOrEmpty(code))
{
materialShelfStocks =
materialShelfStocks.Where(
i => i.F33_PalletNo.Trim().Contains(code.Trim()));
}
var result = from materialShelfStock in materialShelfStocks
from material in materials
//from productShelfStatus in productShelfStatuses
where (
materialShelfStock.F33_MaterialCode.Equals(material.F01_MaterialCode.Trim())
//&& materialShelfStock.F33_PalletNo.Equals(productShelfStatus.F51_PalletNo)
)
select new CommonSearchItem
{
//ShelfNo = productShelfStatus.F51_ShelfRow + "-" + productShelfStatus.F51_ShelfBay + "-" + productShelfStatus.F51_ShelfLevel,
F33_PalletNo = materialShelfStock.F33_PalletNo,
F33_MaterialCode = materialShelfStock.F33_MaterialCode,
MaterialName = material.F01_MaterialDsp,
F01_PackingUnit = material.F01_PackingUnit,
F01_Unit = material.F01_Unit
};
// Sort and paging
var itemCount = result.Count();
//OrderByAndPaging(ref result, gridSettings);
// Find real page index.
var realPageIndex = gridSettings.PageIndex - 1;
if (realPageIndex < 0)
{
realPageIndex = 0;
}
// Pagination.
result = result
.OrderBy(x => x.MaterialName)
.Skip(realPageIndex * gridSettings.PageSize)
.Take(gridSettings.PageSize);
var resultModel = new GridResponse <CommonSearchItem>(result, itemCount);
return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true));
}
public ResponseResult <GridResponse <Te84_Env_Lot> > GetTable(string productCode, GridSettings settings)
{
var result = _unitOfWork.EnvLotRepository.GetMany(i => i.F84_ProductCode.Trim().Equals(productCode.Trim()));
var itemCount = result.Count();
result = result.OrderBy(i => i.F84_Id);
result = result.Skip((settings.PageIndex - 1) * settings.PageSize).Take(settings.PageSize);
var resultModel = new GridResponse <Te84_Env_Lot>(result, itemCount);
return(new ResponseResult <GridResponse <Te84_Env_Lot> >(resultModel, true));
}
public JsonResult GetAttributeList(GridRequest <AttributeFilter> model)
{
int page = model.start;
int rowsPerPage = model.length;
ServiceResultModel <List <AttributeVM> > serviceResult = _attributeService.GetAllAttributeList(model.FilterRequest);
var gridRecords = serviceResult.Data.Skip(page).Take(rowsPerPage).ToList();
GridResponse tableResult = new GridResponse(model.draw, gridRecords, serviceResult.Data.Count, serviceResult.Data.Count);
return(Json(tableResult, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRoomTypeList(GridRequest <RoomTypeFilter> model)
{
var page = model.start;
var rowsPerPage = model.length;
var filteredData = _roomTypeService.GetAllRoomTypes(model.FilterRequest);
var gridPageRecord = filteredData.Data.Skip(page).Take(rowsPerPage).ToList();
GridResponse tableResult = new GridResponse(model.draw, gridPageRecord, filteredData.Data.Count, filteredData.Data.Count);
return(Json(tableResult, JsonRequestBehavior.AllowGet));
}
