public DayEvent SaveOrUpdate(DayEvent oDayEvent)
{
_oDayEvent = new DayEvent();
try
{
string sql = string.Format(@"insert into DayEvent(Note, EventDate) values ('{0}', '{1}')", (oDayEvent.Note, oDayEvent.EventDate));
using (MySqlConnection con = new MySqlConnection(Configuration.GetConnectionString("default")))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
var oDayEvents = con.Query <DayEvent>(sql);
if (oDayEvents != null && oDayEvents.Count() > 0)
{
_oDayEvent = oDayEvents.FirstOrDefault();
}
}
}
catch (Exception ex)
{
_oDayEvent.Message = ex.Message;
}
return(_oDayEvent);
}
public void ReadEventsFromFile()
{
String inputString = "";
int character;
using (FileStream fileStream = File.OpenRead(filePath))
{
while ((character = fileStream.ReadByte()) != -1)
{
//Console.WriteLine(character);
if (character != '\r')
{
inputString += (char)character;
}
else // character == '\r'
{
//Console.WriteLine("lolol");
fileStream.ReadByte();
DayEvent newDayEvent = new DayEvent(
inputString.Substring(23, inputString.Length - 23),
new DateTime(Int32.Parse(inputString.Substring(6, 4)), Int32.Parse(inputString.Substring(3, 2)), Int32.Parse(inputString.Substring(0, 2)), Int32.Parse(inputString.Substring(11, 2)), Int32.Parse(inputString.Substring(14, 2)), 1),
new DateTime(Int32.Parse(inputString.Substring(6, 4)), Int32.Parse(inputString.Substring(3, 2)), Int32.Parse(inputString.Substring(0, 2)), Int32.Parse(inputString.Substring(17, 2)), Int32.Parse(inputString.Substring(20, 2)), 1)
);
CalendarWithBase.Model.Calendar.getInstance().dayEventsList.Add(newDayEvent);
inputString = "";
}
}
}
}
public DayEvent GetEvent(DateTime eventDate)
{
_oDayEvent = new DayEvent();
using (MySqlConnection con = new MySqlConnection(Configuration.GetConnectionString("default")))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sql = string.Format(@"SELECT * FROM DayEvent WHERE EventDate = '{0}'", eventDate.ToString("yyyy-MM-dd"));
var oDayEvents = con.Query <DayEvent>(sql).ToList();
if (oDayEvents != null && oDayEvents.Count() > 0)
{
_oDayEvent = oDayEvents[oDayEvents.Count() - 1];
_oDayEvent.FromDate = eventDate;
_oDayEvent.ToDate = eventDate;
}
else
{
_oDayEvent.EventDate = eventDate;
_oDayEvent.FromDate = eventDate;
_oDayEvent.ToDate = eventDate;
}
}
return(_oDayEvent);
}
public bool CreateEvent(string title, string category, DateTime time, string description, string location, int sourceId)
{
int id = 0;
if (Cache.Events.Any())
{
id = Cache.Events.Max(x => x.Id) + 1;
}
var dayEvent = new DayEvent
{
Id = id,
Category = category,
Description = description,
Location = location,
Time = time,
Title = title
};
Cache.Events.Add(dayEvent);
Cache.SourceEvents.Add(new SourceEvent
{
EventId = id,
SourceId = sourceId
});
return(true);
}
public string Delete(int id)
{
string message = "";
try
{
_oDayEvent = new DayEvent()
{
id = id
};
using (MySqlConnection con = new MySqlConnection(Configuration.GetConnectionString("default")))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
var oDayEvents = con.Query <DayEvent>("Foglalt",
this.SetParameters(_oDayEvent, (int)OperationType.Delete),
commandType: CommandType.StoredProcedure);
message = "Deleted";
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(message);
}
void Start()
{
IT = GameObject.FindObjectOfType <ItemTrack>();
Cs = GameObject.FindObjectOfType <ChangeScene>();
Ps = GameObject.FindObjectOfType <PlayerScript>();
DE = GameObject.FindObjectOfType <DayEvent>();
}
private void ReadPersonEventsFromDatabaseToList()
{
//DayEvents[] dayEventsArray = databaseContext.DayEvents.ToArray();
DayEvent dayEvent;
Appointment searchedAppointment;
Guid appointmentID;
for (int i = 0; i < Models.Calendar.getInstance().databaseContext.Attendances.Count(); i++)
{
if (Models.Calendar.getInstance().databaseContext.Attendances.AsEnumerable().ElementAt(i).PersonID == Models.Calendar.currentPerson.PersonID)
{
appointmentID = Models.Calendar.getInstance().databaseContext.Attendances.AsEnumerable().ElementAt(i).AppointmentID;
searchedAppointment = Models.Calendar.getInstance().databaseContext.Appointments.First<Appointment>(
appointment => appointment.AppointmentID == appointmentID);
dayEvent = new DayEvent(searchedAppointment.Title, searchedAppointment.Description,
new DateTime(searchedAppointment.AppointmentDate.Year, searchedAppointment.AppointmentDate.Month, searchedAppointment.AppointmentDate.Day, searchedAppointment.StartTime.Hours, searchedAppointment.StartTime.Minutes, 1),
new DateTime(searchedAppointment.AppointmentDate.Year, searchedAppointment.AppointmentDate.Month, searchedAppointment.AppointmentDate.Day, searchedAppointment.EndTime.Hours, searchedAppointment.EndTime.Minutes, 1)
);
Models.Calendar.getInstance().dayEventsList.Add(dayEvent);
}
}
Models.Calendar.getInstance().dayEventsList.Sort(new DayEventsComparer());
}
public void ReadEventsFromFile()
{
String inputString = "";
int character;
using (FileStream fileStream = File.OpenRead(filePath))
{
while ((character = fileStream.ReadByte()) != -1)
{
//Console.WriteLine(character);
if (character != '\r')
{
inputString += (char)character;
}
else // character == '\r'
{// uwaga na to ze jest dodatkowy argument - tytul zdarzenia
fileStream.ReadByte();
DayEvent newDayEvent = new DayEvent("",
inputString.Substring(23, inputString.Length - 23),
new DateTime(Int32.Parse(inputString.Substring(6, 4)), Int32.Parse(inputString.Substring(3, 2)), Int32.Parse(inputString.Substring(0, 2)), Int32.Parse(inputString.Substring(11, 2)), Int32.Parse(inputString.Substring(14, 2)), 1),
new DateTime(Int32.Parse(inputString.Substring(6, 4)), Int32.Parse(inputString.Substring(3, 2)), Int32.Parse(inputString.Substring(0, 2)), Int32.Parse(inputString.Substring(17, 2)), Int32.Parse(inputString.Substring(20, 2)), 1)
);
Models.Calendar.getInstance().dayEventsList.Add(newDayEvent);
inputString = "";
}
}
}
}
private void Adapter_ItemClick(object sender, DayEvent e)
{
Intent i = new Intent(ApplicationContext, typeof(ViewEvent));
i.PutExtra("ID", e.Id);
StartActivity(i);
}
private void saveButton_Click(object sender, RoutedEventArgs e)
{
DayEvent dayEvent = new DayEvent(this.descriptionTextBox.Text,
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, this.startHourComboBox.SelectedIndex, this.startMinuteComboBox.SelectedIndex, 1),
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, this.endHourComboBox.SelectedIndex, this.endMinuteComboBox.SelectedIndex, 1));
if (Model.Calendar.getInstance().dayEventsList.BinarySearch(dayEvent, new DayEventsComparer()) >= 0)
{
MessageBox.Show("To zdarzenie istnieje już w kalendarzu");
return;
}
Model.Calendar.getInstance().dayEventsList.Add(dayEvent);
Model.Calendar.getInstance().dayEventsList.Sort(new DayEventsComparer());
ViewModel.MainWindowViewModel.getInstance().DisplayEvents();
//DiskInputOutput.DiskManager.getInstance().WriteEventsToFile();
DayEvents dayEventInDataBase = new DayEvents()
{
username = ViewModel.MainWindowViewModel.getInstance().username,
eventDescription = dayEvent.GetDescription(),
startTime = dayEvent.GetStartTime(),
endTime = dayEvent.GetEndTime()
};
ViewModel.MainWindowViewModel.getInstance().databaseContext.DayEvents.AddObject(dayEventInDataBase);
ViewModel.MainWindowViewModel.getInstance().databaseContext.SaveChanges();
this.Close();
}
private DynamicParameters SetParameters(DayEvent oDayEvent, int operationType)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@DayEventId", oDayEvent.id);
parameters.Add("@Note", oDayEvent.Note);
parameters.Add("@EventDate", oDayEvent.EventDate);
parameters.Add("@OperationType", operationType);
return(parameters);
}
private void SelectedDayChangeEvent(Day sender, DayEvent dayEvent)
{
if (_lastChooseDayControl != sender)
{
if (_lastChooseDayControl != null)
{
_lastChooseDayControl.BackColor = Color.FromArgb(67, 67, 67);
_lastChooseDayControl.ForeColor = Color.White;
}
_lastChooseDayControl = sender;
}
}
private void saveButton_Click(object sender, RoutedEventArgs e)
{
DayEvent dayEvent = new DayEvent(this.descriptionTextBox.Text,
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, this.startHourComboBox.SelectedIndex, this.startMinuteComboBox.SelectedIndex, 1),
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, this.endHourComboBox.SelectedIndex, this.endMinuteComboBox.SelectedIndex, 1));
Calendar.Model.Calendar.getInstance().dayEventsList.Add(dayEvent);
Calendar.Model.Calendar.getInstance().dayEventsList.Sort(new DayEventsComparer());
Calendar.ViewModel.MainWindowViewModel.getInstance().DisplayEvents();
DiskInputOutput.DiskManager.getInstance().WriteEventsToFile();
this.Close();
}
// Use this for initialization
void Awake()
{
days = new List <string>()
{
"Monday", "Tuesday", "Wednesday", "Thursday", "Friday"
};
PauseEvent = Pause;
ClockEvent = UpdateClock;
DescripEvent = UpdateDescrip;
UpdateText = SetText;
FadeDayInEvent = FadeDayIn;
FadeDayOutEvent = FadeDayOut;
}
public List <DayEvent> GetDayEvents()
{
List <DayEvent> eventsToday = new List <DayEvent>();
int amountToday = Random.Range(1, maxEventsPerDay + 1);
for (int i = 0; i < amountToday; i++)
{
DayEvent e = possibleEvents[Random.Range(0, possibleEvents.Count)];
if (!eventsToday.Contains(e))
{
eventsToday.Add(e);
}
}
return(eventsToday);
}
private void Day_Click(object sender, EventArgs e)
{
var dayEventCRUD = DbFactory.DayEventCRUD;
var selectedDay = dayEventCRUD.GetOne("EventDate", _dateTime);
if (selectedDay?._id == null)
{
selectedDay = new DayEvent
{
EventDate = _dateTime
};
}
ForeColor = Color.Black;
BackColor = Color.Goldenrod;
Calendar.SelectedDayChanged?.Invoke(this, selectedDay);
}
public ActionResult AddEvent(DayEventForm dayEventForm, String parameter)
{
DateTime startTime = new DateTime(Models.Calendar.getInstance().dateTime.Year, Models.Calendar.getInstance().dateTime.Month, Models.Calendar.getInstance().dateTime.Day, dayEventForm.StartHour, dayEventForm.StartMinute, 1);
DateTime endTime = new DateTime(Models.Calendar.getInstance().dateTime.Year, Models.Calendar.getInstance().dateTime.Month, Models.Calendar.getInstance().dateTime.Day, dayEventForm.EndHour, dayEventForm.EndMinute, 1);
startTime = startTime.AddDays(dayEventForm.chosenDayNumber);
endTime = endTime.AddDays(dayEventForm.chosenDayNumber);
if (dayEventForm.StartHour > dayEventForm.EndHour)
return View("AddEvent"); // zdarzenie ma wczesniejszy koniec niz rozpoczecie
if ((dayEventForm.StartHour == dayEventForm.EndHour) && (dayEventForm.StartMinute > dayEventForm.EndMinute))
return View("AddEvent"); // zdarzenie ma wczesniejszy koniec niz rozpoczecie
DayEvent dayEvent = new DayEvent(dayEventForm.Title, dayEventForm.Description, startTime, endTime);
if (Models.Calendar.getInstance().dayEventsList.BinarySearch(dayEvent, new DayEventsComparer()) >= 0)
return View("AddEvent");
Models.Calendar.getInstance().dayEventsList.Add(dayEvent);
Models.Calendar.getInstance().dayEventsList.Sort(new DayEventsComparer());
Appointment newAppointment = new Appointment()
{
AppointmentID = Guid.NewGuid(),
Title = dayEventForm.Title,
Description = dayEventForm.Description,
AppointmentDate = new DateTime(startTime.Year, startTime.Month, startTime.Day),
StartTime = new TimeSpan(dayEventForm.StartHour, dayEventForm.StartMinute, 1),
EndTime = new TimeSpan(dayEventForm.EndHour, dayEventForm.EndMinute, 1)
};
Attendance newAttendance = new Attendance()
{
AppointmentID = newAppointment.AppointmentID,
PersonID = Models.Calendar.currentPerson.PersonID,
Accepted = true,
AttendanceID = Guid.NewGuid(),
};
Models.Calendar.getInstance().databaseContext.Appointments.Add(newAppointment);
Models.Calendar.getInstance().databaseContext.Attendances.Add(newAttendance);
Models.Calendar.getInstance().databaseContext.SaveChanges();
return RedirectToAction("Calendar", "Calendar"); //return View("Calendar", Models.Calendar.getInstance());
}
void Start()
{
PS = GameObject.FindObjectOfType <PlayerScript>();
IT = GameObject.FindObjectOfType <ItemTrack>();
C = GameObject.FindObjectOfType <Computer>();
DE = GameObject.FindObjectOfType <DayEvent>();
unlockLevel.text = "Level " + levelNeed;
if (IT.workList.Contains(workName))
{
isFinish = true;
}
if (isFinish)
{
Finish.SetActive(true);
}
}
private void StackPanel1_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
clickCounts[0] = (short)((clickCounts[0] + 1) % 2);
if (clickCounts[0] == 0)
{
DateTime chosenDate = CalendarWithBase.Model.Calendar.getInstance().dateTime;
Label chosenDayLabel = (Label)e.Source;
String chosenDayLabelContent = (String)chosenDayLabel.Content;
DayEvent chosenDayEvent = new DayEvent(
chosenDayLabelContent.Substring(12, chosenDayLabelContent.Length - 12),
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, Int32.Parse(chosenDayLabelContent.Substring(0, 2)), Int32.Parse(chosenDayLabelContent.Substring(3, 2)), 1),
new DateTime(chosenDate.Year, chosenDate.Month, chosenDate.Day, Int32.Parse(chosenDayLabelContent.Substring(6, 2)), Int32.Parse(chosenDayLabelContent.Substring(9, 2)), 1)
);
EditEventWindow editEventWindow = new EditEventWindow(chosenDayEvent);
editEventWindow.ShowDialog();
}
}
public void ReadAllUserEventsFromDatabaseToList()
{
//DayEvents[] dayEventsArray = databaseContext.DayEvents.ToArray();
DayEvent dayEvent;
for (int i = 0; i < databaseContext.DayEvents.Count(); i++)
{
if (databaseContext.DayEvents.AsEnumerable().ElementAt(i).username == this.username)
{
dayEvent = new DayEvent(
databaseContext.DayEvents.AsEnumerable().ElementAt(i).eventDescription,
databaseContext.DayEvents.AsEnumerable().ElementAt(i).startTime,
databaseContext.DayEvents.AsEnumerable().ElementAt(i).endTime);
CalendarWithBase.Model.Calendar.getInstance().dayEventsList.Add(dayEvent);
}
}
CalendarWithBase.Model.Calendar.getInstance().dayEventsList.Sort(new DayEventsComparer());
}
public EditEventWindow(DayEvent chosenDayEvent)
{
InitializeComponent();
this.chosenDayEvent = chosenDayEvent;
for (int i = 0; i < 24; i++)
{
this.startHourComboBox.Items.Add(i.ToString());
this.endHourComboBox.Items.Add(i.ToString());
}
for (int i = 0; i < 60; i++)
{
this.startMinuteComboBox.Items.Add(i.ToString());
this.endMinuteComboBox.Items.Add(i.ToString());
}
this.descriptionTextBox.Text = chosenDayEvent.GetDescription();
this.startHourComboBox.SelectedIndex = chosenDayEvent.GetStartTime().Hour;
this.startMinuteComboBox.SelectedIndex = chosenDayEvent.GetStartTime().Minute;
this.endHourComboBox.SelectedIndex = chosenDayEvent.GetEndTime().Hour;
this.endMinuteComboBox.SelectedIndex = chosenDayEvent.GetEndTime().Minute;
}
// Use this for initialization
void Start()
{
_tod = DayEvent.Idle;
transAmbient = dayAmbient;
dayCycleInSeconds = dayCycleInMinutes * Minute;
startTimeInHours = Mathf.Clamp(startTimeInHours, 0, 23);
timeOfDay = dayCycleInSeconds * (startTimeInHours / 24);
degreeRot = DegreesPerSecond * Day / dayCycleInSeconds;
RenderSettings.skybox.SetFloat ("_Blend", 0);
//sunRise = sunRiseDecimal * dayCycleInSeconds;
//sunSet = sunSetDecimal * dayCycleInSeconds;
sunAngle = 360 * (timeOfDay / dayCycleInSeconds) - 90;
if (sunAngle < 0)
sunAngle = sunAngle + 360;
if ((sunAngle + 180) > 360) {
moonAngle = (sunAngle + 180) - 360;
} else {
moonAngle = sunAngle + 180;
}
sun.localRotation = Quaternion.Euler(sunAngle, 0, 0);
moon.localRotation = Quaternion.Euler(moonAngle, 0, 0);
RenderSettings.ambientLight = dayAmbient;
}
// Update is called once per frame
void Update()
{
sunAngle = sunAngle + (degreeRot * Time.deltaTime);
moonAngle = moonAngle + (degreeRot * Time.deltaTime);
if (sunAngle > 360)
sunAngle = sunAngle - 360;
if (sunAngle < 0)
sunAngle = sunAngle + 360;
if (moonAngle > 360)
moonAngle = moonAngle - 360;
if (moonAngle < 0)
moonAngle = moonAngle + 360;
sun.localRotation = Quaternion.Euler(sunAngle, 0, 0);
moon.localRotation = Quaternion.Euler(moonAngle, 0, 0);
//Debug.Log(sunAngle);
timeOfDay += Time.deltaTime;
if (timeOfDay > dayCycleInSeconds) {
timeOfDay -= dayCycleInSeconds;
dayCount++;
Debug.Log ("Day " +dayCount);
}
if (sunAngle > sunRiseStart && sunAngle < sunRiseEnd) {
_tod = GameTime.DayEvent.SunRise;
BlendSky();
} else if (sunAngle > sunRiseEnd && sunAngle < sunSetStart) {
_tod = GameTime.DayEvent.Daytime;
BlendSky();
} else if (sunAngle > sunSetStart && sunAngle < sunSetEnd) {
_tod = GameTime.DayEvent.SunSet;
BlendSky();
} else if (sunAngle > sunSetEnd && sunAngle < sunRiseStart) {
_tod = GameTime.DayEvent.Nighttime;
BlendSky();
} else {
_tod = GameTime.DayEvent.Idle;
}
// Hud Clock
float clockTimeInSeconds = Day * (timeOfDay / dayCycleInSeconds);
float clockTimeInHours = Mathf.Floor(clockTimeInSeconds / Hour);
float clockTimeInMinutes = Mathf.Floor((clockTimeInSeconds - (clockTimeInHours * Hour)) / 60);
string hudHours = clockTimeInHours.ToString();
string hudMinutes = clockTimeInMinutes.ToString();
if (clockTimeInHours < 10) {
hudHours = "0"+ hudHours;
}
if (clockTimeInMinutes < 10) {
hudMinutes = "0"+ hudMinutes;
}
clockText = hudHours + ":" + hudMinutes;
}
void Start()
{
PS = GameObject.FindObjectOfType <PlayerScript>();
DE = GameObject.FindObjectOfType <DayEvent>();
C = GameObject.FindObjectOfType <Computer>();
}
public static void Initialize(DataContext context)
{
context.Database.EnsureCreated();
// Look for any clubs.
if (context.Clubs.Any())
{
return; // DB has been seeded
}
var clubs = new Club[]
{
new Club {
ClubID = 1, StravaClubID = 238810, Name = "SMITE", Location = "Volcano", Country = "Watopia"
},
new Club {
ClubID = 2, StravaClubID = 238810, Name = "SMITE-London", Location = "Radio Tower", Country = "Watopia"
},
new Club {
ClubID = 3, StravaClubID = 238810, Name = "SMITE-Watopia", Location = "Hank's House", Country = "Watopia"
}
};
foreach (Club club in clubs)
{
context.Clubs.Add(club);
}
context.SaveChanges();
// Look for any seasons.
if (context.Seasons.Any())
{
return; // DB has been seeded
}
var seasons = new Season[]
{
new Season {
SeasonID = 1, ClubID = 1, Start_date = DateTime.Now, End_date = DateTime.Now, Keyword = "smite"
},
new Season {
SeasonID = 2, ClubID = 2, Start_date = DateTime.Now, End_date = DateTime.Now, Keyword = "london"
},
new Season {
SeasonID = 3, ClubID = 3, Start_date = DateTime.Now, End_date = DateTime.Now, Keyword = "watopia"
}
};
foreach (Season season in seasons)
{
context.Seasons.Add(season);
}
context.SaveChanges();
// Look for any events.
if (context.DayEvents.Any())
{
return; // DB has been seeded
}
var dayevents = new DayEvent[]
{
new DayEvent {
DayEventID = 1, Date = DateTime.Now, SeasonID = 1
},
new DayEvent {
DayEventID = 2, Date = DateTime.Now, SeasonID = 2
},
new DayEvent {
DayEventID = 3, Date = DateTime.Now, SeasonID = 3
},
new DayEvent {
DayEventID = 4, Date = DateTime.Now, SeasonID = 1
}
};
foreach (DayEvent dayevent in dayevents)
{
context.DayEvents.Add(dayevent);
}
context.SaveChanges();
// Look for any segments.
if (context.Segments.Any())
{
return; // DB has been seeded
}
var segments = new Segment[]
{
new Segment {
SegmentID = 13855855, Name = "s1", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 14485439, Name = "s2", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 13521759, Name = "s3", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 14250115, Name = "s4", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 14063868, Name = "s5", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 13619366, Name = "s6", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16730849, Name = "s7", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16730862, Name = "s8", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16730897, Name = "s9", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16730888, Name = "s10", Type = "polka", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16936841, Name = "s11", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
},
new Segment {
SegmentID = 16730909, Name = "s12", Type = "green", World = "watopia", Distance = 1, Average_grade = 3, Total_elevation_gain = 2, Star_count = 1
}
};
foreach (Segment segment in segments)
{
context.Segments.Add(segment);
}
context.SaveChanges();
// Look for any eventsegments.
if (context.DayEventSegments.Any())
{
return; // DB has been seeded
}
var eventsegments = new DayEventSegment[]
{
new DayEventSegment {
DayEventID = 1, SegmentID = 13855855
},
new DayEventSegment {
DayEventID = 1, SegmentID = 14485439
},
new DayEventSegment {
DayEventID = 1, SegmentID = 13521759
},
new DayEventSegment {
DayEventID = 1, SegmentID = 14250115
},
new DayEventSegment {
DayEventID = 2, SegmentID = 14063868
},
new DayEventSegment {
DayEventID = 2, SegmentID = 13619366
},
new DayEventSegment {
DayEventID = 3, SegmentID = 16730849
},
new DayEventSegment {
DayEventID = 3, SegmentID = 16730862
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16730849
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16730862
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16730897
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16730888
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16936841
},
new DayEventSegment {
DayEventID = 4, SegmentID = 16730909
}
};
foreach (DayEventSegment eventsegment in eventsegments)
{
context.DayEventSegments.Add(eventsegment);
}
context.SaveChanges();
}
public ActionResult EditEvent(DayEventForm dayEventForm, String parameter)
{
DateTime eventDate = new DateTime(Models.Calendar.getInstance().dateTime.Year, Models.Calendar.getInstance().dateTime.Month, Models.Calendar.getInstance().dateTime.Day);
eventDate = eventDate.AddDays(dayEventForm.chosenDayNumber);
DateTime startTime = new DateTime(eventDate.Year, eventDate.Month, eventDate.Day, Models.DayEventForm.getInstance().StartHour, Models.DayEventForm.getInstance().StartMinute, 1);
DateTime endTime = new DateTime(eventDate.Year, eventDate.Month, eventDate.Day, Models.DayEventForm.getInstance().EndHour, Models.DayEventForm.getInstance().EndMinute, 1);
TimeSpan previousStartTimeSpan = new TimeSpan(startTime.Hour, startTime.Minute, 1);
TimeSpan previousEndTimeSpan = new TimeSpan(endTime.Hour, endTime.Minute, 1);
TimeSpan newStartTimeSpan = new TimeSpan(dayEventForm.StartHour, dayEventForm.StartMinute, 1);
TimeSpan newEndTimeSpan = new TimeSpan(dayEventForm.EndHour, dayEventForm.EndMinute, 1);
String previousEventTitle = Models.DayEventForm.getInstance().Title;
String previousEventDescription = Models.DayEventForm.getInstance().Description;
String newEventDescription = dayEventForm.Description;
String newEventTitle = dayEventForm.Title;
if (dayEventForm.StartHour > dayEventForm.EndHour)
return View("EditEvent"); // zdarzenie ma wczesniejszy koniec niz rozpoczecie
if ((dayEventForm.StartHour == dayEventForm.EndHour) && (dayEventForm.StartMinute > dayEventForm.EndMinute))
return View("EditEvent"); // zdarzenie ma wczesniejszy koniec niz rozpoczecie
DayEvent chosenDayEvent = new DayEvent(previousEventTitle, previousEventDescription, startTime, endTime);
if (this.HttpContext.Request.Form["submitButton"] == "Edit event")
{
int index = Models.Calendar.getInstance().dayEventsList.BinarySearch(chosenDayEvent, new DayEventsComparer());
((DayEvent)Models.Calendar.getInstance().dayEventsList[index]).SetTitle(newEventTitle);
((DayEvent)Models.Calendar.getInstance().dayEventsList[index]).SetDescription(newEventDescription);
((DayEvent)Models.Calendar.getInstance().dayEventsList[index]).SetStartTime(new DateTime(eventDate.Year, eventDate.Month, eventDate.Day, dayEventForm.StartHour, dayEventForm.StartMinute, 1));
((DayEvent)Models.Calendar.getInstance().dayEventsList[index]).SetEndTime(new DateTime(eventDate.Year, eventDate.Month, eventDate.Day, dayEventForm.EndHour, dayEventForm.EndMinute, 1));
Appointment searchedAppointment;
Guid appointmentID;
for (int i = 0; i < Models.Calendar.getInstance().databaseContext.Attendances.Count(); i++)
{
if (Models.Calendar.getInstance().databaseContext.Attendances.AsEnumerable().ElementAt(i).PersonID == Models.Calendar.currentPerson.PersonID)
{
appointmentID = Models.Calendar.getInstance().databaseContext.Attendances.AsEnumerable().ElementAt(i).AppointmentID;
searchedAppointment = Models.Calendar.getInstance().databaseContext.Appointments.FirstOrDefault<Appointment>(
appointment => appointment.AppointmentID == appointmentID && appointment.Title == previousEventTitle &&
appointment.Description == previousEventDescription && appointment.AppointmentDate == eventDate &&
appointment.StartTime.Hours == previousStartTimeSpan.Hours && appointment.StartTime.Minutes == previousStartTimeSpan.Minutes &&
appointment.EndTime.Hours == previousEndTimeSpan.Hours && appointment.EndTime.Minutes == previousEndTimeSpan.Minutes);
if (searchedAppointment != null)
{
searchedAppointment.Title = newEventTitle;
searchedAppointment.Description = newEventDescription;
searchedAppointment.StartTime = newStartTimeSpan;
searchedAppointment.EndTime = newEndTimeSpan;
}
}
}
Models.Calendar.getInstance().databaseContext.SaveChanges();
}
else if (this.HttpContext.Request.Form["submitButton"] == "Remove event")
{
//for(int i = 0; i < )
int index = Models.Calendar.getInstance().dayEventsList.BinarySearch(chosenDayEvent, new DayEventsComparer());
Models.Calendar.getInstance().dayEventsList.RemoveAt(index);
Appointment appointmentToRemove = Models.Calendar.getInstance().databaseContext.Appointments.First<Appointment>(
appointment => appointment.Title == previousEventTitle &&
appointment.Description == previousEventDescription &&
appointment.AppointmentDate == eventDate &&
appointment.StartTime.Hours == previousStartTimeSpan.Hours &&
appointment.StartTime.Minutes == previousStartTimeSpan.Minutes &&
appointment.EndTime.Hours == previousEndTimeSpan.Hours &&
appointment.EndTime.Minutes == previousEndTimeSpan.Minutes);
Attendance attendanceToRemove = Models.Calendar.getInstance().databaseContext.Attendances.First<Attendance>(
attendance => attendance.AppointmentID == appointmentToRemove.AppointmentID);
Models.Calendar.getInstance().databaseContext.Attendances.Remove(attendanceToRemove);
Models.Calendar.getInstance().databaseContext.Appointments.Remove(appointmentToRemove);
Models.Calendar.getInstance().databaseContext.SaveChanges();
}
return RedirectToAction("Calendar", "Calendar");//return View("EditEvent", dayEventForm); //return View("Calendar", Models.Calendar.getInstance());
}
public void OnDayPassed()
{
Debug.Log("Day passed");
DayEvent?.Invoke(this, new TimerEventArgs(this));
}
private void SelectedDayChanged(object sender, DayEvent dayEvent)
{
_currentDayEvent = dayEvent;
EventViewer.Object = null;
RefreshLists();
}
