public TowTruckDriver Find(int id)
{
try
{
var @param = new { id };
TowTruckDriver _towTruckDriver = this.Conexao
.QueryFirstOrDefault <TowTruckDriver>(
@"SELECT
DRV.[IDTOWTRUCKDRIVER] ID,
DRV.[NAME] NAME,
DRV.[MOBILE] MOBILE,
DRV.[ENABLE] ENABLE,
TOW.[IDTOWINGCOMPANY] IDTOWINGCOMPANY
FROM [TOWTRUCKDRIVER] DRV WITH(NOLOCK)
INNER JOIN TOWINGCOMPANY TOW WITH(NOLOCK)
ON DRV.IDTOWINGCOMPANY = TOW.IDTOWINGCOMPANY
WHERE DRV.IDTOWTRUCKDRIVER = @id"
,
param: param, transaction: this.Transacao);
return(_towTruckDriver);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> Put([FromUri] int idTowTruckDriver, [FromBody] TowTruckDriver towTruckDriver)
{
TowTruckDriver _towTruckDriver = null;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (towTruckDriver == null)
{
return(BadRequest());
}
// Recupera a Companhia de Reboque
var company = Util.Helper.GetConfiguration();
// Busca cadastro do Motorista de Guincho informado
_towTruckDriver = await Task.Run(() => _towTruckDriverService.Find(idTowTruckDriver));
// Verifica se Motorista de Guincho informado está cadastrado
if (_towTruckDriver == null && _towTruckDriver.IdTowingCompany != company.Id)
{
return(NotFound());
}
// Copiar as propriedades
_towTruckDriver.Copy(towTruckDriver);
// Atualiza dados do Motorista de Guincho
_towTruckDriver = await Task.Run(() => this._towTruckDriverService.Update(_towTruckDriver));
return(Ok(_towTruckDriver));
}
public void Update(TowTruckDriver towTruckDriver)
{
try
{
var param = new DynamicParameters();
param.Add("@IdTowTruckDriver", towTruckDriver?.Id, DbType.Int32, ParameterDirection.Input);
param.Add("@Name", towTruckDriver?.Name, DbType.String, ParameterDirection.Input, 100);
param.Add("@Mobile", towTruckDriver?.Mobile, DbType.String, ParameterDirection.Input, 20);
param.Add("@Enable", towTruckDriver?.Enable, DbType.String, ParameterDirection.Input, 20);
string sqlStatement = @"UPDATE TOWTRUCKDRIVER
SET
[Name] = ISNULL(@Name, [Name]),
[Mobile] = ISNULL(@Mobile, Mobile),
[Enable] = ISNULL(@Enable, Enable)
WHERE
IdTowTruckDriver = @IdTowTruckDriver";
this.Conexao.Execute(sqlStatement, param: param, transaction: this.Transacao);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Busca Motorista de Guincho por ID informado
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TowTruckDriver Find(int id)
{
TowTruckDriver _towTruckDriver = null;
try
{
_towTruckDriver = _workRepository.TowTruckDriverRepository.Find(id);
}
catch (Exception ex)
{
throw ex;
}
return(_towTruckDriver);
}
/// <summary>
/// Cadastra um Motorista de Guincho relacionada com a Empresa de Guincho
/// </summary>
/// <param name="towTruckDriver"></param>
/// <returns></returns>
public TowTruckDriver Create(TowTruckDriver towTruckDriver)
{
try
{
_workRepository.BeginTransaction();
// Cria um Motorista de Guincho na base de dados
_workRepository.TowTruckDriverRepository.Create(towTruckDriver);
// Comita a transação
_workRepository.Commit();
//retorna o Motorista de Guincho criado
return(towTruckDriver);
}
catch (Exception ex)
{
_workRepository.RollBack();
throw ex;
}
}
public void Create(TowTruckDriver towTruckDriver)
{
try
{
var param = new DynamicParameters();
param.Add("@IdTowingCompany", towTruckDriver?.IdTowingCompany, DbType.Int32, ParameterDirection.Input);
param.Add("@Name", towTruckDriver?.Name, DbType.String, ParameterDirection.Input, 100);
param.Add("@Mobile", towTruckDriver?.Mobile, DbType.String, ParameterDirection.Input, 20);
string sqlStatement = @"INSERT INTO TOWTRUCKDRIVER
(IdTowingCompany, Name, Mobile)
OUTPUT INSERTED.IDTOWTRUCKDRIVER
VALUES
(@IdTowingCompany, @Name, @Mobile) ";
towTruckDriver.Id = this.Conexao.QuerySingle <int>(sqlStatement, param: param, transaction: this.Transacao);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> Post([FromBody] TowTruckDriver towTruckDriver)
{
TowTruckDriver _towTruckDriver = null;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (towTruckDriver == null)
{
return(BadRequest());
}
// Recupera a companhia de reboque
var company = Util.Helper.GetConfiguration();
// Atribui o ID da companhia de reboque ao motorista
towTruckDriver.IdTowingCompany = company.Id;
// Invoka método de inserção do Motorista de Guincho
_towTruckDriver = await Task.Run(() => this._towTruckDriverService.Create(towTruckDriver));
return(Ok(_towTruckDriver));
}
