public ActionResult Create(Consulting consulting)
{
if (consulting.StartConsulting != null)
{
if (consulting.StartConsulting.Date <= DateTime.Now.Date)
{
ModelState.AddModelError("", "Lịch phải sau ngày hiện tại");
}
else
{
var result = VerifyTime(consulting);
if (result != null)
{
ModelState.AddModelError("", "Thời gian không hợp lệ: " + result);
}
}
}
if (ModelState.IsValid)
{
consulting.WebManagerId = User.Identity.GetUserId();
_consultingRepository.Add(consulting);
return(RedirectToAction("Index"));
}
ViewBag.DoctorId = new SelectList(_userRepository.GetAllDoctor(), "Id", "FullName", consulting.DoctorId);
return(View(consulting));
}
public void Update(Consulting consulting)
{
var old = db.Consultings.Find(consulting.ConsultingId);
db.Entry(old).CurrentValues.SetValues(consulting);
db.SaveChanges();
}
public ActionResult Book(Consulting consulting)
{
ViewBag.lstCatePost = _postRepository.GetPost_Category();
var userID = User.Identity.GetUserId();
_consultingRepository.SaveBook(consulting, userID);
return(RedirectToAction("Index", "Home"));
}
public void SaveBook(Consulting consulting, string patientId)
{
var item = db.Consultings.Find(consulting.ConsultingId);
item.Status = true;
item.PatientIssue = consulting.PatientIssue;
item.PatientId = patientId;
db.SaveChanges();
}
public ActionResult EditConsulting(Consulting consulting)
{
if (ModelState.IsValid)
{
_consultingRepository.Update(consulting);
return(RedirectToAction("ConsultingPresent"));
}
ViewBag.lstCatePost = _postRepository.GetPost_Category();
return(View(consulting));
}
// GET: Identity/Consultings/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Consulting consulting = _consultingRepository.Find(id);
if (consulting == null)
{
return(HttpNotFound());
}
return(View(consulting));
}
// GET: Identity/Consultings/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Consulting consulting = _consultingRepository.Find(id);
if (consulting == null)
{
return(HttpNotFound());
}
ViewBag.DoctorId = new SelectList(_userRepository.GetAllDoctor(), "Id", "FullName", consulting.DoctorId);
return(View(consulting));
}
public ActionResult EditConsulting(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Consulting consulting = _consultingRepository.Find(id);
if (consulting == null)
{
return(HttpNotFound());
}
ViewBag.lstCatePost = _postRepository.GetPost_Category();
return(View(consulting));
}
public ActionResult AddConsultingByDoc(Consulting consulting)
{
if (consulting.StartConsulting.Date <= DateTime.Now.Date)
{
return(Json(new { IsSuccess = false, erroMsg = "Lịch phải bắt đầu từ ngày mai !!!" }));
}
var result = VerifyTime(consulting);
if (result == null)
{
_consultingRepository.Add(consulting);
return(Json(new { IsSuccess = true }));
}
else
{
return(Json(new { IsSuccess = false, erroMsg = "Thời gian trùng lặp: " + result }));
}
}
public int add(Consulting con)
{
try
{
string sql = string.Format(@"INSERT INTO `consulting` (`acconunt_id`, `tel`, `remark`, `addtime`, `gender`, `name`) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');", con.acconunt_id, con.tel, con.remark, con.addtime, con.gender, con.name);
int row = MySqlHelper.ExecuteNonQuery(sql);
return(row);
//using (var content = new DBContext())
//{
// string sql = string.Format(@"INSERT INTO `consulting` (`acconunt_id`, `tel`, `remark`, `addtime`, `gender`, `name`) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');", con.acconunt_id, con.tel, con.remark, con.addtime, con.gender, con.name);
// int result = content.Database.ExecuteSqlCommand(sql);
// return result;
//}
}
catch (Exception ex)
{
throw ex;
}
}
public string VerifyTime(Consulting consulting)
{
var nextHour = consulting.StartConsulting.AddHours(1);
var preHour = consulting.StartConsulting.AddHours(-1);
var notAllow = _consultingRepository.GetAll().Where(c => ((c.StartConsulting > preHour && c.StartConsulting <= consulting.StartConsulting && c.ConsultingId != consulting.ConsultingId) ||
(c.StartConsulting > consulting.StartConsulting && c.StartConsulting < nextHour && c.ConsultingId != consulting.ConsultingId)) &&
c.DoctorId.Equals(consulting.DoctorId))
.ToList();
if (notAllow.Count > 0)
{
var result = "";
foreach (var item in notAllow)
{
result += item.StartConsulting.ToString("dd/MM/yyyy HH:mm");
}
return(result);
}
return(null);
}
public void Add(Consulting consulting)
{
db.Consultings.Add(consulting);
db.SaveChanges();
}
