public static void EditPlan(PlanEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
plan plan = dbe.plans.Find(detail.plan_id);
plan.plan_name = detail.plan_name;
plan.plan_cost = detail.plan_cost;
plan.plan_period = detail.plan_period;
dbe.Entry(plan).State = System.Data.Entity.EntityState.Modified;
dbe.SaveChanges();
}
}
public static void SaveAdmin(AdminEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
admin admin = new DAL.admin();
admin.admin_id = detail.admin_id;
admin.admin_fullname = detail.admin_fullname;
admin.admin_username = detail.admin_username;
admin.admin_password = detail.admin_password;
dbe.admins.Add(admin);
dbe.SaveChanges();
}
}
public static void EditAdmin(AdminEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
admin admin = dbe.admins.Find(detail.admin_id);
admin.admin_fullname = detail.admin_fullname;
admin.admin_username = detail.admin_username;
admin.admin_password = detail.admin_password;
dbe.Entry(admin).State = System.Data.Entity.EntityState.Modified;
dbe.SaveChanges();
}
}
public static void Saveplan(PlanEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
plan plan = new DAL.plan();
plan.plan_id = detail.plan_id;
plan.plan_name = detail.plan_name;
plan.plan_cost = detail.plan_cost;
plan.plan_period = detail.plan_period;
dbe.plans.Add(plan);
dbe.SaveChanges();
}
}
public static void SaveTrainer(TrainerEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
trainer trainer = new DAL.trainer();
trainer.trainer_id = detail.trainer_id;
trainer.trainer_name = detail.trainer_name;
trainer.trainer_contact = detail.trainer_contact;
trainer.trainer_address = detail.trainer_address;
trainer.trainer_photo = detail.trainer_photo;
dbe.trainers.Add(trainer);
dbe.SaveChanges();
}
}
public static void EditTrainer(TrainerEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
trainer trainer = dbe.trainers.Find(detail.trainer_id);
trainer.trainer_name = detail.trainer_name;
trainer.trainer_contact = detail.trainer_contact;
trainer.trainer_address = detail.trainer_address;
// trainer.trainer_photo = detail.trainer_photo;
// dbe.Entry(trainer).State = System.Data.Entity.EntityState.Modified;
dbe.SaveChanges();
}
}
public static void SaveEquipment(EquipmentEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
equipment equipment = new DAL.equipment();
equipment.equipment_id = detail.equipment_id;
equipment.equipment_name = detail.equipment_name;
equipment.equipment_quantity = detail.equipment_quantity;
equipment.equipment_cost = detail.equipment_cost;
equipment.equipment_photo = detail.equipment_photo;
dbe.equipments.Add(equipment);
dbe.SaveChanges();
}
}
public static void EditEquipment(EquipmentEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
equipment equipment = dbe.equipments.Find(detail.equipment_id);
equipment.equipment_name = detail.equipment_name;
equipment.equipment_quantity = detail.equipment_quantity;
equipment.equipment_cost = detail.equipment_cost;
// equipment.equipment_photo = detail.equipment_photo;
// dbe.Entry(equipment).State = System.Data.Entity.EntityState.Modified;
dbe.SaveChanges();
}
}
public static MemberEntity ValidateCustomerMember(MemberEntity member)
{
MemberEntity detail = new MemberEntity();
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
customer customer = dbe.customers.Where(m => m.customer_username == member.customer_username && m.customer_password == member.customer_password).FirstOrDefault();
if (customer != null)
{
detail.customer_id = customer.customer_id;
detail.customer_username = customer.customer_username;
detail.customer_fullname = customer.customer_fullname;
detail.Type = "user";
detail.Roles = "Admin,User";
return(detail);
}
}
return(detail);
}
public static UserEntity ValidateMemberUser(UserEntity user)
{
UserEntity detail = new UserEntity();
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
customer custom = dbe.customers.Where(u => u.customer_username == user.username && u.customer_password == user.password).FirstOrDefault();
if (custom != null)
{
detail.id = custom.customer_id;
detail.username = custom.customer_username;
detail.fullname = custom.customer_fullname;
detail.Type = "member";
detail.Roles = "Member";
return(detail);
}
}
return(detail);
}
public static UserEntity ValidateAdminUser(UserEntity user)
{
UserEntity detail = new UserEntity();
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
admin admin = dbe.admins.Where(u => u.admin_username == user.username && u.admin_password == user.password).FirstOrDefault();
if (admin != null)
{
detail.id = admin.admin_id;
detail.username = admin.admin_username;
detail.fullname = admin.admin_fullname;
detail.Type = "admin";
detail.Roles = "Admin,Member";
return(detail);
}
}
return(detail);
}
public static void EditCustomer(CustomerEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
customer customer = dbe.customers.Find(detail.customer_id);
customer.customer_fullname = detail.customer_fullname;
customer.customer_address = detail.customer_address;
customer.customer_phone = detail.customer_phone;
customer.customer_photo = detail.customer_photo;
customer.customer_gender = detail.customer_gender;
customer.customer_joindate = detail.customer_joindate;
customer.trainer_id = detail.trainer_id;
customer.plan_id = detail.plan_id;
customer.customer_username = detail.customer_username;
customer.customer_password = detail.customer_password;
dbe.Entry(customer).State = System.Data.Entity.EntityState.Modified;
dbe.SaveChanges();
}
}
public static void SaveCustomer(CustomerEntity detail)
{
using (fitnessEntities dbe = new DAL.fitnessEntities())
{
customer customer = new DAL.customer();
customer.customer_id = detail.customer_id;
customer.customer_fullname = detail.customer_fullname;
customer.customer_address = detail.customer_address;
customer.customer_phone = detail.customer_phone;
customer.customer_photo = detail.customer_photo;
customer.customer_gender = detail.customer_gender;
customer.customer_joindate = detail.customer_joindate;
customer.trainer_id = detail.trainer_id;
customer.plan_id = detail.plan_id;
customer.customer_username = detail.customer_username;
customer.customer_password = detail.customer_password;
dbe.customers.Add(customer);
dbe.SaveChanges();
}
}
