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