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