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