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 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 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 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 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 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);
}
//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 Boolean updateGearSizeItem(gear_size_items gearSizeItemUpdated)
{
var result = false;
using (var db = new ExtremeAppContext())
{
var oldGearSizeItem =
(from gsi in db.gear_size_items
where gsi.gear_id == gearSizeItemUpdated.gear_id
where gsi.gear_size_id == gearSizeItemUpdated.gear_size_id
select gsi).SingleOrDefault();
if (oldGearSizeItem != null)
{
oldGearSizeItem.quantity = gearSizeItemUpdated.quantity;
oldGearSizeItem.available = gearSizeItemUpdated.quantity;
db.SaveChanges();
result = true;
}
}
return(result);
}
