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