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