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