public void EDIT_CUSTOMER(string First_Name, string Last_Name, string Tel, string Email, byte[] Picture, string Criterion, int ID) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 void UPDATE_PRODUCT(int ID_Cat, string label_product, string ID_product, int Qte, string Price, byte[] img) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 DataTable GET_LAST_ORDER_ID() { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_LAST_ORDER_ID", null); DAL.close(); return(Dt); }
public DataTable GET_ALL_CUSTOMERS() { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer(); DAL.open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_ALL_CUSTOMERS", null); DAL.close(); return(Dt); }
public void DELETE_CUSTOMER(int ID) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 void DeleteProduct(string ID) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 VerifyProductID(string ID) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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("VerifyProductID", param); DAL.close(); return(Dt); }
public DataTable Search_Customer(string Criterion) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer(); DAL.open(); DataTable Dt = new DataTable(); SqlParameter[] param; 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 LOGIN(string ID, string PWD) { Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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); }