public void ProcessData() { Home_ViewModel homeVM = new Home_ViewModel(); #region Processing Data in Single table List <KeyValuePair <string, string> > insert_Parameters = new List <KeyValuePair <string, string> >(); insert_Parameters.Add(new KeyValuePair <string, string>("@ID", "4")); insert_Parameters.Add(new KeyValuePair <string, string>("@FirstName", "R 4 FName")); insert_Parameters.Add(new KeyValuePair <string, string>("@LastName", "R 4 LName")); Home.Insert(insert_Parameters); List <KeyValuePair <string, string> > listing_Parameters = new List <KeyValuePair <string, string> >(); listing_Parameters.Add(new KeyValuePair <string, string>("@FirstName", null)); homeVM.lst_home = JsonConvert.DeserializeObject <List <Home_DataModel> >(Home.Get_Listing(listing_Parameters)); List <KeyValuePair <string, string> > getByID_Parameters = new List <KeyValuePair <string, string> >(); getByID_Parameters.Add(new KeyValuePair <string, string>("@ID", "2")); homeVM.home = JsonConvert.DeserializeObject <Home_DataModel>(Home.GetByID(getByID_Parameters)); Logger.log(homeVM.home, Convert.ToString(LogDirectory.Data_Log)); #endregion #region Processing Data in Multiple tables #endregion }
public ActionResult Index(string Selection) { LogWriter.Instance.LogInfo("HomeController / Index"); List <Home_ViewModel> listHomeViewModel = new List <Home_ViewModel>(); // New List: for Home_ViewModel Home_ViewModel homeViewModel = new Home_ViewModel(); // New ViewModel: Home_ViewModel homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("All"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("All"); listHomeViewModel.Add(homeViewModel); //Passing data to javascript JavaScriptSerializer oSerializer = new JavaScriptSerializer(); ViewBag.homeViewModelJSON = oSerializer.Serialize(homeViewModel); if (User.Identity.IsAuthenticated) { ViewBag.loginStatus = "Login"; } else { ViewBag.loginStatus = "Not Login"; } return(View(listHomeViewModel)); }
public async Task <IActionResult> Index2() { try { Home_ViewModel model = new Home_ViewModel(); model.tb_Sliders = await _unitOfWork.SliderRepo.GetAsync(); model.tb_Setting = await _unitOfWork.SettingRepo.GetByIdAsync(1); return(View(model)); } catch (Exception) { throw; } }
public ActionResult Index(string Selection, string searchKeyword) { LogWriter.Instance.LogInfo("HomeController / Index"); List <Home_ViewModel> listHomeViewModel = new List <Home_ViewModel>(); // New List: for Home_ViewModel Home_ViewModel homeViewModel = new Home_ViewModel(); // New ViewModel: Home_ViewModel if (searchKeyword != null && searchKeyword != "") { if (homeMapper.getLocationInfo(searchKeyword).Count() != 0) { homeViewModel.enumerableAllLocation = homeMapper.getLocationInfo(searchKeyword); homeViewModel.enumerableAllWeather = validateSearchWeatherData(searchKeyword); listHomeViewModel.Add(homeViewModel); /************************************************************************************ * Description: This function update theh search DB with the keyword that the * * users has searched * * * * Developer: Yun Yong * * * * Date: 01/04/2016 * ************************************************************************************/ Search searchModel = new Search(); searchModel.Keyword = searchKeyword; searchModel.Date = DateTime.Now; searchGateway.Insert(searchModel); } } else { if (!String.IsNullOrEmpty(Selection)) { if (Selection == "1") // Musuem selected { homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("Museum"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("Museum"); listHomeViewModel.Add(homeViewModel); } else if (Selection == "2") // HistoricSites selected { homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("Monument"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("Monument"); listHomeViewModel.Add(homeViewModel); } else if (Selection == "3") // Monuments selected { homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("HistoricSite"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("HistoricSite"); listHomeViewModel.Add(homeViewModel); } else { homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("All"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("All"); listHomeViewModel.Add(homeViewModel); } } else { homeViewModel.enumerableAllLocation = homeMapper.getAllLocationInfo("All"); homeViewModel.enumerableAllWeather = validateCategoryWeatherData("All"); listHomeViewModel.Add(homeViewModel); } } //Passing data to javascript JavaScriptSerializer oSerializer = new JavaScriptSerializer(); ViewBag.homeViewModelJSON = oSerializer.Serialize(homeViewModel); if (User.Identity.IsAuthenticated) { ViewBag.loginStatus = "Login"; } else { ViewBag.loginStatus = "Not Login"; } return(View(listHomeViewModel)); }
public IActionResult Index() { //try //{ // _unitOfWork.BeginTransaction(); // var setting = _unitOfWork.Get<PlateSetting>(a => a.Key == "test"); // _unitOfWork.RegisterDeleted<PlateSetting>(setting.Result); // var language = _unitOfWork.Get<LanguageType>(a => a.Code == "zh-CN"); // _unitOfWork.RegisterDeleted<LanguageType>(language.Result); // _unitOfWork.CommitAsync(); //} //catch (Exception ex) //{ // _unitOfWork.Rollback(); //} //using (var context = new TradeDbContext(_serviceProvider.GetRequiredService<DbContextOptions<TradeDbContext>>())) //{ // using (var tran = context.Database.BeginTransaction()) // { // try // { // context.LanguageType.Add(new LanguageType() // { // Code = "zh-CN", // Images = "zhcn.jpg", // Title = "中文", // CreateTime = DateTime.Now, // LastUpdateTime = DateTime.Now, // LastUpdateUserID = Vic.Core.Utils.ConstDefine.SuperAdminID, // CreatorID = Vic.Core.Utils.ConstDefine.SuperAdminID, // }); // context.PlateSetting.AddRange(new PlateSetting() // { // Key = "test", // Tag = "test", // Value = "test", // CreateTime = DateTime.Now, // LastUpdateTime = DateTime.Now, // LastUpdateUserID = Vic.Core.Utils.ConstDefine.SuperAdminID, // CreatorID = Vic.Core.Utils.ConstDefine.SuperAdminID, // }, new PlateSetting() // { // Key = "test", // Tag = "test", // Value = "test", // CreateTime = DateTime.Now, // LastUpdateTime = DateTime.Now, // LastUpdateUserID = Vic.Core.Utils.ConstDefine.SuperAdminID, // CreatorID = Vic.Core.Utils.ConstDefine.SuperAdminID, // }); // context.SaveChanges(); // tran.Commit(); // } // catch (Exception ex) // { // tran.Rollback(); // } // } //} //try //{ // _unitOfWork.BeginTransaction(); // var setting = new PlateSetting() // { // Key = "test", // Tag = "test", // Value = "test", // CreateTime = DateTime.Now, // LastUpdateTime = DateTime.Now, // LastUpdateUserID = Vic.Core.Utils.ConstDefine.SuperAdminID, // CreatorID = Vic.Core.Utils.ConstDefine.SuperAdminID, // }; // _unitOfWork.RegisterNew<PlateSetting>(setting); // var language = new LanguageType() // { // Code = "zh-CN", // Images = "zhcn.jpg", // Title = "中文", // CreateTime = DateTime.Now, // LastUpdateTime = DateTime.Now, // LastUpdateUserID = Vic.Core.Utils.ConstDefine.SuperAdminID, // CreatorID = Vic.Core.Utils.ConstDefine.SuperAdminID, // }; // _unitOfWork.RegisterNew<LanguageType>(language); // _unitOfWork.CommitAsync(); //} //catch (Exception ex) //{ // _unitOfWork.Rollback(); //} var data = _plateSettingAppService.List(); data = _plateSettingAppService.ListByReadOnlyDB(); this.ModelState.Clear(); Home_ViewModel VM = new Home_ViewModel(DateTime.Now.Year); return(View("About", VM)); }