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