private void Button1_Click(object sender, EventArgs e)
{
// MessageBox.Show(CBGyart.Checked.ToString());
if (TBAzon.Text.Length < 3 || TBNev.Text.Length < 3)
{
MessageBox.Show("Hiányzó adat(ok)!");
}
else
{
SqlCommand sqlCmd = new SqlCommand("TermekModosit");
sqlCmd.CommandType = CommandType.StoredProcedure;
if (TBId.Text is null)//Insert
{
sqlCmd.Parameters.AddWithValue("@Id", 0);
}
else//update
{
sqlCmd.Parameters.AddWithValue("@Id", TBId.Text);
}
sqlCmd.Parameters.AddWithValue("@Azonosito", TBAzon.Text);
sqlCmd.Parameters.AddWithValue("@Nev", TBNev.Text);
sqlCmd.Parameters.AddWithValue("@Gyartando", CBGyart.Checked.ToString());
try
{
DbManagment.SqlCommandRun(sqlCmd);
Close();
}
catch (Exception exp)
{
//MessageBox.Show(exp.Message.ToString());
MessageBox.Show(exp.Message.ToString(), "HIBA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void Button1_Click(object sender, EventArgs e)
{
if (CBTermekek.SelectedValue.ToString() == null || NDarab.Value < 1 || NDarab.Value > 1000000)
{
MessageBox.Show("Hibás adatok!");
}
else
{
SqlCommand sqlCmd = new SqlCommand("TermekAlkatreszModosit");
sqlCmd.CommandType = CommandType.StoredProcedure;
if (Id == 0)//Insert
{
sqlCmd.Parameters.AddWithValue("@Id", 0);
}
else//update
{
sqlCmd.Parameters.AddWithValue("@Id", Id);
}
sqlCmd.Parameters.AddWithValue("@TermekId", TermekId);
sqlCmd.Parameters.AddWithValue("@AlkatreszId", Int32.Parse(CBTermekek.SelectedValue.ToString()));
sqlCmd.Parameters.AddWithValue("@AlkatreszMennyiseg", NDarab.Value);
try
{
DbManagment.SqlCommandRun(sqlCmd);
Close();
}
catch (Exception exp)
{
//MessageBox.Show(exp.Message.ToString());
MessageBox.Show(exp.Message.ToString(), "HIBA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void MunkaKesz(string id)
{
Nev dialogus = new Nev();
dialogus.ShowDialog();
string nev = dialogus.textBox1Text;
if (dialogus.mentes)
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
SqlCommand cmd = new SqlCommand("update gyartasifolyamat set nev = @nev , mikor = GETDATE() where id = @id", sqlCon);
cmd.Parameters.AddWithValue("@nev", nev);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
// ha minden kész akkor készre rakni
/* cmd = new SqlCommand("IF " +
* "(select count(*) from GyartasiFolyamat where GyartasId = @id and mikor is null ) = 0 " +
* "BEGIN " +
* "update[GyartasTermekek] set Kesz = 1 where id = @id; " +
* "END", sqlCon);
* cmd.Parameters.AddWithValue("@id", id);
* cmd.ExecuteNonQuery();*/
}
// MessageBox.Show(id.ToString());
try
{
SqlCommand sqlCmd = new SqlCommand("GyartasFolyamatElkeszult");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@Id", id);
sqlCmd.Parameters.AddWithValue("@Nev", nev);
DbManagment.SqlCommandRun(sqlCmd);
sqlCmd = new SqlCommand("GyartasiFolyamatKesz");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@Id", id);
DbManagment.SqlCommandRun(sqlCmd);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString(), "HIBA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
// MessageBox.Show(GenerateSHA256String(tboxPass.Text).Length.ToString());
//new DataTable();
// sqlDa.Fill(dtbl);
if (TBoxCheck())
{
SqlCommand sqlCmd = new SqlCommand("insert into felhasznalok values(@user,@name,@pass)");
sqlCmd.Parameters.AddWithValue("@user", tboxUser.Text);
sqlCmd.Parameters.AddWithValue("@name", tboxName.Text);
sqlCmd.Parameters.AddWithValue("@pass", GenerateSHA256String(tboxPass.Text));
DbManagment.SqlCommandRun(sqlCmd);
this.Hide();
var form2 = new Login();
form2.Closed += (s, args) => this.Close();
form2.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (CBTermekek.SelectedValue.ToString() == null || NDarab.Value < 1 || NDarab.Value > 9999999)
{
MessageBox.Show("Hibás adatok!");
}
else
{
try
{
SqlCommand sqlCmd = new SqlCommand("RaktarModosit");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@Id", Int32.Parse(CBTermekek.SelectedValue.ToString()));
sqlCmd.Parameters.AddWithValue("@Novel", 1);
sqlCmd.Parameters.AddWithValue("@Darab", NDarab.Value);
DbManagment.SqlCommandRun(sqlCmd);
Close();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString());
}
}
}