public void saveEmployee(EmployeeEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblEmployee emp = new EDMX.tblEmployee
{
Id = obj.EmployeeId,
LastName = obj.LastName,
FirstName = obj.FirstName,
MiddleName = obj.MiddleName,
Active = obj.Active,
DateCreated = obj.DateCreated,
DateUpdated = obj.DateUpdated
};
db.tblEmployees.Add(emp);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Save Employee");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public EmployeeEntity searchEmployeeByID(int empID)
{
EmployeeEntity obj = new EmployeeEntity();
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblEmployee emp = db.tblEmployees.FirstOrDefault(x => x.Id == empID);
if (emp != null)
{
obj.EmployeeId = emp.Id;
obj.LastName = emp.LastName;
obj.FirstName = emp.FirstName;
obj.MiddleName = emp.MiddleName;
obj.Active = emp.Active;
obj.DateCreated = emp.DateCreated;
obj.DateUpdated = emp.DateUpdated;
}
else
{
obj = null;
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Employee By ID");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
obj = null;
}
return(obj);
}
public void updateEmployee(EmployeeEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblEmployee emp = db.tblEmployees.Where(x => x.Id == obj.EmployeeId).FirstOrDefault();
emp.LastName = obj.LastName;
emp.FirstName = obj.FirstName;
emp.MiddleName = obj.MiddleName;
emp.Active = obj.Active;
emp.DateCreated = obj.DateCreated;
emp.DateUpdated = obj.DateUpdated;
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Update Employee");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}