public List <InvoiceModel> getallinvoices(string invoicenumber, DateTime invoicedateStartFrom, DateTime invoicedateEndto, string clientid,
bool checkstart, bool checkend)
{
List <InvoiceModel> invoiceList = new List <InvoiceModel>();
DataTable dt = new DataTable();
DATotCeFolosescLaInvoice invoice = new DATotCeFolosescLaInvoice();
dt = invoice.getInvoices(invoicenumber, invoicedateStartFrom, invoicedateEndto, clientid, checkstart, checkend);
for (int i = 0; i < dt.Rows.Count; i++)
{
InvoiceModel invoicemode = new InvoiceModel();
invoicemode.InvoiceId = Convert.ToInt32(dt.Rows[i]["InvoiceId"].ToString());
invoicemode.ClientAddressId = Convert.ToInt32(dt.Rows[i]["ClientAddressId"].ToString());
invoicemode.ClientId = Convert.ToInt32(dt.Rows[i]["ClientId"].ToString());
invoicemode.InvoiceNumber = dt.Rows[i]["InvoiceNumber"].ToString();
invoicemode.InvoiceDate = Convert.ToDateTime(dt.Rows[i]["InvoiceDate"].ToString());
invoicemode.ClientName = dt.Rows[i]["ClientName"].ToString();
invoicemode.ClientSurname = dt.Rows[i]["ClientSurname"].ToString();
invoicemode.Address = dt.Rows[i]["Adresa"].ToString();
invoicemode.Obesrvations = dt.Rows[i]["Observations"].ToString();
invoiceList.Add(invoicemode);
}
return(invoiceList);
}
public InvoiceForm()
{
InitializeComponent();
DATotCeFolosescLaInvoice id = new DATotCeFolosescLaInvoice();
this.InvoiceId = id.getInvoiceId() + 1;
}
private void BtnAddInvoice_Click(object sender, EventArgs e)
{
InvoiceId += 1;
if (String.IsNullOrWhiteSpace(txtBoxInvoiceNumber.Text))
{
MessageBox.Show("Numarul facturii nu este completat!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(comboBoxClient.Text))
{
MessageBox.Show("Nu este ales nciun partenere!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(comboBoxClientAddress.Text))
{
MessageBox.Show("Nu este ales nciun partenere!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (dateInvoiceDate.Text.Length == 0)
{
MessageBox.Show("Nu ai ales data!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DATotCeFolosescLaInvoice invoice = new DATotCeFolosescLaInvoice();
string numarfactura = txtBoxInvoiceNumber.Text;
DateTime dataFactura = dateInvoiceDate.Value.Date;
int idpar = ((ClientModel)comboBoxClient.SelectedItem).ClientId;
int idadresa = ((ClientAddressModel)comboBoxClientAddress.SelectedItem).ClientAddressId;
string obser = txtBoxObservations.Text;
List <InvoiceDetailModel> invoiceDetailModels = new List <InvoiceDetailModel>();
for (int i = 0; i < dGVInvoiceDetails.RowCount; i++)
{
InvoiceDetailModel invoicedetail = new InvoiceDetailModel();
invoicedetail = (InvoiceDetailModel)dGVInvoiceDetails.Rows[i].DataBoundItem;
invoiceDetailModels.Add(invoicedetail);
}
bool status = invoice.insertInvoice(numarfactura, dataFactura, idpar, idadresa, UserId, obser, invoiceDetailModels);
if (status == true)
{
MessageBox.Show("Factura adaugata!", "Wew", MessageBoxButtons.OK, MessageBoxIcon.Information);
InvoicesForm invoicesForm = new InvoicesForm();
invoicesForm.Show();
this.Hide();
invoicesForm.FormClosed += invoice_from_formClosed;
}
else
{
MessageBox.Show("Factura neadaugata!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void DGVInvoices_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
InvoiceForm invoiceForm = new InvoiceForm();
invoiceForm.Show();
this.Hide();
int index = e.RowIndex;
DataGridViewRow selectedRow = dGVInvoices.Rows[index];
invoiceForm.UserId = Convert.ToInt32(selectedRow.Cells[1].Value);
invoiceForm.txtBoxInvoiceNumber.Text = selectedRow.Cells[1].Value.ToString();
invoiceForm.txtBoxObservations.Text = selectedRow.Cells[6].Value.ToString();
invoiceForm.comboBoxClient.SelectedItem = selectedRow.Cells[3].Value.ToString();
invoiceForm.comboBoxClientAddress.Text = selectedRow.Cells[4].Value.ToString();
invoiceForm.dateInvoiceDate.Value = Convert.ToDateTime(selectedRow.Cells[4].Value);
DATotCeFolosescLaInvoice detalii = new DATotCeFolosescLaInvoice();
DataTable dt = new DataTable();
dt = detalii.getInvoiceDetails(Convert.ToInt32(selectedRow.Cells[0].Value));
for (int i = 0; i < dt.Rows.Count; i++)
{
InvoiceDetailModel invoicemode = new InvoiceDetailModel();
invoicemode.InvoiceId = Convert.ToInt32(dt.Rows[i]["InvoiceId"].ToString());
invoicemode.InvoiceDetailId = Convert.ToInt32(dt.Rows[i]["InvoiceDetailId"].ToString());
invoicemode.Item = new ItemModel
{
ItemName = dt.Rows[i]["Item"].ToString()
};
invoicemode.Qtty = Convert.ToDecimal(dt.Rows[i]["Qtty"].ToString());
invoicemode.Price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString());
invoicemode.Amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());
invoicemode.Observations = dt.Rows[i]["Observations"].ToString();
//invoiceForm.lista.Add(invoicemode);
}
invoiceForm.dGVInvoiceDetails.DataSource = detalii.getInvoiceDetails(Convert.ToInt32(selectedRow.Cells[0].Value));
invoiceForm.dGVInvoiceDetails.Columns["InvoiceDetailId"].Visible = false;
invoiceForm.dGVInvoiceDetails.Columns["InvoiceId"].Visible = false;
invoiceForm.dGVInvoiceDetails.Columns["Item"].HeaderText = "Item";
invoiceForm.dGVInvoiceDetails.Columns["Qtty"].HeaderText = "Cantitate";
invoiceForm.dGVInvoiceDetails.Columns["Price"].HeaderText = "Pret";
invoiceForm.dGVInvoiceDetails.Columns["Amount"].HeaderText = "Amount";
invoiceForm.dGVInvoiceDetails.Columns["Observations"].HeaderText = "Observatii";
invoiceForm.FormClosed += ClientDetail_Form_Closed;
}
public List <ItemModel> getItems()
{
List <ItemModel> itemList = new List <ItemModel>();
DataTable dt = new DataTable();
DATotCeFolosescLaInvoice item = new DATotCeFolosescLaInvoice();
dt = item.getItems();
for (int i = 0; i < dt.Rows.Count; i++)
{
ItemModel itemModel = new ItemModel();
itemModel.ItemId = Convert.ToInt32(dt.Rows[i]["ItemId"].ToString());
itemModel.ItemName = dt.Rows[i]["Item"].ToString();
itemList.Add(itemModel);
}
return(itemList);
}
public BindingList <ClientAddressModel> adressList(int id)
{
BindingList <ClientAddressModel> listAdrese = new BindingList <ClientAddressModel>();
DataTable dt = new DataTable();
DATotCeFolosescLaInvoice da = new DATotCeFolosescLaInvoice();
dt = da.getClientsAddress(id);
for (int i = 0; i < dt.Rows.Count; i++)
{
ClientAddressModel adresa = new ClientAddressModel();
adresa.ClientAddressId = Convert.ToInt32(dt.Rows[i]["ClientAddressId"].ToString());
adresa.Adresa = dt.Rows[i]["Adresa"].ToString();
listAdrese.Add(adresa);
}
return(listAdrese);
}
public BindingList <ClientModel> ClientList()
{
BindingList <ClientModel> listaClienti = new BindingList <ClientModel>();
DataTable dt = new DataTable();
DATotCeFolosescLaInvoice da = new DATotCeFolosescLaInvoice();
dt = da.getClients();
for (int i = 0; i < dt.Rows.Count; i++)
{
ClientModel client = new ClientModel();
client.ClientId = Convert.ToInt32(dt.Rows[i]["ClientId"].ToString());
client.ClientName = dt.Rows[i]["ClientName"].ToString();
client.ClientSurname = dt.Rows[i]["ClientSurname"].ToString();
client.CodeClient = dt.Rows[i]["ClientCode"].ToString();
client.Fullname = dt.Rows[i]["FullName"].ToString();
listaClienti.Add(client);
}
return(listaClienti);
}
