public static SelectList GetSupplierPlantList() { IPlantBLL plantBll = MvcApplication.GetInstance <PlantBLL>(); var data = plantBll.GetAll(); return(new SelectList(data, "WERKS", "DROPDOWNTEXTFIELD")); }
private SLDocument CreateDataExcel(SLDocument slDocument, List <VirtualNppbckDetails> listData) { int iRow = 3; //starting row data var listPlants = _plantBll.GetAll(); foreach (var data in listData) { string plantDesc = ""; var plant = listPlants.Where(c => c.NPPBKC_ID == data.VirtualNppbckId); foreach (var plant1 in plant) { plantDesc += plant1.WERKS + "-" + plant1.ORT01 + Environment.NewLine; } slDocument.SetCellValue(iRow, 1, data.VirtualNppbckId); slDocument.SetCellValue(iRow, 2, data.Address1); slDocument.SetCellValue(iRow, 3, data.Address2); slDocument.SetCellValue(iRow, 4, data.City); slDocument.SetCellValue(iRow, 5, data.CityAlias); slDocument.SetCellValue(iRow, 6, data.RegionOfficeOfDGCE); slDocument.SetCellValue(iRow, 7, data.TextTo); slDocument.SetCellValue(iRow, 8, data.KppbcId); slDocument.SetCellValue(iRow, 9, data.Region); slDocument.SetCellValue(iRow, 10, data.AcountNumber); slDocument.SetCellValue(iRow, 11, Utils.ConvertHelper.ConvertDateToStringddMMMyyyy(data.StartDate)); slDocument.SetCellValue(iRow, 12, Utils.ConvertHelper.ConvertDateToStringddMMMyyyy(data.EndDate)); slDocument.SetCellValue(iRow, 13, data.FlagForLack1 ? "Yes" : "No"); slDocument.SetCellValue(iRow, 14, plantDesc); slDocument.SetCellValue(iRow, 15, data.Is_Deleted); iRow++; } //create style SLStyle valueStyle = slDocument.CreateStyle(); valueStyle.Border.LeftBorder.BorderStyle = BorderStyleValues.Thin; valueStyle.Border.RightBorder.BorderStyle = BorderStyleValues.Thin; valueStyle.Border.TopBorder.BorderStyle = BorderStyleValues.Thin; valueStyle.Border.BottomBorder.BorderStyle = BorderStyleValues.Thin; valueStyle.SetWrapText(true); slDocument.AutoFitColumn(1, 15); slDocument.SetCellStyle(3, 1, iRow - 1, 15, valueStyle); return(slDocument); }
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()); }