public Journal(JournalTypes journalType, string journalNumber, IManagementCompany managementCompany, ICurrency currency)
{
this.JournalType = journalType;
this.JournalNumber = journalNumber;
this.ManagementCompany = managementCompany;
this.currency = Currency;
}
public static IList<IJournal> GetJournals(IDalSession session, JournalTypes journalType)
{
List<ICriterion> expressions = new List<ICriterion>();
List<Order> orderings = new List<Order>();
expressions.Add(Expression.Eq("JournalType", journalType));
orderings.Add(Order.Asc("JournalNumber"));
return session.GetTypedList<Journal, IJournal>(expressions, orderings);
}
public static ILedgerType GetLedgerType(IDalSession session, JournalTypes journalType)
{
List<ICriterion> expressions = new List<ICriterion>();
expressions.Add(Expression.Eq("JournalType", journalType));
IList result = session.GetList(typeof(LedgerType), expressions);
if ((result != null) && (result.Count > 0))
return (ILedgerType)result[0];
else
return null;
}
public static IJournal GetJournal(IDalSession session, JournalTypes journalType, int currencyKey)
{
IJournal journal = null;
Hashtable parameters = new Hashtable();
string query = @"B4F.TotalGiro.GeneralLedger.Static.Journal.GetJournalByType";
parameters.Add("journalType", journalType);
parameters.Add("currencyKey", currencyKey);
IList list =session.GetListByNamedQuery(query, parameters);
if (list != null && list.Count == 1)
journal = (IJournal)list[0];
return journal;
}
public static DataSet GetJournals(JournalTypes journalType)
{
DataSet ds = null;
// "Key, FullDescription"
using (IDalSession session = NHSessionFactory.CreateSession())
{
ds = JournalMapper.GetJournals(session, journalType)
.Select(c => new
{
c.Key,
c.FullDescription
})
.ToDataSet();
}
Utility.AddEmptyFirstRow(ds.Tables[0]);
return ds;
}
private void loadDetails()
{
if (GLJournalID != 0)
{
JournalsAdapter.GLJournalDetails details = JournalsAdapter.GetGLJournalDetails(this.GLJournalID);
this.JournalNumber = details.JournalNumber;
this.Description = details.Description;
this.JournalType = details.JournalType;
this.FixedAccount = details.FixedAccount;
this.BankAccountNumber = details.BankAccountNumber;
}
}
