public DataTable GET_ALL_PRODUCTS() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.selectdata("GET_ALL_PRODUCTS", null); DAL.Close(); return(Dt); }
public DataTable select_customer() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); dt = DAL.selectdata("get_customer", null); DAL.Close(); return(dt); }
public DataTable GET_LAST_ORDER_ID_For_Print() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); dt = DAL.selectdata("GET_LAST_ORDER_ID_for_print", null); DAL.Close(); return(dt); }
public DataTable search_customer(string creation) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@creation", SqlDbType.VarChar); param[0].Value = creation; DataTable dt = new DataTable(); dt = DAL.selectdata("Search_customer", param); DAL.Close(); return(dt); }
public DataTable search_PRODUCT(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); 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_PRODUCT", param); DAL.Close(); return(Dt); }
public DataTable SEARCHUSER(string SEARCH) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable dt = new DataTable(); SqlParameter[] PARAM = new SqlParameter[1]; PARAM[0] = new SqlParameter("@SEARCH", SqlDbType.VarChar, 50); PARAM[0].Value = SEARCH; dt = DAL.selectdata("SEARCHUSER", PARAM); DAL.Close(); return(dt); }
public DataTable Get_Imag(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, (50)); param[0].Value = ID; dt = DAL.selectdata("Get_Imag", param); DAL.Close(); return(dt); }
public DataTable GET_ORDER_DETAILS_REPORT_forprint(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_DETAILS_REPORT_forprint", PARAM); DAL.Close(); return(dt); }
public DataTable VERIFY_QNT(string ID, int QNT_INTERED) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 50); param[0].Value = ID; param[1] = new SqlParameter("@QNT_INTERED", SqlDbType.Int); param[1].Value = QNT_INTERED; Dt = DAL.selectdata("VERIFY_QNT", 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.Open(); DataTable Dt = new DataTable(); Dt = DAL.selectdata("SP_Login", param); DAL.Close(); return(Dt); }