public IEnumerable <TInStock> GetStock()
{
DataLinqToSQLDataContext conn = new DataLinqToSQLDataContext();
string sql = "SELECT StockID, BarcodeID, LocationID, Quantity FROM TInStock";
return(conn.ExecuteQuery <TInStock>(sql));
}
public static IEnumerable <TProductGroup> AllProducts()
{
DataLinqToSQLDataContext connect = new DataLinqToSQLDataContext();
var query = connect.ExecuteQuery <TProductGroup>("SELECT * FROM TProductGroup");
return(query);
}
public static IEnumerable <TProductGroup> GetProductGroup(string column, string parameter, string value)
{
DataLinqToSQLDataContext connect = new DataLinqToSQLDataContext();
string sqlStatement = "SELECT * FROM TProductGroup WHERE TProductGroup." + column + " " + parameter + " " + "'" + value + "'";
var query = connect.ExecuteQuery <TProductGroup>(sqlStatement);
return(query);
}
public object PopulateComboBarcode(string param)
{
DataLinqToSQLDataContext products = new DataLinqToSQLDataContext();
string query = "SELECT Barcode, " + param + " FROM TProductGroup";
var result = products.ExecuteQuery <TProductGroup>(query);
return(result.ToList());
}
public static IEnumerable <T> GetResultSetWithWhereClauses <T>(string table, string column, string parameter, string value, List <string[]> list)
{
DataLinqToSQLDataContext connect = new DataLinqToSQLDataContext();
StringBuilder sb = new StringBuilder();
foreach (string[] clause in list)
{
string whereClause = clause[0] + " " + table + "." + clause[1] + " " + clause[2] + "'" + clause[3] + "' ";
sb.Append(whereClause);
}
string sqlStatement = "SELECT * FROM dbo." + table + " WHERE " + table + "." + column + " " + parameter + " " + "'" + value + "' " + sb.ToString();
var query = connect.ExecuteQuery <T>(sqlStatement);
return(query.ToList());
}
