//clears all the ticked boxes
private void Clear_all_Click(object sender, EventArgs e)
{
if (Weeks.SelectionMode != SelectionMode.None)
{
Weeks.ClearSelected();
}
All_dates.Checked = false;
if (Provider.SelectionMode != SelectionMode.None)
{
Provider.ClearSelected();
}
All_providers.Checked = false;
if (Provider_type.SelectionMode != SelectionMode.None)
{
Provider_type.ClearSelected();
}
All_Provider_types.Checked = false;
if (Shops.SelectionMode != SelectionMode.None)
{
Shops.ClearSelected();
}
All_shops.Checked = false;
}
//计算1901 1 1 -> 2000 12 31 每个月的第一天有多少个星期天
public int Solution()
{
//Week在外面处理较好
Date date1 = new Date(1900, 1, 1);
Date date2 = new Date(1901, 1, 1);
Date date3 = new Date(2000, 12, 31);
//计算1901,1,1是周几,已知1900 1 1是周一
Weeks current = Weeks.Mon;
while (!date1.Equals(date2))
{
date1.NextDay();
current++;
}
//计算1901 1 1 -> 2000 12 31 每个月的第一天有多少个星期天
int count = 0;
while (!date1.Equals(date3))
{
if (date1.FirstOfMonth() && current == Weeks.Sun)
{
count++;
}
date1.NextDay();
current = (Weeks)((int)(current + 1) % 7);
}
return(count);
}
public IEnumerable <Weeks> Get()
{
SqlConnection conn = new SqlConnection(connstring);
//ændre så den passer med vores
SqlCommand query = new SqlCommand("SELECT * FROM weeks", conn);
conn.Open();
SqlDataReader laeser = query.ExecuteReader();
//set objekt til hvad vores objekt er
List <Weeks> weeksList = new List <Weeks>();
if (laeser.HasRows)
{
while (laeser.Read())
{
Weeks hs = new Weeks {
week_id = laeser.GetInt32(0), week_week = laeser.GetInt32(1)
};
weeksList.Add(hs);
}
}
return(weeksList);
}
public ScheduleViewModel(Schedule schedule, WellknownData wellknown)
{
Weeks = schedule.Weeks.OrderBy(x => x.WeekNumber).Select(x => new ScheduleWeekViewModel(x, wellknown)).ToList();
if (Weeks.Count > 1)
{
for (int i = 0; i < Weeks.Count - 1; i++)
{
int insertCount = Weeks[i + 1].WeekNumber - Weeks[i].WeekNumber - 1;
for (int j = 0; j < insertCount; j++)
{
ScheduleWeekViewModel emptyWeek = new ScheduleWeekViewModel(new ScheduleWeek(Weeks[i].WeekNumber + j + 1), wellknown);
Weeks.Insert(i + j + 1, emptyWeek);
}
i += insertCount;
}
}
int daysSinceTermStart = (int)(DateTimeOffset.Now.Date - wellknown.TermStartDate).TotalDays;
int weekNumber = daysSinceTermStart / 7;
if (weekNumber < 0 || weekNumber >= Weeks.Count)
{
Today = new List <ScheduleEntryViewModel>();
}
else
{
int todayDayOfWeek = (int)DateTimeOffset.Now.DayOfWeek;
todayDayOfWeek = todayDayOfWeek == 0 ? 7 : todayDayOfWeek;
ScheduleDayViewModel day = Weeks[weekNumber].Days[todayDayOfWeek - 1];
Today = day.Entries.Where(x => x.LocalEndTime > DateTimeOffset.Now).ToList() ?? new List <ScheduleEntryViewModel>();
}
}
public void Put(int id, [FromBody] Weeks value)
{
SqlConnection conn = new SqlConnection(connstring);
SqlCommand query = new SqlCommand($"UPDATE weeks SET week_week={value.week_week} WHERE week_id = {id}", conn);
conn.Open();
query.ExecuteNonQuery();
}
public void Post([FromBody] Weeks value)
{
SqlConnection conn = new SqlConnection(connstring);
SqlCommand query = new SqlCommand($"INSERT INTO weeks(week_week) VALUES({value.week_week})", conn);
conn.Open();
query.ExecuteNonQuery();
}
private void AddWeek(object parameter)
{
var week = _weekService.NewWeek(GetMaxStartDate());
var viewModel = new WeekViewModel(_weekService, _hourCodeProvider, week);
Weeks.Insert(0, viewModel);
CurrentWeek = viewModel;
}
public void addWeek(string week)
{
if (Weeks == null)
{
Weeks = new List <string>();
}
Weeks.Add(week);
}
public ActionResult DeleteConfirmed(int id)
{
Weeks weeks = db.Weeks.Find(id);
db.Weeks.Remove(weeks);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,WeekId,SectionId,CourseId")] Weeks weeks)
{
if (ModelState.IsValid)
{
db.Entry(weeks).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(weeks));
}
static void Main(string[] args)
{
var weeks = new Weeks();
foreach (var item in weeks)
{
Console.WriteLine(item);
}
Console.ReadLine();
}
public override string ToString()
{
StringBuilder builder = new StringBuilder();
if (Signum == -1)
{
builder.Append("-");
}
builder.Append("P");
if (Years != 0)
{
builder.Append(Years.ToString());
builder.Append("Y");
}
if (Months != 0)
{
builder.Append(Months.ToString());
builder.Append("M");
}
if (Weeks != 0)
{
builder.Append(Weeks.ToString());
builder.Append("W");
}
if (Days != 0 || (Years == 0 && Months == 0 && Weeks == 0 && Hours == 0 && Minutes == 0 && Seconds == 0 && FractionOfSecond == 0))
{
builder.Append(Days.ToString());
builder.Append("D");
}
if (!(Hours == 0 && Minutes == 0 && Seconds == 0 && FractionOfSecond == 0))
{
builder.Append("T");
if (Hours != 0)
{
builder.Append(Hours.ToString());
builder.Append("H");
}
if (Minutes != 0)
{
builder.Append(Minutes.ToString());
builder.Append("M");
}
if (Seconds != 0 || FractionOfSecond != 0M)
{
builder.Append(Seconds.ToString());
if (FractionOfSecond != 0)
{
builder.Append(FractionOfSecond.ToString().Substring(1));
}
builder.Append("S");
}
}
return(builder.ToString());
}
public ActionResult Create([Bind(Include = "Id,WeekId,SectionId,CourseId")] Weeks weeks)
{
if (ModelState.IsValid)
{
db.Weeks.Add(weeks);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(weeks));
}
static void Main(string[] args)
{
var weeks = new Weeks();
var iterator = weeks.GetWeeksIterator();
foreach (var item in weeks.GetWeeksIterator())
{
Console.WriteLine(item);
}
Console.ReadLine();
}
public Report Build()
{
var weekPeriods = Weeks.Select(w => new WeekPeriod
(
startedOn: w.StartedOn.Day,
finishedOn: w.FinishedOn.Day,
rates: w.GetRateInfos()
)).ToArray();
return(new Report(string.Format("{0:yyyy}", Weeks[0].StartedOn), string.Format("{0:MMMM}", Weeks[0].StartedOn), weekPeriods));
}
static void Main(string[] args)
{
var weeks = new Weeks();
var iterator = weeks.GetWeekDaysIterator();
while (iterator.MoveNext())
{
Console.WriteLine(iterator.Current);
}
Console.ReadLine();
}
} // ShowCompactWeeks
// ----------------------------------------------------------------------
public static void ShowWeeks(Weeks weeks, string caption = "Weeks")
{
WriteLine("{0}: {1}", caption, weeks);
WriteIndentLine("YearWeek: {0}", Format(weeks.Start));
WriteIndentLine("FirstDayStart: {0}", Format(weeks.FirstDayStart));
WriteIndentLine("LastDayStart: {0}", Format(weeks.LastDayStart));
WriteIndentLine("StartWeek: {0}", weeks.StartWeek);
WriteIndentLine("StartWeekOfYearName: {0}", weeks.StartWeekOfYearName);
WriteIndentLine("EndWeek: {0}", weeks.EndWeek);
WriteIndentLine("EndWeekOfYearName: {0}", weeks.EndWeekOfYearName);
WriteLine();
} // ShowWeeks
public static List <ScheduleView> GetLessons()
{
var list = Parser.GetDataFromTable <LessonCell>((int)ConstantIndexes.ContentRowIndex, (int)ConstantIndexes.ContentColumnIndex, Days.Last().EndCellIndex.GetNumber());
var resultList = new List <LessonCell>();
foreach (var item in list)
{
var itemGroups = Groups.Where(g => g.IsInColumnRange(item.StartCellIndex, item.EndCellIndex)).ToList();
if (itemGroups.Count != 0) // will need to be changed
{
item.Groups = itemGroups.Select(g => g.Group).ToList();
item.Specialities = itemGroups.Select(s => s.Speciality).Distinct().ToList();
item.Day = Days.Where(d => d.IsInRowRange(item.StartCellIndex, item.EndCellIndex)).Select(d => d.Day).FirstOrDefault();
item.LessonNumber = LessonNumbers.Where(l => l.IsInRowRange(item.StartCellIndex, item.EndCellIndex)).Select(s => s.LessonNumber).FirstOrDefault();
if (!item.IsMergedRows)
{
item.Week = Weeks.Where(w => w.IsInRowRange(item.StartCellIndex, item.EndCellIndex)).Select(w => w.Week).FirstOrDefault();
}
resultList.Add(item);
}
}
var _list = new List <ScheduleView>();
foreach (var item in Groups)
{
var rows = resultList.Where(r => r.Groups.Contains(item.Group)); // 57 rows for 422 group
var groupedItems = rows.GroupBy(d => new { d.LessonNumber, item.Group.Name, d.Day },
(key, group) => new GroupedItem
{
Day = key.Day,
NumberOfLesson = key.LessonNumber,
GroupNumber = key.Name,
Rows = group.ToList()
}).ToList();
var groupLessons = ParseRows(groupedItems).ToList();
var scheduleItem = new ScheduleView
{
GroupName = item.Group.Name,
Lessons = groupLessons
};
_list.Add(scheduleItem);
}
//var group422 = _list.Where(u => u.GroupName == "422").FirstOrDefault();
//foreach (var item in group422.Lessons)
//{
// Console.WriteLine($"{item.LessonNumber.NumberOfLesson} : {item.Lesson.Name} : {item.Teacher.Name} : {item.Auditory.Name}");
//}
//Console.WriteLine($"Count {group422.Lessons.Count}");
return(_list);
}
private void RemoveWeek(object obj)
{
if (CurrentWeek == null)
{
return;
}
var currentWeek = CurrentWeek;
Weeks.Remove(currentWeek);
CurrentWeek = Weeks.FirstOrDefault();
_weekService.Remove(currentWeek.Week);
}
public void SingleWeeksTest()
{
const int startYear = 2004;
const int startWeek = 22;
Weeks weeks = new Weeks(startYear, startWeek, 1);
Assert.Equal <int>(weeks.Year, startYear);
Assert.Equal(1, weeks.WeekCount);
Assert.Equal <int>(weeks.StartWeek, startWeek);
Assert.Equal <int>(weeks.EndWeek, startWeek);
Assert.Equal(1, weeks.GetWeeks().Count);
Assert.True(weeks.GetWeeks()[0].IsSamePeriod(new Week(2004, 22)));
} // SingleWeeksTest
public void Fill(IBAWindow parentView, SupplementsCycleDefinitionContext context)
{
this.context = context;
this.parentView = parentView;
this.Cycle = context.CycleDefinition.StandardClone();
Weeks.Clear();
foreach (var day in definition.Weeks.OrderBy(x => x.CycleWeekStart))
{
Weeks.Add(new SupplementsCycleWeekViewModel(this, day));
}
updateButtons();
}
public void AddWeek()
{
SupplementCycleWeekDTO week = new SupplementCycleWeekDTO();
week.CycleWeekStart = week.CycleWeekEnd = getNextWeekNumber();
definition.Weeks.Add(week);
var viewModel = new SupplementsCycleWeekViewModel(this, week);
Weeks.Add(viewModel);
viewModel.IsSelected = true;
IsModified = true;
}
public void MultiWeekTest()
{
const int startYear = 2004;
const int startWeek = 22;
const int weekCount = 4;
Weeks weeks = new Weeks(startYear, startWeek, weekCount);
Assert.Equal <int>(weeks.Year, startYear);
Assert.Equal <int>(weeks.WeekCount, weekCount);
Assert.Equal <int>(weeks.StartWeek, startWeek);
Assert.Equal <int>(weeks.EndWeek, startWeek + weekCount - 1);
Assert.Equal(weeks.GetWeeks().Count, weekCount);
Assert.True(weeks.GetWeeks()[0].IsSamePeriod(new Week(2004, 22)));
} // MultiWeekTest
// GET: Week/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Weeks weeks = db.Weeks.Find(id);
if (weeks == null)
{
return(HttpNotFound());
}
return(View(weeks));
}
public override String ToString()
{
StringBuilder sb = new StringBuilder("P");
if (Years != 0)
{
sb.Append(Years.ToString());
sb.Append("Y");
}
if (Months != 0)
{
sb.Append(Months.ToString());
sb.Append("M");
}
if (Weeks != 0)
{
sb.Append(Weeks.ToString());
sb.Append("W");
}
if (Days != 0)
{
sb.Append(Days.ToString());
sb.Append("D");
}
if (Hours != 0 || Minutes != 0 || Seconds != 0 || Millis != 0)
{
sb.Append("T");
}
if (Hours != 0)
{
sb.Append(Hours.ToString());
sb.Append("H");
}
if (Minutes != 0)
{
sb.Append(Minutes.ToString());
sb.Append("M");
}
if (Seconds != 0 || Millis != 0)
{
sb.Append(Seconds.ToString());
if (Millis != 0)
{
sb.Append(".");
sb.Append(Millis.ToString("000"));
}
sb.Append("S");
}
return(sb.ToString());
}
//check if the checkboxes have been clicked
private void AllDates_CheckedChanged(object sender, EventArgs e)
{
if (All_dates.Checked == true)
{
allDates = true;
Weeks.ClearSelected();
Weeks.SelectionMode = SelectionMode.None;
}
else
{
allDates = false;
Weeks.SelectionMode = SelectionMode.One;
All_selected.Checked = false;
}
}
public void ScrollTo(Weeks week, int year = -1)
{
if (year != -1)
{
this.Year = year;
}
else if ((int)week < (int)Now)
{
this.Year++;
}
Now = week;
OnTimeChanged?.Invoke();
}
public override int GetHashCode()
{
unchecked
{
var hashCode = Years.GetHashCode();
hashCode = (hashCode * 397) ^ Months.GetHashCode();
hashCode = (hashCode * 397) ^ Weeks.GetHashCode();
hashCode = (hashCode * 397) ^ Days.GetHashCode();
hashCode = (hashCode * 397) ^ Hours.GetHashCode();
hashCode = (hashCode * 397) ^ Minutes.GetHashCode();
hashCode = (hashCode * 397) ^ Seconds.GetHashCode();
hashCode = (hashCode * 397) ^ Milliseconds.GetHashCode();
return(hashCode);
}
}
/// <summary>
/// Returns the hash code for this instance.
/// </summary>
/// <returns>A 32-bit signed integer that is the hash code for this instance.</returns>
public override int GetHashCode()
{
unchecked
{
int hash = (int)2166136261;
hash = (hash * 16777619) ^ Years.GetHashCode();
hash = (hash * 16777619) ^ Months.GetHashCode();
hash = (hash * 16777619) ^ Weeks.GetHashCode();
hash = (hash * 16777619) ^ Days.GetHashCode();
hash = (hash * 16777619) ^ Hours.GetHashCode();
hash = (hash * 16777619) ^ Minutes.GetHashCode();
hash = (hash * 16777619) ^ Seconds.GetHashCode();
return(hash);
}
}
/// <summary>
/// 更具传进来的时间设置课表时间
/// </summary>
public void SetTime()
{
isGetSpecific = true;
if (EduTime != null)
{
var yearIndex = ShoolYears.IndexOf(EduTime.SchoolYear);
SelectedSchoolYearIndex = yearIndex;
var termIndex = Terms.IndexOf(EduTime.Term);
SelectedTermIndex = termIndex;
var weekIndex = Weeks.IndexOf(EduTime.Week);
SelectedWeekIndex = weekIndex;
}
isGetSpecific = false;
}
