private void viewButton_Click(object sender, EventArgs e) { this.Hide(); ViewEmployee viewEmployee = new ViewEmployee(); viewEmployee.Show(); }
public ViewEmployee GetEmployeeById(int empId) { try { CommandObj.CommandText = "spGetEmployeeById"; CommandObj.CommandType = CommandType.StoredProcedure; CommandObj.Parameters.AddWithValue("@EmployeeId", empId); ConnectionObj.Open(); SqlDataReader reader = CommandObj.ExecuteReader(); ViewEmployee employee = new ViewEmployee(); if (reader.Read()) { employee = new ViewEmployee { Email = reader["EmailAddress"].ToString(), EmployeeId = Convert.ToInt32(reader["EmployeeId"]), EmployeeName = reader["EmployeeName"].ToString(), EmployeeTypeId = Convert.ToInt32(reader["EmployeeTypeId"]), EmployeeTypeName = reader["EmployeeTypeName"].ToString(), DepartmentId = Convert.ToInt32(reader["DepartmentId"]), DepartmentName = reader["DepartmentName"].ToString(), DesignationId = Convert.ToInt32(reader["DesignationId"]), DesignationName = reader["DesignationName"].ToString(), BranchId = Convert.ToInt32(reader["BranchId"]), BranchName = reader["BranchName"].ToString(), Gender = reader["Gender"].ToString(), PermanentAddress = reader["PermanentAddress"].ToString(), PresentAddress = reader["PresentAddress"].ToString(), Phone = reader["Phone"].ToString(), AlternatePhone = reader["AlternatePhone"].ToString(), Notes = reader["Notes"].ToString(), NationalIdNo = reader["EmployeeNationalIdNo"].ToString(), EmployeeImage = DBNull.Value.Equals(reader["EmployeeImage"])? null:reader["EmployeeImage"].ToString(), EmployeeSignature = DBNull.Value.Equals(reader["EmployeeSignature"]) ? null : reader["EmployeeSignature"].ToString(), JoiningDate = Convert.ToDateTime(reader["JoiningDate"]), SubSubSubAccountCode = reader["SubSubSubAccountCode"].ToString(), EmployeeNo = reader["EmployeeNo"].ToString(), DoB = DBNull.Value.Equals(reader["DateOfBirth"])? (DateTime?)null : Convert.ToDateTime(reader["DateOfBirth"]) }; } reader.Close(); return(employee); } catch (Exception exception) { throw new Exception("Could not collect Employee Information", exception); } finally { ConnectionObj.Close(); CommandObj.Dispose(); CommandObj.Parameters.Clear(); } }
public bool Remove(ViewEmployee request) { try { var delEmployee = context.Employees.Find(request.Id); context.Remove(delEmployee); return(context.SaveChanges() > 0); } catch (Exception ex) { return(false); } }
public bool Create(ViewEmployee request) { try { request.Id = employees.Max(e => e.Id) + 1; employees.Add(request); return(true); } catch (Exception) { return(false); } }
public Controller() { objectFactory = new ObjectFactory(); securityManager = new SecurityManager(); this.openingDialogBox = new SignIn(this); profile = new EmployeeProfile(this); ForgotPassword = new ForgotPassword(this); updateEmployee = new UpdateEmployee(); viewEmployee = new ViewEmployee(this); createOrder = new Invoice(this); reportsHome = new ReportsHome(this); viewOrders = new ViewOrders(this); addProduct_Form = new AddProduct(this); }
public JsonResult GetEmployeeById(string EmpId) { List <Employee> employees = db.employees.Where(a => a.Emp_Id.Contains(EmpId) || a.MobileNo.Contains(EmpId)).ToList(); List <ViewEmployee> viewEmployees = new List <ViewEmployee>(); foreach (Employee employee in employees) { ViewEmployee viewEmployee = new ViewEmployee { Id = employee.Id, EmpFullName = employee.EmpFullName, Emp_Id = employee.Emp_Id, InActive = employee.InActive, MobileNo = employee.MobileNo, Unit = employee.Unit.Name }; viewEmployees.Add(viewEmployee); } return(Json(viewEmployees, JsonRequestBehavior.AllowGet)); }
public IActionResult Edit(EditEmployee model) { if (ModelState.IsValid) { var existingAvatar = model.AvatarPath; if (model.Avatar != null) { //remove exist file existingAvatar = existingAvatar.Split("/").Last(); if (string.Compare(existingAvatar, "noavatar.jpg") != 0) { System.IO.File.Delete(Path.Combine(webHostEnvironment.WebRootPath, "images", existingAvatar)); } //upload new file var folderPath = Path.Combine(webHostEnvironment.WebRootPath, "images"); var filename = $"{Guid.NewGuid()}_{model.Avatar.FileName}"; var filePath = Path.Combine(folderPath, filename); using (var fs = new FileStream(filePath, FileMode.Create)) { model.Avatar.CopyTo(fs); } existingAvatar = $"~/images/{filename}"; } var employee = new ViewEmployee() { Age = model.Age, AvatarPath = existingAvatar, Code = model.Code, Email = model.Email, Firstname = model.Firstname, Lastname = model.Lastname, Id = model.Id, Phone = model.Phone }; if (employeeService.Edit(employee)) { return(RedirectToAction("Profile", "Employee", new { id = model.Id })); } } return(View(model)); }
public bool Edit(ViewEmployee request) { try { var employee = Get(request.Id); employee.Firstname = request.Firstname; employee.Lastname = request.Lastname; employee.Age = request.Age; employee.Email = request.Email; employee.AvatarPath = request.AvatarPath; employee.Code = request.Code; employee.Phone = request.Phone; return(true); } catch (Exception) { return(false); } }
public bool Edit(ViewEmployee request) { try { var editEmployee = context.Employees.Find(request.Id); editEmployee.AvatarPath = request.AvatarPath; editEmployee.Age = request.Age; editEmployee.Code = request.Code; editEmployee.Email = request.Email; editEmployee.FirstName = request.Firstname; editEmployee.LastName = request.Lastname; context.Attach(editEmployee); context.Entry <Employee>(editEmployee).State = EntityState.Modified; return(context.SaveChanges() > 0); } catch (Exception ex) { return(false); } }
public bool Create(ViewEmployee request) { try { var employee = new Employee() { EmployeeId = request.Id, Age = request.Age, AvatarPath = request.AvatarPath, Code = request.Code, Email = request.Email, FirstName = request.Firstname, LastName = request.Lastname }; context.Add(employee); return(context.SaveChanges() > 0); } catch (Exception ex) { return(false); } }
public ActionResult CreateAdmin(ViewEmployee vEmployee) { if (ModelState.IsValid) { EmployeeLogin login = new EmployeeLogin(); login.Username = vEmployee.Username; login.Password = vEmployee.Password; login.EmployeeType = "Admin"; Area area = new Area(); area = areaRepo.Get(vEmployee.AreaName); City city = new City(); city = cityRepo.Get(vEmployee.CityName); Department dept = new Department(); dept = deptRepo.Get(vEmployee.DepartmentName); var config = new MapperConfiguration(conf => conf.CreateMap <ViewEmployee, Admin>()); var mapper = config.CreateMapper(); Admin adminToInsert = mapper.Map <Admin>(vEmployee); adminToInsert.DateOfBirth = vEmployee.DateOfBirth.ToShortDateString(); adminToInsert.JoiningDate = vEmployee.JoiningDate.ToShortDateString(); adminToInsert.LoginData = login; adminToInsert.Area = area; adminToInsert.City = city; adminToInsert.Department = dept; adminRepo.Insert(adminToInsert); return(RedirectToAction("Index")); } else { return(View(vEmployee)); } }
public IActionResult Create(CreateEmployee model) { if (ModelState.IsValid) { //1. get root //2. create folder path //3. filename path //4. copy image to folder step 2 var filename = "noavatar.jpg"; if (model.Avatar != null) { var folderPath = Path.Combine(webHostEnvironment.WebRootPath, "images"); filename = $"{Guid.NewGuid()}_{model.Avatar.FileName}"; var filePath = Path.Combine(folderPath, filename); using (var fs = new FileStream(filePath, FileMode.Create)) { model.Avatar.CopyTo(fs); } } var employee = new ViewEmployee() { Age = model.Age, AvatarPath = $"~/images/{filename}", Code = model.Code, Email = model.Email, Firstname = model.Firstname, Lastname = model.Lastname }; if (employeeService.Create(employee)) { return(RedirectToAction("Index")); } } return(View(model)); }
public ActionResult Details(int id) { ViewEmployee employee = _iEmployeeManager.GetEmployeeById(id); return(View(employee)); }
private void button4_Click(object sender, EventArgs e) { ViewEmployee viewEmp = new ViewEmployee(); viewEmp.Show(); }
public ActionResult ViewEmployee(int id) { unitOfWork = (GenericUnitOfWork)Session["UNITOFWORK"]; GenericRepository <Employee> empRepository = unitOfWork.GetRepoInstance <Employee>(); GenericRepository <Category> catRepository = unitOfWork.GetRepoInstance <Category>(); GenericRepository <Role> roleRepository = unitOfWork.GetRepoInstance <Role>(); GenericRepository <Employee_Case> empcaRepository = unitOfWork.GetRepoInstance <Employee_Case>(); GenericRepository <Case> caseRepository = unitOfWork.GetRepoInstance <Case>(); Employee emp = empRepository.GetBy(s => s.EmployeeID == id).FirstOrDefault(); Category cat = catRepository.GetBy(c => c.CategoryID == emp.CategoryID).FirstOrDefault(); Role rol = roleRepository.GetBy(r => r.RoleID == emp.RoleID).FirstOrDefault(); List <Employee_Case> empc = empcaRepository.GetBy(c => c.EmployeeID == id).ToList(); int esclated = 0; int solving = 0; int solved = 0; foreach (var item in empc) { Case c = caseRepository.GetBy(x => x.CaseID == item.CaseID).FirstOrDefault(); if (c != null) { if (c.StatusID == 1) { solved++; } else if (c.StatusID == 2) { solving++; } else if (c.StatusID == 3) { esclated++; } } } int total = empcaRepository.GetBy(c => c.EmployeeID == id).Count(); if (cat != null) { ViewEmployee empl = new ViewEmployee() { UserID = emp.EmployeeID, UserName = emp.UserName, FirstName = emp.User.FirstName, LastName = emp.User.LastName, Mobile = emp.User.Mobile, Email = emp.User.Email, CategoryName = cat.CategoryName, TotalCases = total, pendingCases = solving, SolvedCases = solved, esclatedCases = esclated, RoleName = rol.RoleName }; ViewBag.categories = catRepository.GetAll().ToList(); ViewBag.roles = roleRepository.GetAll().ToList(); return(View("EmployeeProfile", empl)); } else { ViewEmployee empl = new ViewEmployee() { UserID = emp.EmployeeID, UserName = emp.UserName, FirstName = emp.User.FirstName, LastName = emp.User.LastName, Mobile = emp.User.Mobile, Email = emp.User.Email, CategoryName = " ", TotalCases = total, pendingCases = solving, SolvedCases = solved, esclatedCases = esclated, RoleName = rol.RoleName }; ViewBag.categories = catRepository.GetAll().ToList(); ViewBag.roles = roleRepository.GetAll().ToList(); return(View("EmployeeProfile", empl)); } }
public ViewEmployee GetEmployeeById(int empId) { ViewEmployee employee = _iEmployeeGateway.GetEmployeeById(empId); return(employee); }
private void MenuItem_Click_View(object sender, RoutedEventArgs e) { ViewEmployee VEobj = new ViewEmployee(); VEobj.ShowDialog(); }
public bool Remove(ViewEmployee request) { throw new NotImplementedException(); }