private ComercialData ConvertToComercialData(DataTable table)
{
if (table.Rows.Count.Equals(0))
{
return(null);
}
var data = ComercialData.CreateComercialData();
var row = table.Rows[0];
data.ComercialId = row["id_comercial"].ToString();
data.ClientId = row["id_cliente"].ToString();
data.CompanyName = row["Razon social"].ToString();
data.FantasyName = row["Nombre de fantasia"].ToString();
data.ComercialBusiness = row["Giro comercial"].ToString();
data.Email = row["Email"].ToString();
data.ComercialDni = row["DNI"].ToString();
data.Address = row["Direccion"].ToString();
data.City.CityId = int.Parse(row["id_ciudad"].ToString());
data.City.CityName = row["Ciudad"].ToString();
data.Country.CountryId = int.Parse(row["id_pais"].ToString());
data.Country.CountryName = row["Pais"].ToString();
data.Country.CountryPrefix = row["Prefijo"].ToString();
data.PhoneNumber = row["Telefono"].ToString();
return(data);
}
public void EditCommercialData(ComercialData data, string clientId)
{
IValidator validator = ComercialDataValidator.CreateValidator(data, true);
validator.Validate();
repository.EditComercialData(data, clientId);
}
public void NewCommercialData(ComercialData data, string clientId)
{
IValidator validator = ComercialDataValidator.CreateValidator(data, false);
validator.Validate();
repository.NewComercialData(data, clientId);
}
public void EditComercialData(ComercialData data, string clientId)
{
var query = DefineQueryAction("spActualizarDatosComerciales ");
query.AddParameter("pIdComercial", data.ComercialId, DbType.String);
query = DefineParameters(data, query);
query.ExecuteQuery();
}
private void InitializeObjects(string id, string firstName, string lastName, string dni)
{
Id = id;
FirstName = firstName;
LastName = lastName;
Dni = dni;
Profile = UserProfile.CreateProfile();
ComercialInfo = ComercialData.CreateComercialData();
}
public void NewComercialData(ComercialData data, string clientId)
{
SearchExistingBusinessData(clientId);
var query = DefineQueryAction("spAgregarDatosComerciales ");
query.AddParameter("pIdComercial", data.ComercialId, DbType.String);
query.AddParameter("pIdCliente", clientId, DbType.String);
query = DefineParameters(data, query);
query.ExecuteQuery();
}
private IQueryAction DefineParameters(ComercialData data, IQueryAction query)
{
query.AddParameter("pRSocial", data.CompanyName, DbType.String);
query.AddParameter("pFantasia", data.FantasyName, DbType.String);
query.AddParameter("pGiro", data.ComercialBusiness, DbType.String);
query.AddParameter("pEmail", data.Email, DbType.String);
query.AddParameter("pDNI", data.ComercialDni, DbType.String);
query.AddParameter("pDireccion", data.Address, DbType.String);
query.AddParameter("pIdCiudad", data.City.CityId, DbType.Int32);
query.AddParameter("pTelefono", data.PhoneNumber, DbType.String);
return(query);
}
public IHttpActionResult Put(ComercialData data)
{
if (data == null)
{
return(BadRequest("Parámetro inválido, los datos comerciales son incorrectos"));
}
try{
usecase.EditCommercialData(data, data.ClientId);
return(Ok("Datos comerciales actualizados correctamente"));
}
catch (Exception ex) {
return(BadRequest(ex.Message));
}
}
// Named constructor
public static ComercialDataValidator CreateValidator(ComercialData data, bool editMode)
{
return(new ComercialDataValidator(data, editMode));
}
// Constructor
private ComercialDataValidator(ComercialData data, bool editMode)
{
this.data = data;
EditMode = editMode;
ProcessName = $"{(editMode ? "actualizando" : "ingresando")} datos comerciales";
}
