//Save statistic number of visitors into database
private void CountVisitors()
{
//Count 1 for each time user accessing to website
var listUserAddress = _dbContext.SYS_COUNTER.ToList();
foreach (var item in listUserAddress)
{
if (item.IPAddress.Equals(Request.UserHostAddress) && item.AccessedDate.Date == DateTime.Now.Date)
{
item.AccessedTime += 1;
_dbContext.Entry(item).State = EntityState.Modified;
_dbContext.SaveChanges();
return;
}
if (item.IPAddress.Equals("::1"))
{
item.AccessedTime = 0;
_dbContext.Entry(item).State = EntityState.Modified;
_dbContext.SaveChanges();
}
}
// if ip address and datetime are not existed in database
SYS_COUNTER counter = new SYS_COUNTER()
{
IPAddress = Request.UserHostAddress,
AccessedDate = DateTime.Now,
AccessedTime = 1
};
_dbContext.SYS_COUNTER.Add(counter);
_dbContext.SaveChanges();
}
public int Update(SYS_COUNTER info)
{
var sql = Sql.Builder.Append(@"UPDATE [dbo].[SYS_COUNTER]
SET [SPEC_FUN_IND] = @SPEC_FUN_IND
,[STATE] = @STATE
,[MAX_BUSI_CNT] = @MAX_BUSI_CNT
,[PRI1_BUSI_SER] = @PRI1_BUSI_SER
,[PRI2_BUSI_SER] = @PRI2_BUSI_SER
,[PRI3_BUSI_SER] = @PRI3_BUSI_SER
,[PRI4_BUSI_SER] = @PRI4_BUSI_SER
,[PRI5_BUSI_SER] = @PRI5_BUSI_SER
,[MODIFY_ID] = @MODIFY_ID
,[MODIFY_DTIME] = @MODIFY_DTIME
,[NOTE] = @NOTE
WHERE [HALL_NO] = @HALL_NO and [COUNTER_ID] = @COUNTER_ID"
, new
{
SPEC_FUN_IND = info.SPEC_FUN_IND,
STATE = info.STATE,
MAX_BUSI_CNT = info.MAX_BUSI_CNT,
PRI1_BUSI_SER = info.PRI1_BUSI_SER,
PRI2_BUSI_SER = info.PRI2_BUSI_SER,
PRI3_BUSI_SER = info.PRI3_BUSI_SER,
PRI4_BUSI_SER = info.PRI4_BUSI_SER,
PRI5_BUSI_SER = info.PRI5_BUSI_SER,
MODIFY_ID = info.MODIFY_ID,
MODIFY_DTIME = info.MODIFY_DTIME,
NOTE = info.NOTE,
HALL_NO = info.HALL_NO,
COUNTER_ID = info.COUNTER_ID
});
return(gzswDB.GetInstance().Execute(sql));
}
