public static CreditCardStatement GetOrCreateStatementFromOperationDueDate(long oidCreditCard, DateTime dueDate, int sessionCode = -1)
{
CreditCardInfo credit_card = CreditCardInfo.Get(oidCreditCard, false);
if (credit_card.ETipoTarjeta != ETipoTarjeta.Credito)
{
return(CreditCardStatement.New());
}
if (credit_card.Statements == null)
{
credit_card.LoadChilds(typeof(CreditCardStatement), false);
}
CreditCardStatementInfo statement = credit_card.Statements.GetByDueDateItem(StatementDatesFromOperationDueDate.GetStatementDueDate(credit_card, dueDate));
if (statement == null)
{
CreditCardStatement obj = CreditCardStatement.New(credit_card, dueDate, sessionCode);
obj.From = StatementDatesFromOperationDueDate.GetStatementFromDate(credit_card, dueDate);
obj.Till = StatementDatesFromOperationDueDate.GetStatementTillDate(credit_card, dueDate);
obj.DueDate = StatementDatesFromOperationDueDate.GetStatementDueDate(credit_card, dueDate);
return(obj);
}
else
{
return(CreditCardStatement.Get(statement.Oid, false, sessionCode));
}
}
public static CreditCardStatementList GetByPaymentList(long oidPayment, long oidCreditCard, bool childs)
{
QueryConditions conditions = new QueryConditions
{
OidEntity = oidPayment,
EntityType = ETipoEntidad.Pago,
CreditCard = (oidCreditCard != 0) ? CreditCardInfo.New(oidCreditCard) : null,
};
return(GetList(CreditCardStatement.SELECT_BY_PAYMENT(conditions, false), childs));
}
public static CreditCardStatementList GetChildList(CreditCardInfo parent, bool childs)
{
CriteriaEx criteria = CreditCardStatement.GetCriteria(CreditCardStatement.OpenSession());
criteria.Query = CreditCardStatementList.SELECT(parent);
criteria.Childs = childs;
CreditCardStatementList list = DataPortal.Fetch <CreditCardStatementList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
public static CreditCardStatementList GetUnpaidList(long oidCreditCard, DateTime from, DateTime till, bool childs)
{
QueryConditions conditions = new QueryConditions
{
OidEntity = -1,
EntityType = ETipoEntidad.Pago,
CreditCard = (oidCreditCard != 0) ? CreditCardInfo.New(oidCreditCard) : null,
FechaAuxIni = from,
FechaAuxFin = till,
};
return(GetList(CreditCardStatement.SELECT_UNPAID(conditions, false), childs));
}
internal void CopyValues(CreditCardStatement source)
{
if (source == null)
{
return;
}
_record.CopyValues(source.Base.Record);
_bank_account = source.BankAccount;
_credit_card = source.CreditCard;
_pending = source.Base.Pending;
_deallocated = source.Base.Deallocated;
_status = source.Base.Status;
_cash_amount = source.CashAmount;
}
public static CreditCardStatementList GetList(string query, bool childs)
{
CriteriaEx criteria = CreditCardStatement.GetCriteria(CreditCardStatement.OpenSession());
criteria.Childs = childs;
if (nHManager.Instance.UseDirectSQL)
{
criteria.Query = query;
}
CreditCardStatementList list = DataPortal.Fetch <CreditCardStatementList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
/// <summary>
/// Construye el objeto y se encarga de obtener los
/// hijos si los tiene y se solicitan
/// </summary>
/// <param name="source">DataReader fuente</param>
private void Fetch(IDataReader source)
{
try
{
_base.CopyValues(source);
if (Childs)
{
if (nHMng.UseDirectSQL)
{
CreditCardStatement.DoLOCK(Session());
string query = CreditCardStatements.SELECT(this);
IDataReader reader = nHMng.SQLNativeSelect(query);
_statements = CreditCardStatements.GetChildList(SessionCode, reader);
}
}
}
catch (Exception ex) { throw ex; }
MarkOld();
}
public static string SELECT(CreditCardInfo source)
{
return(CreditCardStatement.SELECT(new QueryConditions {
CreditCard = source
}, false));
}
public static string SELECT(QueryConditions conditions)
{
return(CreditCardStatement.SELECT(conditions, false));
}
public void CopyFrom(CreditCardStatement source)
{
_base.CopyValues(source);
}