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