public static DataTable GetAll() { string statement = "select Name from Category where deleted=0"; var dt = DBManager.ExecuteQuery(statement); return(dt); }
public static int GetIDUsingName(string name) { string quary = string.Format($"select * from Category where categoryName like'%{name}%'"); DataTable dt = new DataTable(); dt = DBManager.ExecuteQuery(quary); return(int.Parse(dt.Rows[0][0].ToString())); }
public static DataTable GetAll() { string query = "select * from Product where deleted=0"; #pragma warning disable CS0436 // Type conflicts with imported type return(DBManager.ExecuteQuery(query)); #pragma warning restore CS0436 // Type conflicts with imported type }
public static DataTable GetByName(string _prodName) { string query = $"select * from Product " + $" where productName like '{_prodName}' and deleted=0"; #pragma warning disable CS0436 // Type conflicts with imported type return(DBManager.ExecuteQuery(query)); #pragma warning restore CS0436 // Type conflicts with imported type }
public static DataTable GetOrders(string _email) { string query = $"select p.productName,p.Price,p.Quantity,o.orderID,o.Date,o.totalPrice from" + "Orders o inner join orderItem oi" + "on o.orderID=oi.orderID" + "inner join Product p" + "on p.productID=oi.productID"; return(DBManager.ExecuteQuery(query)); }
public static DataTable GetALLByUser(string _email) { //get user id By email string query = "select *,userFname+userLname as User Name from " + "order o,users us where us.userID=o.userID "; #pragma warning disable CS0436 // Type conflicts with imported type return(DBManager.ExecuteQuery(query)); #pragma warning restore CS0436 // Type conflicts with imported type }
public static string checkOne(string _email, string _password) { string status; string query = string.Format("select Status from Users where Email='{0}' and Password='******'", _email, _password); var dt = DBManager.ExecuteQuery(query); if (dt.Rows.Count > 0) { status = dt.Rows[0]["Status"].ToString(); } else { status = "Wrong"; } return(status); }
public static DataTable GetRecent(string _name) { string query = string.Format($"select top 3 * from Product, Category where Product.deleted=0 and Category.categoryID=Product.categoryID and Name='{_name}' order by productID desc"); return(DBManager.ExecuteQuery(query)); }
public static DataTable GetAllCurrent() { string query = "select userID,userFname+' '+userLname FullName,Email,Gender,Age,Status from Users where status='unblocked'"; return(DBManager.ExecuteQuery(query)); }
public static DataTable getPasswordById(int _id) { String query = $"select Password from users where userID={_id}"; return(DBManager.ExecuteQuery(query)); }
public static DataTable GetUserByEmail(string _email) { string query = $"select * from users where Email = '{_email}'"; return(DBManager.ExecuteQuery(query)); }
public static string GetStatus(string _email) { string query = $"select Status from Orders"; return(DBManager.ExecuteQuery(query).Rows[0]["Status"].ToString()); }
public static DataTable GettPendedOrder() { string str = "select orderID,userFname+' '+userLname FullName,Date,delivaryAddress,totalPrice from Users u ,Ordr o where u.userID=o.userID and o.orderStatus='pended'"; return(DBManager.ExecuteQuery(str)); }