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