public DataTable GET_ALL_PRODUCTS()
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_PRODUCTS", null);
DAL.close();
return(Dt);
}
public DataTable GET_LAST_ORDER_ID()
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_LAST_ORDER_ID", null);
DAL.close();
return(Dt);
}
public DataTable SEARCH_PRODUCT(string id)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = id;
Dt = DAL.SelectData("SEARCH_PRODUCTS", param);
DAL.close();
return(Dt);
}
public DataTable SEARCH_CUSTOMER(string Criterion)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Criterion", SqlDbType.NVarChar, 50);
param[0].Value = Criterion;
Dt = DAL.SelectData("SEARCH_CUSTOMER", param);
DAL.close();
return(Dt);
}
public DataTable DELETE_USER(string ID)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("DELETE_USER", param);
DAL.close();
return(Dt);
}
public DataTable LOGIN(string ID, string PWD)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@PWD", SqlDbType.VarChar, 50);
param[1].Value = PWD;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
DAL.close();
return(Dt);
}
public DataTable GET_ORDER_DETAILS(int id)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.VarChar, 30);
param[0].Value = id;
Dt = DAL.SelectData("GET_ORDER_DETAILS", param);
DAL.close();
return(Dt);
}
public DataTable VERIFY_QTE(string id, int qty)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[0].Value = id;
param[1] = new SqlParameter("@Qty_ENTERED", SqlDbType.Int);
param[1].Value = qty;
Dt = DAL.SelectData("VERIFY_QTE", param);
DAL.close();
return(Dt);
}
public DataTable EDIT_USER(string ID, string PWD, string fullname, string type)
{
Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@PWD", SqlDbType.VarChar, 50);
param[1].Value = PWD;
param[2] = new SqlParameter("@UserType", SqlDbType.NVarChar, 50);
param[2].Value = type;
param[3] = new SqlParameter("@FullName", SqlDbType.NVarChar, 100);
param[3].Value = fullname;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("EDIT_USER", param);
DAL.close();
return(Dt);
}
