public bool Insert(SecurityUserApplication pSecurityUserApplication)
{
try
{
rep.Add(pSecurityUserApplication);
rep.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <SecurityUserApplication> GetByUserCode(string pUserCode)
{
List <SecurityUserApplication> vList = new List <SecurityUserApplication>();
//IRepository<SecurityApplication> repSA = new Repository<SecurityApplication>(ctx);
try
{
var query = from app in ctx.SecurityApplications
join userApp in ctx.SecurityUserApplications.Where(o => o.UserCode == pUserCode) on
app.ApplicationCode equals userApp.ApplicationCode into Details
from ua in Details.DefaultIfEmpty()
select new { app.ID, app.ApplicationCode, app.ApplicationName, ua };
foreach (var eachItem in query)
{
if (eachItem.ua != null)
{
eachItem.ua.ApplicationID = eachItem.ID;
eachItem.ua.ApplicationName = eachItem.ApplicationName;
vList.Add(eachItem.ua);
}
else
{
SecurityUserApplication oNew = new SecurityUserApplication();
oNew.ApplicationID = eachItem.ID;
oNew.ApplicationCode = eachItem.ApplicationCode;
oNew.UserCode = pUserCode;
oNew.AllowFlag = "N";
oNew.ApplicationName = eachItem.ApplicationName;
vList.Add(oNew);
}
}
return(vList);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Edit(SecurityUserApplication pSecurityUserApplication)
{
try
{
if (pSecurityUserApplication.ID > 0)
{
SecurityUserApplication vSecurityUserApplication = rep.Find(pSecurityUserApplication.ID);
if (vSecurityUserApplication != null)
{
rep.Edit(vSecurityUserApplication);
rep.SaveChanges();
return(true);
}
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
