public static void AddMember(Member MemberToAdd) { con.Open(); Library_Manager.Pages.Universal.Loading loading = new Pages.Universal.Loading(); loading.Show(); command = String.Format("INSERT INTO tblMembers (Name, Email, PhoneNumber, Password, SignDate, SubscriptionDate, ImageFileName, Balance) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}', '{6}', '{7}');", MemberToAdd.Name, MemberToAdd.Email, MemberToAdd.PhoneNumber, MemberToAdd.Password, Date.DateToDateTime(MemberToAdd.SignDate).ToString(), Date.DateToDateTime(MemberToAdd.ExtensionDate).ToString(), MemberToAdd.ImageFileName, 0); SqlCommand com = new SqlCommand(command, con); com.BeginExecuteNonQuery(); Thread.Sleep(2000); loading.Close(); con.Close(); }
private void PayButton_Click(object sender, RoutedEventArgs e) { var load = new Pages.Universal.Loading(); load.Activate(); load.Show(); if (isForAddMember) { if (DataBaseManager.isMemberExists(NewMember.Name, NewMember.Email, NewMember.PhoneNumber)) { if (isCardValid()) { DataBaseManager.AddMember(NewMember); DataBaseManager.AddBudget(amount); MemberPanel member = new MemberPanel(NewMember); member.Show(); MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } } } else { if (isForMember) { DataBaseManager.addMemberBalance(member.Name, amount); MessageBox.Show("Done !"); MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } else { DataBaseManager.AddBudget(amount); MessageBox.Show("Done !"); MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } } load.Close(); }
private void login_btn(object sender, RoutedEventArgs e) { var load = new Pages.Universal.Loading(); load.Activate(); load.Show(); DataTable empData = DataBaseManager.EmpList(); DataTable memData = DataBaseManager.MemberList(); string email = txtEmail.Text.ToLower(); string pass = txtPassword.Password; bool isMatch = false; if (email == "admin" && pass == "AdminLib123") { var admin = new AdminPanel(); admin.Show(); isMatch = true; MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } if (!isMatch) { for (int i = 0; i < empData.Rows.Count; i++) { if (empData.Rows[i][2].ToString().ToLower() == email && empData.Rows[i][4].ToString() == pass) { var emp = new EmployeePanel(new Employee(empData.Rows[i][1].ToString(), empData.Rows[i][2].ToString(), empData.Rows[i][3].ToString(), empData.Rows[i][4].ToString(), int.Parse(empData.Rows[i][5].ToString()), empData.Rows[i][6].ToString())); emp.Show(); isMatch = true; MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } } if (!isMatch) { for (int i = 0; i < memData.Rows.Count; i++) { if (memData.Rows[i][2].ToString().ToLower() == email && memData.Rows[i][4].ToString() == pass) { var emp = new MemberPanel(new Member(memData.Rows[i][1].ToString(), memData.Rows[i][2].ToString() , memData.Rows[i][3].ToString(), memData.Rows[i][4].ToString(), memData.Rows[i][6].ToString())); emp.Show(); isMatch = true; MainWindow main = Application.Current.MainWindow as MainWindow; if (main != null) { main.Close(); } } } } } if (!isMatch) { MessageBox.Show("This combination of email and password does not exist !!"); } load.Close(); }