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