public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
string PDiagnosisId = string.Empty;
if (Request.Cookies["PatientDiagnosisId"] != null)
{
PDiagnosisId = Request.Cookies["PatientDiagnosisId"].ToString();
}
patientTreatment.PatientDiagnosisId = Int32.Parse(PDiagnosisId);
// patientTreatment.DatePrescribed = myDateTime;
// patientTreatment.DatePrescribed = dateValue.ToString("MM/dd/yyyy hh:mm:ss tt");
//dateValue.;
patientTreatment.DatePrescribed = DateTime.Now;
ViewBag.DateTime = patientTreatment.DatePrescribed.ToString("dd MMMM yyyy HH:mm");
if (ModelState.IsValid)
{
// _context.Add(PatientDiagnosisId);
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PatientDiagnosisId"] = new SelectList(_context.PatientDiagnosis, "PatientDiagnosisId", "PatientDiagnosisId", patientTreatment.PatientDiagnosisId);
ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "Name", patientTreatment.TreatmentId);
return(View(patientTreatment));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
if (ModelState.IsValid)
{
var existingMedication = _context.Medication
.Where(m => m.Name == medication.Name &&
m.ConcentrationCode == medication.ConcentrationCode &&
m.Concentration == medication.Concentration).FirstOrDefault(); //firstordefualt means to return such an object
if (existingMedication != null)
{
TempData["message"] = $"medication {medication.Name} with {medication.Concentration} {medication.ConcentrationCode} already exists";
}
else
{
medication.MedicationTypeId = Convert.ToInt32(medTypeId);
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
ViewData["MedTypeName"] = medTypeName;
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(m => m.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(m => m.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
// ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
if (_context.Medication.Any(x => x.Name == medication.Name))
{
if ((_context.Medication.Any(x => x.Concentration == medication.Concentration)))
{
if (_context.Medication.Any(x => x.ConcentrationCode == medication.ConcentrationCode))
{
ModelState.AddModelError("ConcentrationCode", "You cannot add another medication with same name, concentration and concentration code as the existing medication");
ModelState.AddModelError("Name", "You cannot add another medication with same name, concentration and concentration code as the existing medication");
ModelState.AddModelError("Concentration", "You cannot add another medication with same name, concentration and concentration code as the existing medication");
ModelState.AddModelError(string.Empty, "You cannot add another medication with same name, concentration and concentration code as the existing medication");
}
}
}
if (ModelState.IsValid)
{
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit, "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit, "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
if (ModelState.IsValid)
{
// Do not allow user to create a duplication of Name, Concentration and ConcentrationCode medication
var duplicatedMed = _context.Medication
.Include(m => m.ConcentrationCodeNavigation)
.Include(m => m.DispensingCodeNavigation)
.Include(m => m.MedicationType)
.FirstOrDefault(a => a.Name == medication.Name &&
a.Concentration == medication.Concentration &&
a.ConcentrationCode == medication.ConcentrationCode);
if (duplicatedMed != null)
{
TempData["DuplicatedMedication"] = "Medication exists (same Name, Concentration and ConcentrationCode)!";
}
else
{
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit, "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit, "DispensingCode", "DispensingCode", medication.DispensingCode);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
string MedicationTypeCode = string.Empty;
if (Request.Cookies["MTypeId"] != null)
{
MedicationTypeCode = Request.Cookies["MTypeId"].ToString();
}
else if (HttpContext.Session.GetString("MTypeId") != null)
{
MedicationTypeCode = HttpContext.Session.GetString("MTypeId");
}
var isDuplicate = _context.Medication.Where(r => r.Name == medication.Name && r.Concentration == medication.Concentration &&
r.ConcentrationCode == medication.ConcentrationCode);
if (isDuplicate.Any())
{
ModelState.AddModelError("", "There is already a pair with name: " + medication.Name + " ,concentration: "
+ medication.Concentration + " and concentrationCode: " + medication.ConcentrationCode);
}
if (ModelState.IsValid)
{
medication.MedicationTypeId = Int32.Parse(MedicationTypeCode);
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit, "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit, "DispensingCode", "DispensingCode", medication.DispensingCode);
return(View(medication));
}
public async Task <IActionResult> Create(string medicationName, [Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
if (_context.Medication.Any(m => m.Name == medication.Name) && _context.Medication.Any(m => m.Concentration == medication.Concentration) && _context.Medication.Any(m => m.ConcentrationCode == medication.ConcentrationCode))
{
ModelState.AddModelError("Name", "Medication already exists");
}
if (ModelState.IsValid)
{
try
{
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View("Error", new ErrorViewModel {
ErrorMessage = " An error occured while saving the new entries.please, fill the empty fields"
}));
}
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(m => m.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(m => m.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
ViewData["medicationName"] = medicationName;
return(View(medication));
}
public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
if (ModelState.IsValid)
{
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var PatientDiagnosisContext = _context.PatientDiagnosis.Where(p => p.PatientDiagnosisId == patientTreatment.PatientDiagnosisId).FirstOrDefault();
//var DiagnosisId = PatientDiagnosisContext.DiagnosisId;
string PatientName = String.Empty;
string DiagnosisName = String.Empty;
if (Request.Cookies["PatientName"] != null)
{
PatientName = Request.Cookies["PatientName"].ToString();
}
if (Request.Cookies["DiagnosisName"] != null)
{
DiagnosisName = Request.Cookies["DiagnosisName"].ToString();
}
ViewData["DiagnosisName"] = DiagnosisName;
ViewData["PatientName"] = PatientName;
ViewData["PatientDiagnosisId"] = new SelectList(_context.PatientDiagnosis, "PatientDiagnosisId", "PatientDiagnosisId", patientTreatment.PatientDiagnosisId);
ViewData["TreatmentId"] = new SelectList(_context.Treatment.Where(p => p.DiagnosisId == patientTreatment.PatientDiagnosisId), "TreatmentId", "Name", patientTreatment.TreatmentId);
return(View());
}
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
try
{
if (ModelState.IsValid)
{
_context.Add(patient);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", patient.ProvinceCode);
return(View(patient));
}
catch (Exception ex)
{
String innerMostException = ex.InnerException.ToString();
ModelState.AddModelError("", innerMostException);
return(View(patient));
}
}
public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
string diagnosisId = string.Empty;
if (Request.Cookies["PatientDiagnosisId"] != null)
{
diagnosisId = Request.Cookies["PatientDiagnosisId"].ToString();
}
else if (HttpContext.Session.GetString("PatientDiagnosisId") != null)
{
diagnosisId = HttpContext.Session.GetString("PatientDiagnosisId").ToString();
}
var patientName = _context.PatientDiagnosis.Include(p => p.Diagnosis).Include(p => p.Patient)
.Where(a => a.PatientDiagnosisId.ToString() == diagnosisId).FirstOrDefault();
ViewData["patientLastName"] = patientName.Patient.LastName;
ViewData["patientFirstName"] = patientName.Patient.FirstName;
ViewData["treatmentFor"] = patientName.Diagnosis.Name;
if (ModelState.IsValid)
{
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PatientDiagnosisId"] = new SelectList(_context.PatientDiagnosis, "PatientDiagnosisId", "PatientDiagnosisId", patientTreatment.PatientDiagnosisId);
ViewData["TreatmentId"] = new SelectList(_context.Treatment.Where(a => a.DiagnosisId.ToString() == diagnosisId), "TreatmentId", "Name", patientTreatment.TreatmentId);
return(View(patientTreatment));
}
// create method used to create new diagnosis category
public async Task<IActionResult> Create([Bind("Id,Name")] DiagnosisCategory diagnosisCategory)
{
if (ModelState.IsValid)
{
_context.Add(diagnosisCategory);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(diagnosisCategory);
}
public async Task<IActionResult> Create([Bind("CountryCode,Name,PostalPattern,PhonePattern,FederalSalesTax")] Country country)
{
if (ModelState.IsValid)
{
_context.Add(country);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(country);
}
//Saves data to databse through model
public async Task<IActionResult> Create([Bind("MedicationTypeId,Name")] MedicationType medicationType)
{
if (ModelState.IsValid)
{
_context.Add(medicationType);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(medicationType);
}
public async Task <IActionResult> Create([Bind("ConcentrationCode")] ConcentrationUnit concentrationUnit)
{
if (ModelState.IsValid)
{
_context.Add(concentrationUnit);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(concentrationUnit));
}
public async Task <IActionResult> Create([Bind("DispensingCode")] DispensingUnit dispensingUnit)
{
if (ModelState.IsValid)
{
_context.Add(dispensingUnit);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(dispensingUnit));
}
public async Task <IActionResult> Create([Bind("DiagnosisId,Name,DiagnosisCategoryId")] Diagnosis diagnosis)
{
if (ModelState.IsValid)
{
_context.Add(diagnosis);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DiagnosisCategoryId"] = new SelectList(_context.DiagnosisCategory, "Id", "Name", diagnosis.DiagnosisCategoryId);
return(View(diagnosis));
}
public async Task <IActionResult> Create([Bind("PatientDiagnosisId,PatientId,DiagnosisId,Comments")] PatientDiagnosis patientDiagnosis)
{
if (ModelState.IsValid)
{
_context.Add(patientDiagnosis);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DiagnosisId"] = new SelectList(_context.Diagnosis, "DiagnosisId", "Name", patientDiagnosis.DiagnosisId);
ViewData["PatientId"] = new SelectList(_context.Patient, "PatientId", "FirstName", patientDiagnosis.PatientId);
return(View(patientDiagnosis));
}
public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
if (ModelState.IsValid)
{
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PatientDiagnosisId"] = new SelectList(_context.PatientDiagnosis, "PatientDiagnosisId", "PatientDiagnosisId", patientTreatment.PatientDiagnosisId);
ViewData["TreatmentId"] = new SelectList(_context.Treatment.Where(x => x.DiagnosisId == Convert.ToInt32(HttpContext.Session.GetString("sessionDid"))), "TreatmentId", "Name", patientTreatment.TreatmentId);
return(View(patientTreatment));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
//duplicate check
var existingMed = _context.Medication.Where(m => m.Name == medication.Name &&
m.ConcentrationCode == medication.ConcentrationCode &&
m.Concentration == medication.Concentration);
if (existingMed.Any())
{
ModelState.AddModelError("", string.Format("Medication with name as {0}, concentration as {1} and concentration code as {2} already exists.",
medication.Name, medication.Concentration, medication.ConcentrationCode));
}
var existDIN = _context.Medication.Where(m => m.Din == medication.Din);
if (existDIN.Any())
{
ModelState.AddModelError("", string.Format("Medication with Din {0} already exists.", medication.Din));
}
if (ModelState.IsValid)
{
if (Request.Cookies["MedicationTypeId"] != null)
{
medication.MedicationTypeId = Convert.ToInt32(Request.Cookies["MedicationTypeId"].ToString());
}
else if (HttpContext.Session.GetString("MedicationTypeId") != null)
{
medication.MedicationTypeId = Convert.ToInt32(HttpContext.Session.GetString("medicationTypeId"));
}
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
if (Request.Cookies["typeName"] != null)
{
ViewData["typeName"] = Request.Cookies["typeName"].ToString();
}
else if (HttpContext.Session.GetString("typeName") != null)
{
ViewData["typeName"] = HttpContext.Session.GetString("typeName");
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(m => m.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(m => m.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
var PatientDiagnosisId = Request.Cookies["PatientDiagnosisId"];
patientTreatment.PatientDiagnosisId = Convert.ToInt32(PatientDiagnosisId);
if (ModelState.IsValid)
{
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PatientDiagnosisId"] = new SelectList(_context.PatientDiagnosis, "PatientDiagnosisId", "PatientDiagnosisId", patientTreatment.PatientDiagnosisId);
ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "Name", patientTreatment.TreatmentId);
return(View(patientTreatment));
}
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
if (ModelState.IsValid)
{
_context.Add(patient);
await _context.SaveChangesAsync();
TempData["Message"] = "'" + patient.FirstName + ", " + patient.LastName + "' has been added successfully";
return(RedirectToAction(nameof(Index)));
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", patient.ProvinceCode);
TempData["Error"] = "Please try again after correcting all the displayed errors";
TempData["DateOfDeath"] = patient.DateOfDeath.HasValue ? patient.DateOfDeath.Value.ToString("MM/dd/yyyy hh:mm tt") : "";
TempData["DateOfBirth"] = patient.DateOfBirth.HasValue ? patient.DateOfBirth.Value.ToString("MM/dd/yyyy hh:mm tt") : "";
return(View(patient));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
var isNameExists = _context.Medication.Any(a => a.Name == medication.Name);
var isConcentrationExists = _context.Medication.Any(a => a.Concentration == medication.Concentration);
var isConcentrationCodeExists = _context.Medication.Any(a => a.ConcentrationCode == medication.ConcentrationCode);
if (isNameExists)
{
ModelState.AddModelError("", "Name already exists");
}
if (isConcentrationExists)
{
ModelState.AddModelError("", "Concentration already exists");
}
if (isConcentrationCodeExists)
{
ModelState.AddModelError("", "Concentration Code already exists");
}
string medTName = string.Empty;
if (Request.Cookies["MedicationTypeId"] != null)
{
medTName = Request.Cookies["MedicationTypeId"].ToString();
}
else if (HttpContext.Session.GetString("MedicationTypeId") != null)
{
medTName = HttpContext.Session.GetString("MedicationTypeId").ToString();
}
var medName = _context.MedicationType.Where(a => a.MedicationTypeId.ToString() == medTName).FirstOrDefault();
ViewData["MedicationType"] = medName.Name;
if (ModelState.IsValid)
{
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(a => a.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(a => a.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("PatientTreatmentId,TreatmentId,DatePrescribed,Comments,PatientDiagnosisId")] PatientTreatment patientTreatment)
{
//PatientDiagnosisId id rerieved from session
patientTreatment.PatientDiagnosisId = Convert.ToInt32(HttpContext.Session.GetString("patientDiagnosisId"));
if (ModelState.IsValid)
{
_context.Add(patientTreatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
int diagnosisId = Convert.ToInt32(HttpContext.Session.GetString("diagnosisId"));
ViewData["TreatmentId"] = new SelectList(_context.Treatment.Where(a => a.DiagnosisId == diagnosisId), "TreatmentId", "Name", patientTreatment.TreatmentId);
ViewData["Date"] = DateTime.Now;
TempData["PatientTreatmentHeader"] = "Add a Treatment for " + HttpContext.Session.GetString("diagnosisName") + ", Patient: " + HttpContext.Session.GetString("patientName");
return(View(patientTreatment));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")]
Medication medication)
{
if (medication.MedicationTypeId == 0)
{
TempData["message"] =
"Couldn't get the medication type id from the create web page.";
return(RedirectToAction("Index", "YKMedications"));
}
//check there is the same Din on the medication table
Medication existMedication =
_context.Medication.SingleOrDefault(m => m.Din == medication.Din);
if (existMedication != null)
{
TempData["message"] = "The Din already exists in the database.";
return(RedirectToAction("Index", "YKMedications"));
}
if (ModelState.IsValid)
{
//check there is the same name, concentration, and concentration code on the medication table
var existSameContent = _context.Medication.Where(m => m.Name == medication.Name &&
m.Concentration == medication.Concentration &&
m.ConcentrationCode == medication.ConcentrationCode).FirstOrDefault();
if (existSameContent != null)
{
TempData["message"] = "The same record already exists in the database.";
return(RedirectToAction("Index", "YKMedications"));
}
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
//add OrderBy() made by Yunice Kim on Oct 2nd, 2019
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(m => m.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(m => m.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
if (ModelState.IsValid)
{
try
{
_context.Add(patient);
await _context.SaveChangesAsync();
TempData["message"] = "Patient has been added successfully";
return(RedirectToAction(nameof(Index)));
}catch (Exception ex)
{
ModelState.AddModelError("", ex.InnerException.Message);
}
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", patient.ProvinceCode);
return(View(patient));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
//Exception handling for model if user enters duplicate Din
try
{
if (ModelState.IsValid)
{
var existingMedications = await _context.Medication.Include(m => m.ConcentrationCodeNavigation).ToListAsync();
//Validation to see whether user entered unique data for Name, Concentration and ConcentrationCode
foreach (var em in existingMedications)
{
if (em.ConcentrationCode == medication.ConcentrationCode && em.Concentration == medication.Concentration && em.Name == medication.Name)
{
ModelState.AddModelError("", "Please create a unique medication");
ModelState.AddModelError("Name", "There is already a medication with this Name");
ModelState.AddModelError("Concentration", "There is already a medication with this Concentration");
ModelState.AddModelError("ConcentrationCode", "There is already a medication with this Concentration Unit");
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit, "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit, "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType.Where(a => a.MedicationTypeId == Convert.ToInt32(HttpContext.Session.GetString("code"))), "MedicationTypeId", "Name", medication.MedicationTypeId);
TempData["MedicationTypeName"] = "Create Medication for " + HttpContext.Session.GetString("name");
return(View(medication));
}
}
_context.Add(medication);
await _context.SaveChangesAsync();
TempData["UpdateMessage"] = $"Medications updated: {medication.Name}";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception)
{
ModelState.AddModelError("Din", "Din number already exists");
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit, "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit, "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType.Where(a => a.MedicationTypeId == Convert.ToInt32(HttpContext.Session.GetString("code"))), "MedicationTypeId", "Name", medication.MedicationTypeId);
TempData["MedicationTypeName"] = "Create Medication for " + HttpContext.Session.GetString("name");
return(View(medication));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
medication.MedicationTypeId = Convert.ToInt32(HttpContext.Session.GetString("code"));
if (_context.Medication.Any(m => m.Name == medication.Name) && _context.Medication.Any(m => m.Concentration == medication.Concentration) && _context.Medication.Any(m => m.ConcentrationCode == medication.ConcentrationCode))
{
ModelState.AddModelError("Name", "Medication already exists");
}
if (ModelState.IsValid)
{
_context.Add(medication);
await _context.SaveChangesAsync();
TempData["Alert"] = "Created successfully";
return(RedirectToAction(nameof(Index)));
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(x => x.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(x => x.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
//ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}
//[ValidateAntiForgeryToken]
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
try
{
if (ModelState.IsValid)
{
_context.Add(patient);
await _context.SaveChangesAsync();
TempData["message"] = "Create new Patient successfully!";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.GetBaseException().Message);
TempData["message"] = ex.GetBaseException().Message;
}
return(View(patient));
}
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
if (ModelState.IsValid)
{
//patient.PatientId = 1022;
try
{
_context.Add(patient);
await _context.SaveChangesAsync();
TempData["message"] = $"Patient {patient.FirstName + patient.LastName}'s information created succesfully ";
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)//04 LinqRequest ppt p6
{
ModelState.AddModelError("", $"Exception happens when creating a patient files:{ ex.GetBaseException().Message}");
}
}
//ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", patient.ProvinceCode);
return(View(patient));
}
public async Task <IActionResult> Create([Bind("PatientId,FirstName,LastName,Address,City,ProvinceCode,PostalCode,Ohip,DateOfBirth,Deceased,DateOfDeath,HomePhone,Gender")] Patient patient)
{
// if(patient.ProvinceCode)
if (ModelState.IsValid)
{
try
{
_context.Add(patient);
await _context.SaveChangesAsync();
TempData["message"] = $"Patient({patient.LastName}, {patient.FirstName}) record added into database";
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
ModelState.AddModelError("", "Exception Occured: " + e.GetBaseException().Message);
}
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", patient.ProvinceCode);
return(View(patient));
}
public async Task <IActionResult> Create([Bind("Din,Name,Image,MedicationTypeId,DispensingCode,Concentration,ConcentrationCode")] Medication medication)
{
string MedicationTID = string.Empty;
if (Request.Cookies["MedicationTypeId"] != null)
{
MedicationTID = Request.Cookies["MedicationTypeId"].ToString();
}
else if (HttpContext.Session.GetString("MedicationTypeId") != null)
{
MedicationTID = HttpContext.Session.GetString("MedicationTypeId");
}
var MedicationType = _context.MedicationType.Where(m => m.MedicationTypeId.ToString() == MedicationTID).FirstOrDefault();
ViewData["MedicationTypeName"] = MedicationType.Name;
//ViewData["MedicationTypeId"] = MedicationTID;
var isZeroExist = _context.Medication.Where(a => a.Din == medication.Din);
if (isZeroExist.Any())
{
ModelState.AddModelError("", "There is already a same record for this medication. DIN : " + medication.Din);
}
medication.MedicationTypeId = Convert.ToInt32(MedicationTID);
if (ModelState.IsValid)
{
//ModelState.AddModelError("", "There is already a same record for this medication. DIN : " + medication.Din);
_context.Add(medication);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ConcentrationCode"] = new SelectList(_context.ConcentrationUnit.OrderBy(c => c.ConcentrationCode), "ConcentrationCode", "ConcentrationCode", medication.ConcentrationCode);
ViewData["DispensingCode"] = new SelectList(_context.DispensingUnit.OrderBy(d => d.DispensingCode), "DispensingCode", "DispensingCode", medication.DispensingCode);
ViewData["MedicationTypeId"] = new SelectList(_context.MedicationType, "MedicationTypeId", "Name", medication.MedicationTypeId);
return(View(medication));
}