/// <summary>
/// default controller action
/// </summary>
/// <returns>home index view</returns>
public HomeController(UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, IConfiguration configuration, ScheduleDBContext context)
{
_context = context;
_userManager = userManager;
_signInManager = signInManager;
Configuration = configuration;
_context = context;
}
public void GetScheduleByIDOnNonExistantSchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest7");
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetScheduleByID(1);
Assert.Null(result);
}
public void CanDeleteSchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest29");
Schedule schedule = new Schedule
{
UserID = "bob",
Title = "bob's to do list"
};
context.Schedules.Add(schedule);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
devSchedule.DeleteSchedule(schedule);
Assert.Empty(context.Schedules);
}
public void CanGetScheduleByID()
{
ScheduleDBContext context = MakeContext("devscheduletest6");
Schedule schedule = new Schedule
{
UserID = "testUser",
Title = "test"
};
context.Schedules.Add(schedule);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetScheduleByID(schedule.ID);
Assert.Equal(schedule, result);
ResetContext(context);
}
public void GetAllScheduleItemsInEmptySchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest4");
Schedule schedule = new Schedule
{
UserID = "testUser",
Title = "test"
};
context.Schedules.Add(schedule);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetAllScheduleItems(schedule.ID);
Assert.Null(result);
ResetContext(context);
}
public void CanCreateSchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest1");
DevSchedule devSchedule = new DevSchedule(context);
Schedule schedule = new Schedule
{
UserID = "testUser",
Title = "test"
};
devSchedule.CreateSchedule(schedule);
Schedule test = (from s in context.Schedules
where s.Title == "test"
select s).First();
Assert.NotNull(test);
ResetContext(context);
}
public void CanDeleteScheduleItem()
{
ScheduleDBContext context = MakeContext("devscheduletest30");
ScheduleItem item = new ScheduleItem
{
Title = "mow the lawn",
Description = "the grass is too long! time to mow it",
StartTime = new DateTime(2018, 8, 31),
Length = new TimeSpan(2, 0, 0),
};
context.ScheduleItems.Add(item);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
devSchedule.DeleteScheduleItem(item);
Assert.Empty(context.ScheduleItems);
}
public void CanGetScheduleItemByID()
{
ScheduleDBContext context = MakeContext("devscheduletest8");
ScheduleItem item = new ScheduleItem
{
Title = "test",
StartTime = DateTime.Now,
Length = new TimeSpan(0, 0, 0),
Days = 0,
Description = "test item for testing",
};
context.ScheduleItems.Add(item);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetScheduleItemByID(item.ID);
Assert.Equal(item, result);
ResetContext(context);
}
public void CanCreateScheduleItem()
{
ScheduleDBContext context = MakeContext("devscheduletest2");
DevSchedule devSchedule = new DevSchedule(context);
ScheduleItem scheduleItem = new ScheduleItem
{
Title = "test",
StartTime = DateTime.Now,
Length = new TimeSpan(0, 0, 0),
Days = 0,
Description = "test item for testing"
};
devSchedule.CreateScheduleItem(scheduleItem);
ScheduleItem test = (from i in context.ScheduleItems
where i.Title == "test"
select i).First();
Assert.NotNull(test);
ResetContext(context);
}
public void CanUpdateSchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest21");
Schedule schedule = new Schedule
{
UserID = "bob",
Title = "bob's tod do list"
};
context.Schedules.Add(schedule);
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
Schedule updatedSchedule = new Schedule
{
Title = "bob's to do list"
};
devSchedule.UpdateSchedule(schedule.ID, updatedSchedule);
Assert.Equal(updatedSchedule.Title, schedule.Title);
ResetContext(context);
}
public void CanDeleteAllUserSchedules()
{
ScheduleDBContext context = MakeContext("devscheduletest27");
context.Schedules.AddRange(
new Schedule
{
UserID = "bob",
Title = "bob's chores"
},
new Schedule
{
UserID = "bob",
Title = "bob's homework"
});
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
devSchedule.DeleteAllUserSchedules("bob");
Assert.Empty(context.Schedules);
}
public void CanGetUserSchedules()
{
ScheduleDBContext context = MakeContext("devscheduletest13");
context.Schedules.AddRange(
new Schedule
{
Title = "My first schedule",
UserID = "abc123"
},
new Schedule
{
Title = "My second schedule",
UserID = "abc123"
});
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetUserSchedules("abc123");
Assert.Equal(2, result.Count);
ResetContext(context);
}
public ActionResult Index()
{
ScheduleDBContext scheduleDbContext = new ScheduleDBContext();
var startTime = scheduleDbContext.Schedules.Where(u => u.ID == 1).FirstOrDefault();
var endTime = scheduleDbContext.Schedules.Where(u => u.ID == 2).FirstOrDefault();
string time = DateTime.Now.ToString("yyyyMMddHHmm");
string startTm = startTime.Year + startTime.Month + startTime.Day + startTime.Hour + startTime.Minute;
string endTm = endTime.Year + endTime.Month + endTime.Day + endTime.Hour + endTime.Minute;
double start = Convert.ToDouble(startTm);
double end = Convert.ToDouble(endTm);
double now = Convert.ToDouble(time);
if (now >= start && now <= end)
{
@ViewData["timeMessage"] = "true";
}
else
{
@ViewData["timeMessage"] = "false";
}
return(View());
}
public void CanGetAllScheduleItems()
{
ScheduleDBContext context = MakeContext("devscheduletest3");
Schedule schedule = new Schedule
{
UserID = "testUser",
Title = "test"
};
context.Schedules.Add(schedule);
context.SaveChanges();
context.ScheduleItems.AddRange(
new ScheduleItem
{
Title = "test",
StartTime = DateTime.Now,
Length = new TimeSpan(0, 0, 0),
Days = 0,
Description = "test item for testing",
ScheduleID = schedule.ID
},
new ScheduleItem
{
Title = "test",
StartTime = DateTime.Now.AddDays(2),
Length = new TimeSpan(1, 30, 0),
Days = (DayFlags)127,
Description = "test item for testing",
ScheduleID = schedule.ID
});
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
var result = devSchedule.GetAllScheduleItems(schedule.ID);
Assert.Equal(2, result.Count);
ResetContext(context);
}
public void CanInsertMalware()
{
//arrange
ScheduleDBContext context = MakeContext("ChatLogTest2");
ChatLog newLog = new ChatLog
{
TimeStamp = DateTime.Now,
Chat = "{'chat': '{insert json malware here}'}"
};
//act
context.Add(newLog);
context.SaveChanges();
var testResult = from x in context.ChatLogs
select x;
//assert
Assert.NotNull(testResult);
//reset
ResetContext(context);
}
public void CanPostChatLog()
{
//arrange
ScheduleDBContext context = MakeContext("ChatLogTest");
ChatLog newLog = new ChatLog
{
TimeStamp = DateTime.Now,
Chat = "This test string."
};
//act
context.Add(newLog);
context.SaveChanges();
var testResult = from x in context.ChatLogs
select x;
//assert
Assert.NotNull(testResult);
//reset
ResetContext(context);
}
public void CanDeleteAllItemsInSchedule()
{
ScheduleDBContext context = MakeContext("devscheduletest25");
Schedule schedule = new Schedule
{
UserID = "bob",
Title = "bob's to do list"
};
context.Schedules.Add(schedule);
context.SaveChanges();
context.ScheduleItems.AddRange(
new ScheduleItem
{
Title = "mow the lawn",
Description = "the grass is too long! time to mow it",
StartTime = new DateTime(2018, 8, 31),
Length = new TimeSpan(2, 0, 0),
ScheduleID = schedule.ID
},
new ScheduleItem
{
Title = "do the laundry",
Description = "it's laundry day",
StartTime = new DateTime(2018, 8, 11),
Length = new TimeSpan(0),
ScheduleID = schedule.ID,
Days = DayFlags.Saturday
});
context.SaveChanges();
DevSchedule devSchedule = new DevSchedule(context);
devSchedule.DeleteAllItemsInSchedule(schedule.ID);
Assert.Empty(context.ScheduleItems);
ResetContext(context);
}
public GroupService()
{
_avnDb = new testttEntities1();
_scheduleDb = new ScheduleDBContext();
}
public DepartmentService()
{
_avnDb = new testttEntities1();
_scheduleDb = new ScheduleDBContext();
}
public DevSchedule(ScheduleDBContext context)
{
_context = context;
}
//sets DbContext to use ScheduleDbContext
public ChatLogController(ScheduleDBContext context)
{
_context = context;
}
public BuildingService()
{
_avnDb = new testttEntities1();
_scheduleDb = new ScheduleDBContext();
}
public static void ResetContext(ScheduleDBContext context)
{
context.Schedules.RemoveRange(context.Schedules);
context.ScheduleItems.RemoveRange(context.ScheduleItems);
context.SaveChanges();
}
public TeacherService()
{
_avnDb = new avn.avn();
_scheduleDb = new ScheduleDBContext();
}
public SubjectService()
{
_avnDb = new avn.avn();
_scheduleDb = new ScheduleDBContext();
}
public ActionResult SetTime(FormCollection fc)
{
Schedule startSchedule = new Schedule();
ScheduleDBContext startScheduledbContext = new ScheduleDBContext();
Schedule overSchedule = new Schedule();
ScheduleDBContext overScheduledbContext = new ScheduleDBContext();
var start = startScheduledbContext.Schedules.Where(u => u.ID == 1).FirstOrDefault();
var over = overScheduledbContext.Schedules.Where(u => u.ID == 2).FirstOrDefault();
string startTime = fc["begin-time"];
string overTime = fc["over-time"];
if (startTime != null && overTime != null)
{
if (start == null)
{
string startyear = startTime.Substring(0, 4);
string startmonth = startTime.Substring(5, 2);
string startday = startTime.Substring(8, 2);
string starthour = startTime.Substring(11, 2);
string startminute = startTime.Substring(14, 2);
startSchedule = new Schedule()
{
Year = startyear, Month = startmonth, Day = startday, Hour = starthour, Minute = startminute
};
startScheduledbContext.Schedules.Add(startSchedule);
startScheduledbContext.SaveChanges();
}
else
{
start.Year = startTime.Substring(0, 4);
start.Month = startTime.Substring(5, 2);
start.Day = startTime.Substring(8, 2);
start.Hour = startTime.Substring(11, 2);
start.Minute = startTime.Substring(14, 2);
startScheduledbContext.SaveChanges();
}
if (over == null)
{
string overyear = overTime.Substring(0, 4);
string overmonth = overTime.Substring(5, 2);
string overday = overTime.Substring(8, 2);
string overhour = overTime.Substring(11, 2);
string overminute = overTime.Substring(14, 2);
overSchedule = new Schedule()
{
Year = overyear, Month = overmonth, Day = overday, Hour = overhour, Minute = overminute
};
overScheduledbContext.Schedules.Add(overSchedule);
overScheduledbContext.SaveChanges();
}
else
{
over.Year = overTime.Substring(0, 4);
over.Month = overTime.Substring(5, 2);
over.Day = overTime.Substring(8, 2);
over.Hour = overTime.Substring(11, 2);
over.Minute = overTime.Substring(14, 2);
overScheduledbContext.SaveChanges();
}
}
return(View("Index"));
}
public SchedulesController(ScheduleDBContext _context)
{
context = _context;
}
public AuditoriumService()
{
_avnDb = new testttEntities1();
_scheduleDb = new ScheduleDBContext();
}
