public bool EmpDelete(employee employee)
{
using (var context = new LuxoftDBEntities1())
{
var employee1 = context.employees.Where(i => i.id == employee.id)
.Single();
employee1.deactivaed = true;
context.Entry(employee1).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
public PieChartModel GetPieChartData()
{
PieChartModel model = new PieChartModel();
using (var context = new LuxoftDBEntities1())
{
model.TotalCount = context.employees.Count();
var Employees = (from employee in context.employees
where employee.deactivaed == false
select employee
);
model.ActiveCount = Employees.Count();
model.InActiveCount = model.TotalCount - model.ActiveCount;
}
return(model);
}
public EmployeeModel GetData(int page, string sortCol = "createdDate_desc")
{
using (var context = new LuxoftDBEntities1())
{
EmployeeModel model = new EmployeeModel();
model.PageIndex = page;
model.PageSize = 1;
int startIndex = (page - 1) * model.PageSize;
var Employees = (from employee in context.employees
where employee.deactivaed == false
select employee
);
model.RecordCount = Employees.Count();
switch (sortCol)
{
case "name":
Employees = Employees.OrderBy(employee => employee.name);
break;
case "address":
Employees = Employees.OrderBy(employee => employee.address);
break;
case "createdDate":
Employees = Employees.OrderBy(employee => employee.createdDate);
break;
case "name_desc":
Employees = Employees.OrderByDescending(employee => employee.name);
break;
case "address_desc":
Employees = Employees.OrderByDescending(employee => employee.address);
break;
case "createdDate_desc":
Employees = Employees.OrderByDescending(employee => employee.createdDate);
break;
}
model.Employees = Employees
.Skip(startIndex)
.Take(model.PageSize).ToList();
return(model);
}
}
public bool AddEmployee(employee employee)
{
using (var context = new LuxoftDBEntities1())
{
employee.createdDate = DateTime.Now;
employee.deactivaed = false;
employee.dob = DateTime.Now;
if (employee.id != 0)
{
context.Entry(employee).State = EntityState.Modified;
}
else
{
context.employees.Add(employee);
}
context.SaveChanges();
}
// Add product
return(true);
}
