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