public User AddNewMember(User user) { bool test; do { Console.Write("State name: "); user.Name = Console.ReadLine(); if (user.Name.Length == 0) { Console.Clear(); Console.WriteLine("You must have atleast type one char"); } } while (user.Name.Length == 0); do { int n; Console.Write("State personal number: "); string s = Console.ReadLine(); test = Int32.TryParse(s, out n); if (test) { user.PersonalNumber = n; } else { Console.Clear(); Console.WriteLine("Try to state a number again"); } } while (test == false); return user; }
public void AddMember(User user) { try { using (SqlConnection conn = CreateConnection()) { SqlCommand sqlCmd = new SqlCommand("applicationSchema.usp_AddMember", conn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = user.Name; sqlCmd.Parameters.Add("@Personalnumber", SqlDbType.Int, 4).Value = user.PersonalNumber; conn.Open(); sqlCmd.ExecuteNonQuery(); } } catch (Exception) { throw new Exception("Error when the data was going to be saved"); } }
public bool SaveMember(User user) { UserDAL usrDAL = new UserDAL(); List<User> userlist = usrDAL.GetUsers(); if (userlist.Exists(x => x.PersonalNumber == user.PersonalNumber)) { return false; } else { usrDAL.AddMember(user); return true; } }
public void UpdateMember(User user, int userPersonalNumber) { UserDAL usrDAL = new UserDAL(); usrDAL.UpdateMember(user, userPersonalNumber); }
public User ChangeMember(User user) { Console.WriteLine("Change member info"); do { Console.Write("State name:"); user.Name = Console.ReadLine(); if (user.Name == "" || user.Name == null) { Console.Clear(); Console.WriteLine("Try state a name again"); } } while (user.Name == "" || user.Name == null); return user; }