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); } }