//Method to add review details public int Add(Review_Details reviewDetail) { int count = 0; IList <Review_Details> li = null; List <Review_Details> review = null; using (EmployeeContext employeeContext = new EmployeeContext()) { review = employeeContext.Review_Detail.ToList(); li = review.FindAll(p => (p.Revieweename == reviewDetail.Reviewername && p.Date == reviewDetail.Date)); if (li.Count != 0) { count = -4; return(count); } li = review.FindAll(p => (p.Revieweename == reviewDetail.Revieweename && p.Date == reviewDetail.Date)); if (li.Count != 0) { count = -5; return(count); } li = review.FindAll(p => (p.Reviewername == reviewDetail.Revieweename && p.Date == reviewDetail.Date)); if (li.Count != 0) { count = -5; return(count); } employeeContext.Entry(reviewDetail).State = EntityState.Added; count = employeeContext.SaveChanges(); return(count); } }
//Method to delete department public void DeleteDepartments(int departmentId) { using (EmployeeContext employeeContext = new EmployeeContext()) { Departments departments = GetEmployeeById(departmentId); employeeContext.Entry(departments).State = EntityState.Deleted; employeeContext.SaveChanges(); } }
//Method to update employee public bool UpdateEmployee(Employee employee) { using (EmployeeContext employeeContext = new EmployeeContext()) { employeeContext.Entry(employee).State = EntityState.Modified; employeeContext.SaveChanges(); return(true); } }
//Method to update review details public bool UpdateReview(Review_Details reviewDetail) { using (EmployeeContext employeeContext = new EmployeeContext()) { employeeContext.Entry(reviewDetail).State = EntityState.Modified; employeeContext.SaveChanges(); return(true); } }
//Method to add department public bool AddDepartments(Departments departments) { using (EmployeeContext employeeContext = new EmployeeContext()) { // SqlParameter sql = new SqlParameter("@DepartmentName", departments.DepartmentName); // int count = employeeContext.Database.ExecuteSqlCommand("Departments_Insert @DepartmentName", sql); employeeContext.Entry(departments).State = EntityState.Added; employeeContext.SaveChanges(); } return(true); }
//Method to add emloyee details public AccountDetails AddAccountDetails(AccountDetails accountDetails) { using (EmployeeContext employeeContext = new EmployeeContext()) { //SqlParameter sqlUsername = new SqlParameter("@Username", accountDetails.Username); //SqlParameter sqlPassword = new SqlParameter("@Password", accountDetails.Password); //SqlParameter sqlRole = new SqlParameter("@Role", accountDetails.Role); //int count = employeeContext.Database.ExecuteSqlCommand("AccountDetails_Insert @Username,@Password,@Role", sqlUsername, sqlPassword, sqlRole); employeeContext.Entry(accountDetails).State = EntityState.Added; employeeContext.SaveChanges(); return(accountDetails); } }
//Method to delete review details public void Delete(int employeeId) { using (EmployeeContext employeeContext = new EmployeeContext()) { Review_Details reviewDetail = GetReviewDetailsById(employeeId); employeeContext.Entry(reviewDetail).State = EntityState.Deleted; employeeContext.SaveChanges(); //SqlParameter sqlEmployee = new SqlParameter("@Id", employee.Id); //employeeContext.Database.ExecuteSqlCommand("Employee_Delete @Id", sqlEmployee); //SqlParameter sqlAccount = new SqlParameter("@AccountId", accountdetails.AccountId); //employeeContext.Database.ExecuteSqlCommand("AccountDetails_Delete @AccountId", sqlAccount); } }
//Method to update account details public bool UpdatePassword(AccountDetails accountDetails) { AccountDetails accountdetails; using (EmployeeContext employeeContext = new EmployeeContext()) { accountdetails = employeeContext.Account.FirstOrDefault(p => p.Username == accountDetails.Username); if (accountdetails == null) { return(false); } accountdetails.Password = accountDetails.Password; employeeContext.Entry(accountdetails).State = EntityState.Modified; employeeContext.SaveChanges(); return(true); } }
//Method to add employee public Employee Add(Employee employee) { using (EmployeeContext employeeContext = new EmployeeContext()) { //SqlParameter sqlFirstname = new SqlParameter("@Firstname", employee.Firstname); //SqlParameter sqlLastname = new SqlParameter("@Lastname", employee.Lastname); //SqlParameter sqlEmailId = new SqlParameter("@EmailId", employee.EmailId); //SqlParameter sqlGender = new SqlParameter("@Gender", employee.Gender); //SqlParameter sqlMobilenumber = new SqlParameter("@Mobilenumber", employee.Mobilenumber); //SqlParameter sqlDOB = new SqlParameter("@DOB", employee.DOB); //SqlParameter sqlDOJ = new SqlParameter("@DOJ", employee.DOJ); //SqlParameter sqlDesignationId = new SqlParameter("@DesignationId", employee.DesignationId); //SqlParameter sqlDepartmentId = new SqlParameter("@DepartmentId", employee.DepartmentId); //SqlParameter sqlAccountId = new SqlParameter("@AccountId", employee.AccountId); //int count = employeeContext.Database.ExecuteSqlCommand("Employee_Insert @Firstname,@Lastname,@EmailId,@Gender,@Mobilenumber, @DOB, @DOJ, @DesignationId, @DepartmentId,@AccountId", sqlFirstname, sqlLastname, sqlEmailId, sqlGender, sqlMobilenumber, sqlDOB, sqlDOJ, sqlDesignationId, sqlDepartmentId, sqlAccountId); employeeContext.Entry(employee).State = EntityState.Added; employeeContext.SaveChanges(); return(employee); } }