public ActionResult ShowSearch()
{
AssistantViewModel avm = new AssistantViewModel();
avm.assistants = new List <Assistant>();
return(View("SearchAssistants", avm));
}
public ActionResult Submit()
{
AssistantViewModel avm = new AssistantViewModel();
Assistant objAssistant = new Assistant();
objAssistant.AFirstName = Request.Form["assistant.AFirstName"].ToString();
objAssistant.ALastName = Request.Form["assistant.ALastName"].ToString();
objAssistant.AIDNumber = Request.Form["assistant.AIDNumber"].ToString();
objAssistant.AEmployeeNumber = Request.Form["assistant.AEmployeeNumber"].ToString();
objAssistant.IdStudent = Request.Form["assistant.IdStudent"].ToString();
objAssistant.AEmail = Request.Form["assistant.AEmail"].ToString();
objAssistant.APassword = Request.Form["assistant.APassword"].ToString();
AssistantDal dal = new AssistantDal();
if (ModelState.IsValid)
{
//AssistantDal dal = new AssistantDal();
//dal.Assistants.Add(myAssistant);// in memory adding
//dal.SaveChanges();
//return View("Assistant", myAssistant);
dal.Assistants.Add(objAssistant);// in memory adding
dal.SaveChanges();
avm.assistant = new Assistant();
}
//else
// return View("Enter", myAssistant);
else
{
avm.assistant = objAssistant;
}
avm.assistants = dal.Assistants.ToList <Assistant>();
return(View("Enter", avm));
}
public async Task <IActionResult> Create(AssistantViewModel model)
{
if (ModelState.IsValid)
{
var path = string.Empty;
if (model.ImageFile != null && model.ImageFile.Length > 0)
{
path = await _imageHelper.UploadImageAsync(model.ImageFile, "Assistants");
}
try
{
var assistant = _converterHelper.ToAssistant(model, path, true);
assistant.CreatedBy = await _userHelper.GetUserByEmailAsync(User.Identity.Name);
await _assistantRepository.CreateAsync(assistant);
return(RedirectToAction(nameof(Index)));
}
catch (Exception exception)
{
ModelState.AddModelError(string.Empty, exception.Message);
}
}
return(View(model));
}
public async Task <IActionResult> Edit(AssistantViewModel model)
{
if (ModelState.IsValid)
{
try
{
var path = model.ImageUrl;
if (model.ImageFile != null && model.ImageFile.Length > 0)
{
path = await _imageHelper.UploadImageAsync(model.ImageFile, "Assistants");
}
var assistant = _converterHelper.ToAssistant(model, path, false);
assistant.ModifiedBy = await _userHelper.GetUserByEmailAsync(User.Identity.Name);
await _assistantRepository.UpdateAsync(assistant);
}
catch (DbUpdateConcurrencyException)
{
if (!await _assistantRepository.ExistAsync(model.Id))
{
return(new NotFoundViewResult("AssistantNotFound"));
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(model));
}
public Assistant ToAssistant(AssistantViewModel model, string path, bool isNew)
{
return(new Assistant
{
Id = isNew ? 0 : model.Id,
ImageUrl = path,
DateOfBirth = model.DateOfBirth,
CreatedBy = model.CreatedBy,
CreateDate = isNew ? DateTime.Now : model.CreateDate,
UpdateDate = DateTime.Now
});
}
public ActionResult SearchAssistants()
{
AssistantDal dal = new AssistantDal();
string searchValue = Request.Form["txtFirstName"];
List <Assistant> objAssistant =
(from x in dal.Assistants
where x.AFirstName.Contains(searchValue)
select x).ToList <Assistant>();
AssistantViewModel avm = new AssistantViewModel();
avm.assistants = objAssistant;
return(View(avm));
}
// GET: Assistant
public ActionResult Enter()
{
AssistantDal dal = new AssistantDal();
List <Assistant> objAssistant = dal.Assistants.ToList <Assistant>();
AssistantViewModel avm = new AssistantViewModel();
avm.assistant = new Assistant();
avm.assistants = objAssistant;
//AssistantDal dal = new AssistantDal();
return(View(avm));
// return View(new Assistant());
}
public IActionResult Assistant(string id)
{
using (var def = new DoctorContext())
{
var users = UsersInfo.Users;
using (var daef = new DentistAssistantContext())
{
var Notes = (from qaa in daef.Qaa
where qaa.PatientId.ToLower().Equals(id.ToLower()) &&
qaa.Qaqid.Equals(30)
select qaa).FirstOrDefault();
var patientRecords = (from pr in daef.PatientRecords
where pr.PatientSetting.Id.ToUpper().Equals(id.ToUpper())
orderby pr.CreateTime descending
select new PatientRecordUnit()
{
Id = pr.Id,
Room = pr.Room,
UserNo = pr.UserNo,
UserName = users.Where(c => c.UserNo.Equals(pr.UserNo)).FirstOrDefault().UserName,
OrderTime = pr.OrderTime,
ArriveTime = pr.ArriveTime,
DrArriveTime = pr.DrArriveTime,
DrLeaveTime = pr.DrLeaveTime,
PtLeaveTime = pr.PtLeaveTime,
IsFirst = pr.IsFirst,
IsSuggest = pr.IsSuggest,
CreateTime = pr.CreateTime,
PatientSettingId = pr.PatientSettingId,
FdiUnitsF = (from f in pr.Fdis
where f.Type.Equals("F")
select new FdiUnit()
{
Fdi = f,
FdiDetails = f.FdiDetails.ToList()
}).ToList(),
FdiUnitsN = (from f in pr.Fdis
where f.Type.Equals("N")
select new FdiUnit()
{
Fdi = f,
FdiDetails = f.FdiDetails.ToList()
}).ToList(),
RecordUserUnit = (from ru in pr.RecordUsers
select new RecordUserUnit()
{
Id = ru.Id,
UserNo = ru.UserNo,
UserName = users.Where(c => c.UserNo.Equals(ru.UserNo)).FirstOrDefault().UserName,
CreateDate = ru.CreateDate,
PatientRecordId = ru.PatientRecordId
}).ToList()
}).ToList();
AssistantViewModel assistantViewModel = new AssistantViewModel()
{
Patient = (from p in def.Patients
where p.PatNo.ToLower().Equals(id.ToLower()) &&
p.Enable.Equals(true)
select p).FirstOrDefault(),
Notes = Notes == null ? null : Notes.ValueDescription,
IsFinishFirstTime = patientRecords.Where(c => c.IsFirst.Equals(true)).Count() > 0 ? true : false,
PatientRecordUnits = patientRecords.Where(c => c.IsFirst.Equals(false) && c.IsSuggest.Equals(false)).ToList()
};
return(View(assistantViewModel));
}
}
}