public static int Delete(string _name)
{
string statment = string.Format($"update Category set deleted ='{0}' where Name ='{_name}'");
return(DBManager.ExecuteNonQuery(statment));
}
public static int Insert(string _name)
{
var statment = string.Format("insert into Category(categoryID) values('{0}')", _name);
return(DBManager.ExecuteNonQuery(statment));
}
public static int Modify(string _name, int _oldName)
{
string statment = string.Format("update Category set Name ='{0}' where Name ='{1}'", _name, _oldName);
return(DBManager.ExecuteNonQuery(statment));
}
public static void updateOrderStatus(int id, string str)
{
string quary = string.Format($"update Ordr set orderStatus='{str}' where orderID='{id}'");
DBManager.ExecuteNonQuery(quary);
}
