public ZAIDM_EX_BRAND GetBrandForProdConv(string brand, string prodCode, string nppbkc) { var plant = _plantBll.GetPlantByNppbkc(nppbkc).Select(s => s.WERKS).ToList(); var dbData = _repository.Get(c => c.BRAND_CE == brand && c.PROD_CODE == prodCode && plant.Contains(c.WERKS)).FirstOrDefault(); return(dbData); }
public JsonResult GetPlantOfNppbck(string nppbkcId) { //var data = _nppbkcbll.GetById(nppbkcId).T001W; var data = _plantbll.GetPlantByNppbkc(nppbkcId); if (data == null) { return(null); } return(Json(new SelectList(data, "WERKS", "NAME1"))); }
public List <ProductionDto> GetCompleteData(List <ProductionDto> listItem, GetOtherProductionByParamInput input) { List <ProductionDto> list = new List <ProductionDto>(); List <ProductionDto> newList = new List <ProductionDto>(); //search editable other brand var prodCode = _repositoryProd.GetQuery().Where(x => x.CK4CEDITABLE == true).Select(x => x.PROD_CODE).ToList(); var plantList = _plantBll.GetAll().Where(x => x.WERKS == input.Plant); var listBrand = _brandRegistrationBll.GetAllBrandsOnly(); if (input.IsNppbkc) { plantList = _plantBll.GetPlantByNppbkc(input.Nppbkc).Distinct(); } DateTime firstDay = new DateTime(input.Year, input.Month, 1); DateTime startDate = firstDay; DateTime endDate = new DateTime(input.Year, input.Month, 14); if (input.Period == 2) { startDate = new DateTime(input.Year, input.Month, 15); endDate = firstDay.AddMonths(1).AddDays(-1); } for (var j = startDate.Day; j <= endDate.Day; j++) { foreach (var item in plantList) { Int32 isInt; var activeBrand = listBrand.Where(x => x.WERKS == item.WERKS && Int32.TryParse(x.BRAND_CONTENT, out isInt) && (x.EXC_GOOD_TYP == "01" || x.EXC_GOOD_TYP == "02") && prodCode.Contains(x.PROD_CODE)); foreach (var data in activeBrand.Distinct()) { var newItem = new ProductionDto(); newItem.CompanyCode = input.Company; newItem.ProductionDate = startDate; newItem.FaCode = data.FA_CODE; newItem.PlantWerks = item.WERKS; newItem.LevelPlant = item.WERKS; newItem.BrandDescription = data.BRAND_CE; newItem.PlantName = item.NAME1; newItem.TobaccoProductType = data.ZAIDM_EX_PRODTYP.PRODUCT_TYPE; newItem.Hje = data.HJE_IDR; newItem.Tarif = data.TARIFF; newItem.QtyPacked = 0; newItem.QtyUnpacked = 0; newItem.QtyProduced = 0; newItem.Uom = data.ZAIDM_EX_PRODTYP.PRODUCT_ALIAS == "TIS" ? "G" : "Btg"; newItem.ProdCode = data.PROD_CODE; newItem.ContentPerPack = Convert.ToInt32(data.BRAND_CONTENT); newItem.PackedInPack = 0; newItem.PackedInPackZb = 0; newItem.IsEditable = true; newItem.Zb = 0; newItem.PackedAdjusted = 0; newList.Add(newItem); } } startDate = startDate.AddDays(1); } var sameData = from a in newList join b in listItem on new { a.ProductionDate, a.FaCode, a.PlantWerks } equals new { b.ProductionDate, b.FaCode, b.PlantWerks } select a; list = newList.Except(sameData).ToList(); list.AddRange(listItem); return(list.OrderBy(x => x.FaCode).OrderBy(x => x.ProductionDate).ToList()); }
public JsonResult GetPlantByNppbkc(string nppbkcid) { return(Json(_plantBll.GetPlantByNppbkc(nppbkcid))); }