private void RefreshReport(object sender, RoutedEventArgs e) { try { ReportDocument qtRpt = new ReportDocument(); qtRpt.Load("E:/OneDrive - Your IT Link/Your IT Link/Development/QMS 2018/QSync V4/VS 2019/QSync/QSync/QSync/test/AbleQuotation.rpt"); using (AbleDBEntity context = new AbleDBEntity()) { var q = (from a in context.quotes join b in context.quoteitems on a.QuoteNumber equals b.QNL where a.QuoteNumber == b.QNL select new { a.Company, a.Representative, a.Address, a.Email, a.JobLocation, a.Phone, a.ContactPerson, a.Mobile, a.QuoteNumber, b.QNL, b.ItemDescription, // b.Price }).ToList(); if (q != null) { ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = quoteLoad.Text; crParameterFieldDefinitions = qtRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["QuoteLoad"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); qtRpt.SetDataSource(q); QuotePreviewReport.ViewerCore.ReportSource = qtRpt; // crystalReportViewer1.ReportSource = qtRpt; // crystalReportViewer1.Refresh(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoginBtn1_Click(object sender, RoutedEventArgs e) { Analytics.TrackEvent("Login - Login Attempt"); using (var context = new AbleDBEntity()) { // Load all staff who are current ONLY var cudb = context.staffs.Where(a => a.GrantAccess == 1) .ToList(); var user = cudb.Where(i => i.UserName == this.txtUserName.Text).FirstOrDefault(); if (user == null) { Analytics.TrackEvent("Login - Incorrect Username Entry"); MessageBox.Show("Please check your Username (this is your email address) is correct - Remember usernames are case sensitive", "USERNAME Incorrect"); } else if (this.txtUserName.Text == user.UserName && this.txtPassword.Password == user.Password) { Analytics.TrackEvent("Login - Successful Login to QSync"); Properties.Settings.Default.MyUser = txtUserName.Text; Properties.Settings.Default.Name = user.Name; Properties.Settings.Default.Accesslevel = user.QSyncAccess; Properties.Settings.Default.Qid = user.QuoteID; Properties.Settings.Default.Save(); string currentUser = txtUserName.Text; string passAccessLevel = user.QSyncAccess; string passName = user.Name; string currentQid = user.QuoteID; var Home = new QSync.MainWindow(currentUser, passAccessLevel, passName, currentQid); Home.DataContext = this; this.Visibility = Visibility.Hidden; Home.Show(); } else { Analytics.TrackEvent("Login - Incorrect Password Entry"); MessageBox.Show("Please check your password is correct - Remember passwords are case sensitive", "PASSWORD Incorrect"); } } }