protected IList <Audit_DTO> GetAudit(string row_id, string table_name)
{
_dbcontext = new InnonAnalyticsEngineEntities();
IQueryable <tblAudit> audits = _dbcontext.tblAudits.Where(audit => audit.Table_Row_Id == row_id && audit.Table_Name == table_name).OrderByDescending(order => order.Last_Update);
return(Convert_Aduit.Convert(audits.ToList()));
}
protected Audit_DTO GetLastAudit(string row_id, string table_name)
{
_dbcontext = new InnonAnalyticsEngineEntities();
tblAudit _audit = _dbcontext.tblAudits.Where(audit => audit.Table_Row_Id == row_id && audit.Table_Name == table_name).OrderByDescending(order => order.Last_Update).FirstOrDefault();
return(Convert_Aduit.Convert(_audit));
}
protected Audit_DTO GetLastAudit(string row_id, string table_name, LivePoint_DTO livepoint_dto)
{
_dbcontext = new InnonAnalyticsEngineEntities();
tblAudit _audit = _dbcontext.tblAudits.Where(audit => audit.Table_Row_Id == row_id && audit.Table_Name == table_name).OrderByDescending(order => order.Last_Update).FirstOrDefault();
if (_audit != null)
{
livepoint_dto.Last_Changes = $"Previous value {_audit.Old_Values}, Change by {_audit.User_Id}";
livepoint_dto.Last_Updated = _audit.Last_Update;
}
return(Convert_Aduit.Convert(_audit));
}
protected void SaveAduit(string user_id, string row_id, string table_name, string old_values, string new_values, string comments)
{
try
{
_dbcontext = new InnonAnalyticsEngineEntities();
Audit_DTO audit_dto = new Audit_DTO();
audit_dto.Comments = comments;
audit_dto.New_Values = new_values;
audit_dto.Old_Values = old_values;
audit_dto.Table_Name = table_name;
audit_dto.Table_Row_Id = row_id;
audit_dto.User_Id = user_id;
tblAudit tbl_audit = Convert_Aduit.Convert(audit_dto);
_dbcontext.tblAudits.Add(tbl_audit);
_dbcontext.SaveChanges();
_dbcontext.Dispose();
}
catch (Exception ex)
{
}
}