public Parametr_Window(StructOfProduct person) :
base(Gtk.WindowType.Toplevel)
{
this.Build();
Initialize(person);
}
protected void OnTreeviewAllProductCursorChanged(object sender, EventArgs e)
{
TreePath[] f = treeview_AllProduct.Selection.GetSelectedRows();
_SelectProduct = _AllProduct [f [0].Indices [0]];
SetGotStructOfPruduct(_AllProduct[f [0].Indices[0]]);
}
public bool Write_newProduct(StructOfProduct product)
{
bool resalt = true;
try
{
// WHITOUT COUNT BECAUSE COUNT 0 BY START CONFIG IN DB
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO product_t(code ,id_producer ,name_product , id_type_counter ,price_for_one ,parametr ,parametr_value ,count_value )" +
" VALUES('" + product.Number + "','" + product.Id_producer + "','" + product.Name + "','" + product.Id_typeCount + "','" + product.PriceForOne + "','" + product.Parametr + "','" + product.ValueParametr + "','" + 0 + "')";
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception)
{
resalt = false;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(resalt);
}
private void AddNewItemToDeletelist(StructOfProduct productsList)
{
_DataForDelete.Add(productsList);
_ForDelete.Clear();
for (int i = 0; i < _DataForDelete.Count; i++)
{
_ForDelete.AppendValues(_DataForDelete [i].Number, _DataForDelete [i].Name, _DataForDelete [i].TypeCount, _DataForDelete [i].Count.ToString());
}
}
private void Initialize(StructOfProduct person)
{
tb_Code.Text = person.Number;
tb_Name.Text = person.Name;
tb_Producer.Text = person.Produser;
tb_Parametr.Text = person.Parametr;
tb_ParametrValue.Text = person.ValueParametr;
tb_TypeCount.Text = person.TypeCount;
tb_Count.Text = person.Count.ToString();
tb_PriceForOne.Text = person.PriceForOne;
}
private void SetGotStructOfPruduct(StructOfProduct product)
{
try
{
tb_Name_ForInsert.Text = product.Name;
tb_Code_ForInsert.Text = product.Number;
}
catch
{
}
}
private void SetDataForDelete(StructOfProduct productsList)
{
Validation validation = new Validation();
if (!validation.ExistInList(_DataForDelete, productsList))
{
AddNewItemToDeletelist(productsList);
}
else
{
MessageBox.Show("Товар с таким нонером уже есть в списке");
}
}
public Change_Window(List <StructOfProduct> allProducts, StructOfProduct selectProduct, string nameDataBase, Bufer bufer) :
base(Gtk.WindowType.Toplevel)
{
this.Build();
_AllProduct = allProducts;
_SelectProduct = selectProduct;
buf = bufer;
Initialize(nameDataBase);
SetGotStructOfPruduct(selectProduct);
}
public bool ExistInList(List <StructOfProduct> productsList, StructOfProduct lineForInsert)
{
bool ansver = false;
foreach (StructOfProduct product in productsList)
{
if (product.Number == lineForInsert.Number)
{
ansver = true;
}
}
return(ansver);
}
// PRODUCT TABLE
private StructOfProduct Get_Product(int id_labe)
{
StructOfProduct product = new StructOfProduct();
int id_1 = 0;
int id_2 = 0;
try
{
command.CommandText = "SELECT * FROM product_t WHERE id_product=" + id_labe + "";
command.CommandType = CommandType.Text;
connection.Open();
NpgsqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
product.ID = Convert.ToInt32(reader["id_product"].ToString());
product.Number = reader["code"].ToString();
product.Name = reader["name_product"].ToString();
id_1 = Convert.ToInt32(reader["id_producer"].ToString());
id_2 = Convert.ToInt32(reader["id_type_counter"].ToString());
product.PriceForOne = reader["price_for_one"].ToString();
product.Parametr = reader["parametr"].ToString();
product.ValueParametr = reader["parametr_value"].ToString();
product.Count = Convert.ToInt32(reader["count_value"].ToString());
}
}
finally
{
if (connection != null)
{
connection.Close();
}
}
product.Produser = Get_ProducerByID(id_1);
product.TypeCount = Get_TypeOfCount_ByID(id_2);
return(product);
}
//ACTIONS
protected void OnBnAddItemClicked(object sender, EventArgs e)
{
Validation validation = new Validation();
if (!validation.IsEmpty(tb_CodeProduct.Text) && !validation.IsEmpty(tb_CodeProduct.Text) && !validation.IsEmpty(tb_Producer.Text) &&
!validation.IsEmpty(tb_TypeCounting.Text) && !validation.IsEmpty(tb_PriceForOne.Text) && !validation.IsEmpty(tb_ParametrProduct.Text) &&
!validation.IsEmpty(tb_ParametrValue.Text))
{
if (!validation.ExistInList(_ExistProduct, tb_CodeProduct.Text))
{
WriteTo_DB writer = new WriteTo_DB(nameDB, buf);
StructOfProduct product = new StructOfProduct();
product.Number = tb_CodeProduct.Text;
product.Name = tb_NameProduct.Text;
product.Id_producer = writer.Get_Or_Set_IdOfProducer(tb_Producer.Text);
product.Id_typeCount = writer.Get_Or_Set_IdOfTypeCount(tb_TypeCounting.Text);
product.Parametr = tb_ParametrProduct.Text;
product.ValueParametr = tb_ParametrValue.Text;
product.PriceForOne = tb_PriceForOne.Text;
if (writer.Write_newProduct(product))
{
MessageBox.Show("Товар успешно добавлен");
}
else
{
MessageBox.Show("повторите попытку");
}
}
else
{
MessageBox.Show("Товар с таким номером уже есть");
}
}
else
{
MessageBox.Show("Не все поля заполнены. Заполните и повторите попытку");
}
}
public List <StructOfProduct> Search(string filtr, ParametrFiltr param)
{
List <StructOfProduct> products = new List <StructOfProduct> ();
try
{
switch (param)
{
case ParametrFiltr.Code:
command.CommandText = "SELECT * FROM product_t WHERE code LIKE '%" + filtr + "%'";
break;
case ParametrFiltr.ProductName:
command.CommandText = "SELECT * FROM product_t WHERE name_product LIKE '%" + filtr + "%'";
break;
case ParametrFiltr.Parametr:
command.CommandText = "SELECT * FROM product_t WHERE parametr LIKE '%" + filtr + "%'";
break;
default:
command.CommandText = "SELECT * FROM product_t";
break;
}
command.CommandType = CommandType.Text;
connection.Open();
NpgsqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
StructOfProduct product = new StructOfProduct();
product.ID = Convert.ToInt32(reader["id_product"].ToString());
product.Number = reader["code"].ToString();
product.Name = reader["name_product"].ToString();
product.Id_producer = Convert.ToInt32(reader["id_producer"].ToString());
product.Id_typeCount = Convert.ToInt32(reader["id_type_counter"].ToString());
product.PriceForOne = reader["price_for_one"].ToString();
product.Parametr = reader["parametr"].ToString();
product.ValueParametr = reader["parametr_value"].ToString();
product.Count = Convert.ToInt32(reader["count_value"].ToString());
products.Add(product);
}
}
catch
{
}
finally
{
if (connection != null)
{
connection.Close();
}
}
foreach (StructOfProduct product in products)
{
product.Produser = Get_ProducerByID(product.Id_producer);
product.TypeCount = Get_TypeOfCount_ByID(product.Id_typeCount);
}
return(products);
}