private MAccountRef GetAccountRef(EnumReferenceTable referenceTable, string warehouseId)
{
MAccountRef accountRef = _mAccountRefRepository.GetByRefTableId(referenceTable, warehouseId);
if (accountRef != null)
{
return(accountRef);
}
return(null);
}
public MAccountRef GetByRefTableId(EnumReferenceTable enumReferenceTable, string warehouseId)
{
ICriteria criteria = Session.CreateCriteria(typeof(MAccountRef));
criteria.Add(Expression.Eq("ReferenceTable", enumReferenceTable.ToString()));
if (!string.IsNullOrEmpty(warehouseId))
{
criteria.Add(Expression.Eq("ReferenceId", warehouseId));
}
return(criteria.UniqueResult <MAccountRef>());
}
protected void DeleteJournal(EnumReferenceTable referenceTable, string referenceType, string referenceId)
{
TJournalRef journalRef = JournalRefRepository.GetByReference(referenceTable,
referenceType, referenceId);
if (journalRef != null)
{
TJournal journalToDelete = journalRef.JournalId;
JournalRefRepository.Delete(journalRef);
JournalRepository.Delete(journalToDelete);
}
}
public TJournalRef GetByReference(EnumReferenceTable enumReferenceTable, string transStatus, string transId)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@" select ref
from TJournalRef as ref
where ref.ReferenceTable = :enumReferenceTable
and ref.ReferenceType = :transStatus
and ref.ReferenceId = :transId ");
IQuery q = Session.CreateQuery(sql.ToString());
q.SetMaxResults(1);
q.SetString("enumReferenceTable", enumReferenceTable.ToString());
q.SetString("transStatus", transStatus);
q.SetString("transId", transId);
return(q.UniqueResult <TJournalRef>());
}
