private void dgvProducts_CellClick(object sender, DataGridViewCellEventArgs e)
{
// If a valid row is selected If the last row is not selected (because it's empty)
if (e.RowIndex != -1 && e.RowIndex != dgvProducts.Rows.Count - 1)
{
DataGridViewRow row = this.dgvProducts.Rows[e.RowIndex];
mtbCode.Text = row.Cells[0].Value.ToString();
tbProductName.Text = row.Cells[1].Value.ToString();
cbUnit.SelectedIndex = cbUnit.FindString(row.Cells[2].Value.ToString());
cbTaxGroup.SelectedIndex = cbTaxGroup.FindString(row.Cells[3].Value.ToString());
mtbGroupCode.Text = row.Cells[4].Value.ToString();
mtbHelpCode.Text = row.Cells[5].Value.ToString();
tbPrice.Text = row.Cells[6].Value.ToString();
tbOrigin.Text = row.Cells[7].Value.ToString();
tbDescription.Text = row.Cells[8].Value.ToString();
tbQuantity.Text = row.Cells[9].Value.ToString();
int checkedTax = Product_DbCommunication.CheckIfProductIsWithTax(mtbCode.Text);
cbDDV.Checked = checkedTax == 1 ? true : false;
Product.SetProduct(mtbCode.Text, tbProductName.Text, cbUnit.SelectedItem.ToString(), cbTaxGroup.SelectedItem.ToString(), mtbGroupCode.Text, mtbHelpCode.Text, tbPrice.Text, tbOrigin.Text, tbDescription.Text, tbQuantity.Text, checkedTax.ToString());
}
else
{
ClearTextBoxes();
}
}
private void Search()
{
if (tbSearch.Text != "")
{
if (rbtnCode.Checked)
{
dgvProducts.DataSource = Product_DbCommunication.FilterProducts("Шифра", tbSearch.Text);
}
else if (rbtnProduct.Checked)
{
dgvProducts.DataSource = Product_DbCommunication.FilterProducts("Артикл", tbSearch.Text);
}
else
{
MessageBox.Show("Одберете начин на филтрирање!", "Грешка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dgvProducts.SelectedCells.Count == 1)
{
Product_DbCommunication.EditProduct(Product.Code, mtbCode.Text, tbProductName.Text, cbUnit.GetItemText(cbUnit.SelectedItem), cbTaxGroup.GetItemText(cbTaxGroup.SelectedItem), mtbGroupCode.Text, mtbHelpCode.Text, tbPrice.Text, tbOrigin.Text, tbDescription.Text, cbDDV.Checked == true ? 1 : 0, tbQuantity.Text);
Product.Code = mtbCode.Text;
MessageBox.Show
(
"Артиклот е успешно променет!",
"Промени",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
UpdateTable();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (mtbCode.Text == "" || tbProductName.Text == "" || cbUnit.SelectedIndex == -1 || cbTaxGroup.SelectedIndex == -1)
{
errorProviderCode.SetError(mtbCode, "Полето за шифра е задолжително");
errorProviderProduct.SetError(tbProductName, "Полето за назив на артиклот е задолжително");
errorProviderUnit.SetError(cbUnit, "Одберете единица мерка");
errorProviderTaxGroup.SetError(cbTaxGroup, "Одберете даночна група");
}
else
{
if (DbCommunication.Exists("Products", "Шифра", mtbCode.Text) < 1)
{
Product_DbCommunication.AddProduct(mtbCode.Text, tbProductName.Text, cbUnit.GetItemText(cbUnit.SelectedItem), cbTaxGroup.GetItemText(cbTaxGroup.SelectedItem), mtbGroupCode.Text, mtbHelpCode.Text, tbPrice.Text, tbOrigin.Text, tbDescription.Text, cbDDV.Checked == true ? 1 : 0, tbQuantity.Text);
UpdateTable();
MessageBox.Show
(
"Артиклот е успешно додаден!",
"Сними",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
errorProviderCode.Clear();
errorProviderProduct.Clear();
errorProviderUnit.Clear();
errorProviderTaxGroup.Clear();
}
else
{
MessageBox.Show
(
"Тој артикл веќе постои!",
"Грешка",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
decimal ItemTrueQuantity = Product_DbCommunication.GetProductQuantity(item.Code);
if (item.Quantity <= ItemTrueQuantity)
{
if (!DuplicateItem(item.Code))
{
InvoiceItems_DbCommunication.AddInvoiceItem(OutgoingInvoices.InvoiceNumber, item.Code, item.Quantity, item.Price);
dgvInvoiceItems.DataSource = DbCommunication.DisplayData(SearchQuery);
ClearTextBoxes();
Product_DbCommunication.DecreaseQuantity(ItemTrueQuantity - item.Quantity, item.Code);
}
else
{
MessageBox.Show
(
"Ставката веќе постои.",
"Грешка",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
}
else
{
MessageBox.Show
(
"Нема доволно залиха.",
"Грешка",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
