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();
}
