public string SetDailySchedule(string doctorID, DayOfWeek dayOfWeek, int am) { string setting = null; switch (dayOfWeek) { case DayOfWeek.Sunday: setting = "Sun"; break; case DayOfWeek.Monday: setting = "Mon"; break; case DayOfWeek.Tuesday: setting = "Tue"; break; case DayOfWeek.Wednesday: setting = "Wed"; break; case DayOfWeek.Thursday: setting = "Thu"; break; case DayOfWeek.Friday: setting = "Fri"; break; case DayOfWeek.Saturday: setting = "Sat"; break; default: return "Invalid Weekday! @Data"; } if (am > 0) { setting += ":A"; } else { setting += ":P"; } DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities(); Doctor doctor = (from d in DEntities.Doctors where d.DoctorID == doctorID select d).FirstOrDefault(); if (doctor == null) { return "Invalid DoctorID!"; } Schedule schedule = (from s in DEntities.Schedules where s.DoctorID == doctorID select s).FirstOrDefault(); if (schedule == null) { schedule = new Schedule(); schedule.DoctorID = doctor.DoctorID; schedule.Weekday = setting; schedule.LastCheck = DateTime.Now; DEntities.Schedules.AddObject(schedule); } else { schedule.Weekday = setting; schedule.LastCheck = DateTime.Now; } try { DEntities.SaveChanges(); } catch { return "Set Daily Schedule Failed! @Data"; } return null; }
/// <summary> /// 用于向 Schedules EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToSchedules(Schedule schedule) { base.AddObject("Schedules", schedule); }
public string SetExceptionSchedule(string doctorID, DateTime? date) { DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities(); Doctor doctor = (from d in DEntities.Doctors where d.DoctorID == doctorID select d).FirstOrDefault(); if (doctor == null) { return "Invalid DoctorID! @Data"; } if (date == null) { return "Paremeter Date is Null! @Data"; } DateTime newDate = (DateTime)date; DateTime dDate = newDate.Date; if (newDate.CompareTo(dDate.AddHours(12)) >= 0) { dDate = dDate.AddHours(12); } Schedule schedule = (from s in DEntities.Schedules where s.DoctorID == doctorID select s).FirstOrDefault(); if (schedule == null) { schedule = new Schedule(); schedule.DoctorID = doctor.DoctorID; schedule.Exception = dDate; schedule.LastCheck = DateTime.Now; DEntities.Schedules.AddObject(schedule); } else { if (schedule.Addition != null) { if (((DateTime)schedule.Addition) == dDate) { return "Conflict with Additonal Date! @Data"; } } schedule.Exception = dDate; schedule.LastCheck = DateTime.Now; } try { DEntities.SaveChanges(); } catch { return "Set Exceptional Schedule Failed! @Data"; } return null; }
/// <summary> /// 创建新的 Schedule 对象。 /// </summary> /// <param name="doctorID">DoctorID 属性的初始值。</param> public static Schedule CreateSchedule(global::System.String doctorID) { Schedule schedule = new Schedule(); schedule.DoctorID = doctorID; return schedule; }