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 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(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 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);
}
}
public List <Account> SearchAccounts(string text)
{
string query = "SELECT * from AccountTable WHERE AccountId LIKE '%" + text + "%' OR Name LIKE '%" + text + "%'";
List <Account> aList = new List <Account>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Account a = new Account();
a.AccountId = sdr["AccountId"].ToString();
a.Name = sdr["Name"].ToString();
a.AccountType = sdr["AccountType"].ToString();
aList.Add(a);
}
return(aList);
}
public Food GetFoods(string foodname)
{
string query = "SELECT * from FoodTable WHERE FoodName='" + foodname + "'";
Food a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new Food();
a.FoodId = sdr["FoodId"].ToString();
a.FoodName = sdr["FoodName"].ToString();
a.FoodPrice = float.Parse((sdr["FoodPrice"].ToString()));
}
dcc.CloseConnection();
return(a);
}
public FoodOrder GetPay(int OrderId)
{
string query = "SELECT * from OrderTable WHERE OrderId='" + OrderId + "'";
FoodOrder a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new FoodOrder();
a.OrderId = int.Parse((sdr["OrderId"].ToString()));
a.AccountId = sdr["AccountId"].ToString();
a.TotalPrice = float.Parse((sdr["TotalPrice"].ToString()));
}
dcc.CloseConnection();
return(a);
}
public List <string> GetAccontid()
{
string query = "SELECT * from AccountTable";
List <string> aList = new List <string>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Account a = new Account();
a.AccountId = sdr["AccountId"].ToString();
a.Password = sdr["Password"].ToString();
a.Name = sdr["Name"].ToString();
a.AccountType = sdr["AccountType"].ToString();
aList.Add(a.AccountId);
}
return(aList);
}
public string UserLoginVerification(Account a)
{
string query = "SELECT * from AccountTable WHERE AccountId= '" + a.AccountId + "' AND Password= '******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
//a.Name = sdr["AccountName"].ToString();
a.AccountType = sdr["AccountType"].ToString();
dcc.CloseConnection();
return(a.AccountType);
}
else
{
dcc.CloseConnection();
return("false");
}
}
public Account GetAccountType(string AccountId)
{
string query = "SELECT * from AccountTable WHERE AccountId= '" + AccountId + "'";
Account a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new Account();
a.AccountId = sdr["AccountId"].ToString();
a.Password = sdr["Password"].ToString();
a.Name = sdr["Name"].ToString();
a.AccountType = sdr["AccountType"].ToString();
}
dcc.CloseConnection();
return(a);
}
public List <Food> GetAllFoods()
{
string query = "SELECT * from FoodTable";
List <Food> aList = new List <Food>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Food a = new Food();
a.FoodId = sdr["FoodId"].ToString();
a.FoodName = sdr["FoodName"].ToString();
a.FoodPrice = float.Parse((sdr["FoodPrice"].ToString()));
aList.Add(a);
}
return(aList);
}
public List <FoodOrder> GetStatusOrder(string status)
{
string query = "SELECT * from OrderTable WHERE Status='" + status + "'";
List <FoodOrder> aList = new List <FoodOrder>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
FoodOrder a = new FoodOrder();
a.AccountId = sdr["AccountId"].ToString();
a.TotalPrice = float.Parse((sdr["TotalPrice"].ToString()));
a.OrderId = int.Parse((sdr["OrderId"].ToString()));
a.Status = sdr["Status"].ToString();
aList.Add(a);
}
return(aList);
}
