public async Task <IActionResult> Create(MedicineTypeandMedicineSubtypeViewModel model) { if (ModelState.IsValid) { var doesMedicineSubtypeExists = _db.MedicineSubtype.Include(s => s.MedicineType).Where(s => s.Name == model.MedicineSubtype.Name && s.MedicineType.Id == model.MedicineSubtype.MedicineTypeId); if (doesMedicineSubtypeExists.Count() > 0) { //Error StatusMessage = "Error : Sub Type exists under " + doesMedicineSubtypeExists.First().MedicineType.Name + " Type. Please use another name."; } else { _db.MedicineSubtype.Add(model.MedicineSubtype); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } MedicineTypeandMedicineSubtypeViewModel modelVM = new MedicineTypeandMedicineSubtypeViewModel() { MedicineTypeList = await _db.MedicineType.ToListAsync(), MedicineSubtype = model.MedicineSubtype, MedicineSubtypeList = await _db.MedicineSubtype.OrderBy(p => p.Name).Select(p => p.Name).ToListAsync(), StatusMessage = StatusMessage }; return(View(modelVM)); }
//GET - CREATE public async Task <IActionResult> Create() { MedicineTypeandMedicineSubtypeViewModel model = new MedicineTypeandMedicineSubtypeViewModel() { MedicineTypeList = await _db.MedicineType.ToListAsync(), MedicineSubtype = new Models.MedicineSubtype(), MedicineSubtypeList = await _db.MedicineSubtype.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync() }; return(View(model)); }
// GetMedicineSubtype //GET - EDIT public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var MedicineSubtype = await _db.MedicineSubtype.SingleOrDefaultAsync(m => m.Id == id); if (MedicineSubtype == null) { return(NotFound()); } MedicineTypeandMedicineSubtypeViewModel model = new MedicineTypeandMedicineSubtypeViewModel() { MedicineTypeList = await _db.MedicineType.ToListAsync(), MedicineSubtype = MedicineSubtype, MedicineSubtypeList = await _db.MedicineSubtype.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync() }; return(View(model)); }