public ActionResult DeleteConfirmed(int id)
{
EmployeeGuest employeeGuest = db.EmployeeGuests.Find(id);
db.EmployeeGuests.Remove(employeeGuest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Employee_Id,Guest_Id")] EmployeeGuest employeeGuest)
{
if (ModelState.IsValid)
{
db.Entry(employeeGuest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", employeeGuest.Employee_Id);
ViewBag.Guest_Id = new SelectList(db.Guests, "Id", "F_Name", employeeGuest.Guest_Id);
return(View(employeeGuest));
}
// GET: Individuals/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeGuest employeeGuest = db.EmployeeGuests.Find(id);
if (employeeGuest == null)
{
return(HttpNotFound());
}
return(View(employeeGuest));
}
// GET: Individuals/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeGuest employeeGuest = db.EmployeeGuests.Find(id);
if (employeeGuest == null)
{
return(HttpNotFound());
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", employeeGuest.Employee_Id);
ViewBag.Guest_Id = new SelectList(db.Guests, "Id", "F_Name", employeeGuest.Guest_Id);
return(View(employeeGuest));
}
public ActionResult Create(ScheduleMeetingVewModel viewModel, FormCollection formCollection)
{
if (ModelState.IsValid)
{
var meeting = new Meeting()
{
MeetingType_id = viewModel.Meeting.MeetingType_id,
Meeting_Date = viewModel.Meeting.Meeting_Date,
Date_Scheduled = System.DateTime.Today.ToLocalTime(),
Topic = viewModel.Meeting.Topic,
MeetingStatus_id = viewModel.Meeting.MeetingStatus_id,
};
string employee_Id = formCollection["Employee_Id"];
//string isRequired = formCollection["RequirementOption_Id"];
MeetingEmployee meetingEmployee = new MeetingEmployee
{
Meeting_Id = (from mtng in wpgDb.Meetings where mtng.Topic == viewModel.Meeting.Topic select mtng.Id).FirstOrDefault(),
//Meeting_Id = wpgDb.Meetings.Where(x => x.Topic == viewModel.Meeting.Topic).Select(x => x.Id).FirstOrDefault(),
Employee_Id = wpgDb.Employees.Where(x => (x.F_Name + " " + x.L_Name).ToString() == employee_Id).Select(x => x.Id).FirstOrDefault()
};
//meetingEmployee.RequirementOption_Id = wpgDb.RequirementOptions.Where(x => x.IsRequired == isRequired).Select(x => x.Id).FirstOrDefault();
//meetingEmployee.RequirementOption_Id = wpgDb.RequirementOptions.Where(x => x.IsRequired == isRequired).Select(x => x.Id).FirstOrDefault();
//meetingEmployee.RequirementOption_Id = (from reqOption in wpgDb.RequirementOptions where reqOption.IsRequired == isRequired select reqOption.Id).FirstOrDefault();
string guest_Id = formCollection["Guest_Id"];
var employeeGuest = new EmployeeGuest()
{
Guest_Id = wpgDb.Guests.Where(x => (x.F_Name + " " + x.L_Name).ToString() == guest_Id).Select(x => x.Id).FirstOrDefault()
};
wpgDb.Meetings.Add(meeting);
wpgDb.MeetingEmployees.Add(meetingEmployee);
wpgDb.EmployeeGuests.Add(employeeGuest);
wpgDb.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(viewModel));
}
}
