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));
}
