public IActionResult EditEmployee([FromBody] MvEmployee employee) { try { dynamic jsonString = _employeeService.EditEmployee(employee); return(Ok(jsonString)); } catch (Exception e) { throw e; } }
public dynamic UpdateEmployee(MvEmployee employee) { var json = JsonConvert.SerializeObject(employee); using (var sql = _dah.GetConnection()) { using (SqlCommand command = new SqlCommand("SpPersonUpdTsk", sql)) { command.CommandType = (System.Data.CommandType.StoredProcedure);; command.Parameters.Add(new SqlParameter("@json", json)); command.ExecuteNonQuery(); return(employee); } } }
public IActionResult AddEmployee([FromBody] MvEmployee employee) { try { var added = _employeeService.AddEmployee(employee); if (!added) { return(BadRequest()); } return(Ok()); } catch (Exception e) { throw e; } }
public IActionResult EmployeeUpdate([FromBody] MvEmployee employee) { if (!ModelState.IsValid) { return(BadRequest()); } try { var data = _employeeService.UpdateEmployee(employee); return(Ok(data)); } catch (Exception ex) { throw ex; } }
public IActionResult AddEmployee([FromBody] MvEmployee employee) { if (!ModelState.IsValid) { return(BadRequest()); } try { var added = _employeeService.AddEmployee(employee); if (!added) { return(BadRequest()); } return(Ok()); } catch (Exception) { throw; } }
public bool AddEmployee(MvEmployee employee) { var jsonNew = JsonConvert.SerializeObject(employee); using (var conn = _dah.GetConnection()) { using (var cmd = new SqlCommand("SpEmployeeInsertTsk", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Json", SqlDbType.NChar).Value = jsonNew; cmd.CommandTimeout = int.Parse(_commandTimeout); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { return(true); } return(false); } } }
public bool AddEmployee(MvEmployee employee) { using (var con = _dah.GetConnection()) { var jsonNew = JsonConvert.SerializeObject(employee); var cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SpEmployeeInsTsk"; cmd.Parameters.Add("@Json", SqlDbType.NVarChar).Value = jsonNew; cmd.CommandTimeout = _commandTimeout; int rows = cmd.ExecuteNonQuery(); if (rows > 0) { return(true); } return(false); } }
public dynamic EditEmployee(MvEmployee employee) { using (var dbConnection = _dah.GetConnection()) { var dbCommand = dbConnection.CreateCommand(); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "SpEmployeeUpdateTsk"; dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar); dbCommand.Parameters["@Json"].Value = "{\"firstName\":\"" + employee.FirstName + "\"," + "\"middleName\":\"" + employee.MiddleName + "\"," + "\"lastName\":\"" + employee.LastName + "\"," + "\"address\":\"" + employee.Address + "\"," + "\"email\":\"" + employee.Email + "\"," + "\"mobile\":\"" + employee.Mobile + "\"," + "\"employeeId\":\"" + employee.EmployeeId + "\"," + "\"organizationId\":\"" + employee.OrganizationId + "\"," + "\"insertPersonId\":" + employee.InsertPersonId + "}"; using (SqlDataReader reader = dbCommand.ExecuteReader()) { try { if (reader.HasRows) { return(_dah.GetJson(reader)); } else { return(null); } } catch (Exception e) { throw e; } } } }