// UKLONI RAČUN OD ZAPOSLENIKA
public bool removeAccFromEmployee(EmpAccMapp empaccmapp)
{
string findAccURI = "findallaccbyrol/{0}";
string zajednoURI = BASE_URL_ACCMAN + findAccURI;
var webclient = new WebClient();
string url = string.Format(zajednoURI, empaccmapp.RoleId);
var json = webclient.DownloadString(url);
var js = new JavaScriptSerializer();
List <ManyToManyFindAccRole> listaIspis = js.Deserialize <List <ManyToManyFindAccRole> >(json);
using (BazaAccAssignEntities ben = new BazaAccAssignEntities())
{
try
{
List <EmpAccMappTable> eamList = new List <EmpAccMappTable>();
int cid = Convert.ToInt32(empaccmapp.ZapId);
foreach (var obj in listaIspis)
{
EmpAccMappTable eamt = new EmpAccMappTable();
ben.EmpAccMappTables.RemoveRange(ben.EmpAccMappTables.Where(eam => eam.ZaposlenikID == cid));
ben.SaveChanges();
}
ben.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
// PRONAĐI SVE RAČUNE
public List <EmpAccMapp> findEmpAcc()
{
using (BazaAccAssignEntities ben = new BazaAccAssignEntities())
{
return(ben.EmpAccMappTables.Select(at => new EmpAccMapp
{
ZapId = at.ZaposlenikID,
AccId = at.AccID
}).ToList());
}
}
// PRONAĐI SVE RAČUNE POJEDINOG ZAPOSLENIKA
public List <ManyToManyEmpAcc> findAllAccForEmp(string id)
{
using (BazaAccAssignEntities ben = new BazaAccAssignEntities())
{
int cid = Convert.ToInt32(id);
var x = from b in ben.AccountTables
join a in ben.EmpAccMappTables on b.AccID equals a.AccID
where a.ZaposlenikID == cid
select new ManyToManyEmpAcc {
AccID = b.AccID, ImeAcc = b.ImeAcc, TipAcc = b.TipAcc
};
return(x.ToList());
}
}
