public ClientDetail(int id, ClientDBContext cdb, ServicesDBContext sdb) { client = cdb.Client.Find(id); services = sdb.Services.Find(id); }
public ActionResult PrintDetails(int id) { ServicesDBContext serviceDB = new ServicesDBContext(); ClientDetail cd = new ClientDetail(id, db, serviceDB); if (cd.client == null || cd.services == null) { return RedirectToAction("Index"); } return View(cd); }
public static IQueryable<Services> getTasks(ServicesDBContext db, DateTime date, String dow, int dom) { var tasks = from s in db.Services where // CONDITIONS: these will depend on the Calendar format that we choose //every day, end date defined (s.dtStart <= date && s.dtEnd >= date && s.freq.Equals("daily") && DbFunctions.DiffDays(date, s.dtStart) % s.interval == 0) //s.interval == 1 && || //every day, count defined (s.dtStart <= date && DbFunctions.AddDays(s.dtStart, s.count) >= date && s.freq.Equals("daily") && DbFunctions.DiffDays(date, s.dtStart) % s.interval == 0) || //every week, end date defined (s.dtStart <= date && s.dtEnd >= date && s.freq.Equals("weekly") && s.byDay.Contains(dow) && (DbFunctions.DiffDays(date, DbFunctions.AddDays(s.dtStart, -s.dtStartWD)) / 7) % s.interval == 0) || //every week, count defined (s.dtStart <= date && DbFunctions.AddDays(s.dtStart, s.count * 7) >= date && s.freq.Equals("weekly") && s.byDay.Contains(dow) && (DbFunctions.DiffDays(date, DbFunctions.AddDays(s.dtStart, -s.dtStartWD)) / 7) % s.interval == 0) || //every month, end date defined (s.dtStart <= date && s.freq.Equals("monthly") && DbFunctions.AddMonths(s.dtStart, s.count) >= date && s.byMonthDay == dom && DbFunctions.DiffMonths(date, s.dtStart) % s.interval == 0) || //every month, count defined (s.dtStart <= date && s.freq.Equals("monthly") && s.dtEnd >= date && s.byMonthDay == dom && DbFunctions.DiffMonths(date, s.dtStart) % s.interval == 0) select s; return tasks; }
public ActionResult GetServices(int? id) { if (hasUserAccess()) { if (id.HasValue) { ServicesDBContext serviceDB = new ServicesDBContext(); var tasks = Services.listServices(serviceDB, id); return View(tasks); } else { return RedirectToAction("Index", "Client"); } } return RedirectToAction("Index", "Home"); }
public static List<Services> listServices(ServicesDBContext db, int? id) { String query = "select * from Services where PatientID = " + id.ToString(); var sqlResults = db.Services.SqlQuery(query); return sqlResults.ToList(); }