public bool AddOutsourcingCompany(HiringCompanyData.OutsourcingCompany oCompany) { using (var access = new AccessDB()) { HiringCompanyData.OutsourcingCompany oc = access.OcActions.FirstOrDefault(f => f.Name.Equals(oCompany.Name)); if (oc == null) { access.OcActions.Add(oCompany); int i = access.SaveChanges(); if (i > 0) { Log.Info("Successfully added outsourcing company into DB"); return(true); } return(false); } else { Log.Warn("Outsourcing company already exists in DB"); return(false); } } }
public int GetHcIdForUser(string username) { using (var access = new AccessDB()) { Log.Info("Successfully returned company id for employee username."); var employee = access.Actions.Include(x => x.HiringCompanyId).FirstOrDefault(f => f.Username.Equals(username)); return(employee.HiringCompanyId.IDHc); } }
/// <summary> /// Method returns instance of Employee only if username and password maches /// return null if it doesnt /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public Employee GetEmployee(string username, string password) { Log.Debug("Enter GetEmployee method."); using (var access = new AccessDB()) { Employee employee = access.Actions.FirstOrDefault(f => f.Username.Equals(username) && f.Password.Equals(password)); Log.Info("Successfully returned employee"); return(employee); } }
public List <Employee> GetReallyEmployees() { Log.Debug("Enter GetReallyEmployees method."); using (var access = new AccessDB()) { List <Employee> employees = new List <Employee>(20); foreach (var em in access.Actions) { employees.Add(em); } Log.Info("Successfully returned list of employees"); return(employees); } }
public List <Project> GetProjects() { Log.Debug("Enter GetProjects method."); using (var access = new AccessDB()) { List <Project> ret = new List <Project>(); foreach (var pr in access.PrActions) { ret.Add(pr); } Log.Info("Successfully returned list of projects."); return(ret); } }
public List <Project> GetPartnershipProjects(int hiringCompanyTr) { using (var access = new AccessDB()) { List <Project> ret = new List <Project>(); List <OutsourcingCompany> oc = new List <OutsourcingCompany>(); oc = GetPartnerOc(hiringCompanyTr); var allProjectList = access.PrActions.Include(x => x.Company); //List<Project> projects = allProjectList as List<Project>; //foreach (var ocItem in allProjectList) //{ foreach (var o in oc) { //var project = access.PrActions.Include(x => x.Company).FirstOrDefault(f => f.Company.Id.Equals(o.Id)); foreach (Project pr in allProjectList) { if (pr.Company != null) { if (pr.Company.Id.Equals(o.Id)) { Project p = new Project(); p.Name = pr.Name; p.Id = pr.Id; p.ProjectState = pr.ProjectState; p.Description = pr.Description; ret.Add(p); } } } } if (ret.Count == 0) { Log.Warn("No project to return"); } else { Log.Info("Successfully returned project"); } return(ret); } }
public HiringCompany GetHiringCompanyFromThr(int hiringCompanyThr) { Log.Debug("Enter GetCompany method."); using (var acces = new AccessDB()) { HiringCompany cm = acces.HcActions.FirstOrDefault(f => f.CompanyIdThr == hiringCompanyThr); if (cm != null) { Log.Info("Successfully returned hiring company data."); } else { Log.Warn("Company with thad id doesn't exists in DB"); } return(cm); } }
public List <UserStory> GetUserStory(string projectName) { using (var access = new AccessDB()) { List <UserStory> ret = new List <UserStory>(); foreach (UserStory us in access.UsAction) { if (us.Project.Name.Equals(projectName)) { ret.Add(us); } } Log.Info("Successfully returned user stories for specified project name."); return(ret); } }
public UserStory GetUserStoryFromId(int id) { using (var access = new AccessDB()) { UserStory us = access.UsAction.FirstOrDefault(f => f.Id == id); if (us != null) { Log.Info("Successfully returned user story for specified id."); } else { Log.Warn("User story for specified id doesn't exist."); } return(us); } }
public List <Employee> GetAllNotSignedInEmployees() { Log.Debug("Enter GetAllNotSignedInEmployees method."); using (var access = new AccessDB()) { List <Employee> employees = new List <Employee>(20); foreach (var em in access.Actions) { if (!em.Login) { employees.Add(em); } } Log.Info("Successfully returned not signedIn employees"); return(employees); } }
public Project GetProject(string name) { using (var access = new AccessDB()) { Project p = access.PrActions.FirstOrDefault(f => f.Name.Equals(name)); if (p == null) { Log.Warn("Project with specified name doesn't exist in DB."); } else { Log.Info("Successfully returned project from DB."); } return(p); } }
public OutsourcingCompany GetOutsourcingCompany(string name) { using (var access = new AccessDB()) { HiringCompanyData.OutsourcingCompany oc = access.OcActions.FirstOrDefault(f => f.Name.Equals(name)); if (oc == null) { Log.Warn("Requestet Outsourcing company doesn't exists in DB."); } else { Log.Info("Successfully returned Outsourcing company with specified name."); } return(oc); } }
public String GetEmployeeEmail(string username) { Log.Debug("Enter GetEmployeeEmail method."); using (var access = new AccessDB()) { Employee emp = access.Actions.FirstOrDefault(f => f.Username.Equals(username)); if (emp != null) { Log.Info("Successfully returned employee email"); return(emp.Email); } else { Log.Warn("Employee with that username does not exist. Failed to retrieve email."); return(string.Empty); } } }
public bool UpdateEmployee(Employee employee) { Log.Debug("Enter UpdateEmployee method."); using (var access = new AccessDB()) { //access.Actions.Attach(employee); Employee em = access.Actions.FirstOrDefault(f => f.Email.Equals(employee.Email)); if (em != null) { Log.Debug("Employee exists"); em.Email = employee.Email; em.EndTime = employee.EndTime; em.HiringCompanyId = employee.HiringCompanyId; em.Login = employee.Login; em.Name = employee.Name; em.Password = employee.Password; em.PasswordUpadateDate = employee.PasswordUpadateDate; em.Position = employee.Position; em.StartTime = employee.StartTime; em.Surname = employee.Surname; em.Username = employee.Username; //access.Entry(employee).State = System.Data.Entity.EntityState.Modified; int i = access.SaveChanges(); if (i > 0) { Log.Info("Successfully updated DB"); return(true); } Log.Warn("Failed to update DB"); return(false); } else { Log.Warn("Employee with that username does not exist. Failed updating employee."); return(false); } } }
public bool SetOcToProject(string projectName, int outsourcingCompanyId) { using (var access = new AccessDB()) { Project p = access.PrActions.FirstOrDefault(f => f.Name.Equals(projectName)); if (p != null) { OutsourcingCompany oc = access.OcActions.FirstOrDefault(f => f.IdFromOutSourcingDB == outsourcingCompanyId); if (oc != null) { p.Company = oc; access.OcActions.Attach(p.Company); } else { Log.Warn("Outsourcing company doesn't exists."); } int i = access.SaveChanges(); if (i > 0) { Log.Info("Successfully assigned project to Outsourcing company."); return(true); } else { return(false); } } else { Log.Warn("Project doesn't exists."); return(false); } } }
public List <OutsourcingCompany> GetOutsourcingCompanies() { using (var access = new AccessDB()) { List <OutsourcingCompany> ret = new List <OutsourcingCompany>(); foreach (var oc in access.OcActions) { ret.Add(oc); } if (ret != null) { Log.Info("Successfully returned list of outsourcing companies."); } else { Log.Warn("No outsourcing company to show."); } return(ret); } }