public void Update(POSSession session)
{
SQLCeDb.Do(@"UPDATE session set sessionstate=@sessionstate, opendate=@opendate, closedate =@closedate WHERE id = @id")
.AddParameter("sessionstate", session.SessionState)
.And("opendate", session.SessionState)
.And("closedate", session.OpenDate)
.And("id", session.Id).Than.Execute();
}
public void Save(POSSession session)
{
SQLCeDb.Do(@"INSERT INTO tblsession (id,username,sessionstate,closedate,opendate) values (@id, @username, @sessionstate, @closedate,@opendate)")
.AddParameter("id", session.Id)
.And("username", session.UserName)
.And("sessionstate", session.SessionState)
.And("closedate", session.CloseDate)
.And("opendate", session.OpenDate).Than.Execute();
}
private POSSession POSSessionDeserializer(SqlCeDataReader reader)
{
var id = Guid.Parse(reader["id"].ToString());
var username = reader["username"].ToString();
var openDate = Convert.ToDateTime(reader["opendate"].ToString());
var closeDate = Convert.ToDateTime(reader["closedate"].ToString());
var state = (SessionState)Convert.ToInt32(reader["sessionstate"]);
var session = new POSSession(id, username, openDate, closeDate, state);
return session;
}
public POSSession OpenSession(string userName)
{
POSSession session = sessionRepository.GetSessionOpened(userName);
if (Object.ReferenceEquals(session, null))
{
session = new POSSession(userName);
DateTime lastSession = sessionRepository.GetLastCloseDate(userName);
if (!lastSession.Equals(new DateTime()))
if (session.OpenDate <= lastSession.AddDays(-7))
throw new Exception("Tanggal komputer anda salah. silahkan di perbaharui terlebih dahulu");
sessionRepository.Save(session);
}
shoppingCartSingleton.SetSession(session);
return session;
}
public void SetSession(POSSession session)
{
this.POSSession = session;
}
public void CloseSession(POSSession session)
{
session.Close();
sessionRepository.Update(session);
}
