private void btn_DeactiveMember_Click(object sender, RoutedEventArgs e)
{
try
{
object item = DataGrid_Members.SelectedItem;
this.UserId = 0;
if (item != null)
{
this.UserId = Convert.ToInt32((DataGrid_Members.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text);
string UserFullName = (DataGrid_Members.SelectedCells[1].Column.GetCellContent(item) as TextBlock).Text;
if (!string.IsNullOrEmpty(UserFullName))
{
if (MessageBox.Show("Are you sure ? ", "Disable", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
db.disableUserMember(this.UserId, 0);
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n + " + ex.ToString());
}
finally
{
this.StatusSearch = 1; //Normal Search
LoadMembersData(GenerateSearchKey);
LoadExpireMembers();
}
}
private void LoadExpireMembers()
{
try
{
this.CountExpiredDate = 0;
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
var queryLoadMembers = db.Database.SqlQuery <VW_members>("select * From VW_members where users_Status=1");
var resultLoadMembers = queryLoadMembers.ToList();
if (resultLoadMembers.Count > 0)
{
for (int i = 0; i < resultLoadMembers.Count; i++)
{
this.CountExpiredDate += ExpiredDate(resultLoadMembers[i].usersInfoFitness_EndDate,
String.Format("{0:yyyy-MM-dd}", DateTime.Now));
}
txt_ExpiredAccounts.Text = Convert.ToString(this.CountExpiredDate);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n " + ex.ToString());
}
}
private bool CheckAuth(string userName, string password)
{
try
{
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
// linq query
var querySelectUser = from varUser in db.vw_AuthUsers
where varUser.user_Auth_UserName == userName
where varUser.user_Auth_Password == password
where varUser.user_Auth_Status == 1
select varUser;
var resultSelectUser = querySelectUser.ToList();
if (resultSelectUser.Count == 1)
{
return(true);
}
else
{
MessageBox.Show("User Not Found !");
return(false);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n " + ex.ToString());
}
return(false);
}
public static List <CustomerEntity> GetCustomers()
{
List <CustomerEntity> customers = new List <Entity.CustomerEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
CustomerEntity customerEntity;
var customerList = dbe.customers.ToList();
foreach (var customer in customerList)
{
customerEntity = new Entity.CustomerEntity();
customerEntity.customer_id = customer.customer_id;
customerEntity.customer_fullname = customer.customer_fullname;
customerEntity.customer_address = customer.customer_address;
customerEntity.customer_phone = customer.customer_phone;
customerEntity.customer_photo = customer.customer_photo;
customerEntity.customer_gender = customer.customer_gender;
customerEntity.customer_joindate = customer.customer_joindate;
customerEntity.trainer_name = customer.trainer_id;
customerEntity.plan_name = customer.plan_id;
customerEntity.customer_username = customer.customer_username;
customerEntity.customer_password = customer.customer_password;
customers.Add(customerEntity);
}
}
return(customers);
}
public static void DelAdmin(string Id)
{
using (fitnessEntities dbe = new fitnessEntities())
{
admin admin = dbe.admins.Where(o => o.admin_id.Equals(Id)).SingleOrDefault();
dbe.admins.Remove(admin);
dbe.SaveChanges();
}
}
public static void DelCustomer(string Id)
{
using (fitnessEntities dbe = new fitnessEntities())
{
customer customer = dbe.customers.Where(o => o.customer_id.Equals(Id)).SingleOrDefault();
dbe.customers.Remove(customer);
dbe.SaveChanges();
}
}
public static void DelEquipment(string Id)
{
using (fitnessEntities dbe = new fitnessEntities())
{
equipment equipment = dbe.equipments.Where(o => o.equipment_id.Equals(Id)).SingleOrDefault();
dbe.equipments.Remove(equipment);
dbe.SaveChanges();
}
}
private void btn_Edit_Click(object sender, RoutedEventArgs e)
{
try
{
object item = DataGrid_Members.SelectedItem;
this.UserId = 0;
if (item != null)
{
this.UserId = Convert.ToInt32((DataGrid_Members.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text);
string UserFullName = (DataGrid_Members.SelectedCells[1].Column.GetCellContent(item) as TextBlock).Text;
if (!string.IsNullOrEmpty(UserFullName))
{
if (MessageBox.Show("Are you sure ? ", "Edit", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
var querySelectMember = db.Database.SqlQuery <VW_members>("select * From VW_members where PK_users_Id=" + this.UserId);
var resultSelectMember = querySelectMember.ToList();
if (resultSelectMember.Count == 1)
{
txt_ShowFirstName.Text = resultSelectMember[0].users_FirstName;
txt_ShowLastName.Text = resultSelectMember[0].users_LastName;
txt_phoneNumber.Text = resultSelectMember[0].users_PhoneNumber;
txt_address.Text = resultSelectMember[0].users_Address;
date_Start.Text = resultSelectMember[0].usersInfoFitness_StartDate;
date_End.Text = resultSelectMember[0].usersInfoFitness_EndDate;
txt_Age.Text = Convert.ToString(resultSelectMember[0].usersInfoFitness_Age);
txt_Height.Text = Convert.ToString(resultSelectMember[0].usersInfoFitness_Height);
txt_Weight.Text = Convert.ToString(resultSelectMember[0].usersInfoFitness_Weight);
txt_waistMeasure.Text = Convert.ToString(resultSelectMember[0].usersInfoFitness_WaistMeasure);
txt_MonthlyAmount.Text = Convert.ToString(resultSelectMember[0].usersInfoFitness_MonthlyAmount);
txt_Description.Text = resultSelectMember[0].users_Description;
Btn_New.Content = "Update";
cmb_exerciesLevel.SelectedIndex = Convert.ToInt32(resultSelectMember[0].usersInfoFitness_exerciesLevel);
this.btnAddOrUpdate = 2;//For Update Btn //Change Action btn_new for update
}
else
{
MessageBox.Show("There is more than one member in the system !");
return;
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n + " + ex.ToString());
}
finally
{
this.StatusSearch = 1; //Normal Search
LoadMembersData(GenerateSearchKey);
LoadExpireMembers();
}
}
public ActionResult ShowData()
{
List <plan> plans = new List <plan>();
using (fitnessEntities dbe = new fitnessEntities())
{
plans = dbe.plans.ToList();
}
return(View(plans));
}
public ActionResult ShowData()
{
List <admin> admins = new List <admin>();
using (fitnessEntities dbe = new fitnessEntities())
{
admins = dbe.admins.ToList();
}
return(View(admins));
}
public ActionResult ShowData()
{
List <equipment> equipments = new List <equipment>();
using (fitnessEntities dbe = new fitnessEntities())
{
equipments = dbe.equipments.ToList();
}
return(View(equipments));
}
public ActionResult ShowData()
{
List <trainer> trainers = new List <trainer>();
using (fitnessEntities dbe = new fitnessEntities())
{
trainers = dbe.trainers.ToList();
}
return(View(trainers));
}
public ActionResult ShowData()
{
List <customer> customers = new List <customer>();
using (fitnessEntities dbe = new fitnessEntities())
{
customers = dbe.customers.ToList();
}
return(View(customers));
}
private void btn_Delete_Click(object sender, RoutedEventArgs e)
{
try
{
object item = DataGrid_Members.SelectedItem;
this.UserId = 0;
if (item != null)
{
this.UserId = Convert.ToInt32((DataGrid_Members.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text);
string UserFullName = (DataGrid_Members.SelectedCells[1].Column.GetCellContent(item) as TextBlock).Text;
if (!string.IsNullOrEmpty(UserFullName))
{
if (MessageBox.Show("Are you sure ? ", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
//todo Delete member with Query
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
using (TransactionScope ts = new TransactionScope())
{
var querySelectAuthUser = db.Database.SqlQuery <vw_AuthUsers>("select * From vw_AuthUsers where PK_users_Id=" + this.UserId + " and FK_user_Auth_role_Id=1");
var resultSelectAuthUser = querySelectAuthUser.ToList();
if (resultSelectAuthUser.Count == 1)
{
MessageBox.Show("You can not delete this user, this user is the system admin !");
return;
}
else
{
db.DeleteFromMemberInfo(UserId);
db.DeleteFromUsers(UserId);
db.SaveChanges();
}
ts.Complete();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n " + ex.ToString());
}
finally
{
this.StatusSearch = 1; //Normal Search
//Reload Data
LoadMembersData(GenerateSearchKey);
LoadExpireMembers();
}
}
public static AdminEntity DetailAdmin(string Id)
{
AdminEntity adminEntity = new Entity.AdminEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
admin admin = dbe.admins.Where(o => o.admin_id.Equals(Id)).SingleOrDefault();
adminEntity.admin_id = admin.admin_id;
adminEntity.admin_fullname = admin.admin_fullname;
adminEntity.admin_username = admin.admin_username;
adminEntity.admin_password = admin.admin_password;
}
return(adminEntity);
}
public static PlanEntity Detailplan(string Id)
{
PlanEntity planEntity = new Entity.PlanEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
plan plan = dbe.plans.Where(o => o.plan_id.Equals(Id)).SingleOrDefault();
planEntity.plan_id = plan.plan_id;
planEntity.plan_name = plan.plan_name;
planEntity.plan_cost = plan.plan_cost;
planEntity.plan_period = plan.plan_period;
}
return(planEntity);
}
public static TrainerEntity DetailTrainer(string Id)
{
TrainerEntity trainerEntity = new Entity.TrainerEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
trainer trainer = dbe.trainers.Where(o => o.trainer_id.Equals(Id)).SingleOrDefault();
trainerEntity.trainer_id = trainer.trainer_id;
trainerEntity.trainer_name = trainer.trainer_name;
trainerEntity.trainer_contact = trainer.trainer_contact;
trainerEntity.trainer_address = trainer.trainer_address;
trainerEntity.trainer_photo = trainer.trainer_photo;
}
return(trainerEntity);
}
public static EquipmentEntity DetailEquipment(string Id)
{
EquipmentEntity equipmentEntity = new Entity.EquipmentEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
equipment equipment = dbe.equipments.Where(o => o.equipment_id.Equals(Id)).SingleOrDefault();
equipmentEntity.equipment_id = equipment.equipment_id;
equipmentEntity.equipment_name = equipment.equipment_name;
equipmentEntity.equipment_quantity = equipment.equipment_quantity;
equipmentEntity.equipment_cost = equipment.equipment_cost;
equipmentEntity.equipment_photo = equipment.equipment_photo;
}
return(equipmentEntity);
}
public static bool DelTrainer(string Id)
{
using (fitnessEntities dbe = new fitnessEntities())
{
var cst = dbe.customers.Where(o => o.trainer_id == Id).ToList();
if (cst.Count == 0)
{
trainer trainer = dbe.trainers.Where(o => o.trainer_id.Equals(Id)).SingleOrDefault();
dbe.trainers.Remove(trainer);
dbe.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public static CustomerEntity DetailCustomer(string Id)
{
CustomerEntity customerEntity = new Entity.CustomerEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
customer customer = dbe.customers.Where(o => o.customer_id.Equals(Id)).SingleOrDefault();
customerEntity.customer_id = customer.customer_id;
customerEntity.customer_fullname = customer.customer_fullname;
customerEntity.customer_address = customer.customer_address;
customerEntity.customer_phone = customer.customer_phone;
customerEntity.customer_photo = customer.customer_photo;
customerEntity.customer_gender = customer.customer_gender;
customerEntity.customer_joindate = customer.customer_joindate;
customerEntity.trainer_id = customer.trainer_id;
customerEntity.plan_id = customer.plan_id;
customerEntity.customer_username = customer.customer_username;
customerEntity.customer_password = customer.customer_password;
}
return(customerEntity);
}
public static List <PlanEntity> Getplans()
{
List <PlanEntity> plans = new List <Entity.PlanEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
PlanEntity planEntity;
var planList = dbe.plans.ToList();
foreach (var plan in planList)
{
planEntity = new Entity.PlanEntity();
planEntity.plan_id = plan.plan_id;
planEntity.plan_name = plan.plan_name;
planEntity.plan_cost = plan.plan_cost;
planEntity.plan_period = plan.plan_period;
plans.Add(planEntity);
}
}
return(plans);
}
public static List <AdminEntity> GetAdmins()
{
List <AdminEntity> admins = new List <Entity.AdminEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
AdminEntity adminEntity;
var adminList = dbe.admins.ToList();
foreach (var admin in adminList)
{
adminEntity = new Entity.AdminEntity();
adminEntity.admin_id = admin.admin_id;
adminEntity.admin_fullname = admin.admin_fullname;
adminEntity.admin_username = admin.admin_username;
adminEntity.admin_password = admin.admin_password;
admins.Add(adminEntity);
}
}
return(admins);
}
private void LoadMembersData(Func <string> FuncGenerate)
{
try
{
decimal TotalAmount = 0;
DataGrid_Members.ItemsSource = null;
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
var queryLoadMembers = db.Database.SqlQuery <VW_members>("select * From VW_members where users_Status=1 " + FuncGenerate() + " ORDER BY usersInfoFitness_StartDate DESC");
var resultLoadMembers = queryLoadMembers.ToList();
if (resultLoadMembers.Count > 0)
{
for (int i = 0; i < resultLoadMembers.Count; i++)
{
//this.CountExpiredDate += ExpiredDate(resultLoadMembers[i].usersInfoFitness_EndDate,
// String.Format("{0:yyyy-MM-dd}", DateTime.Now));
TotalAmount += Convert.ToDecimal(resultLoadMembers[i].usersInfoFitness_MonthlyAmount);
}
DataGrid_Members.ItemsSource = resultLoadMembers;
txt_Total_MontlyAmount.Text = string.Format(new System.Globalization.CultureInfo("ar-IQ"),
"{0:C0}",
TotalAmount);
}
else
{
DataGrid_Members.ItemsSource = null;
txt_Total_MontlyAmount.Text = string.Format(new System.Globalization.CultureInfo("ar-IQ"),
"{0:C0}",
0);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n " + ex.ToString());
}
}
public static List <TrainerEntity> GetTrainers()
{
List <TrainerEntity> trainers = new List <Entity.TrainerEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
TrainerEntity trainerEntity;
var trainerList = dbe.trainers.ToList();
foreach (var trainer in trainerList)
{
trainerEntity = new Entity.TrainerEntity();
trainerEntity.trainer_id = trainer.trainer_id;
trainerEntity.trainer_name = trainer.trainer_name;
trainerEntity.trainer_contact = trainer.trainer_contact;
trainerEntity.trainer_address = trainer.trainer_address;
trainerEntity.trainer_photo = trainer.trainer_photo;
trainers.Add(trainerEntity);
}
}
return(trainers);
}
public static List <EquipmentEntity> GetEquipments()
{
List <EquipmentEntity> equipments = new List <Entity.EquipmentEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
EquipmentEntity equipmentEntity;
var equipmentList = dbe.equipments.ToList();
foreach (var equipment in equipmentList)
{
equipmentEntity = new Entity.EquipmentEntity();
equipmentEntity.equipment_id = equipment.equipment_id;
equipmentEntity.equipment_name = equipment.equipment_name;
equipmentEntity.equipment_quantity = equipment.equipment_quantity;
equipmentEntity.equipment_cost = equipment.equipment_cost;
equipmentEntity.equipment_photo = equipment.equipment_photo;
equipments.Add(equipmentEntity);
}
}
return(equipments);
}
private void Btn_New_Click(object sender, RoutedEventArgs e)
{
try
{
if (!checkNullable())
{
return;
}
else
{
if (this.btnAddOrUpdate == 1) // For New
{
//todo add new member with query
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
using (TransactionScope ts = new TransactionScope())
{
var querySelectMember = db.Database.SqlQuery <VW_members>("select * From VW_members where FullName =N'" + txt_ShowFirstName.Text.Trim() + ' ' + txt_ShowLastName.Text.Trim() + "'");
var resultSelectMember = querySelectMember.ToList();
if (resultSelectMember.Count == 1)
{
MessageBox.Show("User Exist ! ");
return;
}
else
{
//Save Members info Part 1
db.addMember(
txt_ShowFirstName.Text.Trim(),
txt_ShowLastName.Text.Trim(),
txt_phoneNumber.Text.Trim(),
txt_address.Text.Trim(),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToString("hh:mm:ss"))),
1,
txt_Description.Text.Trim()
);
db.SaveChanges();
//select Id New Member
var querySelectMemberId = db.Database.SqlQuery <User>("select * From Users where users_FirstName Like N'%" + txt_ShowFirstName.Text.Trim() + "%' and users_LastName Like N'%" + txt_ShowLastName.Text.Trim() + "%'");
var resultSelectMemberId = querySelectMemberId.ToList();
if (resultSelectMemberId.Count == 0)
{
MessageBox.Show("Transaction Canceled !");
return;
}
//Save Members info Part 2
db.AddmemberInfo(resultSelectMemberId[0].PK_users_Id,
Convert.ToDouble(txt_Height.Text.Trim()),
Convert.ToDouble(txt_Weight.Text.Trim()),
Convert.ToDouble(txt_waistMeasure.Text.Trim()),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(date_Start.Text)) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToLongTimeString())),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(date_End.Text)) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToLongTimeString())),
"",
Convert.ToInt32(txt_Age.Text.Trim()),
Convert.ToDecimal(txt_MonthlyAmount.Text.Trim()),
Convert.ToDouble(this.BMRResult),
Convert.ToDouble(this.BMIResult),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToString("hh:mm:ss"))),
cmb_exerciesLevel.SelectedIndex,
cmb_exerciesLevel.Text
);
db.SaveChanges();
MessageBox.Show("Save Successed !");
}
ClearData();
ts.Complete();
}
}
}
else if (this.btnAddOrUpdate == 2) // For update
{
//todo update member with query
if (this.UserId > 0) //Select Member
{
using (fitnessEntities db = new fitnessEntities(dbConnection.ConnectionString))
{
using (TransactionScope ts = new TransactionScope())
{
db.updateMember(
this.UserId, txt_ShowFirstName.Text.Trim(), txt_ShowLastName.Text.Trim(), txt_phoneNumber.Text.Trim(), txt_address.Text.Trim(), 1, txt_Description.Text
);
db.SaveChanges();
db.updateMemberInfo(
this.UserId,
Convert.ToDouble(txt_Height.Text.Trim()),
Convert.ToDouble(txt_Weight.Text.Trim()),
Convert.ToDouble(txt_waistMeasure.Text.Trim()),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(date_Start.Text)) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToLongTimeString())),
String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(date_End.Text)) +
' ' +
String.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.ToLongTimeString())),
"", Convert.ToInt32(txt_Age.Text.Trim()),
Convert.ToDecimal(txt_MonthlyAmount.Text.Trim()),
this.BMRResult,
this.BMIResult,
cmb_exerciesLevel.SelectedIndex,
cmb_exerciesLevel.Text
);
db.SaveChanges();
MessageBox.Show("Update Success !");
this.btnAddOrUpdate = 1;
Btn_New.Content = "New";
ClearData();
ts.Complete();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : \n\n\n " + ex.ToString());
}
finally
{
LoadMembersData(GenerateSearchKey);
LoadExpireMembers();
}
}
