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