public Employee Create(Employee employee)
{
EEmployee eEmployee = EEmployee(employee);
eEmployee = _iDEmployee.Create(eEmployee);
return(Employee(eEmployee));
}
private Employee Employee(EEmployee eEmployee)
{
Employee returnEmployee = new Employee
{
CreatedDate = eEmployee.CreatedDate,
DateHired = eEmployee.DateHired,
DateStarted = eEmployee.DateStarted,
DateEnded = eEmployee.DateEnded,
UpdatedDate = eEmployee.UpdatedDate,
CompanyId = eEmployee.CompanyId,
CreatedBy = eEmployee.CreatedBy,
EmployeeId = eEmployee.EmployeeId,
JobTitleId = eEmployee.JobTitleId,
ManagerEmployeeId = eEmployee.ManagerEmployeeId,
UpdatedBy = eEmployee.UpdatedBy,
Email = eEmployee.Email,
FirstName = eEmployee.FirstName,
LastName = eEmployee.LastName,
MiddleName = eEmployee.MiddleName
};
return(returnEmployee);
}
public int UpdateEmployee(EEmployee GRD, int id)
{
int effectrows;
using (MySqlConnection con = new MySqlConnection(conn))
{
using (MySqlCommand cmd = new MySqlCommand("EditEmployee", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emp_id", id);
cmd.Parameters.AddWithValue("@emp_fname", GRD.FNAME);
cmd.Parameters.AddWithValue("@emp_lname", GRD.LNAME);
cmd.Parameters.AddWithValue("@emp_email", GRD.EMAIL);
cmd.Parameters.AddWithValue("@emp_pass", GRD.PASSWORD);
cmd.Parameters.AddWithValue("@emp_dob", GRD.DOB);
cmd.Parameters.AddWithValue("@emp_telno", GRD.TELEPHONE);
cmd.Parameters.AddWithValue("@emp_mobno", GRD.MOBILENO);
cmd.Parameters.AddWithValue("@emp_doj", GRD.DOJ);
cmd.Parameters.AddWithValue("@emp_status", GRD.STATUS);
cmd.Parameters.AddWithValue("@emp_gender", GRD.GENDER);
cmd.Parameters.AddWithValue("@emp_roleid", GRD.ROLE);
cmd.Parameters.AddWithValue("@emp_salary", GRD.SALARY);
con.Open();
effectrows = cmd.ExecuteNonQuery();
con.Close();
}
}
return(effectrows);
}
public ActionResult DeleteConfirmed(string id)
{
EEmployee employee = db.Employees.Find(id);
db.Employees.Remove(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Employee Update(int updatedBy, Employee employee)
{
EEmployee eEmployee = EEmployee(employee);
eEmployee.UpdatedDate = DateTime.Now;
eEmployee.UpdatedBy = updatedBy;
eEmployee = _iDEmployee.Update(EEmployee(employee));
return(Employee(eEmployee));
}
public Employee Create(int createdBy, Employee employee)
{
EEmployee eEmployee = EEmployee(employee);
eEmployee.CreatedDate = DateTime.Now;
eEmployee.CreatedBy = createdBy;
eEmployee = _iDEmployee.Create(eEmployee);
return(Employee(eEmployee));
}
public ActionResult Edit([Bind(Include = "FullName,StartDate,EndDate,JobName,CompanyName")] EEmployee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public Employee Read(string employeeNumber, string pin)
{
EEmployee eEmployee = _iDEmployee.Read <EEmployee>(a => a.EmployeeNumber == employeeNumber && a.Pin == pin);
if (eEmployee == null)
{
return(new Employee());
}
return(Employee(eEmployee));
}
public ActionResult Edit(int id, EEmployee e)
{
try
{
empRepo.Update(id, e);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public Employee Create(int createdBy, Employee employee)
{
if (_iDEmployee.Count <EEmployee>(a => a.EmployeeNumber == employee.EmployeeNumber) == 0)
{
EEmployee eEmployee = EEmployee(employee);
eEmployee.CreatedDate = DateTime.Now;
eEmployee.CreatedBy = createdBy;
eEmployee = _iDEmployee.Create(eEmployee);
return(Employee(eEmployee));
}
return(employee);
}
public ActionResult Create([Bind(Include = "FullName,StartDate,EndDate,JobName,CompanyName")] EEmployee employee /*, company company*/)
{
if (ModelState.IsValid)
{
//string TempData = company.CompanyName;
//employee.CompanyName = TempData;
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
// GET: AddEmployees/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EEmployee employee = db.Employees.Find(id);
if (employee == null)
{
return(HttpNotFound());
}
return(View(employee));
}
// GET: AddEmployees/Edit/5
public ActionResult Edit(string id)
{
ViewBag.JobName = new SelectList(db.jobs, "JobName", "JobName");
ViewBag.CompanyName = new SelectList(db.companies, "CompanyName", "CompanyName");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EEmployee employee = db.Employees.Find(id);
if (employee == null)
{
return(HttpNotFound());
}
return(PartialView(employee));
}
private EEmployee EEmployee(Employee employee)
{
EEmployee returnEEmployee = new EEmployee
{
EmployeeId = employee.EmployeeId,
CompanyId = employee.CompanyId,
PositionId = employee.PositionId,
DepartmentId = employee.DepartmentId,
ManagerEmployeeId = employee.ManagerEmployeeId,
FirstName = employee.FirstName,
LastName = employee.LastName,
MiddleName = employee.MiddleName,
Email = employee.Email,
JobTitle = employee.JobTitle,
StartingDate = employee.StartingDate,
HiringDate = employee.HiringDate,
CreatedBy = employee.CreatedBy,
UpdatedBy = employee.UpdatedBy
};
return(returnEEmployee);
}
public ActionResult Create(EmployeeDepartmemtViewModel eE)
{
try
{
EEmployee e = new EEmployee
{
Id = eE.Id,
FirstName = eE.FirstName,
LastName = eE.LastName,
Gender = eE.Gender,
Address = eE.Address,
Email = eE.Email,
Password = eE.Password
};
empRepo.Add(e);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public int UpdateEmployee(EEmployee emp, int id)
{
return(EmployeeDb.UpdateEmployee(emp, id));
}
public Employee Read(int employeeId)
{
EEmployee eEmployee = _iDEmployee.Read <EEmployee>(a => a.EmployeeId == employeeId);
return(Employee(eEmployee));
}
public int AddNewEmployee(EEmployee Employee)
{
return(EmployeeDb.AddNewEmployee(Employee));
}
