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