// Total meetings
public long totalMeetingsHeld()
{
var totalMeetings = (from m in SessionProxy.Query <Meeting>()
select m).Count();
return(totalMeetings);
}
// Total Loan Repayment
public double findTotalLoanRepayment()
{
var replayments = (from m in SessionProxy.Query <Meeting>()
select m).Sum(x => (double)x.SumOfLoanRepayments);
return(replayments);
}
// Total loans
public double findTotalLoans()
{
var loans = (from m in SessionProxy.Query <Meeting>()
select m).Sum(x => (double)x.SumOfLoanIssues);
return(loans);
}
// Total Savings
public double findTotalSavings()
{
var savings = (from m in SessionProxy.Query <Meeting>()
select m).Sum(x => (double)x.SumOfSavings);
return(savings);
}
public List <VslaRegion> findAllRegions()
{
var allRegions = (from r in SessionProxy.Query <VslaRegion>()
select r).ToList();
return(allRegions);
}
public void CloseSessionPool()
{
lock (sessionPool)
{
for (int i = 0; i < MAX_SESSION; i++)
{
SessionProxy sp = sessionPool[i];
if (sp == null || sp.session == null || sp.tid == 0 || sp.startDT == null)
{
continue;
}
ITransaction currXact = sp.session.Transaction;
if (currXact != null)
{
if (currXact.IsActive)
{
currXact.Rollback();
}
currXact.Dispose();
currXact = null;
}
sp.session.Dispose();
sp.session = null;
sp.startDT = null;
sp.tid = 0;
}
}
}
// All Technical Trainers
public List <TechnicalTrainer> findAllTechnicalTrainers()
{
var trainers = (from t in SessionProxy.Query <TechnicalTrainer>()
select t).ToList();
return(trainers);
}
public List <UserPermissions> allUserPermissions()
{
var permissions = (from p in SessionProxy.Query <UserPermissions>()
select p).ToList();
return(permissions);
}
// Get all Vslas
public List <Vsla> findAllVslas()
{
var vslas = (from v in SessionProxy.Query <Vsla>()
select v).ToList();
return(vslas);
}
// Get all registered system users
public List <Users> findAllUsers()
{
var users = (from u in SessionProxy.Query <Users>()
select u).ToList();
return(users);
}
// Count the number of VSLAs
public long countVslas()
{
var vslas = (from v in SessionProxy.Query <Vsla>()
select v).Count();
return(vslas);
}
public static SessionInfo From(ISocketClient socketClient, SessionPool sessionPool)
{
var session = new Session(socketClient);
var proxy = new SessionProxy(session, sessionPool);
return(new SessionInfo(session, proxy));
}
public void KillSessions(Guid[] ids)
{
using (var proxy = new SessionProxy())
{
proxy.KillSessions(ids);
}
}
public List <GroupSupport> findAllGroupSupport()
{
var groupSupport = (from gs in SessionProxy.Query <GroupSupport>()
select gs).ToList();
return(groupSupport);
}
public Vsla FindVslaByCode(string vslaCode)
{
var vsla = (from v in SessionProxy.Query <Vsla>()
where v.VslaCode.ToUpper() == vslaCode.ToUpper()
select v).FirstOrDefault();
return(vsla);
}
// Get a information for a particular
public List <Users> findParticularUser(int userLevel, string userName)
{
var user = (from u in SessionProxy.Query <Users>()
where u.UserLevel == userLevel && u.Username == userName
select u).ToList();
return(user);
}
// get the maximum share quantity and share price for each group in a given cycle
public VslaCycle vslaCycleDetails(int vslaId, int cycleId)
{
var details = (from c in SessionProxy.Query <VslaCycle>()
where c.CycleId == cycleId && c.Vsla.VslaId == vslaId
select c).FirstOrDefault();
return(details);
}
public VslaCycle FindVslaCycleByIdEx(int vslaId, int cycleIdEx)
{
var cycle = (from c in SessionProxy.Query <VslaCycle>()
where c.CycleIdEx == cycleIdEx && c.Vsla.VslaId == vslaId
select c).FirstOrDefault();
return(cycle);
}
public VslaCycle FindVslaCycleByIdEx(string vslaCode, int cycleIdEx)
{
var cycle = (from c in SessionProxy.Query <VslaCycle>()
where c.CycleIdEx == cycleIdEx && c.Vsla.VslaCode.ToUpper() == vslaCode.ToUpper()
select c).FirstOrDefault();
return(cycle);
}
public LoanRepayment findMemberMeetingRepayment(int meetingId, int memberId)
{
var repayment = (from r in SessionProxy.Query <LoanRepayment>()
where r.Meeting.MeetingId == meetingId && r.Member.MemberId == memberId
select r).FirstOrDefault();
return(repayment);
}
public List <LoanRepayment> FindMeetingLoanRepayments(int meetingId)
{
var loanRepayments = (from m in SessionProxy.Query <LoanRepayment>()
where m.Meeting.MeetingId == meetingId
select m).ToList();
return(loanRepayments);
}
public LoanRepayment FindLoanRepaymentByIdEx(int meetingId, int repaymentIdEx)
{
var loanRepayment = (from m in SessionProxy.Query <LoanRepayment>()
where m.RepaymentIdEx == repaymentIdEx && m.Meeting.MeetingId == meetingId
select m).FirstOrDefault();
return(loanRepayment);
}
public Vsla FindVslaById(int vslaId)
{
var vsla = (from v in SessionProxy.Query <Vsla>()
where v.VslaId == vslaId
select v).FirstOrDefault();
return(vsla);
}
// Find vsla by name
public List <Vsla> FindVslaByName(string vslaName)
{
var vsla = (from v in SessionProxy.Query <Vsla>()
where v.VslaName.Contains(vslaName.ToLower())
select v).ToList();
return(vsla);
}
// Find user by Id
public Users findUserById(int id)
{
var userx = (from u in SessionProxy.Query <Users>()
where u.Id == id
select u).FirstOrDefault();
return(userx);
}
// Total members absent
public long totalMembersAbsent()
{
var absent = (from a in SessionProxy.Query <Attendance>()
where a.IsPresent == false
select a).Count();
return(absent);
}
// /find the total number of members attached to a particular group
public int totalGroupMembers(int vslaId)
{
int total = (from m in SessionProxy.Query <Member>()
where m.Vsla.VslaId == vslaId
select m).Count();
return(total);
}
// Find all members attached to a given VSLA
public List <Member> findAllMembersByVslaId(int vslaId)
{
var members = (from m in SessionProxy.Query <Member>()
where m.Vsla.VslaId == vslaId
select m).ToList();
return(members);
}
// Count the number of female members
public long countFemaleMembers()
{
var femaleMembers = (from m in SessionProxy.Query <Member>()
where m.Gender == "Female"
select m).Count();
return(femaleMembers);
}
//Find a Member by the Id as is on the Phone
public Member FindMemberByIdEx(int vslaId, int memberIdEx)
{
var member = (from m in SessionProxy.Query <Member>()
where m.MemberIdEx == memberIdEx && m.Vsla.VslaId == vslaId
select m).FirstOrDefault();
return(member);
}
public Member FindMemberById(int memberId)
{
var member = (from m in SessionProxy.Query <Member>()
where m.MemberId == memberId
select m).FirstOrDefault();
return(member);
}
public SessionInfo[] GetActiveSessions(SessionCriteria criteria)
{
using (var proxy = new SessionProxy())
{
if (criteria == null)
{
return proxy.GetActiveSessions();
}
return proxy.GetActiveSessions(criteria.UserName, criteria.IPAddress, criteria.HostName,
criteria.LoginTimeFrom, criteria.LoginTimeTill, criteria.LastActivityTimeFrom, criteria.LastActivityTimeTill);
}
}
public void Test()
{
var proxy = new SessionProxy(BaseAddress);
var session = proxy.Get(Token, AppId).Result;
Assert.AreEqual(UserId, session.UserId);
Assert.AreEqual(AppSettings, session.Settings);
var ping = proxy.Ping(Token).Result;
Assert.IsTrue(ping.Ok);
proxy.Reset(Token).Wait();
ping = proxy.Ping(Token).Result;
Assert.IsFalse(ping.Ok);
}
/// <summary>
/// Open it and close itself.
/// </summary>
/// <returns></returns>
public SessionWrapper CreateNewWrapper()
{
SessionProxy session = null;
bool openInthisContxt = true;
if (!CurrentSessionContext.HasBind(SessionFactory))
{
session = new SessionProxy(SessionFactory.OpenSession());
}
else
{
var parent = (SessionProxy)CurrentSessionContext.Unbind(SessionFactory);
session = new SessionProxy(SessionFactory.OpenSession(), parent);
openInthisContxt = false;
}
CurrentSessionContext.Bind(session);
return new SessionWrapper(SessionFactory, openInthisContxt);
}
/// <summary>
/// Open it and close itself. It do not bind in ths SessionContext;
/// </summary>
/// <returns></returns>
public SessionWrapper CreateIndependentSession()
{
var session = new SessionProxy(SessionFactory.OpenSession());
return new SessionWrapper(session);
}
