public DataTable Search_Customer(string Criterion)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50);
Param[0].Value = Criterion;
Dt = DAL.SelectData("Search_Customer", Param);
DAL.close();
return(Dt);
}
public DataTable get_order(int ID_ORDER)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
Dt = DAL.SelectData("get_order", param);
DAL.close();
return(Dt);
}
public DataTable LOGIN(string ID, string PWD)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
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;
DAL.close();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
return(Dt);
}
public DataTable VerifyQty(string ID_PRODUCT, int Qty_Entered)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[0].Value = ID_PRODUCT;
param[1] = new SqlParameter("@Qty_Entered", SqlDbType.Int);
param[1].Value = Qty_Entered;
Dt = DAL.SelectData("VerifyQty", param);
DAL.close();
return(Dt);
}
