public ActionResult EmployessList()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Employee> employeeList = db.Employee.ToList();
List <Models.EmployeeViewModel> employeeVMList = employeeList.Select(x => new Models.EmployeeViewModel
{
Name = x.Name,
EmployeeID = x.EmployeeID
}).ToList();
return(View(employeeVMList));
}
// GET: DataBase
public ActionResult Index()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
Employee employee = db.Employee.SingleOrDefault(x => x.EmployeeID == 2);
Models.EmployeeViewModel employeeVM = new Models.EmployeeViewModel();
employeeVM.EmployeeID = employee.EmployeeID;
employeeVM.Address = employee.Address;
employeeVM.DepartmentId = employee.DepartmentId;
employeeVM.Name = employee.Name;
return(View(employeeVM));
}
public ActionResult EmployeeDetails(int employeeId)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
Employee employee = db.Employee.SingleOrDefault(x => x.EmployeeID == employeeId);
Models.EmployeeViewModel employeeViewModel = new Models.EmployeeViewModel();
employeeViewModel.EmployeeID = employee.EmployeeID;
employeeViewModel.Address = employee.Address;
employeeViewModel.DepartmentId = employee.DepartmentId;
employeeViewModel.Name = employee.Name;
employeeViewModel.DepartmentName = employee.Department.DepartmentName;
return(View(employeeViewModel));
}
public ActionResult GetSearchRecord(string SearchWord)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <EmployeeViewModel> employeeViewModels = db.Employee.Where(x => x.Name.Contains(SearchWord) || x.Department.DepartmentName.Contains(SearchWord)).Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
EmployeeID = x.EmployeeID,
Name = x.Name,
DepartmentName = x.Department.DepartmentName
}).ToList();
return(PartialView("SearchEmployeePartial", employeeViewModels));
}
public ActionResult EmployeesInfo()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Employee> employeeList = db.Employee.ToList();
List <Models.EmployeeViewModel> employeeVMList = employeeList.Select(x => new Models.EmployeeViewModel
{
Name = x.Name,
EmployeeID = x.EmployeeID,
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName
}).ToList();
return(View(employeeVMList));
}
// GET: ISearchRecord
public ActionResult Index()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <EmployeeViewModel> listEmployees = db.Employee.Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
EmployeeID = x.EmployeeID,
Name = x.Name,
DepartmentName = x.Department.DepartmentName
}).ToList();
ViewBag.ListEmployees = listEmployees;
return(View());
}
public JsonResult DeleteEmployee(int EmployeeId)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
bool result = false;
DataBaseModels.Employee emp = db.Employee.SingleOrDefault(x => x.IsDeleted == false && x.EmployeeID == EmployeeId);
if (emp != null)
{
emp.IsDeleted = true;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public List <EmployeeDomainModel> GetAllEmployee()
{
MVCDataBaseEntities dbContext = new MVCDataBaseEntities();
List <EmployeeDomainModel> employeeDomainModels = new List <EmployeeDomainModel>();
employeeDomainModels = employeeRepository.GetAll().Select(m => new EmployeeDomainModel {
EmployeeID = m.EmployeeID, Name = m.Name
}).ToList();
//employeeDomainModels = dbContext.Employees.Select(m => new EmployeeDomainModel { EmployeeID = m.EmployeeID, Name = m.Name }).ToList();
//employeeDomainModels.Add(new EmployeeDomainModel { EmployeeID = 1, Name = "Jose" });
return(employeeDomainModels);
}
public ActionResult ShowEmployee(int EmployeeId)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <EmployeeViewModel> employeeList = db.Employee.Where(x => x.IsDeleted == false && x.EmployeeID == EmployeeId).Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
EmployeeID = x.EmployeeID,
Name = x.Name
}).ToList();
ViewBag.EmployeeList = employeeList;
return(PartialView("PartialExample"));
}
public ActionResult AddEditEmployee(int EmployeeId)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> listDep = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(listDep, "DepartmentId", "DepartmentName");
EmployeeViewModel employeeViewModel = new EmployeeViewModel();
if (EmployeeId > 0)
{
Employee employee = db.Employee.SingleOrDefault(x => x.IsDeleted == false && x.EmployeeID == EmployeeId);
employeeViewModel.EmployeeID = employee.EmployeeID;
employeeViewModel.Address = employee.Address;
employeeViewModel.Name = employee.Name;
employeeViewModel.DepartmentId = employee.DepartmentId;
}
return(PartialView("Partial2", employeeViewModel));
}
public ActionResult Index(EmployeeViewModel employeeViewModel)
{
try
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> departmentList = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(departmentList, "DepartmentID", "DepartmentName");
if (ModelState.IsValid)
{
DataBaseModels.Employee e = new DataBaseModels.Employee
{
Address = employeeViewModel.Address,
DepartmentId = employeeViewModel.DepartmentId,
Name = employeeViewModel.Name
};
db.Employee.Add(e);
db.SaveChanges();
int idEmp = e.EmployeeID;
DataBaseModels.Sites EmployeeSite = new DataBaseModels.Sites
{
EmployeeId = idEmp,
SiteName = employeeViewModel.SiteName
};
db.Sites.Add(EmployeeSite);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
return(View(employeeViewModel));
}
public ActionResult EmployeeList()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> departmentList = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(departmentList, "DepartmentID", "DepartmentName");
List <EmployeeViewModel> employeeList = db.Employee.Where(x => x.IsDeleted == false).Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
EmployeeID = x.EmployeeID,
Name = x.Name
}).ToList();
ViewBag.EmployeeList = employeeList;
return(View());
}
// GET: OJQueryDataTables
public ActionResult Index()
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> listDep = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(listDep, "DepartmentId", "DepartmentName");
List <EmployeeViewModel> listEmployeesVM = db.Employee.Where(x => x.IsDeleted == false).Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
Name = x.Name,
IsDeleted = x.IsDeleted,
EmployeeID = x.EmployeeID
}).ToList();
ViewBag.EmployeeList = listEmployeesVM;
return(View());
}
public JsonResult ImageUpload(ProductViewModel productViewModel)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
HttpPostedFileWrapper file = productViewModel.ImageFile;
byte[] imageByte = null;
string fileName = "";
int imageStoreId;
if (file != null)
{
fileName = Path.GetFileName(file.FileName);
string extension = Path.GetExtension(file.FileName);
string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(file.FileName);
file.SaveAs(Server.MapPath("/UploadedImages/" + fileName));
BinaryReader binaryReader = new BinaryReader(file.InputStream);
imageByte = binaryReader.ReadBytes(file.ContentLength);
//ImageStore imageStore = new ImageStore();
//imageStore.ImageName = file.FileName;
//imageStore.ImageByte = imageByte;
//imageStore.ImagePath = "/UploadedImages/" + fileName;
//imageStore.IsDeleted = false;
//db.ImageStore.Add(imageStore);
//db.SaveChanges();
//imageStoreId = imageStore.ImageId;
}
return(Json(fileName, JsonRequestBehavior.AllowGet));
}
public JsonResult RegisterUser(RegistrationViewModel registrationViewModel)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
bool result = false;
SiteUser siteUser = new SiteUser();
siteUser.Address = registrationViewModel.Address;
siteUser.EmailId = registrationViewModel.EmailId;
siteUser.Password = registrationViewModel.Password;
siteUser.RoleId = 3;
siteUser.UserName = registrationViewModel.UserName;
try
{
db.SiteUser.Add(siteUser);
db.SaveChanges();
result = true;
}
catch (Exception)
{
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(EmployeeViewModel employeeViewModel)
{
try
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> listDep = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(listDep, "DepartmentId", "DepartmentName");
if (employeeViewModel.EmployeeID > 0)
{
Employee employee = db.Employee.SingleOrDefault(x => x.EmployeeID == employeeViewModel.EmployeeID &&
x.IsDeleted == false);
employee.Name = employeeViewModel.Name;
employee.DepartmentId = employeeViewModel.DepartmentId;
employee.Address = employeeViewModel.Address;
db.SaveChanges();
}
else
{
Employee employee = new Employee();
employee.Name = employeeViewModel.Name;
employee.Address = employeeViewModel.Address;
employee.DepartmentId = employeeViewModel.DepartmentId;
employee.IsDeleted = false;
db.Employee.Add(employee);
db.SaveChanges();
}
}
catch (Exception e)
{
throw;
}
return(View(employeeViewModel));
}
public UnitOfWork()
{
_dbContext = new MVCDataBaseEntities();
}
public JsonResult getEmployeeList(DataTablesParam dataTablesParam, string EName)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <EmployeeViewModel> listEmployeesVM;
int pageNumber = 1;
int totalCount = 0;
if (dataTablesParam.iDisplayStart >= dataTablesParam.iDisplayLength)
{
pageNumber = (dataTablesParam.iDisplayStart / dataTablesParam.iDisplayLength) + 1;
}
if (dataTablesParam.sSearch != null)
{
totalCount = db.Employee.Where(x => x.Name.Contains(dataTablesParam.sSearch)).Count();
listEmployeesVM = db.Employee
.Where(x => x.Name.Contains(dataTablesParam.sSearch))
.OrderBy(x => x.EmployeeID)
.Skip((pageNumber - 1) * dataTablesParam.iDisplayLength)
.Take(dataTablesParam.iDisplayLength)
.Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
Name = x.Name,
IsDeleted = x.IsDeleted,
EmployeeID = x.EmployeeID
}).ToList();
}
else if (EName != "")
{
totalCount = db.Employee.Where(x => x.Department.DepartmentName.Contains(EName)).Count();
listEmployeesVM = db.Employee
.Where(x => x.Department.DepartmentName.Contains(EName))
.OrderBy(x => x.EmployeeID)
.Skip((pageNumber - 1) * dataTablesParam.iDisplayLength)
.Take(dataTablesParam.iDisplayLength)
.Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
Name = x.Name,
IsDeleted = x.IsDeleted,
EmployeeID = x.EmployeeID
}).ToList();
}
else
{
totalCount = db.Employee.Count();
listEmployeesVM = db.Employee
.OrderBy(x => x.EmployeeID)
.Skip((pageNumber - 1) * dataTablesParam.iDisplayLength)
.Take(dataTablesParam.iDisplayLength)
.Select(x => new EmployeeViewModel
{
Address = x.Address,
DepartmentId = x.DepartmentId,
DepartmentName = x.Department.DepartmentName,
Name = x.Name,
IsDeleted = x.IsDeleted,
EmployeeID = x.EmployeeID
}).ToList();
}
return(Json(new
{
aaData = listEmployeesVM,
sEcho = dataTablesParam.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = totalCount
}, JsonRequestBehavior.AllowGet));
}
