public DataTable SearchItemById(Item item)
{
string commandString = @"SELECT * FROM Items WHERE ID = '" + item.ID + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public DataTable Display()
{
string commandString = @"SELECT * FROM Items";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public DataTable SearchOrderById(Order order)
{
string commandString = @"SELECT o.ID, c.Name AS Customer, i.Name AS Item, Quantity, TotalPrice FROM Orders AS o LEFT JOIN Customers AS c ON c.ID = o.CustomerID LEFT JOIN Items AS i ON i.ID = o.ItemID WHERE CustomerId = '" + order.CustomerId + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public DataTable SearchOrderByName(Order order)
{
string commandString = @"SELECT * FROM Orders WHERE Name = '" + order.CustomerId + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public DataTable CustomerCombo()
{
string commandString = @"SELECT ID, Name FROM Customers";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public DataTable SearchCustomerById(Customer customer)
{
string commandString = @"SELECT * FROM Customers WHERE ID = '" + customer.ID + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable dataTable = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
return(dataTable);
}
public bool IsItemExist(Item item)
{
string commandString = @"SELECT * FROM Items WHERE Name='" + item.Name + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable result = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
if (result.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool IsOrderExist(Order order)
{
string commandString = @"SELECT * FROM Orders WHERE ID='" + order.ID + "'";
SqlConnection sqlConnection = null;
ConnectionClass connectionClass = new ConnectionClass();
sqlConnection = connectionClass.CreateConnection();
sqlConnection.Open();
DataTable result = connectionClass.ExcecuteDataAdapter(commandString);
sqlConnection.Close();
if (result.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}