public ActionResult Edit(ScheduleHealthCare scheduleHealthCare)
{
HealthCareSheduleM_M mm = new HealthCareSheduleM_M();
// var data = db.DoctorScheduleM_M.Where(a=> a.doctorSchedule_schedule == scheduleHealthCare.schedule_id);
// var data1 = db.ScheduleHealthCares.Where(a=> a.schedule_id == scheduleHealthCare.schedule_id );
// var allschedule = db.ScheduleHealthCares.Where(a=> a.schedule_id != scheduleHealthCare.schedule_id);
var health = db.HealthCareSheduleM_M.Where(a => a.hospitalSchedule_shedule == scheduleHealthCare.schedule_id).SingleOrDefault();
var data1 = db.HealthCareSheduleM_M.Where(a => a.ScheduleHealthCare.checkup_date.Value.Year == scheduleHealthCare.checkup_date.Value.Year && a.ScheduleHealthCare.checkup_date.Value.Month == scheduleHealthCare.checkup_date.Value.Month && a.ScheduleHealthCare.checkup_date.Value.Day == scheduleHealthCare.checkup_date.Value.Day && a.Healthcare_Doctor.doctor_id == health.DoctorId && a.ScheduleHealthCare.schedule_isDeleted != true && a.hospitalSchedule_shedule != scheduleHealthCare.schedule_id && ((scheduleHealthCare.checkup_start <= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_end >= a.ScheduleHealthCare.checkup_end) || (scheduleHealthCare.checkup_end >= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_end <= a.ScheduleHealthCare.checkup_end) || (scheduleHealthCare.checkup_start >= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_start <= a.ScheduleHealthCare.checkup_end))).FirstOrDefault();
if (data1 != null)
{
ViewBag.doctorschedule = Languages.Language.scheduleErrDoctor;
return(View(scheduleHealthCare));
}
if (ModelState.IsValid)
{
db.Entry(scheduleHealthCare).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(scheduleHealthCare));
}
public ActionResult Create(ScheduleHealthCare scheduleHealthCare)
{
if (Session["lang"] != null)
{
if (Session["lang"].ToString().Equals("ar-EG"))
{
ViewBag.State = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
}
}
if (ModelState.IsValid)
{
int hos = (int)Session["hos"];
// start > start1 w start1< end
int doctoId = (int)Session["doctorId"];
// data = db.ScheduleHealthCares.Where(a=> a.checkup_date.ToString() == scheduleHealthCare.checkup_date.ToString() && scheduleHealthCare.checkup_start >= a.checkup_start && scheduleHealthCare.checkup_end <= a.checkup_end ); start < db start && end >= end || end >= db start && end <= end || start >= start && start <= endvar
var data1 = db.HealthCareSheduleM_M.Where(a => a.ScheduleHealthCare.checkup_date.Value.Year == scheduleHealthCare.checkup_date.Value.Year && a.ScheduleHealthCare.checkup_date.Value.Month == scheduleHealthCare.checkup_date.Value.Month && a.ScheduleHealthCare.checkup_date.Value.Day == scheduleHealthCare.checkup_date.Value.Day && a.DoctorId == doctoId && a.ScheduleHealthCare.schedule_isDeleted != true && ((scheduleHealthCare.checkup_start <= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_end >= a.ScheduleHealthCare.checkup_end) || (scheduleHealthCare.checkup_end >= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_end <= a.ScheduleHealthCare.checkup_end) || (scheduleHealthCare.checkup_start >= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_start <= a.ScheduleHealthCare.checkup_end))).FirstOrDefault();
//var data = db.ScheduleHealthCares.Where(a => a.checkup_date.ToString() == scheduleHealthCare.checkup_date.ToString() && scheduleHealthCare.checkup_start >= a.checkup_start && scheduleHealthCare.checkup_end <= a.checkup_end);
// var data1 = db.DoctorScheduleM_M.Where(a => a.ScheduleHealthCare.checkup_date.ToString() == scheduleHealthCare.checkup_date.ToString() && scheduleHealthCare.checkup_start >= a.ScheduleHealthCare.checkup_start && scheduleHealthCare.checkup_end <= a.ScheduleHealthCare.checkup_end && a.ScheduleHealthCare.checkup_end < scheduleHealthCare.checkup_start && a.Healthcare_Doctor.doctor_id == doctoId && a.Healthcare_Doctor.HealthCareDoctorM_M.Where(x => x.hospitalDoctor_hospital == hos).FirstOrDefault().HealthCare.hospital_id == hos).SingleOrDefault();
if (data1 != null)
{
ViewBag.doctorschedule = Languages.Language.scheduleErrDoctor;
return(View(scheduleHealthCare));
}
db.ScheduleHealthCares.Add(scheduleHealthCare);
db.SaveChanges();
HealthCareSheduleM_M mm = new HealthCareSheduleM_M();
mm.hospitalSchedule_hospital = hos;
mm.DoctorId = doctoId;
mm.hospitalSchedule_shedule = scheduleHealthCare.schedule_id;
db.HealthCareSheduleM_M.Add(mm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(scheduleHealthCare));
}
