private void Add_Click(object sender, EventArgs e)
{
if (info_textBox.Text != string.Empty &&
Country_textBox.Text != string.Empty &&
grain_type_textBox.Text != string.Empty &&
Price_textBox.Text != string.Empty &&
cost_price_textBox.Text != string.Empty &&
Name_textBox.Text != string.Empty &&
Gramm_numericUpDown.Value != 0)
{
Model_Coffee temp = new Model_Coffee(Name_textBox.Text,
Convert.ToDouble(cost_price_textBox.Text.Replace(".", ",")),
Convert.ToDouble(Price_textBox.Text.Replace(".", ",")),
grain_type_textBox.Text, Country_textBox.Text,
Convert.ToInt32(Gramm_numericUpDown.Value), info_textBox.Text);
comand.Add_BD(temp);
MessageBox.Show("Новый элемент успешно добавлен", "Добавлен новый элемент", MessageBoxButtons.OK, MessageBoxIcon.Information);
GC.Collect(GC.GetGeneration(temp));
this.Close();
}
else
{
MessageBox.Show("Заполните все поля", "Не все поля заполнены", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
internal void Add_BD(Model_Coffee temp)
{
using (DataContext db = new DataContext(Resources.ConectString))
{
db.GetTable <Model_Coffee>().InsertOnSubmit(temp);
db.SubmitChanges();
}
/* using (SqlConnection connection = new SqlConnection(Resources.ConectString))
* {
* connection.Open(); // открываем соидинение
* SqlCommand sqlComm = new SqlCommand(Resources.SQL_Select_ALL, connection);
* SqlDataAdapter adapter = new SqlDataAdapter(sqlComm.CommandText, connection);
* DataSet data = new DataSet();
* adapter.Fill(data);
* DataTable dt = data.Tables[0];
* DataRow newRow = dt.NewRow();
* newRow["Name"] = temp.name;
* newRow["Cost_price"] = temp.cost_price;
* newRow["Price"] = temp.price;
* newRow["Gram_per_serving"] = temp.gram_per_serving;
* newRow["Grain_type"] = temp.grain_type;
* newRow["Country_of_origin"] = temp.country_of_origin;
* newRow["Info"] = temp.info;
* dt.Rows.Add(newRow);
*
*
* SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);
* adapter.Update(data);
* data.Clear();
* adapter.Fill(data);
* }*/
}
public Form_edit_selected(ComboBox comboBox_select_coffe)
{
InitializeComponent();
comand = new Comand_Coffee();
Сancel.Click += Сancel_Click;
Edit.Click += Edit_Click;
Load += Form_edit_selected_Load;
edit_coffee = Coffee_list.coffee_list.Find(i => i.name == comboBox_select_coffe.SelectedItem.ToString());
}
internal void Edit(Model_Coffee edit_coffee, Model_Coffee rezult_coffee)
{
using (DataContext db = new DataContext(Resources.ConectString))
{
// Получаем таблицу пользователей
Model_Coffee up_data_coffe = db.GetTable <Model_Coffee>().FirstOrDefault <Model_Coffee>(i => i.name == edit_coffee.name);
// и изменим у него возраст
up_data_coffe.Edit_Coffe(rezult_coffee);
// сохраним изменения
db.SubmitChanges();
}
}
private void Edit_Click(object sender, EventArgs e)
{
if (info_textBox.Text != string.Empty &&
Country_textBox.Text != string.Empty &&
grain_type_textBox.Text != string.Empty &&
Price_textBox.Text != string.Empty &&
cost_price_textBox.Text != string.Empty &&
Name_textBox.Text != string.Empty &&
Gramm_numericUpDown.Value != 0)
{
rezult_coffee = new Model_Coffee(Name_textBox.Text,
Convert.ToDouble(cost_price_textBox.Text.Replace(".", ",")),
Convert.ToDouble(Price_textBox.Text.Replace(".", ",")),
grain_type_textBox.Text, Country_textBox.Text,
Convert.ToInt32(Gramm_numericUpDown.Value), info_textBox.Text);
comand.Edit(edit_coffee, rezult_coffee);
MessageBox.Show("Элемент успешно изменен", "Элемент изменен", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("Заполните все поля", "Не все поля заполнены", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
