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