public DataTable Get_allprdcts()
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = dal.Read_Data("select_all_prdcts", null);
return(Dt);
}
public DataTable Get_Categories()
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = dal.Read_Data("Get_Categories", null);
return(Dt);
}
public DataTable Get_Last_order()
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = dal.Read_Data("Get_last_order_ID", null);
return(Dt);
}
public DataTable Get_Customers()
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = dal.Read_Data("Get_All_Customers", null);
return(Dt);
}
public DataTable Delete(string ID)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@ID", SqlDbType.NChar, 50);
par[0].Value = ID;
Dt = dal.Read_Data("mydel", par);
return(Dt);
}
public DataTable Search(string word)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@word", SqlDbType.VarChar, 50);
par[0].Value = word;
Dt = dal.Read_Data("Search", par);
return(Dt);
}
public DataTable get_image(string ID)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@ID", SqlDbType.NChar, 10);
par[0].Value = ID;
Dt = dal.Read_Data("get_my_imag", par);
dal.Close_Connection();
return(Dt);
}
public DataTable find_cust( )
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@id", SqlDbType.Int);
par[0].Value = id;
Dt = dal.Read_Data("find_customer", par);
return(Dt);
}
public DataTable GET_BELLS(string word)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@WORD", SqlDbType.VarChar, 50);
par[0].Value = word;
Dt = dal.Read_Data("SEARCH_BELLS", par);
return(Dt);
}
public DataTable GET_Details_return(int id)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@id_order", SqlDbType.Int);
par[0].Value = id;
Dt = dal.Read_Data("GET_Details_Order_return", par);
return(Dt);
}
public DataTable Return_Quantity(string ID, int quant, int order_id)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[3];
par[0] = new SqlParameter("@product_id", SqlDbType.NChar, 10);
par[0].Value = ID;
par[1] = new SqlParameter("@quantity", SqlDbType.Int);
par[1].Value = quant;
par[2] = new SqlParameter("@id_order", SqlDbType.Int);
par[2].Value = order_id;
Dt = dal.Read_Data("return_product", par);
return(Dt);
}
public bool Find_ID(string ID)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter [1];
par[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
par[0].Value = ID;
Dt = dal.Read_Data("Find_ID", par);
if (Dt.Rows.Count > 0)
{
return(false);
}
return(true);
}
//Method to check authentication
public DataTable authentication_login(string UserName, string password)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
SqlParameter [] para = new SqlParameter [2];
para[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
para[0].Value = UserName;
para[1] = new SqlParameter("@Password", SqlDbType.NVarChar, 50);
para[1].Value = password;
DataTable Dt = new DataTable();
Dt = dal.Read_Data("Loging_info", para);
dal.Close_Connection();
return(Dt);
}
public bool Check_Quantity(string ID, int quant)
{
DAL.Data_Access_Layer dal = new DAL.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@id_prod", SqlDbType.NChar, 10);
par[0].Value = ID;
par[1] = new SqlParameter("@quant", SqlDbType.Int);
par[1].Value = quant;
Dt = dal.Read_Data("check_quantity", par);
if (Dt.Rows.Count > 0)
{
return(true);
}
return(false);
}