void DrawLineTextForModels(XGraphics gfx, int startX, int startY, CvlItem dataLine, int heightSum, int rowCount, int brandNumber, int serieNumber) { gfx.DrawString(dataLine.Fr, font5Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 146.5).Point, (float)XUnit.FromMillimeter(51 + startY + serieNumber * 10 + brandNumber * 20).Point)); gfx.DrawString(dataLine.BadBeeNumber, font5, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 151.5).Point, (float)XUnit.FromMillimeter(51 + startY + serieNumber * 10 + brandNumber * 20).Point)); gfx.DrawString(dataLine.BrakeSystem, font5Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 166).Point, (float)XUnit.FromMillimeter(51 + startY + serieNumber * 10 + brandNumber * 20).Point)); gfx.DrawString(dataLine.Wva, font5Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 171).Point, (float)XUnit.FromMillimeter(51 + startY + serieNumber * 10 + brandNumber * 20).Point)); gfx.DrawString(dataLine.Size, font5Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 181).Point, (float)XUnit.FromMillimeter(51 + startY + serieNumber * 10 + brandNumber * 20).Point)); }
void DrawLineText(XGraphics gfx, int startX, int startY, CvlItem dataLine, int heightSum, int rowCount) { if (dataLine.Model.Count() > 39) { gfx.DrawString(dataLine.Model.Replace(",5\"", ",5''").Replace(".5\"", ".5''").Replace("\"", ""), font5, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 15).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); } else { gfx.DrawString(dataLine.Model.Replace(",5\"", ",5''").Replace(".5\"", ".5''").Replace("\"", ""), font6, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 15).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); } gfx.DrawString(dataLine.WvaDesc, font6Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 65).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); //else if (!string.IsNullOrEmpty(dataLine[3]) && string.IsNullOrEmpty(dataLine[4]) || dataLine[4] == " ") //{ // gfx.DrawString(dataLine[3].Replace("10\"", "10''").Replace(".5\"", ".5''").Replace("\"", ""), font6Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 65).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); //} //else if (!string.IsNullOrEmpty(dataLine[4]) && (string.IsNullOrEmpty(dataLine[3]) || dataLine[3] == " ")) //{ // gfx.DrawString(dataLine[4].Replace("10\"", "10''").Replace(".5\"", ".5''").Replace("\"", ""), font6Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 65).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); //} gfx.DrawString(GetYears(dataLine.DateFrom, dataLine.DateTo), font6Regular, XBrushes.Black, new System.Drawing.PointF((float)XUnit.FromMillimeter(startX + 128).Point, (float)XUnit.FromMillimeter(31 + heightSum + ((rowCount * 5) / 2)).Point)); }
public ListResult GetList(BadBeeFilter filter, int page, int itemsPerPage) { ListResult results = new ListResult(); results.Items = new List <CvlItem>(); results.ItemsCount = 0; var query = db.Item.AsQueryable(); if (filter.PhraseFilter != null) { if (GetChList <Brand>().Any(row => row.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower()))) { List <Brand> br = GetChList <Brand>().Where(q => q.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower())).ToList(); List <int> brandIds = br.Select(x => x.BrandId).ToList(); query = query.Where(q => brandIds.Contains(q.Model.Serie.Brand.BrandId)); filter.BrandsList = brandIds; } else if (GetChList <Serie>().Any(row => row.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower()))) { List <Serie> ser = GetChList <Serie>().Where(q => q.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower())).ToList(); List <int> serieIds = ser.Select(x => x.SerieId).ToList(); query = query.Where(q => serieIds.Contains(q.Model.Serie.SerieId)); filter.SeriesList = serieIds; } else if (GetChList <Model>().Any(row => row.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower()))) { List <Model> mod = GetChList <Model>().Where(q => q.Name.ToLower().StartsWith(filter.PhraseFilter.ToLower())).ToList(); List <int> modelIds = mod.Select(x => x.ModelId).ToList(); query = query.Where(q => modelIds.Contains(q.Model.ModelId)); filter.ModelsList = modelIds; } else if (GetChList <DAL.BadBee>().Any(q => (q.BadBeeNo.Replace(" ", "").Replace(".", "").Replace(",", "").Replace("-", "") .StartsWith(filter.PhraseFilter.Replace(" ", "").Replace(".", "").Replace(",", "").Replace("-", ""))))) { List <DAL.BadBee> bb = GetChList <DAL.BadBee>().Where(q => (q.BadBeeNo.Replace(" ", "").Replace(".", "").Replace(",", "").Replace("-", "") .StartsWith(filter.PhraseFilter.Replace(" ", "").Replace(".", "").Replace(",", "").Replace("-", "")))).ToList(); List <int> badBeeIds = bb.Select(x => x.BadBeeId).ToList(); query = query.Where(q => badBeeIds.Contains(q.BadBee.BadBeeId)); if (bb != null) { filter.BadBeeNumbersList = badBeeIds; } } else if (GetChList <Wva>().Any(q => q.WvaNo.StartsWith(filter.PhraseFilter.Replace(" ", "")))) { List <Wva> wva = GetChList <Wva>().Where(q => q.WvaNo.Replace(" ", "").StartsWith(filter.PhraseFilter.Replace(" ", ""))).ToList(); List <int> wvaIds = wva.Select(x => x.WvaId).ToList(); query = query.Where(q => wvaIds.Contains(q.BadBee.Wva.WvaId)); if (wva != null) { filter.WvasList = wvaIds; } } filter.PhraseFilter = null; } if (filter != null && filter.PhraseFilter == null) { if (!string.IsNullOrEmpty(filter.Models)) { query = query.Where(q => filter.ModelsList.Contains(q.ModelId)); } else if (!string.IsNullOrEmpty(filter.Series)) { query = query.Where(q => filter.SeriesList.Contains(q.Model.Serie.SerieId)); } else if (!string.IsNullOrEmpty(filter.Brands)) { query = query.Where(q => filter.BrandsList.Contains(q.Model.Serie.Brand.BrandId)); } if (string.IsNullOrEmpty(filter.Brands)) { filter.Series = null; filter.Models = null; } if (!string.IsNullOrEmpty(filter.BadBeeNumbers)) { query = query.Where(q => filter.BadBeeNumbersList.Contains(q.BadBee.BadBeeId)); } //if (filter.DateYear.HasValue) //{ // DateTime date = new DateTime(); // date = date.AddYears(filter.DateYear.Value - 1); // query = query.Where(q => (q.DateFrom <= date && q.DateTo >= date) || (q.DateFrom <= date && q.DateTo == null) || (q.DateFrom == null && q.DateTo >= date)); //} if (!string.IsNullOrEmpty(filter.DateYears)) { // DateTime date = new DateTime(); List <int> yslist = filter.DateYearsList.ToList(); query = query.Where(q => yslist.Contains(q.Model.Year.DateFromFK.DateId) || yslist.Contains(q.Model.Year.DateToFK.DateId)); } if (!string.IsNullOrEmpty(filter.Wvas)) { query = query.Where(q => filter.WvasList.Contains(q.BadBee.Wva.WvaId)); } if (!string.IsNullOrEmpty(filter.Widths)) { query = query.Where(q => filter.WidthsList.Contains(q.BadBee.Dimension.Width.WidthId)); } if (!string.IsNullOrEmpty(filter.Heights)) { query = query.Where(q => filter.HeightsList.Contains(q.BadBee.Dimension.Height.HeightId)); } if (!string.IsNullOrEmpty(filter.Thicknesses)) { query = query.Where(q => filter.ThicknessesList.Contains(q.BadBee.Dimension.Thickness.ThicknessId)); } if (!string.IsNullOrEmpty(filter.Systems)) { query = query.Where(q => filter.SystemsList.Contains(q.BadBee.Systems.SystemId)); } query = query.OrderBy(q => q.Model.Serie.Brand.Name).ThenBy(q => q.Model.Serie.Name).ThenBy(q => q.Model.Name).ThenBy(q => q.Id); results.ItemsCount = query.Count(); query = query.Skip((page - 1) * itemsPerPage).Take(itemsPerPage); var list = query.ToList(); filter.PhraseFilter = null; foreach (Item item in list) { string sYears = ""; if (item.Model.Year != null && item.Model.Year.DateFromId != 0) { if (item.Model.Year.DateFromFK.Date1 != "0") { sYears += item.Model.Year.DateFromFK.Date1; } if (item.Model.Year.DateToId != 0) { sYears += " - " + item.Model.Year.DateToFK.Date1; } else { sYears += " ->"; } } else { if (item.Model.Year != null && item.Model.Year.DateToId != 0) { sYears += "<- " + item.Model.Year.DateToFK.Date1; } } CvlItem newItem = new CvlItem() { Id = item.Id, BadBeeNumber = item.BadBee.BadBeeNo.TrimEnd(), Brand = item.Model.Serie.Brand.Name.TrimEnd(), Serie = item.Model.Serie.Name.TrimEnd(), Model = item.Model.Name.TrimEnd(), Years = sYears.TrimEnd(), Fr = item.BadBee.FR.TrimEnd(), WvaDesc = item.BadBee.Wva.Description.TrimEnd(), Wva = item.BadBee.Wva.WvaNo.TrimEnd(), Width = item.BadBee.Dimension.Width.Width1.ToString(), Height = item.BadBee.Dimension.Height.Height1.ToString(), Thickness = item.BadBee.Dimension.Thickness.Thickness1.ToString(), BrakeSystem = item.BadBee.Systems.Abbreviation.TrimEnd() }; results.Items.Add(newItem); } } return(results); }