public List <SquadTag> SelectAll() { List <SquadTag> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.SquadTag_SelectAll" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { } , map : delegate(IDataReader reader, short set) { SquadTag p = new SquadTag(); int startingIndex = 0; //startingOrdinal p.Id = reader.GetInt32(startingIndex++); p.Keyword = reader.GetString(startingIndex++); p.DisplayOrder = reader.GetInt32(startingIndex++); if (list == null) { list = new List <SquadTag>(); } list.Add(p); } ); return(list); }
protected void CreateSquad_Click(object sender, EventArgs e) { string squadName = ((TextBox)SquadName.FindControl("SquadName")).Text; string squadTag = ((TextBox)SquadTag.FindControl("SquadTag")).Text; string squadDescription = SquadDescription.Value; string createSquad = "insert into [Squads](SquadName, SquadTag, SquadDescription) values('" + squadName + "','" + squadTag + "','" + squadDescription + "';"; function.Create(createSquad); }
private static SquadTag MapSquadTag(IDataReader reader, out int squadId) { SquadTag st = new SquadTag(); int ord = 0; squadId = reader.GetSafeInt32(ord++); st.Id = reader.GetSafeInt32(ord++); st.Keyword = reader.GetSafeString(ord++); st.DisplayOrder = reader.GetSafeInt32(ord++); st.Inactive = reader.GetSafeBool(ord++); return(st); }
public static List <SquadTag> SelectSquadTags(int id) { List <SquadTag> stList = new List <SquadTag>(); DataProvider.ExecuteCmd(GetConnection, "dbo.SquadSquadTag_SelectBySquadId", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@SquadId", id); }, map : (Action <IDataReader, short>) delegate(IDataReader reader, short set) { SquadTag squadTag = new SquadTag(); int startingIndex = 0; squadTag.Id = reader.GetSafeInt32(startingIndex++); squadTag.Keyword = reader.GetSafeString(startingIndex++); stList.Add(squadTag); }); return(stList); }
public SquadTag SelectById(int id) { SquadTag squadTag = null; DataProvider.ExecuteCmd(GetConnection, "dbo.SquadTag_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); } , map : delegate(IDataReader reader, short set) { squadTag = new SquadTag(); int startingIndex = 0; //startingOrdinal squadTag.Id = reader.GetInt32(startingIndex++); squadTag.Keyword = reader.GetString(startingIndex++); squadTag.DisplayOrder = reader.GetInt32(startingIndex++); } ); return(squadTag); }
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); }