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!
}
