private void AddData(object sender, EventArgs e)
{
if (!CheckAllFields())
{
return;
}
Trainers newTrainer = new Trainers
{
LastName = textBox2.Text,
FirstName = textBox3.Text,
MiddleName = textBox4.Text
};
try
{
using (var db = new SportEntities(SportProgramSettings.ConnectionString))
{
db.Trainers.Add(newTrainer);
db.SaveChanges();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка! Тренер не был добавлен.\nВозникло исключение: " + ex.Message, "Ошибка!");
}
}
private static void SecondTierAction_Add(int secondTierChoice, out int back)
{
Manager manager = new Manager(); // to initialize manager class which includes database inserts
back = 1; // default value to make the loop of the tier again, true for all the choises except the last one
if (secondTierChoice == 1) // Add Course
{
Courses cr = new Courses(); // to initialize and create an entity, then pass it to manager to insert it to db
cr.CreateCourse();
manager.AddCourse(cr);
}
else if (secondTierChoice == 2) // Add Student
{
Students st = new Students();
st.CreateStudent();
manager.AddStudent(st);
}
else if (secondTierChoice == 3) // Add Trainer
{
Trainers tr = new Trainers();
tr.CreateTrainer();
manager.AddTrainer(tr);
}
else if (secondTierChoice == 4) // Add Assignment
{
Assignments ag = new Assignments();
ag.CreateAssignment();
manager.AddAssignment(ag);
}
else
{
back = 0;
}
}
private void DeleteTrainer(object obj)
{
if (MessageBox.Show("Are you Sure You want to Delete this Record?", "Pinna Fitness", MessageBoxButton.YesNoCancel, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
try
{
SelectedTrainer.Enabled = false;
var stat = _trainerService.Disable(SelectedTrainer);
if (stat == string.Empty)
{
Trainers.Remove(SelectedTrainer);
}
else
{
MessageBox.Show("Can't Delete, may be the data is already in use..."
+ Environment.NewLine + stat, "Can't Delete",
MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Can't Delete, may be the data is already in use..."
+ Environment.NewLine + ex.Message + Environment.NewLine + ex.InnerException, "Can't Delete",
MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("TrainersID,TrainerName,Seniority,PhoneNumber,Email")] Trainers trainers)
{
if (id != trainers.TrainersID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(trainers);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TrainersExists(trainers.TrainersID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(trainers));
}
private async void BtnApply_OnClicked(object sender, EventArgs e)
{
//var imageArray = FilesHelper.ReadFully(file.GetStream());
//file.Dispose();
var instructor = new Trainers()
{
Name = EntName.Text,
UserName = EntUserName.Text,
LastName = EntLastName.Text,
//Gender = PickerGender.Items[PickerGender.SelectedIndex],
Phone = EntPhone.Text,
Email = EntEmail.Text,
SchoolId = 1, //EntAcademy.Text,
BeltId = 1, //PickerBelt.Items[PickerBelt.SelectedIndex],
Importe = Convert.ToDouble(PickerRate.Items[PickerRate.SelectedIndex]),
Tarifa = PickerTarifa.Items[PickerTarifa.SelectedIndex],
//City = PickerCity.Items[PickerCity.SelectedIndex],
//OneLineTitle = EntOneLineTitle.Text,
//First = EdtDescription.Text
//,
//ImageArray = imageArray,
};
ApiService apiService = new ApiService();
var response = await apiService.BecomeAnInstructor(instructor);
if (!response)
{
await DisplayAlert("Oops", "Something wrong...", "Cancel");
}
else
{
await DisplayAlert("Congratulations", "You're now an instructor at teachify.", "Alright");
}
}
public void EnsureSeedDataCreated()
{
Trainers.Add(new Trainer()
{
Id = new Guid("8B176CF0-D3E4-4C5E-93DC-CF9F793040AC"), Username = "******"
});
}
public ActionResult Edit(int?id)
{
if (id != null)
{
Trainers tr = db.Trainers.FirstOrDefault(t => t.id == id);
if (tr != null)
{
TrainerVM model = new TrainerVM()
{
Trainer = tr,
Trainers = db.Trainers.ToList(),
Header = "Edit Trainer",
Action = "Edit"
};
return(View("Index", model));
}
else
{
return(HttpNotFound());
}
}
else
{
return(RedirectToAction("Index"));
}
}
public void AddTrainersToCourses(Database db)
{
List <int> cr = db.GetCoursesID();
List <int> tr = db.GetTrainersID();
bool flag = false;
int tr_number;
int cr_number;
do
{
db.ShowTrainers();
tr_number = Helper.GetNumberList(tr, "the number that corresponds to the trainer you want to assign:");
db.ShowCourses();
cr_number = Helper.GetNumberList(cr, "the number that corresponds to the course you want to assign the trainer you picked:");
List <Trainers> tr_list = db.Trainers.ToList();
Trainers tr_target = tr_list.Find(x => x.TID == tr_number);
List <Courses> cr_list = tr_target.Courses.ToList();
foreach (var item in cr_list)
{
if (item.CID == cr_number)
{
flag = true;
Console.WriteLine("Already exists!");
break;
}
}
} while (flag);
try
{
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(queryTrainersPerCourse, connstring);
DataSet dtset = new DataSet();
adapter.Fill(dtset, "TrainersPerCourse");
SqlCommand cmd = new SqlCommand(@"insert into TrainersPerCourse(CID, TID) values (@CID, @TID)", conn);
cmd.Parameters.AddWithValue("@CID", cr_number);
cmd.Parameters.AddWithValue("@TID", tr_number);
adapter.InsertCommand = cmd;
int a = adapter.InsertCommand.ExecuteNonQuery();
if (a == 0)
{
Console.WriteLine("Problem!");
}
else
{
Console.WriteLine("Success!!");
}
adapter.Dispose();
dtset.Dispose();
conn.Close();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex);
}
}
public async Task <IActionResult> Login(Users model)
{
if (ModelState.IsValid)
{
SHA512Managed sha = new SHA512Managed();
string hash = System.Text.Encoding.UTF8.GetString(sha.ComputeHash(System.Text.Encoding.UTF8.GetBytes(model.Password)));
Users user = AppDbContext.db.Users.FirstOrDefault(u => u.Email == model.Email && u.Password == hash);
if (user != null)
{
byte pass = 0;
Athletes a = AppDbContext.db.Athletes.FirstOrDefault(u => u.Id == user);
Trainers t = AppDbContext.db.Trainers.FirstOrDefault(u => u.User == user);
RDSUWorkers r = AppDbContext.db.RDSUWorkers.FirstOrDefault(u => u.User == user);
if (a != null && a.Status >= 0)
{
pass &= 0b00000001;
}
if (t != null && t.Status)
{
pass &= 0b00000010;
}
if (r != null && r.Status)
{
pass &= 0b00000100;
}
return(Ok(new { token = GenerateJWT(user, pass) }));
}
ModelState.AddModelError("", "Некорректные логин и(или) пароль"); // : проверка логина и пароля отдельно
}
return(UnprocessableEntity());
}
static void addNewLoop(availableTypes typeToAdd, Courses course)
{
do
{
switch (typeToAdd)
{
case availableTypes.Trainer:
Trainers newTrainer = createTrainer();
course.addToCourse(newTrainer);
break;
case availableTypes.Student:
Students newStudent = createStudent();
course.addToCourse(newStudent);
break;
case availableTypes.Assignment:
Assignments newAssignment = createAssignment(course);
course.addToCourse(newAssignment);
break;
default:
Console.WriteLine("You cannot add {0} to the DataBase.", typeToAdd);
break;
}
Console.WriteLine("\nWould you like to add another {0} to this Course? (y/n)", typeToAdd);
} while (Helper.yesInput());
}
public ActionResult DeleteConfirmed(int id)
{
Trainers trainers = db.Trainers.Find(id);
db.Trainers.Remove(trainers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddTrainer(string fname, string lname, string subject)
{
int current_id = Trainers.Count + 1;
var trainer = new Trainer(current_id, fname, lname, subject);
Trainers.Add(trainer);
PrivateSchool.OutputTrainer(trainer);
}
public ActionResult Delete(int id)
{
Trainers tr = db.Trainers.FirstOrDefault(p => p.id == id);
db.Trainers.Remove(tr);
db.SaveChanges();
return(new HttpStatusCodeResult(200));
}
public async Task <bool> BecomeAnInstructor(Trainers instructor)
{
var json = JsonConvert.SerializeObject(instructor);
var content = new StringContent(json, Encoding.UTF8, "application/json");
//httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", Preferences.Get("accesstoken", ""));
var response = await httpClient.PostAsync("api/Students", content);
return(response.StatusCode == HttpStatusCode.Created);
}
public ActionResult Edit([Bind(Include = "TrainerID,FirstName,LastName,Email,AreaOfFocus,Phone,TrainerSince")] Trainers trainers)
{
if (ModelState.IsValid)
{
db.Entry(trainers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trainers));
}
private static void RemoveTrainer(string username)
{
Trainer trainer = Trainers.FirstOrDefault(x => x.UserName == username);
if (trainer == null)
{
throw new Exception("There is no such trainer");
}
Trainers.Remove(trainer);
}
public ActionResult Edit([Bind(Include = "TrainerID,FirstName,LastName,Email,Phone,Id")] Trainers trainers)
{
if (ModelState.IsValid)
{
db.Entry(trainers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.AspNetUsers, "Id", "Email", trainers.Id);
return(View(trainers));
}
public ActionResult Create([Bind(Include = "TrainerID,FirstName,LastName,Email,AreaOfFocus,Phone,TrainerSince")] Trainers trainers)
{
if (ModelState.IsValid)
{
db.Trainers.Add(trainers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trainers));
}
public static Trainers chooseTrainer()
{
IndividualPartBModel db = new IndividualPartBModel();
List <Trainers> trainerList = db.Trainers.OrderBy(x => x.lastName).ToList();
HelperDB.showDbByType(trainerList);
int listPosition = Helper.menuSelectionChecker(trainerList.Count, false) - 1;
Trainers trainer = trainerList[listPosition];
return(trainer);
}
internal bool TryAddTrainer(Trainer trainer)
{
if (Trainers.Contains(trainer))
{
return(false);
}
Trainers.Add(trainer);
return(true);
}
private void LoadData(int Id)
{
this.CurrentObjectId = Id;
using (var db = new SportEntities(SportProgramSettings.ConnectionString))
{
Trainers CurrentObject = db.Trainers.Find(Id);
textBox1.Text = CurrentObject.TrainerId.ToString();
textBox2.Text = CurrentObject.LastName;
textBox3.Text = CurrentObject.FirstName;
textBox4.Text = CurrentObject.MiddleName;
}
}
public void AddTrainer()
{
try
{
Trainers.Add(new Trainer(TrainerName, TrainerSurname, System.Int32.Parse(TrainerAge), TrainerGender, TrainerRegion, TrainerHometown, TrainerClass));
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
this.CloseAction();
}
public BattleContext(IList <ITrainer> trainers)
{
foreach (var trainer in trainers)
{
Trainers.Add(CreateTrainer(trainer));
}
foreach (var trainer in Trainers)
{
ActiveTrainers.Add(trainer);
}
}
public string GetTrainerReport(int trainerId, DateTime from, DateTime to, bool isDetailed)
{
StringBuilder sb = new StringBuilder();
using (var db = new SportEntities(SportProgramSettings.ConnectionString))
{
// Находим тренера
Trainers trainer = db.Trainers.Find(trainerId);
// Заполняем шапку отчёта
sb.AppendLine($"Отчёт сформирован {DateTime.Now}");
sb.AppendLine($"Тренер: {trainer.LastName} {trainer.FirstName} {trainer.MiddleName} (TrainerId {trainer.TrainerId})");
sb.AppendLine($"Границы отчёта: С `{from.ToShortDateString()}` ПО `{to.ToShortDateString()}`");
sb.AppendLine();
// Получаем список групп, подконтрольных тренеру
int[] trainerGroupIds = db.Groups.Where(x => x.TrainerId == trainerId).Select(x => x.GroupId).ToArray();
if (trainerGroupIds.Length == 0)
{
sb.AppendLine("Этот тренер не тренирует никаких групп.");
return(sb.ToString());
}
// Получаем список сессий, проведенных тренером за указанный период
var sessions = db.Sessions.Where(x => trainerGroupIds.Contains(x.GroupId) && from <= x.Date && x.Date <= to).OrderBy(x => x.Date).ThenBy(x => x.Time);
if (sessions.Count() == 0)
{
sb.AppendLine("У тренера не было занятий в этом периоде.");
return(sb.ToString());
}
foreach (Sessions s in sessions)
{
int studentsCount = s.StudentsInSessions.Count();
sb.AppendLine($"{s.Date.ToShortDateString()} {s.Time} [ {studentsCount} ] {s.Groups.Name} (GroupId {s.GroupId})");
if (isDetailed)
{
StringBuilder sbStudents = new StringBuilder();
var students = s.StudentsInSessions.ToList();
sbStudents.AppendLine("Ученики:");
if (studentsCount == 0)
{
sbStudents.AppendLine("\t <<никого не было>>");
}
for (int i = 0; i < students.Count; i++)
{
sbStudents.AppendLine($"\t{i + 1}. {students[i].Students.LastName} {students[i].Students.FirstName} {students[i].Students.MiddleName} (StudentId {students[i].Students.StudentId})");
}
sbStudents.AppendLine();
sb.Append(sbStudents.ToString());
}
}
}
return(sb.ToString());
}
private async Task LoadTrainers()
{
var trainers = await trainerLookupDataService.LoadTrainerLookupItemsAsync();
foreach (var trainer in trainers)
{
Trainers.Add(new NavigationItemViewModel(
eventAggregator,
trainer.Id,
trainer.DisplayMember,
nameof(TrainerDetailViewModel)));
}
}
public async Task <IActionResult> Create([Bind("TrainersID,TrainerName,Seniority,PhoneNumber,Email")] Trainers trainers)
{
if (ModelState.IsValid)
{
_context.Add(trainers);
//FacebookAPI
facebook(trainers.TrainerName);
//FacebookAPI
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(trainers));
}
// GET: Trainers/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Trainers trainers = db.Trainers.Find(id);
if (trainers == null)
{
return(HttpNotFound());
}
return(View(trainers));
}
// GET: Trainers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Trainers trainers = db.Trainers.Find(id);
if (trainers == null)
{
return(HttpNotFound());
}
ViewBag.Id = new SelectList(db.AspNetUsers, "Id", "Email", trainers.Id);
return(View(trainers));
}
public void InputTrainerPerCourse()
{
Console.WriteLine("Enter a Course: ");
Course.InputCourse();
Console.WriteLine("How many trainers has the course?");
int j = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Please enter the Trainers: ");
for (int i = 0; i < j; i++)
{
Trainer t = new Trainer();
t.InputTrainer();
Trainers.Add(t);
}
}
static void AddTrainer()
{
Console.Clear();
Console.WriteLine("Please enter a trainer in the following format: \"< FirstName > < LastName > < Subject >\"");
Console.WriteLine("In case of multiple entries use a comma to separate each trainer. Example: \"Konstantinos Takakis Programming,John Doe Gymnastics\"");
string[] trainers = Console.ReadLine().Split(',');
foreach (string trainerInfo in trainers)
{
string[] tokens = trainerInfo.Split(' ');
Trainers.Add(new Trainer(tokens[0], tokens[1], tokens[2]));
}
TrainerMenu();
}
