public ActionResult GuardaFotoCedulaDorso(DTO_SOLICITUD_VENTAS solicitudes)
{
ManagerSolcitudes manager = new ManagerSolcitudes();
List <Tab_ConfigSys> CONF = new List <Tab_ConfigSys>();
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
string strHostName = System.Net.Dns.GetHostName();
//IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); <-- Obsolete
IPHostEntry ipHostInfo = Dns.GetHostEntry(strHostName);
IPAddress ipAddress = ipHostInfo.AddressList[0];
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
STR_PARAMETROS = JsonConvert.SerializeObject(solicitudes),
FEC_CREACION = DateTime.Now
};
Tab_ConfigSys dto_Config = new Tab_ConfigSys();
dto_Config.llave_Config1 = "SERVICIO";
dto_Config.llave_Config2 = "CONFIGURACION";
dto_Config.llave_Config3 = "SERVIDOR";
dto_Config.llave_Config4 = "URL";
dto_Config.llave_Config5 = "FOTOCEDULATRASERA";
try
{
var dto_interval = manager.ConsultaConfiUrlImagen(dto_Config);
string URL = dto_interval.Where(x => x.llave_Config5 == "FOTOCEDULATRASERA").Select(x => x.Dato_Char1).FirstOrDefault();
solicitudes.UrlFoto = URL + solicitudes.Identificacion + "/" + solicitudes.Identificacion;
FileStream fileStream = new FileStream(solicitudes.UrlFotoCedulaTrasera, FileMode.Open);
Image image = Image.FromStream(fileStream);
fileStream.Close();
if (manager.ValidarFichero(solicitudes.UrlFotoCedulaTrasera))
{
image.Save(solicitudes.UrlFotoCedulaTrasera);
image.Dispose();
}
var dto_listLogin = manager.MetodoGuardaFoto(solicitudes);
return(View());
// return Ok();
}
catch (ArgumentException)
{
solicitudes.Respuesta = "Ocurrio un Error";
}
return(View());
}
public ActionResult ActualizarSolicitud(DTO_SOLICITUD_VENTAS solicitudes)
{
ManagerSolcitudes mang = NewMethod();
solicitudes.USUARIO_MODIFICACION = Session["agente"].ToString();
var res = mang.CambiarEstadoRevisionDocumentos(solicitudes);
return(Json(res));
}
internal static void ApiSolicitudEndConsul(InsertPersonasWeb insertPersonasWeb, ref DTO_SOLICITUD_VENTAS persona)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in insertPersonasWeb.GetType().GetProperties()
where nodo.GetValue(insertPersonasWeb) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(insertPersonasWeb).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_ValidarPIN";
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(insertPersonasWeb),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
try
{
var obj = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
var dto_result = new List <DTO_SOLICITUD_VENTAS>();
if (obj.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <DTO_SOLICITUD_VENTAS> >(JsonConvert.SerializeObject(obj.Result.Tables[0]));
}
persona = dto_result.ToList().FirstOrDefault();
if (persona != null)
{
persona.Status = dto_result.Any() ? dto_result.ToList().FirstOrDefault().Status : null;
}
else
{
persona = new DTO_SOLICITUD_VENTAS();
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
}
public ActionResult InsertarNuevaSolictitudes(DTO_SOLICITUD_VENTAS solicitudes)
{
int contadorIntentos = 0;
InsertPersonasWeb persona = new InsertPersonasWeb();
try
{
if (ModelState.IsValid)
{
persona.Identificacion = solicitudes.Identificacion;
persona.TelefonoCel = solicitudes.Telefono;
persona.Correo = solicitudes.Mail;
persona.SubOrigen = solicitudes.SubOrigen;
persona.UsrModifica = Convert.ToString(Session["agente"]);
persona.Origen = GlobalClass.Origen_Apps;
Models.Manager.clsInsertaSolicitud.InsertaSolicitudesInvoke(ref persona);
if (persona.UltidSolicitud == null)
{
persona.UltidSolicitud = 0;
}
System.Threading.Thread.Sleep(9000);
while ((solicitudes.Status == 12 || solicitudes.Status == null || solicitudes.Status == 0) && (contadorIntentos < 50))
{
Models.Manager.clsInsertaSolicitud.ApiSolicitudEndConsul(persona, ref solicitudes);
contadorIntentos++;
}
solicitudes.Identificacion = persona.Identificacion;
if (persona.SegundoNombre != "")
{
solicitudes.Nombre = persona.PrimerNombre + " " + persona.SegundoNombre + " " + persona.PrimerApellido + " " + persona.SegundoApellido;
}
else
{
solicitudes.Nombre = persona.PrimerNombre + " " + persona.PrimerApellido + " " + persona.SegundoApellido;
}
}
}
catch (Exception ex)
{
solicitudes.Status = -1;
solicitudes.Mensaje = ex.Message;
return(Json(solicitudes));
//persona.Respuesta = "Ocurrio un Error";
}
//return View(asignacionbuckets);
return(Json(solicitudes));
}
//return View(asignacionbuckets);
public ActionResult GuardaProductoSolicitud(DTO_SOLICITUD_VENTAS solicitudes)
{
var dto_sol = new List <DTO_SOLICITUD_VENTAS>();
try
{
if (ModelState.IsValid)
{
solicitudes.USUARIO_MODIFICACION = Convert.ToString(Session["agente"]);
Models.Manager.clsInsertaSolicitud.GuardaProducto(solicitudes);
}
}
catch (ArgumentException)
{
solicitudes.Respuesta = "Ocurrio un Error";
}
//return View(asignacionbuckets);
return(Json(solicitudes));
}
internal static List <DTO_SOLICITUD_VENTAS> GuardaProducto(DTO_SOLICITUD_VENTAS solicitudes)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in solicitudes.GetType().GetProperties()
where nodo.GetValue(solicitudes) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(solicitudes).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_GuardarProducto";
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(solicitudes),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto_obj = new List <DTO_SOLICITUD_VENTAS>();
try
{
var obj = DynamicSqlDAO.ExecuterSp <DTO_SOLICITUD_VENTAS>(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
dto_obj = obj.ToList();
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(dto_obj);
}
public ActionResult CrearDocumentoDom(PagareContrato documentoDom)
{
ManagerSolcitudes manager = new ManagerSolcitudes();
dto_file dto_File = new dto_file();
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
string strHostName = System.Net.Dns.GetHostName();
var dto_listLogin = new List <DTO_SOLICITUD_VENTAS>();
//IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); <-- Obsolete
IPHostEntry ipHostInfo = Dns.GetHostEntry(strHostName);
IPAddress ipAddress = ipHostInfo.AddressList[0];
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
STR_PARAMETROS = JsonConvert.SerializeObject(documentoDom),
FEC_CREACION = DateTime.Now
};
DTO_SOLICITUD_VENTAS solicitudes = new DTO_SOLICITUD_VENTAS();
solicitudes.Identificacion = documentoDom.Identificacion;
solicitudes.IdSolicitud = documentoDom.IdSolicitud;
try
{
//creamos el documento de domiciliacion y guardamos al url del archivo
dto_File = manager.CrearDocDom(documentoDom);
}
catch (ArgumentException)
{
dto_File.Respuesta = "Ocurrio un Error";
}
return(Json(dto_File));
///System.IO.File.Delete(rutaDocDom);
}
public ActionResult CreaContratoPagare(PagareContrato pagareContrato)
{
ManagerSolcitudes manager = new ManagerSolcitudes();
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
string strHostName = System.Net.Dns.GetHostName();
var dto_listLogin = new List <DTO_SOLICITUD_VENTAS>();
//IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); <-- Obsolete
IPHostEntry ipHostInfo = Dns.GetHostEntry(strHostName);
IPAddress ipAddress = ipHostInfo.AddressList[0];
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
STR_PARAMETROS = JsonConvert.SerializeObject(pagareContrato),
FEC_CREACION = DateTime.Now
};
DTO_SOLICITUD_VENTAS solicitudes = new DTO_SOLICITUD_VENTAS();
solicitudes.Identificacion = pagareContrato.Identificacion;
solicitudes.IdSolicitud = pagareContrato.IdSolicitud;
try
{
solicitudes.UrlDirectorioPagare = manager.CrearPdf(pagareContrato);
dto_listLogin = manager.MetodoGuardaFoto(solicitudes);
return(Json(dto_listLogin));
}
catch (ArgumentException)
{
solicitudes.Respuesta = "Ocurrio un Error";
}
return(Json(dto_listLogin));
}
/// <summary>
///
/// </summary>
/// <param name="ventas"></param>
/// <param name="dto_interval"></param>
/// <param name="tipoImagen">1=FotoCedula, 2=CedultaTrasera, 3=firma, 4= selfie, 5=pagare PDF</param>
private void descargarImagenes(DTO_SOLICITUD_VENTAS ventas, List <Tab_ConfigSys> dto_interval, int tipoImagen)
{
try
{
var dir = dto_interval.Where(x => x.llave_Config5 == "RUTA_REMOVE").Select(x => x.Dato_Char1).FirstOrDefault(); //Server.MapPath("/");
var _ContainerPrefix = string.Empty;
var _PatchTempToSave = string.Empty;
var _ImageExtencion = string.Empty; //Path.GetExtension();
switch (tipoImagen)
{
case 1:
_ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_CEDULA").Select(x => x.Dato_Char1).FirstOrDefault(), "/", ventas.Identificacion);
_PatchTempToSave = string.Concat(dto_interval.Where(x => x.llave_Config5 == "FOTOCEDULA").Select(x => x.Dato_Char1).FirstOrDefault(), ventas.Identificacion);
_ImageExtencion = Path.GetExtension(ventas.UrlFotoCedula);
ventas.UrlFotoCedula = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion).Replace(dir, "");
break;
case 2:
_ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_CEDULATRASERA").Select(x => x.Dato_Char1).FirstOrDefault(), "/", ventas.Identificacion);
_PatchTempToSave = string.Concat(dto_interval.Where(x => x.llave_Config5 == "FOTOCEDULATRASERA").Select(x => x.Dato_Char1).FirstOrDefault(), ventas.Identificacion);
_ImageExtencion = Path.GetExtension(ventas.UrlFotoCedulaTrasera);
ventas.UrlFotoCedulaTrasera = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion).Replace(dir, "");
break;
case 3:
_ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault(), "/", ventas.Identificacion);
_PatchTempToSave = string.Concat(dto_interval.Where(x => x.llave_Config5 == "FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault(), ventas.Identificacion);
_ImageExtencion = Path.GetExtension(ventas.UrlFotoFirma);
ventas.UrlFotoFirma = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion).Replace(dir, "");
break;
case 4:
_ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_SELFIE").Select(x => x.Dato_Char1).FirstOrDefault(), "/", ventas.Identificacion);
_PatchTempToSave = string.Concat(dto_interval.Where(x => x.llave_Config5 == "FOTOSELFIE").Select(x => x.Dato_Char1).FirstOrDefault(), ventas.Identificacion);
_ImageExtencion = Path.GetExtension(ventas.UrlFotoSelfie);
ventas.UrlFotoSelfie = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion).Replace(dir, "");
break;
case 5:
_ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_PAGARE").Select(x => x.Dato_Char1).FirstOrDefault(), "/", ventas.Identificacion);
_PatchTempToSave = string.Concat(dto_interval.Where(x => x.llave_Config5 == "CONTRATOPAGARE").Select(x => x.Dato_Char1).FirstOrDefault(), ventas.Identificacion);
_ImageExtencion = Path.GetExtension(ventas.UrlDirectorioPagare);
ventas.UrlDirectorioPagare = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion).Replace(dir, "");
break;
}
var blobDowland = new blobStorage
{
ImageToUploadByte = null,
ContainerPrefix = _ContainerPrefix,
ImageExtencion = _ImageExtencion,
ImageToUpload = ventas.Identificacion,
ConnectionString = dto_interval.Where(x => x.llave_Config5 == "CONECTION").Select(x => x.Dato_Char1).FirstOrDefault(),// "DefaultEndpointsProtocol=https;AccountName=fenix2fun2me;AccountKey=qEZhKqhySrIvLgiplmWIVwTR9kCFtznIFEmMhrfF56jWwlSnUJuh2fCXYmBtKl2dafQb+f/UYBUv1RQP5n9/Mg==;EndpointSuffix=core.windows.net",
PatchTempToSave = _PatchTempToSave
};
if (!Directory.Exists(blobDowland.PatchTempToSave))
{
Directory.CreateDirectory(blobDowland.PatchTempToSave);
}
var fileDelete = string.Concat(_PatchTempToSave, "/", ventas.Identificacion, _ImageExtencion);
if (System.IO.File.Exists(fileDelete))
{
System.IO.File.Delete(fileDelete);
}
UtilBlobStorageAzure.DownloadBlobStorage(blobDowland);
}
catch (Exception ex) { }
//return ventas;
}
public ActionResult GiraFotoFirma(DTO_SOLICITUD_VENTAS solicitudes)
{
ManagerSolcitudes manager = new ManagerSolcitudes();
List <Tab_ConfigSys> CONF = new List <Tab_ConfigSys>();
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
string strHostName = System.Net.Dns.GetHostName();
var dto_listLogin = new List <DTO_SOLICITUD_VENTAS>();
//IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); <-- Obsolete
IPHostEntry ipHostInfo = Dns.GetHostEntry(strHostName);
IPAddress ipAddress = ipHostInfo.AddressList[0];
AWSAccess wSAccess = new AWSAccess();
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
STR_PARAMETROS = JsonConvert.SerializeObject(solicitudes),
FEC_CREACION = DateTime.Now
};
Tab_ConfigSys dto_Config = new Tab_ConfigSys();
dto_Config.llave_Config1 = "SERVICIO";
dto_Config.llave_Config2 = "CONFIGURACION";
dto_Config.llave_Config3 = "SERVIDOR";
dto_Config.llave_Config4 = "URL";
//dto_Config.llave_Config5 = "FOTOFIRMA";
byte[] bytes = null;
try
{
int rotate = 0;
var dto_interval = manager.ConsultaConfiUrlImagen(dto_Config);
string URL = dto_interval.Where(x => x.llave_Config5 == "FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault();
var SOL_TEMP = manager.ConsultaDirectorioImagen(solicitudes);
string ext = Path.GetExtension(SOL_TEMP.FirstOrDefault().UrlFotoFirma);
ext = ext == null ? ".jpg" : ext;
//solicitudes.UrlFotoFirma = String.Concat(URL + solicitudes.Identificacion + "/" + solicitudes.Identificacion, ext);
// FileStream fileStream = new FileStream(SOL_TEMP.FirstOrDefault().UrlFotoCedula, FileMode.Open);
var blobDowland = new blobStorage
{
ImageToUploadByte = null,
ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault(), "/", solicitudes.Identificacion), //"documentos/FotoCedula/206560175",
ImageExtencion = ".jpg",
ImageToUpload = solicitudes.Identificacion,
ConnectionString = dto_interval.Where(x => x.llave_Config5 == "CONECTION").Select(x => x.Dato_Char1).FirstOrDefault(), // "DefaultEndpointsProtocol=https;AccountName=fenix2fun2me;AccountKey=qEZhKqhySrIvLgiplmWIVwTR9kCFtznIFEmMhrfF56jWwlSnUJuh2fCXYmBtKl2dafQb+f/UYBUv1RQP5n9/Mg==;EndpointSuffix=core.windows.net",
PatchTempToSave = dto_interval.Where(x => x.llave_Config5 == "FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault() //@"C:\IVAN\images\FotoCedulas\206560175"
};
//FileStream fileStream = new FileStream(solicitudes.UrlFotoFirma, FileMode.Open);
UtilBlobStorageAzure.DownloadBlobStorageBytes(blobDowland);
if (blobDowland.ImageToUploadByte != null)
{
bytes = blobDowland.ImageToUploadByte;
}
Image image = Image.FromStream(new MemoryStream(bytes));
//fileStream.Close();
rotate = 8;
//int orientationValue = image.GetPropertyItem(prop.Id).Value[0];
RotateFlipType rotateFlipType = wSAccess.GetOrientationToFlipType(rotate);
image.RotateFlip(rotateFlipType);
bytes = (byte[])(new ImageConverter()).ConvertTo(image, typeof(byte[]));
//if (Utilitarios.ValidarFichero(solicitudes.UrlFotoFirma))
//{
// image.Save(solicitudes.UrlFotoFirma);
// image.Dispose();
//}
var blob = new blobStorage
{
ImageToUploadByte = bytes,
ContainerPrefix = string.Concat(dto_interval.Where(x => x.llave_Config5 == "RUTA_BLOB_FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault(), "/", solicitudes.Identificacion), //"documentos/FotoCedula/206560175",
ImageExtencion = ext,
ImageToUpload = solicitudes.Identificacion,
ConnectionString = dto_interval.Where(x => x.llave_Config5 == "CONECTION").Select(x => x.Dato_Char1).FirstOrDefault(), // "DefaultEndpointsProtocol=https;AccountName=fenix2fun2me;AccountKey=qEZhKqhySrIvLgiplmWIVwTR9kCFtznIFEmMhrfF56jWwlSnUJuh2fCXYmBtKl2dafQb+f/UYBUv1RQP5n9/Mg==;EndpointSuffix=core.windows.net",
PatchTempToSave = dto_interval.Where(x => x.llave_Config5 == "FOTOFIRMA").Select(x => x.Dato_Char1).FirstOrDefault() //@"C:\IVAN\images\FotoCedulas\206560175"
};
UtilBlobStorageAzure.UploadBlobStorage(blob);
//Thread threadObj = new Thread(new ThreadStart(() => UtilBlobStorageAzure.UploadBlobStorage(blob)));
//threadObj.Start();
solicitudes.UrlFotoFirma = string.Concat(blob.ContainerPrefix, "/", solicitudes.Identificacion, blob.ImageExtencion);
dto_listLogin = manager.MetodoGuardaFoto(solicitudes);
return(Json(dto_listLogin));
// return Ok();
}
catch (ArgumentException)
{
solicitudes.Respuesta = "Ocurrio un Error";
}
return(Json(dto_listLogin));
}
