public List <SquadEvent> SelectAll()
{
List <SquadEvent> list = new List <SquadEvent>();
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadEvent_SelectAll",
inputParamMapper : null,
map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
int squadEventId = 0;
SquadEvent squadEvent = MapSquadEvent(reader, out squadEventId);
if (list == null)
{
list = new List <SquadEvent>();
}
list.Add(squadEvent);
break;
}
}
);
return(list);
}
public List <SquadEvent> SelectBySquadId(int squadId)
{
List <SquadEvent> list = new List <SquadEvent>();
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadEvent_SelectbySquadId",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@SquadId", squadId);
},
map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
int squadEventId = 0;
SquadEvent squadEvent = MapSquadEvent(reader, out squadEventId);
if (list == null)
{
list = new List <SquadEvent>();
}
list.Add(squadEvent);
break;
}
});
return(list);
}
public List <SquadEvent> SquadEventSearch(SquadEventSearchRequest model, out int totalRows)
{
List <SquadEvent> list = null;
int r = 0;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadEvent_Search",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@SearchStr", model.SearchString);
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramCollection.AddWithValue("@SquadId", model.SquadId);
}
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
SquadEvent sqe = new SquadEvent();
int ord = 0;
sqe.Id = reader.GetSafeInt32(ord++);
sqe.Name = reader.GetSafeString(ord++);
sqe.DateCreated = reader.GetSafeDateTime(ord++);
sqe.DateModified = reader.GetSafeDateTime(ord++);
sqe.UserIdCreated = reader.GetSafeString(ord++);
sqe.EventStart = reader.GetSafeDateTime(ord++);
sqe.EventEnd = reader.GetSafeDateTime(ord++);
sqe.Description = reader.GetSafeString(ord++);
sqe.Location = reader.GetSafeString(ord++);
sqe.SquadId = reader.GetSafeInt32(ord++);
sqe.Color = reader.GetSafeString(ord++);
sqe.Timezone = reader.GetSafeString(ord++);
r = reader.GetSafeInt32(ord++);
if (list == null)
{
list = new List <SquadEvent>();
}
list.Add(sqe);
break;
}
});
totalRows = r;
return(list);
}
public List <Squad> Search(SquadSearchRequest model)
{
List <Squad> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Squad_Search"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@SearchStr", model.SearchString);
}
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0: //first result set
Squad p = new Squad();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetInt32(startingIndex++);
p.Name = reader.GetSafeString(startingIndex++); //extension method
p.Mission = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List <Squad>();
}
list.Add(p);
break;
case 1:
int squadId = 0;
SquadEvent squadEvent = MapSquadEvent(reader, out squadId);
Squad parentSquad = list.Find(o => o.Id == squadId);
if (parentSquad.SquadEvents == null)
{
parentSquad.SquadEvents = new List <SquadEvent>();
}
parentSquad.SquadEvents.Add(squadEvent);
break;
}
}
);
return(list);
}
public SquadEvent SelectById(int id)
{
SquadEvent squadEvent = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadEvent_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
},
map : delegate(IDataReader reader, short set)
{
int squadEventId = 0;
squadEvent = MapSquadEvent(reader, out squadEventId);
}
);
return(squadEvent);
}
private static SquadEvent MapSquadEvent(IDataReader reader, out int squadId)
{
SquadEvent sqe = new SquadEvent();
int ord = 0;
sqe.Id = reader.GetSafeInt32(ord++);
sqe.Name = reader.GetSafeString(ord++);
sqe.DateCreated = reader.GetSafeDateTime(ord++);
sqe.DateModified = reader.GetSafeDateTime(ord++);
sqe.UserIdCreated = reader.GetSafeString(ord++);
sqe.EventStart = reader.GetSafeDateTime(ord++);
sqe.EventEnd = reader.GetSafeDateTime(ord++);
sqe.Description = reader.GetSafeString(ord++);
sqe.Location = reader.GetSafeString(ord++);
sqe.SquadId = reader.GetSafeInt32(ord++);
squadId = sqe.SquadId;
sqe.Color = reader.GetSafeString(ord++);
sqe.Timezone = reader.GetSafeString(ord++);
return(sqe);
}
public Squad SelectById(int id)
{
Squad squad = null;
List <SquadEvent> sqEventList = null;
List <SquadMember> squadMemberList = null;
List <SquadTag> SquadTagList = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Squad_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
squad = new Squad();
int startingIndex = 0;
squad.Id = reader.GetInt32(startingIndex++);
squad.Name = reader.GetString(startingIndex++);
squad.Mission = reader.GetString(startingIndex++);
squad.Notes = reader.GetString(startingIndex++);
break;
case 1:
int squadEventId = 0;
SquadEvent squadEvent = MapSquadEvent(reader, out squadEventId);
if (sqEventList == null)
{
sqEventList = new List <SquadEvent>();
}
sqEventList.Add(squadEvent);
break;
case 2:
int squadMemberId = 0;
SquadMember squadMember = MapSquadMember(reader, out squadMemberId);
if (squadMemberList == null)
{
squadMemberList = new List <SquadMember>();
}
squadMemberList.Add(squadMember);
break;
default:
break;
case 3:
int SquadTagId = 0;
SquadTag squadTag = MapSquadTag(reader, out SquadTagId);
if (SquadTagList == null)
{
SquadTagList = new List <SquadTag>();
}
SquadTagList.Add(squadTag);
break;
}
}
);
squad.SquadEvents = sqEventList;
squad.SquadMember = squadMemberList;
squad.SquadTag = SquadTagList;
return(squad);
}
public List <Squad> SelectAll()
{
List <Squad> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Squad_SelectAll"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
Squad p = new Squad();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetInt32(startingIndex++);
p.Name = reader.GetSafeString(startingIndex++); //extension method
p.Mission = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List <Squad>();
}
list.Add(p);
break;
case 1:
int se_SquadId = 0;
SquadEvent squadEvent = MapSquadEvent(reader, out se_SquadId);
Squad squad_se = list.Find(item => item.Id == se_SquadId);
if (squad_se.SquadEvents == null)
{
squad_se.SquadEvents = new List <SquadEvent>();
}
squad_se.SquadEvents.Add(squadEvent);
break;
case 2:
int sm_SquadId = 0;
SquadMember squadMember = MapSquadMember(reader, out sm_SquadId);
Squad squad_sm = list.Find(item => item.Id == sm_SquadId);
if (squad_sm.SquadMember == null)
{
squad_sm.SquadMember = new List <SquadMember>();
}
squad_sm.SquadMember.Add(squadMember);
break;
case 3:
int st_SquadId = 0;
SquadTag squadTag = MapSquadTag(reader, out st_SquadId);
Squad squad_st = list.Find(item => item.Id == st_SquadId);
if (squad_st.SquadTag == null)
{
squad_st.SquadTag = new List <SquadTag>();
}
squad_st.SquadTag.Add(squadTag);
break;
default:
break;
}
}
);
return(list);
}
