// UREDI SAMO ROLU ZAPOSLENIKA
public bool editOnlyEmpRol(Employee employee)
{
string prviURI = "removeaccfromemployee";
string prviZaj = BASE_URL_ASSIGN + prviURI;
string drugiURI = "addacctoemployee";
string drugiZaj = BASE_URL_ASSIGN + drugiURI;
int oldRole = 0;
int newRoleID = 0;
string newRolID = null;
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
int cid = Convert.ToInt32(employee.Id);
EmployeeTable et = ben.EmployeeTables.Single(ete => ete.ZaposlenikID == cid);
oldRole = et.RoleID;
et.RoleID = employee.RoleID;
ben.SaveChanges();
newRoleID = et.RoleID;
newRolID = newRoleID.ToString();
}
catch
{
return(false);
}
// pozivanje removeAccFromEmployee
int employeeId = employee.Id; // id zaposlenika koji se prosljeđuje
EmpAccMapp empaccmappDel = new EmpAccMapp(employeeId, oldRole);
DataContractJsonSerializer serDel = new DataContractJsonSerializer(typeof(EmpAccMapp));
MemoryStream memDel = new MemoryStream();
serDel.WriteObject(memDel, empaccmappDel);
string dataDel = Encoding.UTF8.GetString(memDel.ToArray(), 0, (int)memDel.Length);
WebClient webClientDel = new WebClient();
webClientDel.Headers["Content-type"] = "application/json";
webClientDel.Encoding = Encoding.UTF8;
webClientDel.UploadString(prviZaj, "DELETE", dataDel);
// pozivanje addAccountToEmployee
EmpAccMapp empaccmappAdd = new EmpAccMapp(employee.Id, employee.RoleID);
DataContractJsonSerializer serAdd = new DataContractJsonSerializer(typeof(EmpAccMapp));
MemoryStream memAdd = new MemoryStream();
serAdd.WriteObject(memAdd, empaccmappAdd);
string dataAdd = Encoding.UTF8.GetString(memAdd.ToArray(), 0, (int)memAdd.Length);
WebClient webClientAdd = new WebClient();
webClientAdd.Headers["Content-type"] = "application/json";
webClientAdd.Encoding = Encoding.UTF8;
webClientAdd.UploadString(drugiZaj, "POST", dataAdd);
return(true);
}
}
// PRONAĐI SVE ROLE
public List <Role> findAllRol()
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
return(ben.RoleTables.Select(rt => new Role
{
Id = rt.RoleID,
Ime = rt.ImeRole
}).ToList());
}
}
// PRONAĐI POJEDINU ROLU ZA ROLECHANGE
public RoleRoleChange findRolForRolechange(string id)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
int cid = Convert.ToInt32(id);
return(ben.RoleTables.Where(rt => rt.RoleID == cid).Select(rtr => new RoleRoleChange
{
Id = rtr.RoleID
}).First());
}
}
// PRONAĐI ZAPOSLENIKA U EMPACCMAPP TABLICI (AKO BUDE POTREBNO)
public EmpAccMapp findEmpAccMapp(string id)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
int cid = Convert.ToInt32(id);
return(ben.EmpAccMappTables.Where(eam => eam.ZaposlenikID == cid).Select(eamt => new EmpAccMapp
{
ZapId = eamt.ZaposlenikID,
AccId = eamt.AccID
}).First());
}
}
// PRONAĐI SAMO ROLU ZAPOSLENIKA (ZA ROLECHANGE)
public List <EmpRole> findRoleForEmp(string id)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
int cid = Convert.ToInt32(id);
var x = from b in ben.RoleTables
join a in ben.EmployeeTables on b.RoleID equals a.RoleID
where a.ZaposlenikID == cid
select new EmpRole {
RoleId = a.RoleID
};
return(x.ToList());
}
}
// PRONAĐI SVE ZAPOSLENIKE
public List <Employee> findAllEmp()
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
return(ben.EmployeeTables.Select(bt => new Employee
{
Id = bt.ZaposlenikID,
Ime = bt.ImeZap,
Prezime = bt.PrezimeZap,
Adresa = bt.AdresaZap,
Grad = bt.GradZap,
RoleID = bt.RoleID
}).ToList());
}
}
// PRONAĐI POJEDINOG ZAPOSLENIKA
public Employee findEmp(string id)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
int cid = Convert.ToInt32(id);
return(ben.EmployeeTables.Where(et => et.ZaposlenikID == cid).Select(ete => new Employee
{
Id = ete.ZaposlenikID,
Ime = ete.ImeZap,
Prezime = ete.PrezimeZap,
Adresa = ete.AdresaZap,
Grad = ete.GradZap,
RoleID = ete.RoleID
}).First());
}
}
// OBRIŠI JEDNU ROLU
public bool deleteRol(Role role)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
int cid = Convert.ToInt32(role.Id);
RoleTable rt = ben.RoleTables.Single(rtr => rtr.RoleID == cid);
ben.RoleTables.Remove(rt);
ben.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
// OBRIŠI JEDNOG ZAPOSLENIKA
public bool deleteEmp(Employee employee)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
int cid = Convert.ToInt32(employee.Id);
EmployeeTable et = ben.EmployeeTables.Single(ete => ete.ZaposlenikID == cid);
ben.EmployeeTables.Remove(et);
ben.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
// KREIRAJ ROLU
public bool createRol(Role role)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
RoleTable rt = new RoleTable();
rt.ImeRole = role.Ime;
ben.RoleTables.Add(rt);
ben.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
// KREIRAJ ZAPOSLENIKA
public bool createEmp(Employee employee)
{
string uriAddAccToEmp = "addacctoemployee";
string zajednoURI = BASE_URL_ASSIGN + uriAddAccToEmp;
int empID = 0;
int roleID = 0;
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
EmployeeTable emt = new EmployeeTable();
emt.ImeZap = employee.Ime;
emt.PrezimeZap = employee.Prezime;
emt.AdresaZap = employee.Adresa;
emt.GradZap = employee.Grad;
emt.RoleID = employee.RoleID;
ben.EmployeeTables.Add(emt);
ben.SaveChanges();
empID = emt.ZaposlenikID;
roleID = emt.RoleID;
}
catch
{
return(false);
}
}
// pozivanje AddAccountToEmployee
EmpAccMapp empaccmapp = new EmpAccMapp(empID, roleID);
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(EmpAccMapp));
MemoryStream mem = new MemoryStream(); ser.WriteObject(mem, empaccmapp);
string data = Encoding.UTF8.GetString(mem.ToArray(), 0, (int)mem.Length);
WebClient webClient = new WebClient();
webClient.Headers["Content-type"] = "application/json";
webClient.Encoding = Encoding.UTF8;
webClient.UploadString(zajednoURI, "POST", data);
return(true);
}
// UREDI ZAPOSLENIKA (BEZ ROLE)
public bool editEmp(Employee employee)
{
using (BazaEmployeeEntities ben = new BazaEmployeeEntities())
{
try
{
int cid = Convert.ToInt32(employee.Id);
EmployeeTable et = ben.EmployeeTables.Single(ete => ete.ZaposlenikID == cid);
et.ImeZap = employee.Ime;
et.PrezimeZap = employee.Prezime;
et.AdresaZap = employee.Adresa;
et.GradZap = employee.Grad;
ben.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
