public static Models.LodgeMember xxGetMember(int id, string connString)
{
var item = new Models.LodgeMember();
try
{
using (var connection = new System.Data.SqlClient.SqlConnection(connString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "Select * from lodge.vwMemberList where MasonId=" + id;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
item = ReadaLodgeMemberLine(reader);
}
}
}
}
catch (Exception ex) { item.FullName = ex.Message; }
return item;
}
private static Models.LodgeMember ReadaLodgeMemberLine(System.Data.SqlClient.SqlDataReader reader)
{
var item = new Models.LodgeMember();
try
{
item.MemberNumber = (int)reader["MasonId"];
item.LastName = reader["LastName"].ToString();
item.FirstName = reader["FirstName"].ToString();
item.MiddleName = reader["MiddleName"].ToString();
item.NickName = reader["NickName"].ToString();
item.FullName = reader["FullName"].ToString();
item.SuffixName = reader["SuffixName"].ToString();
item.Birthdate = reader["Birthdate"].ToString();
item.Died = reader["Died"].ToString();
item.BirthLocation = reader["BirthLocation"].ToString();
item.Joined = reader["Joined"].ToString();
item.MemberStatus = reader["CurrentStatus"].ToString();
item.LastUpdated = reader["LastUpdated"].ToString();
item.StreetAddress = reader["StreetAddress"].ToString();
item.City = reader["City"].ToString();
item.State = reader["State"].ToString();
item.Zip = reader["Zip"].ToString();
item.HomePhone = reader["HomePhone"].ToString();
item.WorkPhone = reader["WorkPhone"].ToString();
item.MobilePhone = reader["MobilePhone"].ToString();
item.PersonalEmail = reader["Email"].ToString();
item.BusinessEmail = reader["WorkEmail"].ToString();
item.Initiated = reader["Initiated"].ToString();
item.Passed = reader["Passed"].ToString();
item.Raised = reader["Raised"].ToString();
}
catch (Exception ex) { item.FirstName = ex.Message; }
return item;
}
