public int AddLab(Modelos.Laboratorio L)
{
try
{
dsl = new DSL();
int IDL;
dsl.Open("DATA SOURCE = DESKTOP-3AQGIM6\\SQLEXPRESS; INITIAL CATALOG = PROYECTOINTEGRADOR; user=sa; password=#m1m2m3m4m5", 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;
}
}
public int CheckUser(Usuario U)
{
// DSL dsl = new DSL();
int IDT = 0;
//Usuario Us = new Usuario();
dsl = new DSL();
DataTable Dt = new DataTable();
try
{
dsl.Open(Con, Proveedor.SQLServer);
dsl.InitialSQLStatement("dbo.CheckUser", CommandType.StoredProcedure);
dsl.SetParameterProcedure("Id", ParameterDirection.Output, eTypes.Entero, null);
dsl.SetParameterProcedure("NombreU", ParameterDirection.Input, eTypes.Cadena, U.NombreUsuario);
dsl.SetParameterProcedure("Password", ParameterDirection.Input, eTypes.Cadena, U.CodigoAcceso);
IDT = int.Parse(dsl.ExecuteStoredOutPut().ToString());
dsl.Close();
return(IDT);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
dsl = null;
}
}
