public void EditUser(User user) { using (SqlConnection con = new SqlConnection(Configuration.someeServer)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = AdminRequest.UpdateUser(user); cmd.ExecuteNonQuery(); } }
public void AddCharity(string name, string desc, string logo) { using (SqlConnection con = new SqlConnection(Configuration.someeServer)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = AdminRequest.NewCharity(name, desc, logo); cmd.ExecuteNonQuery(); } }
public void AddUser(string email, string password, string firstName, string lastName, string roleId) { using (SqlConnection con = new SqlConnection(Configuration.someeServer)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = AdminRequest.NewUser(email, password, firstName, lastName, roleId); cmd.ExecuteNonQuery(); } }
public void AddVolunteers(List <Volunteer> volunteers) { using (SqlConnection con = new SqlConnection(Configuration.someeServer)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; volunteers.ForEach(volunteer => { cmd.CommandText = AdminRequest.NewVolunteer(volunteer); cmd.ExecuteNonQuery(); }); } }
public List <Charity> GetAllCharity() { var reader = Reader.GetTableReader(AdminRequest.Charities()); var charities = new List <Charity>(); while (reader.Read()) { var charity = new Charity( reader["CharityId"].ToString(), reader["CharityName"].ToString(), reader["CharityDescription"].ToString(), reader["CharityLogo"].ToString() ); charities.Add(charity); } return(charities); }
public List <User> GetAllUser() { var reader = Reader.GetTableReader(AdminRequest.Users()); var users = new List <User>(); while (reader.Read()) { var role = new Role(reader["RoleId"].ToString()); var user = new User( reader["Email"].ToString(), reader["Password"].ToString(), reader["FirstName"].ToString(), reader["LastName"].ToString(), role ); users.Add(user); } return(users); }