public ActionResult Save(DailyLog aDailyLog)
{
DailyLogManager aDailyLogManager = new DailyLogManager();
ViewBag.Message = aDailyLogManager.Save(aDailyLog);
return(View());
}
public void Test_DailyLogMgr_CreateDailyLog()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try {
var options = new DbContextOptionsBuilder <HOSContext>()
.UseSqlite(connection)
.Options;
using (var context = new HOSContext(options))
{
context.Database.EnsureCreated();
}
using (var context = new HOSContext(options))
{
HOSTestData.LoadStateProvinceCodeTable(context);
HOSTestData.LoadDutyStatusTable(context);
HOSTestData.LoadDutyStatusActivityTable(context);
HOSTestData.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
HOSTestData.LoadDailyLogTable(context);
HOSTestData.LoadDailyLogDetailTable(context);
}
using (var context = new HOSContext(options))
{
IDailyLogManager logMgr = new DailyLogManager(new Repository(context));
var dailyLogModel = new DailyLogModel
{
LogID = 4,
LogDate = new DateTime(2016, 9, 10),
BeginningMileage = 963000,
TruckNumber = "3082",
TrailerNumber = "9225",
IsSigned = false,
Notes = "Dropped trailer 9225 at Whirlpool and picked up loaded trailer 9159",
DriverID = 4,
CreatedBy = "sysadmin",
CreatedOn = new DateTime(2016, 9, 10, 8, 0, 0),
UpdatedBy = "sysadmin",
UpdatedOn = new DateTime(2016, 9, 10, 8, 0, 0),
};
logMgr.Create(dailyLogModel);
logMgr.SaveChanges();
var test = logMgr.GetDailyLog(log => log.LogID == dailyLogModel.LogID);
Assert.NotNull(test);
Assert.Equal(new DateTime(2016, 9, 10), test.LogDate.Date);
}
} finally {
connection.Close();
}
}
public static void LoadTest()
{
var result = DailyLogManager.LoadPriod(DateTime.Today - TimeSpan.FromDays(1), DateTime.Today + TimeSpan.FromDays(1));
foreach (var log in result)
{
Console.WriteLine("[Date={0}]", log.TargetDate);
foreach (var record in log.Records)
{
Console.WriteLine("* {0:00}:{1:00}:{2:00}", record.Time.Hour, record.Time.Minute, record.Time.Second);
}
}
}
public void Test_DailyLogMgr_UpdateDailyLog()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try {
var options = new DbContextOptionsBuilder <HOSContext>()
.UseSqlite(connection)
.EnableSensitiveDataLogging()
.Options;
using (var context = new HOSContext(options))
{
context.Database.EnsureCreated();
}
using (var context = new HOSContext(options))
{
HOSTestData.LoadStateProvinceCodeTable(context);
HOSTestData.LoadDutyStatusTable(context);
HOSTestData.LoadDutyStatusActivityTable(context);
HOSTestData.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
HOSTestData.LoadDailyLogTable(context);
HOSTestData.LoadDailyLogDetailTable(context);
}
using (var context = new HOSContext(options))
{
IDailyLogManager logMgr = new DailyLogManager(new Repository(context));
var dailyLogModel = logMgr.GetDailyLog(log => log.LogID == 1);
var currentTimestamp = DateTime.Now;
dailyLogModel.UpdatedOn = currentTimestamp;
logMgr.Update(dailyLogModel);
logMgr.SaveChanges();
dailyLogModel = logMgr.GetDailyLog(log => log.LogID == 1);
Assert.Equal(currentTimestamp, dailyLogModel.UpdatedOn);
}
} finally {
connection.Close();
}
}
public void Test_DailyLogMgr_SelectAllDetailsForOneDay()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try {
var options = new DbContextOptionsBuilder <HOSContext>()
.UseSqlite(connection)
.EnableSensitiveDataLogging()
.Options;
using (var context = new HOSContext(options))
{
context.Database.EnsureCreated();
}
using (var context = new HOSContext(options))
{
HOSTestData.LoadStateProvinceCodeTable(context);
HOSTestData.LoadDutyStatusTable(context);
HOSTestData.LoadDutyStatusActivityTable(context);
HOSTestData.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
HOSTestData.LoadDailyLogTable(context);
HOSTestData.LoadDailyLogDetailTable(context);
}
using (var context = new HOSContext(options))
{
IDailyLogManager logMgr = new DailyLogManager(new Repository(context));
var dailyLogModel = logMgr.GetDailyLog(log => log.LogDate == new DateTime(2016, 9, 7));
Assert.NotNull(dailyLogModel);
var dailyLogDetailModel = logMgr.GetDailyLogDetails(details => details.LogID == dailyLogModel.LogID);
Assert.NotNull(dailyLogDetailModel);
Assert.Equal(8, dailyLogDetailModel.ToList().Count());
}
} finally {
connection.Close();
}
}
public void Test_DailyLogMgr_SelectDailyLog()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try {
var options = new DbContextOptionsBuilder <HOSContext>()
.UseSqlite(connection)
.EnableSensitiveDataLogging()
.Options;
using (var context = new HOSContext(options))
{
context.Database.EnsureCreated();
}
using (var context = new HOSContext(options))
{
HOSTestData.LoadStateProvinceCodeTable(context);
HOSTestData.LoadDutyStatusTable(context);
HOSTestData.LoadDutyStatusActivityTable(context);
HOSTestData.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
HOSTestData.LoadDailyLogTable(context);
HOSTestData.LoadDailyLogDetailTable(context);
}
using (var context = new HOSContext(options))
{
IDailyLogManager logMgr = new DailyLogManager(new Repository(context));
var allLogs = logMgr.GetAll().ToList();
var allLogsForDrv = logMgr.GetDailyLogs(log => log.DriverID == 4);
Assert.Equal(3, allLogs.Count());
Assert.Equal(3, allLogsForDrv.Count());
}
} finally {
connection.Close();
}
}
public static void SaveTest()
{
// 正常系
var yesterdayDailyLog = DailyLog.LoadExistOrCreate(DateTime.Today - TimeSpan.FromDays(1));
if (yesterdayDailyLog.Records.Count != 0)
{
Console.WriteLine("すでに {0} 件のレコードが存在しております。", yesterdayDailyLog.Records.Count);
}
yesterdayDailyLog.AddRecord(new TimeRecord()
{
Time = DateTime.Now - TimeSpan.FromDays(1)
});
DailyLogManager.SaveDailyLog(yesterdayDailyLog);
var todayDailyLog = DailyLog.LoadExistOrCreate(DateTime.Today);
if (todayDailyLog.Records.Count != 0)
{
Console.WriteLine("すでに {0} 件のレコードが存在しております。", todayDailyLog.Records.Count);
}
todayDailyLog.AddRecord(new TimeRecord()
{
Time = DateTime.Now
});
DailyLogManager.SaveDailyLog(todayDailyLog);
// 異常系
#if FALSE
var errorDailyLog = new DailyLog(DateTime.Today - TimeSpan.FromDays(2));
errorDailyLog.AddRecord(new TimeRecord()
{
Time = DateTime.Now - TimeSpan.FromDays(3)
});
#endif
}
public void Test_DailyLogMgr_CreateDailyLogDetail()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try {
var options = new DbContextOptionsBuilder <HOSContext>()
.UseSqlite(connection)
.EnableSensitiveDataLogging()
.Options;
using (var context = new HOSContext(options))
{
context.Database.EnsureCreated();
}
using (var context = new HOSContext(options))
{
HOSTestData.LoadStateProvinceCodeTable(context);
HOSTestData.LoadDutyStatusTable(context);
HOSTestData.LoadDutyStatusActivityTable(context);
HOSTestData.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
HOSTestData.LoadDailyLogTable(context);
HOSTestData.LoadDailyLogDetailTable(context);
}
using (var context = new HOSContext(options))
{
IDailyLogManager logMgr = new DailyLogManager(new Repository(context));
var dailyLog = logMgr.GetDailyLog(log => log.LogID == 3);
// Retrieve the last pre-trip entry for this driver
var mostRecentPreTrip = logMgr.GetLastPreTripInspection(drv => drv.DriverID == dailyLog.DriverID);
// Determine hours available on 14
// Determine hours available on 11
// Determine if in violation of 30 min break rule
// Determine current duty status
// Determine duty status driver is attempting to move to
var dailyLogDetailModel = new DailyLogDetailModel
{
LogDetailID = 23,
LogID = dailyLog.LogID,
DutyStatusID = 4,
StartTime = new DateTime(2016, 9, 9, 8, 0, 0),
LocationCity = "Fort Worth",
StateProvinceId = 45,
DutyStatusActivityID = 1
};
logMgr.CreateLogDetail(dailyLogDetailModel);
logMgr.SaveChanges();
dailyLogDetailModel = logMgr.GetDailyLogDetail(details => details.LogID == dailyLog.LogID);
Assert.NotNull(dailyLogDetailModel);
}
} finally {
connection.Close();
}
}
