public void ModificarCuenta(Tbl_Administrador ad) { try { string constr = ConfigurationManager.ConnectionStrings["AllBloodContext"].ConnectionString; AllBloodContext db = new AllBloodContext(); string sqlComand = @"st_ModificarAdministrador"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sqlComand, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id_Admin", ad.Id_Admin); cmd.Parameters.AddWithValue("@Nombres", ad.Nombres); cmd.Parameters.AddWithValue("@APaterno", ad.APaterno); cmd.Parameters.AddWithValue("@AMaterno", ad.AMaterno); cmd.Parameters.AddWithValue("@Telefono", ad.Telefono); cmd.Parameters.AddWithValue("@Id_Login", ad.Id_Login); cmd.Parameters.AddWithValue("@Id_Direccion", ad.Id_Direccion); cmd.Parameters.AddWithValue("@Id_Genero", ad.Id_Genero); cmd.Parameters.AddWithValue("@Id_EstadoCivil", ad.Id_EstadoCivil); cmd.Parameters.AddWithValue("@Usuario", ad.Usuario); cmd.Parameters.AddWithValue("@Contrasenia", ad.Contrasenia); cmd.Parameters.AddWithValue("@Calle", ad.Calle); cmd.Parameters.AddWithValue("@NumExterior", ad.NumExterior); cmd.Parameters.AddWithValue("@NumInterior", ad.NumInterior); cmd.Parameters.AddWithValue("@Id_CodigoPostal", ad.Id_CodigoPostal); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { return; } }
public void ModificarPaciente(Tbl_Persona per) { try { string constr = ConfigurationManager.ConnectionStrings["AllBloodContext"].ConnectionString; AllBloodContext db = new AllBloodContext(); string sqlComand = @"st_ModificarPaciente"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sqlComand, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", per.id); cmd.Parameters.AddWithValue("@nombre", per.nombre); cmd.Parameters.AddWithValue("@aPaterno ", per.aPaterno); cmd.Parameters.AddWithValue("@aMaterno ", per.aMaterno); cmd.Parameters.AddWithValue("@edad", per.edad); cmd.Parameters.AddWithValue("@curp", per.curp); cmd.Parameters.AddWithValue("@telefono", per.telefono); cmd.Parameters.AddWithValue("@idTipoSangre", per.idTipoSangre); cmd.Parameters.AddWithValue("@idDireccion", per.idDireccion); cmd.Parameters.AddWithValue("@idGenero", per.idGenero); cmd.Parameters.AddWithValue("@idEstadoCivil", per.idEstadoCivil); cmd.Parameters.AddWithValue("@calle", per.Calle); cmd.Parameters.AddWithValue("@NumExterior", per.NumExterior); cmd.Parameters.AddWithValue("@NumInterior", per.NumInterior); cmd.Parameters.AddWithValue("@Id_CodigoPostal", per.Id_CodigoPostal); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { return; } }
public void ModificarCita(Tbl_Cita ci) { try { string constr = ConfigurationManager.ConnectionStrings["AllBloodContext"].ConnectionString; AllBloodContext db = new AllBloodContext(); string sqlComand = @"st_ModificarCita"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sqlComand, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id_Cita", ci.Id_Cita); cmd.Parameters.AddWithValue("@Id_Donante", ci.Id_Donante); cmd.Parameters.AddWithValue("@Id_Solicitante", ci.Id_Solicitante); cmd.Parameters.AddWithValue("@Fecha", ci.Fecha); cmd.Parameters.AddWithValue("@Hora", ci.Hora); cmd.Parameters.AddWithValue("@Id_Direccion", ci.Id_Direccion); cmd.Parameters.AddWithValue("@Id_Estatus", ci.Id_Estatus); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { return; } }
public List <DonanteParaModificar_ViewDataModelDonante> ConsultarDonantesParaModificar() { try { using (AllBloodContext db = new AllBloodContext()) { var donantes = db.Database.SqlQuery <DonanteParaModificar_ViewDataModelDonante>("st_ConsultarDonantesParaModificar").ToList(); return(donantes); } } catch (Exception ex) { return(null); } }
public List <Pacientes_ViewDataModelDonante> ConsultarPacientes() { try { using (AllBloodContext db = new AllBloodContext()) { var pacientes = db.Database.SqlQuery <Pacientes_ViewDataModelDonante>("st_ConsultarPacientes").ToList(); return(pacientes); } } catch (Exception ex) { return(null); } }
public List <CitasTotales_ViewDataModelDonante> ConsultarCitas() { try { using (AllBloodContext db = new AllBloodContext()) { var citas = db.Database.SqlQuery <CitasTotales_ViewDataModelDonante>("st_ConsultarCitas").ToList(); return(citas); } } catch (Exception ex) { return(null); } }
public List <Administradores_ViewDataModelDonante> ConsultarAdministradores() { try { using (AllBloodContext db = new AllBloodContext()) { var admin = db.Database.SqlQuery <Administradores_ViewDataModelDonante>("st_ConsultarAdministradores").ToList(); return(admin); } } catch (Exception ex) { return(null); } }
public List <Ctl_Clinica> ConsultarClinica() { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Clinica> clinica = db.Database.SqlQuery <Ctl_Clinica>("st_ConsultarClinica").ToList(); return(clinica); } } catch (Exception ex) { return(null); } }
public List <PacientesTotales_ViewDataModelDonante> ConsultarPorCurp(Tbl_Persona per) { try { using (AllBloodContext db = new AllBloodContext()) { var pacientes = db.Database.SqlQuery <PacientesTotales_ViewDataModelDonante>("st_ConsultarPacientesPorCurp @curp", new SqlParameter("@curp", per.curp)).ToList(); return(pacientes); } } catch (Exception ex) { return(null); } }
public List <Ctl_Genero> CargarGenero() { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Genero> genero = db.Database.SqlQuery <Ctl_Genero>("st_ConsultarGenero").ToList(); return(genero); } } catch (Exception ex) { return(null); } }
public List <Tbl_Persona> ConsultarDonante() { try { using (AllBloodContext db = new AllBloodContext()) { List <Tbl_Persona> donante = db.Database.SqlQuery <Tbl_Persona>("st_ConsultarDonantePorPerfil").ToList(); return(donante); } } catch (Exception ex) { return(null); } }
public string ObtenerEncriptacion(string Usuario) { try { using (AllBloodContext db = new AllBloodContext()) { var obPass = db.Database.SqlQuery <string>("st_ObtenerEncriptacion @Usuario", new SqlParameter("@Usuario", Usuario)).FirstOrDefault(); return(obPass); } } catch (Exception ex) { return(null); } }
public List <Ctl_TipoSangre> CargarTipoSangre() { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_TipoSangre> tipSangre = db.Database.SqlQuery <Ctl_TipoSangre>("st_ConsultarTipoSangre").ToList(); return(tipSangre); } } catch (Exception ex) { return(null); } }
public int ObtenerPerfil(string Usuario) { try { using (AllBloodContext db = new AllBloodContext()) { int IdPerfil = db.Database.SqlQuery <int>("st_ObtenerPerfil @Usuario", new SqlParameter("@Usuario", Usuario)).SingleOrDefault(); return(IdPerfil); } } catch (Exception ex) { return(0); } }
public List <Ctl_Perfil> CargarPerfil() { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Perfil> perfil = db.Database.SqlQuery <Ctl_Perfil>("st_ConsultarPerfil").ToList(); return(perfil); } } catch (Exception ex) { return(null); } }
//Aqui se realiza el stored procedure para el logueo public bool LogearUsuario(string Usuario) { try { using (AllBloodContext db = new AllBloodContext()) { int IdPerfil = db.Database.SqlQuery <int>("st_logueoPorPerfil @Usuario", new SqlParameter("@Usuario", Usuario)).SingleOrDefault(); return(true); } } catch (Exception ex) { return(false); } }
public List <Ctl_Estados> CargarEstados() { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Estados> estados = db.Database.SqlQuery <Ctl_Estados>("st_ConsultarEstados").ToList(); return(estados); } } catch (Exception ex) { return(null); } }
public int ConsultarIdEstadoCivil(string lblEstadoCivil) { try { using (AllBloodContext db = new AllBloodContext()) { int estadoCivil = db.Database.SqlQuery <int>("st_ConsultarIdEstadoCivil @Estado_Civil", new SqlParameter("@Estado_Civil", lblEstadoCivil)).FirstOrDefault(); return(estadoCivil); } } catch (Exception ex) { return(0); } }
public string ConsultarsiExistelaPersona(string curp) { try { using (AllBloodContext db = new AllBloodContext()) { string persona = db.Database.SqlQuery <string>("st_ConsultarsiExistelaPersona @curp", new SqlParameter("@curp", curp)).FirstOrDefault(); return(persona); } } catch (Exception ex) { return(null); } }
public string ObtenerNombre(int id) { try { using (AllBloodContext db = new AllBloodContext()) { string donante = db.Database.SqlQuery <string>("st_ConsultarPacienteParaObtenerNombre @id", new SqlParameter("@id", id)).FirstOrDefault(); return(donante); } } catch (Exception ex) { return(null); } }
public List <Ctl_CodigoPostal> CargarCP(int Id_Colonia) { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_CodigoPostal> cp = db.Database.SqlQuery <Ctl_CodigoPostal>("st_ConsultarCodigosPostal @Id_Colonia", new SqlParameter("@Id_Colonia", Id_Colonia)).ToList(); return(cp); } } catch (Exception ex) { return(null); } }
public List <Ctl_Colonia> CargarColonias(int idMunicipio) { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Colonia> colonias = db.Database.SqlQuery <Ctl_Colonia>("st_ConsultarColonia @Id_Municipio", new SqlParameter("@Id_Municipio", idMunicipio)).ToList(); return(colonias); } } catch (Exception ex) { return(null); } }
public List <Ctl_Municipio> CargarMunicipios(int idEstado) { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_Municipio> municipios = db.Database.SqlQuery <Ctl_Municipio>("st_ConsultarMunicipios @Id_Estado", new SqlParameter("@Id_Estado", idEstado)).ToList(); return(municipios); } } catch (Exception ex) { return(null); } }
public List <Ctl_DireccionClinica> ConsultarDireccionClinica(int Id_Clinica) { try { using (AllBloodContext db = new AllBloodContext()) { List <Ctl_DireccionClinica> direClinica = db.Database.SqlQuery <Ctl_DireccionClinica>("st_ConsultarDireccionClinica @Id_Clinica", new SqlParameter("@Id_Clinica", Id_Clinica)).ToList(); return(direClinica); } } catch (Exception ex) { return(null); } }
public void EliminarCita(Tbl_Cita ci) { try { string constr = ConfigurationManager.ConnectionStrings["AllBloodContext"].ConnectionString; AllBloodContext db = new AllBloodContext(); string sqlComand = @"st_EliminarCita"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sqlComand, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id_Cita", ci.Id_Cita); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception) { return; } }
public void RegistrarDonante(Tbl_Persona pers) { try { string constr = ConfigurationManager.ConnectionStrings["AllBloodContext"].ConnectionString; AllBloodContext db = new AllBloodContext(); string sqlComand = @"st_RegistrarDonante"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sqlComand, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Nombre", pers.nombre); cmd.Parameters.AddWithValue("@APaterno", pers.aPaterno); cmd.Parameters.AddWithValue("@AMaterno", pers.aMaterno); cmd.Parameters.AddWithValue("@edad", pers.edad); cmd.Parameters.AddWithValue("@curp", pers.curp); cmd.Parameters.AddWithValue("@telefono", pers.telefono); cmd.Parameters.AddWithValue("@idTiposangre ", pers.idTipoSangre); cmd.Parameters.AddWithValue("@calle", pers.Calle); cmd.Parameters.AddWithValue("@NumExterior", pers.NumExterior); cmd.Parameters.AddWithValue("@NumInterior", pers.NumInterior); cmd.Parameters.AddWithValue("@idGenero", pers.idGenero); cmd.Parameters.AddWithValue("@idEstadoCivil", pers.idEstadoCivil); cmd.Parameters.AddWithValue("@idTipoPaciente", pers.idTipoPaciente); cmd.Parameters.AddWithValue("@idCita", pers.idCita); cmd.Parameters.AddWithValue("@Id_CodigoPostal", pers.Id_CodigoPostal); cmd.Parameters.AddWithValue("@ImpDefinitivos", pers.ImpDefinitivos); cmd.Parameters.AddWithValue("@Imp12Meses", pers.Imp12Meses); cmd.Parameters.AddWithValue("@ImpMujeres", pers.ImpMujeres); cmd.Parameters.AddWithValue("@Imp72Horas", pers.Imp72Horas); cmd.Parameters.AddWithValue("@Id_Estatus", pers.Id_Estatus); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { return; } }