public void LoadUserAccess(int id) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); userAccessList.Clear(); db = new ImusCityHallEntities(); var subModules = db.SubModules.OrderBy(m => m.Name).ToList(); foreach (var subModule in subModules) { bool selectedSubModule = false; if (db.SubModuleUsers.Any(m => m.EmployeeID == id && m.SubModuleID == subModule.SubModuleID)) { selectedSubModule = true; } UserAccessModel userAccess = new UserAccessModel() { Name = subModule.Name, Id = subModule.SubModuleID, IsSelected = selectedSubModule }; userAccessList.Add(userAccess); } moduleslb.ItemsSource = userAccessList; moduleslb.SelectedValuePath = "Id"; moduleslb.Items.Refresh(); Employee employee = db.Employees.Find(id); adminchk.IsChecked = employee.IsAdmin == true ? true : false; } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { if (newpasswordpb.Password != confirmpasswordpb.Password) { MessageBox.Show("Password mismatch!"); } else { Employee employee = db.Employees.Find(App.EmployeeID); AspNetUser asp = db.AspNetUsers.FirstOrDefault(m => m.UserName == employee.EmployeeNo); var passwordHasher = new Microsoft.AspNet.Identity.PasswordHasher(); asp.PasswordHash = passwordHasher.HashPassword(confirmpasswordpb.Password); db.SaveChanges(); MessageBox.Show("Password updated successfully!"); var audit = new AuditTrailModel { Activity = "User changes his/her password.", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); this.Close(); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void LoadQuestion() { if (SystemClass.CheckConnection()) { using (var db = new ImusCityHallEntities()) { //int total = db.SecurityQuestionBanks.Count(); //decimal toTakeD = (total / 3); //int toTake = (int)toTakeD; var ques = db.SecurityQuestionBanks.ToList(); cbSecurityQuestion1.ItemsSource = ques.OrderBy(m => Guid.NewGuid()).Take(7).ToList(); cbSecurityQuestion1.DisplayMemberPath = "Question"; cbSecurityQuestion1.SelectedValuePath = "SecurityQuestionID"; cbSecurityQuestion2.ItemsSource = ques.OrderBy(m => Guid.NewGuid()).Take(7).ToList(); cbSecurityQuestion2.DisplayMemberPath = "Question"; cbSecurityQuestion2.SelectedValuePath = "SecurityQuestionID"; cbSecurityQuestion3.ItemsSource = ques.OrderBy(m => Guid.NewGuid()).Take(7).ToList(); cbSecurityQuestion3.DisplayMemberPath = "Question"; cbSecurityQuestion3.SelectedValuePath = "SecurityQuestionID"; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void LoadInitialQuestion() { if (SystemClass.CheckConnection()) { try { using (var db = new ImusCityHallEntities()) { var getques = db.SecurityQuestionUsers.Where(m => m.EmployeeID == App.EmployeeID).OrderBy(m => Guid.NewGuid()).FirstOrDefault(); if (getques != null) { txtSecQues.Text = getques.SecurityQuestionBank.Question; QuestionID = getques.SecurityQuestionID; } else { MessageBox.Show("Question not available."); return; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { try { using (var db = new ImusCityHallEntities()) { if (!String.IsNullOrEmpty(txtAnswer.Text)) { var getanswer = db.SecurityQuestionUsers.Where(m => m.EmployeeID == App.EmployeeID && m.SecurityQuestionID == QuestionID).FirstOrDefault(); if (getanswer != null) { string inputAnswer = txtAnswer.Text; if (inputAnswer.TrimStart().Trim().TrimEnd().ToLower() == getanswer.Answer.TrimStart().Trim().TrimEnd().ToLower()) { ChangePasswordWindow cp = new ChangePasswordWindow(); cp.Show(); var audit = new AuditTrailModel { Activity = "User answer a security question for Forgot Password.", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); this.Close(); } else { MessageBox.Show("Incorrect answer."); return; } } else { MessageBox.Show("Question not available."); return; } } else { MessageBox.Show("Please input answer."); return; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { LoadEmployee(); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void employeecb_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (SystemClass.CheckConnection()) { int employeeId = (int)employeecb.SelectedValue; LoadUserAccess(employeeId); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { if (employeecb.SelectedValue == null) { MessageBox.Show("Please select/load an employee"); } else { ImusCityHallEntities db = new ImusCityHallEntities(); int employeeId = (int)employeecb.SelectedValue; foreach (var userAccess in userAccessList.Where(m => m.IsSelected == true)) { if (db.SubModuleUsers.Any(m => m.EmployeeID == employeeId && m.SubModuleID == userAccess.Id)) { } else { SubModuleUser userSubModule = new SubModuleUser(); userSubModule.EmployeeID = employeeId; userSubModule.SubModuleID = userAccess.Id; db.SubModuleUsers.Add(userSubModule); db.SaveChanges(); } } foreach (var userAccess in userAccessList.Where(m => m.IsSelected == false)) { if (db.SubModuleUsers.Any(m => m.EmployeeID == employeeId && m.SubModuleID == userAccess.Id)) { SubModuleUser userSubModule = db.SubModuleUsers.FirstOrDefault(m => m.EmployeeID == employeeId && m.SubModuleID == userAccess.Id); db.SubModuleUsers.Remove(userSubModule); db.SaveChanges(); } } Employee employee = db.Employees.Find(employeeId); employee.IsAdmin = adminchk.IsChecked == true ? true : false; db.SaveChanges(); MessageBox.Show("Employee user access updated successfully"); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); if (db.SystemSettings.Count() >= 1) { ImusCityGovernmentSystem.Model.SystemSetting systemSetting = db.SystemSettings.FirstOrDefault(); userstb.Text = systemSetting.NumberOfUser.ToString(); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void CheckDisbursementVoucher(int id) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); List <DisbursementVoucherModel> DVList = new List <DisbursementVoucherModel>(); db = new ImusCityHallEntities(); DVList = new List <DisbursementVoucherModel>(); var disburse = db.GetDisbursementVoucher(id).ToList(); CDSSignatory signatories = db.CDSSignatories.FirstOrDefault(); foreach (var x in disburse) { DisbursementVoucherModel dvl = new DisbursementVoucherModel(); dvl.Amount = x.Amount.HasValue ? x.Amount.Value : 0; dvl.Certification = x.Certification; dvl.CompanyAddress = x.CompanyAddress; dvl.CompanyName = x.CompanyName; dvl.DateCreated = x.DateCreated.Value; dvl.DepartmentCode = x.DepartmentCode; dvl.Description = x.Explanation; dvl.DocumentCompleted = x.DocumentCompleted; dvl.Obligated = x.Obligated; dvl.ObligationRequestNo = x.ObligationRequestNo; dvl.TIN_EmpNo = x.TIN_EmpNo; dvl.Unit_Project = x.Unit_Project; dvl.VoucherNo = x.VoucherNo; dvl.PaymentName = x.PaymentType; dvl.Name = x.FundName; dvl.Signatory = SystemClass.GetSignatory(signatories.CityAccountant); dvl.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer); dvl.Signatory3 = SystemClass.GetSignatory(signatories.CityMayor); DVList.Add(dvl); } ReportDocument report; report = new DisbursementVoucherReport(); report.SetDataSource(DVList); report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID)); report.SetParameterValue("actingmayor", signatories.UseActingMayor); reportviewer.ViewerCore.ReportSource = report; } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void CheckReport(int id) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); CDSSignatory signatories = db.CDSSignatories.FirstOrDefault(); CheckModel check = new CheckModel(); ImusCityGovernmentSystem.Model.Check checklist = db.Checks.Find(id); check.CheckNo = checklist.CheckNo; check.CheckDate = checklist.DateCreated.Value; check.CompanyName = checklist.Disbursement.Payee == null ? checklist.Disbursement.PayeeName : checklist.Disbursement.Payee.CompanyName; CurrencyToWords convert = new CurrencyToWords(); double amount = Convert.ToDouble(checklist.Amount.Value); check.AmountInWords = convert.NumberToWords(amount).ToUpper(); check.CheckDescription = checklist.CheckDescription; check.VoucherNo = checklist.Disbursement.VoucherNo; check.Amount = checklist.Amount.Value; check.Signatory1 = SystemClass.GetSignatory(signatories.CityMayor); check.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer); ReportDocument report; switch (bankName) { case "LB": report = new LBCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; case "UCPB": report = new UCPBCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; case "DBP": report = new DBPCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void acceptbtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); if (db.SystemSettings.Count() >= 1) { int numberUsers = Convert.ToInt32(userstb.Text); ImusCityGovernmentSystem.Model.SystemSetting systemSetting = db.SystemSettings.FirstOrDefault(); systemSetting.NumberOfUser = numberUsers; db.SaveChanges(); MessageBox.Show("System setting updated successfully!"); } else { if (String.IsNullOrEmpty(userstb.Text)) { MessageBox.Show("Please input number of users field"); } else { int numberUsers = Convert.ToInt32(userstb.Text); ImusCityGovernmentSystem.Model.SystemSetting systemSetting = new SystemSetting { NumberOfUser = numberUsers }; db.SystemSettings.Add(systemSetting); db.SaveChanges(); MessageBox.Show("System setting updated successfully!"); } } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void acceptbtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); var licenseList = from p in db.LicensingCodes select new { p.LicenseId, p.ExpirationDate, p.SubModule, LicenseKey = p.LicenseKey.Replace("\r\n", string.Empty) }; if (String.IsNullOrEmpty(licensekey.Text)) { MessageBox.Show("The license key field is empty"); return; } var licenseCode = licenseList.FirstOrDefault(m => m.LicenseKey == licensekey.Text); LicensingCode license = new LicensingCode() { LicenseId = licenseCode.LicenseId, LicenseKey = licenseCode.LicenseKey, ExpirationDate = licenseCode.ExpirationDate, SubModule = licenseCode.SubModule }; if (license != null && license.ExpirationDate > DateTime.Now.Date && license.SubModule.Acronym == subModuleCode && license.LicenseKey == App.LicenseKey) { LicensingCode dbLicense = db.LicensingCodes.Find(license.LicenseId); //license.MachineName = Environment.MachineName; //license.UserID = App.EmployeeID; dbLicense.ActivatedDate = DateTime.Now; db.SaveChanges(); MessageBox.Show("License key applied"); this.Close(); } else if (String.IsNullOrEmpty(licensekey.Text)) { MessageBox.Show("The license key field is empty"); } else if (license == null) { MessageBox.Show("Please enter a valid license key."); } else if (license.ExpirationDate < DateTime.Now) { MessageBox.Show("The license that youve entering is expired!"); } else if (licensekey.Text != App.LicenseKey) { MessageBox.Show("Please enter a valid license key."); } else if (license.SubModule.Acronym != subModuleCode && license != null) { MessageBox.Show("The license that you are applying is not meant for the specified module"); } //else if (license.LicenseKey == licensekey.Text && license.UserID == App.EmployeeID) //{ // MessageBox.Show("This license is associated with another user"); //} } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void loginbtn_Click(object sender, RoutedEventArgs e) { Mouse.OverrideCursor = Cursors.Wait; try { if (String.IsNullOrEmpty(usernametb.Text) || String.IsNullOrEmpty(passwordpb.Password)) { MessageBox.Show("Please input your sign-in credentials"); } else { if (SystemClass.CheckConnection()) { using (var db = new ImusCityHallEntities()) { var passwordHasher = new Microsoft.AspNet.Identity.PasswordHasher(); string pass = ""; var asp = db.AspNetUsers.Where(m => m.UserName == usernametb.Text).FirstOrDefault(); if (asp != null) { pass = passwordHasher.VerifyHashedPassword(asp.PasswordHash, passwordpb.Password).ToString(); } else { MessageBox.Show("Log-in failed!"); Mouse.OverrideCursor = null; return; } if (pass == "Success") { Mouse.OverrideCursor = Cursors.Wait; var emp = db.Employees.FirstOrDefault(m => m.EmployeeNo == usernametb.Text); App.EmployeeID = emp.EmployeeID; if (passwordpb.Password == "imuscitygov") { Mouse.OverrideCursor = null; MessageBox.Show("Please change your default password."); ChangePasswordWindow password = new ChangePasswordWindow(); password.Show(); } else if (emp.SecurityQuestionUsers.Count < 3 && emp.EmployeeNo != "123456") { Mouse.OverrideCursor = null; MessageBox.Show("Please set-up your security questions."); SecurityQuestion secquestion = new SecurityQuestion(); secquestion.Show(); // } else { var audit = new AuditTrailModel { Activity = "Log-in to the system", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); MainWindow mw = new MainWindow(); mw.Password = passwordpb.Password; mw.Show(); this.Close(); } } else { MessageBox.Show("Log-in failed!"); Mouse.OverrideCursor = null; return; } } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } Mouse.OverrideCursor = null; }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { using (var db = new ImusCityHallEntities()) { QList = new List <QuestionList>(); if (!String.IsNullOrEmpty(cbSecurityQuestion1.Text) && !String.IsNullOrEmpty(txtAnswer1.Text)) { QuestionList ql = new QuestionList(); int QuestionID1 = Convert.ToInt32(cbSecurityQuestion1.SelectedValue); ql.EmployeeID = App.EmployeeID; ql.QuestionID = QuestionID1; ql.Answer = txtAnswer1.Text; QList.Add(ql); } else { MessageBox.Show("Please answer security questions."); return; } if (!String.IsNullOrEmpty(cbSecurityQuestion2.Text) && !String.IsNullOrEmpty(txtAnswer2.Text)) { QuestionList ql = new QuestionList(); int QuestionID2 = Convert.ToInt32(cbSecurityQuestion2.SelectedValue); ql.EmployeeID = App.EmployeeID; ql.QuestionID = QuestionID2; ql.Answer = txtAnswer2.Text; QList.Add(ql); } else { MessageBox.Show("Please answer security questions."); return; } if (!String.IsNullOrEmpty(cbSecurityQuestion3.Text) && !String.IsNullOrEmpty(txtAnswer3.Text)) { QuestionList ql = new QuestionList(); int QuestionID3 = Convert.ToInt32(cbSecurityQuestion3.SelectedValue); ql.EmployeeID = App.EmployeeID; ql.QuestionID = QuestionID3; ql.Answer = txtAnswer3.Text; QList.Add(ql); } else { MessageBox.Show("Please answer security questions."); return; } foreach (var x in QList) { SecurityQuestionUser squ = new SecurityQuestionUser(); squ.EmployeeID = x.EmployeeID; squ.SecurityQuestionID = x.QuestionID; squ.Answer = x.Answer; db.SecurityQuestionUsers.Add(squ); db.SaveChanges(); } MessageBox.Show("Security Questions set-up succesfully!"); var audit = new AuditTrailModel { Activity = "User set-up security questions.", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); this.Close(); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void CheckUserAccess() { CDS.IsEnabled = false; EMP.IsEnabled = false; CUST.IsEnabled = false; DEPT.IsEnabled = false; DIV.IsEnabled = false; ID.IsEnabled = false; UA.IsEnabled = false; if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); IEnumerable <SubModuleUser> submodule = db.SubModuleUsers.Where(m => m.EmployeeID == App.EmployeeID); if (submodule.Count() >= 1) { foreach (var module in submodule) { switch (module.SubModule.Acronym) { case "CDS": CDS.IsEnabled = module.SubModule.Acronym == CDS.Name ? true : false; break; case "EMP": EMP.IsEnabled = module.SubModule.Acronym == EMP.Name ? true : false; break; case "CUST": CUST.IsEnabled = module.SubModule.Acronym == CUST.Name ? true : false; break; case "DEPT": DEPT.IsEnabled = module.SubModule.Acronym == DEPT.Name ? true : false; break; case "DIV": DIV.IsEnabled = module.SubModule.Acronym == DIV.Name ? true : false; break; case "ID": ID.IsEnabled = module.SubModule.Acronym == ID.Name ? true : false; break; case "UA": UA.IsEnabled = module.SubModule.Acronym == UA.Name ? true : false; break; } } } else { modules.IsEnabled = false; } Employee superAdmin = db.Employees.Find(App.EmployeeID); AspNetUser user = db.AspNetUsers.FirstOrDefault(m => m.UserName == superAdmin.EmployeeNo); if (user.AspNetUserRoles.FirstOrDefault().RoleId == "1") { SS.Visibility = Visibility.Visible; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }