internal void GenerateRapport() //metod för att generera och spara rapporter
{
string path = @"..\..\..\..\Logs\" + Date.ToString("yy-MM-dd hh-mm-ss") + ".txt"; //sökvägen dit de unika rapporterana ska genereras
string pathTotal = @"..\..\..\..\Logs\total.txt"; //sökväg dit rapport för alla simulationer tillsammans genereras
string root = @"..\..\..\..\Logs"; //foldern dit rapporterna ska sparas
if (!Directory.Exists(root)) //kollar om foldern finns
{
Directory.CreateDirectory(root); //gör den inte det så skapas den
}
//slår ihop activitylogs med hamster med hjälp av hamserID och skapar ett nytt anonymt object
var ham = ActivityLogs.Join(Hamsters, ac => ac.HamsterID, ham => ham.ID, (ac, ham) => new
{
Owner = ham.Ownername,
ID = ham.ID,
HamName = ham.Name,
Activity = ac.ActivityName,
Start = ac.StartDate,
End = ac.EndDate,
});
foreach (var h in ham) //går igenom varje inlägg och sparar det till en unikfil för simulationen och till en fil för alla simulationer
{
var temp = $"{h.ID},{h.Owner},{h.HamName}, {h.Activity}, {h.Start}, {h.End}\n";
//DirectoryInfo di = Directory.CreateDirectory(path);
File.AppendAllText(path, temp);
File.AppendAllText(pathTotal, temp);
}
PrintReports(path); //anropa print metod
}
private ActivityLogs MakeObject(SqlDataReader oReader)
{
oReader.Read();
ActivityLogs oActivityLogs = new ActivityLogs();
oActivityLogs = MapObject(oReader);
return(oActivityLogs);
}
private List <ActivityLogs> MakeObjects(SqlDataReader oReader)
{
List <ActivityLogs> oActivityLogss = new List <ActivityLogs>();
while (oReader.Read())
{
ActivityLogs oActivityLogs = MapObject(oReader);
oActivityLogss.Add(oActivityLogs);
}
return(oActivityLogss);
}
public void DeleteActivityHistory(long logId)
{
ActivityLogData log = getActivityLog(logId);
if (log is QLogData)
{
ICollection <AnswerByPhoneData> answersData = ((QLogData)log).studentsAnswers;
deleteAnswers(answersData);
}
ActivityLogs.Remove(log);
SaveChanges();
}
public void CreateAuditLog(string userName, string ipAddress, string areaAccessed, DateTime timeAccessed,
string action, string result)
{
var entity = new ActivityLogs
{
Description =
string.Format("IP Address: {0}, Area Access: {1}, Result: {2}", ipAddress, areaAccessed, result),
ExecutedBy = userName,
Timestamp = timeAccessed,
Type = action
};
_activityLogsRepository.Create(entity);
}
public void AddActivity(int sessionId, string activity)
{
var userid = Thread.CurrentPrincipal.Identity.GetUserId();
var activitylog = ActivityLogs.Create();
activitylog.UserId = userid;
activitylog.SessionId = sessionId;
activitylog.Activity = activity;
activitylog.CreateDateTime = DateTime.UtcNow;
Entry(activitylog).State = EntityState.Added;
SaveChanges();
}
public List <ActivityLogData> getHistory(long roomID)
{
List <ActivityLogData> lst = new List <ActivityLogData>();
List <ActivityLogData> allHistory = ActivityLogs.ToList();
foreach (ActivityLogData act in allHistory)
{
if (act.RoomId == roomID)
{
lst.Add(act);
}
}
return(lst);
}
public JsonResult Search(ActivityLogs objActivityLogs)
{
SessionObj oSessionobj = new SessionObj(Session);
ActivityLogs oActivityLogs = new ActivityLogs();
List <ActivityLogs> oActivityLogsList = new List <ActivityLogs>();
ActivityLogsService oActivityLogsService = new ActivityLogsService();
DataSet oDataSet = new DataSet();
oDataSet = oActivityLogsService.GetDynamicObjectList(objActivityLogs.ErrorMessage, 1);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(oDataSet.Tables[0]);
JavaScriptSerializer serializer = new JavaScriptSerializer();
string sjson = serializer.Serialize(JSONString);
return(Json(sjson, JsonRequestBehavior.AllowGet));
}
public ActivityLogs InsertActivityLog(ActivityLogs activityLog)
{
try
{
_offlineMessagingDbContext.ActivityLogs.Add(activityLog);
_offlineMessagingDbContext.SaveChanges();
return(activityLog);
}
catch (Exception ex)
{
PublicLogs publicLog = new PublicLogs();
publicLog.LogContent = ex.ToString();
publicLog.LogTime = DateTime.Now;
InsertPublicLog(publicLog);
return(null);
}
}
public List <ActivityLogs> Gets(string sSQL, int nUserID)
{
Connection.Open();
Command.CommandText = ActivityLogsDA.Gets(sSQL, nUserID);
SqlDataReader reader = Command.ExecuteReader();
ActivityLogs _oActivityLogs = new ActivityLogs();
List <ActivityLogs> _oActivityLogss = new List <ActivityLogs>();
if (reader.HasRows)
{
_oActivityLogss = MakeObjects(reader);
}
reader.Close();
Connection.Close();
return(_oActivityLogss);
}
private ActivityLogs MapObject(SqlDataReader oReader)
{
ActivityLogs oActivityLogs = new ActivityLogs();
oActivityLogs.ActivityLogID = (int)oReader["ActivityLogID"];
oActivityLogs.TableName = oReader["TableName"].ToString();
oActivityLogs.ColNames = oReader["ColNames"].ToString();
oActivityLogs.ColPreviousValues = oReader["ColPreviousValues"].ToString();
oActivityLogs.ColNewValues = oReader["ColNewValues"].ToString();
oActivityLogs.WhereClause = oReader["WhereClause"].ToString();
oActivityLogs.Remarks = oReader["Remarks"].ToString();
oActivityLogs.BranchID = (int)oReader["BranchID"];
oActivityLogs.DBOperationID = (EnumDBOperation)oReader["DBOperationID"];
oActivityLogs.DBServerDateTime = (DateTime)oReader["DBServerDateTime"];
return(oActivityLogs);
}
public ActionResult <CustomUser> CreateCustomUser(CustomUser customUser)
{
var createdCustomUser = _customUserServices.CreateCustomUser(customUser);
if (createdCustomUser == null)
{
return(NotFound());
}
ActivityLogs activityLog = new ActivityLogs();
activityLog.ActivityContent = "The user account has been created successfully";
activityLog.ActivityTime = DateTime.Now;
activityLog.customUser = createdCustomUser;
InsertActivityLog(activityLog);
return(createdCustomUser);
}
public async Task <bool> Save(string code, string contentType, Office365LogContext db)
{
ActivityService service = new ActivityService();
IEnumerable <ActivityContent> contents = await service.GetContentListAsync(code, contentType);
foreach (ActivityContent content in contents)
{
IEnumerable <ActivityDetail> details = await service.GetDetailsAsync(code, content.contentId);
foreach (ActivityDetail detail in details)
{
ActivityLogs activityLog = new ActivityLogs();
activityLog.ClientIp = detail.ClientIP;
activityLog.CorrelationId = detail.CorrelationId;
activityLog.CreationTime = detail.CreationTime;
activityLog.EventSource = detail.EventSource;
activityLog.Id = detail.Id;
activityLog.ItemType = detail.ItemType;
activityLog.ListId = detail.ListId;
activityLog.ListItemUniqueId = detail.ListItemUniqueId;
activityLog.ObjectId = detail.ObjectId;
activityLog.Operation = detail.Operation;
activityLog.OrganizationId = detail.OrganizationId;
activityLog.RecordType = detail.RecordType;
activityLog.Site = detail.Site;
activityLog.SiteUrl = detail.SiteUrl;
activityLog.SourceFileExtension = detail.SourceFileExtension;
activityLog.SourceFileName = detail.SourceFileName;
activityLog.SourceRelativeUrl = detail.SourceRelativeUrl;
activityLog.UserAgent = detail.UserAgent;
activityLog.UserId = detail.UserId;
activityLog.UserKey = detail.UserKey;
activityLog.UserType = detail.UserType;
activityLog.Version = detail.Version;
activityLog.WebId = detail.WebId;
activityLog.Workload = detail.Workload;
db.ActivityLogs.Add(activityLog);
await db.SaveChangesAsync();
}
}
return(true);
}
public void clearAllTables()
{
Groups.RemoveRange(Groups);
AnswersByPhone.RemoveRange(AnswersByPhone);
//Rooms.RemoveRange(Rooms);
//Teachers.RemoveRange(Teachers);
MeasureInstructionsData.RemoveRange(MeasureInstructionsData);
OneMeasuresEvalData.RemoveRange(OneMeasuresEvalData);
OneMeasuresByGroupId.RemoveRange(OneMeasuresByGroupId);
MeasurementsByGroupId.RemoveRange(MeasurementsByGroupId);
Measurements.RemoveRange(Measurements);
ActiveExperiments.RemoveRange(ActiveExperiments);
Experiments.RemoveRange(Experiments);
Activities.RemoveRange(Activities);
ActivityLogs.RemoveRange(ActivityLogs);
//Students.RemoveRange(Students);
SaveChanges();
}
public static void CreateLogs(string ma_nguoi_dung, string ma_man_hinh, string thao_tac, string chi_tiet)
{
try
{
var data = new ActivityLogs();
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
data.ma_nguoi_dung = ma_nguoi_dung;
data.nguoi_tao = ma_nguoi_dung;
data.ma_man_hinh = ma_man_hinh;
data.thao_tac = thao_tac;
data.chi_tiet = chi_tiet;
data.ngay_tao = DateTime.Now;
dbConn.Insert(data);
}
}
catch (Exception ex)
{
}
}
public ActionResult ViewActivityLogs(int nID, int nUserID)
{
SessionObj oSessionobj = new SessionObj(Session);
if (nID > 0)
{
//_oActivityLogs = _oActivityLogsService.ge
}
else
{
_oActivityLogs = new ActivityLogs();
}
ActivityTable oActivityTable = new ActivityTable();
List <ActivityTable> _oActivityTables = new List <ActivityTable>()
{
};
ActivityTableService _oActivityTableService = new ActivityTableService();
_oActivityTables = _oActivityTableService.Gets(nUserID);
ViewBag.ActivityTables = _oActivityTables;
return(View());
}
async Task LoadItems()
{
IsBusy = true;
try
{
ActivityLogs.Clear();
var activityLogs = await DataStore.GetAllActivityLogsAsync(true);
foreach (var activityLog in activityLogs)
{
ActivityLogs.Add(activityLog);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public JsonResult UpdateDatabaseTable(UpdateObject oUpdateObject)
{
SessionObj oSessionobj = new SessionObj(Session);
string sFinalSP = "";
string sTableName = oUpdateObject.TableName;
string sSPName = "SP_ActivityLog";
string sColNames = "";
string sColValues = "";
string sWhereClause = oUpdateObject.WhereClause;
int nDBOperationID = oUpdateObject.DBOperationID;
string sRemarks = oUpdateObject.Remarks;
int nBranchID = 0;
for (int i = 0; i < oUpdateObject.ActivityColumns.Count(); i++)
{
sColNames = sColNames + oUpdateObject.ActivityColumns[i].ColumnName + '#';
sColValues = sColValues + oUpdateObject.ActivityColumns[i].ColumnData + '#';
}
if (nDBOperationID != 3)
{
sColNames = sColNames.Remove(sColNames.Length - 1, 1);
sColValues = sColValues.Remove(sColValues.Length - 1, 1);
}
sFinalSP = "EXEC " + sSPName + " '" + sTableName + "', '" + sColNames + "', '" + sColValues + "', '" + sWhereClause + "', " + nBranchID + ", " + nDBOperationID + ", '" + sRemarks + "'";
_oActivityLogs = new ActivityLogs();
DataSet oDataSet = new DataSet();
oDataSet = _oActivityLogsService.UpdateDatabaseTable(sFinalSP, 1);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(oDataSet.Tables[1]);
JavaScriptSerializer serializer = new JavaScriptSerializer();
string sjson = serializer.Serialize(JSONString);
return(Json(sjson, JsonRequestBehavior.AllowGet));
}
public void SaveOrUpdate(ActivityLogs entity)
{
_activityLogsRepository.SaveOrUpdate(entity);
}
public void SaveChanges(ActivityLogs entity)
{
_activityLogsRepository.SaveChanges(entity);
}
public ActivityLogs GetByExpression(ActivityLogs entity)
{
return _activityLogsRepository.GetByExpression(x => x.Type.Equals(entity.Type));
}
public Guid Create(ActivityLogs entity)
{
return _activityLogsRepository.Create(entity);
}
public ActivityLogs InsertActivityLog(ActivityLogs activityLog)
{
return(_customUserServices.InsertActivityLog(activityLog));
}
public ActivityLogData getActivityLog(long id)
{
return(ActivityLogs.SingleOrDefault(a => a.id == id));
}
public void addActivityLog(ActivityLogData activityLog)
{
ActivityLogs.Add(activityLog);
SaveChanges();
}
