public void GetSingleNews(int newsId) { using (var context = new TownUtilityBillSystemV2Entities()) { var singleNewsDB = context.NEWS.Find(newsId); string currentLanguage = HelperMethod.GetCurrentLanguage(); var newsTitle = context.NEWS_TITLEs. Where(t => t.NEWS_ID == singleNewsDB.ID). Where(t => t.LANGUAGE == currentLanguage). FirstOrDefault().TITLE; var chaptersDB = context.NEWS_CHAPTERs. Where(c => c.NEWS_ID == newsId). Where(c => c.LANGUAGE == currentLanguage). ToList(); SingleNews.Title = newsTitle; SingleNews.Date = singleNewsDB.DATE; foreach (var ch in chaptersDB) { SingleNews.NewsChapters.Add(new NewsChapter() { Id = ch.ID, Text = ch.TEXT }); } } }
public ActionResult EditMeterData(int meterItemId) { var model = new MeterItemModel(); model.GetMeterAndDataToEdit(meterItemId); ViewBag.CurrentCulture = HelperMethod.GetCurrentLanguage(); return(View(model)); }
/// <summary> /// Rerurns news titles list for a slide-show /// </summary> public void GetNewsTitlesForSlideShow() { using (var context = new TownUtilityBillSystemV2Entities()) { var newsDB = context.NEWS.ToList(); var newsTitlesDB = context.NEWS_TITLEs.ToList(); string currentLanguage = HelperMethod.GetCurrentLanguage(); foreach (var n in newsDB) { string newsTitle = newsTitlesDB. Where(t => t.NEWS_ID == n.ID). Where(t => t.LANGUAGE == currentLanguage). FirstOrDefault().TITLE; NewsList.Add(new News() { Id = n.ID, Date = n.DATE, Title = newsTitle, ImagePath = GetNewsImage(n.IMAGE_ID) }); } } }
public string GetBuildingImage(int buildingId) { using (var context = new TownUtilityBillSystemV2Entities()) { IMAGE_BUILDING imageDB = null; string imageName = ""; string imagePathForHtml = ""; string imagePathDB = ""; string folderName = ""; var buildingDB = context.BUILDINGs.Where(b => b.ID == buildingId).FirstOrDefault(); imageDB = (buildingDB != null) ? context.IMAGE_BUILDINGs.Where(i => i.ID == buildingDB.IMAGE_ID).FirstOrDefault() : null; if (imageDB != null) { imagePathDB = imageDB.PATH.ToString(); folderName = Path.GetFileName(Path.GetDirectoryName(imagePathDB)); imageName = Path.GetFileName(imagePathDB); imagePathForHtml = "<img src = '/Content/Images/TownBuildings/" + folderName + "/" + imageName + "'" + "id = 'buildingImage'/> <br /> <br /><strong>" + Localization.BuildingImage + "</strong>"; } else { switch (HelperMethod.GetCurrentLanguage()) { case "da": imagePathForHtml = "<img src = '/Content/Images/EmptyImages/NoImageBuildingDa.jpg' id = 'buildingImage'/>"; break; default: imagePathForHtml = "<img src = '/Content/Images/EmptyImages/NoImageBuildingEn.jpg' id = 'buildingImage'/>"; break; } } return(imagePathForHtml); } }
public static string GetBuildingImageForCustomerDetailsView(int buildingId) { using (var context = new TownUtilityBillSystemV2Entities()) { IMAGE_BUILDING imageDB = null; string imageName = ""; string imagePath = ""; string imagePathDB = ""; string folderName = ""; var buildingDB = context.BUILDINGs.Where(b => b.ID == buildingId).FirstOrDefault(); if (buildingDB != null) { imageDB = context.IMAGE_BUILDINGs.Where(i => i.ID == buildingDB.IMAGE_ID).FirstOrDefault(); } if (imageDB != null) { imagePathDB = imageDB.PATH.ToString(); folderName = Path.GetFileName(Path.GetDirectoryName(imagePathDB)); imageName = Path.GetFileName(imagePathDB); imagePath = "/Content/Images/TownBuildings/" + folderName + "/" + imageName; } else { imagePath = "/Content/Images/EmptyImages/NoImageBuilding" + HelperMethod.UppercaseFirstLetter(HelperMethod.GetCurrentLanguage()) + ".jpg"; } return(imagePath); } }
public void CheckGetCurrentLanguage() { string currentCulture = HelperMethod.GetCurrentLanguage(); Assert.IsFalse(String.IsNullOrEmpty(currentCulture)); }