public ActionResult DeleteConfirmed(int id)
{
MeetingEmployee meetingEmployee = db.MeetingEmployees.Find(id);
db.MeetingEmployees.Remove(meetingEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Employee_Id,Meeting_Id,IsRequired")] MeetingEmployee meeting_Employee)
{
if (ModelState.IsValid)
{
db.Entry(meeting_Employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", meeting_Employee.Employee_Id);
ViewBag.Meeting_Id = new SelectList(db.Meetings, "Id", "Topic", meeting_Employee.Meeting_Id);
return(View(meeting_Employee));
}
public ActionResult Create([Bind(Include = "Id,Employee_Id,Meeting_Id,RequirementOption_Id")] MeetingEmployee meetingEmployee)
{
if (ModelState.IsValid)
{
db.MeetingEmployees.Add(meetingEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", meetingEmployee.Employee_Id);
ViewBag.Meeting_Id = new SelectList(db.Meetings, "Id", "Topic", meetingEmployee.Meeting_Id);
ViewBag.RequirementOption_Id = new SelectList(db.RequirementOptions, "Id", "Id", meetingEmployee.RequirementOption_Id);
return(View(meetingEmployee));
}
// GET: MeetingEmployees/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MeetingEmployee meetingEmployee = db.MeetingEmployees.Find(id);
if (meetingEmployee == null)
{
return(HttpNotFound());
}
return(View(meetingEmployee));
}
// GET: MeetingEmployee/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MeetingEmployee meeting_Employee = db.MeetingEmployees.Find(id);
if (meeting_Employee == null)
{
return(HttpNotFound());
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", meeting_Employee.Employee_Id);
ViewBag.Meeting_Id = new SelectList(db.Meetings, "Id", "Topic", meeting_Employee.Meeting_Id);
return(View(meeting_Employee));
}
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));
}
}
