public static DataSet GetAll()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FDetalleVenta_GetAll", dbParams));
}
public static System.Data.DataSet GetAll()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FCategoria_GetAll", dbParams));
}
public static DataSet AutoLoginGet()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FUsuario_Logged", dbParams));
}
public static DataSet GetNumeroDocumento()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FVenta_GetNumeroDocumento", dbParams));
}
public static DataSet GetAll(string sProdServ)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@ProdServ", SqlDbType.VarChar, 0, sProdServ),
};
return(FDBHelper.ExecuteDataSet("usp_Data_FProducto_GetAll", dbParams));
}
public static DataSet GetAll(int ventaId)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@VentaId", SqlDbType.Int, 0, ventaId),
};
return(FDBHelper.ExecuteDataSet("usp_Data_FDetalleVenta_GetAll", dbParams));
}
public static DataSet ValidarLogin(string sUsuario, string sPassword)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Usuario", SqlDbType.VarChar, 0, sUsuario),
FDBHelper.MakeParam("@Password", SqlDbType.VarChar, 0, sPassword)
};
return(FDBHelper.ExecuteDataSet("usp_Data_FLogin_ValidarLogin", dbParams));
}
//Este es el metodo para hacer el LOG
public static void Log(string usuario, string accion)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@usuario", SqlDbType.VarChar, 0, usuario),
FDBHelper.MakeParam("@fechaHora", SqlDbType.DateTime, 0, DateTime.Now),
FDBHelper.MakeParam("@accion", SqlDbType.VarChar, 0, accion)
};
FDBHelper.ExecuteDataSet("usp_Data_FLogin_LogLogin", dbParams);
}
public static DataSet GetAllDeletedNotes(int UserID)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@UserID", SqlDbType.Int, 0, UserID)
};
// This will return the deleted notes (with all data they have).
return(FDBHelper.ExecuteDataSet("usp_Data_GetAllDeletedNotes", dbParams));
}
public static DataSet LoadDeletedNotesByPage(int UserID, int pageNumber)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@UserID", SqlDbType.Int, 0, UserID),
FDBHelper.MakeParam("@ActualPage", SqlDbType.Int, 0, pageNumber)
};
return(FDBHelper.ExecuteDataSet("usp_Data_LoadDeletedNotesByPage", dbParams));
}