public Response UpdateExecutive(InUpdateExecutive input)
{
InUpdateExecutive userData = new InUpdateExecutive();
Response response = new Response();
try
{
ExecutiveDAO dao = new ExecutiveDAO();
response = dao.UpdateExecutive(input);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageExecutive", "UpdateExecutive", ex, "");
}
return(response);
}
public JsonResult UpdateExcecutive(InUpdateExecutiveService formulario, List<HttpPostedFile> files)
{
var usr = (Login)System.Web.HttpContext.Current.Session["usr"];
if (usr == null)
{
RedirectToAction("Index", "Home");
return null;
}
InUpdateExecutive infoExecutive = new InUpdateExecutive();
var response = new Response();
var valid = new ManageExecutive().MapEntity(formulario, infoExecutive, ref response);
if (valid)
{
response = new ManageExecutive().UpdateExecutive(infoExecutive);
}
return new JsonResult { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public Response UpdateExecutive(InUpdateExecutive input)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
var ora = new OracleServer(connectionString);
Response response = new Response();
try
{
var pi_documentID = new OracleParameter("fa_cedula", OracleDbType.Varchar2, input.documentID, ParameterDirection.Input);
ora.AddParameter(pi_documentID);
var pi_name1 = new OracleParameter("fa_nombre1", OracleDbType.Varchar2, input.name1, ParameterDirection.Input);
ora.AddParameter(pi_name1);
var pi_name2 = new OracleParameter("fa_nombre2", OracleDbType.Varchar2, input.name2, ParameterDirection.Input);
ora.AddParameter(pi_name2);
var pi_surname1 = new OracleParameter("fa_apellido1", OracleDbType.Varchar2, input.surname1, ParameterDirection.Input);
ora.AddParameter(pi_surname1);
var pi_surname2 = new OracleParameter("fa_apellido2", OracleDbType.Varchar2, input.surname2, ParameterDirection.Input);
ora.AddParameter(pi_surname2);
var pi_birthDate = new OracleParameter("fa_fecha_nacto", OracleDbType.Date, input.birthDate, ParameterDirection.Input);
ora.AddParameter(pi_birthDate);
var pi_placeBirth = new OracleParameter("fa_lugar_nacto", OracleDbType.Double, input.placeBirth, ParameterDirection.Input);
ora.AddParameter(pi_placeBirth);
var pi_gender = new OracleParameter("fa_genero_persona", OracleDbType.Double, input.gender, ParameterDirection.Input);
ora.AddParameter(pi_gender);
var pi_civilStatus = new OracleParameter("fa_estado_civil", OracleDbType.Double, input.civilStatus, ParameterDirection.Input);
ora.AddParameter(pi_civilStatus);
var pi_notifyAddress = new OracleParameter("fa_direccion_notificacion", OracleDbType.Varchar2, input.notifyAddress, ParameterDirection.Input);
ora.AddParameter(pi_notifyAddress);
var pi_department = new OracleParameter("fa_departamento", OracleDbType.Double, input.department, ParameterDirection.Input);
ora.AddParameter(pi_department);
var pi_city = new OracleParameter("fa_ciudad_ase", OracleDbType.Double, input.city, ParameterDirection.Input);
ora.AddParameter(pi_city);
var pi_neighborhood = new OracleParameter("fa_barrio", OracleDbType.Double, input.neighborhood, ParameterDirection.Input);
ora.AddParameter(pi_neighborhood);
var pi_executivePhone = new OracleParameter("fa_telefono_ejecutivo", OracleDbType.Varchar2, input.executivePhone, ParameterDirection.Input);
ora.AddParameter(pi_executivePhone);
var pi_housePhone = new OracleParameter("fa_telefono_fijo", OracleDbType.Varchar2, input.housePhone, ParameterDirection.Input);
ora.AddParameter(pi_housePhone);
var pi_housingType = new OracleParameter("fa_tipo_vivienda", OracleDbType.Double, input.housingType, ParameterDirection.Input);
ora.AddParameter(pi_housingType);
var pi_email = new OracleParameter("fa_correo_electronico", OracleDbType.Varchar2, input.email, ParameterDirection.Input);
ora.AddParameter(pi_email);
var pi_appliedStudies = new OracleParameter("fa_estudios_realizados", OracleDbType.Double, input.appliedStudies, ParameterDirection.Input);
ora.AddParameter(pi_appliedStudies);
var pi_notifyEmail = new OracleParameter("fa_correo_ele_notificacion", OracleDbType.Varchar2, input.notifyEmail, ParameterDirection.Input);
ora.AddParameter(pi_notifyEmail);
var pi_bayportEmail = new OracleParameter("fa_correo_ele_bayport", OracleDbType.Varchar2, input.bayportEmail, ParameterDirection.Input);
ora.AddParameter(pi_bayportEmail);
var pi_emergencyPhone = new OracleParameter("fa_tel_caso_de_emergencia", OracleDbType.Varchar2, input.emergencyPhone, ParameterDirection.Input);
ora.AddParameter(pi_emergencyPhone);
var pi_bankAccount = new OracleParameter("fa_cuentabancaria", OracleDbType.Varchar2, input.bankAccount, ParameterDirection.Input);
ora.AddParameter(pi_bankAccount);
var pi_accountType = new OracleParameter("fa_tipodecuenta", OracleDbType.Double, input.accountType, ParameterDirection.Input);
ora.AddParameter(pi_accountType);
var pi_entityBank = new OracleParameter("fa_bancooentidad", OracleDbType.Double, input.entityBank, ParameterDirection.Input);
ora.AddParameter(pi_entityBank);
var pi_spouseName = new OracleParameter("fa_nombre_conyuge", OracleDbType.Varchar2, input.spouseName, ParameterDirection.Input);
ora.AddParameter(pi_spouseName);
var pi_spouseID = new OracleParameter("fa_cedula_conyuge", OracleDbType.Varchar2, input.spouseID, ParameterDirection.Input);
ora.AddParameter(pi_spouseID);
var pi_spouseCellphone = new OracleParameter("fa_celular_conyuge", OracleDbType.Varchar2, input.spouseCellphone, ParameterDirection.Input);
ora.AddParameter(pi_spouseCellphone);
var pi_spouseEmail = new OracleParameter("fa_correo_ele_conyuge", OracleDbType.Varchar2, input.spouseEmail, ParameterDirection.Input);
ora.AddParameter(pi_spouseEmail);
var pi_assets = new OracleParameter("fa_total_activos", OracleDbType.Double, input.assets, ParameterDirection.Input);
ora.AddParameter(pi_assets);
var pi_liabilities = new OracleParameter("fa_total_pasivos", OracleDbType.Double, input.liabilities, ParameterDirection.Input);
ora.AddParameter(pi_liabilities);
var pi_income = new OracleParameter("fa_ingresos", OracleDbType.Double, input.income, ParameterDirection.Input);
ora.AddParameter(pi_income);
var pi_expenses = new OracleParameter("fa_gastos", OracleDbType.Double, input.expenses, ParameterDirection.Input);
ora.AddParameter(pi_expenses);
var pi_otherIncome = new OracleParameter("fa_otros_ingresos", OracleDbType.Double, input.otherIncome, ParameterDirection.Input);
ora.AddParameter(pi_otherIncome);
var pi_afpNIT = new OracleParameter("fa_nit_afp", OracleDbType.Double, input.afpNIT, ParameterDirection.Input);
ora.AddParameter(pi_afpNIT);
var pi_arpNIT = new OracleParameter("fa_nit_arp", OracleDbType.Double, input.arpNIT, ParameterDirection.Input);
ora.AddParameter(pi_arpNIT);
var pi_epsNIT = new OracleParameter("fa_nit_eps", OracleDbType.Double, input.epsNIT, ParameterDirection.Input);
ora.AddParameter(pi_epsNIT);
var po_ErrorCode = new OracleParameter("fa_Error", OracleDbType.Double, ParameterDirection.Output);
var po_ErrorMessage = new OracleParameter("fa_Descripcion_Error", OracleDbType.Varchar2, ParameterDirection.Output);
po_ErrorMessage.Size = 100;
ora.AddParameter(po_ErrorCode);
ora.AddParameter(po_ErrorMessage);
ora.ExecuteProcedureNonQuery("DLGWFC_F_UPDATE_ASESOR_PORTAL");
response.errorCode = ora.GetParameter("fa_Error").ToString();
response.errorMessage = ora.GetParameter("fa_Descripcion_Error").ToString();
ora.Dispose();
}
catch (Exception ex)
{
throw new Exception("ExecutiveDAO.UpdateExecutive", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public bool MapEntity(InUpdateExecutiveService inputData, InUpdateExecutive infoExecutive, ref Response response)
{
bool valid = true;
string message = string.Empty;
try
{
/* Validacion sobre primer nombre*/
if (!string.IsNullOrEmpty(inputData.nombre1))
{
infoExecutive.name1 = inputData.nombre1;
}
else
{
valid = false;
message = "Inconsistencias en primer nombre";
response.errorMessage = message;
response.errorCode = "400";
LogHelper.WriteLog("Models", "MangerExecutive", "MapEntity", Helper.Utilities.ConvertToXml(inputData), "400-" + "|" + message, inputData.nombre1);
return(valid);
}
/* Validacion sobre primer apellido*/
if (!string.IsNullOrEmpty(inputData.apellido1))
{
infoExecutive.surname1 = inputData.apellido1;
}
else
{
valid = false;
message = "Inconsistencias en primer apellido";
response.errorMessage = message;
response.errorCode = "400";
LogHelper.WriteLog("Models", "MangerExecutive", "MapEntity", Helper.Utilities.ConvertToXml(inputData), "400-" + "|" + message, inputData.apellido1);
return(valid);
}
infoExecutive.documentID = inputData.numDocto;
if (!string.IsNullOrEmpty(inputData.nombre2))
{
infoExecutive.name2 = inputData.nombre2;
}
if (!string.IsNullOrEmpty(inputData.apellido2))
{
infoExecutive.surname1 = inputData.apellido2;
}
/*Validacion sobre fecha de nacimiento*/
if (inputData.fechaNacimiento != null && inputData.fechaNacimiento.Length <= 10 && inputData.fechaNacimiento != string.Empty)
{
CultureInfo provider = CultureInfo.InvariantCulture;
infoExecutive.birthDate = DateTime.ParseExact(inputData.fechaNacimiento.Substring(0, 10), "dd/MM/yyyy", provider);
}
else
{
valid = false;
message = "Inconsistencias en Fecha Nacimiento";
response.errorMessage = message;
response.errorCode = "400";
LogHelper.WriteLog("Models", "MangerExecutive", "MapEntity", Helper.Utilities.ConvertToXml(inputData), "400-" + "|" + message, inputData.fechaNacimiento);
return(valid);
}
if (!string.IsNullOrEmpty(inputData.lugarNac) && double.Parse(inputData.lugarNac) > 0)
{
infoExecutive.placeBirth = double.Parse(inputData.lugarNac);
}
if (!string.IsNullOrEmpty(inputData.gender) && double.Parse(inputData.gender) > 0)
{
infoExecutive.gender = double.Parse(inputData.gender);
}
if (!string.IsNullOrEmpty(inputData.civilStatus) && double.Parse(inputData.civilStatus) > 0)
{
infoExecutive.civilStatus = double.Parse(inputData.civilStatus);
}
if (!string.IsNullOrEmpty(inputData.dirNotifica))
{
infoExecutive.notifyAddress = inputData.dirNotifica;
}
if (!string.IsNullOrEmpty(inputData.DepartamentoID) && double.Parse(inputData.DepartamentoID) > 0)
{
infoExecutive.department = double.Parse(inputData.DepartamentoID);
}
if (!string.IsNullOrEmpty(inputData.ciudad) && double.Parse(inputData.ciudad) > 0)
{
infoExecutive.city = double.Parse(inputData.ciudad);
}
if (!string.IsNullOrEmpty(inputData.barrio) && double.Parse(inputData.barrio) > 0)
{
infoExecutive.neighborhood = double.Parse(inputData.barrio);
}
if (!string.IsNullOrEmpty(inputData.celular))
{
infoExecutive.executivePhone = inputData.celular;
}
if (!string.IsNullOrEmpty(inputData.telFijo))
{
infoExecutive.housePhone = inputData.telFijo;
}
if (!string.IsNullOrEmpty(inputData.tipoVivienda) && double.Parse(inputData.tipoVivienda) > 0)
{
infoExecutive.housingType = double.Parse(inputData.tipoVivienda);
}
if (!string.IsNullOrEmpty(inputData.correo))
{
infoExecutive.email = inputData.correo;
}
if (!string.IsNullOrEmpty(inputData.estudios) && double.Parse(inputData.estudios) > 0)
{
infoExecutive.appliedStudies = double.Parse(inputData.estudios);
}
if (!string.IsNullOrEmpty(inputData.correo))
{
infoExecutive.notifyEmail = inputData.correo;
}
if (!string.IsNullOrEmpty(inputData.correoBayport))
{
infoExecutive.bayportEmail = inputData.correoBayport;
}
if (!string.IsNullOrEmpty(inputData.celular))
{
infoExecutive.emergencyPhone = inputData.celular;
}
if (!string.IsNullOrEmpty(inputData.numeroCuenta))
{
infoExecutive.bankAccount = inputData.numeroCuenta;
}
if (!string.IsNullOrEmpty(inputData.tipoCuenta) && double.Parse(inputData.tipoCuenta) > 0)
{
infoExecutive.accountType = double.Parse(inputData.tipoCuenta);
}
if (!string.IsNullOrEmpty(inputData.Banco) && double.Parse(inputData.Banco) > 0)
{
infoExecutive.entityBank = double.Parse(inputData.Banco);
}
if (!string.IsNullOrEmpty(inputData.nombreConyuge))
{
infoExecutive.spouseName = inputData.nombreConyuge;
}
if (!string.IsNullOrEmpty(inputData.cedulaConyuge))
{
infoExecutive.spouseID = inputData.cedulaConyuge;
}
if (!string.IsNullOrEmpty(inputData.celularConyuge))
{
infoExecutive.spouseCellphone = inputData.celularConyuge;
}
if (!string.IsNullOrEmpty(inputData.emailConyuge))
{
infoExecutive.spouseEmail = inputData.emailConyuge;
}
inputData.activos = inputData.activos.Replace(".", "");
if (!string.IsNullOrEmpty(inputData.activos) && double.Parse(inputData.activos) > 0)
{
infoExecutive.assets = double.Parse(inputData.activos);
}
inputData.pasivos = inputData.pasivos.Replace(".", "");
if (!string.IsNullOrEmpty(inputData.pasivos) && double.Parse(inputData.pasivos) > 0)
{
infoExecutive.liabilities = double.Parse(inputData.pasivos);
}
inputData.ingresos = inputData.ingresos.Replace(".", "");
if (!string.IsNullOrEmpty(inputData.ingresos) && double.Parse(inputData.ingresos) > 0)
{
infoExecutive.income = double.Parse(inputData.ingresos);
}
inputData.gastos = inputData.gastos.Replace(".", "");
if (!string.IsNullOrEmpty(inputData.gastos) && double.Parse(inputData.gastos) > 0)
{
infoExecutive.expenses = double.Parse(inputData.gastos);
}
inputData.otrosIngresos = inputData.otrosIngresos.Replace(".", "");
if (!string.IsNullOrEmpty(inputData.otrosIngresos) && double.Parse(inputData.otrosIngresos) > 0)
{
infoExecutive.otherIncome = double.Parse(inputData.otrosIngresos);
}
if (!string.IsNullOrEmpty(inputData.AFP))
{
infoExecutive.afpNIT = inputData.AFP;
}
if (!string.IsNullOrEmpty(inputData.ARP))
{
infoExecutive.arpNIT = inputData.ARP;
}
if (!string.IsNullOrEmpty(inputData.EPS))
{
infoExecutive.epsNIT = inputData.EPS;
}
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageExecutive", "MapEntity", ex, "");
response.errorMessage = ex.InnerException.ToString();
response.errorCode = "400";
}
return(valid);
}
