public static int update(member member)
{
int result = 0;
using (var db = new ExtremeAppContext())
{
var existingMember = (from m in db.members
where m.member_id == member.member_id
select m).First();
existingMember.first_name = member.first_name;
existingMember.last_name = member.last_name;
existingMember.sex = member.sex;
existingMember.birth_date = member.birth_date;
existingMember.address = member.address;
existingMember.phone_number = member.phone_number;
existingMember.email = member.email;
existingMember.registration_date = member.registration_date;
existingMember.last_modified = DateTime.Now;
existingMember.profile_picture = member.profile_picture;
existingMember.active = member.active;
existingMember.membership_type_id = member.membership_type_id;
result = db.SaveChanges();
}
return(result);
}
public static List <MemberFeeDTO> getMembershipFeePaymentsInDateRange(DateTime dateFrom,
DateTime dateTo)
{
dateTo = dateTo.AddDays(1);
Console.WriteLine(dateTo);
using (var db = new ExtremeAppContext())
{
var membersAttendances =
(from m in db.membeship_fee_payment
where m.payment_date >= dateFrom.Date
where m.payment_date <= dateTo.Date
select new MemberFeeDTO
{
member_id = m.member_id,
first_name = m.member.first_name,
last_name = m.member.last_name,
month = m.month,
payingDate = m.payment_date,
issuer_user_name = m.user_account.username,
price = m.price,
category = m.member.membership_type.name,
}
).ToList();
return(membersAttendances);
}
}
public static List <gear_detailed> getAllDetailed()
{
using (var db = new ExtremeAppContext())
{
var gear =
(from g in db.gears
join gc in db.gear_category on g.gear_category_id equals gc.gear_category_id
join m in db.manufacturers on g.manufacturer_id equals m.manufacturer_id
join gsi in db.gear_size_items on g.gear_id equals gsi.gear_id
join gs in db.gear_size on gsi.gear_size_id equals gs.gear_size_id
select new gear_detailed()
{
gear_id = g.gear_id,
name = g.name,
gear_category_id = g.gear_category_id,
gear_category_name = gc.name,
manufacturer_id = g.manufacturer_id,
manufacturer_name = m.name,
description = g.descritption,
size_id = gs.gear_size_id,
size_value = gs.value,
quantity = gsi.quantity,
available = gsi.available
}).ToList();
return(gear);
}
}
public static List <MemberAttendanceSummaryDTO> getMembersAttendanceSummaryInDateRange(DateTime dateFrom,
DateTime dateTo)
{
dateTo = dateTo.AddDays(1);
Console.WriteLine(dateTo);
using (var db = new ExtremeAppContext())
{
var membersAttendancesSummary =
(from a in db.attendances
join m in db.members
on a.member_id equals m.member_id
where a.check_in_time >= dateFrom.Date
where a.check_in_time <= dateTo.Date
group a by new
{
member_id = a.member_id,
first_name = m.first_name,
last_name = m.last_name
}
into g
select new MemberAttendanceSummaryDTO
{
member_id = g.Key.member_id,
first_name = g.Key.first_name,
last_name = g.Key.last_name,
number_of_attendances = g.Count()
}).ToList();
return(membersAttendancesSummary);
}
}
public static List <gear_size> getAllSizes()
{
using (var db = new ExtremeAppContext())
{
var gearSizes = (from gs in db.gear_size select gs).ToList();
return(gearSizes);
}
}
public static List <manufacturer> getAllManufacturers()
{
using (var db = new ExtremeAppContext())
{
var manufacturers = (from m in db.manufacturers select m).ToList();
return(manufacturers);
}
}
public static List <gear_category> getAllCategories()
{
using (var db = new ExtremeAppContext())
{
var gearCategory = (from gc in db.gear_category select gc).ToList();
return(gearCategory);
}
}
public static int insertGearSizeItem(gear_size_items newGearSizeItem)
{
using (var db = new ExtremeAppContext())
{
db.gear_size_items.Add(newGearSizeItem);
db.SaveChanges();
}
return(newGearSizeItem.gear_id);
}
public static int insert(gear newGear)
{
using (var db = new ExtremeAppContext())
{
db.gears.Add(newGear);
db.SaveChanges();
}
return(newGear.gear_id);
}
public static Boolean insert(attendance newAttendance)
{
int retVal = 0;
using (var db = new ExtremeAppContext())
{
db.attendances.Add(newAttendance);
retVal = db.SaveChanges();
}
return(retVal > 0 ? true : false);
}
public static List <daily_ticket_type> getAllTypes()
{
using (var db = new ExtremeAppContext())
{
var allTypes =
(from at in db.daily_ticket_type
select at).ToList();
return(allTypes);
}
}
public static Boolean insert(daily_ticket newDailyTicket)
{
int result = 0;
using (var db = new ExtremeAppContext())
{
db.daily_ticket.Add(newDailyTicket);
result = db.SaveChanges();
}
return(result > 0 ? true : false);
}
public static int insert(member_education memberEducation)
{
int result = 0;
using (var db = new ExtremeAppContext())
{
db.member_education.Add(memberEducation);
result = db.SaveChanges();
}
return(result);
}
public static int insert(membership_card membership_card)
{
int result = 0;
using (var db = new ExtremeAppContext())
{
db.membership_card.Add(membership_card);
result = db.SaveChanges();
}
return(result);
}
public static List <gear_size_items> getAllSizesByGearId(int id)
{
using (var db = new ExtremeAppContext())
{
var sizes =
(from gsi in db.gear_size_items
where gsi.gear_id == id
select gsi).ToList();
return(sizes);
}
}
public static membership_type getById(int id)
{
using (var db = new ExtremeAppContext())
{
var membershipType =
(from e in db.membership_type where e.membership_type_id == id
select e).First();
return(membershipType);
}
}
public static int getLast()
{
using (var db = new ExtremeAppContext())
{
var lastMemberId =
(from m in db.members
select m.member_id).Max();
return(lastMemberId);
}
}
public static List <String> getAll()
{
using (var db = new ExtremeAppContext())
{
var allMembershipTypes =
(from e in db.membership_type
select e.name).ToList();
return(allMembershipTypes);
}
}
public static List <String> getAll()
{
using (var db = new ExtremeAppContext())
{
var allEducationLevels =
(from e in db.education_level
select e.name).ToList();
return(allEducationLevels);
}
}
public static int insert(membeship_fee_payment membershipFeePayment)
{
int result = 0;
using (var db = new ExtremeAppContext())
{
db.membeship_fee_payment.Add(membershipFeePayment);
result = db.SaveChanges();
}
return(result);
}
public static List <member> getAll()
{
using (var db = new ExtremeAppContext())
{
var allMembers =
(from m in db.members
select m).ToList();
return(allMembers);
}
}
public static List <member_education> getById(int id)
{
using (var db = new ExtremeAppContext())
{
var membershipEducation =
(from e in db.member_education where e.member_id == id
select e).ToList();
return(membershipEducation);
}
}
public static member getById(int id)
{
using (var db = new ExtremeAppContext())
{
var member =
(from m in db.members
where m.member_id == id
select m).First();
return(member);
}
}
public static String getById(int id)
{
using (var db = new ExtremeAppContext())
{
var name =
(from e in db.education_level
where e.education_level_id == id
select e.name).First();
return(name);
}
}
//revoke permissions for user
//User identification
public static user_account identifyUser(String username)
{
using (var db = new ExtremeAppContext())
{
var userAccount =
(from ua in db.user_account
where ua.username == username
select ua).SingleOrDefault();
return(userAccount);
}
}
public static String getBarcodeNumber(int memberId)
{
using (var db = new ExtremeAppContext())
{
var barcodeNumber =
(from m in db.membership_card
where m.member_id == memberId
select m.barcode_number).First();
return(barcodeNumber);
}
}
public static List <DateTime> getAllById(int id)
{
using (var db = new ExtremeAppContext())
{
var attendances =
(from a in db.attendances
where a.member_id == id
select a.check_in_time).ToList();
return(attendances);
}
}
//insert
public static Boolean insert(user_account newUser) //lower to invariant kod pravljenja za username
{
int retVal = 0;
//Check if user with same username already exists //DORADITI
using (var db = new ExtremeAppContext())
{
db.user_account.Add(newUser);
retVal = db.SaveChanges();
}
return(retVal > 0 ? true : false);
}
public static int getNumberOfPaidMembershipFees(int memberId)
{
using (var db = new ExtremeAppContext())
{
var attendances =
(from a in db.membeship_fee_payment
where a.member_id == memberId
orderby a.payment_date descending
select a).ToList();
return(attendances.Count());
}
}
public static Boolean isPaidFor(int memberId, int month, int year)
{
using (var db = new ExtremeAppContext())
{
var feePayment =
(from p in db.membeship_fee_payment
where p.member_id == memberId
where p.month == month
where p.year == year
select p).First();
return(feePayment.is_paid);
}
}
