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