public MainResponse GetSponsorExhibitorBySponsorId(int SponsorId) { IEnumerable <SponsorExhibitorResponse> sponsorExhibitorResponses = null; SponsorExhibitorListResponse sponsorExhibitorListResponses = new SponsorExhibitorListResponse(); sponsorExhibitorResponses = (from sponsorexhibitor in _context.SponsorExhibitor join exhibitor in _context.Exhibitors on sponsorexhibitor.ExhibitorId equals exhibitor.ExhibitorId where sponsorexhibitor.SponsorId == SponsorId && sponsorexhibitor.IsActive == true && sponsorexhibitor.IsDeleted == false && exhibitor.IsActive == true && exhibitor.IsDeleted == false select new SponsorExhibitorResponse { SponsorExhibitorId = sponsorexhibitor.SponsorExhibitorId, SponsorId = sponsorexhibitor.SponsorId, ExhibitorId = exhibitor.ExhibitorId, FirstName = exhibitor.FirstName, LastName = exhibitor.LastName, BirthYear = exhibitor.BirthYear, SponsorTypeId = sponsorexhibitor.SponsorTypeId, AdTypeId = sponsorexhibitor.AdTypeId, SponsorTypeName = (from code in _context.GlobalCodes where code.GlobalCodeId == sponsorexhibitor.SponsorTypeId select code.CodeName).FirstOrDefault(), AdTypeName = (from code1 in _context.GlobalCodes where code1.GlobalCodeId == sponsorexhibitor.AdTypeId select code1.CodeName).FirstOrDefault(), IdNumber = sponsorexhibitor.SponsorTypeId == (int)SponsorTypes.Class ? Convert.ToString(_context.Classes.Where(x => x.ClassId == Convert.ToInt32(sponsorexhibitor.TypeId)).Select(x => x.ClassNumber).FirstOrDefault()) : (sponsorexhibitor.SponsorTypeId == (int)SponsorTypes.Add ? sponsorexhibitor.TypeId : Convert.ToString(0)), }).ToList(); sponsorExhibitorListResponses.SponsorExhibitorResponses = sponsorExhibitorResponses.ToList(); _mainResponse.SponsorExhibitorListResponse = sponsorExhibitorListResponses; _mainResponse.SponsorExhibitorListResponse.UnassignedSponsorExhibitor = GetUnassignedSponsorExhibitorBySponsorId(sponsorExhibitorResponses.ToList()); return(_mainResponse); }
public MainResponse GetSponsorExhibitorBySponsorId(int SponsorId) { IEnumerable <SponsorExhibitorResponse> sponsorExhibitorResponses = null; SponsorExhibitorListResponse sponsorExhibitorListResponses = new SponsorExhibitorListResponse(); var sponsorTypes = (from gcc in _context.GlobalCodeCategories join gc in _context.GlobalCodes on gcc.GlobalCodeCategoryId equals gc.CategoryId where gcc.CategoryName == "SponsorTypes" && gc.IsDeleted == false && gc.IsActive == true select new GlobalCodeResponse { GlobalCodeId = gc.GlobalCodeId, CodeName = (gc.CodeName == null ? "" : gc.CodeName), Description = (gc.Description == null ? String.Empty : gc.Description), GlobalCodeCategory = gcc.CategoryName, CategoryId = gc.CategoryId, }).ToList(); var adSponsorTypeId = 0; var classSponsorTypeId = 0; if (sponsorTypes != null && sponsorTypes.Count > 0) { adSponsorTypeId = sponsorTypes.Where(x => x.CodeName == "Ad").Select(x => x.GlobalCodeId).FirstOrDefault(); classSponsorTypeId = sponsorTypes.Where(x => x.CodeName == "Class").Select(x => x.GlobalCodeId).FirstOrDefault(); } sponsorExhibitorResponses = (from sponsorexhibitor in _context.SponsorExhibitor join exhibitor in _context.Exhibitors on sponsorexhibitor.ExhibitorId equals exhibitor.ExhibitorId where sponsorexhibitor.SponsorId == SponsorId && sponsorexhibitor.IsActive == true && sponsorexhibitor.IsDeleted == false && exhibitor.IsActive == true && exhibitor.IsDeleted == false select new SponsorExhibitorResponse { SponsorExhibitorId = sponsorexhibitor.SponsorExhibitorId, SponsorId = sponsorexhibitor.SponsorId, ExhibitorId = exhibitor.ExhibitorId, FirstName = exhibitor.FirstName, LastName = exhibitor.LastName, BirthYear = exhibitor.BirthYear, SponsorTypeId = sponsorexhibitor.SponsorTypeId, AdTypeId = sponsorexhibitor.AdTypeId, SponsorTypeName = (from code in _context.GlobalCodes where code.GlobalCodeId == sponsorexhibitor.SponsorTypeId select code.CodeName).FirstOrDefault(), AdTypeName = (from fee in _context.YearlyMaintainenceFee where fee.YearlyMaintainenceFeeId == sponsorexhibitor.AdTypeId select fee.FeeName).FirstOrDefault(), IdNumber = sponsorexhibitor.SponsorTypeId == Convert.ToInt32(classSponsorTypeId) ? Convert.ToString(_context.Classes.Where(x => x.ClassId == Convert.ToInt32(sponsorexhibitor.TypeId)).Select(x => x.ClassNumber).FirstOrDefault()) : Convert.ToString(sponsorexhibitor.TypeId), }).ToList(); sponsorExhibitorListResponses.SponsorExhibitorResponses = sponsorExhibitorResponses.ToList(); _mainResponse.SponsorExhibitorListResponse = sponsorExhibitorListResponses; _mainResponse.SponsorExhibitorListResponse.UnassignedSponsorExhibitor = GetUnassignedSponsorExhibitorBySponsorId(sponsorExhibitorResponses.ToList()); return(_mainResponse); }