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