private static SquadMember MapSquadMember(IDataReader reader, out int sm_SquadId)
{
SquadMember sm = new SquadMember();
int ord = 0;
PersonBase pb = new PersonBase();
SquadMemberStatus sms = new SquadMemberStatus();
sm.Id = reader.GetSafeInt32(ord++);
sm.SquadId = reader.GetSafeInt32(ord++);
sm_SquadId = sm.SquadId;
pb.Id = reader.GetSafeInt32(ord++);
sm.LeaderComment = reader.GetSafeString(ord++);
sm.DateCreated = reader.GetSafeDateTime(ord++);
sm.DateModified = reader.GetSafeDateTime(ord++);
sms.Id = reader.GetSafeInt32(ord++);
sms.Name = reader.GetSafeString(ord++);
pb.FirstName = reader.GetSafeString(ord++);
pb.MiddleName = reader.GetSafeString(ord++);
pb.LastName = reader.GetSafeString(ord++);
pb.PhoneNumber = reader.GetSafeString(ord++);
pb.Email = reader.GetSafeString(ord++);
pb.PhotoKey = reader.GetSafeString(ord++);
pb.ProfilePicture = SiteConfig.GetUrlFromFileKey(pb.PhotoKey);//this replaces the url
sm.IsLeader = reader.GetSafeBool(ord++);
sm.Person = pb;
sm.Status = sms;
return(sm);
}
public static List <SquadMemberStatus> SelectAll()
{
List <SquadMemberStatus> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadMemberStatus_SelectAll",
inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
SquadMemberStatus status = new SquadMemberStatus();
int ord = 0;
status.Id = reader.GetSafeInt32(ord++);
status.Name = reader.GetSafeString(ord++);
if (list == null)
{
list = new List <SquadMemberStatus>();
}
list.Add(status);
}
);
return(list);
}
public static List <SquadMember> SelectAll()
{
List <SquadMember> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadMember_SelectAll",
inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
SquadMember sm = new SquadMember();
int ord = 0;
SquadMemberStatus sms = new SquadMemberStatus();
sm.Id = reader.GetSafeInt32(ord++);
sm.SquadId = reader.GetSafeInt32(ord++);
PersonBase pb = new PersonBase();
pb.Id = reader.GetSafeInt32(ord++);
sm.LeaderComment = reader.GetSafeString(ord++);
sm.DateCreated = reader.GetSafeDateTime(ord++);
sm.DateModified = reader.GetSafeDateTime(ord++);
sms.Id = reader.GetSafeInt32(ord++);
sms.Name = reader.GetSafeString(ord++);
pb.FirstName = reader.GetSafeString(ord++);
pb.MiddleName = reader.GetSafeString(ord++);
pb.LastName = reader.GetSafeString(ord++);
pb.PhoneNumber = reader.GetSafeString(ord++);
pb.Email = reader.GetSafeString(ord++);
pb.PhotoKey = reader.GetSafeString(ord++);
sm.IsLeader = reader.GetBoolean(ord++);
sm.Person = pb;
sm.Status = sms;
if (list == null)
{
list = new List <SquadMember>();
}
list.Add(sm);
}
);
return(list);
}
public static SquadMember SelectById(int id)
{
SquadMember sm = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadMember_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("Id", id);
}
, map : delegate(IDataReader reader, short set)
{
sm = new SquadMember();
int ord = 0;
SquadMemberStatus sms = new SquadMemberStatus();
sm.Id = reader.GetSafeInt32(ord++);
sm.SquadId = reader.GetSafeInt32(ord++);
PersonBase pb = new PersonBase();
pb.Id = reader.GetSafeInt32(ord++);
sm.LeaderComment = reader.GetSafeString(ord++);
sm.DateCreated = reader.GetSafeDateTime(ord++);
sm.DateModified = reader.GetSafeDateTime(ord++);
sms.Id = reader.GetSafeInt32(ord++);
sms.Name = reader.GetSafeString(ord++);
pb.FirstName = reader.GetSafeString(ord++);
pb.MiddleName = reader.GetSafeString(ord++);
pb.LastName = reader.GetSafeString(ord++);
pb.PhoneNumber = reader.GetSafeString(ord++);
pb.Email = reader.GetSafeString(ord++);
pb.PhotoKey = reader.GetSafeString(ord++);
sm.IsLeader = reader.GetBoolean(ord++);
sm.Person = pb;
sm.Status = sms;
}
);
return(sm);
}
