public ActionResult CreateAppointment()
{
Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities();
List <doctorDetail> doctorDetailsList = new List <doctorDetail>();
//appointment app = new appointment();
userLogin login = new userLogin();
var drafts = appoinment_Entities_db.userLogins.Where(x => x.RoleID == 2).ToList();
if (drafts.Count != 0)
{
foreach (var doc in drafts)
{
doctorDetail docdetail = new doctorDetail();
var docId = appoinment_Entities_db.doctorDetails.Where(
i => i.doctor_Id == doc.UserID).Single();
var userName = appoinment_Entities_db.userLogins.Where(
i => i.UserID == docId.doctor_Id).Single().FullName;
docdetail.startTime = docId.startTime;
docdetail.doctor_Id = docId.doctor_Id;
docdetail.endTime = docId.endTime;
docdetail.Doctor_Name = userName;
List <string> timeIntervals = new List <string>();
TimeSpan? approvedSlots = new TimeSpan();
//var approvedSlots;
var slots = appoinment_Entities_db.appointmentInfoes.Where(x => x.doctor_Id == docdetail.doctor_Id && x.appointment_Status == true).ToList();
DateTime date = Convert.ToDateTime(docId.startTime);
DateTime endDate = Convert.ToDateTime(docId.endTime);
while (date < endDate)
{
timeIntervals.Add(date.ToString("hh:mm:ss"));
date = date.AddMinutes(15);
}
docdetail.Interval = timeIntervals.Select(x => new SelectListItem()
{
Value = x, Text = x
}).ToList();
foreach (var approvedTime in slots)
{
docdetail.Interval.RemoveAll(c => c.Value == Convert.ToString(approvedTime.appointment_Time));
}
doctorDetailsList.Add(docdetail);
}
}
return(View(doctorDetailsList));
}
public ActionResult CreateUser(user_Info userInfo)
{
if (ModelState.IsValid) // this is check validity
{
using (Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities())
{
userLogin userLogin = new userLogin();
doctorDetail doctorDetails = new doctorDetail();
userRole userRole = new userRole();
appoinment_Entities_db.user_Info.Add(userInfo);
appoinment_Entities_db.SaveChanges();
userLogin.FullName = userInfo.first_Name + userInfo.last_Name;
userLogin.RoleID = userInfo.role_Id;
var userName = appoinment_Entities_db.userRoles.Where(
i => i.role_Id == userLogin.RoleID).SingleOrDefault().role_Name;
userLogin.UserID = userInfo.user_Id;
userLogin.UserName = userInfo.email_Address;
userLogin.Password = userInfo.first_Name + "@123";
appoinment_Entities_db.userLogins.Add(userLogin);
appoinment_Entities_db.SaveChanges();
if (userInfo.role_Id == 2)
{
doctorDetails.doctor_Id = userInfo.user_Id;
doctorDetails.startTime = userInfo.doctorDetail.startTime;
doctorDetails.endTime = userInfo.doctorDetail.endTime;
appoinment_Entities_db.doctorDetails.Add(doctorDetails);
appoinment_Entities_db.SaveChanges();
}
}
ViewBag.Message = "User Created Succesfully";
return(View("DisplayMessage"));
}
else
{
return(RedirectToAction("CreateUser", "Home"));
}
}
