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; } }