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