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