public TowingCompany Find(TowingCompany towingCompany)
{
try
{
var @param = new { id = towingCompany.Id, email = towingCompany.Email };
TowingCompany _towingCompany = this.Conexao
.QueryFirstOrDefault <TowingCompany>(
@"SELECT
CMP.[IDCOMPANY] ID,
CMP.[NAME] NAME,
CMP.[REGISTRATIONNUMBER] CNPJ,
CMP.[IDTYPECOMPANY] TYPECOMPANY,
TOW.[DESCRIPTION] DESCRIPTION,
TOW.[EMAIL] EMAIL,
TOW.[ENABLE] ENABLE
FROM [COMPANY] CMP WITH(NOLOCK)
INNER JOIN TOWINGCOMPANY TOW WITH(NOLOCK)
ON TOW.IDTOWINGCOMPANY = CMP.IDCOMPANY
WHERE TOW.IDTOWINGCOMPANY = ISNULL(@id, TOW.IDTOWINGCOMPANY)
AND TOW.EMAIL = ISNULL(@email, TOW.EMAIL)",
param: param,
transaction: this.Transacao);
return(_towingCompany);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> Put([FromUri] int idTowingCompany, [FromBody] TowingCompany towingCompany)
{
TowingCompany _towingCompany = null;
Company _insuranceCompany = null;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (towingCompany == null)
{
return(BadRequest());
}
// Carrega a configuração da Seguradora associada ao Token
_insuranceCompany = Util.Helper.GetConfiguration();
// Busca Empresa de Guincho por relacionamento com a Seguradora do Token
_towingCompany = await Task.Run(() => _towingCompanyService.ListByInsuranceCompany(_insuranceCompany)
.FirstOrDefault(c => c.Id == idTowingCompany));
// Verifica se Empresa de Guincho informada é relacionada com Seguradora do Token
if (_towingCompany == null)
{
return(NotFound());
}
// Copiar as propriedades
_towingCompany.Copy(towingCompany);
// Atualiza dados da Empresa de Guincho
_towingCompany = await Task.Run(() => this._towingCompanyService.Update(_towingCompany));
return(Ok(_towingCompany));
}
public bool SaveCompany(TowingCompany item)
{
try
{
ctxWrite.TowingCompanies_AddEdit(item.TowingCompanyID, item.TowingCompanyName, item.TowingCompanyEmail, item.TowingCompanyPhone, item.TowingCompanyAddress,
item.TowingCompanyDesc, item.Priority, item.Active, item.OpeningBalance, item.System_Who_Add, item.System_LastAction_IP);
return(true);
}
catch { return(false); }
}
/// <summary>
/// Busca todos campos da Empresa de Guincho informada
/// </summary>
/// <param name="towingCompany"></param>
/// <returns></returns>
public TowingCompany GetTowingCompany(TowingCompany towingCompany)
{
TowingCompany _towingCompany = null;
try
{
_towingCompany = _workRepository.TowingCompanyRepository.Find(towingCompany);
}
catch (Exception ex)
{
throw ex;
}
return(_towingCompany);
}
/// <summary>
/// Cria uma Empresa de Guincho por dados informados
/// </summary>
/// <param name="towingCompany"></param>
/// <returns></returns>
public TowingCompany Create(Company insuranceCompany, TowingCompany towingCompany)
{
try
{
this._workRepository.BeginTransaction();
//Adiciona o Id da company de seguros
towingCompany.IdInsuranceCompany = insuranceCompany.Id;
// Cria a Empresa de Guincho na base de dados
this._workRepository.TowingCompanyRepository.Create(towingCompany);
// Configura Usuário a ser criado
var user = new User()
{
Company = new Company()
{
Id = towingCompany.Id
},
Name = towingCompany.Name,
Login = towingCompany.Email,
Password = System.Web.Security.Membership.GeneratePassword(8, 1),
Status = true
};
// Cria Usuário para realizar login na aplicação
this._workRepository.UserRepository.Create(user);
// Busca configuração da Companhia Seguradora
InsuranceCompany configurationInsuranceCompany = this._workRepository.ConfigurationRepository.Find(insuranceCompany);
// Envia E-mail à Empresa Guincho com Usuário/Senha para seu acesso
this.SendMail(configurationInsuranceCompany, user);
// Finaliza Escopo principal
this._workRepository.Commit();
return(towingCompany);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(TowingCompany towingCompany)
{
try
{
var paramCompany = new DynamicParameters();
var paramTowingCompany = new DynamicParameters();
paramCompany.Add("@IdCompany", towingCompany?.Id, DbType.Int32, ParameterDirection.Input);
paramCompany.Add("@Name", towingCompany?.Name, DbType.String, ParameterDirection.Input, 200);
paramCompany.Add("@RegistrationNumber", towingCompany?.CNPJ, DbType.String, ParameterDirection.Input, 20);
string sqlStatement = @"UPDATE Company
SET
[Name] = ISNULL(@Name, [Name]),
RegistrationNumber = ISNULL(@RegistrationNumber, RegistrationNumber)
WHERE
IdCompany = @IdCompany";
// Atualiza dados da Companhia base
this.Conexao.Execute(sqlStatement, param: paramCompany, transaction: this.Transacao);
// Inizializa lista de Parâmetros
paramTowingCompany.Add("@IdTowingCompany", towingCompany?.Id, DbType.Int32, ParameterDirection.Input);
paramTowingCompany.Add("@Description", towingCompany?.Description, DbType.String, ParameterDirection.Input, 100);
paramTowingCompany.Add("@Email", towingCompany?.Email, DbType.String, ParameterDirection.Input, 100);
paramTowingCompany.Add("@Enable", towingCompany?.Enable, DbType.Boolean, ParameterDirection.Input);
sqlStatement = @"UPDATE TowingCompany
SET
Description = ISNULL(@Description, Description),
Email = ISNULL(@Email , Email),
Enable = ISNULL(@Enable, Enable)
WHERE
IdTowingCompany = @IdTowingCompany";
// Atualiza dados da Empresa Guincho
this.Conexao.Execute(sqlStatement, param: paramTowingCompany, transaction: this.Transacao);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> Post([FromBody] TowingCompany towingCompany)
{
TowingCompany _towingCompany = null;
Company _insuranceCompany = null;
User _user = null;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (towingCompany == null)
{
return(BadRequest());
}
// Carrega a configuração da Seguradora associada ao Token
_insuranceCompany = Util.Helper.GetConfiguration();
// Busca Empresa de Guincho com pelo e-mail informado
_towingCompany = this._towingCompanyService.GetTowingCompany(towingCompany);
// Busca Usuário cadastrado pelo Login (e-mail) informado
_user = this._loginService.GetUserByLogin(new User()
{
Login = towingCompany.Email
});
// Valida se já existe Empresa de Guincho com o -email informado
if (_towingCompany != null || _user != null)
{
return(BadRequest("Endereço da conta E-mail informada já existe"));
}
// Atribui o Tipo de Companhia para: Empresa de Guincho
towingCompany.TypeCompany = TypeCompany.TowingServiceCompany;
// Invoka método de inserção da Empresa de Guincho
_towingCompany = await Task.Run(() => this._towingCompanyService.Create(_insuranceCompany, towingCompany));
return(Ok(_towingCompany));
}
public void Create(TowingCompany towingCompany)
{
try
{
var paramCompany = new DynamicParameters();
var paramTowingCompany = new DynamicParameters();
paramCompany.Add("@Name", towingCompany?.Name, DbType.String, ParameterDirection.Input, 200);
paramCompany.Add("@RegistrationNumber", towingCompany?.CNPJ, DbType.String, ParameterDirection.Input, 20);
paramCompany.Add("@IdTypeCompany", towingCompany?.TypeCompany, DbType.Int32, ParameterDirection.Input);
string sqlStatement = @"INSERT INTO Company
(Name, RegistrationNumber, IdTypeCompany)
OUTPUT INSERTED.IDCOMPANY
VALUES
(@Name, @RegistrationNumber, @IdTypeCompany) ";
// Insere dados da Companhia base
towingCompany.Id = this.Conexao.QuerySingle <int>(sqlStatement, param: paramCompany, transaction: this.Transacao);
paramTowingCompany.Add("@IdTowingCompany", towingCompany?.Id, DbType.Int32, ParameterDirection.Input);
paramTowingCompany.Add("@IdInsuranceCompany", towingCompany?.IdInsuranceCompany, DbType.Int32, ParameterDirection.Input);
paramTowingCompany.Add("@Description", towingCompany?.Description, DbType.String, ParameterDirection.Input, 100);
paramTowingCompany.Add("@Email", towingCompany?.Email, DbType.String, ParameterDirection.Input, 100);
paramTowingCompany.Add("@Enable", towingCompany?.Enable, DbType.Boolean, ParameterDirection.Input);
sqlStatement = @"INSERT INTO TowingCompany
(IdTowingCompany,IdInsuranceCompany, Description, Email, Enable)
OUTPUT INSERTED.IDTOWINGCOMPANY
VALUES
(@IdTowingCompany, @IdInsuranceCompany, @Description, @Email, @Enable) ";
// Insere dados da Empresa Guincho usando chave da Companhia base gerada
this.Conexao.QuerySingle(sqlStatement, param: paramTowingCompany, transaction: this.Transacao);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Atualiza uma Empresa de Guincho por dados informados
/// </summary>
/// <param name="towingCompany"></param>
/// <returns></returns>
public TowingCompany Update(TowingCompany towingCompany)
{
try
{
_workRepository.BeginTransaction();
// Atualiza a Empresa de Guincho na base de dados
_workRepository.TowingCompanyRepository.Update(towingCompany);
// Comita a transação
_workRepository.Commit();
//retorna a Empresa de Guincho
return(towingCompany);
}
catch (Exception ex)
{
_workRepository.RollBack();
throw ex;
}
}
private void SaveTowingCompanyInformation()
{
TowingCompany TowingCompanyToSave = new TowingCompany();
try
{
if (hfID.Value != "")
{
TowingCompanyToSave.TowingCompanyID = Convert.ToInt32(hfID.Value);
}
TowingCompanyToSave.TowingCompanyEmail = txtEmail.Text;
TowingCompanyToSave.TowingCompanyName = txtNameS.Text;
TowingCompanyToSave.TowingCompanyPhone = txtPhone.Text;
TowingCompanyToSave.TowingCompanyDesc = txtShortdesc.Text;
TowingCompanyToSave.Priority = Convert.ToInt32(txtPriority.Text);
TowingCompanyToSave.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text);
TowingCompanyToSave.Active = cbActive.Checked;
TowingCompanyToSave.System_Add_Date = DateTime.Now;
TowingCompanyToSave.System_LastAction_IP = ClientSession.Current.IP;
// perform saving method.
if (new TowingCompaniesManager().SaveCompany(TowingCompanyToSave))
{
lblError.Text = Resources.AdminResources_en.SuccessSave;
ResetControls();
FillTowingCompaniesList(); // refresh data.
}
else
{
lblError.Text = Resources.AdminResources_en.ErrorSave;
}
}
catch { lblError.Text = Resources.AdminResources_en.ErrorSave; }
}
