public ActionResult Create(ProcedureViewModel model) { try { model.Medicines = model.MedicineIds.Select(x => new MedicineViewModel { MedicineId = x }); _procedureRepository.Add(_mapper.Map <Procedure>(model)); return(RedirectToAction(nameof(Index))); } catch { return(RedirectToAction(nameof(Index))); } }
private void ProcessProcedure(string proc, IProcedureRepository procedureRepo) { var procedure = new StoredProcedure <SqlParameter>(_schema, proc); using (var command = Connection.CreateCommand()) { var sb = new StringBuilder(Resources.SQL_PARAMETER_QUERY); sb = sb.Replace("@Catalog", _catalog); sb = sb.Replace("@Schema", _schema); sb = sb.Replace("@ProcName", proc); command.CommandText = sb.ToString(); command.CommandType = CommandType.Text; var reader = command.ExecuteReader(); while (reader.Read()) { procedure.AddParameter(CreateParameter(reader)); } reader.Dispose(); } procedureRepo.Add(new ProcedureKey(_schema, proc), procedure); }
public async Task Add(ProcedureDto dto) { var entity = dto.MapToEntity(); await _procedureRepository.Add(entity); }
public IActionResult AddProcedure([FromBody] Procedure model) { model.CreatedAt = DateTime.Now; Procedure_repo.Add(model); return(new OkObjectResult(new { ProcedureID = model.ProcedureId })); }