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