public ActionResult Branch_Wise_Trainer_Index(Int64 ID, Int64 IDS) { try { Session["ID"] = ID; Session["IDS"] = IDS; var demo = db.Trainers.Join(db.Branches, u => u.Branvch_ID, j => j.ID, (u, j) => new { Trainer = u, Branch = j }).Where(i => i.Branch.ID == i.Trainer.Branvch_ID && i.Trainer.Role_ID == IDS && i.Branch.ID == ID).OrderByDescending(i => i.Trainer.ID).ToList(); List <TrainerBranchModel> TrainerBranchModelList = new List <TrainerBranchModel>(); foreach (var d in demo) { TrainerBranchModel trainerBranchModel = new TrainerBranchModel(); BranchModel branchModel = new BranchModel(); TrainerModel trainerModel = new TrainerModel(); branchModel.Name = d.Branch.Name; trainerModel.Branvch_ID = d.Trainer.Branvch_ID; trainerModel.Email_ID = d.Trainer.Email_ID; trainerModel.First_Name = d.Trainer.First_Name; trainerModel.Last_Name = d.Trainer.Last_Name; trainerModel.ID = d.Trainer.ID; trainerModel.Role_ID = d.Trainer.Role_ID; trainerBranchModel.Trainer = trainerModel; trainerBranchModel.Branch = branchModel; TrainerBranchModelList.Add(trainerBranchModel); } return(View(TrainerBranchModelList)); } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public ActionResult GYM_Wise_Trainer_Create() { try { TrainerModel trainerModel = new TrainerModel(); if (Convert.ToInt32(Session["IDS"]) == 2) { ViewBag.trainer = "Create Manager"; trainerModel.Role_ID = 2; } if (Convert.ToInt32(Session["IDS"]) == 3) { ViewBag.trainer = "Create Trainer"; trainerModel.Role_ID = 3; } int GYM_ID = Convert.ToInt32(Session["GYM_ID"]); var Branches = db.Branches.Where(i => i.GYM_ID == GYM_ID && i.IS_Active == true).ToList(); ViewBag.Branch_NAME = Branches; return(View(trainerModel)); } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public ActionResult Branch_Wise_Trainer_Edit(Int64 ID) { try { if (Convert.ToInt32(Session["IDS"]) == 2) { ViewBag.trainer = "Edit Manager"; } if (Convert.ToInt32(Session["IDS"]) == 3) { ViewBag.trainer = "Edit Trainer"; } var Details = db.Trainers.Where(b => b.ID == ID).FirstOrDefault(); if (Details != null) { TrainerModel Trainer = new TrainerModel(); var Branches = db.Branches.ToList(); ViewBag.Branch_NAME = Branches; Trainer.Branvch_ID = Convert.ToInt32(Session["ID"]); var Trainers = Mapper.Map <TrainerModel>(Details); return(View(Trainers));; } else { return(View()); } } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public IActionResult SetTrainer(TrainerModel model) { this.courses.AddTrainer(model); TempData["TrainerSet"] = TrainerSet; return(this.RedirectToAction(nameof(CoursesController.Courses), "Courses")); }
public TrainerModel GetByID(int Id) { TrainerModel trainer = new TrainerModel(); try { var _trainer = context.Trainer.First(a => a.Id == Id);// fTrainerFactoryAsync.GetById(Id); trainer.Id = _trainer.Id; trainer.Code = _trainer.Code; trainer.Name = _trainer.Name; trainer.Description = _trainer.Description; trainer.Type = _trainer.IdType; trainer.Active = _trainer.Active; trainer.DateCreated = _trainer.DateCreated; trainer.DateUpdated = _trainer.DateUpdated; trainer.Huella1 = _trainer.Finger1; trainer.Huella2 = _trainer.Finger2; trainer.PhotoLink = _trainer.PhotoLink; trainer.Price = _trainer.Price; } catch (Exception ex) { trainer = null; } return(trainer); }
public bool Update(TrainerModel aModel) { bool result = false; //await Task.Run(() => //{ try { var getToUpdate = context.Trainer.First(a => a.Id == aModel.Id); //.GetById(aModel.Id); getToUpdate.Code = aModel.Code; getToUpdate.Name = aModel.Name; getToUpdate.Description = aModel.Description; getToUpdate.IdType = aModel.Type; getToUpdate.Active = aModel.Active; getToUpdate.DateUpdated = aModel.DateUpdated; getToUpdate.Finger1 = aModel.Huella1; getToUpdate.Finger2 = aModel.Huella2; getToUpdate.Price = aModel.Price; getToUpdate.PhotoLink = aModel.PhotoLink; context.Entry(getToUpdate).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(true); } catch (Exception ex) { result = false; } //}); return(result); }
public int Add(TrainerModel aModel) { int result = 0; //await Task.Run(() => //{ try { Trainer aNew = new Trainer { Name = aModel.Name, Code = aModel.Code, Description = aModel.Description, IdType = aModel.Type, Active = true, DateCreated = DateTime.Now, Finger1 = aModel.Huella1, Finger2 = aModel.Huella2, Price = aModel.Price, PhotoLink = aModel.PhotoLink }; context.Trainer.Add(aNew); context.SaveChanges(); result = aNew.Id; } catch (Exception ex) { result = 0; } //}); return(result); }
public ActionResult Branch_Wise_Trainer_Create() { try { TrainerModel trainerModel = new TrainerModel(); if (Convert.ToInt32(Session["IDS"]) == 2) { ViewBag.trainer = "Create Manager"; trainerModel.Role_ID = 2; } if (Convert.ToInt32(Session["IDS"]) == 3) { ViewBag.trainer = "Create Trainer"; trainerModel.Role_ID = 3; } var Branches = db.Branches.ToList(); ViewBag.Branch_NAME = Branches; trainerModel.Branvch_ID = Convert.ToInt32(Session["ID"]); return(View(trainerModel)); } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public TrainerModel GetTrainerFromDB(string name) { var trainer = new TrainerModel() { Handle = name }; var con = new DBConnect().MyConnection; con.Open(); var querystring = $"SELECT * FROM sql3346222.userCredentials WHERE(TrainerName = '{name}');"; MySqlCommand cmd = new MySqlCommand(querystring, con); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { trainer.Id = int.Parse(rdr[0].ToString()); trainer.HighScore = int.Parse(rdr[5].ToString()); trainer.Lineups = Lineup.DeserializeLineupList(rdr[4].ToString()); trainer.Team = Lineup.DeserializeLineup(rdr[6].ToString()); } rdr.Close(); con.Close(); return(trainer); }
public void UpdateLineups(TrainerModel trainer) { if (trainer.Lineups.Any(l => l.Checked == true)) { trainer.Lineups.Where(l => l.Checked == true).Select(l => l).ToList().ForEach(l => { l.Checked = false; }); // reset the check } if (trainer.Team.TeamId <= 0) { // new team to be saved var nextTeamId = DBConnect.ExecuteScalar($"SELECT TOP 1 TeamId FROM Teams;"); trainer.Team.TeamId = ++nextTeamId; var json = JsonConvert.SerializeObject(trainer.Team); var sql = $"INSERT INTO Teams(TrainerId, JSON) VALUES({trainer.Id}, '{json}');"; DBConnect.ExecuteNonQuery(sql); } trainer.Lineups.ForEach(t => { if (t.TeamId > 0 && t.TeamId != trainer.Team.TeamId) { // new team to be saved var json = JsonConvert.SerializeObject(t); var sql = $"UPDATE Teams SET JSON = '{json}' WHERE TeamId = {t.TeamId};"; DBConnect.ExecuteNonQuery(sql); } }); }
protected ActionResult GetIndex(long userId, UserLanguages userLanguages, long groupId, Action <TrainerModel> modelSetter) { if (WebSettingsConfig.Instance.IsSectionForbidden(SectionId)) { return(RedirectToAction("Index", RouteConfig.MAIN_CONTROLLER_NAME)); } if (IdValidator.IsInvalid(userId) || UserLanguages.IsInvalid(userLanguages) || IdValidator.IsInvalid(groupId)) { return(RedirectToParentPage()); } IUserRepetitionIntervalQuery userRepetitionIntervalQuery = CreateUserRepetitionIntervalQuery(userId, groupId); var trainerHelper = new TrainerHelper(userRepetitionIntervalQuery, userLanguages); TrainerModel model = trainerHelper.GetTrainerModel(Request); modelSetter(model); if (EnumerableValidator.IsNullOrEmpty(model.Items)) { return(RedirectToParentPage()); } ViewData[OurHtmlHelper.ViewDataFlags.SKIP_POPUP_PANEL] = true; return(View("../Trainer/Index", model)); }
[HttpPost("trainer/update")] // https://localhost:44392/api/pokemon/lineup?trainername=srosy public HttpResponseMessage UpdateTrainer([FromBody] TrainerModel trainer) { //CreateLineupDB(trainername, lineupJson); var response = new HttpResponseMessage(); response.StatusCode = HttpStatusCode.OK; return(response); }
public HttpResponseMessage UpdateAvatar([FromBody] TrainerModel trainer) { DoUpdateAvater(trainer); var response = new HttpResponseMessage(); response.StatusCode = HttpStatusCode.OK; return(response); }
public ActionResult DeleteConfirmed(int id) { TrainerModel trainermodel = db.TrainerModel.Find(id); db.TrainerModel.Remove(trainermodel); db.SaveChanges(); return(RedirectToAction("Index")); }
[HttpPost("lineup")] // https://localhost:44392/api/pokemon/lineup public HttpResponseMessage UpdateLineup([FromBody] TrainerModel trainer) { UpdateLineups(trainer); return(new HttpResponseMessage() { StatusCode = HttpStatusCode.OK }); }
[HttpPost("score/update")] // https://localhost:44392/api/pokemon/lineup?trainername=srosy public HttpResponseMessage UpdateScore([FromBody] TrainerModel trainer) { UpdateHighScore(trainer); var response = new HttpResponseMessage(); response.StatusCode = HttpStatusCode.OK; return(response); }
public ActionResult ProjectTrainers(TrainerModel trainerModel) { int message = trainer.ProjectTrainer(trainerModel.VendorId, trainerModel.TrainerId, trainerModel.StartDate, trainerModel.EndDate); GetAvailableTrainers(); //return PartialView("_ProjectTrainers", message); return(View("Index")); }
private Trainer Map(TrainerModel model) { return(new Trainer { ID = model.ID, UserName = model.UserName, Password = model.Password }); }
// // GET: /Trainer/Delete/5 public ActionResult Delete(int id = 0) { TrainerModel trainermodel = db.TrainerModel.Find(id); if (trainermodel == null) { return(HttpNotFound()); } return(View(trainermodel)); }
public ActionResult Edit(TrainerModel trainermodel) { if (ModelState.IsValid) { db.Entry(trainermodel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(trainermodel)); }
/// <summary> /// TO DO REGISTER /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void registerButton_Click(object sender, RoutedEventArgs e) { String firstNameValue = firstNameTextBox.Text.Trim(); String lastNameValue = lastNameTextBox.Text.Trim(); String emailValue = emailTextBox.Text.Trim(); String phoneNumberStringValue = phoneNumberTextBox.Text.Trim(); String passwordValue = passwordPasswordBox.Password.Trim(); String retypedPasswordValue = retypePasswordPasswordBox.Password.Trim(); RegisterPageValidator validator = new RegisterPageValidator(); if (validator.IsInputedDataValid(firstNameValue, lastNameValue, emailValue, phoneNumberStringValue, passwordValue, retypedPasswordValue)) { if (userRadioButton.IsChecked == true) { UserModel u = new UserModel(firstNameValue, lastNameValue, emailValue, phoneNumberStringValue); bool isEmailUnique = isUniqueValue("email", "user_password_table", emailValue); if (isEmailUnique) { insertUserToDataBase(u, passwordPasswordBox.Password, "user_table"); failedRegisterTextBlock.Visibility = Visibility.Collapsed; successRegisterTextBlock.Visibility = Visibility.Visible; } else { failedRegisterTextBlock.Visibility = Visibility.Visible; successRegisterTextBlock.Visibility = Visibility.Collapsed; } } else { TrainerModel t = new TrainerModel(firstNameValue, lastNameValue, emailValue, phoneNumberStringValue); bool isEmailUnique = isUniqueValue("email", "trainer_password_table", emailValue); if (isEmailUnique) { insertUserToDataBase(t, passwordPasswordBox.Password, "trainer_table"); failedRegisterTextBlock.Visibility = Visibility.Collapsed; successRegisterTextBlock.Visibility = Visibility.Visible; } else { failedRegisterTextBlock.Visibility = Visibility.Visible; successRegisterTextBlock.Visibility = Visibility.Collapsed; } } } else { failedRegisterTextBlock.Visibility = Visibility.Visible; successRegisterTextBlock.Visibility = Visibility.Collapsed; } }
public ActionResult TrainerRegistration(TrainerModel Trainer) { if (!ModelState.IsValid) { return(View()); } ViewBag.Tmessage = _service.TrainerRegistration(Trainer); ModelState.Clear(); return(View()); }
public ActionResult Create(TrainerModel trainermodel) { if (ModelState.IsValid) { db.TrainerModel.Add(trainermodel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(trainermodel)); }
private List <TrainerItem> GetOverdueItems(long userId, UserLanguages userLanguages) { IUserRepetitionIntervalQuery userRepetitionIntervalQuery = CreateUserRepetitionIntervalQuery(userId, RepetitionType. Overdue); var trainerHelper = new TrainerHelper(userRepetitionIntervalQuery, userLanguages); TrainerModel model = trainerHelper.GetTrainerModel(Request); List <TrainerItem> items = model.Items; return(items); }
internal static string GetLineups(TrainerModel trainer, [Optional] bool teamOnly) { try { var query = string.Empty; if (teamOnly) { if (trainer.CurrentTeamId > 0) { query = $"SELECT TOP 1 * FROM Teams WHERE TrainerId = {trainer.Id} AND TeamId = {trainer.CurrentTeamId} AND DeleteDate IS NULL;"; } else { query = $"SELECT TOP 1 * FROM Teams WHERE TrainerId = {trainer.Id} AND DeleteDate IS NULL;"; } } else { query = $"SELECT * FROM Teams WHERE TrainerId = {trainer.Id} AND DeleteDate IS NULL;"; } using (var conn = DBConnect.BuildSqlConnection()) { SqlCommand command = new SqlCommand(query, conn); conn.Open(); var rdr = command.ExecuteReader(); var lineups = new List <LineupModel>(); while (rdr.Read()) { var team = new LineupModel(); team.TeamId = int.Parse(rdr[0].ToString()); team.Name = rdr[1].ToString(); var json = rdr[3].ToString(); if (!string.IsNullOrEmpty(json)) { team.Lineup = DeserializePokemonList(json); } team.Text = ""; // TODO lineups.Add(team); } return(JsonConvert.SerializeObject(lineups)); } } catch (Exception ex) { throw new Exception($"Error executing query: {ex.Message}"); } }
private void SelectTrainerAction(object o) { TrainerModel trainer = _displayService.ShowDialog <SelectEntityDialogViewModel <Trainer, TrainerModel>, object, TrainerModel>(); if (trainer == null) { return; } Model.TrainerId = trainer.Id; Model.TrainerCaption = trainer.FullName; }
private void SetModel(string groupName, TrainerModel model) { var pageRequiredData = new PageRequiredData(SectionId.GroupByWords); pageRequiredData.Title = WebSettingsConfig.Instance.GetTemplateText(pageRequiredData.SectionId, PageId.Cards, TemplateId.Title, groupName); pageRequiredData.Keywords = WebSettingsConfig.Instance.GetTemplateText(pageRequiredData.SectionId, PageId.Cards, TemplateId.Keywords, groupName); pageRequiredData.Description = WebSettingsConfig.Instance.GetTemplateText(pageRequiredData.SectionId, PageId.Cards, TemplateId.Description, groupName); model.PageRequiredData = pageRequiredData; model.BreadcrumbsItems = BreadcrumbsHelper.GetWords(Url, groupName, pageRequiredData.Title); model.SetMarkUrl = Url.Action("SetMark", RouteConfig.USER_TRAINER_GROUP_WORDS_CONTROLLER, new { group = groupName + "/" }, Request.Url.Scheme); }
/// <summary> /// Updates the classifier guess on the training page. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> private TrainerModel UpdateClassifier(TrainerModel model) { // ask the naive bayes classifier what it thinks var classifier = new NaiveBayes(); model.UnigramSentiment = classifier.GetTextSentiment(model.CurrentTweet.text, 1, 1, false, null, OclumenContext.BasicNgrams, OclumenContext); model.BigramSentiment = classifier.GetTextSentiment(model.CurrentTweet.text, 2, 1, false, null, OclumenContext.BasicNgrams, OclumenContext); model.UnigramSentimentStemmed = classifier.GetTextSentiment(model.CurrentTweet.text, 1, 1, true, Dictionary, OclumenContext.StemmedNgrams, OclumenContext); model.BigramSentimentStemmed = classifier.GetTextSentiment(model.CurrentTweet.text, 2, 1, true, Dictionary, OclumenContext.StemmedNgrams, OclumenContext); return(model); }
public JsonResult SetMark(HttpRequestBase request, KnowledgeMark mark, UserRepetitionIntervalItem repetitionInterval) { //выставляем оценку if (!_userRepetitionIntervalQuery.SetMark(repetitionInterval, mark)) { return(JsonResultHelper.Error()); } TrainerModel model = GetTrainerModel(request); return (JsonResultHelper.GetUnlimitedJsonResult( new { sourceLanguageId = _userLanguages.From.Id, items = model.Items })); }
public Lineup(TrainerModel ghostTrainer, MySqlConnection con) { PokemonArray = new string[6]; MovesCSVArray = new string[6]; LineupSize = 0; ValidPokemon = false; GhostTrainer = ghostTrainer; Con = con; ReturnedName = "-1"; while (LineupSize <= 6) { PokeFinder(); } AddPokemonToDB(); }