public static bool GetAuth(string Name, string NameP)
{
var command = new SqlCommand("uspAuth", DbsConnections.SqlBCApp)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(DbsSqlParams.Direct("@Name", SqlDbType.VarChar, Name));
command.Parameters.Add(DbsSqlParams.Direct("@NameP", SqlDbType.VarChar, NameP));
return(DbsSqlOperations.GetInt(command) == 1);
}
public List <Exam.Entities.Product> Retrive()
{
var command = new SqlCommand("uspProducts", DbsConnections.SqlBCApp)
{
CommandType = CommandType.StoredProcedure
};
var result = DbsSqlOperations.GetDataSet(command).Tables[0].AsEnumerable()
.Select(dataRow => new Exam.Entities.Product
{
IdProduct = dataRow.Field <int>("IdProduct"),
Product1 = dataRow.Field <string>("Product"),
Cost = dataRow.Field <double>("Cost"),
Inventary = dataRow.Field <int>("Inventary")
}).ToList();
return(result);
}