public override SuccessResult <AbstractCompany> CompanyUpsert(AbstractCompany abstractCompany)
{
SuccessResult <AbstractCompany> company = null;
var param = new DynamicParameters();
param.Add("@Id", abstractCompany.Id, dbType: DbType.Int32, direction: ParameterDirection.Input);
param.Add("@Name", abstractCompany.Name, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@Address1", abstractCompany.Address1, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@Address2", abstractCompany.Address2, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@Address3", abstractCompany.Address3, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@Phone", abstractCompany.Phone, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@Fax", abstractCompany.Fax, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@LoginUserId", ProjectSession.UserID, dbType: DbType.Int32, direction: ParameterDirection.Input);
using (SqlConnection con = new SqlConnection(Configurations.ConnectionString))
{
var task = con.QueryMultiple(SQLConfig.CompanyUpsert, param, commandType: CommandType.StoredProcedure);
company = task.Read <SuccessResult <AbstractCompany> >().SingleOrDefault();
company.Item = task.Read <Company>().SingleOrDefault();
}
return(company);
}
/// <summary>
/// Espelhas o resultado do layout em uma empresa
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public AbstractCompany ToCompany(AbstractCompany e)
{
if (!string.IsNullOrEmpty(this.Nome))
{
e.RazaoSocial = this.Nome;
}
if (!string.IsNullOrEmpty(this.Uf))
{
e.Uf = this.Uf;
}
if (!string.IsNullOrEmpty(this.Telefone))
{
var tel = this.Telefone.Split('/');
if (tel.Length > 0)
{
e.Telefone = tel[0].Trim();
if (tel.Length > 1)
{
e.Fax = tel[1].Trim();
}
}
}
if (!string.IsNullOrEmpty(this.Situacao))
{
e.Situacao = this.Situacao;
}
if (!string.IsNullOrEmpty(this.Bairro))
{
e.Bairro = this.Bairro;
}
if (!string.IsNullOrEmpty(this.Logradouro))
{
e.NomeEndereco = this.Logradouro;
}
if (!string.IsNullOrEmpty(this.Numero))
{
e.NumeroEndereco = this.Numero;
}
if (!string.IsNullOrEmpty(this.Cep))
{
e.Cep = this.Cep;
}
if (!string.IsNullOrEmpty(this.Municipio))
{
e.Cidade = this.Municipio;
}
if (!string.IsNullOrEmpty(this.Abertura))
{
e.Abertura = this.Abertura;
}
if (!string.IsNullOrEmpty(this.NaturezaJuridica))
{
e.NaturezaJuridica = this.NaturezaJuridica;
}
if (!string.IsNullOrEmpty(this.Fantasia))
{
e.NomeFantasia = this.Fantasia;
}
//essa sera a entrada
//c.CpfCnpj = this.Cnpj;
e.UltimaAtualizacao = this.UltimaAtualizacao;
if (!string.IsNullOrEmpty(this.Status))
{
e.Status = this.Status;
}
if (!string.IsNullOrEmpty(this.Tipo))
{
e.Tipo = this.Tipo;
}
if (!string.IsNullOrEmpty(this.Complemento))
{
e.Complemento = this.Complemento;
}
if (!string.IsNullOrEmpty(this.Email))
{
e.Email = this.Email;
}
if (!string.IsNullOrEmpty(this.Efr))
{
e.Efr = this.Efr;
}
if (!string.IsNullOrEmpty(this.MotivoSituacao))
{
e.MotivoSituacao = this.MotivoSituacao;
}
if (!string.IsNullOrEmpty(this.SituacaoEspecial))
{
e.SituacaoEspecial = this.SituacaoEspecial;
}
if (!string.IsNullOrEmpty(this.DataSituacaoEspecial))
{
e.DataSituacaoEspecial = this.DataSituacaoEspecial;
}
if (this.CapitalSocial != 0)
{
e.CapitalSocial = this.CapitalSocial;
}
return(e);
}
public abstract SuccessResult <AbstractCompany> CompanyUpsert(AbstractCompany abstractCompany);
public override SuccessResult <AbstractCompany> CompanyUpsert(AbstractCompany abstractCompany)
{
return(this.abstractCompanyDao.CompanyUpsert(abstractCompany));
}
