public bool Get_Beneficiario_for_cDocCodigo_and_cPerCodigo(string cDocCodigo, string cPerCodigo)
{
BE_Get_Beneficiario_for_cDocCodigo Request = new BE_Get_Beneficiario_for_cDocCodigo();
DA_FondoMortorio DA = new DA_FondoMortorio();
Request.cDocCodigo = cDocCodigo;
Request.cPerCodigo = cPerCodigo;
return DA.Get_Beneficiario_for_cDocCodigo_and_cPerCodigo(Request);
}
//usp_Get_Beneficiario_for_cDocCodigo_and_cPerCodigo - * Para la Regla de Negocio *
public bool Get_Beneficiario_for_cDocCodigo_and_cPerCodigo(BE_Get_Beneficiario_for_cDocCodigo Request)
{
bool nExists = false;
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Get_Beneficiario_for_cDocCodigo_and_cPerCodigo]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
if (dt.Rows.Count == 0)
{
nExists = true; //si NO existe devuelve TRUE para crear nuevo
}
}
}
}
catch (Exception)
{
throw;
}
return nExists;
}
