public List<DataObjectCodeCampEvals> GetAll(string sortData)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
List<DataObjectCodeCampEvals> DataTemplateODSList = new List<DataObjectCodeCampEvals>();
SqlDataReader reader = null;
string sqlSelectString = "SELECT AttendeePKID,MetExpectations,PlanToAttendAgain,EnjoyedFreeFood,SessionsVariedEnough,EnoughSessionsAtMyLevel,FoothillGoodVenue,WishToldMoreFriends,EventWellPlanned,WirelessAccessImportant,WiredAccessImportant,LikeReceivingUpdateByEmail,LikeReceivingUpdateByByRSSFeed,RatherNoSponsorAndNoFreeFood,AttendedVistaFairOnly,AttendedVistaFairAndCC,AttendedCCOnly,BestPartOfEvent,WhatWouldYouChange,NotSatisfiedWhy,WhatFoothillClassesToAdd,InteresteInLongTermPlanning,InteresteInWebBackEnd,InterestedInWebFrontEnd,InteresteInLongSessionReviewPanel,InteresteInContributorSolicitation,InteresteInBeingContributor,InteresteInBeforeEvent,InteresteInDayOfEvent,InteresteInEventTearDown,InteresteInAfterEvent,ForVolunteeringBestWayToContactEmail,ForVolunteeringBestWayToContactPhone,DateSubmitted,DateUpdated,id FROM [dbo].[CodeCampEvals] ";
SqlCommand cmd = new SqlCommand(sqlSelectString, conn);
reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
Guid attendeepkid = reader.IsDBNull(0) ? Guid.NewGuid() : reader.GetGuid(0);
int metexpectations = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);
int plantoattendagain = reader.IsDBNull(2) ? 0 : reader.GetInt32(2);
int enjoyedfreefood = reader.IsDBNull(3) ? 0 : reader.GetInt32(3);
int sessionsvariedenough = reader.IsDBNull(4) ? 0 : reader.GetInt32(4);
int enoughsessionsatmylevel = reader.IsDBNull(5) ? 0 : reader.GetInt32(5);
int foothillgoodvenue = reader.IsDBNull(6) ? 0 : reader.GetInt32(6);
int wishtoldmorefriends = reader.IsDBNull(7) ? 0 : reader.GetInt32(7);
int eventwellplanned = reader.IsDBNull(8) ? 0 : reader.GetInt32(8);
int wirelessaccessimportant = reader.IsDBNull(9) ? 0 : reader.GetInt32(9);
int wiredaccessimportant = reader.IsDBNull(10) ? 0 : reader.GetInt32(10);
int likereceivingupdatebyemail = reader.IsDBNull(11) ? 0 : reader.GetInt32(11);
int likereceivingupdatebybyrssfeed = reader.IsDBNull(12) ? 0 : reader.GetInt32(12);
int rathernosponsorandnofreefood = reader.IsDBNull(13) ? 0 : reader.GetInt32(13);
bool attendedvistafaironly = reader.IsDBNull(14) ? false : reader.GetBoolean(14);
bool attendedvistafairandcc = reader.IsDBNull(15) ? false : reader.GetBoolean(15);
bool attendedcconly = reader.IsDBNull(16) ? false : reader.GetBoolean(16);
string bestpartofevent = reader.IsDBNull(17) ? "" : reader.GetString(17);
string whatwouldyouchange = reader.IsDBNull(18) ? "" : reader.GetString(18);
string notsatisfiedwhy = reader.IsDBNull(19) ? "" : reader.GetString(19);
string whatfoothillclassestoadd = reader.IsDBNull(20) ? "" : reader.GetString(20);
bool interesteinlongtermplanning = reader.IsDBNull(21) ? false : reader.GetBoolean(21);
bool interesteinwebbackend = reader.IsDBNull(22) ? false : reader.GetBoolean(22);
bool interestedinwebfrontend = reader.IsDBNull(23) ? false : reader.GetBoolean(23);
bool interesteinlongsessionreviewpanel = reader.IsDBNull(24) ? false : reader.GetBoolean(24);
bool interesteincontributorsolicitation = reader.IsDBNull(25) ? false : reader.GetBoolean(25);
bool interesteinbeingcontributor = reader.IsDBNull(26) ? false : reader.GetBoolean(26);
bool interesteinbeforeevent = reader.IsDBNull(27) ? false : reader.GetBoolean(27);
bool interesteindayofevent = reader.IsDBNull(28) ? false : reader.GetBoolean(28);
bool interesteineventteardown = reader.IsDBNull(29) ? false : reader.GetBoolean(29);
bool interesteinafterevent = reader.IsDBNull(30) ? false : reader.GetBoolean(30);
string forvolunteeringbestwaytocontactemail = reader.IsDBNull(31) ? "" : reader.GetString(31);
string forvolunteeringbestwaytocontactphone = reader.IsDBNull(32) ? "" : reader.GetString(32);
DateTime datesubmitted = reader.IsDBNull(33) ? DateTime.Now : reader.GetDateTime(33);
DateTime dateupdated = reader.IsDBNull(34) ? DateTime.Now : reader.GetDateTime(34);
int id = reader.IsDBNull(35) ? 0 : reader.GetInt32(35);
DataObjectCodeCampEvals td = new DataObjectCodeCampEvals(attendeepkid, metexpectations, plantoattendagain, enjoyedfreefood, sessionsvariedenough, enoughsessionsatmylevel, foothillgoodvenue, wishtoldmorefriends, eventwellplanned, wirelessaccessimportant, wiredaccessimportant, likereceivingupdatebyemail, likereceivingupdatebybyrssfeed, rathernosponsorandnofreefood, attendedvistafaironly, attendedvistafairandcc, attendedcconly, bestpartofevent, whatwouldyouchange, notsatisfiedwhy, whatfoothillclassestoadd, interesteinlongtermplanning, interesteinwebbackend, interestedinwebfrontend, interesteinlongsessionreviewpanel, interesteincontributorsolicitation, interesteinbeingcontributor, interesteinbeforeevent, interesteindayofevent, interesteineventteardown, interesteinafterevent, forvolunteeringbestwaytocontactemail, forvolunteeringbestwaytocontactphone, datesubmitted, dateupdated, id);
DataTemplateODSList.Add(td);
}
}
finally
{
if (reader != null) reader.Close();
}
conn.Close();
if (sortData == null)
{
sortData = "Id";
}
if (sortData.Length == 0)
{
sortData = "Id";
}
string sortDataBase = sortData;
string descString = " DESC";
if (sortData.EndsWith(descString))
{
sortDataBase = sortData.Substring(0, sortData.Length - descString.Length);
}
Comparison<DataObjectCodeCampEvals> comparison = null;
switch (sortDataBase)
{
case "Metexpectations":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Metexpectations.CompareTo(rhs.Metexpectations);
}
);
break;
case "Plantoattendagain":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Plantoattendagain.CompareTo(rhs.Plantoattendagain);
}
);
break;
case "Enjoyedfreefood":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Enjoyedfreefood.CompareTo(rhs.Enjoyedfreefood);
}
);
break;
case "Sessionsvariedenough":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Sessionsvariedenough.CompareTo(rhs.Sessionsvariedenough);
}
);
break;
case "Enoughsessionsatmylevel":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Enoughsessionsatmylevel.CompareTo(rhs.Enoughsessionsatmylevel);
}
);
break;
case "Foothillgoodvenue":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Foothillgoodvenue.CompareTo(rhs.Foothillgoodvenue);
}
);
break;
case "Wishtoldmorefriends":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Wishtoldmorefriends.CompareTo(rhs.Wishtoldmorefriends);
}
);
break;
case "Eventwellplanned":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Eventwellplanned.CompareTo(rhs.Eventwellplanned);
}
);
break;
case "Wirelessaccessimportant":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Wirelessaccessimportant.CompareTo(rhs.Wirelessaccessimportant);
}
);
break;
case "Wiredaccessimportant":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Wiredaccessimportant.CompareTo(rhs.Wiredaccessimportant);
}
);
break;
case "Likereceivingupdatebyemail":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Likereceivingupdatebyemail.CompareTo(rhs.Likereceivingupdatebyemail);
}
);
break;
case "Likereceivingupdatebybyrssfeed":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Likereceivingupdatebybyrssfeed.CompareTo(rhs.Likereceivingupdatebybyrssfeed);
}
);
break;
case "Rathernosponsorandnofreefood":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Rathernosponsorandnofreefood.CompareTo(rhs.Rathernosponsorandnofreefood);
}
);
break;
case "Attendedvistafaironly":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Attendedvistafaironly.CompareTo(rhs.Attendedvistafaironly);
}
);
break;
case "Attendedvistafairandcc":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Attendedvistafairandcc.CompareTo(rhs.Attendedvistafairandcc);
}
);
break;
case "Attendedcconly":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Attendedcconly.CompareTo(rhs.Attendedcconly);
}
);
break;
case "Bestpartofevent":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Bestpartofevent.CompareTo(rhs.Bestpartofevent);
}
);
break;
case "Whatwouldyouchange":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Whatwouldyouchange.CompareTo(rhs.Whatwouldyouchange);
}
);
break;
case "Notsatisfiedwhy":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Notsatisfiedwhy.CompareTo(rhs.Notsatisfiedwhy);
}
);
break;
case "Whatfoothillclassestoadd":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Whatfoothillclassestoadd.CompareTo(rhs.Whatfoothillclassestoadd);
}
);
break;
case "Interesteinlongtermplanning":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinlongtermplanning.CompareTo(rhs.Interesteinlongtermplanning);
}
);
break;
case "Interesteinwebbackend":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinwebbackend.CompareTo(rhs.Interesteinwebbackend);
}
);
break;
case "Interestedinwebfrontend":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interestedinwebfrontend.CompareTo(rhs.Interestedinwebfrontend);
}
);
break;
case "Interesteinlongsessionreviewpanel":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinlongsessionreviewpanel.CompareTo(rhs.Interesteinlongsessionreviewpanel);
}
);
break;
case "Interesteincontributorsolicitation":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteincontributorsolicitation.CompareTo(rhs.Interesteincontributorsolicitation);
}
);
break;
case "Interesteinbeingcontributor":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinbeingcontributor.CompareTo(rhs.Interesteinbeingcontributor);
}
);
break;
case "Interesteinbeforeevent":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinbeforeevent.CompareTo(rhs.Interesteinbeforeevent);
}
);
break;
case "Interesteindayofevent":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteindayofevent.CompareTo(rhs.Interesteindayofevent);
}
);
break;
case "Interesteineventteardown":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteineventteardown.CompareTo(rhs.Interesteineventteardown);
}
);
break;
case "Interesteinafterevent":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Interesteinafterevent.CompareTo(rhs.Interesteinafterevent);
}
);
break;
case "Forvolunteeringbestwaytocontactemail":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Forvolunteeringbestwaytocontactemail.CompareTo(rhs.Forvolunteeringbestwaytocontactemail);
}
);
break;
case "Forvolunteeringbestwaytocontactphone":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Forvolunteeringbestwaytocontactphone.CompareTo(rhs.Forvolunteeringbestwaytocontactphone);
}
);
break;
case "Datesubmitted":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Datesubmitted.CompareTo(rhs.Datesubmitted);
}
);
break;
case "Dateupdated":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Dateupdated.CompareTo(rhs.Dateupdated);
}
);
break;
case "Id":
comparison = new Comparison<DataObjectCodeCampEvals>(
delegate(DataObjectCodeCampEvals lhs, DataObjectCodeCampEvals rhs)
{
return lhs.Id.CompareTo(rhs.Id);
}
);
break;
}
if (comparison != null)
{
DataTemplateODSList.Sort(comparison);
if (sortData.ToLower().EndsWith("desc"))
{
DataTemplateODSList.Reverse();
}
}
return DataTemplateODSList;
}
public List<DataObjectCodeCampEvals> GetByPKID(Guid searchattendeepkid)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
List<DataObjectCodeCampEvals> DataTemplateODSList = new List<DataObjectCodeCampEvals>();
SqlDataReader reader = null;
string sqlSelectString = "SELECT AttendeePKID,MetExpectations,PlanToAttendAgain,EnjoyedFreeFood,SessionsVariedEnough,EnoughSessionsAtMyLevel,FoothillGoodVenue,WishToldMoreFriends,EventWellPlanned,WirelessAccessImportant,WiredAccessImportant,LikeReceivingUpdateByEmail,LikeReceivingUpdateByByRSSFeed,RatherNoSponsorAndNoFreeFood,AttendedVistaFairOnly,AttendedVistaFairAndCC,AttendedCCOnly,BestPartOfEvent,WhatWouldYouChange,NotSatisfiedWhy,WhatFoothillClassesToAdd,InteresteInLongTermPlanning,InteresteInWebBackEnd,InterestedInWebFrontEnd,InteresteInLongSessionReviewPanel,InteresteInContributorSolicitation,InteresteInBeingContributor,InteresteInBeforeEvent,InteresteInDayOfEvent,InteresteInEventTearDown,InteresteInAfterEvent,ForVolunteeringBestWayToContactEmail,ForVolunteeringBestWayToContactPhone,DateSubmitted,DateUpdated,id FROM [dbo].[CodeCampEvals] WHERE attendeePKID = @searchattendeepkid ";
SqlCommand cmd = new SqlCommand(sqlSelectString, conn);
cmd.Parameters.Add("@searchattendeepkid", SqlDbType.UniqueIdentifier).Value = searchattendeepkid; ;
reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
Guid attendeepkid = reader.IsDBNull(0) ? Guid.NewGuid() : reader.GetGuid(0);
int metexpectations = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);
int plantoattendagain = reader.IsDBNull(2) ? 0 : reader.GetInt32(2);
int enjoyedfreefood = reader.IsDBNull(3) ? 0 : reader.GetInt32(3);
int sessionsvariedenough = reader.IsDBNull(4) ? 0 : reader.GetInt32(4);
int enoughsessionsatmylevel = reader.IsDBNull(5) ? 0 : reader.GetInt32(5);
int foothillgoodvenue = reader.IsDBNull(6) ? 0 : reader.GetInt32(6);
int wishtoldmorefriends = reader.IsDBNull(7) ? 0 : reader.GetInt32(7);
int eventwellplanned = reader.IsDBNull(8) ? 0 : reader.GetInt32(8);
int wirelessaccessimportant = reader.IsDBNull(9) ? 0 : reader.GetInt32(9);
int wiredaccessimportant = reader.IsDBNull(10) ? 0 : reader.GetInt32(10);
int likereceivingupdatebyemail = reader.IsDBNull(11) ? 0 : reader.GetInt32(11);
int likereceivingupdatebybyrssfeed = reader.IsDBNull(12) ? 0 : reader.GetInt32(12);
int rathernosponsorandnofreefood = reader.IsDBNull(13) ? 0 : reader.GetInt32(13);
bool attendedvistafaironly = reader.IsDBNull(14) ? false : reader.GetBoolean(14);
bool attendedvistafairandcc = reader.IsDBNull(15) ? false : reader.GetBoolean(15);
bool attendedcconly = reader.IsDBNull(16) ? false : reader.GetBoolean(16);
string bestpartofevent = reader.IsDBNull(17) ? "" : reader.GetString(17);
string whatwouldyouchange = reader.IsDBNull(18) ? "" : reader.GetString(18);
string notsatisfiedwhy = reader.IsDBNull(19) ? "" : reader.GetString(19);
string whatfoothillclassestoadd = reader.IsDBNull(20) ? "" : reader.GetString(20);
bool interesteinlongtermplanning = reader.IsDBNull(21) ? false : reader.GetBoolean(21);
bool interesteinwebbackend = reader.IsDBNull(22) ? false : reader.GetBoolean(22);
bool interestedinwebfrontend = reader.IsDBNull(23) ? false : reader.GetBoolean(23);
bool interesteinlongsessionreviewpanel = reader.IsDBNull(24) ? false : reader.GetBoolean(24);
bool interesteincontributorsolicitation = reader.IsDBNull(25) ? false : reader.GetBoolean(25);
bool interesteinbeingcontributor = reader.IsDBNull(26) ? false : reader.GetBoolean(26);
bool interesteinbeforeevent = reader.IsDBNull(27) ? false : reader.GetBoolean(27);
bool interesteindayofevent = reader.IsDBNull(28) ? false : reader.GetBoolean(28);
bool interesteineventteardown = reader.IsDBNull(29) ? false : reader.GetBoolean(29);
bool interesteinafterevent = reader.IsDBNull(30) ? false : reader.GetBoolean(30);
string forvolunteeringbestwaytocontactemail = reader.IsDBNull(31) ? "" : reader.GetString(31);
string forvolunteeringbestwaytocontactphone = reader.IsDBNull(32) ? "" : reader.GetString(32);
DateTime datesubmitted = reader.IsDBNull(33) ? DateTime.Now : reader.GetDateTime(33);
DateTime dateupdated = reader.IsDBNull(34) ? DateTime.Now : reader.GetDateTime(34);
int id = reader.IsDBNull(35) ? 0 : reader.GetInt32(35);
DataObjectCodeCampEvals td = new DataObjectCodeCampEvals(attendeepkid, metexpectations, plantoattendagain, enjoyedfreefood, sessionsvariedenough, enoughsessionsatmylevel, foothillgoodvenue, wishtoldmorefriends, eventwellplanned, wirelessaccessimportant, wiredaccessimportant, likereceivingupdatebyemail, likereceivingupdatebybyrssfeed, rathernosponsorandnofreefood, attendedvistafaironly, attendedvistafairandcc, attendedcconly, bestpartofevent, whatwouldyouchange, notsatisfiedwhy, whatfoothillclassestoadd, interesteinlongtermplanning, interesteinwebbackend, interestedinwebfrontend, interesteinlongsessionreviewpanel, interesteincontributorsolicitation, interesteinbeingcontributor, interesteinbeforeevent, interesteindayofevent, interesteineventteardown, interesteinafterevent, forvolunteeringbestwaytocontactemail, forvolunteeringbestwaytocontactphone, datesubmitted, dateupdated, id);
DataTemplateODSList.Add(td);
}
}
finally
{
if (reader != null) reader.Close();
}
conn.Close();
return DataTemplateODSList;
}
