public string Save(Member member)
{
if (member.MemberId.ToString() == string.Empty)
{
return "Member Id is missing";
}
else if (member.Name == string.Empty)
{
return "Name is missing";
}
else if (memberGateway.HasThisNumberExists(member.MemberId))
{
return "Sorry,Member Already Exists";
}
else
{
int value = memberGateway.Save(member);
if (value > 0)
{
return "Member Saved Successfully";
}
else
{
return "Operation Failed";
}
}
}
public int Save(Member member)
{
SqlConnection connection=new SqlConnection(connectionstring);
string query = "INSERT INTO Member VALUES('"+member.MemberId+"','"+member.Name+"')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowsAffected = command.ExecuteNonQuery();
return rowsAffected;
}
