public void AddCons(Consulta C, int IDCH)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = DESKTOP - 3AQGIM6\\SQLEXPRESS; INITIAL CATALOG = PROYECTOINTEGRADOR; user = sa; password =#m1m2m3m4m5", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_AddCons", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@IdPac", ParameterDirection.Input, eTypes.Entero, IDCH);
dsl.SetParameterProcedure("@Peso", ParameterDirection.Input, eTypes.Entero, C.Peso);
dsl.SetParameterProcedure("@Altura", ParameterDirection.Input, eTypes.Entero, C.Altura);
dsl.SetParameterProcedure("@Presion", ParameterDirection.Input, eTypes.Cadena, C.PresionArt);
dsl.SetParameterProcedure("@Motivo", ParameterDirection.Input, eTypes.Cadena, C.Motivo);
dsl.SetParameterProcedure("@Antecedentes", ParameterDirection.Input, eTypes.Cadena, C.Antecedentes);
dsl.SetParameterProcedure("@Diagnostico", ParameterDirection.Input, eTypes.Cadena, C.Diagnostico);
dsl.SetParameterProcedure("@Receta", ParameterDirection.Input, eTypes.Cadena, C.Receta);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void ModLab(Modelos.Laboratorio L)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = DESKTOP-3AQGIM6\\SQLEXPRESS; INITIAL CATALOG = PROYECTOINTEGRADOR; user=sa; password=#m1m2m3m4m5", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_ModLab", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Id", ParameterDirection.Input, eTypes.Entero, L.IdLab);
dsl.SetParameterProcedure("@Nombre", ParameterDirection.Input, eTypes.Cadena, L.Nombre);
dsl.SetParameterProcedure("@Director", ParameterDirection.Input, eTypes.Cadena, L.Director);
dsl.SetParameterProcedure("@Telefono", ParameterDirection.Input, eTypes.Cadena, L.Telefono);
dsl.SetParameterProcedure("@Calle", ParameterDirection.Input, eTypes.Cadena, L.Calle);
dsl.SetParameterProcedure("@Colonia", ParameterDirection.Input, eTypes.Cadena, L.Colonia);
dsl.SetParameterProcedure("@Municipio", ParameterDirection.Input, eTypes.Cadena, L.Municipio);
dsl.SetParameterProcedure("@Estado", ParameterDirection.Input, eTypes.Cadena, L.Estado);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void DelLab(int IDL)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = DESKTOP-3AQGIM6\\SQLEXPRESS; INITIAL CATALOG = PROYECTOINTEGRADOR; user=sa; password=#m1m2m3m4m5", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_DelLab", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Id", ParameterDirection.Input, eTypes.Entero, IDL);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void DelPac(int IDP)
{
try
{
dsl = new DSL();
dsl.Open(Con, Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_DelPac", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Id", ParameterDirection.Input, eTypes.Entero, IDP);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception();
}
finally
{
dsl = null;
}
}
public void DelCita(int IDC)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = JARVIS; INITIAL CATALOG = PROYECTOINTEGRADOR; INTEGRATED SECURITY = YES", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_DelCita", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Id", ParameterDirection.Input, eTypes.Entero, IDC);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void AddEL(int IDP, int IDL, EstudioLab EL)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = JARVIS; INITIAL CATALOG = PROYECTOINTEGRADOR; INTEGRATED SECURITY = YES", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_AddEL", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Idp", ParameterDirection.Input, eTypes.Entero, IDP);
dsl.SetParameterProcedure("@Idl", ParameterDirection.Input, eTypes.Entero, IDL);
dsl.SetParameterProcedure("@Motivo", ParameterDirection.Input, eTypes.Cadena, EL.Motivo);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void ModPac(Paciente P)
{
try
{
dsl = new DSL();
dsl.Open(Con, Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_ModPac", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Nombre", ParameterDirection.Input, eTypes.Cadena, P.Nombre);
dsl.SetParameterProcedure("@ApePat", ParameterDirection.Input, eTypes.Cadena, P.ApePaterno);
dsl.SetParameterProcedure("@ApeMat", ParameterDirection.Input, eTypes.Cadena, P.ApeMaterno);
dsl.SetParameterProcedure("@Edad", ParameterDirection.Input, eTypes.Cadena, P.Edad);
dsl.SetParameterProcedure("@Sexo", ParameterDirection.Input, eTypes.Cadena, P.Sexo);
dsl.SetParameterProcedure("@FechaNac", ParameterDirection.Input, eTypes.Cadena, P.FechaNacimiento);
dsl.SetParameterProcedure("@EstadoCivil", ParameterDirection.Input, eTypes.Cadena, P.EstadoCivil);
dsl.SetParameterProcedure("@RFC", ParameterDirection.Input, eTypes.Cadena, P.RFC);
dsl.SetParameterProcedure("@CURP", ParameterDirection.Input, eTypes.Cadena, P.CURP);
dsl.SetParameterProcedure("@Email", ParameterDirection.Input, eTypes.Cadena, P.Email);
dsl.SetParameterProcedure("@Ocupacion", ParameterDirection.Input, eTypes.Cadena, P.Ocupacion);
dsl.SetParameterProcedure("@TelefonoMovil", ParameterDirection.Input, eTypes.Cadena, P.TelMovil);
dsl.SetParameterProcedure("@TelefonoCasa", ParameterDirection.Input, eTypes.Cadena, P.TelCasa);
dsl.SetParameterProcedure("@Calle", ParameterDirection.Input, eTypes.Cadena, P.Calle);
dsl.SetParameterProcedure("@Colonia", ParameterDirection.Input, eTypes.Cadena, P.Colonia);
dsl.SetParameterProcedure("@Estado", ParameterDirection.Input, eTypes.Cadena, P.Estado);
dsl.SetParameterProcedure("@Municipio", ParameterDirection.Input, eTypes.Cadena, P.Municipio);
dsl.SetParameterProcedure("@Num", ParameterDirection.Input, eTypes.Cadena, P.NumeroCasa);
dsl.SetParameterProcedure("@IdPe", ParameterDirection.Input, eTypes.Entero, P.IdPersona);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void AddHC(Paciente P, Consulta HC)
{
try
{
dsl = new DSL();
dsl.Open("DATA SOURCE = JARVIS; INITIAL CATALOG = PROYECTOINTEGRADOR; INTEGRATED SECURITY = YES", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_AddHC", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@Id", ParameterDirection.Input, eTypes.Entero, P.IdPaciente);
dsl.SetParameterProcedure("@Peso", ParameterDirection.Input, eTypes.Entero, HC.Peso);
dsl.SetParameterProcedure("@Altura", ParameterDirection.Input, eTypes.Entero, HC.Altura);
dsl.SetParameterProcedure("@Presion", ParameterDirection.Input, eTypes.Entero, HC.PresionArt);
dsl.ExecuteNonQuery();
dsl.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
public void AddServ(List <ItemServLab> LS, int idl)
{
try
{
foreach (ItemServLab SL in LS)
{
dsl = new DSL();
dsl.Open("DATA SOURCE = DESKTOP-DMUTBHE; INITIAL CATALOG = PROYECTOINTEGRADOR; INTEGRATED SECURITY = YES", Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.usp_AddServs", CommandType.StoredProcedure);
dsl.SetParameterProcedure("@IdLab", ParameterDirection.Input, eTypes.Entero, idl);
dsl.SetParameterProcedure("@Serv", ParameterDirection.Input, eTypes.Cadena, SL.Servicio);
dsl.ExecuteNonQuery();
dsl.Close();
}
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dsl = null;
}
}
