public JsonResult SaveEvent(Event e) { var status = false; using (CalendarDatabaseEntities dc = new CalendarDatabaseEntities()) { if (e.EventID > 0) { //Update the event var v = dc.Events.FirstOrDefault(a => a.EventID == e.EventID); if (v != null) { v.Subject = e.Subject; v.Start = e.Start; v.End = e.End; v.Description = e.Description; v.IsFullDay = e.IsFullDay; v.ThemeColor = e.ThemeColor; } } else { dc.Events.Add(e); } dc.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult GetEvents() { using (CalendarDatabaseEntities dc = new CalendarDatabaseEntities()) { var events = dc.Events.ToList(); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult DeleteEvent(int eventId) { var status = false; using (CalendarDatabaseEntities dc = new CalendarDatabaseEntities()) { var v = dc.Events.FirstOrDefault(a => a.EventID == eventId); if (v != null) { dc.Events.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public MainWindowViewModel() { this.databaseContext = new CalendarDatabaseEntities(); if (!this.databaseContext.DatabaseExists()) { //this.databaseContext.CreateDatabase(); SqlConnection connection = new SqlConnection(@"server=X51RL-PC;Trusted_Connection=Yes;"); using (connection) { string sqlQuery = string.Format(@" CREATE DATABASE [NTR2017] ON PRIMARY ( NAME=Calendar_data, FILENAME = '{0}\Calendar_data.mdf' ) LOG ON ( NAME=Calendar_log, FILENAME = '{0}\Calendar_log.ldf' )", @"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA" ); SqlCommand command = new SqlCommand(sqlQuery, connection); command.Connection.Open(); command.ExecuteNonQuery(); } Console.WriteLine("New calendar database created"); } WindowColor = new SolidColorBrush(Color.FromRgb(255, 255, 255)); GeneralLabelColor = new SolidColorBrush(Color.FromRgb(198, 179, 255)); ButtonColor = new SolidColorBrush(Color.FromRgb(152, 230, 230)); DayLabelColor = new SolidColorBrush(Color.FromRgb(173, 235, 173)); MarkedDayLabelColor = new SolidColorBrush(Color.FromRgb(255, 153, 153)); int currentDayOfYear = Model.Calendar.getInstance().dateTime.DayOfYear; for (int i = 0; i < 4; i++) { weekLabelsArray[i] = "W" + ((currentDayOfYear / 7) + i + 1).ToString() + "\n2017"; } Model.Calendar.getInstance().NormalizeWeek(); for (int i = 0; i < 28; i++) { dayLabelsArray[i] = Model.Calendar.getInstance().Months[Model.Calendar.getInstance().dateTime.Month - 1] + " " + Model.Calendar.getInstance().dateTime.Day.ToString(); if (Model.Calendar.getInstance().dateTime.CompareTo(Model.Calendar.getInstance().currentDateTime) == 0) { this.DayLabelBackgroundsArray.SetValue(MarkedDayLabelColor, i); } else { this.DayLabelBackgroundsArray.SetValue(DayLabelColor, i); } Model.Calendar.getInstance().dateTime = Model.Calendar.getInstance().dateTime.AddDays(1); } Model.Calendar.getInstance().dateTime = Model.Calendar.getInstance().dateTime.AddDays(-28); EditEventCommandInstance = new EditEventCommand(); }