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