public bool UpdateEmployee(EmpManagementModelLayer empManagementModelLayer)
{
try
{
using (this.connection)
{
SqlCommand command = new SqlCommand("SPUpdateEmployeeData", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@EmpID", empManagementModelLayer.EmpID);
command.Parameters.AddWithValue("@FirstName", empManagementModelLayer.FirstName);
command.Parameters.AddWithValue("@LastName", empManagementModelLayer.LastName);
command.Parameters.AddWithValue("@EmailID", empManagementModelLayer.EmailID);
command.Parameters.AddWithValue("@PhoneNumber", empManagementModelLayer.PhoneNumber);
command.Parameters.AddWithValue("@DepartmentID", empManagementModelLayer.DepartmentID);
this.connection.Open();
var result = command.ExecuteNonQuery();
this.connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool UpdateEmployee(EmpManagementModelLayer empManagementML)
{
try
{
return(this.empManagementRepositoryLayer.UpdateEmployee(empManagementML));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult UpdateEmployee([FromBody] EmpManagementModelLayer empManagementModelLayer)
{
var result = this.empManagementBusinessLayer.UpdateEmployee(empManagementModelLayer);
try
{
if (result != null)
{
return(this.Ok(new ResponseEntity(HttpStatusCode.OK, "Employee Updated Successfully", result)));
}
return(this.NotFound(new ResponseEntity(HttpStatusCode.NotFound, "Employee Not Updated", result)));
}
catch (Exception ex)
{
return(this.BadRequest(new ResponseEntity(HttpStatusCode.BadRequest, "", ex.Message)));
}
}
public ActionResult AddEmployee(EmpManagementModelLayer empManagementModelLayer)
{
try
{
if (ModelState.IsValid)
{
var result = empManagementBusinessLayer.AddEmployee(empManagementModelLayer);
if (result != null)
{
ViewBag.Message = "Employee Added Successfully!";
}
}
return(View());
}
catch (Exception)
{
return(View());
}
}
public List <EmpManagementModelLayer> GetAllEmployees()
{
try
{
List <EmpManagementModelLayer> getAllData = new List <EmpManagementModelLayer>();
using (this.connection)
{
SqlCommand command = new SqlCommand("SpGetAllEmployees", this.connection);
command.CommandType = CommandType.StoredProcedure;
this.connection.Open();
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
EmpManagementModelLayer empManagementModelLayer = new EmpManagementModelLayer();
empManagementModelLayer.EmpID = Convert.ToInt32(sqlDataReader["EmpID"]);
empManagementModelLayer.FirstName = sqlDataReader["FirstName"].ToString();
empManagementModelLayer.LastName = sqlDataReader["LastName"].ToString();
empManagementModelLayer.EmailID = sqlDataReader["EmailID"].ToString();
empManagementModelLayer.PhoneNumber = sqlDataReader["PhoneNumber"].ToString();
empManagementModelLayer.DepartmentID = Convert.ToInt32(sqlDataReader["DepartmentID"]);
getAllData.Add(empManagementModelLayer);
}
return(getAllData);
}
return(null);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
this.connection.Close();
}
}
