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