public User Create(User source) { User actual = null; SqlConnection connection = ConnectionFactory.GetConnection (); SqlCommand command = new SqlCommand (QUERY_CREATE, connection); command.Parameters.AddWithValue ("@Name", source.Name); command.Parameters.AddWithValue ("@Password", source.Password); command.Parameters.AddWithValue ("@Email", source.Email); try { connection.Open (); int id = (int) command.ExecuteScalar (); actual = GetById (id); } finally { connection.Close (); } return actual; }
private User ReadUser(SqlDataReader reader) { User user = new User (); user.Id = (int) reader["Id"]; user.Name = reader["Name"].ToString (); user.Password = reader["Password"].ToString (); user.Email = reader["Email"].ToString (); return user; }
public User Update(User source) { User me = CurrentUser.retrieve (); SqlConnection connection = ConnectionFactory.GetConnection (); SqlCommand command = new SqlCommand (QUERY_UPDATE, connection); command.Parameters.AddWithValue ("@Id", me.Id); command.Parameters.AddWithValue ("@Name", source.Name == null ? me.Name : source.Name); command.Parameters.AddWithValue ("@Password", source.Password == null ? me.Password : source.Password); command.Parameters.AddWithValue ("@Email", source.Email == null ? me.Email : source.Email); try { connection.Open (); command.ExecuteScalar (); } finally { connection.Close (); } return GetById (me.Id); }