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