public void UPDATE_PRODUCT(int ID_cat, string Label_product, string ID_product, int Qte, string Price, byte[] img) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); 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.VarChar, 30); 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.ExecuteCommand("UPDATE_PRODUCT", param); DAL.close(); }
public void ADD_ORDER(int ID_ORDER, DateTime DATE_ORDER, int CUSTOMER_ID, string DESCRIPTION_ORDER, string SALESMAN) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); 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.VarChar, 250); param[3].Value = DESCRIPTION_ORDER; param[4] = new SqlParameter("@SALESMAN", SqlDbType.VarChar, 50); param[4].Value = SALESMAN; DAL.ExecuteCommand("ADD_ORDER", param); DAL.close(); }
public void ADD_ORDER_DETAILS(string ID_PRODUCT, int ID_ORDER, int QTE, string PRICE, double DISCOUNT, string AMOUNT, string TOTAL_AMOUNT) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); 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.ExecuteCommand("ADD_ORDER_DETAILS", param); DAL.close(); }
public void EDIT_CUSTOMER(string First_Name, string Last_Name, string Tel, string Email, byte[] Picture, string Criterion, int ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@First_Name", SqlDbType.VarChar, 25); param[0].Value = First_Name; param[1] = new SqlParameter("@Last_Name", SqlDbType.VarChar, 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("@Picture", SqlDbType.Image); param[4].Value = Picture; param[5] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50); param[5].Value = Criterion; param[6] = new SqlParameter("@ID", SqlDbType.Int); param[6].Value = ID; DAL.ExecuteCommand("EDIT_CUSTOMER", param); DAL.close(); }
public DataTable GET_ALL_PRODUCTS() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_ALL_PRODUCTS", null); DAL.close(); return(Dt); }
public DataTable GET_ALL_CATEGORIES() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("get_cat", null); DAL.close(); return(Dt); }
public DataTable GET_LAST_ORDER_FOR_PRINT() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_LAST_ORDER_FOR_PRINT", null); DAL.close(); return(Dt); }
public void DeleteProduct(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50); param[0].Value = ID; DAL.ExecuteCommand("DeleteProduct", param); DAL.close(); }
public DataTable SearchProduct(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50); param[0].Value = ID; Dt = DAL.SelectData("SearchProduct", param); DAL.close(); return(Dt); }
public DataTable GET_IMAGE_PRODUCT(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); 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_IMAGE_PRODUCT", param); DAL.close(); return(Dt); }
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 void DELETE_CUSTOMER(int ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.Int); param[0].Value = ID; DAL.ExecuteCommand("DELETE_CUSTOMER", param); DAL.close(); }
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); }
public void EDIT_USER(string ID, string FullName, string PWD, string UserType) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50); param[0].Value = ID; param[1] = new SqlParameter("@FullName", SqlDbType.VarChar, 50); param[1].Value = FullName; param[2] = new SqlParameter("@PWD", SqlDbType.VarChar, 50); param[2].Value = PWD; param[3] = new SqlParameter("@UserType", SqlDbType.VarChar, 50); param[3].Value = UserType; DAL.ExecuteCommand("EDIT_USER", param); DAL.close(); }