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");
//}
}
