public async Task <ActionResult> DoctorByBrunche([Bind(Include = "Id,idDoctor,practicsName,insertDate,turnId,city")] DateTimeByDoctor dateTimeByDoctor) { if (ModelState.IsValid) { var resultSelect = (db.DateTimeByDoctor.Where(x => x.insertDate == dateTimeByDoctor.insertDate) .Where(x => x.idDoctor == dateTimeByDoctor.idDoctor) .Where(x => x.city == dateTimeByDoctor.city) .Where(x => x.practicsName == dateTimeByDoctor.practicsName)).ToList(); if (resultSelect.Count == 0) { dateTimeByDoctor.turnId = "0"; db.DateTimeByDoctor.Add(dateTimeByDoctor); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "The doctor is not available"); } } ViewBag.idDoctor = new SelectList(db.Doctor, "idDoctor", "idDoctor", dateTimeByDoctor.idDoctor); ViewBag.practicsName = new SelectList(db.Practics, "practicsName", "practicsName", dateTimeByDoctor.practicsName); ViewBag.practicsName = new SelectList(db.Brunch, "city", "city", dateTimeByDoctor.city); return(View(dateTimeByDoctor)); }
public async Task <ActionResult> DoctorByBrunche(string practicsName) { DateTimeByDoctor doc = new DateTimeByDoctor(); doc.practicsName = practicsName; var resultCity = db.Brunch.Where(x => x.practicsName.Equals(practicsName)).ToList(); var resultDocId = db.Doctor.Where(x => x.practicsName.Equals(practicsName)).ToList(); List <String> listCity = new List <string>(); for (int i = 0; i < resultCity.Count; i++) { listCity.Add(resultCity[i].city); } List <String> listDoc = new List <string>(); for (int i = 0; i < resultDocId.Count; i++) { listDoc.Add(resultDocId[i].idDoctor); } ViewBag.city = new SelectList(listCity, "city"); ViewBag.idDoctor = new SelectList(listDoc, "idDoctor"); return(View(doc)); }
// GET: DateTimeByDoctor/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(id); if (dateTimeByDoctor == null) { return(HttpNotFound()); } //ViewBag.idDoctor = new SelectList(db.Doctor, "idDoctor", "idDoctor", dateTimeByDoctor.idDoctor); ViewBag.city = new SelectList(db.Brunch, "city", "city", dateTimeByDoctor.city); var result = db.Doctor.Where(x => x.practicsName.Equals(dateTimeByDoctor.practicsName)).ToList(); List <string> resSelect = new List <string>(); for (int i = 0; i < result.Count; i++) { resSelect.Add(result[i].idDoctor); } ViewBag.idDoctor = new SelectList(resSelect, "idDoctor"); return(View(dateTimeByDoctor)); }
public async Task <ActionResult> DeleteConfirmed(int id) { DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(id); db.DateTimeByDoctor.Remove(dateTimeByDoctor); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "Id,idDoctor,practicsName,insertDate,turnId")] DateTimeByDoctor dateTimeByDoctor) { if (ModelState.IsValid) { db.Entry(dateTimeByDoctor).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.idDoctor = new SelectList(db.Doctor, "idDoctor", "firstName", dateTimeByDoctor.idDoctor); return(View(dateTimeByDoctor)); }
public async Task <ActionResult> Login(DateTimeByDoctor tmp) { //string flag = "fail"; //if(tmp != null) //{ // //flag = "true"; // return RedirectToAction("SearchDoctor", "DateTimeByDoctor", new { practicsName = tmp.practicsName, city = tmp.city }); //} //return Json(flag, JsonRequestBehavior.AllowGet); return(RedirectToAction("SearchDoctor", "DateTimeByDoctor", new { practicsName = tmp.practicsName, city = tmp.city })); }
// GET: DateTimeByDoctor/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(id); if (dateTimeByDoctor == null) { return(HttpNotFound()); } return(View(dateTimeByDoctor)); }
// GET: AnotherArea/DateTimeByDoctorsAnotherArea/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(id); if (dateTimeByDoctor == null) { return(HttpNotFound()); } ViewBag.idDoctor = new SelectList(db.Doctor, "idDoctor", "firstName", dateTimeByDoctor.idDoctor); return(View(dateTimeByDoctor)); }
public async Task <ActionResult> Create(DateTimeByDoctor dateTimeByDoctor) { return(RedirectToAction("DoctorByBrunche", new { practicsName = dateTimeByDoctor.practicsName })); }
public async Task <ActionResult> CreateUserByBrunc(Turn t, DateTime?date) { if (date.HasValue) { if (ModelState.IsValid) { try { t.hour = ""; db.Turn.Add(t); await db.SaveChangesAsync(); var resultSelect = (db.DateTimeByDoctor .Where(x => x.practicsName.Equals(t.practicsName)) .Where(x => x.turnId.Equals("0")) .Where(x => x.insertDate == date.Value) ).ToList(); if (resultSelect.Count == 1) { int idDateTimeByDoc = resultSelect[0].Id; DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(idDateTimeByDoc); dateTimeByDoctor.turnId = "1"; if (ModelState.IsValid) { db.Entry(dateTimeByDoctor).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } } } catch (Exception) { return(View()); } } } ViewBag.practicsName = new SelectList(db.Practics, "practicsNameId", "practicsName", t.practicsName); var resultDate2 = db.DateTimeByDoctor.Where(x => x.practicsName.Equals(t.practicsName)).ToList(); List <DateTime> resDate = new List <DateTime>(); for (int i = 0; i < resultDate2.Count; i++) { if (resultDate2[i].turnId.Equals("0")) { resDate.Add(resultDate2[i].insertDate); } else { continue; } } var result = db.Brunch.Where(x => x.practicsName.Equals(t.practicsName)).ToList(); List <String> resSelect = new List <string>(); for (int i = 0; i < result.Count; i++) { resSelect.Add(result[i].city); } ViewBag.city = new SelectList(resSelect, "city"); ViewBag.date = new SelectList(resDate, "date"); return(View(t)); }
public async Task <ActionResult> turn(string str) { Turn t = new Turn(); DateTimeByDoctor d = new DateTimeByDoctor(); var dayString = ""; string userId = Session["userId"].ToString(); List <Models.Turn> turn = await db.Turn.ToListAsync(); // IEnumerable<string> userNames = turn.Select(x => x.practicsName); var y = str.Split(' '); var len = y.Length; if (len != 5) { return(RedirectToAction("Inde2", "Home2")); } string actualpracticsName = y[0]; string actualTime = y[1]; string day = y[3]; string month = y[4]; if (day.Equals("one") || day.Equals("1th")) { day = "1"; } if (day.Equals("two") || day.Equals("to") || day.Equals("2th")) { day = "2"; } if (day.Equals("three") || day.Equals("3th")) { day = "3"; } if (day.Equals("four") || day.Equals("for") || day.Equals("4th")) { day = "4"; } if (day.Equals("five") || day.Equals("5th")) { day = "5"; } if (day.Equals("six") || day.Equals("6th")) { day = "6"; } if (day.Equals("seven") || day.Equals("7th")) { day = "7"; } if (day.Equals("eight") || day.Equals("8th")) { day = "8"; } if (day.Equals("nine") || day.Equals("9th")) { day = "9"; } if (day.Equals("ten") || day.Equals("10th")) { day = "10"; } if (day.Equals("eleven") || day.Equals("11th")) { day = "11"; } if (day.Equals("twelve") || day.Equals("12th")) { day = "12"; } if (day.Equals("thirteen") || day.Equals("13th")) { day = "13"; } if (day.Equals("fourteen") || day.Equals("14th")) { day = "14"; } if (day.Equals("fifteen") || day.Equals("15th")) { day = "15"; } if (day.Equals("sixteen") || day.Equals("16th")) { day = "16"; } if (day.Equals("seventeen") || day.Equals("17th")) { day = "17"; } if (day.Equals("eighteen") || day.Equals("18th")) { day = "18"; } if (day.Equals("nineteen") || day.Equals("19th")) { day = "19"; } if (day.Equals("20th")) { day = "20"; } if (day.Equals("21th")) { day = "21"; } if (day.Equals("22th")) { day = "22"; } if (day.Equals("23th")) { day = "23"; } if (day.Equals("24th")) { day = "24"; } if (day.Equals("25th")) { day = "25"; } if (day.Equals("26th")) { day = "26"; } if (day.Equals("27th")) { day = "27"; } if (day.Equals("28th")) { day = "28"; } if (day.Equals("29th")) { day = "29"; } if (day.Equals("30th")) { day = "30"; } if (day.Equals("31th")) { day = "31"; } if (month.Equals("january") || month.Equals("January")) { dayString = "1"; } if (month.Equals("february") || month.Equals("February")) { dayString = "2"; } if (month.Equals("march") || month.Equals("March")) { dayString = "3"; } if (month.Equals("april") || month.Equals("April")) { dayString = "4"; } if (month.Equals("may") || month.Equals("May")) { dayString = "5"; } if (month.Equals("june") || month.Equals("June")) { dayString = "6"; } if (month.Equals("july") || month.Equals("July")) { dayString = "7"; } if (month.Equals("august") || month.Equals("August")) { dayString = "8"; } if (month.Equals("september") || month.Equals("September")) { dayString = "9"; } if (month.Equals("october") || month.Equals("October")) { dayString = "10"; } if (month.Equals("november") || month.Equals("November")) { dayString = "11"; } if (month.Equals("december") || month.Equals("December")) { dayString = "12"; } // var practisTable = db.Practics.Where(x => x.practicsName.Equals(actualpracticsName)).ToList(); var res = db.DateTimeByDoctor.Where(x => x.practicsName.Equals(actualpracticsName)) .Where(x => x.turnId.Equals("0")) .Where(x => x.insertDate.ToString().Contains(actualTime)).ToList() .Where(x => x.insertDate.Day.ToString().Equals(day)).ToList() .Where(x => x.insertDate.Month.ToString().Equals(dayString)).ToList(); //var yyy = practisTable.Count; // var zzz = res.Count; if (res.Count == 1) { string date = day.ToString() + "/" + dayString.ToString() + "/18" + " " + actualTime; DateTime dt = Convert.ToDateTime(date); t.userId = userId; t.hour = ""; t.practicsName = actualpracticsName; t.date = dt.ToString(); t.city = res[0].city; t.comment = ""; t.medicineName = "none"; db.Turn.Add(t); int idDateTimeByDoc = res[0].Id; DateTimeByDoctor dateTimeByDoctor = await db.DateTimeByDoctor.FindAsync(idDateTimeByDoc); dateTimeByDoctor.turnId = "1"; db.Entry(dateTimeByDoctor).State = EntityState.Modified;// מעדכן await db.SaveChangesAsync(); return(RedirectToAction("succefullyInsert")); } else { return(RedirectToAction("failedInsert")); } //bool exists = userNames.Contains(actualpracticsName); //if (exists) //{ // var time = turn.Where(x => x.hour == actualTime).First(); // bool timeExits = time.hour.Contains(actualTime); // if (timeExits) //// { //t.userId = userId; // t.hour = actualTime; // t.practicsName = actualpracticsName; // db.Turn.Add(t); // await db.SaveChangesAsync(); // return Content("The doctor is free at this time"); // } // else // { // return Content("The doctor is full"); // } //} //else //{ // return Content("No such doctor"); //} }