private void BtnFilter_Click(object sender, EventArgs e)
{
DateTime startDate;
DateTime endDate;
if (checkedStartDate)
{
startDate = dateTimePickerStartDate.Value;
}
else
{
startDate = Convert.ToDateTime("01/01/1980");
}
if (checkedFinishDate)
{
endDate = dateTimePickerFinishDate.Value;
}
else
{
endDate = Convert.ToDateTime("01/01/3000");
}
BLInvoice bliv = new BLInvoice();
BindingList <InvoiceModel> listInvoice = bliv.BLGetInvoice(null, startDate, endDate, txtNrInvoice.Text, comboBoxFilterClientName.Text);
dataGridViewInvoice.Rows.Clear();
foreach (InvoiceModel invoice in listInvoice)
{
dataGridViewInvoice.Rows.Add(invoice.invoiceId, invoice.invoiceNumber, invoice.invoiceDate, invoice.clientId, invoice.clientName, invoice.clientAddressId, invoice.clientAddress, invoice.userId, invoice.observations, invoice.status);
}
}
public void InvoicePopulateForm(DateTime date)
{
BLInvoice bl = new BLInvoice();
BindingList <InvoiceModel> list = bl.BLGetInvoice(invoiceIdSelected, date, date, "", "");
foreach (InvoiceModel invoice in list)
{
txtNrInvoice.Text = invoice.invoiceNumber;
dateTimePickerInvoiceDate.Value = invoice.invoiceDate;
comboBoxClientName.Text = invoice.clientName;
comboBoxClientAddress.Text = invoice.clientAddress;
txtObs.Text = invoice.observations;
}
}
private void InvoiceForm_Load(object sender, EventArgs e)
{
BLClient bl = new BLClient();
BindingList <ClientModel> listClients = bl.GetClientBi("", "", "", null, null, null);
foreach (ClientModel client in listClients)
{
comboBoxFilterClientName.Items.Add(client.ClientName + ' ' + client.ClientSurname);
}
this.dateTimePickerStartDate.CustomFormat = " ";
this.dateTimePickerStartDate.Format = DateTimePickerFormat.Custom;
this.dateTimePickerFinishDate.CustomFormat = " ";
this.dateTimePickerFinishDate.Format = DateTimePickerFormat.Custom;
dateTimePickerStartDate.ValueChanged += DateTimePickerStartDate_ValueChanged;
dateTimePickerStartDate.ShowCheckBox = true;
dateTimePickerFinishDate.ValueChanged += DateTimePickerFinishDate_ValueChanged;
dateTimePickerFinishDate.ShowCheckBox = true;
dataGridViewInvoice.Columns.Add("invoiceId", "invoiceId");
dataGridViewInvoice.Columns.Add("invoiceNumber", "Numar Factura");
dataGridViewInvoice.Columns.Add("invoiceDate", "Data Factura");
dataGridViewInvoice.Columns.Add("clientId", "clientId");
dataGridViewInvoice.Columns.Add("clientName", "Nume Client");
dataGridViewInvoice.Columns.Add("clientAddressId", "clientAddressId");
dataGridViewInvoice.Columns.Add("clientAddress", "Adresa Client");
dataGridViewInvoice.Columns.Add("userId", "userId");
dataGridViewInvoice.Columns.Add("invoiceObs", "Observatii");
dataGridViewInvoice.Columns.Add("invoiceStatus", "invoiceStatus");
dataGridViewInvoice.AutoGenerateColumns = false;
dataGridViewInvoice.Columns[0].Visible = false;
dataGridViewInvoice.Columns[3].Visible = false;
dataGridViewInvoice.Columns[5].Visible = false;
dataGridViewInvoice.Columns[7].Visible = false;
dataGridViewInvoice.Columns[9].Visible = false;
BLInvoice bliv = new BLInvoice();
BindingList <InvoiceModel> listInvoice = bliv.BLGetInvoice(null, Convert.ToDateTime("01/01/1980"), Convert.ToDateTime("01/01/3000"), txtNrInvoice.Text, comboBoxFilterClientName.Text);
foreach (InvoiceModel invoice in listInvoice)
{
dataGridViewInvoice.Rows.Add(invoice.invoiceId, invoice.invoiceNumber, invoice.invoiceDate, invoice.clientId, invoice.clientName, invoice.clientAddressId, invoice.clientAddress, invoice.userId, invoice.observations, invoice.status);
}
}
