/// <summary> /// Get Countries by Level /// </summary> /// <param name="level">int level</param> /// <returns>List Countries by Level</returns> public List <CountriesViewModel> GetByLevel(int level) { List <CountriesViewModel> listByLevel = new List <CountriesViewModel>(); string sqlQuery = $"SELECT * FROM Countries WHERE Level = {level}"; SqlDataReader reader = helper.ExecDataReader(sqlQuery); while (reader.Read()) { CountriesViewModel data = new CountriesViewModel { Id = int.Parse(reader["Id"].ToString()), Name = reader["Name"].ToString(), Code = reader["Code"].ToString(), Description = reader["Description"].ToString(), Level = int.Parse(reader["Level"].ToString()), Type = reader["Type"].ToString(), ParentId = int.Parse(reader["ParentId"].ToString()), IsVisible = int.Parse(reader["IsVisible"].ToString()), IsState = bool.Parse(reader["IsState"].ToString()), NameKhongDau = reader["NameKhongDau"].ToString() }; listByLevel.Add(data); } reader.Close(); _conn.Close(); return(listByLevel); }
/// <summary> /// Get allData in VietNam /// </summary> /// <returns>List<CountriesViewModel> : All Data in VietNam</returns> public List <CountriesViewModel> GetAllData() { List <CountriesViewModel> allData = new List <CountriesViewModel>(); string sqlQuery = "SELECT * FROM Countries ORDER BY Level"; SqlDataReader reader = helper.ExecDataReader(sqlQuery); while (reader.Read()) { CountriesViewModel Data = new CountriesViewModel { Id = int.Parse(reader["Id"].ToString()), Name = reader["Name"].ToString(), Code = reader["Code"].ToString(), Description = reader["Description"].ToString(), Level = int.Parse(reader["Level"].ToString()), Type = reader["Type"].ToString(), ParentId = int.Parse(reader["ParentId"].ToString()), IsVisible = int.Parse(reader["IsVisible"].ToString()), IsState = bool.Parse(reader["IsState"].ToString()), NameKhongDau = reader["NameKhongDau"].ToString() }; allData.Add(Data); } reader.Close(); _conn.Close(); return(allData); }
public ActionResult Create(string CoId) { NullChecker.NullCheck(new object[] { CoId }); var curentCompany = unitOfWork.NotExpiredCompanyRepository .GetByID(EncryptionHelper.Unprotect(CoId)); if (curentCompany == null || !curentCompany.Admins.Any(u => AuthorizationHelper.isRelevant(u.UserId))) { return(new RedirectToError()); } CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.countries; //PorT SelectList var PorTs = from PorT e in Enum.GetValues(typeof(PorT)) select new { Id = e, Name = Resource.EnumTypes.ResourceManager.GetString(e.ToString()) }; ViewBag.portDropdown = new SelectList(PorTs, "Id", "Name"); ViewData["company"] = CoId; return(View()); }
async void GetCountriesList(object sender, EventArgs e) { CountriesViewModel cvm = MSProApp.Locator.CountriesVM; WaitLabel.IsVisible = true; GetCountriesListBtn.IsEnabled = false; await cvm.GetCountiesListThread(); CountriesToSelect.ItemsSource = cvm.ExitCountries; SelectedCountries.ItemsSource = cvm.SelectedCountriesList; TotalCountriesLabel.Text = AppStrings.TotalCountries + " " + cvm.TotalCountries.ToString(); TotalExitRelaysLabel.Text = AppStrings.TotalExitRelays + " " + cvm.ExitIPsNum.ToString(); WaitLabel.IsVisible = false; GetCountriesListBtn.IsEnabled = true; SelectedCountriesModeLabel.Text = cvm.SelectedCountriesModeLabelText; SelectedCitiesModeLabel.Text = cvm.SelectedCitiesModeLabelText; GetCountriesListBtn.Text = cvm.GetCountriesListBtnText; WaitLabel.Text = cvm.WaitLabelText; SelectedCountriesLabel.Text = cvm.SelectedCountriesLabelText; ApplySelectedCountries.Text = cvm.ApplySelectedCountriesText; CancelSelectedCountries.Text = cvm.CancelSelectedCountriesText; AddCountryBtn.Text = cvm.AddCountryBtnText; RemoveCountryBtn.Text = cvm.RemoveCountryBtnText; }
public ActionResult PlanRequest(string Plan, PlanType planType) { if (Plan == null) { return(new RedirectToError()); } PlanRequestViewModel viewmodel = new PlanRequestViewModel(); if (planType == PlanType.Company && !PlansPrices.CompanyPlans.ContainsKey(Plan)) { return(new RedirectToError()); } else if (planType == PlanType.Store && !PlansPrices.StorePlans.ContainsKey(Plan)) { return(new RedirectToError()); } else { viewmodel.plan = Plan; CountriesViewModel countries = new CountriesViewModel(); viewmodel.country = countries.countries; return(View(viewmodel)); } //var payTypes = from PayType e in Enum.GetValues(typeof(PayType)) // select new { Id = e, Name = Resource.EnumTypes.ResourceManager.GetString(e.ToString()) }; //viewmodel.payTypeToSelectList = new SelectList(payTypes, "Id", "Name"); ////PayBank SelectList //var payBanks = from PayBank e in Enum.GetValues(typeof(PayBank)) // select new { Id = e, Name = Resource.EnumTypes.ResourceManager.GetString(e.ToString()) }; //viewmodel.bankTypeToSelectList = new SelectList(payBanks, "Id", "Name"); }
public List <CountriesViewModel> GetCountryList() { Query = "SELECT * FROM CountriesViewModel"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { nameOfCountry = Reader["Name"].ToString(); aboutOfCountry = Reader["About"].ToString(); } Reader.Close(); Connection.Close(); Query = "SELECT COUNT(Name) AS NoOfCity,SUM(NoOfDwellers) AS NoOfTotalDwellers FROM CountriesViewModel"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <CountriesViewModel> yCountryList = new List <CountriesViewModel>(); while (Reader.Read()) { CountriesViewModel aCountry = new CountriesViewModel(); aCountry.CountryName = nameOfCountry; aCountry.CountryAbout = aboutOfCountry; aCountry.NoOfCities = (int)Reader["NoOfCity"]; aCountry.NoOfCityDwellers = (int)Reader["NoOfTotalDwellers"]; yCountryList.Add(aCountry); } Reader.Close(); Connection.Close(); return(yCountryList); }
public ActionResult Edit(string CoId) { NullChecker.NullCheck(new object[] { CoId }); var CoToEdit = unitOfWork.NotExpiredCompanyRepository .GetByID(EncryptionHelper.Unprotect(CoId)); if (!CoToEdit.Admins.Any(c => AuthorizationHelper.isRelevant(c.UserId))) { return(new RedirectToNotFound()); } CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.counts(CoToEdit.State); ViewBag.StateDropDown = countries.states(CoToEdit.State); //PorT SelectList var PorTs = from CompanySize e in Enum.GetValues(typeof(CompanySize)) select new { Id = e, Name = Resource.EnumTypes.ResourceManager.GetString(e.ToString()) }; ViewBag.CoSizeDropdown = new SelectList(PorTs, "Id", "Name"); var catss = CoToEdit.Categories.Select(u => u.catID); ViewData["Cats"] = String.Join(",", catss); ViewData["company"] = CoId; return(View(CoToEdit)); }
public ActionResult Edit(string PrId) { NullChecker.NullCheck(new object[] { PrId }); var productToEdit = unitOfWork.ProductRepository .GetByID(EncryptionHelper.Unprotect(PrId)); if (productToEdit.company is CompanyExpired || !productToEdit.company.Admins.Any(u => AuthorizationHelper.isRelevant(u.UserId))) { return(new RedirectToError()); } CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.countries; //PorT SelectList var PorTs = from PorT e in Enum.GetValues(typeof(PorT)) select new { Id = e, Name = Resource.EnumTypes.ResourceManager.GetString(e.ToString()) }; ViewBag.portDropdown = new SelectList(PorTs, "Id", "Name"); ViewData["product"] = PrId; var catss = productToEdit.categories.Select(u => u.catID); ViewData["Cats"] = String.Join(",", catss); return(View(productToEdit)); }
public IActionResult Index(SortingInputModel sorting, int pageId = 1) { if (sorting.OrderBy == null) { sorting = new SortingInputModel() { Ascending = true, OrderBy = "Name", }; } var orderBySelector = GetOrderBySelector(sorting); var skip = DefaultItemsPerPage * (pageId - 1); var countriesViewModel = new CountriesViewModel() { Countries = this.countriesService .GetMany <CountryViewModel>( orderBySelector: orderBySelector, asc: sorting.Ascending, skip: skip, take: DefaultItemsPerPage), Common = new CommonViewModel() { Pagination = this.GetPaginationModel(pageId, this.countriesService.Count()), Sorting = sorting, }, }; return(this.View(countriesViewModel)); }
public ActionResult Create() { CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.countries; return(PartialView()); }
/// <summary> /// Get all Ward by District /// </summary> /// <param name="IdDistrict"></param> /// <returns>List<CountriesViewModel></returns> public List <CountriesViewModel> GetAllWardByDistrict(int IdDistrict) { List <CountriesViewModel> listWard = new List <CountriesViewModel>(); string sqlQuery = "SELECT * FROM Countries WHERE ParentId = @ParentId ORDER BY Name"; object[] _params = new object[] { new SqlParameter("ParentId", IdDistrict.ToString()) }; SqlDataReader reader = helper.ExecDataReader(sqlQuery, _params); while (reader.Read()) { CountriesViewModel Ward = new CountriesViewModel { Id = int.Parse(reader["Id"].ToString()), Code = reader["Code"].ToString(), Name = reader["Name"].ToString(), Description = reader["Description"].ToString(), Level = int.Parse(reader["Level"].ToString()), Type = reader["Type"].ToString(), ParentId = int.Parse(reader["ParentId"].ToString()), IsVisible = int.Parse(reader["IsVisible"].ToString()), IsState = bool.Parse(reader["IsState"].ToString()), NameKhongDau = reader["NameKhongDau"].ToString() }; listWard.Add(Ward); } reader.Close(); _conn.Close(); return(listWard); }
void CancelCountriesList(object sender, EventArgs e) { CountriesViewModel cvm = MSProApp.Locator.CountriesVM; cvm.CancelSelectedCountriesList(); DisplayAlert("Mask Surf Pro", AppStrings.CountriesCancelled, AppStrings.OK); }
// Get all countries public static CountriesViewModel GetCountries() { CountriesViewModel model = new CountriesViewModel(); model.Countries = Startup.openAQHelper.GetCountries(); return(model); }
public ActionResult Recipies(int recipieId) { CountriesViewModel myView = new CountriesViewModel() { Recipie = _worldRecipiesRepository.GetRecipie(recipieId) }; return(View(myView)); }
public ActionResult Update([DataSourceRequest] DataSourceRequest request, CountriesViewModel item) { if (item != null && ModelState.IsValid) { repo.Update(item); } return(Json(new[] { item }.ToDataSourceResult(request, ModelState))); }
private void paisesMenuItem_Click(object sender, Telerik.Windows.RadRoutedEventArgs e) { var paisesWin = new CountriesView(); var paisesViewModel = new CountriesViewModel(); paisesWin.DataContext = paisesViewModel; paisesWin.ShowDialog(); }
public ActionResult Index(int countryId) { CountriesViewModel myView = new CountriesViewModel() { Recipies = _worldRecipiesRepository.GetRecipies(countryId).ToList() }; return(View(myView)); }
public ActionResult Destroy([DataSourceRequest] DataSourceRequest request, CountriesViewModel item) { if (item != null) { repo.Destroy(item); } return(Json(new[] { item }.ToDataSourceResult(request, ModelState))); }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user try { var isEmail = unitOfWork.UserRepository.Get(u => u.Email == model.Email).Any(); if (isEmail) { throw new MembershipCreateUserException(MembershipCreateStatus.DuplicateEmail); } string confirmationToken = WebSecurity.CreateUserAndAccount( model.UserName, model.Password, new { model.Birthday, model.Email, model.stateID, model.firstName, model.firstNameEN, model.lastName, model.lastNameEN, model.gender }, true); try { UserMailer.Registraion(new MailRgisterConfirmationViewModel { EmailAddress = model.Email, DisplayName = model.firstName + " " + model.lastName, UserName = model.UserName, Token = confirmationToken }).Send(); } catch { ViewData["errorMess"] = ControllerError.registerActivationEmailError; ViewData["link"] = Url.Action("ResendConfirmationToken", "Account"); return(View("~/Views/Error/CustomError.cshtml")); } return(RedirectToAction("RegisterStepTwo", "Account")); } catch (MembershipCreateUserException e) { CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.countries; ModelState.AddModelError("", GetErrorMessage(e.StatusCode)); } } // If we got this far, something failed, redisplay form return(View(model)); }
void AddSelectedCountry(object sender, EventArgs e) { CountriesViewModel cvm = MSProApp.Locator.CountriesVM; string Selected = CountriesToSelect.SelectedItem.ToString().Replace(" ", "|"); string[] Temp = Selected.Split('|'); string Country = Temp[0]; cvm.AddSelectedCountry(Country); }
/// <summary> /// Obtiene todos los datos relacionados con el país /// </summary> /// <returns>La vista con la lista de todos los países</returns> public async Task <ActionResult <CountriesViewModel> > GetCountries() { var countries = await GetRequestData <IEnumerable <Countries> >(AppSettingsConfig.COUNTRIES_KEY); var countriesViewModel = new CountriesViewModel() { Countries = countries.OrderBy(c => c.Country) }; return(View("Index", countriesViewModel)); }
protected override void OnAppearing() { base.OnAppearing(); CountriesViewModel cvm = MSProApp.Locator.CountriesVM; cvm.LoadSettings(); SelectedCountries.ItemsSource = cvm.SelectedCountriesList; TotalCountriesLabel.Text = AppStrings.TotalCountries + " " + cvm.TotalCountries.ToString(); TotalExitRelaysLabel.Text = AppStrings.TotalExitRelays + " " + cvm.ExitIPsNum.ToString(); }
public ActionResult Register() { if (Request.IsAuthenticated) { return(RedirectToAction("Home", "UserProfile")); } CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.countries; return(View()); }
public CountriesViewModel GetCountries() { CountriesViewModel vm = new CountriesViewModel(); repository.Execute(session => { var contries = session.Query <Entities.Lookup.Country>().ToList(); vm.Countries = AutoMapper.Mapper.Map <List <Cherries.Models.Lookup.Country> >(contries); }); return(vm); }
private CountriesViewModel GetByCountryID(int id) { CountriesBLL CountriesBLL = new HCMBLL.CountriesBLL(); CountriesBLL = CountriesBLL.GetByCountryID(id); CountriesViewModel CountryVM = new CountriesViewModel(); if (CountriesBLL != null) { CountryVM.CountryID = CountriesBLL.CountryID; CountryVM.CountryName = CountriesBLL.CountryName; } return(CountryVM); }
void ApplyCountriesList(object sender, EventArgs e) { CountriesViewModel cvm = MSProApp.Locator.CountriesVM; if (cvm.ApplySelectedCountriesList()) { DisplayAlert("Mask Surf Pro", AppStrings.CountriesSelected, AppStrings.OK); } else { DisplayAlert(AppStrings.Warning, AppStrings.CountriesNotSelected, AppStrings.OK); } SelectedCountries.ItemsSource = cvm.SelectedCountriesList; }
void RemoveSelectedCountry(object sender, EventArgs e) { if (SelectedCountries.SelectedItem == null) { return; } CountriesViewModel cvm = MSProApp.Locator.CountriesVM; string Selected = SelectedCountries.SelectedItem.ToString().Replace(" ", "|"); string[] Temp = Selected.Split('|'); string Country = Temp[0]; cvm.RemoveSelectedCountry(Country); }
public async Task <IActionResult> Accounts(string id) { var currentUser = await this.GetUserDetailsAsync(); if (string.IsNullOrEmpty(id) || !id.Equals(currentUser.Id)) { return(RedirectToAction(nameof(Index))); } var modelPendings = await this.pendingList.AllAsync(currentUser.IdLogin, PendingTransactionCode, currentUser.Sandbox); var processMap = await this.countries.ProcessMapByIdAsync(currentUser.Id); var modelCountries = this.countries.CountryList(processMap); var modelMining = this.mining.MiningByUserId(currentUser.Id); var cvm = new CountriesViewModel(); foreach (var model in modelCountries) { cvm.CountryList.Add(model); } foreach (var model in modelMining) { cvm.MiningList.Add(model); } foreach (var model in modelPendings) { cvm.PendingList.Add(model); } var previousTransactionId = HttpContext.Session.Get <int>("PreviousTransactionId"); if (previousTransactionId != default(int)) { cvm.PreviousTransaction = this.transaction.PreviousTransaction(previousTransactionId); } if (HttpContext.Session.Get <DateTime>("StartDate") == default(DateTime)) { HttpContext.Session.Set <DateTime>("StartDate", DateTime.Now); } return(View(cvm)); }
public ActionResult EditInfo(string UId) { NullChecker.NullCheck(new object[] { UId }); var uid = EncryptionHelper.Unprotect(UId); if (!AuthorizationHelper.isRelevant((int)uid)) { return(new RedirectToError()); } var user = unitOfWork.ActiveUserRepository.GetByID(uid); CountriesViewModel countries = new CountriesViewModel(); ViewBag.CountryDropDown = countries.counts(user.State); ViewBag.StateDropDown = countries.states(user.State); return(View(user)); }
public ActionResult Edit(string expID) { NullChecker.NullCheck(new object[] { expID }); CountriesViewModel countries = new CountriesViewModel(); var expToEdit = unitOfWork.ExperienceRepository .GetByID(EncryptionHelper.Unprotect(expID)); if (!AuthorizationHelper.isRelevant(expToEdit.userID)) { throw new JsonCustomException(ControllerError.ajaxErrorEducationUser); } ViewBag.CountryDropDown = countries.counts(expToEdit.State); ViewBag.StateDropDown = countries.states(expToEdit.State); return(PartialView(expToEdit)); }