public DailyStatus SyncDayStatus(DailyStatus dailyStatus)
{
if (GetDayStat(dailyStatus.OpenDate) == null)
{
//insert
OleDbCommand command = DBFunctions.GetInstance().GetCommand(
"Insert Into DailyStatus(OpenDate, DayStartCash, DayEndCash) " +
"Values(?,?,?)");
command.Parameters.AddWithValue("OpenDate", dailyStatus.OpenDate.Date.ToString());
command.Parameters.AddWithValue("DayStartCash", dailyStatus.DayStartCash);
command.Parameters.AddWithValue("DayEndCash", dailyStatus.DayEndCash);
command.ExecuteNonQuery();
//dailyStatuses.Add(dailyStatus);
}
else
{
//update
OleDbCommand command = DBFunctions.GetInstance().GetCommand(
"Update DailyStatus Set DayStartCash=?, DayEndCash=? Where OpenDate=?");
command.Parameters.AddWithValue("startCash", dailyStatus.DayStartCash);
command.Parameters.AddWithValue("endCash", dailyStatus.DayEndCash);
command.Parameters.Add("openDate", OleDbType.Date).Value = dailyStatus.OpenDate.Date;
command.ExecuteNonQuery();
DailyStatus d = GetDayStat(dailyStatus.OpenDate);
d = dailyStatus;
}
return(dailyStatus);
}
public DailyResponse(Daily daily, DailyStatus status, int amountClaimed)
{
Status = status;
AmountClaimed = amountClaimed;
LongestStreak = daily.LongestStreak;
CurrentStreak = daily.CurrentStreak;
LastClaimTime = daily.LastClaimTime;
}
//public double GetPreviousDayAmount(DateTime day)
//{
// DateTime dayToLook;
// //look for atleast 7 days for previous amount
// for (int i = 0; i < 7; i++)
// {
// dayToLook = day.Subtract(new TimeSpan(i,0,0,0));
// DailyStatus dayStat = CommonCache.GetInstance().GetDayStat(dayToLook);
// if (dayStat == null)
// {
// continue;
// }
// return dayStat.DayEndCash;
// }
// return 0;
//}
public void MarkDayStart(DateTime day, double startingCash)
{
DailyStatus dayStat = new DailyStatus();
dayStat.OpenDate = day.Date;
dayStat.DayStartCash = startingCash;
dayStat.DayEndCash = 0;
CommonCache.GetInstance().SyncDayStatus(dayStat);
}
public DailyStatus GetDayStat(DateTime day)
{
DailyStatus dayStat = null;
OleDbCommand command = DBFunctions.GetInstance().GetCommand(
"Select ID, OpenDate, DayStartCash, DayEndCash From DailyStatus Where OpenDate=?");
command.Parameters.Add("OpenDate", OleDbType.Date).Value = day.Date;
OleDbDataReader reader = DBFunctions.GetInstance().GetReader(command);
if (reader.Read())
{
dayStat = new DailyStatus();
dayStat.ID = int.Parse(reader[0].ToString());
dayStat.OpenDate = DateTime.Parse(reader[1].ToString());
dayStat.DayStartCash = double.Parse(reader[2].ToString());
}
return(dayStat);
}
public DailyStatus SyncDayStatus(DailyStatus dayStat)
{
return(CommonCache.GetInstance().SyncDayStatus(dayStat));
}
