public ActionResult Create([Bind(Include = "Id,Description,Date,Time,NoteType,Employee_Id")] Note note)
{
if (ModelState.IsValid)
{
db.Notes.Add(note);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", note.Employee_Id);
return(View(note));
}
public ActionResult Create([Bind(Include = "Id,Start_Time,End_Time,Meeting_Date,Date_Scheduled,Topic,MeetingStatus_id,MeetingType_id,Pause_Start_Time,Pause_End_Time")] Meeting meeting)
{
if (ModelState.IsValid)
{
db.Meetings.Add(meeting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MeetingStatus_id = new SelectList(db.MeetingStatus, "id", "status", meeting.MeetingStatus_id);
ViewBag.MeetingType_id = new SelectList(db.MeetingTypes, "id", "meeting_type", meeting.MeetingType_id);
return(View(meeting));
}
public ActionResult Create([Bind(Include = "Id,Employee_Id,Meeting_Id,IsRequired")] MeetingEmployee meeting_Employee)
{
if (ModelState.IsValid)
{
db.MeetingEmployees.Add(meeting_Employee);
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,Guest_Id")] EmployeeGuest employee_Guest)
{
if (ModelState.IsValid)
{
db.EmployeeGuests.Add(employee_Guest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.Employees, "Id", "F_Name", employee_Guest.Employee_Id);
ViewBag.Guest_Id = new SelectList(db.Guests, "Id", "F_Name", employee_Guest.Guest_Id);
return(View(employee_Guest));
}
public ActionResult Edit([Bind(Include = "Id,F_Name,L_Name,Email,Password,Role_Id,EmployeeStatus,Manager_Id")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Role_Id = new SelectList(db.Roles, "id", "Role1", employee.Role_Id);
return(View(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));
}
}
public void Save()
{
db.SaveChanges();
}
