private void comboBoxStorages_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem;
List <StoreCellTable> list = query.querySelectStoreCells(obj.Id);
addGridView(list);
}
private void buttonSearch_Click(object sender, EventArgs e)
{
string name = searchNameBox.Text;
string description = searchDescriptionBox.Text;
ObjectComboBox obj = (ObjectComboBox)comboBoxColors.SelectedItem;
int article = 0;
string color = "";
try
{
if (obj.Id != 0)
{
color = obj.Name;
}
bool ifNumber = Int32.TryParse(searchArticleBox.Text.ToString(), out article);
if (!ifNumber)
{
addGridView(query.querySelectProductsBySearch(name, description, color));
}
else
{
addGridView(query.querySelectProductsBySearch(name, article, description, color));
}
}
catch (Exception) {
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
ContractShipment c = new ContractShipment();
ObjectComboBox obj2 = (ObjectComboBox)comboBoxCells.SelectedItem;
c.StoreCellFromId = obj2.Id;
ObjectComboBox objPr = (ObjectComboBox)comboBoxProducts.SelectedItem;
c.ProductId = objPr.Id;
int amount = 0;
Int32.TryParse(textBox1.Text, out amount);
c.Amount = amount;
c.Date = dateTimePicker1.Value.Date;
if (Id == -1)
{
query.queryAddContractShipment(c);
}
else
{
c.Id = Id;
query.queryUpdateContractShipment(c);
}
instance.refreshGrid();
this.Dispose();
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxStorehouses.SelectedItem;
int storehouseIdSelected = obj.Id;
addStorageCells(storehouseIdSelected, comboBoxCells);
}
private void buttonOK_Click(object sender, EventArgs e)
{
ContractMove c = new ContractMove();
ObjectComboBox obj2 = (ObjectComboBox)comboBoxCellFrom.SelectedItem;
c.StoreCellFromId = obj2.Id;
ObjectComboBox obj4 = (ObjectComboBox)comboBoxCellTo.SelectedItem;
c.StoreCellToId = obj4.Id;
ObjectComboBox objPr = (ObjectComboBox)comboBoxProducts.SelectedItem;
c.ProductId = objPr.Id;
c.Amount = Int32.Parse(textBoxAmount.Text);
c.Date = dateTimePicker1.Value.Date;
if (Id == -1)
{
query.queryAddContractMove(c);
}
else
{
c.Id = Id;
query.queryUpdateContractMove(c);
}
instance.refreshGrid();
this.Dispose();
}
private void comboBoxGroups_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxGroups.SelectedItem;
List <EmployeeTable> list = queryEmpl.querySelectEmployees(obj.Id);
addGridView(list);
}
private void comboBoxContractorType_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxContractorType.SelectedItem;
List <Contractor> list = query.querySelectContractors(obj.Id);
addGridView(list);
// MessageBox.Show(comboBoxContractorType.SelectedIndex+"");
}
private void comboBoxColors_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxColors.SelectedItem;
if (obj.Id != 0)
{
addGridView(query.querySelectProducts(obj.Name));
}
else
{
addGridView(query.querySelectProducts());
}
}
private void search_Click(object sender, EventArgs e)
{
string name = searchNameBox.Text;
ObjectComboBox obj = (ObjectComboBox)comboBoxContractorType.SelectedItem;
if (obj.Id != 0)
{
addGridView(query.querySelectContractorsBySearch(name, obj.Id));
}
else
{
addGridView(query.querySelectContractorsBySearch(name));
}
}
private void addDataForUpdate()
{
StoreCell c = query.queryFindStoreCellById(Id);
if (c == null)
{
return;
}
textBox2.Text = c.Description;
ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem;
comboBoxStorages.SelectedValue = c.StorehouseId;
}
private void buttonSearch_Click(object sender, EventArgs e)
{
string description = searchDescriptionBox.Text;
int id = 0;
bool isNumber = Int32.TryParse(searchCellIdBox.Text, out id);
ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem;
if (obj.Id != 0)
{
addGridView(query.querySelectStoreCellsBySearch(description, id, obj.Id));
}
else
{
addGridView(query.querySelectStoreCellsBySearch(description, id));
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
StoreCell c = new StoreCell();
ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem;
c.StorehouseId = obj.Id;
c.Description = textBox2.Text;
if (Id == -1)
{
query.queryAddStoreCell(c);
}
else
{
c.Id = Id;
query.queryUpdateStoreCell(c);
}
instance.refreshGrid();
this.Dispose();
}
private void buttonOK_Click(object sender, EventArgs e)
{
TechnologicalCard techCard = new TechnologicalCard();
techCard.Title = textBox1.Text;
techCard.Date = dateTimePicker1.Value.Date;
List <ProductTechCard> productTechCardList = new List <ProductTechCard>();
ObjectComboBox objPr1 = (ObjectComboBox)comboBoxProductsImport.SelectedItem;
ProductTechCard product = new ProductTechCard();
product.ProductId = objPr1.Id;
int amount = 0;
Int32.TryParse(textBoxAmountImport.Text, out amount);
product.Amount = amount;
product.Type = 1;
productTechCardList.Add(product);
product = new ProductTechCard();
objPr1 = (ObjectComboBox)comboBoxProductsExport.SelectedItem;
product.ProductId = objPr1.Id;
amount = 0;
Int32.TryParse(textBoxAmountExport.Text, out amount);
product.Amount = amount;
product.Type = 2;
productTechCardList.Add(product);
techCard.ProductTechCards = productTechCardList;
if (Id == -1)
{
query.queryAddTechCard(techCard);
}
else
{
techCard.Id = Id;
query.queryUpdateTechCard(techCard);
}
instance.refreshGrid();
this.Dispose();
}
