public async Task <ActionResult <ResponseViewModel> > PostInscViewModel(InscViewModel inscViewModel)
{
// var helper = new InscripcionService(_connectionString, mailService);
var modelo = service.PostInscViewModel(inscViewModel).Result;
if (modelo.UsuarioId < 0)
{
return(BadRequest());
}
await Task.Delay(100).ConfigureAwait(false);
return(modelo);
}
public async Task <InscViewModel> GetListado()
{
//var helper = new InscripcionService(_connectionString, mailService);
var result = service.GetListadosInciales().Result;
var model = new InscViewModel();
var tipoFamilia = result.TipoFamiliaList.Select
(r => new SelectListItem
{
Value = $"{r.TipoFamiliaKey}",
Text = r.TipoFamiliaDesc
})
.OrderBy(o => o.Text)
.ToList();
var departamento = result.DepartamentosList.Select
(r => new SelectListItem
{
Value = $"{r.DepartamentoKey}",
Text = r.DepartamentoDesc
})
.OrderBy(o => o.Text)
.ToList();
var localidad = result.LocalidadList.Select
(r => new SelectListItem
{
Value = $"{r.DepartamentoKey + "-" + r.LocalidadKey}",
Text = r.LocalidadDesc
})
.OrderBy(o => o.Text)
.ToList();
var parentesco = result.ParentescoList.Select(r => new SelectListItem
{
Value = $"{r.ParentescoKey}",
Text = r.ParentescoDesc
}).OrderBy(o => o.Text).ToList();
model.DepartamentosList = departamento;
model.LocalidadesList = localidad;
model.TipoFamiliaList = tipoFamilia;
model.ParentescoList = parentesco;
await Task.Delay(100).ConfigureAwait(false);
return(model);
}
public int InsertTotal(InscViewModel inscViewModel)
{
string queryInsertTitular = "INSERT INTO Inscriptos " +
" (ins_ficha, ins_tipflia, ins_fecins, ins_nombre, ins_tipdoc, ins_numdoc, ins_email, ins_telef, ins_estado, ins_fecalt " +
"VALUES " +
"( @ins_ficha, @ins_tipflia, @ins_fecins, @ins_nombre, @ins_tipdoc, @ins_numdoc, " +
" @ins_email, @ins_telef, @ins_estado, @ins_fecalt )";
var inscId = 0;
Connection();
using (TransactionScope ts = new TransactionScope())
{
using SqlCommand cmd = new SqlCommand(queryInsertTitular, con)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add(new SqlParameter("@ins_ficha", inscViewModel.InsFicha));
cmd.Parameters.Add(new SqlParameter("@ins_tipflia", inscViewModel.InsTipflia));
cmd.Parameters.Add(new SqlParameter("@ins_fecins", inscViewModel.InsFecins));
cmd.Parameters.Add(new SqlParameter("@ins_nombre", inscViewModel.InsNombre.Trim()));
cmd.Parameters.Add(new SqlParameter("@ins_tipdoc", inscViewModel.InsFicha));
cmd.Parameters.Add(new SqlParameter("@ins_numdoc", inscViewModel.InsFicha));
cmd.Parameters.Add(new SqlParameter("@ins_email", inscViewModel.InsEmail));
cmd.Parameters.Add(new SqlParameter("@ins_telef", inscViewModel.InsTelef));
cmd.Parameters.Add(new SqlParameter("@ins_estado", inscViewModel.InsEstado));
cmd.Parameters.Add(new SqlParameter("@ins_fecalt", inscViewModel.InsFecalt));
con.Open();
inscId = (int)cmd.ExecuteScalar(); //ejecuta y devuelve el primer campo del registro, es decir el id
if (inscId > 0)
{
ts.Complete();
}
else
{
ts.Dispose();
}
}
return(inscId);
}
public InscViewModel GetInscripto(int dni)
{
Connection();
string query = "SELECT ins_id, ins_ficha ,ins_tipflia ,ins_fecins, ins_nombre, ins_tipdoc " +
",ins_numdoc ,ins_email ,ins_telef ,ins_estado ,ins_fecalt FROM Inscriptos where ins_numdoc = @dni";
using SqlCommand cmd = new SqlCommand(query, con)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add(new SqlParameter("@dni", dni.ToString()));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
con.Open();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
var pList = new InscViewModel();
var insId = 0;
foreach (DataRow item in dt.Rows)
{
pList.InsId = (int)item["ins_id"];
pList.InsEmail = (string)item["ins_email"];
pList.InsEstado = (string)item["ins_estado"];
pList.InsFecalt = (DateTime)item["ins_fecalt"];
pList.InsFecins = (string)item["ins_fecins"];
pList.InsFicha = (int)item["ins_ficha"];
pList.InsNombre = (string)item["ins_nombre"];
pList.InsNumdoc = (string)item["ins_numdoc"];
pList.InsTelef = (string)item["ins_telef"];
pList.InsTipdoc = (string)item["ins_tipdoc"];
pList.InsTipflia = (string)item["ins_tipflia"];
insId = pList.InsId;
}
if (insId > 0)
{
string query1 = "SELECT insf_id , insf_nombre, insf_tipdoc, insf_numdoc, insf_estado, insf_fecalt, ins_id, P.ParentescoDesc " +
"FROM InsFamilia F INNER JOIN Parentesco P ON P.ParentescoKey = F.Parentescokey WHERE ins_id = @pList.InsId ";
//select * from Parentesco P inner join InsFamilia F on F.ParentescoKey = P.Parentescokey
using SqlCommand cmd1 = new SqlCommand(query1, con)
{
CommandType = CommandType.Text
};
cmd1.Parameters.Add(new SqlParameter("@pList.InsId", pList.InsId));
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
con.Open();
da1.Fill(dt1);
foreach (DataRow item in dt1.Rows)
{
pList.GrupoFamiliar.Add(MapToFamilia(item));
}
con.Close();
return(pList);
}
else
{
return(new InscViewModel());
}
}
else
{
return(new InscViewModel());
}
/*
* return new InscViewModel();
*/
}
public IActionResult IndexPanel()
{
InscViewModel model = TempData["data"] as InscViewModel;
return(View(model));
}
public async Task <ResponseViewModel> PostInscViewModel(InscViewModel model)
{
var result = await helper.PostInscViewModel(model);
return(result);
}
