/// <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);
}
