public async Task <JsonResult> AddInfectologico(InfectologicoDTO model)
{
model.UserName = User.Identity.Name;
await _infectoService.AddInfectologicoAsync(model);
return(Json(new { Success = true }));
}
public async Task AddInfectologicoAsync(InfectologicoDTO model)
{
var param_atb = new List <CoberturaAtbDTO>();
var param_cultivo = new List <CultivoDTO>();
var param_sensibilidad = new List <SensibilidadDTO>();
var param_hisopado = new List <HisopadoDTO>();
if (!string.IsNullOrWhiteSpace(model.CoberturaAtbParamJSON))
{
param_atb = JsonConvert.DeserializeObject <List <CoberturaAtbDTO> >(model.CoberturaAtbParamJSON);
}
if (!string.IsNullOrWhiteSpace(model.CultivoParamJSON))
{
param_cultivo = JsonConvert.DeserializeObject <List <CultivoDTO> >(model.CultivoParamJSON);
}
if (!string.IsNullOrWhiteSpace(model.SensibilidadParamJSON))
{
param_sensibilidad = JsonConvert.DeserializeObject <List <SensibilidadDTO> >(model.SensibilidadParamJSON);
}
if (!string.IsNullOrWhiteSpace(model.HisopadoParamJSON))
{
param_hisopado = JsonConvert.DeserializeObject <List <HisopadoDTO> >(model.HisopadoParamJSON);
}
var param_atb_dt = CoberturaAtbToDataTable(param_atb);
var param_cultivo_dt = CultivoToDataTable(param_cultivo);
var param_sensibilidad_dt = SensibilidadToDataTable(param_sensibilidad);
var param_hisopado_dt = HisopadoToDataTable(param_hisopado);
var pAtb = new SqlParameter("@Antibioticos", SqlDbType.Structured)
{
TypeName = "dbo.AntibioticosList",
Value = param_atb_dt
};
var pCultivo = new SqlParameter("@Cultivos", SqlDbType.Structured)
{
TypeName = "dbo.CultivosList",
Value = param_cultivo_dt
};
var pSensibilidad = new SqlParameter("@Sensibilidad", SqlDbType.Structured)
{
TypeName = "dbo.SensibilidadList",
Value = param_sensibilidad_dt
};
var pHisopado = new SqlParameter("@Hisopado", SqlDbType.Structured)
{
TypeName = "dbo.HisopadoList",
Value = param_hisopado_dt
};
List <SqlParameter> parametros = new List <SqlParameter>
{
new SqlParameter("PacienteId", model.PacienteId),
new SqlParameter("EstadoInfectologicoId", model.EstadoInfectologicoId),
pAtb,
pCultivo,
pSensibilidad,
pHisopado,
new SqlParameter("Interconsulta", (model.Interconsulta ?? "")),
new SqlParameter("Eventos", (model.Eventos ?? "")),
new SqlParameter("Planes", (model.Planes ?? "")),
new SqlParameter("UserName", model.UserName)
};
await ExecuteNonQueryAsync("sp_AddInfectologico", _connectionString, CommandType.StoredProcedure, parametros.ToArray());
}
