public int Insert(EmployeeTypeModel model)
{
string sqlInsert = "INSERT INTO EmployeeType (Id, Name) Values (@Id, @Name)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
public int Update(EmployeeTypeModel model)
{
string sqlUpdate = "UPDATE EmployeeType SET Name = @Name Where Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
public int Delete(EmployeeTypeModel model)
{
string sqlDelete = "DELETE FROM EmployeeType WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
/// <summary>
/// Saves this instance.
/// </summary>
/// <returns></returns>
public string Save()
{
var employeeType = new EmployeeTypeModel
{
EmployeeTypeId = View.EmployeeTypeId,
EmployeeTypeName = View.EmployeeTypeName,
Description = View.Description,
IsActive = View.IsActive,
EmployeeTypeCode = View.EmployeeTypeCode
};
return(string.IsNullOrEmpty(View.EmployeeTypeId) ? Model.InsertEmployeeType(employeeType) : Model.UpdateEmployeeType(employeeType));
}
public IHttpActionResult UpdateEmployeeType(EmployeeTypeModel employeeTypeModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var employeeTypeDto = Mapper.Map <EmployeeTypeDto>(employeeTypeModel);
_employeeTypeAppService.Update(employeeTypeDto, AuthHelper.GetCurrentUserId());
return(Ok("Employee Type Updated"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
/// <summary>
/// Method whose purpose is to update an
/// existing EmployeeType record.
/// </summary>
/// <param name="employeeType">
/// Existing EmployeeTypeModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Update(EmployeeTypeModel employeeType)
{
return(_employeeTypeRepository.Update(employeeType) > 0 ? true : false);
}
/// <summary>
/// Method whose purpose is to insert a
/// new EmployeeType record.
/// </summary>
/// <param name="employeeType">
/// Existing EmployeeTypeModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Insert(EmployeeTypeModel employeeType)
{
return(_employeeTypeRepository.Insert(employeeType) > 0 ? true : false);
}