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 }));
}
