public bool Update(Account a)
{
try
{
string query = "UPDATE AccountTable SET Name = '" + a.Name + "', Password = '******' , AccountType = '" + a.AccountType + "' WHERE AccountId= '" + a.AccountId + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Delete(string accountId)
{
try
{
string query = "DELETE from AccountTable WHERE AccountId = '" + accountId + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Insert(Account a)
{
try
{
string query = "INSERT into AccountTable VALUES ('" + a.AccountId + "', '" + a.Password + "','" + a.Name + "', '" + a.AccountType + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(Food a)
{
try
{
string query = "UPDATE FoodTable SET FoodName = '" + a.FoodName + "', FoodPrice = '" + a.FoodPrice + "' WHERE FoodId= '" + a.FoodId + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Insert(Food a)
{
try
{
string query = "INSERT into FoodTable VALUES ('" + a.FoodId + "', '" + a.FoodName + "', '" + a.FoodPrice + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(string a, int num)
{
try
{
string query = "UPDATE OrderTable SET Status = '" + a + "' WHERE OrderId=" + num + "";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Insert(FoodOrder a)
{
try
{
string query = "INSERT into OrderTable VALUES ('" + a.OrderId + "', '" + a.TotalPrice + "','" + a.AccountId + "','" + a.Status + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
