public async Task AddHMNAsync(HmnDTO model)
{
var gral = new List <HMNListasDTO>();
var balance = new List <HMNListasDTO>();
var lab = new List <HMNListasDTO>();
if (!string.IsNullOrWhiteSpace(model.GeneralJSON))
{
gral = JsonConvert.DeserializeObject <List <HMNListasDTO> >(model.GeneralJSON);
}
var gral_dt = ListToDataTable(gral);
var pGral = new SqlParameter("@General", SqlDbType.Structured)
{
TypeName = "dbo.HMNList",
Value = gral_dt
};
if (!string.IsNullOrWhiteSpace(model.BalanceHidricoJSON))
{
balance = JsonConvert.DeserializeObject <List <HMNListasDTO> >(model.BalanceHidricoJSON);
}
var balance_dt = ListToDataTable(balance);
var pBalance = new SqlParameter("@BalanceHidrico", SqlDbType.Structured)
{
TypeName = "dbo.HMNList",
Value = balance_dt
};
if (!string.IsNullOrWhiteSpace(model.LaboratorioJSON))
{
lab = JsonConvert.DeserializeObject <List <HMNListasDTO> >(model.LaboratorioJSON);
}
var lab_dt = ListToDataTable(lab);
var pLab = new SqlParameter("@Laboratorio", SqlDbType.Structured)
{
TypeName = "dbo.HMNList",
Value = lab_dt
};
List <SqlParameter> parametros = new List <SqlParameter>
{
new SqlParameter("PacienteId", model.PacienteId),
new SqlParameter("DialisisPeritoneal", model.DialisisPeritoneal),
new SqlParameter("FormulacionDialisisPeritoneal", (model.FormulacionDialisisPeritoneal ?? "")),
pGral,
pBalance,
pLab,
new SqlParameter("Eventos", (model.Eventos ?? "")),
new SqlParameter("Planes", (model.Planes ?? "")),
new SqlParameter("UserName", model.UserName)
};
await ExecuteNonQueryAsync("sp_AddHMN", _connectionString, CommandType.StoredProcedure, parametros.ToArray());
}
public async Task <JsonResult> AddHMN(HmnDTO model)
{
model.UserName = User.Identity.Name;
await _hmnService.AddHMNAsync(model);
return(Json(new { Success = true }));
}
