/// <summary>
/// Converts the value of the current WeatherEvent instance
/// to its equivalent string representation.
/// </summary>
/// <returns>A string representation of a WeatherEvent.</returns>
public override string ToString()
{
return(EventID.ToString() + ToStringSeparator +
Type.ToString() + ToStringSeparator +
Severity.ToString() + ToStringSeparator +
StartTime.ToString() + ToStringSeparator +
EndTime.ToString() + ToStringSeparator +
TimeZone.ToString() + ToStringSeparator +
AirportCode.ToString() + ToStringSeparator +
LocationLatitude.ToString() + ToStringSeparator +
LocationLongitude.ToString() + ToStringSeparator +
City.ToString() + ToStringSeparator +
County.ToString() + ToStringSeparator +
State.ToString() + ToStringSeparator +
ZipCode.ToString());
}
public void AddStudentToDb()
{
ad.AddNewStudent(FirstName, LastName, AddressLine1, AddressLine2, City, County.ToString(), Email, Phone, CourseId);
}
/// <summary>
/// 身份证号码。
/// </summary>
/// <returns></returns>
public override string ToString()
{
return(string.Concat(ProvinceCode.ToString("00"), CityCode.ToString("00"), County.ToString("00"), Birthday.ToString("yyyyMMdd"), SerialNumber.ToString("000"), CheckCode));
}
public void EditStudent()
{
edata.EditStu(Email, Phone, Address1, Address2, City, County.ToString(), Level.ToString(), StudentNo);
}
public void AddStudent()
{
data.AddStu(FirstName, LastName, Email, Phone, Address1, Address2, City, County.ToString(), Level.ToString(), Course.ToString(), StudentNo);
}
// divide list up into counties and add to database document
public void AddList(List <AlteredRecord> list, DateTime date) // date parameter is were updated to
{
DateTime lastDate = date;
// find date the update file is updated to
foreach (AlteredRecord ar in list)
{
// get the last date in the list so know were database has been updated to
if (ar.SoldOn > lastDate)
{
lastDate = ar.SoldOn;
}
}
// set date updated too as last date in list
WorkerRole.dateTimeUpdatedTo = lastDate;
// loop through every county 1 at a time
for (County co = County.Kerry; co <= County.Clare; co++)
{
if (co == County.Dublin) // Dublin is too large and needs to be uploaded to database in months
{
foreach (AlteredRecord ar in list)
{
if (ar.County.Equals(co.ToString()))
{
templist.Add(ar);
}
}
// only need to update around date of last update, so:
int day = date.Day;
int month = date.Month;
string year = date.Year.ToString();
foreach (AlteredRecord ar in templist)
{
if (ar.SoldOn.Month == month)
{
templist1.Add(ar);
}
}
// create database connection with list and county
DatabaseConnect dba = new DatabaseConnect(co.ToString(), templist1);
// update the document with new data
dba.ModifyDocumentDublin(year, month);
// if any data for next month deal with it
if (lastDate.Month > month)
{
foreach (AlteredRecord ar in templist) // if any data for next month is in the list
{
if (ar.SoldOn.Month == lastDate.Month)
{
templist3.Add(ar);
}
}
// create database connection with list and county
DatabaseConnect dbd = new DatabaseConnect(co.ToString(), templist3);
// update the document with new data
dbd.ModifyDocumentDublin(year, lastDate.Month);
}
// clear the lists
templist.Clear();
templist1.Clear();
templist2.Clear();
templist3.Clear();
}
else // rest of Ireland
{
foreach (AlteredRecord ar in list)
{
if (ar.County.Equals(co.ToString()))
{
templist.Add(ar);
}
}
foreach (AlteredRecord ar in templist) // divide in 2
{
if (ar.SoldOn.Month == 1 || ar.SoldOn.Month == 2 || ar.SoldOn.Month == 3 || ar.SoldOn.Month == 4 ||
ar.SoldOn.Month == 5 || ar.SoldOn.Month == 6)
{
templist1.Add(ar);
}
else
{
templist2.Add(ar);
}
}
// depending on date send appropriate list to database
int day = date.Day;
int month = date.Month;
string year = date.Year.ToString();
if (month >= 1 && month <= 6) // first 6 months update group A
{
DatabaseConnect db = new DatabaseConnect(co.ToString(), templist1);
db.ModifyDocumentBoggers(year, 'A');
}
else // update last 6 months in group B
{
DatabaseConnect db2 = new DatabaseConnect(co.ToString(), templist2);
db2.ModifyDocumentBoggers(year, 'B');
}
// clear temp lists
templist.Clear();
templist1.Clear();
templist2.Clear();
}
}
}
public override string ToString()
{
return(Province?.ToString() + Prefecture?.ToString() + County?.ToString()
+ Township?.ToString() + Village?.ToString() + ResidentialGroup?.ToString()
+ Detail);
}
private void RunAsync()
{
// check if new documents need to be created
// documents created on first of every month for dublin and 1st of january and july for rest of country
if (DateTime.Now.Day == 1)
{
Trace.TraceInformation("Worker role running on first of month, creating new documents");
string year = DateTime.Now.Year.ToString() + "_";
List <AlteredRecord> list = new List <AlteredRecord>();
if (DateTime.Now.Month == 1)
{
for (County co = County.Kerry; co <= County.Clare; co++)
{
if (co == County.Dublin)
{
DatabaseConnect db = new DatabaseConnect(co.ToString(), list);
db.CreateDocument(year + "1");
}
else
{
DatabaseConnect db = new DatabaseConnect(co.ToString(), list);
db.CreateDocument(year + "A");
}
}
}
else if (DateTime.Now.Month == 2)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "2");
}
else if (DateTime.Now.Month == 3)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "3");
}
else if (DateTime.Now.Month == 4)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "4");
}
else if (DateTime.Now.Month == 5)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "5");
}
else if (DateTime.Now.Month == 6)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "6");
}
else if (DateTime.Now.Month == 7)
{
for (County co = County.Kerry; co <= County.Clare; co++)
{
if (co == County.Dublin)
{
DatabaseConnect db = new DatabaseConnect(co.ToString(), list);
db.CreateDocument(year + "7");
}
else
{
DatabaseConnect db = new DatabaseConnect(co.ToString(), list);
db.CreateDocument(year + "B");
}
}
}
else if (DateTime.Now.Month == 8)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "8");
}
else if (DateTime.Now.Month == 9)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "9");
}
else if (DateTime.Now.Month == 10)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "10");
}
else if (DateTime.Now.Month == 11)
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "11");
}
else
{
DatabaseConnect db = new DatabaseConnect("Dublin", list);
db.CreateDocument(year + "12");
}
}
// get dates from database document and check them against the websites dates to see if update available
UpdateDates update = DatabaseDates.ReadDatesDocument().Result;
dateTimeLastUpdated = update.lastUpdate;
dateTimeUpdatedTo = update.updatedTo;
if (UpdateAvailable(update.lastUpdate))
{
// the main tasks of an update
MainTasks(dateTimeUpdatedTo.Year.ToString());
}
}
public override string ToString()
{
return($"{Province.ToString()}{City.ToString()}{County.ToString()}{Town.ToString()}{Detail}");
}
