/// <summary> /// Convierte de un tipo de SipeAv a Entitle /// </summary> /// <param name="entitleSipe"></param> /// <returns></returns> public static Entitle EntitleConverter(EntitleSipeInformation entitleSipe) { var entitle = new Entitle { Birthdate = (DateTime)entitleSipe.BirthDate, Birthplace = entitleSipe.EntityBirth, CURP = entitleSipe.Curp, City = entitleSipe.Population, Colony = entitleSipe.Colony, EntitleId = entitleSipe.Curp, Gender = entitleSipe.Genger, MaritalStatus = entitleSipe.MaritalStatus, MaternalLastName = entitleSipe.SecondSurname, Name = entitleSipe.Name, NoISSSTE = entitleSipe.NumIssste, NumExt = entitleSipe.ExteriorNumber, NumInt = entitleSipe.InteriorNumber, PaternalLastName = entitleSipe.FirstSurname, RFC = entitleSipe.Rfc, Street = entitleSipe.Street, ZipCode = entitleSipe.PostalCode, Age = entitleSipe.Age, State = entitleSipe.State, MobilePhone = entitleSipe.MobilePhone }; return(entitle); }
public void UpdateEntitle(Entitle entitle) { var conexion = con.obtenConexion(); SqlCommand command = new SqlCommand("sp_updateEntitled", conexion); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@NoIssste", SqlDbType.VarChar).Value = entitle.NoISSSTE; command.Parameters.Add("@PaternalLastName", SqlDbType.VarChar).Value = entitle.PaternalLastName; command.Parameters.Add("@MaternalLastName", SqlDbType.VarChar).Value = entitle.MaternalLastName; command.Parameters.Add("@Name", SqlDbType.VarChar).Value = entitle.Name; command.Parameters.Add("@RFC", SqlDbType.VarChar).Value = entitle.RFC; command.Parameters.Add("@Age", SqlDbType.Int).Value = entitle.Age; command.Parameters.Add("@BirthDate", SqlDbType.Date).Value = entitle.Birthdate; command.Parameters.Add("@Gender", SqlDbType.VarChar).Value = entitle.Gender; command.Parameters.Add("@Street", SqlDbType.VarChar).Value = entitle.Street; command.Parameters.Add("@NumExt", SqlDbType.VarChar).Value = entitle.NumExt; command.Parameters.Add("@NumInt", SqlDbType.VarChar).Value = entitle.NumInt; command.Parameters.Add("@Colony", SqlDbType.VarChar).Value = entitle.Colony; command.Parameters.Add("@ZipCode", SqlDbType.VarChar).Value = entitle.ZipCode; command.Parameters.Add("@Email", SqlDbType.VarChar).Value = entitle.Email; command.Parameters.Add("@Telephone", SqlDbType.VarChar).Value = entitle.Telephone; command.Parameters.Add("@City", SqlDbType.VarChar).Value = entitle.City; command.Parameters.Add("@Curp", SqlDbType.VarChar).Value = entitle.CURP; command.Parameters.Add("@MaritalStatus", SqlDbType.VarChar).Value = entitle.MaritalStatus; command.Parameters.Add("@BirthPlace", SqlDbType.VarChar).Value = entitle.Birthplace; command.Parameters.Add("@Lada", SqlDbType.VarChar).Value = entitle.Lada; command.Parameters.Add("@RegimeType", SqlDbType.VarChar).Value = entitle.RegimeType; command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = entitle.IsActive; command.Parameters.Add("@MobilePhone", SqlDbType.VarChar).Value = entitle.MobilePhone == null ? entitle.MobilePhone = string.Empty : entitle.MobilePhone; conexion.Open(); command.ExecuteNonQuery(); conexion.Close(); }
public Entitle GetEntitleByCurp(string curp) { Entitle entitle = new Entitle(); var conexion = con.obtenConexion(); SqlCommand command = new SqlCommand("sp_getEntitles", conexion); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Curp", SqlDbType.VarChar).Value = curp; try { conexion.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { entitle.EntitleId = reader["EntitleId"].ToString(); entitle.Age = (int)reader["Age"]; entitle.Name = reader["Name"].ToString(); entitle.Birthdate = (DateTime?)reader["BirthDate"]; entitle.Birthplace = (string)reader["BirthPlace"]; entitle.City = (string)reader["City"]; entitle.Colony = (string)reader["Colony"]; entitle.CURP = (string)reader["CURP"]; entitle.Gender = (string)reader["Gender"]; entitle.MaritalStatus = (string)reader["MaritalStatus"]; entitle.MaternalLastName = (string)reader["MaternalLastName"]; entitle.PaternalLastName = (string)reader["PaternalLastName"]; entitle.Name = (string)reader["Name"]; entitle.NoISSSTE = (string)reader["NoISSSTE"]; entitle.NumExt = (string)reader["NumExt"]; entitle.NumInt = (string)reader["NumInt"]; entitle.RegimeType = reader["RegimeType"] == DBNull.Value ? "" : (string)reader["RegimeType"]; entitle.RFC = (string)reader["RFC"]; entitle.Street = (string)reader["Street"]; entitle.ZipCode = (string)reader["ZipCode"]; entitle.IsActive = reader["IsActive"] == DBNull.Value ? false : (bool)reader["IsActive"]; entitle.Lada = reader["Lada"] == DBNull.Value ? "" : (string)reader["Lada"]; entitle.Email = reader["Email"] == DBNull.Value ? "" : (string)reader["Email"]; entitle.Telephone = reader["Telephone"] == DBNull.Value ? "" : (string)reader["Telephone"]; entitle.MobilePhone = reader["MobilePhone"] == DBNull.Value ? "" : (string)reader["MobilePhone"]; } } else { Console.WriteLine("No rows found."); } //reader.Close(); conexion.Close(); return(entitle); } catch (Exception ex) { return(null); } }
/// <summary> /// Construye la sección de datos del cliente del reporte /// </summary> /// <param name="entitle">Datos del cliente del reporte</param> /// <returns>Lista de objetos entitle</returns> private List <Entitle> BuildEntitle(Entitle entitle) { List <Entitle> listEntitle = new List <Entitle>(); listEntitle.Add(entitle); return(listEntitle); }
public async Task <HttpResponseMessage> SaveEntitle(Entitle entitle) { return(await ValidateAndHandleOperationExecutionAsync(async() => { var result = await _entitleDomainService.SaveEntitle(entitle); return Request.CreateResponse(HttpStatusCode.OK, entitle); })); }
public bool GetStatusEntitle(string noIssste) { Entitle entitledInfo = null; EntitleSipeInformation entitledInformix = sipeAvServiceAgent.GetEntitleByNoIssste(noIssste); bool isActive = sipeAvServiceAgent.GetStateEntitle(entitledInformix); return(isActive); }
/// <summary> /// Construye el reporte con los objetos proporcionados /// </summary> /// <param name="header">Encabezado del reporte</param> /// <param name="entitle">Datos personales del cliente</param> /// <param name="items">Detalle la cotización</param> /// <returns>Objeto con el reporte de cotización</returns> private QuotationReport BuildReport(Header header, Entitle entitle, List <ItemsQuotation> items) { QuotationReport report = new QuotationReport(); report.Subreports[1].SetDataSource(BuildHeader(header)); report.Subreports[0].SetDataSource(BuildEntitle(entitle)); report.Subreports[2].SetDataSource(items); return(report); }
public Catalogos(IEnumerable <DelegationCalendar> dc, IEnumerable <PropertType> pt, IEnumerable <TypeOwner> to, IEnumerable <UrbanCenter> uc, Request_Property_Entitles rpe, Entitle entap) { _pt = pt.ToList(); _to = to.ToList(); _uc = uc.ToList(); _rpe = rpe; _entap = entap; _dc = dc.ToList(); // _typeowner = typeowner; }
/// <summary> /// Obtiene el reporte de una cotización en formato Pdf /// </summary> /// <param name="header">Encabezado del reporte</param> /// <param name="entitle">Datos personales del cliente</param> /// <param name="items">Detalle la cotización</param> /// <returns>Arreglo de bytes con el reporte final generado</returns> public byte[] GetQuotationReportPDFStream(Header header, Entitle entitle, List <ItemsQuotation> items) { var report = BuildReport(header, entitle, items); var reportQuotation = report.ExportToStream(ExportFormatType.PortableDocFormat); using (MemoryStream ms = new MemoryStream()) { reportQuotation.CopyTo(ms); return(ms.ToArray()); } }
public Task <int> SaveEntitle(Entitle entitle) { try { _context.Entitles.AddOrUpdate(entitle); if (!String.IsNullOrEmpty(entitle.Email) && !String.IsNullOrEmpty(entitle.Telephone)) { var entitleViewModel = new EntitleViewModel { Email = entitle.Email, Telephone = entitle.Telephone }; _sipeAv.UpdateEntitledInfoAsync(entitle.CURP, entitleViewModel); } return(_context.SaveChangesAsync()); } catch (Exception exception) { throw exception; } }
public void UpdateEntitledFromInformix(Entitle entitledDataBase, EntitleSipeInformation entitledInformix, RegimenInformation regimenInformation) { entitledDataBase.Age = entitledInformix.Age; entitledDataBase.Birthdate = entitledInformix.BirthDate; entitledDataBase.Birthplace = entitledInformix.EntityBirth.Trim(); entitledDataBase.City = entitledInformix.Population.Trim(); entitledDataBase.Colony = entitledInformix.Colony.Trim(); entitledDataBase.CURP = entitledInformix.Curp.Trim(); entitledDataBase.Gender = entitledInformix.Genger.Trim(); entitledDataBase.MaritalStatus = entitledInformix.MaritalStatus.Trim(); entitledDataBase.MaternalLastName = entitledInformix.SecondSurname.Trim(); entitledDataBase.Name = entitledInformix.Name.Trim(); entitledDataBase.NoISSSTE = entitledInformix.NumIssste.Trim(); entitledDataBase.NumExt = entitledInformix.ExteriorNumber.Trim(); entitledDataBase.NumInt = entitledInformix.InteriorNumber.Trim(); entitledDataBase.PaternalLastName = entitledInformix.FirstSurname.Trim(); entitledDataBase.RegimeType = (regimenInformation != null && !string.IsNullOrEmpty(regimenInformation.RegimenKey)) ? regimenInformation.RegimenKey.Trim() : string.Empty; entitledDataBase.RFC = entitledInformix.Rfc.Trim(); entitledDataBase.Street = entitledInformix.Street.Trim(); entitledDataBase.ZipCode = entitledInformix.PostalCode.Trim(); entitledDataBase.IsActive = sipeAvServiceAgent.GetStateEntitle(entitledInformix); db.UpdateEntitle(entitledDataBase); }
public void SaveEntitle(Entitle entitle) { ////entDA.saveInformationEntitle(); }
public Entitle GetEntitle(string noIssste) { Entitle entitledInfo = null; EntitleSipeInformation entitledInformix = sipeAvServiceAgent.GetEntitleByNoIssste(noIssste); RegimenInformation entitledRegimen = sipeAvServiceAgent.GetRegimenByNoIssste(noIssste); bool isActive = sipeAvServiceAgent.GetStateEntitle(entitledInformix); if (entitledInformix != null) { entitledInfo = new Entitle() { Age = entitledInformix.Age, Birthdate = entitledInformix.BirthDate, Birthplace = entitledInformix.EntityBirth.Trim(), City = entitledInformix.Population.Trim(), Colony = entitledInformix.Colony.Trim(), CURP = entitledInformix.Curp.Trim(), Gender = entitledInformix.Genger.Trim(), MaritalStatus = entitledInformix.MaritalStatus.Trim().ToUpper(), MaternalLastName = entitledInformix.SecondSurname.Trim(), Name = entitledInformix.Name.Trim(), NoISSSTE = entitledInformix.NumIssste.Trim(), NumExt = entitledInformix.ExteriorNumber.Trim(), NumInt = entitledInformix.InteriorNumber.Trim(), PaternalLastName = entitledInformix.FirstSurname.Trim(), RegimeType = (entitledRegimen != null && !string.IsNullOrEmpty(entitledRegimen.RegimenKey)) ? entitledRegimen.RegimenKey.Trim() : string.Empty, RFC = entitledInformix.Rfc.Trim(), Street = entitledInformix.Street.Trim(), ZipCode = entitledInformix.PostalCode.Trim(), EntitleId = entitledInformix.Curp.Trim(), IsActive = isActive, State = entitledInformix.State }; Entitle existingEntitled = commonDomainService.GetEntitledByCURP(entitledInformix.Curp); if (existingEntitled != null && !string.IsNullOrEmpty(existingEntitled.CURP)) { commonDomainService.UpdateEntitledFromInformix(existingEntitled, entitledInformix, entitledRegimen); } else { commonDomainService.SaveEntitledFromInformix(entitledInfo); } entitledInfo = commonDomainService.GetEntitledByCURP(entitledInformix.Curp); } if (entitledInformix.State == "") { entitledInfo.State = "BAJA"; } else if (entitledInformix.State == "F") { entitledInfo.State = "FINADO"; } else { entitledInfo.State = "ACTIVO"; } return(entitledInfo); }
public ActionResult SaveRequest(string hidden, [Bind(Prefix = "Item2")] Request requestData, [Bind(Prefix = "Item1")] Entitle entitle, string RequestId) { //Meter variables de session o temp para guardar los datos del campo de direccion y el de la opcion de conyugue o individual //Validar de algun modo que si ya existe el numero de RequestId no tiene que volver arrojar otro try { Request request = new Request(); if (RequestId == null || RequestId == "") { request.RequestId = Guid.NewGuid(); } else { request.RequestId = new Guid(RequestId); } request.IsConjugalCredit = Convert.ToBoolean(requestData.IsConjugalCredit); request.WritingProperty = Request.Params["WritingProperty"].ToString(); var result = entitleDomain.GetEntitle(hidden); if (RequestId == null || RequestId == "") { requestBussinessLogic.SaveRequest(request, result.EntitleId); } else { requestBussinessLogic.UpdateRequest(RequestId, request.WritingProperty, request.IsConjugalCredit); } if (request.IsConjugalCredit) { TempData["TypeCredit"] = (int)EnumBeneficiario.Conyugal; } TempData["WritingProperty"] = request.WritingProperty.ToString(); TempData["RequestId"] = request.RequestId; ViewBag.Message = "1"; Session["Status"] = (int)StatusEnum.EnesperaderevisiondedocumentacionDer; return(RedirectToAction("Documentacion", new { NoIssste = hidden, RequestId = request.RequestId })); } catch (Exception ex) { ViewBag.Message = "Error"; return(View()); } }
public void SaveEntitledFromInformix(Entitle entitled) { db.SaveEntitle(entitled); }