public List <clsEntityRetention_RetentionLine> cs_fxObtenerTodoPorCabeceraId(string Id)
        {
            List <clsEntityRetention_RetentionLine> List_PerceptionLine;

            try
            {
                List_PerceptionLine = new List <clsEntityRetention_RetentionLine>();
                OdbcDataReader datos = null;
                string         sql   = "SELECT * FROM " + cs_cmTabla + " WHERE cs_Retention_Id=" + Id.Trim() + " ;";
                //clsBaseConexion cn = new clsBaseConexion();
                OdbcConnection cs_pxConexion_basedatos = new OdbcConnection(localDB.cs_prConexioncadenabasedatos());
                cs_pxConexion_basedatos.Open();
                datos = new OdbcCommand(sql, cs_pxConexion_basedatos).ExecuteReader();

                clsEntityRetention_RetentionLine PerceptionLine;
                while (datos.Read())
                {
                    PerceptionLine = new clsEntityRetention_RetentionLine(localDB);
                    PerceptionLine.Cs_pr_Retention_RetentionLine_Id = datos[0].ToString();
                    PerceptionLine.Cs_pr_Retention_Id                   = datos[1].ToString();
                    PerceptionLine.Cs_tag_Id                            = datos[2].ToString();
                    PerceptionLine.Cs_tag_Id_SchemeId                   = datos[3].ToString();
                    PerceptionLine.Cs_tag_IssueDate                     = datos[4].ToString();
                    PerceptionLine.Cs_tag_TotalInvoiceAmount            = datos[5].ToString();
                    PerceptionLine.Cs_tag_TotalInvoiceAmount_CurrencyId = datos[6].ToString();
                    PerceptionLine.Cs_tag_Payment_PaidDate              = datos[7].ToString();
                    PerceptionLine.Cs_tag_Payment_Id                    = datos[8].ToString();
                    PerceptionLine.Cs_tag_Payment_PaidAmount            = datos[9].ToString();
                    PerceptionLine.Cs_tag_Payment_PaidAmount_CurrencyId = datos[10].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_SUNATRetentionAmount            = datos[11].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_SUNATRetentionAmount_CurrencyId = datos[12].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_SUNATRetentionDate              = datos[13].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_SUNATNetTotalPaid               = datos[14].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_SUNATNetTotalPaid_CurrencyId    = datos[15].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_ExchangeRate_SourceCurrencyCode = datos[16].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_ExchangeRate_TargetCurrencyCode = datos[17].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_ExchangeRate_CalculationRate    = datos[18].ToString();
                    PerceptionLine.Cs_tag_SUNATRetentionInformation_ExchangeRate_Date               = datos[19].ToString();
                    List_PerceptionLine.Add(PerceptionLine);
                }
                cs_pxConexion_basedatos.Close();
                return(List_PerceptionLine);
            }
            catch (Exception ex)
            {
                clsBaseMensaje.cs_pxMsgEr("ERR6", ex.ToString());
                clsBaseLog.cs_pxRegistarAdd("clsEntityRetention_RetentionLine cs_fxObtenerTodoPorCabeceraId" + ex.ToString());
                return(null);
            }
        }
示例#2
0
        public bool cs_pxEliminarDocumento(string Id)
        {
            bool resultado = false;

            try
            {
                //Eliminar la cabecera y todos sus registros.
                clsEntityRetention Document = new clsEntityRetention(localDB).cs_fxObtenerUnoPorId(Id);
                clsEntityRetention_RetentionLine Document_Line = new clsEntityRetention_RetentionLine(localDB);

                foreach (var item in Document_Line.cs_fxObtenerTodoPorCabeceraId(Id))
                {
                    item.cs_pxElimnar(false);
                }

                Document.cs_pxElimnar(false);
                resultado = true;
            }
            catch (Exception ex)
            {
                clsBaseLog.cs_pxRegistarAdd(" clsEntityRetention cs_pxEliminarDocumento " + ex.ToString());
            }
            return(resultado);
        }