public static void delete_record(string objednavka, string poradove_cislo, string tabulka, System.Windows.Forms.Form Form, int rework)
{
if (MessageBox.Show("Naozaj chcete vymazať objednávku? všetko bude vymazané!", "DELETE",
MessageBoxButtons.YesNo, MessageBoxIcon.Question)
== DialogResult.Yes)
{
try
{
string connectionString = Class1.dbs_nastavenia("DBS_connection_string");
SqlConnection sqlConn = new SqlConnection(connectionString);
SqlCommand sqlComm = new SqlCommand();
sqlComm = sqlConn.CreateCommand();
SqlCommand sqlCommDelete = new SqlCommand();
sqlCommDelete = sqlConn.CreateCommand();
sqlCommDelete.CommandText = @"DELETE FROM tblObjednavky WHERE SylexObjednavka = '" + objednavka + "/" + poradove_cislo + "' AND rework=" + rework;
sqlConn.Open();
sqlCommDelete.ExecuteNonQuery();
sqlCommDelete.CommandText = @"DELETE FROM " + tabulka + " WHERE Objednavka = '" + objednavka + "/" + poradove_cislo + "' AND rework=" + rework;
sqlCommDelete.ExecuteNonQuery();
sqlCommDelete.CommandText = @"DELETE FROM tblZnicenyMaterial WHERE objednavka = '" + objednavka + "/" + poradove_cislo + "' AND rework=" + rework;
sqlCommDelete.ExecuteNonQuery();
sqlConn.Close();
Form f1 = (Form)System.Windows.Forms.Application.OpenForms[1];
f1.Close();
Zakazky f = (Zakazky)System.Windows.Forms.Application.OpenForms[0];
f.tblZakazkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblZakazky);
f.tblObjednavkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblObjednavky);
Class1.set_sort_main_form();
}
}
private void NovaZakazka_FormClosing(object sender, FormClosingEventArgs e)
{
Zakazky f = (Zakazky)Application.OpenForms[0];
f.tblZakazkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblZakazky);
f.tblObjednavkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblObjednavky);
Class1.set_sort_main_form();
}
private void UlozitZakazku_Click(object sender, EventArgs e)
{
try
{
this.tblNastaveniaTableAdapter.Update(this.novaDBcsharpDataSet.tblNastavenia);
this.novaDBcsharpDataSet.tblNastavenia.AcceptChanges();
Zakazky f = (Zakazky)Application.OpenForms[0];
f.tblZakazkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblZakazky);
f.tblObjednavkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblObjednavky);
Class1.set_sort_main_form();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.Close();
}
/// <summary>
/// Handles user clicks of the button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void MyGridButtonXEditControlClick(object sender, EventArgs e)
{
Zakazky f = (Zakazky)Application.OpenForms[0];
GridPanel panel = f.gridObjednavky.ActiveRow.GridPanel;
GridRow row = panel.ActiveRow as GridRow;
String Objednavka = Convert.ToString(row.Cells[3].Value);
String formular = Convert.ToString(row.Cells[53].Value);
int rework = Convert.ToInt32(row.Cells[4].Value);
Properties.Settings.Default.Objednavka = Objednavka;
Properties.Settings.Default.Snimac = formular;
Properties.Settings.Default.rework = rework;
Properties.Settings.Default.CisloZakazky = Convert.ToInt32(row.Cells[2].Value);
Properties.Settings.Default.formulare_otvorenie = true;
Properties.Settings.Default.Save();
Form form_to_open = (Form)Assembly.GetExecutingAssembly().CreateInstance("WindowsFormsApplication14." + formular);
Class1.open_form(form_to_open);
}
private void buttonX1_Click(object sender, EventArgs e)
{
string connectionString = Class1.dbs_nastavenia("DBS_connection_string");
SqlConnection con = new SqlConnection(connectionString);
SqlDataReader dr = null;
con.Open();
try
{
SqlCommand cmd = new SqlCommand("SELECT * FROM tblUzivatelia WHERE Meno = '" +
"mukky" + "' AND Heslo ='" + "marek0" + "'", con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Zakazky f = (Zakazky)System.Windows.Forms.Application.OpenForms[0];
f.textBoxItem1.Text = dr.GetString(2);
f.textBoxItem2.Text = dr.GetString(5);
Class1.prihlasovacie_meno = dr.GetString(2);
Class1.opravnenie = dr.GetString(5);
//Properties.Settings.Default.Login = dr.GetString(2);
//Properties.Settings.Default.Opravnenie = dr.GetString(5);
//Properties.Settings.Default.Save();
this.Close();
}
else
{
MessageBox.Show("Nesprávne meno alebo heslo");
}
this.login.Text = "";
this.password.Text = "";
this.login.Select();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void UlozitZakazku_Click(object sender, EventArgs e)
{
foreach (DevComponents.DotNetBar.SuperGrid.GridRow row in superGridControl1.PrimaryGrid.Rows.Reverse().Skip(1).Reverse())
{
string connectionString = Class1.dbs_nastavenia("DBS_connection_string");
SqlConnection sqlConn = new SqlConnection(connectionString);
SqlCommand sqlCommKonektorovanie = new SqlCommand();
sqlCommKonektorovanie = sqlConn.CreateCommand();
sqlConn.Open();
SqlCommand cmdCount = new SqlCommand("SELECT count(*) from tblUzivatelia WHERE IdUzivatela = @IdUzivatela", sqlConn);
cmdCount.Parameters.AddWithValue("@IdUzivatela", row.Cells[0].Value);
int count = (int)cmdCount.ExecuteScalar();
if (count > 0)
{
// UPDATE STATEMENT
sqlCommKonektorovanie.CommandText = @"UPDATE tblUzivatelia SET Skupina=@Skupina,Meno=@Meno,Heslo=@Heslo,Email=@Email,Opravnenie=@Opravnenie,Kto=@Kto,Kedy=@Kedy WHERE IdUzivatela=@IdUzivatela";
}
else
{
// UPDATE STATEMENT
sqlCommKonektorovanie.CommandText = @"INSERT INTO tblUzivatelia (Skupina,Meno,Heslo,Email,Opravnenie,Kto,Kedy) VALUES (@Skupina,@Meno,@Heslo,@Email,@Opravnenie,@Kto,@Kedy)";
}
sqlCommKonektorovanie.Parameters.AddWithValue("@IdUzivatela", row.Cells[0].Value);
for (int i = 0; i < row.Cells.Count; i++)
{
switch (i)
{
case 1:
sqlCommKonektorovanie.Parameters.AddWithValue("@Skupina", row.Cells[i].Value);
break;
case 2:
sqlCommKonektorovanie.Parameters.AddWithValue("@Meno", row.Cells[i].Value);
break;
case 3:
sqlCommKonektorovanie.Parameters.AddWithValue("@Heslo", row.Cells[i].Value);
break;
case 4:
sqlCommKonektorovanie.Parameters.AddWithValue("@Email", row.Cells[i].Value);
break;
case 5:
sqlCommKonektorovanie.Parameters.AddWithValue("@Opravnenie", row.Cells[i].Value);
break;
case 6:
sqlCommKonektorovanie.Parameters.AddWithValue("@Kto", row.Cells[i].Value);
break;
case 7:
var outputParam = row.Cells[i].Value;
if (outputParam == DBNull.Value)
{
sqlCommKonektorovanie.Parameters.AddWithValue("@Kedy", "");
}
else
{
sqlCommKonektorovanie.Parameters.AddWithValue("@Kedy", Convert.ToDateTime(row.Cells[i].Value));
}
break;
}
}
sqlCommKonektorovanie.ExecuteNonQuery();
sqlConn.Close();
}
Zakazky f = (Zakazky)Application.OpenForms[0];
f.tblZakazkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblZakazky);
f.tblObjednavkyTableAdapter.Fill(f.novaDBcsharpDataSet.tblObjednavky);
Class1.set_sort_main_form();
this.Close();
}
