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