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