public BasicResponse Update(DailyLog log, bool isOverNight = false)
{
if (!IsValidDate(log))
{
return(Common.Common.SendResponse(500, "date entered is not correct"));
}
var punchlog = SetPropValue(log);
if (isOverNight)
{
punchlog.IsAutoSplit = isOverNight;
}
if (!IsOverNight(log))
{
if (punchlog.IsAutoSplit)
{
Delete(punchlog.ID);
punchlog.SplitLogId = 0;
punchlog.IsAutoSplit = false;
}
_work.DailyPunchLogsRepo.Update(punchlog);
_work.Commit();
}
return(Common.Common.SendResponse(200, "record updated successfully"));
}
public ActionResult Save(DailyLog aDailyLog)
{
DailyLogManager aDailyLogManager = new DailyLogManager();
ViewBag.Message = aDailyLogManager.Save(aDailyLog);
return(View());
}
public List <DailyLog> GetAllDailyLog()
{
try
{
List <DailyLog> DailyLogList = new List <DailyLog>();
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT DISTINCT Lorry_Number FROM DailyLog";
SqlCommand command = new SqlCommand(query, connection);
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DailyLog aDailyLog = new DailyLog
{
//Id = Convert.ToInt32(reader["Id"]),
LorryNumber = Convert.ToString(reader["Lorry_Number"])
};
DailyLogList.Add(aDailyLog);
}
command.Connection.Close();
return(DailyLogList);
}
catch (Exception)
{
throw;
}
}
public DailyLog GetDailyLog(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, CreateTime from DailyLog");
strSql.Append(" where Id = @Id");
Database db = DatabaseFactory.CreateDatabase("MYLOGConn");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "Id", DbType.String, id);
DataTable dt = db.ExecuteDataSet(dbCommand).Tables[0];
if (dt.Rows.Count > 0)
{
DailyLog log = new DailyLog();
log.Id = dt.Rows[0]["Id"].ToString();
DateTime CreateTime;
if (DateTime.TryParse(dt.Rows[0]["CreateTime"].ToString(), out CreateTime))
{
log.CreateTime = CreateTime;
}
return(log);
}
else
{
return(null);
}
}
public void Start()
{
DailyLogClient logClient = new DailyLogClient();
FitbitClient fitbitClient = new FitbitClient(ConsumerKey, ConsumerSecret, AccessTokenKey, AccessTokenSecret);
//for (DateTime dt = fitbitClient.GetActivityTrackerFirstDay().Value; dt <= DateTime.Today; dt = dt.AddDays(1))
//{
DateTime queryDate = DateTime.Today;
var day = fitbitClient.GetDayActivity(queryDate).Summary;
var sleep = fitbitClient.GetSleep(queryDate).Summary;
DailyLog log = logClient.Get(queryDate);
log.Distance = day.Distances.FirstOrDefault(x => x.Activity == "total").Distance;
log.CaloriesOut = day.CaloriesOut;
log.FairlyActiveMinutes = day.FairlyActiveMinutes;
log.LightlyActiveMinutes = day.LightlyActiveMinutes;
log.SedentaryMinutes = day.SedentaryMinutes;
log.Steps = day.Steps;
log.VeryActiveMinutes = day.VeryActiveMinutes;
log.TimeInBadMinutes = sleep.TotalTimeInBed;
log.SleepMinutes = sleep.TotalMinutesAsleep;
logClient.InsertOrReplace(log);
//}
}
public IActionResult Get(string id)
{
DailyLog currentRecipe = accessor.Get <DailyLog>(id);
return(Json(currentRecipe));
}
public int?CreateUpdateDailyLog(DailyLogViewModel dailyLogViewModel)
{
DailyLog dailyLog = null;
if (dailyLogViewModel.DailyLogId > 0)
{
dailyLog = _repository.Find <DailyLog>(x => x.DailyLogId == dailyLogViewModel.DailyLogId);
if (dailyLog == null)
{
return(null);
}
dailyLog.CustomerId = dailyLogViewModel.CustomerId;
dailyLog.GuardId = dailyLogViewModel.GuardId;
dailyLog.Comments = dailyLogViewModel.Comments;
dailyLog.Dated = dailyLogViewModel.Dated;
_repository.Modify <DailyLog>(dailyLog);
return(dailyLog.CustomerId);
}
Mapper.CreateMap <DailyLogViewModel, DailyLog>();
dailyLog = Mapper.Map <DailyLogViewModel, DailyLog>(dailyLogViewModel);
dailyLog.CreatedDate = DateTime.Now;
dailyLog.Dated = dailyLogViewModel.Dated;
dailyLog.IsDeleted = false;
return(_repository.Insert <DailyLog>(dailyLog));
}
public void Test_DailyLogUpdate()
{
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.LoadCompanyTable(context);
HOSTestData.LoadAppUserTable(context);
}
using (var context = new HOSContext(options))
{
IRepository repository = new Repository(context);
var dailyLog = new DailyLog
{
LogID = 1,
LogDate = new DateTime(2016, 9, 7),
BeginningMileage = 899201,
EndingMileage = 899423,
TruckNumber = "3082",
TrailerNumber = "9225",
IsSigned = true,
Notes = "Dropped trailer 9225 at Whirlpool and picked up loaded trailer 9159",
DriverID = 4
};
repository.Create <DailyLog>(dailyLog);
repository.Save();
var test = repository.Find <DailyLog>(log => log.LogID == dailyLog.LogID);
Assert.NotNull(test);
Assert.Equal(new DateTime(2016, 9, 7), dailyLog.LogDate);
test.LogDate = new DateTime(2016, 9, 9);
repository.Update <DailyLog>(test);
repository.Save();
test = repository.Find <DailyLog>(log => log.LogID == dailyLog.LogID);
Assert.Equal(new DateTime(2016, 9, 9), test.LogDate);
}
} finally {
connection.Close();
}
}
public int insert(DailyLog log)
{
var punchlog = SetPropValue(log);
punchlog.SplitLogId = log.SplitLogID;
_work.DailyPunchLogsRepo.Insert(punchlog);
_work.Commit();
return(punchlog.ID);
}
private void SetDailyLogSelected(int dailylogId)
{
using (SQLiteConnection conn = new SQLiteConnection(Settings.DBPATH, SQLiteOpenFlags.ReadWrite, false))
{
DailyLog dl = conn.Table <DailyLog>().FirstOrDefault(x => x.DailyLogID == dailylogId);
dl.DailyLogIsSelected = true;
conn.Update(dl);
}
}
List <DailyLog> LoadGridData()
{
for (int i = 0; i < 31; i++)
{
DailyLog dayLog = new DailyLog();
log.Add(dayLog);
}
return(log);
}
public DailyLog(int slavesDied, int goodsProduced, int toolsUsed)
{
day = CampaignTime.Now;
_slavesDied = slavesDied;
_goodsProduced = goodsProduced;
_toolsUsed = toolsUsed;
_nextDay = null;
_previousDay = null;
}
public void DailyLog_CanBeCreated()
{
//Given
DailyLog dailyLog;
//When
dailyLog = new DailyLog();
//Then
Assert.NotNull(dailyLog);
}
public string Save(DailyLog aDailyLog)
{
DailyLogGateway aDailyLogGateway = new DailyLogGateway();
int rowAffected = aDailyLogGateway.Save(aDailyLog);
if (rowAffected > 0)
{
return("Daily Log Saved Successfully.");
}
return("Daily Log Saved Fail");
}
/// <summary>
///
/// </summary>
/// <param name="log"></param>
public static void SaveDailyLog(DailyLog log)
{
var dir = prepareDailyRecordsPath(log.TargetDate);
foreach (var record in log.Records)
{
var path = getRecordFilePath(record);
using (var fs = File.OpenWrite(path))
SaveTimeRecord(fs, record);
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DailyLogViewModel GetDailyLog(int id)
{
DailyLog dailylog = _repository.Find <DailyLog>(x => x.DailyLogId == id);
if (dailylog == null)
{
return(null);
}
Mapper.CreateMap <DailyLog, DailyLogViewModel>();
return(Mapper.Map <DailyLog, DailyLogViewModel>(dailylog));
}
public int DeleteDailyLog(int id, int UserId)
{
DailyLog dailylog = _repository.Find <DailyLog>(x => x.DailyLogId == id);
if (dailylog == null)
{
return(0);
}
dailylog.IsDeleted = true;
dailylog.DeletedBy = UserId;
dailylog.DeletedDate = DateTime.Now;
return(_repository.Modify <DailyLog>(dailylog));
}
public static DailyLog Load(DateTime date)
{
var dir = prepareDailyRecordsPath(date);
var files = Directory.GetFiles(dir, "*." + DAT_EXTENSION, SearchOption.TopDirectoryOnly);
var result = new DailyLog(date);
foreach (var f in files)
{
using (var fs = File.OpenRead(f))
result.AddRecord(LoadRecordFrom(fs));
}
return(result);
}
public IActionResult Get(int month, int day, int year)
{
DateTime date = new DateTime(year, month, day);
DailyLog dailyLog = accessor.GetDailyLogByDate(date);
if (dailyLog == null)
{
Response r = new Response();
r.Success = true;
r.Message = "Log does not exist.";
return(Json(r));
}
return(Json(dailyLog));
}
public void AddToLogs(int slavesDied, int goodsProduced, int toolsUsed)
{
DailyLog newEntry = new DailyLog(slavesDied, goodsProduced, toolsUsed);
if (_logs == null)
{
_logs = new List <DailyLog>();
}
if (_logs.Count > 0)
{
_logs.Last <DailyLog>().NextDay = newEntry;
newEntry.PreviousDay = _logs.Last <DailyLog>();
}
_logs.Add(newEntry);
}
public int AddDailyLog(DailyLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DailyLog(");
strSql.Append("Id,CreateTime)");
strSql.Append(" values (");
strSql.Append("@Id,@CreateTime)");
Database db = DatabaseFactory.CreateDatabase("MYLOGConn");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "Id", DbType.String, model.Id);
db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
return(db.ExecuteNonQuery(dbCommand));
}
private DailyStatisticViewModel GenerateDailyLogViewModel(DailyLog dailyLog)
{
var todayStatisticViewModel = new DailyStatisticViewModel
{
Date = dailyLog.Date,
City = dailyLog.City,
Fasted = dailyLog.Fasted,
Id = dailyLog.Id,
LastMealTimeStamp = dailyLog.LastMealTimeStamp,
MorningWeight = dailyLog.MorningWeight,
Steps = dailyLog.Steps,
Stretched = dailyLog.Stretched,
Sport = dailyLog.Sport
};
return(todayStatisticViewModel);
}
private void BT_SaveEvent_Click(object sender, EventArgs e)
{
int count = FLP_Events.Controls.Count;
if (count > 0)
{
DailyLog dailyLog;
dailyLog = db.GetDailyLog(DateTime.Now.ToShortDateString());
if (dailyLog == null)
{
dailyLog = new DailyLog();
dailyLog.Id = DailyLogId;
dailyLog.CreateTime = DateTime.Now;
db.AddDailyLog(dailyLog);
}
foreach (EventControl item in FLP_Events.Controls)
{
switch (item.Status)
{
case EventControl.StatusType.Create:
CreateEvent(item, dailyLog.Id);
break;
case EventControl.StatusType.Delete:
DeleteEvent(item);
break;
case EventControl.StatusType.Keep:
break;
case EventControl.StatusType.Update:
UpdateEvent(item);
break;
}
}
MessageBox.Show("已保存");
}
else
{
// if nothing delete
return;
}
}
public Response Post(string id, [FromBody] DailyLog value)
{
Response r = new Response();
if (value == null)
{
r.Success = false;
r.Message = "Null DailyLog Found";
return(r);
}
value = GlobalFunctions.AddIdIfNeeded(value, id);
accessor.Post(value);
r.Message = value.idString;
return(r);
}
private List <DailyLog> GetDailyLogs(Timesheets log, int groupID = 0)
{
List <DailyLog> dailyLogs = new List <DailyLog>();
if (log.SplitLogId.HasValue && log.SplitLogId.Value > 0)
{
return(null);
}
foreach (var column in Constants.Columns)
{
var prop = GetPropValue(log, column);
var value = prop.GetValue(log);
var idProp = GetPropValue(log, "ID");
var idVal = idProp.GetValue(log);
if (prop.Name.ToLower() == Constants.Columns[1].ToLower())
{
var isAutoSplitProp = GetPropValue(log, "IsAutoSplit");
var isAutoSplitVal = (bool)isAutoSplitProp.GetValue(log);
if (isAutoSplitVal)
{
var splitLog = _work.DailyPunchLogsRepo.Get(x => x.SplitLogId.HasValue && x.SplitLogId.Value == log.ID).FirstOrDefault();
value = splitLog.ClockedOut;
}
}
if (value != null)
{
var time = Convert.ToDateTime(value);
var dailyLog = new DailyLog
{
ID = (int)idVal,
PunchName = prop.Name,
PunchTime = time,
Time = time.ToString("HH:mm"),
PunchDate = time.Date,
GroupID = groupID
};
dailyLogs.Add(dailyLog);
}
}
return(dailyLogs);
}
public int Save(DailyLog aDailyLog)
{
try
{
SqlConnection connection = new SqlConnection();
SqlCommand command = new SqlCommand();
command.CommandText = "INSERT INTO DailyLog (Date,SupplierName,Destination,Lorry_Number,SupplierPriceRent,SupplierAdvancedPayment,PartyName,PartyPrice,PartyAdvancedReceived,CnF) VALUES ('" + aDailyLog.Date + "','" + aDailyLog.SupplierName + "','" + aDailyLog.Destination + "','" + aDailyLog.LorryNumber + "','" + aDailyLog.SupplierPriceRent + "','" + aDailyLog.SupplierAdvancedPayment + "','" + aDailyLog.PartyName + "','" + aDailyLog.PartyPrice + "','" + aDailyLog.PartyAdvancedReceived + "','" + aDailyLog.CnF + "')";
command.Connection = connection;
command.Connection.ConnectionString = connectionString;
command.Connection.Open();
int rowAffected = command.ExecuteNonQuery();
command.Connection.Close();
return(rowAffected);
}
catch (Exception exception)
{
return(0);
}
}
public bool IsOverNight(DailyLog dLog)
{
var log = DailyPunch(dLog.PunchTime.AddDays(-1));
if (log != null && log.SubmitTime == null && !dLog.IsAutoSplit)
{
if (log.ClockedIn.Value.Date < dLog.PunchTime.Date)
{
var newLog = (DailyLog)dLog.Clone();
var newDate = new DateTime(log.ClockedIn.Value.Date.Year, log.ClockedIn.Value.Date.Month, log.ClockedIn.Value.Date.Day, 23, 59, 59);
newLog.PunchTime = newDate;
newLog.IsAutoSplit = true;
//insert entry to old
Update(newLog, true);
//clock In entry for current Day
var newDayClockIn = new DailyLog
{
SplitLogID = log.ID,
PunchName = "clockedIn",
PunchTime = new DateTime(dLog.PunchTime.Date.Year, dLog.PunchTime.Date.Month, dLog.PunchTime.Date.Day, 00, 00, 00),
IsAutoSplit = true
};
var id = insert(newDayClockIn);
//clockout for the day
dLog.ID = id;
dLog.IsAutoSplit = true;
Update(dLog);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public JsonResult InsertLog(DailyLog log)
{
int logID = HttpContext.Session.Get <int>("LogID");
if (logID > 0)
{
log.ID = logID;
_pService.Update(log);
if (log.PunchName.ToLower() == Constants.ClockedOut.Replace(" ", "").ToLower())
{
HttpContext.Session.Set <int>("LogID", 0);
}
}
else
{
logID = _pService.insert(log);
HttpContext.Session.Set("LogID", logID);
}
return(Json("data inserted successfully"));
}
public DailyLog GetLogs(int offset, int limit, DateTime day)
{
var logsList = new List <Log>();
logsList.Add(new Log()
{
LogId = null,
LogType = 2,
DateTime = DateTime.Now.ToString(),
Error = "Test error",
Status = ""
});
var data = new DailyLog()
{
Logs = logsList,
TotalCount = 1
};
return(data);
}
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
}
