public ActionResult Create([Bind(Include = "ID,UserID,InstructorID,Date,Place")] IndividualTraining individualTraining)
{
if (ModelState.IsValid)
{
var user = db.Users.Where(x => x.UserName == User.Identity.Name).First();
individualTraining.UserID = user.ID;
var hour = Int32.Parse(Request.Form["hour"]);
individualTraining.Date = new DateTime(individualTraining.Date.Year, individualTraining.Date.Month, individualTraining.Date.Day, hour, 0, 0);
var check = db.IndividualTrainings.Any(x => x.InstructorID == individualTraining.InstructorID && x.Date.Day == individualTraining.Date.Day && x.Date.Month == individualTraining.Date.Month && x.Date.Year == individualTraining.Date.Year && x.Date.Hour == individualTraining.Date.Hour);
if (check != true)
{
db.IndividualTrainings.Add(individualTraining);
db.SaveChanges();
}
else
{
ViewBag.Err = "Dany trener ma już zarezerwowany trening o tej godzinie";
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "ID", individualTraining.InstructorID);
ViewBag.UserID = new SelectList(db.Users, "ID", "UserName", individualTraining.UserID);
return(View(individualTraining));
}
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "ID", individualTraining.InstructorID);
ViewBag.UserID = new SelectList(db.Users, "ID", "UserName", individualTraining.UserID);
return(View(individualTraining));
}
public ActionResult DeleteConfirmed(int id)
{
IndividualTraining individualTraining = db.IndividualTrainings.Find(id);
db.IndividualTrainings.Remove(individualTraining);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,UserID,InstructorID,Date,Place")] IndividualTraining individualTraining)
{
if (ModelState.IsValid)
{
db.Entry(individualTraining).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "ID", individualTraining.InstructorID);
ViewBag.UserID = new SelectList(db.Users, "ID", "UserName", individualTraining.UserID);
return(View(individualTraining));
}
// GET: IndividualTrainings/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IndividualTraining individualTraining = db.IndividualTrainings.Find(id);
if (individualTraining == null)
{
return(HttpNotFound());
}
return(View(individualTraining));
}
// GET: IndividualTrainings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IndividualTraining individualTraining = db.IndividualTrainings.Find(id);
if (individualTraining == null)
{
return(HttpNotFound());
}
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "ID", individualTraining.InstructorID);
ViewBag.UserID = new SelectList(db.Users, "ID", "UserName", individualTraining.UserID);
return(View(individualTraining));
}
private void BtnConfirm_Click(object sender, RoutedEventArgs e)
{
try
{
if (CmbTraining.SelectedIndex != 0 || CmbPlayer.SelectedIndex != 0 || DPDate.SelectedDate != null)
{
if (VarIdTraining == 0)
{
IndividualTraining addtrain = new IndividualTraining();
addtrain.IdPlayer = CmbPlayer.SelectedIndex + 1;
addtrain.DateStart = (DateTime)DPDate.SelectedDate;
addtrain.Idtraining = CmbTraining.SelectedIndex + 1;
context.IndividualTraining.Add(addtrain);
context.SaveChanges();
MessageBox.Show("Training was successfully added", "Success", MessageBoxButton.OK, MessageBoxImage.Asterisk);
Close();
}
else
{
var editTrain = context.IndividualTraining.Where(i => i.IdIndTra == VarIdTraining).FirstOrDefault();
editTrain.IdPlayer = CmbPlayer.SelectedIndex + 1;
editTrain.Idtraining = CmbTraining.SelectedIndex + 1;
editTrain.DateStart = (DateTime)DPDate.SelectedDate;
context.SaveChanges();
VarIdTraining = 0;
MessageBox.Show("Training was successfully changed", "Success", MessageBoxButton.OK, MessageBoxImage.Asterisk);
Close();
}
}
else
{
MessageBox.Show("Fields cannot be empty", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch
{
MessageBox.Show("Try later!", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
