public void SaveInvoice()
{
if (invoiceIdSelected == 0)
{
LoginForm lf = new LoginForm();
BLInvoice bl = new BLInvoice();
invoiceIdSelected = bl.BLInsertInvoice(txtNrInvoice.Text, dateTimePickerInvoiceDate.Value, comboBoxClientName.Text,
comboBoxClientAddress.Text, LoginForm.id, txtObs.Text);
foreach (InvoiceDetailModel detail in listDetail)
{
detail.invoiceId = invoiceIdSelected;
}
BLInvoiceDetail bli = new BLInvoiceDetail();
bli.BLPrepareInvoiceDetail(listDetail);
MessageBox.Show("Factura a fost adaugata cu succes", "Succes", MessageBoxButtons.OK, MessageBoxIcon.None);
}
else
{
BLInvoice bl = new BLInvoice();
bl.BLUpdateInvoice(invoiceIdSelected, txtNrInvoice.Text, dateTimePickerInvoiceDate.Value, txtObs.Text, comboBoxClientName.Text, comboBoxClientAddress.Text);
BLInvoiceDetail bli = new BLInvoiceDetail();
bli.BLPrepareInvoiceDetail(listDetail);
MessageBox.Show("Factura a fost modificata cu succes", "Succes", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
//public invoicedetailform(int _id, int _userid)
//{
// initializecomponent();
// userid = _userid;
// invoiceid = _id;
// blclient blclient = new blclient();
// cmbclientfullname.datasource = blclient.getclientfullname(0);
// cmbclientfullname.displaymember = "clientfullname";
//}
public InvoiceDetailForm(int _id, int _userId)
{
InitializeComponent();
//userId = _userId;
invoiceId = _id;
userId = _userId;
BLInvoice bLInvoice = new BLInvoice();
List <DisplayInvoiceModel> list = bLInvoice.GetDisplayInvoice(invoiceId, "", DateTime.Now, DateTime.Now, "");
DisplayInvoiceModel displayInvoiceModel = new DisplayInvoiceModel();
if (list.Count > 0)
{
displayInvoiceModel = list[0];
}
//txtAddress.Text = displayInvoiceModel.Address;
//txtClientFullName.Text = displayInvoiceModel.ClientFullName;
txtInvoiceNumber.Text = displayInvoiceModel.InvoiceNumber;
dateInvoice.Value = (displayInvoiceModel.InvoiceDate == DateTime.Parse("1/1/0001 12:00:00 AM")) ? DateTime.Now : displayInvoiceModel.InvoiceDate;
BLClient bLClient = new BLClient();
List <ClientFullNameModel> clients = bLClient.GetClientFullName(0);
cmbClientFullName.DataSource = clients;
ClientFullNameModel clientFullName = bLClient.GetClientFullName(displayInvoiceModel.ClientId)[0];
//int index = clients.IndexOf(clientFullName);
int index = clients.FindIndex(a => a.ClientId == clientFullName.ClientId);
cmbClientFullName.SelectedIndex = index;
//MessageBox.Show(cmbClientFullName.SelectedIndex.ToString());
//cmbClientFullName.
//MessageBox.Show(cmbClientFullName.SelectedItem.ClientId);
//cmbClientFullName.
cmbClientFullName.DisplayMember = "ClientFullName";
//cmbClientFullName.DisplayMember = "ClientSurname";
//txtInvoiceDate.Text = displayInvoiceModel.InvoiceDate.Year.ToString()+"-"+ displayInvoiceModel.InvoiceDate.Month.ToString()+"-"+ displayInvoiceModel.InvoiceDate.Day.ToString();
txtObservations.Text = displayInvoiceModel.Observations;
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
dataGridDetails.DataSource = bLInvoiceDetail.GetInvoiceDetail(invoiceId);
dataGridDetails.Columns["InvoiceDetailId"].Visible = false;
dataGridDetails.Columns["ItemId"].Visible = false;
dataGridDetails.Columns["InvoiceId"].Visible = false;
dataGridDetails.Columns["Status"].Visible = false;
dataGridDetails.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public AddInvoiceDetailForm(int _id, InvoiceDetailForm owner)
{
InitializeComponent();
invoiceId = _id;
parent = owner;
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
cmbItem.DataSource = bLInvoiceDetail.GetItem();
cmbItem.DisplayMember = "ItemName";
}
private void Save(int invoiceId, int userId)
{
BLInvoice bLInvoice = new BLInvoice();
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
if (userId != 0 & invoiceId == 0)
{
string invoiceNumber = txtInvoiceNumber.Text;
DateTime invoiceDate = dateInvoice.Value;
ClientFullNameModel clientFullName = (ClientFullNameModel)cmbClientFullName.SelectedItem;
FullAddressModule fullAddress = (FullAddressModule)cmbAddress.SelectedItem;
if (fullAddress == null)
{
MessageBox.Show("Clientul nu are o adresa, adaugati o adresa clientului pentru a creea o factura!");
return;
}
int clientId = clientFullName.ClientId;
int clientAddressId = fullAddress.ClientAddressId;
string observations = txtObservations.Text;
MessageBox.Show(clientAddressId.ToString());
bLInvoice.AddInvoice(invoiceNumber, invoiceDate, clientId, clientAddressId, userId, observations);
MessageBox.Show("Factura a fost adaugata cu succes.");
int invoiceIdValue = bLInvoice.GetInvoiceList(-1, "", DateTime.Now, DateTime.Now, invoiceNumber)[0].InvoiceId;
Save(invoiceIdValue, 0);
}
if (userId == 0 & invoiceId != 0)
{
for (int i = 0; i < dataGridDetails.Rows.Count; i++)
{
InvoiceDetailModel detail = new InvoiceDetailModel();
detail = (InvoiceDetailModel)dataGridDetails.Rows[i].DataBoundItem;
if (detail.Status == 1)
{
bLInvoiceDetail.AddDetail(invoiceId, detail.ItemName, detail.Qtty, detail.UnitPrice, detail.Amount, detail.Observations);
}
//INSERT
if (detail.Status == 2)
{
bLInvoiceDetail.UpdateDetail(invoiceId, detail.InvoiceDetailId, detail.ItemName, detail.Qtty, detail.UnitPrice, detail.Amount, detail.Observations);
}
//UPDATE
if (detail.Status == 3)
{
bLInvoiceDetail.DeleteDetail(invoiceId, detail.InvoiceDetailId);
}
}
}
}
public UpdateInvoiceDetailForm(int _invoiceId, int _invoiceDetailId, InvoiceDetailForm owner)
{
InitializeComponent();
invoiceId = _invoiceId;
invoiceDetailId = _invoiceDetailId;
parent = owner;
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
cmbItem.DataSource = bLInvoiceDetail.GetItem();
cmbItem.DisplayMember = "ItemName";
cmbItem.SelectedIndex = -1;
}
private void InvoiceAddForm_Load(object sender, EventArgs e)
{
if (invoiceIdSelected == 0)
{
btnSave.Text = "Salveaza";
}
else
{
btnSave.Text = "Modifica";
}
BLClient bl = new BLClient();
listClients = bl.GetClientBi("", "", "", null, null, null);
foreach (ClientModel client in listClients)
{
comboBoxClientName.Items.Add(client.ClientName + ' ' + client.ClientSurname);
}
dataGridViewItems.Columns.Add("invoiceDetailId", "invoiceDetailId");
dataGridViewItems.Columns.Add("invoiceId", "invoiceId");
dataGridViewItems.Columns.Add("itemId", "itemId");
dataGridViewItems.Columns.Add("itemName", "Nume Articol");
dataGridViewItems.Columns.Add("qtty", "Cantitate");
dataGridViewItems.Columns.Add("price", "Pret");
dataGridViewItems.Columns.Add("amount", "Valoare");
dataGridViewItems.Columns.Add("observation", "Observatii");
dataGridViewItems.Columns.Add("status", "Status");
dataGridViewItems.Columns.Add("Unique", "Codul Unic");
dataGridViewItems.Columns[0].Visible = false;
dataGridViewItems.Columns[1].Visible = false;
dataGridViewItems.Columns[2].Visible = false;
dataGridViewItems.Columns[9].Visible = false;
BLInvoiceDetail blid = new BLInvoiceDetail();
BindingList <InvoiceDetailModel> list = blid.BLGetInvoiceDetail(invoiceIdSelected, null);
foreach (InvoiceDetailModel detail in list)
{
dataGridViewItems.Rows.Add(detail.invoiceDetailId, detail.invoiceId, detail.itemId, detail.itemName, detail.qtty, detail.price, detail.amount, detail.observation, detail.status, detail.unique);
}
}
