public static int GetSQLTourArrayList(List <Tour> sqlTours)
{
string strErrorMsg;
//int version = -1;
DateTime dtBeginDateTime;
DateTime dtEndDateTime;
int OrdCol;
Guid tourguid;
string tourtitle;
string workflowstatuscode;
DateTime toursubmitteddatetime;
DateTime tourapproveddatetime;
DateTime tourrejecteddatetime;
string tourapprovedrejectedbyname;
string tourdescription;
string tourattributionandcredits;
string authorname;
string authoremailaddress;
string authorurl;
string authorsecondaryemailaddress;
string authorcontactphonenumber;
string authorcontacttext;
string organizationname;
string organizationurl;
string tourkeywordlist;
string tourithlist;
string tourastroobjectlist;
string tourexplicittourlinklist;
int lengthinsecs;
double averageRating;
strErrorMsg = "";
SqlConnection myConnection5 = GetConnectionWWTTours();
dtBeginDateTime = Convert.ToDateTime("1/1/1900");
dtEndDateTime = Convert.ToDateTime("1/1/2100");
try
{
myConnection5.Open();
SqlCommand Cmd = null;
Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandTimeout = 20;
Cmd.Connection = myConnection5;
Cmd.CommandText = "spGetWWTToursForDateRange";
SqlParameter CustParm = new SqlParameter("@pBeginDateTime", SqlDbType.DateTime);
CustParm.Value = dtBeginDateTime;
Cmd.Parameters.Add(CustParm);
SqlParameter CustParm2 = new SqlParameter("@pEndDateTime", SqlDbType.DateTime);
CustParm2.Value = dtEndDateTime;
Cmd.Parameters.Add(CustParm2);
System.Data.SqlClient.SqlDataReader MySQLReader;
MySQLReader = Cmd.ExecuteReader();
while (MySQLReader.Read())
{
OrdCol = MySQLReader.GetOrdinal("TourGUID");
tourguid = MySQLReader.GetGuid(OrdCol);
OrdCol = MySQLReader.GetOrdinal("TourTitle");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourtitle = MySQLReader.GetString(OrdCol);
}
else
{
tourtitle = null;
}
OrdCol = MySQLReader.GetOrdinal("WorkFlowStatusCode");
if (MySQLReader[OrdCol] != DBNull.Value)
{
workflowstatuscode = MySQLReader.GetString(OrdCol);
}
else
{
workflowstatuscode = null;
}
OrdCol = MySQLReader.GetOrdinal("TourSubmittedDateTime");
if (MySQLReader[OrdCol] != DBNull.Value)
{
toursubmitteddatetime = Convert.ToDateTime(MySQLReader.GetSqlDateTime(OrdCol).ToString());
}
else
{
toursubmitteddatetime = DateTime.MinValue;
}
OrdCol = MySQLReader.GetOrdinal("TourApprovedDateTime");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourapproveddatetime = Convert.ToDateTime(MySQLReader.GetSqlDateTime(OrdCol).ToString());
}
else
{
tourapproveddatetime = DateTime.MinValue;
}
OrdCol = MySQLReader.GetOrdinal("TourRejectedDateTime");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourrejecteddatetime = Convert.ToDateTime(MySQLReader.GetSqlDateTime(OrdCol).ToString());
}
else
{
tourrejecteddatetime = DateTime.MinValue;
}
OrdCol = MySQLReader.GetOrdinal("TourApprovedRejectedByName");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourapprovedrejectedbyname = MySQLReader.GetString(OrdCol);
}
else
{
tourapprovedrejectedbyname = null;
}
OrdCol = MySQLReader.GetOrdinal("TourDescription");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourdescription = MySQLReader.GetString(OrdCol);
}
else
{
tourdescription = null;
}
OrdCol = MySQLReader.GetOrdinal("TourAttributionAndCredits");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourattributionandcredits = MySQLReader.GetString(OrdCol);
}
else
{
tourattributionandcredits = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorName");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authorname = MySQLReader.GetString(OrdCol);
}
else
{
authorname = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorEmailAddress");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authoremailaddress = MySQLReader.GetString(OrdCol);
}
else
{
authoremailaddress = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorURL");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authorurl = MySQLReader.GetString(OrdCol);
}
else
{
authorurl = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorSecondaryEmailAddress");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authorsecondaryemailaddress = MySQLReader.GetString(OrdCol);
}
else
{
authorsecondaryemailaddress = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorContactPhoneNumber");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authorcontactphonenumber = MySQLReader.GetString(OrdCol);
}
else
{
authorcontactphonenumber = null;
}
OrdCol = MySQLReader.GetOrdinal("AuthorContactText");
if (MySQLReader[OrdCol] != DBNull.Value)
{
authorcontacttext = MySQLReader.GetString(OrdCol);
}
else
{
authorcontacttext = null;
}
OrdCol = MySQLReader.GetOrdinal("OrganizationName");
if (MySQLReader[OrdCol] != DBNull.Value)
{
organizationname = MySQLReader.GetString(OrdCol);
}
else
{
organizationname = null;
}
OrdCol = MySQLReader.GetOrdinal("OrganizationURL");
if (MySQLReader[OrdCol] != DBNull.Value)
{
organizationurl = MySQLReader.GetString(OrdCol);
}
else
{
organizationurl = null;
}
OrdCol = MySQLReader.GetOrdinal("TourKeywordList");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourkeywordlist = MySQLReader.GetString(OrdCol);
}
else
{
tourkeywordlist = null;
}
OrdCol = MySQLReader.GetOrdinal("TourITHList");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourithlist = MySQLReader.GetString(OrdCol);
}
else
{
tourithlist = null;
}
OrdCol = MySQLReader.GetOrdinal("TourAstroObjectList");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourastroobjectlist = MySQLReader.GetString(OrdCol);
}
else
{
tourastroobjectlist = null;
}
OrdCol = MySQLReader.GetOrdinal("TourExplicitTourLinkList");
if (MySQLReader[OrdCol] != DBNull.Value)
{
tourexplicittourlinklist = MySQLReader.GetString(OrdCol);
}
else
{
tourexplicittourlinklist = null;
}
OrdCol = MySQLReader.GetOrdinal("LengthInSecs");
if (MySQLReader[OrdCol] != DBNull.Value)
{
lengthinsecs = MySQLReader.GetInt32(OrdCol);
}
else
{
lengthinsecs = -1;
}
OrdCol = MySQLReader.GetOrdinal("AverageRating");
if (MySQLReader[OrdCol] != DBNull.Value)
{
averageRating = MySQLReader.GetDouble(OrdCol);
}
else
{
averageRating = 0;
}
//OrdCol = MySQLReader.GetOrdinal("TourXML");
//if (MySQLReader[OrdCol] != DBNull.Value)
//{
// tourxml = MySQLReader.GetString(OrdCol);
//}
//else
//{
// tourxml = null;
//}
Tour loadTour = new Tour();
loadTour.TourGuid = tourguid;
loadTour.TourTitle = tourtitle;
if (workflowstatuscode != null)
{
loadTour.WorkFlowStatusCode = workflowstatuscode;
}
if (toursubmitteddatetime != null)
{
loadTour.TourSubmittedDateTime = toursubmitteddatetime;
}
if (tourapproveddatetime != null)
{
loadTour.TourApprovedDateTime = tourapproveddatetime;
}
if (tourrejecteddatetime != null)
{
loadTour.TourRejectedDateTime = tourrejecteddatetime;
}
//loadTour.TourApprovedRejectedByName = tourapprovedrejectedbyname;
loadTour.TourDescription = tourdescription;
loadTour.TourAttributionAndCredits = tourattributionandcredits;
loadTour.AuthorName = authorname;
loadTour.AuthorEmailAddress = authoremailaddress;
loadTour.AuthorURL = authorurl;
loadTour.AuthorSecondaryEmailAddress = authorsecondaryemailaddress;
loadTour.AuthorContactPhoneNumber = authorcontactphonenumber;
loadTour.AuthorContactText = authorcontacttext;
loadTour.OrganizationName = organizationname;
loadTour.OrganizationURL = organizationurl;
loadTour.TourKeywordList = tourkeywordlist;
loadTour.TourITHList = tourithlist;
loadTour.TourAstroObjectList = tourastroobjectlist;
loadTour.TourExplicitTourLinkList = tourexplicittourlinklist;
loadTour.LengthInSecs = lengthinsecs;
loadTour.AverageRating = averageRating;
//loadTour.TourXML = tourxml;
sqlTours.Add(loadTour);
}
}
catch (InvalidCastException)
{ }
catch (Exception ex)
{
//throw ex.GetBaseException();
strErrorMsg = ex.Message;
return(-1);
}
finally
{
if (myConnection5.State == ConnectionState.Open)
{
myConnection5.Close();
}
}
return(0);
}
