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 int AddLab(Modelos.Laboratorio L) { try { dsl = new DSL(); int IDL; dsl.Open("DATA SOURCE = JARVIS; INITIAL CATALOG = PROYECTOINTEGRADOR; INTEGRATED SECURITY = YES", Proveedor.SQLServer); dsl.InitialSQLStatement("dbo.usp_AddLab", CommandType.StoredProcedure); 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.SetParameterProcedure("@Id", ParameterDirection.Output, eTypes.Entero, null); IDL = int.Parse(dsl.ExecuteStoredOutPut().ToString()); dsl.Close(); return(IDL); } catch (Exception e) { throw new Exception(e.Message, e); } finally { dsl = null; } }