109 lines
4.7 KiB
C#
109 lines
4.7 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using System.Windows.Forms;
|
|
|
|
namespace StacjaProb
|
|
{
|
|
public partial class manufacturersFormAdd : Form
|
|
{
|
|
public int prodID;
|
|
|
|
public manufacturersFormAdd()
|
|
{
|
|
InitializeComponent();
|
|
}
|
|
|
|
private void manufacturersFormAdd_Load(object sender, EventArgs e)
|
|
{
|
|
//DLa RAMBu
|
|
buttonSave.Visible = false;
|
|
|
|
if (prodID>0)
|
|
{
|
|
//wczytuje dane do formularza
|
|
mySqlFunctions.initConnection();
|
|
if (mySqlFunctions.OpenConnection())
|
|
{
|
|
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT MCF_NAME,MCF_CATEGORY,MCF_ADDRESS,MCF_POST,MCF_CITY,MCF_MAIL,MCF_PHONE,MCF_CONT_PERSON,MCF_DESCTRIPTION from seg_manufacturers where MCF_ID=" + prodID.ToString(), mySqlFunctions.connection);
|
|
MySql.Data.MySqlClient.MySqlDataReader dataReader = cmd.ExecuteReader();
|
|
while (dataReader.Read())
|
|
{
|
|
//comboBoxStanowisko.Items.Insert(Convert.ToInt32(dataReader["TPL_ID"]), dataReader["TPL_NAME"].ToString());
|
|
textBoxNazwa.Text = dataReader["MCF_NAME"].ToString();
|
|
textBoxKategoria.Text = dataReader["MCF_CATEGORY"].ToString();
|
|
textBoxAdres.Text = dataReader["MCF_ADDRESS"].ToString();
|
|
textBoxKodPocztowy.Text = dataReader["MCF_POST"].ToString();
|
|
textBoxMiasto.Text = dataReader["MCF_CITY"].ToString();
|
|
textBoxMail.Text = dataReader["MCF_MAIL"].ToString();
|
|
textBoxTel.Text = dataReader["MCF_PHONE"].ToString();
|
|
textBoxOsoba.Text = dataReader["MCF_CONT_PERSON"].ToString();
|
|
richTextBoxOpis.Text = dataReader["MCF_DESCTRIPTION"].ToString();
|
|
}
|
|
mySqlFunctions.CloseConnection();
|
|
//comboBoxStanowisko.SelectedIndex = 0;
|
|
}
|
|
}
|
|
else
|
|
buttonSave.Enabled = false;
|
|
|
|
|
|
|
|
}
|
|
|
|
private void buttonSave_Click(object sender, EventArgs e)
|
|
{
|
|
string query_insert;
|
|
mySqlFunctions.initConnection();
|
|
if (mySqlFunctions.OpenConnection())
|
|
{
|
|
if (prodID>0)
|
|
query_insert = "update seg_manufacturers SET MCF_NAME='" + textBoxNazwa.Text
|
|
+ "',MCF_CATEGORY='" + textBoxKategoria.Text
|
|
+ "',MCF_ADDRESS='" + textBoxAdres.Text
|
|
+ "',MCF_POST='" + textBoxKodPocztowy.Text
|
|
+ "',MCF_CITY='" + textBoxMiasto.Text
|
|
+ "',MCF_MAIL='" + textBoxMail.Text
|
|
+ "',MCF_PHONE='" + textBoxTel.Text
|
|
+ "',MCF_CONT_PERSON='" + textBoxOsoba.Text
|
|
+ "',MCF_DESCTRIPTION='" + richTextBoxOpis.Text + "' where MCF_ID="+prodID.ToString();
|
|
else
|
|
query_insert = "INSERT INTO seg_manufacturers SET MCF_NAME='" + textBoxNazwa.Text
|
|
+ "',MCF_CATEGORY='" + textBoxKategoria.Text
|
|
+ "',MCF_ADDRESS='" + textBoxAdres.Text
|
|
+ "',MCF_POST='" + textBoxKodPocztowy.Text
|
|
+ "',MCF_CITY='" + textBoxMiasto.Text
|
|
+ "',MCF_MAIL='" + textBoxMail.Text
|
|
+ "',MCF_PHONE='" + textBoxTel.Text
|
|
+ "',MCF_CONT_PERSON='" + textBoxOsoba.Text
|
|
+ "',MCF_DESCTRIPTION='" + richTextBoxOpis.Text + "'";
|
|
|
|
|
|
MySql.Data.MySqlClient.MySqlCommand cmd_01 = new MySql.Data.MySqlClient.MySqlCommand(query_insert, mySqlFunctions.connection);
|
|
cmd_01.ExecuteNonQuery();
|
|
|
|
mySqlFunctions.CloseConnection();
|
|
}
|
|
|
|
this.Close();
|
|
}
|
|
|
|
|
|
|
|
private void textBoxNazwa_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (!String.IsNullOrEmpty(textBoxNazwa.Text)) buttonSave.Enabled = true;
|
|
}
|
|
|
|
private void buttonClose_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
}
|
|
}
|