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