public ActionResult GetMeetings(DropdownViewModel selecteduser)
{
GetUser();
var Meetings = new List <MeetingViewModel>();
using (context = new ETutorEntities())
{
Meetings = context.User_tbl.Where(w => w.Id == selecteduser.id).SelectMany(sm => sm.Meeting_tbl2)
.Where(w => w.IsCanceled == false)
.Select(s => new MeetingViewModel
{
meetingId = s.Id,
description = s.Description,
place = s.Venue,
date = s.MeetingDate.ToString(),
time = s.MeetingDate.ToString(),
createdBy = s.User_tbl.UserName,
createdById = s.CreatedBy,
isOwner = user.userId == s.CreatedBy,
members = s.User_tbl2.Select(ss => new DropdownViewModel
{
id = ss.Id,
label = ss.UserName
}).ToList()
}).OrderByDescending(o => o.meetingId).ToList();
}
return(new JsonResult {
Data = Meetings, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = int.MaxValue
});
}
public List <DropdownViewModel> getPlaylistsDropdown(string username)
{
List <DropdownViewModel> dropdownViewModels = new List <DropdownViewModel>();
OpenConnection();
MySqlCommand cmdGetPlaylists = new MySqlCommand("SELECT id, name FROM playlists WHERE owner= @username ", con);
cmdGetPlaylists.Parameters.AddWithValue("@username", username);
using (reader = cmdGetPlaylists.ExecuteReader())
{
while (reader.Read())
{
DropdownViewModel dropdown = new DropdownViewModel()
{
id = reader.GetInt32("id"),
name = reader.GetString("name")
};
dropdownViewModels.Add(dropdown);
}
}
CloseConnection();
return(dropdownViewModels);
}
public ActionResult DropdownValuesList()
{
DropdownViewModel viewModel = new DropdownViewModel();
short ItemsPerPage = default(short);
short.TryParse(this.Identity.ToItemsPerPage(), out ItemsPerPage);
ViewBag.ItemsPerPage = ItemsPerPage;
return(View("DropdownList", viewModel));
}
public ActionResult BySubmissionSimilarity()
{
var viewModel = new SubmissionSimilarityFiltersInputModel
{
PlagiarismDetectorTypes = DropdownViewModel.GetEnumValues <PlagiarismDetectorType>()
};
return(this.View(viewModel));
}
public ActionResult GetSubmissions(int id)
{
if (!this.CheckIfUserHasProblemPermissions(id))
{
return(this.RedirectToContestsAdminPanelWithNoPrivilegesMessage());
}
this.ViewBag.SubmissionStatusData = DropdownViewModel.GetEnumValues <SubmissionStatus>();
return(this.PartialView("_SubmissionsGrid", id));
}
private void PrepareViewBagData(int?contestId = null)
{
this.ViewBag.TypeData = DropdownViewModel.GetEnumValues <ContestType>();
this.ViewBag.SubmissionExportTypes = DropdownViewModel.GetEnumValues <SubmissionExportType>();
if (contestId.HasValue)
{
// TODO: find a better solution for determining whether a Contest is active or not
this.ViewBag.IsActive = this.contestsData.IsActiveById(contestId.Value);
}
}
public ActionResult GetSubmissions(int id)
{
if (!this.CheckIfUserHasProblemPermissions(id))
{
this.TempData[GlobalConstants.DangerMessage] = "Нямате привилегиите за това действие";
return(this.RedirectToAction("Index", "Contests", new { area = "Administration" }));
}
this.ViewBag.SubmissionStatusData = DropdownViewModel.GetEnumValues <SubmissionStatus>();
return(this.PartialView("_SubmissionsGrid", id));
}
public ActionResult GetSubmissions(int id)
{
if (!this.CheckIfUserHasProblemPermissions(id))
{
this.TempData.AddDangerMessage(GlobalConstants.NoPrivilegesMessage);
return(this.RedirectToAction("Index", "Contests", new { area = "Administration" }));
}
this.ViewBag.SubmissionStatusData = DropdownViewModel.GetEnumValues <SubmissionStatus>();
return(this.PartialView("_SubmissionsGrid", id));
}
public async Task <IActionResult> Dropdown(DropdownViewModel model)
{
IEnumerable <ProductViewModel> productNew = await _context.Product
.Where(p => p.Name.StartsWith(model.SelectedProductName))
.Select(a => new ProductViewModel
{
Name = a.Name,
Price = a.Price,
Count = a.Count,
InventoryValue = a.Count * a.Price
}).ToListAsync();
return(View(nameof(List), productNew));
}
public IViewComponentResult Invoke(string category)
{
DropdownViewModel model = new DropdownViewModel();
model.DropdownName = category;
model.DropdownItems = tubes.GetAll()
.Where(x => x.Category.CategoryName == category)
.OrderBy(x => x.Type)
.Select(x => x.Type)
.Distinct()
.ToList();
return(View("Dropdown", model));
}
public async Task <IActionResult> Dropdown()
{
DropdownViewModel model = new DropdownViewModel();
model.product = _productRepository.AllProduct;
model.SelectedProductName = null;
var list = _productRepository.AllProduct.Select(P => new SelectListItem
{
Value = P.Name,
Text = P.Name,
});
model.SelectList = list;
return(this.View(model));
}
public GetDropdownValueResponse GetDropdownValue(GetDropdownValueRequest request)
{
GetDropdownValueResponse response = new GetDropdownValueResponse();
Dropdown dropdown = dropdownRepository.FindBy(request.DropdownID, request.AccountId);
if (dropdown == null)
{
response.Exception = GetDropdownvaluesNotFoundException();
}
else
{
DropdownViewModel dropdownViewModel = Mapper.Map <Dropdown, DropdownViewModel>(dropdown);
response.DropdownValues = dropdownViewModel;
}
return(response);
}
public async Task <IActionResult> Cart()
{
// Initialization.
DropdownViewModel model = new DropdownViewModel();
model.SelectedProductId = "";
var p = await ApiClientFactory.Instance.GetProducts();
var selItems = GetProductList(p);
this.ViewBag.ProductList = selItems;
ViewBag.MyProducts = JsonConvert.SerializeObject(p);
ViewData["Message"] = "Your contact page.";
return(View(model));
}
private void AddCheckersAndProblemGroupsToProblemViewModel(
DetailedProblemViewModel problem,
short numberOfProblemGroups)
{
problem.AvailableCheckers = this.Data.Checkers.All()
.Select(checker => new SelectListItem
{
Text = checker.Name,
Value = checker.Name,
Selected = checker.Name.Contains("Trim")
});
if (numberOfProblemGroups > 0)
{
this.ViewBag.GroupNumberData = DropdownViewModel.GetFromRange(1, numberOfProblemGroups);
}
}
public ActionResult InsertDropdown(string dropdownViewModel)
{
DropdownViewModel viewModel = JsonConvert.DeserializeObject <DropdownViewModel>(dropdownViewModel);
viewModel.AccountID = this.Identity.ToAccountID();
foreach (DropdownValueViewModel dvvm in viewModel.DropdownValuesList)
{
dvvm.AccountID = viewModel.AccountID;
if (dvvm.IsNewField)
{
dvvm.DropdownValueID = 0;
}
}
InsertDropdownRequest request = new InsertDropdownRequest();
request.DropdownViewModel = viewModel;
dropdownValuesService.InsertDropdownValue(request);
cachingService.AddDropdownValues(this.Identity.ToAccountID());
return(Json(new { success = true, response = "" }, JsonRequestBehavior.AllowGet));
}
public IViewComponentResult Invoke(
string enumTypeName,
string selectedEnumName,
string area,
string controllerName,
string actionName,
string routeParamName,
string returnUrl,
string prependText = "",
string methodType = "post")
{
var enumType = Type.GetType(enumTypeName);
DataValidator.ValidateEnumType(enumType);
DataValidator.ValidateNotEmptyEnum(enumType, ErrorConstants.EmptyEnum);
DataValidator.ValidateEnumValue(selectedEnumName, enumType);
area = GetArea(area);
controllerName = GetControllerName(controllerName);
actionName = GetActionName(actionName);
returnUrl = GetReturnUrl(returnUrl);
var enumNames = Enum.GetNames(enumType);
var model = new DropdownViewModel()
{
SelectedSortName = selectedEnumName,
SortNames = enumNames,
AreaName = area,
ControllerName = controllerName,
ActionName = actionName,
ReturnUrl = returnUrl,
ParameterName = routeParamName,
PrependText = prependText,
MethodType = methodType
};
return(View(model));
}
private void AddCheckersAndProblemGroupsToProblemViewModel(
ViewModelType problem,
int numberOfProblemGroups,
bool isOnlineContest)
{
problem.AvailableCheckers = this.checkersData
.GetAll()
.Select(checker => new SelectListItem
{
Text = checker.Name,
Value = checker.Name,
Selected = checker.Name.Contains("Trim")
});
if (isOnlineContest && numberOfProblemGroups > 0)
{
this.ViewBag.ProblemGroupIdData = this.problemGroupsData
.GetAllByContest(problem.ContestId)
.OrderBy(pg => pg.OrderBy)
.Select(DropdownViewModel.FromProblemGroup);
}
this.ViewBag.ProblemGroupTypeData = DropdownViewModel.GetEnumValues <ProblemGroupType>();
}
public IActionResult Pokemon(string name)
{
int pokemonId = selectedPokemonId;
int generationId = selectedGenerationId;
selectedPokemonId = 0;
selectedGenerationId = 0;
name = this.dataService.FormatPokemonName(name);
Pokemon pokemon = this.dataService.GetPokemon(name);
if (pokemonId == 0)
{
pokemonId = pokemon.Id;
}
if (generationId == 0)
{
generationId = this.dataService.GetPokemonGameDetails(pokemonId).Last().Game.GenerationId;
}
if (pokemon?.IsComplete == true)
{
List <PokemonViewModel> pokemonList = new List <PokemonViewModel>();
PokemonViewModel pokemonDetails = this.dataService.GetPokemonDetails(pokemon, null, this.appConfig);
pokemonDetails.SurroundingPokemon = this.dataService.GetSurroundingPokemon(pokemon.Id);
pokemonList.Add(pokemonDetails);
List <Pokemon> altForms = this.dataService.GetAltForms(pokemon.Id);
if (altForms.Count > 0)
{
Form form;
foreach (var p in altForms)
{
if (p.IsComplete)
{
form = this.dataService.GetFormByAltFormId(p.Id);
pokemonDetails = this.dataService.GetPokemonDetails(p, form, this.appConfig);
pokemonList.Add(pokemonDetails);
}
}
}
List <int> pokemonIds = pokemonList.ConvertAll(x => x.Pokemon.Id);
if (pokemonIds.IndexOf(pokemonId) == -1)
{
pokemonId = pokemon.Id;
}
AdminPokemonDropdownViewModel model = new AdminPokemonDropdownViewModel()
{
PokemonList = pokemonList,
PokemonId = pokemonId,
GenerationId = generationId,
};
if (this.User.IsInRole("Owner"))
{
AllAdminPokemonViewModel allAdminPokemon = this.dataService.GetAllAdminPokemonDetails();
DropdownViewModel dropdownViewModel = new DropdownViewModel()
{
AllPokemon = allAdminPokemon,
AppConfig = this.appConfig,
};
AdminGenerationTableViewModel adminDropdown = new AdminGenerationTableViewModel()
{
PokemonList = new List <Pokemon>(),
DropdownViewModel = dropdownViewModel,
AppConfig = this.appConfig,
};
foreach (var p in pokemonList)
{
adminDropdown.PokemonList.Add(p.Pokemon);
}
model.AdminDropdown = adminDropdown;
}
return(this.View(model));
}
else
{
return(this.RedirectToAction("AllPokemon", "Home"));
}
}
public PlaylistSongsViewModel getPlaylistSongs(int id, string username)
{
PlaylistSongsViewModel playlistSongs = new PlaylistSongsViewModel();
if (this.OpenConnection())
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM playlists Where id = @playlistId", con);
cmd.Parameters.AddWithValue("@playlistId", id);
using (reader = cmd.ExecuteReader())
{
while (reader.Read())
{
playlistSongs.id = reader.GetInt32("id");
playlistSongs.name = reader.GetString("name");
playlistSongs.owner = reader.GetString("owner");
}
}
MySqlCommand cmdSongs = new MySqlCommand("SELECT * From playlistsongs INNER JOIN songs ON playlistsongs.songId = songs.id WHERE playlistsongs.playlistId = @playlistId", con);
cmdSongs.Parameters.AddWithValue("@playlistId", id);
using (reader = cmdSongs.ExecuteReader())
{
while (reader.Read())
{
SongWithArtist song = new SongWithArtist()
{
id = reader.GetInt32("songId"),
title = reader.GetString("title"),
artist = reader.GetInt32("artist"),
duration = reader.GetString("duration")
};
playlistSongs.songs.Add(song);
}
}
foreach (var song in playlistSongs.songs)
{
MySqlCommand cmdArtistName = new MySqlCommand("SELECT name FROM artists Where id = @artistId ", con);
cmdArtistName.Parameters.AddWithValue("@artistId", song.artist);
using (reader = cmdArtistName.ExecuteReader())
{
while (reader.Read())
{
song.nameOfArtist = reader.GetString("name");
}
}
}
MySqlCommand cmdGetPlaylists = new MySqlCommand("SELECT id, name FROM playlists WHERE owner= @username ", con);
cmdGetPlaylists.Parameters.AddWithValue("@username", username);
using (reader = cmdGetPlaylists.ExecuteReader())
{
while (reader.Read())
{
DropdownViewModel dropdown = new DropdownViewModel()
{
id = reader.GetInt32("id"),
name = reader.GetString("name")
};
playlistSongs.dropdownList.Add(dropdown);
}
}
}
this.CloseConnection();
return(playlistSongs);
}
public ControllerHelper(string courseId = "", string levelId = "", string contentId = "", string questionId = "", string keyword = "", string orderBy = "", string isAscending = "")
{
CourseId = courseId;
LevelId = levelId;
ContentId = contentId;
QuestionId = questionId;
Keyword = keyword;
OrderBy = orderBy;
IsAscending = isAscending;
VtaDbContext db = new VtaDbContext();
var defaultItem = new DropdownViewModel()
{
Id = new Guid().ToString(), Name = "All"
};
// filter preparation
var courses = db.Courses.ToDropdownList();
courses.Insert(0, defaultItem);
if (string.IsNullOrWhiteSpace(CourseId))
{
CourseId = defaultItem.Id;
}
var levels = db.Levels.FilterBy(CourseId, x => x.CourseId == CourseId).ToDropdownList();
levels.Insert(0, defaultItem);
if (string.IsNullOrWhiteSpace(LevelId))
{
LevelId = defaultItem.Id;
}
var contents = db.Contents.FilterBy(CourseId, x => x.Level.CourseId == CourseId).FilterBy(LevelId, x => x.LevelId == LevelId).ToDropdownList();
contents.Insert(0, defaultItem);
if (string.IsNullOrWhiteSpace(ContentId))
{
ContentId = defaultItem.Id;
}
var questions = db.Questions.ByCourse(CourseId).ByLevel(LevelId).ByContent(ContentId).ToDropdownList();
questions.Insert(0, defaultItem);
if (string.IsNullOrWhiteSpace(QuestionId))
{
QuestionId = defaultItem.Id;
}
if (string.IsNullOrWhiteSpace(OrderBy))
{
OrderBy = "Modified";
}
if (string.IsNullOrWhiteSpace(IsAscending))
{
IsAscending = "True";
}
// viewbag populate
CoursesSelectList = new SelectList(courses, "Id", "Name", CourseId);
LevelsSelectList = new SelectList(levels, "Id", "Name", LevelId);
ContentsSelectList = new SelectList(contents, "Id", "Name", ContentId);
QuestionsSelectList = new SelectList(questions, "Id", "Name", QuestionId);
OrderBySelectList = new SelectList(new List <string>()
{
"Name", "No", "Modified"
}, OrderBy);
IsAscendingSelectList = new SelectList(new List <string>()
{
"True", "False"
}, IsAscending);
}
private void PrepareViewBagData() => this.ViewBag.TypeData = DropdownViewModel.GetEnumValues <ProblemGroupType>();
private void PrepareViewBagData()
{
this.ViewBag.TypeData = DropdownViewModel.GetEnumValues <ContestType>();
this.ViewBag.SubmissionExportTypes = DropdownViewModel.GetEnumValues <SubmissionExportType>();
}
public ActionResult RenderGrid(int?id)
{
this.ViewBag.SubmissionStatusData = DropdownViewModel.GetEnumValues <SubmissionStatus>();
return(this.PartialView("_SubmissionsGrid", id));
}
public ActionResult Index()
{
this.ViewBag.SubmissionStatusData = DropdownViewModel.GetEnumValues <SubmissionStatus>();
return(this.View());
}
