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