public void DELETE_USER(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("DELETE_USER", 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(); }