public static async Task <Auxiliar> InsertAuxiliarAsync(ResultInstruction instruction, Conexion conexion, Comuna comuna)
{
string acteco = null;
TextInfo ti = CultureInfo.CurrentCulture.TextInfo;
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
string adressTemp = ti.ToTitleCase(instruction.ParticipantDebtor.CommercialAddress.ToLower());
if (instruction.ParticipantDebtor.CommercialAddress.Contains(','))
{
int index = instruction.ParticipantDebtor.CommercialAddress.IndexOf(',');
adressTemp = instruction.ParticipantDebtor.CommercialAddress.Substring(0, index);
}
if (adressTemp.Length > 60)
{
adressTemp = adressTemp.Substring(0, 60);
}
// Get acteco from CEN
if (instruction.ParticipantDebtor.CommercialBusiness != null)
{
if (instruction.ParticipantDebtor.CommercialBusiness.Length > 60)
{
acteco = instruction.ParticipantDebtor.CommercialBusiness.Substring(0, 60);
}
else
{
acteco = instruction.ParticipantDebtor.CommercialBusiness;
}
// Insert new Acteco
await Acteco.InsertActecoAsync(acteco, conexion);
// Production:
if (Environment.MachineName == "DEVELOPER")
{
time = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
}
}
try
{
string rut = string.Format(CultureInfo.CurrentCulture, "{0:N0}", instruction.ParticipantDebtor.Rut).Replace(',', '.');
StringBuilder query = new StringBuilder();
query.Append($"IF (NOT EXISTS(SELECT * FROM softland.cwtauxi WHERE CodAux = '{instruction.ParticipantDebtor.Rut}')) BEGIN ");
query.Append("INSERT INTO softland.CWTAUXI (CodAux, NomAux, NoFAux, RutAux, ActAux, GirAux, PaiAux, Comaux, ");
query.Append("DirAux, ClaCli, ClaPro, Bloqueado, BloqueadoPro, EsReceptorDTE ,eMailDTE, Usuario, Proceso, Sistema, Region, FechaUlMod) ");
query.Append($"VALUES ('{instruction.ParticipantDebtor.Rut}', ");
query.Append($"'{instruction.ParticipantDebtor.BusinessName}','{instruction.ParticipantDebtor.Name}', ");
query.Append($"'{rut}-{instruction.ParticipantDebtor.VerificationCode}','S',(SELECT TOP 1 GirCod from softland.cwtgiro where GirDes = '{acteco}' ),'CL','{comuna.ComCod}', ");
query.Append($"'{adressTemp}','S', 'S','N', 'N', 'S','{instruction.ParticipantDebtor.DteReceptionEmail}' ");
query.Append($",'Softland','Centralizador', 'IW',{comuna.Id_Region}, '{time}') END");
conexion.Query = query.ToString();
var res = await Conexion.ExecuteNonQueryAsync(conexion);
if ((int)res == 2)
{
return(new Auxiliar()
{
DirAux = adressTemp,
ComAux = comuna.ComDes
});
}
}
catch (Exception)
{
throw;
}
return(null);
}
public async Task <int> UpdateAuxiliarAsync(ResultInstruction instruction, Conexion conexion, Comuna comuna)
{
string name;
string acteco = null;
CultureInfo cultureInfo = CultureInfo.GetCultureInfo("es-CL");
TextInfo ti = CultureInfo.CurrentCulture.TextInfo;
string time = string.Format(cultureInfo, "{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now);
string adressTemp = ti.ToTitleCase(instruction.ParticipantDebtor.CommercialAddress.ToLower());
if (instruction.ParticipantDebtor.CommercialAddress.Contains(','))
{
int index = instruction.ParticipantDebtor.CommercialAddress.IndexOf(',');
adressTemp = instruction.ParticipantDebtor.CommercialAddress.Substring(0, index);
}
if (adressTemp.Length > 60)
{
adressTemp = adressTemp.Substring(0, 60);
}
// Address
if (instruction.ParticipantDebtor.BusinessName.Length > 60)
{
name = instruction.ParticipantDebtor.BusinessName.Substring(0, 60);
}
else
{
name = instruction.ParticipantDebtor.BusinessName;
}
// Get acteco from CEN
if (true)
{
}
if (instruction.ParticipantDebtor.CommercialBusiness != null)
{
if (instruction.ParticipantDebtor.CommercialBusiness.Length > 60)
{
acteco = instruction.ParticipantDebtor.CommercialBusiness.Substring(0, 60);
}
else
{
acteco = instruction.ParticipantDebtor.CommercialBusiness;
}
// Insert new Acteco
await Acteco.InsertActecoAsync(acteco, conexion);
}
// Production:
if (Environment.MachineName == "DEVELOPER")
{
time = string.Format(cultureInfo, "{0:g}", DateTime.Now);
}
try
{
StringBuilder query = new StringBuilder();
string rut = string.Format(CultureInfo.CurrentCulture, "{0:N0}", instruction.ParticipantDebtor.Rut).Replace(',', '.');
query.Append($"UPDATE softland.cwtauxi SET NomAux='{name}', NoFAux='{instruction.ParticipantDebtor.Name}', ClaCli = 'S', ClaPro = 'S', Bloqueado = 'N', ");
query.Append($"Comaux = '{comuna.ComCod}', GirAux = (SELECT TOP 1 GirCod from softland.cwtgiro where GirDes = '{acteco}' ), EsReceptorDTE = 'S', PaiAux='CL', ActAux='S', ");
query.Append($"Usuario='Softland', Proceso='Centralizador', Sistema='IW', RutAux='{rut}-{instruction.ParticipantDebtor.VerificationCode}', FechaUlMod ='{time}', ");
query.Append($"DirAux = '{adressTemp}', ");
query.Append($"eMailDTE='{instruction.ParticipantDebtor.DteReceptionEmail}' WHERE CodAux='{instruction.ParticipantDebtor.Rut}'");
conexion.Query = query.ToString();
var res = await Conexion.ExecuteNonQueryAsync(conexion);
return((int)res);
}
catch (Exception)
{
throw;
}
}
