public ActionResult UserLogin(userLogin userLogin) { if (ModelState.IsValid) // this is check validity { using (Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities()) { var userCredentials = appoinment_Entities_db.userLogins.Where(a => a.UserName.Equals(userLogin.UserName) && a.Password.Equals(userLogin.Password)).FirstOrDefault(); if (userCredentials != null) { Session["LogedUserID"] = userCredentials.UserID.ToString(); Session["LogedUserFullname"] = userCredentials.FullName.ToString(); Session["LoggedRoleID"] = userCredentials.RoleID.ToString(); if (Convert.ToInt32(Session["LoggedRoleID"].ToString()) == 1) { return(RedirectToAction("CreateUser", userLogin.UserID)); } else if (Convert.ToInt32(Session["LoggedRoleID"].ToString()) == 2) { return(RedirectToAction("ShowAppointment")); } else if (Convert.ToInt32(Session["LoggedRoleID"].ToString()) == 3) { return(RedirectToAction("CreateAppointment")); } } return(View("Index")); } } return(View(userLogin)); }
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 string ValidateMobileNumber(string mobileNumber) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); var mobile = appoinment_Entities_db.user_Info.Where(m => m.mobile_Number == mobileNumber).FirstOrDefault(); if (mobile != null) { return("1"); } else { return("0"); } }
public string ValidateEmailId(string emailId) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); var emailStatus = appoinment_Entities_db.user_Info.Where(m => m.email_Address == emailId).FirstOrDefault(); if (emailStatus != null) { return("1"); } else { return("0"); } }
public ActionResult ShowAppointment() { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointments = new appointmentInfo(); appointments.doctor_Id = Convert.ToInt32(Session["LogedUserID"]); var appointment = appoinment_Entities_db.appointmentInfoes.Where(x => x.doctor_Id == appointments.doctor_Id && x.appointment_Status == false).ToList(); if (appointment.Count != 0) { return(View(appointment)); } else { return(View()); } }
public ActionResult CreateUser() { var userInfo = new user_Info(); if (ModelState.IsValid) // this is check validity { using (var appoinment_Entities_db = new Appoinment_Entities()) { userInfo.CreateRole = appoinment_Entities_db.userRoles.ToList().Select(x => new SelectListItem { Value = x.role_Id.ToString(), Text = x.role_Name }); } return(View(userInfo)); } else { return(View(userInfo)); } }
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")); } }
public ActionResult CreateAppointment(int doctorId, string appointmentTime) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointment = new appointmentInfo(); appointment.patient_Id = Convert.ToInt32(Session["LogedUserID"]); var patientAppointment = appoinment_Entities_db.appointmentInfoes.Where( i => i.patient_Id == appointment.patient_Id && i.appointment_Status == true).ToList(); if (patientAppointment.Count == 0) { userLogin login = new userLogin(); //appointment.appointment_Id = 1; //appointment.appointment_Id = appoinment_Entities_db.appointmentInfoes.Select(c => c.appointment_Id).Count() + 1; appointment.doctor_Id = doctorId; var doctorName = appoinment_Entities_db.userLogins.Where( i => i.UserID == doctorId).Single().FullName; appointment.doctor_Name = doctorName; appointment.patient_Name = appoinment_Entities_db.userLogins.Where( i => i.UserID == appointment.patient_Id).Single().FullName; DateTime date = DateTime.Now; var shortDate = date.Date; appointment.appointment_Date = shortDate; appointment.appointment_Time = TimeSpan.Parse(appointmentTime); appointment.appointment_Status = false; appoinment_Entities_db.appointmentInfoes.Add(appointment); appoinment_Entities_db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Fail", JsonRequestBehavior.AllowGet)); } }
public ActionResult ShowAppointment(int?patientId, string status) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointmentInfo = new appointmentInfo(); appointmentInfo.doctor_Id = Convert.ToInt32(Session["LogedUserID"]); appointmentInfo = appoinment_Entities_db.appointmentInfoes.Where(x => x.patient_Id == patientId && x.doctor_Id == appointmentInfo.doctor_Id).FirstOrDefault(); if (appointmentInfo != null) { if (status == "Confirm") { appointmentInfo.appointment_Status = true; } else { appointmentInfo.appointment_Status = false; } appoinment_Entities_db.appointmentInfoes.Add(appointmentInfo); appoinment_Entities_db.Entry(appointmentInfo).State = System.Data.Entity.EntityState.Modified; appoinment_Entities_db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } return(Json("Fail", JsonRequestBehavior.AllowGet)); }