public void ADD_PRODUCTS(int ID_cat, string Label_Product, string ID_product, int Qte, string Price, byte[] img) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID_CAT", SqlDbType.Int); param[0].Value = ID_cat; param[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30); param[1].Value = ID_product; param[2] = new SqlParameter("@LABEL", SqlDbType.NVarChar); param[2].Value = Label_Product; param[3] = new SqlParameter("@Qte", SqlDbType.Int); param[3].Value = Qte; param[4] = new SqlParameter("@PRICE", SqlDbType.VarChar, 50); param[4].Value = Price; param[5] = new SqlParameter("@Img", SqlDbType.Image); param[5].Value = img; DAL.ExcecuteCommand("ADD_PRODUCT", param); DAL.close(); }
public void ADD_ORDER_DETAILS( string ID_PRODUCT, int ID_ORDER, int QTE, string PRICE, float DISCOUNT, string AMOUNT, string TOTAL_AMOUNT ) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30); param[0].Value = ID_PRODUCT; param[1] = new SqlParameter("@ID_ORDER", SqlDbType.Int); param[1].Value = ID_ORDER; param[2] = new SqlParameter("@QTE", SqlDbType.Int); param[2].Value = QTE; param[3] = new SqlParameter("@PRICE", SqlDbType.VarChar, 50); param[3].Value = PRICE; param[4] = new SqlParameter("@DISCOUNT", SqlDbType.Float); param[4].Value = DISCOUNT; param[5] = new SqlParameter("@AMOUNT", SqlDbType.VarChar, 50); param[5].Value = AMOUNT; param[6] = new SqlParameter("@TOTAL_AMOUNT", SqlDbType.VarChar, 50); param[6].Value = TOTAL_AMOUNT; DAL.ExcecuteCommand("ADD_ORDER_DETAILS", param); DAL.close(); }
public void EDIT_CUSTOMERS(string FIRST_NAME, string LAST_NAME, string TEL, string EMAIL, byte[] PICUTRE, string Criterion, int id) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@FIRST_NAME", SqlDbType.NVarChar, 25); param[0].Value = FIRST_NAME; param[1] = new SqlParameter("@LAST_NAME", SqlDbType.NVarChar, 25); param[1].Value = LAST_NAME; param[2] = new SqlParameter("@TEL", SqlDbType.NChar, 15); param[2].Value = TEL; param[3] = new SqlParameter("@EMAIL", SqlDbType.VarChar, 25); param[3].Value = EMAIL; param[4] = new SqlParameter("@PICUTRE", SqlDbType.Image); param[4].Value = PICUTRE; param[5] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50); param[5].Value = Criterion; param[6] = new SqlParameter("@ID", SqlDbType.Int); param[6].Value = id; DAL.ExcecuteCommand("EDIT_CUSTOMERS", param); DAL.close(); }
public void ADD_ORDER( int ID_ORDER, DateTime DATE_ORDER, int CUSTOMER_ID, string DESCRIPTION_ORDER, string SALESMAN) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int); param[0].Value = ID_ORDER; param[1] = new SqlParameter("@DATE_ORDER", SqlDbType.DateTime); param[1].Value = DATE_ORDER; param[2] = new SqlParameter("@CUSTOMER_ID", SqlDbType.Int); param[2].Value = CUSTOMER_ID; param[3] = new SqlParameter("@DESCRIPTION_ORDER", SqlDbType.NVarChar, 250); param[3].Value = DESCRIPTION_ORDER; param[4] = new SqlParameter("@SALESMAN", SqlDbType.NVarChar, 75); param[4].Value = SALESMAN; DAL.ExcecuteCommand("ADD_ORDER", param); DAL.close(); }
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 void DELETE_PRODUCT(string ID) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50); param[0].Value = ID; DAL.ExcecuteCommand("DELETE_PRODUCT", param); DAL.close(); }
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 void DELETE_CUSTOMERS(int id) { Data_Access_Layer.Data_Access_Layer DAL = new Data_Access_Layer.Data_Access_Layer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.Int); param[0].Value = id; DAL.ExcecuteCommand("DELETE_CUSTOMER", param); DAL.close(); }
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); }