public PlayerSummaryPresentationObject(Guid id, string name, int jerseyNumber, int height, int weight, Year year)
{
this.Id = id;
this.Name = name;
this.JerseyNumber = jerseyNumber;
this.Height = height;
this.Weight = weight;
this.Year = year;
}
public async Task UpdateCourseRelationships(AssistDbContext db, College userSelectedCollege, Year year)
{
// Our datasets are relatively small so load up everything we plan to touch into memory
var otherColleges = db.Colleges.Where(c => c.CollegeId != userSelectedCollege.CollegeId).ToList();
var dbCourseSets = db.CourseSets.Include("College").Include("Year").ToList();
var dbCourseRelationships = db.CourseRelationships.Include("ToCourseSet").Include("FromCourseSet").ToList();
var dbKnownRequests = db.KnownRequests.ToList();
foreach (var otherCollege in otherColleges)
//foreach (var toCollege in new College[] { toColleges[0] }) //DEBUG
{
await UpdateCollegeYearBundleRelationships(db, userSelectedCollege, otherCollege, year, dbCourseSets, dbCourseRelationships, dbKnownRequests);
await UpdateCollegeYearBundleRelationships(db, otherCollege, userSelectedCollege, year, dbCourseSets, dbCourseRelationships, dbKnownRequests);
}
}
public override void ExitYear(Year year)
{
}
public override string ToString()
{
return(Day.ToString() + "/" + Month.ToString() + "/" + Year.ToString() + (IsLeapYear ? "N" : ""));
}
public override int GetHashCode()
{
return(Year.GetHashCode() + Month.GetHashCode());
}
public void Valid_leap_year()
{
Assert.That(Year.IsLeap(1996), Is.True);
}
public async Task <StylesViewModel> GetStyles(string makeName, string modelName, int year)
{
var result = await edmundsService.GetStyles(makeName, modelName, year);
Make make = (
from m in db.Makes
where m.Name == makeName
select new Make
{
Id = m.Id,
Name = m.Name,
Models = (
from mo in m.Models
where mo.Name == modelName
select new Model
{
Id = mo.Id,
Name = mo.Name,
Years = (
from y in mo.Years
where y.Years == year
select new Year
{
Id = y.Id,
Years = y.Years,
Styles = y.Styles
})
.ToList()
})
.ToList()
})
.ToList()
.FirstOrDefault();
if (make == null)
{
return(result);
}
Model model = make.Models.FirstOrDefault();
if (model == null)
{
return(result);
}
Year styleYear = model.Years.FirstOrDefault();
if (styleYear == null)
{
return(result);
}
result.Styles.AddRange(
from s in styleYear.Styles
select new StyleViewModel
{
Id = make.Id,
Make = make.Name,
Year = styleYear.Years,
Name = s.Name
});
return(result);
}
public string GetHisDataTableName(string year, string month, string machineTypeId)
{
return("HISDATA" + Year.ToString() + month + machineTypeId);
}
public string AddYear(double year)
{
string response = "";
CurtDevDataContext db = new CurtDevDataContext();
JavaScriptSerializer ser = new JavaScriptSerializer();
if (year > 0) {
// Make sure this year doesn't exist
int yCount = (from y in db.Years
where y.year1.Equals(year)
select y).Count<Year>();
if (yCount == 0) {
try {
// Add year
Year new_year = new Year {
year1 = year
};
db.Years.InsertOnSubmit(new_year);
db.SubmitChanges();
response = ser.Serialize(new_year);
} catch (Exception e) {
response = "[{\"error\":\"" + e.Message + "\"}]";
}
} else {
response = "[{\"error\":\"This year already exists\"}]";
}
}
return response;
}
public void Initialize()
{
if (role == Role.Player)
{
if (mode == Mode.Local)
{
year = Year.FirstYear;
season = Season.BeginningSeason;
page = Page.NewYearPlanningPage;
}
else
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.LANPage_Player;
}
}
else
{
if (mode == Mode.Local)
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.BlankPage;
}
else
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.LANPage_Admin;
}
}
GetSiblingPages();
}
static public Money in_the(this IEnumerable<IIncome> income_collected, Year year)
{
return income_collected.return_value_from_visiting_all_with(new AnnualIncomeVisitor(year));
}
public static Year CreateYear(int yearID, int year1)
{
Year year = new Year();
year.YearID = yearID;
year.Year1 = year1;
return year;
}
public void AddToYear(Year year)
{
base.AddObject("Year", year);
}
public void NotBeALeapYearIfItIsNotDivisibleBy4()
{
var year = new Year(2015);
Assert.That(year.IsLeap(), Is.False);
}
public Date(Day day, Month month, Year year)
{
Day = day;
Month = month;
Year = year;
}
public override string ToString()
{
return("Name:" + Name.ToString() + " " + "Binding:" + Binding.ToString() + " " + "Year:" + Year.ToString() + " " + "Amount author:" + AmountAuthor.ToString() + " " + "Format:" + Format.ToString() + " " + "Amount page:" + AmountPage.ToString() + ";" + Environment.NewLine);
}
public async void ReadMyXML()
{
Uri uriYears = ToAbsoluteUri("xmlyears.aspx");
App app = (App)Application.Current;
if (app.BackgroundDownloader != null)
{
if (app.BackgroundDownloader.Status == TaskStatus.RanToCompletion)
{
bool b = await app.BackgroundDownloader;
if (b)
{
try
{
var y = Windows.Storage.ApplicationData.Current.LocalFolder;
string subdir = BasicFileDownloader.UriToSubDirectory(uriYears);
string fname = BasicFileDownloader.UriToFilename(uriYears);
string backupfname = BasicFileDownloader.UriToFilename(uriYears) + ".bak";
var sf = await y.GetFileAsync(subdir + "\\" + fname);
await sf.DeleteAsync();
sf = await y.GetFileAsync(subdir + "\\" + backupfname);
await sf.RenameAsync(fname);
}
catch { }
}
}
}
Years = new Years();
Progress<int> progress = new Progress<int>((p) => { ProgressPercent = p; });
BasicFileDownloader bidl = new BasicFileDownloader(uriYears);
IRandomAccessStream s = await bidl.DownloadAsync(progress);
XmlReaderSettings settings = new XmlReaderSettings();
settings.ConformanceLevel = ConformanceLevel.Fragment;
settings.IgnoreWhitespace = true;
settings.IgnoreComments = true;
settings.Async = true;
XmlReader reader = XmlReader.Create(s.AsStream(), settings);
reader.ReadStartElement("Model");
reader.ReadStartElement("Years");
Count = 0;
while (reader.IsStartElement())
{
string year = reader[0];
string str = reader[1];
str = str.Replace("_s.jpg", "");
if (!String.IsNullOrEmpty(str))
{
uint count = 0;
if (uint.TryParse(reader[2], out count))
{
Year y = new Year(year, str, count);
if (FirstYear == null)
FirstYear = y;
else
Years.Add(y);
Count += y.Count;
}
}
await reader.ReadAsync();
}
s.Dispose();
BasicFileDownloader bfdlForce = new BasicFileDownloader(uriYears);
app.BackgroundDownloader = bfdlForce.DownloadAsyncForce(null);
}
/// <summary>
/// Converts the date represented by this instance to an equivalent 32-bit signed integer.
/// </summary>
/// <returns>n 32-bit signed integer equivalent to the date represented by this instance.</returns>
public int ToInt()
{
return(int.Parse(Year.ToString() + Month.ToString().PadLeft(2, '0') + Day.ToString().PadLeft(2, '0')));
}
public void Initialize()
{
if (role == Role.Player)
{
if (mode == Mode.Local)
{
year = Year.FirstYear;
season = Season.BeginningSeason;
page = Page.NewYearPlanningPage;
//设定用户名称与初始值
int useNum = (App.Current as App).accessDB.GetUserNumber(name);
if (useNum == 0)
{
(App.Current as App).accessDB.AddNewUserList(name, "", "");
useNum = (App.Current as App).accessDB.GetUserNumber(name);
}
(App.Current as App).accessDB.SetIniValue(useNum, (App.Current as App).accessDB.GetDefaultIniValue(useNum));
}
else
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.LANPage_Player;
}
}
else
{
if (mode == Mode.Local)
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.SetIniPage;
//设定用户名称与初始值
int useNum = (App.Current as App).accessDB.GetUserNumber(name);
if (useNum == 0)
{
(App.Current as App).accessDB.AddNewUserList(name, "", "");
useNum = (App.Current as App).accessDB.GetUserNumber(name);
}
}
else
{
year = Year.BeginningYear;
season = Season.Season_END;
page = Page.LANPage_Admin;
}
}
GetSiblingPages();
}
public void Turn_of_the_20th_century_is_not_a_leap_year()
{
Assert.That(Year.IsLeap(1900), Is.False);
}
public void Update()
{
if (role == Role.Player)
{
if (mode == Mode.Local)
{
page += 1;
switch (page)
{
case Page.BeginningSeason_END:
season += 1;
page = Page.ManageShortTermLoanPage;
GetSiblingPages();
break;
case Page.Season_END:
season += 1;
page = (season < Season.EndingSeason) ? Page.ManageShortTermLoanPage : Page.ExploitMarketPage;
GetSiblingPages();
break;
case Page.EndingSeason_END:
year += 1;
season = Season.BeginningSeason;
page = Page.NewYearPlanningPage;
GetSiblingPages();
break;
}
}
//else
//{
// year = Year.BeginningYear;
// season = Season.Season_END;
// page = Page.LANPage_Player;
//}
}
else
{
if (mode == Mode.Local)
{
page = Page.BlankPage;
App.Current.Shutdown();
}
//else
//{
// year = Year.BeginningYear;
// season = Season.Season_END;
// page = Page.LANPage_Admin;
//}
}
// Call MainWindow to complete
Update_Event();
}
public void NotBeALeapYearIfItIsDivisibleBy100AndNotDivisibleBy400()
{
var year = new Year(4100);
Assert.That(year.IsLeap(), Is.False);
}
public static FullVehicle CarryOverPart(int vehicleID = 0, int partID = 0)
{
try {
CurtDevDataContext db = new CurtDevDataContext();
CarryOverInfo latest = GetLatestVehiclePart(vehicleID, partID);
VehiclePart latestvp = db.VehicleParts.Where(x => x.vehicleID == vehicleID).Where(x => x.partID == partID).First<VehiclePart>();
List<VehiclePartAttribute> vpas = db.VehiclePartAttributes.Where(x => x.vPartID == latestvp.vPartID).ToList<VehiclePartAttribute>();
List<VehiclePartAttribute> newvpas = new List<VehiclePartAttribute>();
double year = latest.year + 1;
int yearID = 0;
try {
yearID = db.Years.Where(x => x.year1 == year).Select(x => x.yearID).First();
} catch {
Year y = new Year {
year1 = year
};
db.Years.InsertOnSubmit(y);
db.SubmitChanges();
yearID = y.yearID;
};
try {
YearMake ym = db.YearMakes.Where(x => x.yearID.Equals(yearID)).Where(x => x.makeID.Equals(latest.makeID)).First<YearMake>();
} catch {
YearMake ym = new YearMake {
yearID = yearID,
makeID = latest.makeID
};
db.YearMakes.InsertOnSubmit(ym);
db.SubmitChanges();
}
int vID = Vehicle.GetVehicleID(yearID, latest.makeID, latest.modelID, latest.styleID);
if (vID == 0) {
Vehicles v = new Vehicles {
yearID = yearID,
makeID = latest.makeID,
modelID = latest.modelID,
styleID = latest.styleID,
dateAdded = DateTime.Now
};
db.Vehicles.InsertOnSubmit(v);
db.SubmitChanges();
vID = v.vehicleID;
}
List<VehiclePart> parts = new List<VehiclePart>();
foreach (int partnum in latest.partids) {
if (db.VehicleParts.Where(x => x.partID.Equals(partnum)).Where(x => x.vehicleID.Equals(vID)).Count() == 0) {
VehiclePart vp = new VehiclePart {
vehicleID = vID,
partID = partnum,
drilling = latestvp.drilling,
exposed = latestvp.exposed,
installTime = latestvp.installTime
};
parts.Add(vp);
}
}
db.VehicleParts.InsertAllOnSubmit(parts);
db.SubmitChanges();
foreach (VehiclePart part in parts) {
newvpas = new List<VehiclePartAttribute>();
foreach (VehiclePartAttribute vpa in vpas) {
VehiclePartAttribute newvpa = new VehiclePartAttribute {
vPartID = part.vPartID,
field = vpa.field,
value = vpa.value
};
newvpas.Add(newvpa);
};
db.VehiclePartAttributes.InsertAllOnSubmit(newvpas);
db.SubmitChanges();
};
UpdatePart(partID);
return Vehicle.GetFullVehicle(vID);
} catch (Exception e) {
throw new Exception(e.Message);
}
}
private bool IsFormComplete()
{
if ((!string.IsNullOrEmpty(Title)) && (!string.IsNullOrEmpty(Director)) && (!string.IsNullOrEmpty(Year)) && (!string.IsNullOrEmpty(Description)) && IsFileSelected())
{
// Validate form values
if (Year.Contains("-"))
{
SetMessage("Year is invalid.", ERROR_COLOR);
return(false);
}
if (!Int32.TryParse(Year, out _yearInt))
{
SetMessage("Year is invalid.", ERROR_COLOR);
return(false);
}
if ((_yearInt < 1888) || (_yearInt > DateTime.Now.Year))
{
SetMessage("We only rent movies that are currently released. Please check the date.", ERROR_COLOR);
return(false);
}
if (Price.Contains("-"))
{
SetMessage("Price is invalid.", ERROR_COLOR);
return(false);
}
if (!(Price.Length == 4))
{
SetMessage("Price must be in format \"x.xx\".", ERROR_COLOR);
return(false);
}
if (!Price.Contains(".") || !Price.Substring(1, 1).Contains("."))
{
SetMessage("Price must be in format \"x.xx\".", ERROR_COLOR);
return(false);
}
if (!Decimal.TryParse(Price, out _priceDecimal))
{
SetMessage("Price is invalid.", ERROR_COLOR);
return(false);
}
if (!(_priceDecimal > 0))
{
SetMessage("Price is invalid.", ERROR_COLOR);
return(false);
}
return(true);
}
else
{
SetMessage(ERROR, ERROR_COLOR);
return(false);
}
}
void Awake()
{
if(LevelSerializer.IsDeserializing)
{
return;
}
//Will use playerprefs here to sort this out but for testing purposes...
currentDate = new DateTime(2012,10,18,6,0,0);
Time.timeScale = timeSpeed;
//month = currentDate.Month;
currentDay = new Day();
currentMonth = new Month();
currentYear = new Year();
currentHour = new Hour(currentDate.Hour);
currentMinute = new Minute(currentDate.Minute);
currentDay.day = currentDate.Day;
currentYear.year = currentDate.Year;
currentMonth.month = currentDate.Month;
RandomMinute ();
//PerformMonthlyActions();
}
public override bool EnterYear(Year year) => true;
public void TestYearSort()
{
Year tempYear = new Year();
}
/// <summary>
/// Display time in the same manner as the Legends mode
/// </summary>
internal string LegendsTime()
{
const int SecPerDay = 1200;
const int DayPerMonth = 28;
long months = (TotalSeconds - 1) / SecPerDay / DayPerMonth;
if (Year == -1)
{
return("In a time before time");
}
else if (months == 0 && TotalSeconds == 0)
{
return(Year.ToString());
}
else if (months <= 0)
{
return("the early spring of " + Year.ToString());
}
else if (months == 1)
{
return("the midspring of " + Year.ToString());
}
else if (months == 2)
{
return("the late spring of " + Year.ToString());
}
else if (months == 3)
{
return("the early summer of " + Year.ToString());
}
else if (months == 4)
{
return("the midssummer of " + Year.ToString());
}
else if (months == 5)
{
return("the late summer of " + Year.ToString());
}
else if (months == 6)
{
return("the early autumn of " + Year.ToString());
}
else if (months == 7)
{
return("the midautumn of " + Year.ToString());
}
else if (months == 8)
{
return("the late autumn of " + Year.ToString());
}
else if (months == 9)
{
return("the early winter of " + Year.ToString());
}
else if (months == 10)
{
return("the midwinter of " + Year.ToString());
}
else if (months == 11)
{
return("the late spring of " + Year.ToString());
}
else
{
return(Year.ToString());
}
}
public void PrintDate()
{
Console.WriteLine(Day.ToString() + ' ' + GetMonthName(Month) + ' ' + Year.ToString() + " года");
}
// This was written from the point of view of being provided a From college and finding argreements From this college To all others
// However this was just to make dev easier, it can be reversed to
private async Task UpdateCollegeYearBundleRelationships(AssistDbContext db, College fromCollege, College toCollege, Year year
, List <CourseSet> dbCourseSets, List <CourseRelationship> dbCourseRelationships, List <KnownRequest> dbKnownRequests)
{
//Get this request from the DB
var url = RequestUrl(fromCollege.Shorthand, toCollege.Shorthand, year.Name);
var requestShell = new KnownRequest()
{
RequestTo = RequestSource.Main, Url = url
};
var knownRequest = dbKnownRequests.FirstOrDefault(r => r.LooseEquals(requestShell));
if (knownRequest == null)
{
db.KnownRequests.Add(requestShell);
dbKnownRequests.Add(requestShell);
knownRequest = requestShell;
}
else
{
// If we know this request returns nothing we can skip it
if (!knownRequest.IsValid() && knownRequest.UpToDateAsOf > DateTimeOffset.Now.AddDays(-14))
{
return;
}
}
string result;
using (var response = await client.GetAsync(url))
{
using (var content = response.Content)
{
result = await content.ReadAsStringAsync();
//result = DebugManager.RequestAhcToCpp1516(); //DEBUG
knownRequest.Update(result.Length);
db.SaveChanges();
}
}
// Technically this is an html doc but the bit we care about is always going to be between the only set of PRE tags
// so we'll skip the html doc overhead and do it old school
var dirtyList = result.Between("<PRE>", "</PRE>").Trim().Split(courseGroupSeperator);
var validCourseRelationships = new List <string>();
var multiCoursesRegex = RegexManager.MultiCourseRegex();
// Clean phase 1, remove single courses or non course data, add these to cleanList
foreach (var potentialCourseRela in dirtyList)
{
// Regex match on multiple courses and exclude our known empty comparison cases
if (multiCoursesRegex.IsMatch(potentialCourseRela) && !badRelationshipIndicators.Any(s => potentialCourseRela.ToLower().Contains(s)))
{
validCourseRelationships.Add(potentialCourseRela);
}
}
// Clean phase 2 + parse, all within each block of course relationships
// parse the ones which do into to/from courses
var courseRelaExtractedBucket = new List <CourseRelationship>();
foreach (var courseRelaRaw in validCourseRelationships)
//var courseRelaRaw = validCourseRelationships[0]; //DEBUG
{
using (StringReader reader = new StringReader(courseRelaRaw))
{
var toPart = "";
var fromPart = "";
string line;
while ((line = reader.ReadLine()) != null)
{
// if the line doesn't contain a |, skip (notes, department headers, etc. Never course data)
if (line.IndexOf('|') == -1)
{
continue;
}
// strip formatting
line = line.Replace("<B >", "").Replace("<B>", "").Replace("</B>", "");
line = line.Replace("<U >", "").Replace("<U>", "").Replace("</U>", "");
// break line into to/from parts (before/after the | ...order matters!)
var lineParts = line.Split("|", 2);
toPart += lineParts[0] + System.Environment.NewLine;
fromPart += lineParts[1] + System.Environment.NewLine;
}
toPart = toPart.Trim();
fromPart = fromPart.Trim();
if (toPart.Length == 0 || fromPart.Length == 0)
{
continue;
}
var toCourseSet = new CourseSet(toCollege, year, toPart);
var fromCourseSet = new CourseSet(fromCollege, year, fromPart);
// Courses stacked on one side and nothing on the other dont violate any of the rules thus far, weed them out here
if (toCourseSet.CommaDelimitedCourseNames.Length == 0 || fromCourseSet.CommaDelimitedCourseNames.Length == 0)
{
continue;
}
//Prevent building dupe courses
var toCourseSetDb = dbCourseSets.FirstOrDefault(c => c.Equals(toCourseSet));
var fromCourseSetDb = dbCourseSets.FirstOrDefault(c => c.Equals(fromCourseSet));
var now = DateTimeOffset.Now;
if (toCourseSetDb != null)
{
toCourseSetDb.UpToDateAsOf = now;
toCourseSet = toCourseSetDb;
}
else
{
dbCourseSets.Add(toCourseSet);
}
if (fromCourseSetDb != null)
{
fromCourseSetDb.UpToDateAsOf = now;
fromCourseSet = fromCourseSetDb;
}
else
{
dbCourseSets.Add(fromCourseSet);
}
var courseRela = new CourseRelationship()
{
ToCourseSet = toCourseSet, FromCourseSet = fromCourseSet, UpToDateAsOf = DateTimeOffset.Now
};
courseRelaExtractedBucket.Add(courseRela);
}
}
// Save after each toCollege has been processed. Ensures we walking into each save session on a clean slate.
db.SaveChanges();
// Whats currently in the DB for this college/college/year bucket. If no updates have happened RelaDb and RelaExtracted should be equivalent
var courseRelaDbBucket = dbCourseRelationships.Where(
cr => cr.FromCourseSet.College.CollegeId == fromCollege.CollegeId &&
cr.ToCourseSet.College.CollegeId == toCollege.CollegeId &&
cr.FromCourseSet.Year.YearId == year.YearId
).ToList();
var relasToAdd = courseRelaExtractedBucket.Except(courseRelaDbBucket).ToList();
var relasToRemove = courseRelaDbBucket.Except(courseRelaExtractedBucket).ToList();
foreach (var rela in relasToRemove)
{
dbCourseRelationships.Remove(rela);
db.CourseRelationships.Remove(rela);
}
db.SaveChanges();
foreach (var rela in relasToAdd)
{
dbCourseRelationships.Add(rela);
db.CourseRelationships.Add(rela);
}
db.SaveChanges();
}
private List <BaseSPDataModel> GetSchoolData(List <School> tListSchoolSelected, string sYear, string sSchoolType)
{
var listYear = GetListYear();
var listSchoolData = new List <BaseSPDataModel>();
BaseSPDataModel tempSchool = new BaseSPDataModel();
//add Aberdeen Primary School data
tListSchoolSelected.Add(new School("1002", "Aberdeen Special Schools"));
Year selectedyear = new Year(sYear);
foreach (School school in tListSchoolSelected)
{
tempSchool = new BaseSPDataModel();
tempSchool.SeedCode = school.seedcode;
tempSchool.SchoolName = school.name;
tempSchool.listNationalityIdentity = GetHistoricalNationalityData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.NationalityIdentity = tempSchool.listNationalityIdentity.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listEthnicbackground = GetHistoricalEthnicData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.Ethnicbackground = tempSchool.listEthnicbackground.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listLevelOfEnglish = GetHistoricalEALData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.LevelOfEnglish = tempSchool.listLevelOfEnglish.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listLookedAfter = GetHistoricalLookedAfterData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.LookedAfter = tempSchool.listLookedAfter.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.SchoolRoll = GetSchoolRollData(school, selectedyear);
tempSchool.SchoolRollForecast = GetSchoolRollForecastData(rpGeneric2nd, school);
//tempSchool.listSIMD = GetHistoricalSIMDData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
if (Convert.ToInt16(selectedyear.year) < 2016)
{
tempSchool.listSIMD = null;
tempSchool.SIMD = null;
}
else
{
if (school.seedcode.Equals("1004140"))
{
if (Convert.ToInt16(selectedyear.year) == 2016)
{
tempSchool.listSIMD = null;
tempSchool.SIMD = null;
}
else
{
tempSchool.listSIMD = GetHistoricalSIMDData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.SIMD = tempSchool.listSIMD.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
}
}
else
{
tempSchool.listSIMD = GetHistoricalSIMDData(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.SIMD = tempSchool.listSIMD.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
}
}
tempSchool.listFSM = GetHistoricalFSMData(rpGeneric2nd, school.seedcode, listYear, sSchoolType);
tempSchool.FSM = tempSchool.listFSM.Where(x => x.year.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listStudentNeed = GetHistoricalStudentNeed(rpGeneric2nd, sSchoolType, school.seedcode, listYear);
tempSchool.StudentNeed = tempSchool.listStudentNeed.Where(x => x.year.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listAttendance = GetHistoricalAttendanceData(rpGeneric2nd, sSchoolType, school, listYear);
tempSchool.SPAttendance = tempSchool.listAttendance.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
tempSchool.listExclusion = GetHistoricalExclusionData(rpGeneric2nd, sSchoolType, school, listYear);
tempSchool.SPExclusion = tempSchool.listExclusion.Where(x => x.YearInfo.year.Equals(selectedyear.year)).FirstOrDefault();
listSchoolData.Add(tempSchool);
}
return(listSchoolData);
}
private TagData toTagData()
{
TagData result = new TagData();
result.Title = Title;
result.Artist = Artist;
result.Composer = Composer;
result.Comment = Comment;
result.Genre = Genre;
result.OriginalArtist = OriginalArtist;
result.OriginalAlbum = OriginalAlbum;
result.GeneralDescription = Description;
result.Rating = (Popularity * 5).ToString();
result.Copyright = Copyright;
result.Publisher = Publisher;
if (!PublishingDate.Equals(DateTime.MinValue))
{
result.PublishingDate = TrackUtils.FormatISOTimestamp(PublishingDate);
}
result.AlbumArtist = AlbumArtist;
result.Conductor = Conductor;
if (!Date.Equals(DateTime.MinValue))
{
result.RecordingDate = TrackUtils.FormatISOTimestamp(Date);
}
result.RecordingYear = Year.ToString();
result.Album = Album;
result.TrackNumber = TrackNumber.ToString();
result.TrackTotal = TrackTotal.ToString();
result.DiscNumber = DiscNumber.ToString();
result.DiscTotal = DiscTotal.ToString();
result.ChaptersTableDescription = ChaptersTableDescription.ToString();
result.Chapters = new List <ChapterInfo>();
foreach (ChapterInfo chapter in Chapters)
{
result.Chapters.Add(new ChapterInfo(chapter));
}
if (Lyrics != null)
{
result.Lyrics = new LyricsInfo(Lyrics);
}
foreach (string s in AdditionalFields.Keys)
{
result.AdditionalFields.Add(new MetaFieldInfo(MetaDataIOFactory.TAG_ANY, s, AdditionalFields[s]));
}
// Detect and tag deleted Additional fields (=those which were in initialAdditionalFields and do not appear in AdditionalFields anymore)
foreach (string s in initialAdditionalFields)
{
if (!AdditionalFields.ContainsKey(s))
{
MetaFieldInfo metaFieldToDelete = new MetaFieldInfo(MetaDataIOFactory.TAG_ANY, s, "");
metaFieldToDelete.MarkedForDeletion = true;
result.AdditionalFields.Add(metaFieldToDelete);
}
}
result.Pictures = new List <PictureInfo>();
if (currentEmbeddedPictures != null)
{
foreach (PictureInfo targetPic in currentEmbeddedPictures)
{
targetPic.TransientFlag = 0;
}
}
if (initialEmbeddedPictures != null && currentEmbeddedPictures != null)
{
foreach (PictureInfo picInfo in initialEmbeddedPictures)
{
// Detect and tag deleted pictures (=those which were in initialEmbeddedPictures and do not appear in embeddedPictures anymore)
if (!currentEmbeddedPictures.Contains(picInfo))
{
PictureInfo picToDelete = new PictureInfo(picInfo);
picToDelete.MarkedForDeletion = true;
result.Pictures.Add(picToDelete);
}
else // Only add new additions (pictures identical to initial list will be kept, and do not have to make it to the list, or else a duplicate will be created)
{
foreach (PictureInfo targetPic in currentEmbeddedPictures)
{
if (targetPic.Equals(picInfo))
{
// Compare picture contents
targetPic.ComputePicHash();
if (targetPic.PictureHash != picInfo.PictureHash)
{
// A new picture content has been defined for an existing location
result.Pictures.Add(targetPic);
PictureInfo picToDelete = new PictureInfo(picInfo);
picToDelete.MarkedForDeletion = true;
result.Pictures.Add(picToDelete);
}
targetPic.TransientFlag = 1;
}
}
}
}
if (currentEmbeddedPictures != null)
{
foreach (PictureInfo targetPic in currentEmbeddedPictures)
{
if (0 == targetPic.TransientFlag) // Entirely new pictures without equivalent in initialEmbeddedPictures
{
result.Pictures.Add(targetPic);
}
}
}
}
return(result);
}
private ACCDataStore.Entity.SchoolProfiles.Census.Entity.ChartData GetChartData(List <BaseSPDataModel> listSchool, Year eYearSelected)
{
try
{
Entity.SchoolProfiles.Census.Entity.ChartData chartdata = new Entity.SchoolProfiles.Census.Entity.ChartData();
chartdata.ChartNationalityIdentity = GetChartNationalityIdentity(listSchool, eYearSelected);
chartdata.ChartLevelOfEnglish = GetChartLevelofEnglish(listSchool, eYearSelected);
chartdata.ChartLevelOfEnglishByCatagories = GetChartLevelofEnglishbyCatagories(listSchool, eYearSelected);
if (Convert.ToInt16(eYearSelected.year) < 2016)
{
chartdata.ChartSIMD = null;
}
else
{
if (listSchool.FirstOrDefault(i => i.SeedCode.Equals("1004140")) != null) //school.seedcode.Equals("1004140")
{
if (Convert.ToInt16(eYearSelected.year) == 2016)
{
chartdata.ChartSIMD = null;
}
else
{
chartdata.ChartSIMD = GetChartSIMDDecile(listSchool, eYearSelected);
}
}
else
{
chartdata.ChartSIMD = GetChartSIMDDecile(listSchool, eYearSelected);
}
}
chartdata.CartSchoolRollForecast = GetChartSchoolRollForecast(listSchool);
chartdata.ChartIEP = GetChartStudentNeedIEP(listSchool);
chartdata.ChartCSP = GetChartStudentNeedCSP(listSchool);
chartdata.ChartLookedAfter = GetChartLookedAfter(listSchool);
chartdata.ChartAttendance = GetChartAttendance(listSchool, "Attendance");
chartdata.ChartAuthorisedAbsence = GetChartAttendance(listSchool, "Authorised Absence");
chartdata.ChartUnauthorisedAbsence = GetChartAttendance(listSchool, "Unauthorised Absence");
chartdata.ChartTotalAbsence = GetChartAttendance(listSchool, "Total Absence");
chartdata.ChartNumberofDaysLostExclusion = GetChartExclusion(listSchool, "Number of Days Lost Per 1000 Pupils Through Exclusions");
chartdata.ChartNumberofExclusionRFR = GetChartExclusion(listSchool, "Number of Removals from the Register");
chartdata.ChartNumberofExclusionTemporary = GetChartExclusion(listSchool, "Number of Temporary Exclusions");
chartdata.ChartFSM = GetChartFSM(listSchool);
return(chartdata);
}
catch (Exception ex)
{
var sErrorMessage = "Error : " + ex.Message + (ex.InnerException != null ? ", More Detail : " + ex.InnerException.Message : "");
log.Error(ex.Message, ex);
return(null);
}
}
static void Main(string[] args)
{
List <Year> years = new List <Year>();
while (true)
{
try
{
Write("Что вы хотите сделать(1-установить дату, 2-вывести день по дате, 3-рассчитать кол-во дней, 4-рассчитать кол-во месяцев)");
int x = Convert.ToInt32(Console.ReadLine());
int day = 1, month = 1, year1 = 1;
Year year = null;
switch (x)
{
case 1:
Write("Введите день");
day = Convert.ToInt32(Console.ReadLine());
Write("Введите месяц");
month = Convert.ToInt32(Console.ReadLine());
Write("Введите год");
if (day >= 31 || month >= 12)
{
Write("Данные введены неверно");
break;
}
year1 = Convert.ToInt32(Console.ReadLine());
year = new Year(Convert.ToInt32(year1));
year.CreateDate();
years.Add(year);
break;
case 2:
if (years.Count == 0)
{
Write("Сначала установите дату");
break;
}
Write(Year.PrintDay(day, month, years[years.Count - 1]));
break;
case 3:
Write("Введите день даты1");
int day1 = Convert.ToInt32(Console.ReadLine());
Write("Введите месяц даты1");
int month1 = Convert.ToInt32(Console.ReadLine());
Write("Введите год даты1");
if (day >= 31 || month >= 12)
{
Write("Данные введены неверно");
break;
}
int year2 = Convert.ToInt32(Console.ReadLine());
year = new Year(Convert.ToInt32(year2));
year.CreateDate();
years.Add(year);
Write("Введите день даты2");
int day2 = Convert.ToInt32(Console.ReadLine());
Write("Введите месяц даты2");
int month2 = Convert.ToInt32(Console.ReadLine());
Write("Введите год даты2");
if (day >= 31 || month >= 12)
{
Write("Данные введены неверно");
break;
}
int year3 = Convert.ToInt32(Console.ReadLine());
int d = year3 - year2;
for (int i = 1; i < d; i++)
{
years.Add(new Year(year2 + i));
}
year = new Year(Convert.ToInt32(year3));
year.CreateDate();
years.Add(year);
Write(Convert.ToString(Math.Abs(Year.CountDaysInDates(years, Convert.ToInt32(day1), Convert.ToInt32(month1), Convert.ToInt32(year2), Convert.ToInt32(day2), Convert.ToInt32(month2), Convert.ToInt32(year3)))));
years.Clear();
break;
case 4:
Write("Введите день даты1");
int day4 = Convert.ToInt32(Console.ReadLine());
Write("Введите месяц даты1");
int month4 = Convert.ToInt32(Console.ReadLine());
Write("Введите год даты1");
if (day >= 31 || month >= 12)
{
Write("Данные введены неверно");
break;
}
int year4 = Convert.ToInt32(Console.ReadLine());
year = new Year(Convert.ToInt32(year4));
year.CreateDate();
years.Add(year);
Write("Введите день даты2");
int day5 = Convert.ToInt32(Console.ReadLine());
Write("Введите месяц даты2");
int month5 = Convert.ToInt32(Console.ReadLine());
Write("Введите год даты2");
if (day >= 31 || month >= 12)
{
Write("Данные введены неверно");
break;
}
int year5 = Convert.ToInt32(Console.ReadLine());
d = year5 - year4;
for (int i = 1; i < d; i++)
{
years.Add(new Year(year4 + i));
}
year = new Year(Convert.ToInt32(year5));
year.CreateDate();
years.Add(year);
Write(Convert.ToString(Math.Abs(Year.CountMonthsInDates(years, Convert.ToInt32(day4), Convert.ToInt32(month4), Convert.ToInt32(year4), Convert.ToInt32(day5), Convert.ToInt32(month5), Convert.ToInt32(year5)))));
years.Clear();
break;
}
}
catch (Exception)
{
Write("Ошибка при введении данных, попробуйте снова");
}
}
}
public void FillMandatoryData(string nic, string date, string firstName, string middleName, string lastName, string birthPlace)
{
WebDriver.driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(2000);
Thread.Sleep(3000);
txtNIC.EnterText(nic);
txtNICConfirm.EnterText(nic);
Major.ButtonClick();
Thread.Sleep(2000);
txtNICConfirm.ButtonClick();
Actions acc = new Actions(WebDriver.driver);
txtNICIssueDate.ButtonClick();
Thread.Sleep(2000);
//txtNICIssueDate.EnterText(date);
Month.ButtonClick();
acc.SendKeys(Keys.ArrowUp).SendKeys(Keys.Enter).Perform();
Year.ButtonClick();
Thread.Sleep(2000);
acc.SendKeys(Keys.ArrowUp).SendKeys(Keys.Enter).Perform();
Thread.Sleep(2000);
Day.ButtonClick();
/*
* Month.SelectDropDown(month);
* Year.SelectDropDown(year.ToString());
* Day.ButtonClick(); */
dpdCountryId.ButtonClick();
Actions SelectCountry = new Actions(WebDriver.driver);
SelectCountry.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions nicchange = new Actions(WebDriver.driver);
nicchange.MoveToElement(txtNICConfirm).Click().Perform();
txtFirstName.EnterText(firstName);
txtMiddleName.EnterText(middleName);
txtLastName.EnterText(lastName);
txtPlaceOfBirth.EnterText(birthPlace);
Thread.Sleep(2000);
Actions Marital = new Actions(WebDriver.driver);
Marital.MoveToElement(dpdMaritalStatus).Click().Perform();
Marital.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions CustomerCategories = new Actions(WebDriver.driver);
CustomerCategories.MoveToElement(dpdCustomerCategories).Click().Perform();
CustomerCategories.SendKeys(Keys.ArrowDown).SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions Nationality = new Actions(WebDriver.driver);
Nationality.MoveToElement(dpdNationality).Click().Perform();
Nationality.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions SupplierType = new Actions(WebDriver.driver);
SupplierType.MoveToElement(dpdSupplierType).Click().Perform();
SupplierType.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions Religion = new Actions(WebDriver.driver);
Religion.MoveToElement(dpdReligion).Click().Perform();
Religion.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions Race = new Actions(WebDriver.driver);
Race.MoveToElement(dpdRace).Click().Perform();
Race.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions Nationality1 = new Actions(WebDriver.driver);
Nationality1.MoveToElement(dpdNationality).Click().Perform();
Nationality1.SendKeys(Keys.ArrowDown).SendKeys(Keys.Enter).Perform();
Actions next = new Actions(WebDriver.driver);
next.MoveToElement(btnNext).Click().Perform();
// return new BusinessPartnerCreationSecondPageObjects();
}
public static void InitializeDataAsync(IServiceProvider serviceProvider)
{
var db = serviceProvider.GetService <ApplicationDbContext>();
db.Database.Migrate();
AddEmptyMarksToStudentForSubject(db);
if (db.Schools.Any(x => x.Deleted == false))
{
return;
}
var school = new School {
Id = 1, Title = "ثانوية دمشق العربية", City = "دمشق", ManagerName = ""
};
db.Schools.Add(school);
db.SaveChanges();
var year = new Year {
Title = "2017-2018", PresenceDays = 0
};
db.Years.Add(year);
db.SaveChanges();
var classes = new List <Class>()
{
new Class {
Title = "الاول"
},
new Class {
Title = "الثاني"
},
new Class {
Title = "الثالث"
},
new Class {
Title = "الرابع"
},
new Class {
Title = "الخامس"
},
new Class {
Title = "السادس"
},
new Class {
Title = "السابع"
},
new Class {
Title = "الثامن"
},
new Class {
Title = "التاسع"
},
new Class {
Title = "العاشر"
},
new Class {
Title = "الحادي عشر علمي"
},
new Class {
Title = "الثاني عشر علمي"
},
new Class {
Title = "الحادي عشر ادبي"
},
new Class {
Title = "الثاني عشر ادبي"
}
};
db.Classes.AddRange(classes);
db.SaveChanges();
foreach (var c in classes)
{
db.ClassYears.Add(new ClassYear {
ClassId = c.Id, YearId = year.Id, SchoolId = school.Id
});
}
db.SaveChanges();
db.Subjects.AddRange(
new Subject {
ClassId = classes[6].Id, Title = "التربية الدينية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[6].Id, Title = "اللغة العربية", MaxMark = 600, MinMark = 300
},
new Subject {
ClassId = classes[6].Id, Title = "اللغة الانكيزية", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[6].Id, Title = "اللغة الفرنسية", MaxMark = 300, MinMark = 120
},
new Subject {
ClassId = classes[6].Id, Title = "المواد الاجتماعية", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[6].Id, Title = "الرياضيات", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[6].Id, Title = "العلوم العامة", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[6].Id, Title = "المعلوماتية ", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[6].Id, Title = " التربية الموسيقية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[6].Id, Title = "التربية الفنية التشكلية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[6].Id, Title = "التربية الرياضية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[6].Id, Title = "السلوك", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = "التربية الدينية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = "اللغة العربية", MaxMark = 600, MinMark = 300
},
new Subject {
ClassId = classes[7].Id, Title = "اللغة الانكيزية", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[7].Id, Title = "اللغة الفرنسية", MaxMark = 300, MinMark = 120
},
new Subject {
ClassId = classes[7].Id, Title = "المواد الاجتماعية", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[7].Id, Title = "الرياضيات", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[7].Id, Title = "العلوم العامة", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[7].Id, Title = "المعلوماتية ", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = " التربية الموسيقية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = "التربية الفنية التشكلية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = "التربية الرياضية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[7].Id, Title = "السلوك", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[8].Id, Title = "التربية الدينية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[8].Id, Title = "اللغة العربية", MaxMark = 600, MinMark = 300
},
new Subject {
ClassId = classes[8].Id, Title = "اللغة الانكيزية", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[8].Id, Title = "اللغة الفرنسية", MaxMark = 300, MinMark = 120
},
new Subject {
ClassId = classes[8].Id, Title = "المواد الاجتماعية", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[8].Id, Title = "الرياضيات", MaxMark = 600, MinMark = 240
},
new Subject {
ClassId = classes[8].Id, Title = "العلوم العامة", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[8].Id, Title = " التربية الموسيقية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[8].Id, Title = "التربية الفنية التشكلية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[8].Id, Title = "التربية الرياضية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[8].Id, Title = "السلوك", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "التربية الدينية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "اللغة العربية", MaxMark = 500, MinMark = 250
},
new Subject {
ClassId = classes[9].Id, Title = "اللغة الانكيزية", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[9].Id, Title = "اللغة الفرنسية", MaxMark = 300, MinMark = 120
},
new Subject {
ClassId = classes[9].Id, Title = "التربية الوطنية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "التاريخ", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "الجغرافية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "الفلسفة", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "الرياضيات ", MaxMark = 400, MinMark = 160
},
new Subject {
ClassId = classes[9].Id, Title = "المعلوماتية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "الفيزياء", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "الكيمياء", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "علم الأحياء", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "التربية الفنية التشكلية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "التربية الرياضية", MaxMark = 200, MinMark = 80
},
new Subject {
ClassId = classes[9].Id, Title = "السلوك", MaxMark = 200, MinMark = 80
}
);
db.SaveChanges();
}
public BuiltInFunctions()
{
// Text
Functions["len"] = new Len();
Functions["lower"] = new Lower();
Functions["upper"] = new Upper();
Functions["left"] = new Left();
Functions["right"] = new Right();
Functions["mid"] = new Mid();
Functions["replace"] = new Replace();
Functions["rept"] = new Rept();
Functions["substitute"] = new Substitute();
Functions["concatenate"] = new Concatenate();
Functions["char"] = new CharFunction();
Functions["exact"] = new Exact();
Functions["find"] = new Find();
Functions["fixed"] = new Fixed();
Functions["proper"] = new Proper();
Functions["search"] = new Search();
Functions["text"] = new Text.Text();
Functions["t"] = new T();
Functions["hyperlink"] = new Hyperlink();
Functions["value"] = new Value();
// Numbers
Functions["int"] = new CInt();
// Math
Functions["abs"] = new Abs();
Functions["asin"] = new Asin();
Functions["asinh"] = new Asinh();
Functions["cos"] = new Cos();
Functions["cosh"] = new Cosh();
Functions["power"] = new Power();
Functions["sign"] = new Sign();
Functions["sqrt"] = new Sqrt();
Functions["sqrtpi"] = new SqrtPi();
Functions["pi"] = new Pi();
Functions["product"] = new Product();
Functions["ceiling"] = new Ceiling();
Functions["count"] = new Count();
Functions["counta"] = new CountA();
Functions["countblank"] = new CountBlank();
Functions["countif"] = new CountIf();
Functions["countifs"] = new CountIfs();
Functions["fact"] = new Fact();
Functions["floor"] = new Floor();
Functions["sin"] = new Sin();
Functions["sinh"] = new Sinh();
Functions["sum"] = new Sum();
Functions["sumif"] = new SumIf();
Functions["sumifs"] = new SumIfs();
Functions["sumproduct"] = new SumProduct();
Functions["sumsq"] = new Sumsq();
Functions["stdev"] = new Stdev();
Functions["stdevp"] = new StdevP();
Functions["stdev.s"] = new Stdev();
Functions["stdev.p"] = new StdevP();
Functions["subtotal"] = new Subtotal();
Functions["exp"] = new Exp();
Functions["log"] = new Log();
Functions["log10"] = new Log10();
Functions["ln"] = new Ln();
Functions["max"] = new Max();
Functions["maxa"] = new Maxa();
Functions["median"] = new Median();
Functions["min"] = new Min();
Functions["mina"] = new Mina();
Functions["mod"] = new Mod();
Functions["average"] = new Average();
Functions["averagea"] = new AverageA();
Functions["averageif"] = new AverageIf();
Functions["averageifs"] = new AverageIfs();
Functions["round"] = new Round();
Functions["rounddown"] = new Rounddown();
Functions["roundup"] = new Roundup();
Functions["rand"] = new Rand();
Functions["randbetween"] = new RandBetween();
Functions["rank"] = new Rank();
Functions["rank.eq"] = new Rank();
Functions["rank.avg"] = new Rank(true);
Functions["quotient"] = new Quotient();
Functions["trunc"] = new Trunc();
Functions["tan"] = new Tan();
Functions["tanh"] = new Tanh();
Functions["atan"] = new Atan();
Functions["atan2"] = new Atan2();
Functions["atanh"] = new Atanh();
Functions["acos"] = new Acos();
Functions["acosh"] = new Acosh();
Functions["var"] = new Var();
Functions["varp"] = new VarP();
Functions["large"] = new Large();
Functions["small"] = new Small();
Functions["degrees"] = new Degrees();
// Information
Functions["isblank"] = new IsBlank();
Functions["isnumber"] = new IsNumber();
Functions["istext"] = new IsText();
Functions["isnontext"] = new IsNonText();
Functions["iserror"] = new IsError();
Functions["iserr"] = new IsErr();
Functions["error.type"] = new ErrorType();
Functions["iseven"] = new IsEven();
Functions["isodd"] = new IsOdd();
Functions["islogical"] = new IsLogical();
Functions["isna"] = new IsNa();
Functions["na"] = new Na();
Functions["n"] = new N();
// Logical
Functions["if"] = new If();
Functions["iferror"] = new IfError();
Functions["ifna"] = new IfNa();
Functions["not"] = new Not();
Functions["and"] = new And();
Functions["or"] = new Or();
Functions["true"] = new True();
Functions["false"] = new False();
// Reference and lookup
Functions["address"] = new Address();
Functions["hlookup"] = new HLookup();
Functions["vlookup"] = new VLookup();
Functions["lookup"] = new Lookup();
Functions["match"] = new Match();
Functions["row"] = new Row()
{
SkipArgumentEvaluation = true
};
Functions["rows"] = new Rows()
{
SkipArgumentEvaluation = true
};
Functions["column"] = new Column()
{
SkipArgumentEvaluation = true
};
Functions["columns"] = new Columns()
{
SkipArgumentEvaluation = true
};
Functions["choose"] = new Choose();
Functions["index"] = new Index();
Functions["indirect"] = new Indirect();
Functions["offset"] = new Offset()
{
SkipArgumentEvaluation = true
};
// Date
Functions["date"] = new Date();
Functions["today"] = new Today();
Functions["now"] = new Now();
Functions["day"] = new Day();
Functions["month"] = new Month();
Functions["year"] = new Year();
Functions["time"] = new Time();
Functions["hour"] = new Hour();
Functions["minute"] = new Minute();
Functions["second"] = new Second();
Functions["weeknum"] = new Weeknum();
Functions["weekday"] = new Weekday();
Functions["days360"] = new Days360();
Functions["yearfrac"] = new Yearfrac();
Functions["edate"] = new Edate();
Functions["eomonth"] = new Eomonth();
Functions["isoweeknum"] = new IsoWeekNum();
Functions["workday"] = new Workday();
Functions["networkdays"] = new Networkdays();
Functions["networkdays.intl"] = new NetworkdaysIntl();
Functions["datevalue"] = new DateValue();
Functions["timevalue"] = new TimeValue();
// Database
Functions["dget"] = new Dget();
Functions["dcount"] = new Dcount();
Functions["dcounta"] = new DcountA();
Functions["dmax"] = new Dmax();
Functions["dmin"] = new Dmin();
Functions["dsum"] = new Dsum();
Functions["daverage"] = new Daverage();
Functions["dvar"] = new Dvar();
Functions["dvarp"] = new Dvarp();
//Finance
Functions["pmt"] = new Pmt();
}
public int GetSubjectID(Year Year, string SubjectName)
{
return(Year.Subject.First(x => x.SubjectName == SubjectName).SubjectID);
}
public string ToString(string format)
{
var formattedText = "";
if (format != null)
{
for (int i = 0, len = format.Length; i < len; i++)
{
var wildcard = format[i];
var part = wildcard.ToString();
i++;
while (i < len && format[i] == wildcard)
{
part += format[i];
i++;
}
i--;
switch (part)
{
case "y":
case "yy":
case "yyy":
case "yyyy":
formattedText += Year.ToString().PadLeft(part.Length, '0');
break;
case "MMMM":
formattedText += GetMonthName(Month);
break;
case "MMM":
formattedText += GetShortMonthName(Month);
break;
case "MM":
case "M":
formattedText += Month.ToString().PadLeft(part.Length, '0');
break;
case "dddd":
formattedText += DayName;
break;
case "ddd":
formattedText += ShortDayName;
break;
case "dd":
case "d":
formattedText += Day.ToString().PadLeft(part.Length, '0');
break;
case "HH":
case "H":
formattedText += Hour.ToString().PadLeft(part.Length, '0');
break;
case "hh":
case "h":
formattedText += (Hour % 12 == 0 ? 12 : Hour % 12).ToString().PadLeft(part.Length, '0');
break;
case "mm":
case "m":
formattedText += Minute.ToString().PadLeft(part.Length, '0');
break;
case "ss":
case "s":
formattedText += Second.ToString().PadLeft(part.Length, '0');
break;
case "fffffff":
case "ffffff":
case "fffff":
case "ffff":
case "fff":
case "ff":
case "f":
formattedText += Millisecond.ToString().PadLeft(part.Length, '0');
break;
case "tt":
case "t":
formattedText += (Hour < 12 ? "صبح" : "عصر").Substring(0, part.Length == 1 ? 1 : 3);
break;
default:
formattedText += part;
break;
}
}
}
return(formattedText);
}
public void Invalid_leap_year()
{
Assert.That(Year.IsLeap(1997), Is.False);
}
//public double ToOADate(){}
public string ToShortDateString()
{
return(Year.ToString().Substring(2, 2) + "/" + Month.ToString().PadLeft(2, '0') + "/" + Day.ToString().PadLeft(2, '0'));
}
public void Turn_of_the_25th_century_is_a_leap_year()
{
Assert.That(Year.IsLeap(2400), Is.True);
}
/// <summary>Returns the string representation of the value of this instance.</summary>
/// <param name="format">Format string using the usual characters to interpret custom datetime - as per standard DateTime custom formats</param>
/// <returns>A string that represents the value of this instance.</returns>
public String ToString(String format, IFormatProvider provider)
{
//parse and replace the format stuff
MatchCollection matches = Regex.Matches(format, "([a-zA-z])\\1{0,}");
for (int i = matches.Count - 1; i >= 0; i--)
{
Match m = matches[i];
Int32 mIndex = m.Index, mLength = m.Length;
if (mIndex > 0 && format[m.Index - 1] == '\\')
{
if (m.Length == 1)
{
continue;
}
else
{
mIndex++;
mLength--;
}
}
switch (m.Value[0])
{
case 'y':
format = format.Substring(0, mIndex) + Year.ToString("D" + mLength) + format.Substring(mIndex + mLength);
break;
case 'M':
if (mLength < 3)
{
String input2 = Month.ToString("D" + mLength);
format = format.Substring(0, mIndex) + input2 + format.Substring(mIndex + mLength);
}
else if (mLength == 3)
{
if (KSPDateStructure.CalendarType == CalendarTypeEnum.Earth)
{
format = format.Substring(0, mIndex) + System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetAbbreviatedMonthName(Month) + format.Substring(mIndex + mLength);
}
else
if (KSPDateStructure.MonthCount < 1)
{
String input2 = Month.ToString("D" + mLength);
format = format.Substring(0, mIndex) + input2 + format.Substring(mIndex + mLength);
}
else
{
format = format.Substring(0, mIndex) + KSPDateStructure.Months[Month].ToString().Substring(0, 3) + format.Substring(mIndex + mLength);
}
}
else
{
if (KSPDateStructure.CalendarType == CalendarTypeEnum.Earth)
{
format = format.Substring(0, mIndex) + System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Month) + format.Substring(mIndex + mLength);
}
else
if (KSPDateStructure.MonthCount < 1)
{
String input2 = Month.ToString("D" + mLength);
format = format.Substring(0, mIndex) + input2 + format.Substring(mIndex + mLength);
}
else
{
format = format.Substring(0, mIndex) + KSPDateStructure.Months[Month] + format.Substring(mIndex + mLength);
}
}
break;
case 'd':
format = format.Substring(0, mIndex) + Day.ToString("D" + mLength) + format.Substring(mIndex + mLength);
break;
case 'h':
//how to do this one AM/PM Hours
String HalfDayTime = "";
switch (AMPM)
{
case AMPMEnum.AM:
HalfDayTime = Hour.ToString("D" + mLength.Clamp(1, (KSPDateStructure.HoursPerDay / 2).ToString().Length));
break;
case AMPMEnum.PM:
HalfDayTime = (Hour - (KSPDateStructure.HoursPerDay / 2)).ToString("D" + mLength.Clamp(1, (KSPDateStructure.HoursPerDay / 2).ToString().Length));
break;
case AMPMEnum.OddHoursPerDay:
default:
HalfDayTime = Hour.ToString("D" + mLength.Clamp(1, KSPDateStructure.HoursPerDay.ToString().Length));
break;
}
format = format.Substring(0, mIndex) + HalfDayTime + format.Substring(mIndex + mLength);
break;
case 't':
if (AMPM != AMPMEnum.OddHoursPerDay)
{
format = format.Substring(0, mIndex) + AMPM.ToString().ToLower() + format.Substring(mIndex + mLength);
}
break;
case 'T':
if (AMPM != AMPMEnum.OddHoursPerDay)
{
format = format.Substring(0, mIndex) + AMPM.ToString().ToUpper() + format.Substring(mIndex + mLength);
}
break;
case 'H':
format = format.Substring(0, mIndex) + Hour.ToString("D" + mLength.Clamp(1, KSPDateStructure.HoursPerDay.ToString().Length)) + format.Substring(mIndex + mLength);
break;
case 'm':
format = format.Substring(0, mIndex) + Minute.ToString("D" + mLength.Clamp(1, KSPDateStructure.MinutesPerHour.ToString().Length)) + format.Substring(mIndex + mLength);
break;
case 's':
format = format.Substring(0, mIndex) + Second.ToString("D" + mLength.Clamp(1, KSPDateStructure.SecondsPerMinute.ToString().Length)) + format.Substring(mIndex + mLength);
break;
default:
break;
}
}
//Now strip out the \ , but not multiple \\
format = Regex.Replace(format, "\\\\(?=[a-z])", "");
return(format);
//if (KSPDateStructure.CalendarType == CalendarTypeEnum.Earth)
// return String.Format(format, _EarthDateTime);
//else
// return String.Format(format, this); //"TEST";
}
//Generate a unique id for this object instance.
public override int GetHashCode()
{
return(Make.GetHashCode() + Model.GetHashCode() + Year.GetHashCode());
}
public void BeALeapYearIfItIsDivisibleBy400()
{
var year = new Year(4000);
Assert.That(year.IsLeap(), Is.True);
}
