public CompanyWindow() { InitializeComponent(); _context = new CRMV1Entities(); if (_context.Companies.Count() != 0) { Company myCompany = _context.Companies.First(); CompanyNameTB.Text = myCompany.Name; AdressTB.Text = myCompany.Adress; TelephoneTB.Text = myCompany.Telefon; WebSiteTB.Text = myCompany.Website; image.Source = new BitmapImage(new Uri(myCompany.FileName)); fileName = myCompany.FileName; imageInBytes = myCompany.Data; } DataContext = this; }
public InvoiceWindow() { InitializeComponent(); SwitchMode(); CustomerTB.Text = "Almedin"; using (CRMV1Entities _context = new CRMV1Entities()) { Services = new List <Service>(); Services.Add(new Service()); InvoiceDate = DateTime.Now; foreach (var service in _context.Services) { Services.Add(service); } long id; if (_context.Services.Count() > 0) { List <Invoice> c = _context.Invoices.ToList(); id = c[_context.Invoices.Count() - 1].Id + 1; } else { id = 1; } InvoiceNoTB.Text = id.ToString(); } DataContext = this; dt = new DataTable(); dt.Columns.Add(new DataColumn("LineNumber", typeof(string))); dt.Columns.Add(new DataColumn("Id", typeof(int))); dt.Columns.Add(new DataColumn("ServiceName", typeof(string))); dt.Columns.Add(new DataColumn("Price", typeof(string))); dt.Columns.Add(new DataColumn("Quantity", typeof(string))); dt.Columns.Add(new DataColumn("Total", typeof(string))); dataGrid.ItemsSource = dt.DefaultView; }
public InvoiceReport(DataTable dt) { InitializeComponent(); using (CRMV1Entities _context = new CRMV1Entities()) { Company myCompany = _context.Companies.First(); if (myCompany != null) { companyName = myCompany.Name; adress = myCompany.Adress; telefon = myCompany.Telefon; website = myCompany.Website; logo = myCompany.Data; } } ReportDataSource reportDataSource = new ReportDataSource("CRMVersion1._0", dt); reportDataSource.Name = "DataSet1"; // Name of the DataSet we set in .rdlc reportDataSource.Value = dt; reportViewer.LocalReport.ReportPath = "C:/Users/840/Documents/Visual Studio 2015/Projects/CRMVersion1.0/CRMVersion1.0/InvoiceReport.rdlc"; List <ReportParameter> paramList = new List <ReportParameter>(); paramList.Add(new ReportParameter("CompanyName", companyName, true)); paramList.Add(new ReportParameter("Adress", adress, true)); paramList.Add(new ReportParameter("Telefon", telefon, true)); paramList.Add(new ReportParameter("Website", website, true)); reportViewer.LocalReport.SetParameters(paramList); reportViewer.LocalReport.DataSources.Add(reportDataSource); reportViewer.RefreshReport(); }
public CustomerWindow() { InitializeComponent(); _context = new CRMV1Entities();//Open connection on windows initialization and dispose on window_unloaded event! }
public ServiceWindow() { InitializeComponent(); _context = new CRMV1Entities();//Opening connection on window initialization, dispose on window_unload! }