// 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);
}
public List <VslaRegion> findAllRegions()
{
var allRegions = (from r in SessionProxy.Query <VslaRegion>()
select r).ToList();
return(allRegions);
}
// Total loans
public double findTotalLoans()
{
var loans = (from m in SessionProxy.Query <Meeting>()
select m).Sum(x => (double)x.SumOfLoanIssues);
return(loans);
}
public List <UserPermissions> allUserPermissions()
{
var permissions = (from p in SessionProxy.Query <UserPermissions>()
select p).ToList();
return(permissions);
}
public List <GroupSupport> findAllGroupSupport()
{
var groupSupport = (from gs in SessionProxy.Query <GroupSupport>()
select gs).ToList();
return(groupSupport);
}
// Get all registered system users
public List <Users> findAllUsers()
{
var users = (from u in SessionProxy.Query <Users>()
select u).ToList();
return(users);
}
// All Technical Trainers
public List <TechnicalTrainer> findAllTechnicalTrainers()
{
var trainers = (from t in SessionProxy.Query <TechnicalTrainer>()
select t).ToList();
return(trainers);
}
// Get all Vslas
public List <Vsla> findAllVslas()
{
var vslas = (from v in SessionProxy.Query <Vsla>()
select v).ToList();
return(vslas);
}
// Total Savings
public double findTotalSavings()
{
var savings = (from m in SessionProxy.Query <Meeting>()
select m).Sum(x => (double)x.SumOfSavings);
return(savings);
}
// Count the number of VSLAs
public long countVslas()
{
var vslas = (from v in SessionProxy.Query <Vsla>()
select v).Count();
return(vslas);
}
// 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);
}
public Vsla FindVslaById(int vslaId)
{
var vsla = (from v in SessionProxy.Query <Vsla>()
where v.VslaId == vslaId
select v).FirstOrDefault();
return(vsla);
}
public Vsla FindVslaByCode(string vslaCode)
{
var vsla = (from v in SessionProxy.Query <Vsla>()
where v.VslaCode.ToUpper() == vslaCode.ToUpper()
select v).FirstOrDefault();
return(vsla);
}
public List <Attendance> FindMeetingAttendances(int meetingId)
{
var attendances = (from m in SessionProxy.Query <Attendance>()
where m.Meeting.MeetingId == meetingId
select m).ToList();
return(attendances);
}
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);
}
// 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);
}
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);
}
// 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(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 Member FindMemberById(int memberId)
{
var member = (from m in SessionProxy.Query <Member>()
where m.MemberId == memberId
select m).FirstOrDefault();
return(member);
}
// /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 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);
}
// Total members absent
public long totalMembersAbsent()
{
var absent = (from a in SessionProxy.Query <Attendance>()
where a.IsPresent == false
select a).Count();
return(absent);
}
// 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);
}
// 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);
}
// 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);
}
public Attendance FindAttendanceByIdEx(int meetingId, int attendanceIdEx)
{
var attendance = (from m in SessionProxy.Query <Attendance>()
where m.AttendanceIdEx == attendanceIdEx && m.Meeting.MeetingId == meetingId
select m).FirstOrDefault();
return(attendance);
}