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