public List <System_Log> GetLogs(string timeRange) { /*day week month year*/ query = "exec spLogTable_AutoTrackChanges_GetLogs @timeRange='" + timeRange + "'"; try { dbs = new DbService(); List <System_Log> logs = new List <System_Log>(); SqlDataReader sdr = dbs.GetDataReader(query); System_Log log; while (sdr.Read()) { log = new System_Log(); log.Id = Convert.ToInt32(sdr["Id"]); log.WhoChanged = Convert.ToString(sdr["WhoChanged"]); log.TableName = Convert.ToString(sdr["TableName"]); log.Recorde_UniqueId = Convert.ToInt32(sdr["Recorde_UniqueId"]); log.ColumnName = Convert.ToString(sdr["ColumnName"]); valueIsDate = DateTime.TryParse(Convert.ToString(sdr["OldValue"]), out temp4values_asDate); if (valueIsDate) { log.OldValue_AsDate = temp4values_asDate; } else { log.OldValue = Convert.ToString(sdr["OldValue"]); } valueIsDate = DateTime.TryParse(Convert.ToString(sdr["NewValue"]), out temp4values_asDate); if (valueIsDate) { log.NewValue_AsDate = temp4values_asDate; } else { log.NewValue = Convert.ToString(sdr["NewValue"]); } log.DateAdded = Convert.ToDateTime(Convert.ToString(sdr["DateAdded"])); log.TimeAdded = TimeSpan.Parse(Convert.ToString(sdr["TimeAdded"])); logs.Add(log); } return(logs); } catch (Exception ex) { throw new Exception(ex.Message); } finally { dbs.CloseConnection(); } }
public void AddLog(DataProvider dp, System_Log log) { dp.System_Log.Add(log); }
public static bool writeToSystemLog(string[] username, string Comment, string Type, string Section) { List<System_Log> log = new List<System_Log>(); foreach (string s in username) { System_Log l = new System_Log(); l.Comment = Comment; l.Type = Type; l.Section = Section; l.DateTime = DateTime.Now; l.Deleted = false; l.UserName = s; log.Add(l); } return saveSystemLog(log); }
private static bool saveSystemLog(System_Log log) { try { db.System_Log.AddObject(log); db.SaveChanges(); } catch (Exception e) { Debug.WriteLine(e.Message); return false; } return true; }
public static bool writeToSystemLog(int CaseID, string Comment, string Type, string Section) { List<System_Log> log = new List<System_Log>(); string studentUsername = db.Cases.SingleOrDefault(x => x.Case_Id == CaseID).Student.UserName; System_Log l = new System_Log(); l.UserName = studentUsername; l.Comment = Comment; l.Type = Type; l.Section = Section; l.DateTime = DateTime.Now; l.Deleted = false; log.Add(l); foreach (Case_Staff s in db.Case_Staff.Where(x => x.Case_Id == CaseID).ToList()) { l = new System_Log(); l.UserName = s.Staff.UserName; l.Comment = Comment; l.Type = Type; l.Section = Section; l.DateTime = DateTime.Now; l.Deleted = false; log.Add(l); } return saveSystemLog(log); }