public List <AccessLogCommon> GetAccessLogList(string from_date, string to_date) { List <AccessLogCommon> acclog = new List <AccessLogCommon>(); string sql = "sproc_access_log @flag = 's'"; sql += string.IsNullOrEmpty(from_date) ? "" : ", @from_date=" + DAO.FilterString(from_date); sql += string.IsNullOrEmpty(to_date) ? "" : ", @to_date=" + DAO.FilterString(to_date); var dbres = DAO.ExecuteDataTable(sql); if (dbres != null) { foreach (DataRow dr in dbres.Rows) { AccessLogCommon accesslog = new AccessLogCommon(); accesslog.pageName = dr["page_name"].ToString(); accesslog.logType = dr["log_type"].ToString(); accesslog.actionIpAddress = dr["from_ip_address"].ToString(); accesslog.browser = dr["browser_info"].ToString(); accesslog.createdBy = dr["created_by"].ToString(); accesslog.createdUtcDate = dr["created_UTC_date"].ToString(); accesslog.createdLocalDate = dr["created_local_date"].ToString(); //accesslog.fromDate = dr["created_UTC_date"].ToString(); //accesslog.toDate = dr["created_UTC_date"].ToString(); accesslog.msg = dr["remarks"].ToString(); acclog.Add(accesslog); } } return(acclog); }
public ActionResult AccessLog(AccessLogCommon alc) { //AccessLogCommon alc = new AccessLogCommon(); //alc.fromDate = fromDate; //alc.toDate = toDate; var list = _access.GetAccessLogList(alc.fromDate, alc.toDate); //foreach (var item in list) //{ // item.Action = StaticData.GetActions("AccessLog", "", this, "", ""); //} IDictionary <string, string> param = new Dictionary <string, string>(); param.Add("pageName", "Page Name"); param.Add("logType", "Log Status"); param.Add("browser", "Browser"); param.Add("Msg", "Remarks"); param.Add("CreatedBy", "Access By"); param.Add("actionIpAddress", "Ip Address"); param.Add("createdLocalDate", "Date Time"); ProjectGrid.column = param; var grid = ProjectGrid.MakeGrid(list, "hidebreadcrumb", "", 0, true, "", "", "Home", "Access Log", "#", "#"); ViewData["grid"] = grid; return(View(alc)); }
public ActionResult AccessLog(string from, string to) { AccessLogCommon alc = new AccessLogCommon(); alc.fromDate = from; alc.toDate = to; //var UserType = Session["UserType"].ToString(); var list = _access.GetAccessLogList(alc.fromDate, alc.toDate); foreach (var item in list) { item.Action = StaticData.GetActions("AccessLog", "", this, "", ""); } IDictionary <string, string> param = new Dictionary <string, string>(); param.Add("pageName", "Page Name"); param.Add("logType", "Log Status"); param.Add("browser", "Browser"); param.Add("msg", "Remarks"); param.Add("createdBy", "Access By"); param.Add("actionIpAddress", "Ip Address"); param.Add("createdLocalDate", "Date Time"); ProjectGrid.column = param; var grid = ProjectGrid.MakeGrid(list, "", "", 0, true, "", "", "Home", "Access Log", "#", "#"); ViewData["grid"] = grid; return(View()); }