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(); } }