// PRONAĐI ACC U ACCROLEMAPP (jedna vrijednost) public AccRoleMapp findAccRoleMapp(string id) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { int cid = Convert.ToInt32(id); return(ben.AccRoleMappTables.Where(acm => acm.AccID == cid).Select(acmt => new AccRoleMapp { AccId = acmt.AccID, }).First()); } }
// PRONAĐI SVE ROLE VEZTANE ZA POJEDINI RAČUN public List <ManyToManyFindRolAcc> findAllRolByAcc(string id) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { int cid = Convert.ToInt32(id); var x = from c in ben.RoleTables join d in ben.AccRoleMappTables on c.RoleID equals d.RoleID where d.AccID == cid select new ManyToManyFindRolAcc { ImeRole = c.ImeRole, RoleID = c.RoleID }; return(x.ToList()); } }
// PRONAĐI SVE RAČUNE PREMA ROLI public List <ManyToManyFindAccRole> findAllAccByRol(string id) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { int cid = Convert.ToInt32(id); var x = from b in ben.AccountTables join a in ben.AccRoleMappTables on b.AccID equals a.AccID where a.RoleID == cid select new ManyToManyFindAccRole { AccID = b.AccID, ImeAccounta = b.ImeAcc, TipAccounta = b.TipAcc, RoleID = a.RoleID }; return(x.ToList()); } }
// PRONAĐI SVE RAČUNE public List <Account> findAllAcc() { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { return(ben.AccountTables.Select(at => new Account { Id = at.AccID, Ime = at.ImeAcc, Tip = at.TipAcc, Kreirano = at.Kreirano, Izmjena = at.Izmjena }).ToList()); } }
// PRONAĐI SPECIFIČAN RAČUN (PREMA ID-ju) public Account findAcc(string id) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { int cid = Convert.ToInt32(id); return(ben.AccountTables.Where(at => at.AccID == cid).Select(ata => new Account { Id = ata.AccID, Ime = ata.ImeAcc, Tip = ata.TipAcc, Kreirano = ata.Kreirano, Izmjena = ata.Izmjena }).First()); } }
// REMOVE ROLE FROM ACC public bool removeRoleFromAcc(AccRoleMapp accrolemapp) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { int cid = Convert.ToInt32(accrolemapp.AccId); AccRoleMappTable armt = ben.AccRoleMappTables.Single(arm => arm.AccID == cid); ben.AccRoleMappTables.Remove(armt); ben.SaveChanges(); return(true); } catch { return(false); } } }
// ADD ROLE TO ACC public bool addRoleToAcc(AccRoleMapp accrolemapp) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { AccRoleMappTable armt = new AccRoleMappTable(); armt.RoleID = accrolemapp.RoleId; ben.AccRoleMappTables.Add(armt); ben.SaveChanges(); return(true); } catch { return(false); } } }
// OBRIŠI JEDAN ACCOUNT public bool deleteAcc(Account account) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { int cid = Convert.ToInt32(account.Id); AccountTable at = ben.AccountTables.Single(ata => ata.AccID == cid); ben.AccountTables.Remove(at); ben.SaveChanges(); return(true); } catch { return(false); } } }
// KREIRAJ NOVI RAČUN public bool createAcc(Account account) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { AccountTable at = new AccountTable(); at.ImeAcc = account.Ime; at.TipAcc = account.Tip; at.Kreirano = account.Kreirano; at.Izmjena = account.Izmjena; ben.AccountTables.Add(at); ben.SaveChanges(); return(true); } catch { return(false); } } }
// UPDATE ACCOUNT public bool updateAccData(Account account) { using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { int cid = Convert.ToInt32(account.Id); AccountTable at = ben.AccountTables.Single(ata => ata.AccID == cid); at.ImeAcc = account.Ime; at.TipAcc = account.Tip; at.Kreirano = account.Kreirano; at.Izmjena = account.Izmjena; ben.SaveChanges(); return(true); } catch { return(false); } } }
// ADD ACCOUNT TO ROLE (CREATE) public bool addAccToRole(AccRoleMapp accrolemapp) { int idRole = Convert.ToInt32(accrolemapp.RoleId); int idAccounta = Convert.ToInt32(accrolemapp.AccId); using (BazaAccountManEntities ben = new BazaAccountManEntities()) { try { AccRoleMappTable armt = new AccRoleMappTable(); armt.RoleID = idRole; armt.AccID = idAccounta; ben.AccRoleMappTables.Add(armt); ben.SaveChanges(); return(true); } catch { return(false); } } }