/// <summary>
/// Create a proxy guid for requested purpose
/// </summary>
/// <param name="userId"></param>
/// <param name="proxyType"></param>
/// <param name="statusMessage"></param>
/// <returns></returns>
public string Create_ProxyLoginId(int userId, string proxyType, int expiryDays, ref string statusMessage)
{
EM.System_ProxyCodes efEntity = new EM.System_ProxyCodes();
string proxyId = "";
try
{
using (var context = new EntityContext())
{
efEntity.UserId = userId;
efEntity.ProxyCode = Guid.NewGuid().ToString();
//assuming if generated, not for identity
efEntity.IsIdentityProxy = false;
efEntity.Created = System.DateTime.Now;
if (proxyType == SessionLoginProxy)
{
//expire at midnight - not really good for night owls
//efEntity.ExpiryDate = new System.DateTime( DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59 );
efEntity.ExpiryDate = System.DateTime.Now.AddDays(expiryDays);
}
else
{
efEntity.ExpiryDate = System.DateTime.Now.AddDays(expiryDays);
}
efEntity.IsActive = true;
efEntity.ProxyType = proxyType;
context.System_ProxyCodes.Add(efEntity);
// submit the change to database
int count = context.SaveChanges();
if (count > 0)
{
statusMessage = "Successful";
int id = efEntity.Id;
return(efEntity.ProxyCode);
}
else
{
//?no info on error
return(proxyId);
}
}
}
catch (Exception ex)
{
LoggingHelper.LogError(ex, thisClassName + ".Create_Proxy()");
statusMessage = ex.Message;
return(proxyId);
}
}
public bool InactivateProxy(string proxyCode, ref string statusMessage)
{
bool isValid = true;
using (var context = new EntityContext())
{
EM.System_ProxyCodes proxy = context.System_ProxyCodes.FirstOrDefault(s => s.ProxyCode == proxyCode);
if (proxy != null && proxy.Id > 0)
{
proxy.IsActive = false;
proxy.AccessDate = System.DateTime.Now;
context.SaveChanges();
}
}
return(isValid);
}
public bool Proxy_IsCodeActive(string proxyCode)
{
bool isValid = false;
using (var context = new EntityContext())
{
EM.System_ProxyCodes proxy = context.System_ProxyCodes.FirstOrDefault(s => s.ProxyCode == proxyCode);
if (proxy != null && proxy.Id > 0)
{
if (proxy.IsActive &&
proxy.ExpiryDate > DateTime.Now)
{
isValid = true;
}
}
}
return(isValid);
}
public bool Store_ProxyCode(string proxyCode, int userId, string proxyType, int expiryDays, ref string statusMessage)
{
bool isValid = true;
EM.System_ProxyCodes efEntity = new EM.System_ProxyCodes();
//string proxyId = "";
try
{
using (var context = new EntityContext())
{
efEntity.UserId = userId;
efEntity.ProxyCode = proxyCode;
//assuming if storing existing, likely for identity
efEntity.IsIdentityProxy = true;
efEntity.Created = System.DateTime.Now;
efEntity.ExpiryDate = System.DateTime.Now.AddDays(expiryDays);
efEntity.IsActive = true;
efEntity.ProxyType = proxyType;
context.System_ProxyCodes.Add(efEntity);
int count = context.SaveChanges();
if (count > 0)
{
statusMessage = "Successful";
int id = efEntity.Id;
}
else
{
//?no info on error
return(false);
}
}
}
catch (Exception ex)
{
LoggingHelper.LogError(ex, thisClassName + ".Store_ProxyCode()");
statusMessage = ex.Message;
return(false);
}
return(isValid);
}
