public int UpdateSessionAuditTrail(SessionAuditTrail pSessionAuditTrail)
{
var _auditTrail = (from p in context.SessionAuditTrail
where p.AuditTrailId == pSessionAuditTrail.AuditTrailId
select p).FirstOrDefault();
if (_auditTrail != null)
{
context.Entry(_auditTrail).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
return(context.SaveChanges());
}
return(0);
}
public int InsertSessionAuditTrail(User luser, string type, string status, string loginid)
{
int result = 0;
try
{
if (luser != null)
{
SessionAuditTrail ltrail = new SessionAuditTrail();
ltrail.SessionId = luser.LoginSessionId;
ltrail.SessionType = type;
ltrail.SessionStatus = status;
ltrail.LinkedSession = "";
ltrail.SessionOpenTime = DateTime.Now;
ltrail.UserId = luser.UserId;
ltrail.Type = Utilities.getUserType(luser.Type.ToString());
ltrail.Name = luser.Name;
ltrail.EmailId = luser.Email;
ltrail.PasswordUsed = luser.Password;
int res = InsertSessionAuditTrail(ltrail);
if (res > 0 && ltrail.AuditTrailId > 0 && !string.IsNullOrEmpty(loginid))
{
List <SessionAuditTrail> ltrailList = GetSessionAuditTrailByUserId(ltrail.UserId, "forced logout", type, loginid);
if (ltrailList != null && ltrailList.Count > 0)
{
foreach (SessionAuditTrail sTrail in ltrailList)
{
sTrail.LinkedSession = ltrail.SessionId;
int lupdateres = UpdateSessionAuditTrail(sTrail);
if (lupdateres > 0)
{
result = result + 1;
}
}
}
else
{
result = res;
}
}
else
{
result = res;
}
}
}
catch (Exception ex)
{
}
return(result);
}
public int InsertSessionAuditTrail(SessionAuditTrail pSessionAuditTrail)
{
context.SessionAuditTrail.Add(pSessionAuditTrail);
return(context.SaveChanges());
}
