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