private void button1_Click(object sender, EventArgs e)
{
try
{
MySqlConnection myConn = new MySqlConnection();
myConn.Host = "192.168.69.8";
myConn.Port = 3306;
myConn.UserId = "cody";
myConn.Password = "******";
myConn.Open();
MySqlCommand myCommand = new MySqlCommand(" SELECT * FROM registration.regUser ;", myConn);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = myCommand;
DataTable dbDataSet = new DataTable();
myDataAdapter.Fill(dbDataSet);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbDataSet;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbDataSet);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void MultiWord()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), dt DATETIME, tm TIME, `multi word` int, PRIMARY KEY(id))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
row["id"] = 1;
row["name"] = "Name";
row["dt"] = DBNull.Value;
row["tm"] = DBNull.Value;
row["multi word"] = 2;
dt.Rows.Add(row);
da.Update(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(2, dt.Rows[0]["multi word"]);
dt.Rows[0]["multi word"] = 3;
da.Update(dt);
cb.Dispose();
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(3, dt.Rows[0]["multi word"]);
}
public void MultiWord()
{
try
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
row["id"] = 1;
row["name"] = "Name";
row["dt"] = DBNull.Value;
row["tm"] = DBNull.Value;
row["multi word"] = 2;
dt.Rows.Add(row);
da.Update(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(2, dt.Rows[0]["multi word"]);
dt.Rows[0]["multi word"] = 3;
da.Update(dt);
cb.Dispose();
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(3, dt.Rows[0]["multi word"]);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void AutoIncrementColumnsOnInsert()
{
execSQL("DROP TABLE IF EXISTS Test");
execSQL("CREATE TABLE Test (id INT UNSIGNED NOT NULL AUTO_INCREMENT, " +
"name VARCHAR(100), PRIMARY KEY(id))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dt.Columns[0].AutoIncrement = true;
Assert.IsTrue(dt.Columns[0].AutoIncrement);
dt.Columns[0].AutoIncrementSeed = -1;
dt.Columns[0].AutoIncrementStep = -1;
DataRow row = dt.NewRow();
row["name"] = "Test";
try
{
dt.Rows.Add(row);
da.Update(dt);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
dt.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(1, dt.Rows[0]["id"]);
Assert.AreEqual("Test", dt.Rows[0]["name"]);
cb.Dispose();
}
public void AutoIncrementColumnsOnInsert()
{
execSQL("CREATE TABLE Test (id INT UNSIGNED NOT NULL AUTO_INCREMENT, " +
"name VARCHAR(100), PRIMARY KEY(id))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
da.InsertCommand = cb.GetInsertCommand();
da.InsertCommand.CommandText += "; SELECT last_insert_id()";
da.InsertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
DataTable dt = new DataTable();
da.Fill(dt);
dt.Columns[0].AutoIncrement = true;
Assert.IsTrue(dt.Columns[0].AutoIncrement);
dt.Columns[0].AutoIncrementSeed = -1;
dt.Columns[0].AutoIncrementStep = -1;
DataRow row = dt.NewRow();
row["name"] = "Test";
dt.Rows.Add(row);
da.Update(dt);
dt.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(1, dt.Rows[0]["id"]);
Assert.AreEqual("Test", dt.Rows[0]["name"]);
cb.Dispose();
}
public void AdapterConcurrentException()
{
execSQL(
"CREATE TABLE T (" +
"id_auto int(11) NOT NULL AUTO_INCREMENT," +
"field varchar(50) DEFAULT NULL," +
"PRIMARY KEY (id_auto))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM T", conn);
da.InsertCommand = conn.CreateCommand();
da.InsertCommand.CommandText = @"INSERT INTO T(field) VALUES (@p_field);
SELECT * FROM T WHERE id_auto=@@IDENTITY";
da.InsertCommand.Parameters.Add("@p_field", MySqlDbType.VarChar, 50, "field");
da.InsertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
da.DeleteCommand = conn.CreateCommand();
da.DeleteCommand.CommandText = "DELETE FROM T WHERE id_auto=@id_auto";
da.DeleteCommand.Parameters.Add("@id_auto", MySqlDbType.Int32, 4, "id_auto");
DataSet ds = new DataSet();
da.Fill(ds, "T");
DataTable table = ds.Tables["T"];
DataRow r = table.NewRow();
r["field"] = "row";
table.Rows.Add(r);
da.Update(table);
Assert.AreEqual(r.RowState, DataRowState.Unchanged);
table.Rows[0].Delete();
r = table.NewRow();
r["field"] = "row2";
table.Rows.Add(r);
da.Update(table); // here was concurrencyviolation
da.Fill(ds);
Assert.AreEqual(ds.Tables["T"].Rows.Count, 1);
Assert.AreEqual(ds.Tables["T"].Rows[0]["field"], "row2");
}
public void BulkCopyCTC(List<EmployeeDet> list)
{
DataTable dt =new DataTable();
dt.Columns.Add(new DataColumn("employee_id",typeof(System.String)));
dt.Columns.Add(new DataColumn("employee_name",typeof(System.String)));
dt.Columns.Add(new DataColumn("emp_ctc",typeof(System.Decimal)));
foreach(EmployeeDet item in list)
{
DataRow dr = dt.NewRow();
dr["employee_id"]= item.GetID();
dr["employee_name"]= item.GetName();
dr["emp_ctc"]= item.GetCTC();
dt.Rows.Add(dr);
}
MySqlConnection con =new MySqlConnection(newConnectionUtils().GetConnectionString());
if(con.State==ConnectionState.Open)
{
con.Close();
}
con.Open();
MySqlCommand cmd =new MySqlCommand("SP_InsertCTC", con);
cmd.CommandType=CommandType.StoredProcedure;
cmd.UpdatedRowSource=UpdateRowSource.None;
cmd.Parameters.Add("?e_id",MySqlDbType.String).SourceColumn="employee_id";
cmd.Parameters.Add("?e_name",MySqlDbType.String).SourceColumn= "employee_name";
cmd.Parameters.Add("?emp_ctc",MySqlDbType.Decimal).SourceColumn= "emp_ctc";
MySqlDataAdapter da =new MySqlDataAdapter();
da.InsertCommand= cmd;
da.UpdateBatchSize=100;
int records = da.Update(dt);
con.Close();
}
void llenartabla()
{
MySqlCommand codigo = new MySqlCommand();
codigo.Connection = databaseConnection;
codigo.CommandText = ("SELECT * FROM entradas_salidas");
try
{
MySqlDataAdapter ejecutar = new MySqlDataAdapter();
ejecutar.SelectCommand = codigo;
DataTable datostabla = new DataTable();
ejecutar.Fill(datostabla);
dataGridView2.DataSource = datostabla;
ejecutar.Update(datostabla);
databaseConnection.Close();
}
catch (Exception e)
{
MessageBox.Show("ERROR" + e.ToString());
databaseConnection.Close();
}
MySqlCommand code = new MySqlCommand();
code.Connection = databaseConnection;
code.CommandText = ("SELECT * FROM existencias");
try
{
MySqlDataAdapter ejecutar = new MySqlDataAdapter();
ejecutar.SelectCommand = code;
DataTable datostabla = new DataTable();
ejecutar.Fill(datostabla);
dataGridView1.DataSource = datostabla;
ejecutar.Update(datostabla);
databaseConnection.Close();
}
catch (Exception e)
{
MessageBox.Show("ERROR" + e.ToString());
databaseConnection.Close();
}
try
{
comboBox1.Text = "Producto";
comboBox1.Items.Clear();
databaseConnection.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM productos", databaseConnection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
comboBox1.Refresh();
comboBox1.Items.Add(reader.GetValue(0).ToString() + " " + reader.GetValue(1).ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
databaseConnection.Close();
try
{
comboBox2.Text = "Bodega";
comboBox2.Items.Clear();
databaseConnection.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM Bodega", databaseConnection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
comboBox2.Refresh();
comboBox2.Items.Add(reader.GetValue(0).ToString() + " " + reader.GetValue(1).ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
databaseConnection.Close();
}
public void UseAdapterPropertyOfCommandBuilder()
{
CreateDefaultTable();
execSQL("INSERT INTO Test (id, id2, name) VALUES (NULL, 1, 'Test')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder();
cb.DataAdapter = da;
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["name"] = "Test Update";
int updateCnt = da.Update(dt);
Assert.AreEqual(1, updateCnt);
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("Test Update", dt.Rows[0]["name"]);
}
// Wyszukanie usług, które wykonuje pracownik
private void dgPUPracownik_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
id_rekordu = Convert.ToInt32(dgPUPracownik.Rows[e.RowIndex].Cells[0].Value);
txtPUImie.Text = dgPUPracownik.Rows[e.RowIndex].Cells["imie"].Value.ToString();
txtPUNazwisko.Text = dgPUPracownik.Rows[e.RowIndex].Cells["nazwisko"].Value.ToString();
string query = $"SELECT uslugi.uslugi_id, uslugi.nazwa, uslugi.cena, uslugi.czas FROM uslugi, uzytkownik_usluga WHERE uslugi.uslugi_id = uzytkownik_usluga.uslugi_id AND uzytkownik_usluga.id_uzytkownik = '{id_rekordu}' ORDER BY nazwa;";
MySqlCommand cmd = new MySqlCommand(query, conn);
conn.Open();
try
{
MySqlDataAdapter moja = new MySqlDataAdapter();
moja.SelectCommand = cmd;
DataTable tabela = new DataTable();
moja.Fill(tabela);
BindingSource zrodlo = new BindingSource();
zrodlo.DataSource = tabela;
dgPUUslugi.DataSource = zrodlo;
moja.Update(tabela);
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
string query2 = $"SELECT * FROM uslugi ORDER BY nazwa;";
MySqlCommand cmd2 = new MySqlCommand(query2, conn);
conn.Open();
try
{
MySqlDataAdapter moja = new MySqlDataAdapter();
moja.SelectCommand = cmd2;
DataTable tabela = new DataTable();
moja.Fill(tabela);
BindingSource zrodlo = new BindingSource();
zrodlo.DataSource = tabela;
dgPUUslugiNowe.DataSource = zrodlo;
moja.Update(tabela);
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dgPUUslugiNowe.Columns[0].Visible = false;
dgPUUslugi.Columns[0].Visible = false;
}
}
public void UsingFunctions()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), dt DATETIME, tm TIME, `multi word` int, PRIMARY KEY(id))");
execSQL("INSERT INTO Test (id, name) VALUES (1,'test1')");
execSQL("INSERT INTO Test (id, name) VALUES (2,'test2')");
execSQL("INSERT INTO Test (id, name) VALUES (3,'test3')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT id, name, now() as ServerTime FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["id"] = 4;
da.Update(dt);
da.SelectCommand.CommandText = "SELECT id, name, CONCAT(name, ' boo') as newname from Test where id=4";
dt.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("test1", dt.Rows[0]["name"]);
Assert.AreEqual("test1 boo", dt.Rows[0]["newname"]);
dt.Rows[0]["id"] = 5;
da.Update(dt);
dt.Clear();
da.SelectCommand.CommandText = "SELECT * FROM Test WHERE id=5";
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("test1", dt.Rows[0]["name"]);
da.SelectCommand.CommandText = "SELECT *, now() as stime FROM Test WHERE id<4";
cb = new MySqlCommandBuilder(da);
cb.ConflictOption = ConflictOption.OverwriteChanges;
da.InsertCommand = cb.GetInsertCommand();
}
public void DifferentDatabase()
{
if (Version < new Version(4, 1)) return;
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), dt DATETIME, tm TIME, `multi word` int, PRIMARY KEY(id))");
execSQL("INSERT INTO Test (id, name) VALUES (1,'test1')");
execSQL("INSERT INTO Test (id, name) VALUES (2,'test2')");
execSQL("INSERT INTO Test (id, name) VALUES (3,'test3')");
conn.ChangeDatabase(database1);
MySqlDataAdapter da = new MySqlDataAdapter(
String.Format("SELECT id, name FROM `{0}`.Test", database0), conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
ds.Tables[0].Rows[0]["id"] = 4;
DataSet changes = ds.GetChanges();
da.Update(changes);
ds.Merge(changes);
ds.AcceptChanges();
cb.Dispose();
conn.ChangeDatabase(database0);
}
private void AcademicsPeformanceUpdate_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid gd = (DataGrid)sender;
DataRowView row_selected = gd.SelectedItem as DataRowView;
if (row_selected != null)
{
userid.Text = row_selected["system_users_id"].ToString();
registration_number.Text = row_selected["registration_number"].ToString();
String fname = row_selected["first_name"].ToString();
String mname = row_selected["middle_name"].ToString();
String nname = row_selected["last_name"].ToString();
fullName.Text = fname + " " + mname + " " + nname;
gender.Text = row_selected["gender"].ToString();
Activeclass.Text = row_selected["class"].ToString();
Activestream.Text = row_selected["stream"].ToString();
vis.Visibility = Visibility.Hidden;
dis.Visibility = Visibility.Visible;
}
MySqlConnection myConn = new MySqlConnection(myConnection);
try
{
myConn.Open();
MySqlCommand SelectCommand = new MySqlCommand("SELECT `coursename` as 'COURSE NAME', `coursebatch` as 'COURSE BATCH', `coursecode` as 'COURSE CODE' FROM system_institution_subjects_enrollments JOIN system_institution_courses ON `system_institution_subjects_enrollments`.`system_institution_courses_id`=`system_institution_courses`.`system_institution_courses_id` WHERE `system_users_id`='" + this.userid.Text + "' ", myConn);
SelectCommand.ExecuteNonQuery();
MySqlDataAdapter dataAdp = new MySqlDataAdapter(SelectCommand);
//dataAdp.SelectCommand = SelectCommand;
DataTable dt = new DataTable();
dataAdp.Fill(dt);
StudentEnrolledCourses.ItemsSource = dt.DefaultView;
dataAdp.Update(dt);
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//try
//{
// myConn.Open();
// MySqlCommand SelectCommand = new MySqlCommand("SELECT `EnrolledCourse` AS 'COURSE', `SessionYear` AS 'YEAR', `CourseMarks` AS 'MARKS' FROM system_institution_course_assessments_binded_peformance WHERE `registration_number`='" + this.registration_number.Text + "' ", myConn);
// SelectCommand.ExecuteNonQuery();
// MySqlDataAdapter dataAdp = new MySqlDataAdapter(SelectCommand);
// //dataAdp.SelectCommand = SelectCommand;
// DataTable dt = new DataTable();
// dataAdp.Fill(dt);
// BindedPaformance.ItemsSource = dt.DefaultView;
// dataAdp.Update(dt);
// myConn.Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
public void UnsignedTypes()
{
execSQL("CREATE TABLE Test (b TINYINT UNSIGNED PRIMARY KEY)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataView dv = new DataView(dt);
DataRowView row;
row = dv.AddNew();
row["b"] = 120;
row.EndEdit();
da.Update(dv.Table);
row = dv.AddNew();
row["b"] = 135;
row.EndEdit();
da.Update(dv.Table);
cb.Dispose();
execSQL("DROP TABLE IF EXISTS Test");
execSQL("CREATE TABLE Test (b MEDIUMINT UNSIGNED PRIMARY KEY)");
execSQL("INSERT INTO Test VALUES(20)");
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test WHERE (b > ?id)", conn);
cmd.Parameters.Add("?id", MySqlDbType.UInt16).Value = 10;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
dr.Read();
Assert.AreEqual(20, dr.GetUInt16(0));
}
}
public void ParsingTender()
{
var s = DownloadString.DownL1251(_tn.Href);
if (string.IsNullOrEmpty(s))
{
Log.Logger("Empty string in ParsingTender()", _tn.Href);
return;
}
var htmlDoc = new HtmlDocument();
htmlDoc.LoadHtml(s);
using (var connect = ConnectToDb.GetDbConnection())
{
connect.Open();
var selectTend =
$"SELECT id_tender FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND end_date = @end_date AND type_fz = @type_fz AND doc_publish_date = @doc_publish_date AND notice_version = @notice_version";
var cmd = new MySqlCommand(selectTend, connect);
cmd.Prepare();
cmd.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd.Parameters.AddWithValue("@type_fz", TypeFz);
cmd.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
cmd.Parameters.AddWithValue("@notice_version", _tn.Status);
var dt = new DataTable();
var adapter = new MySqlDataAdapter {
SelectCommand = cmd
};
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Log.Logger("This tender is exist in base", PurNum);
return;
}
var dateUpd = DateTime.Now;
var cancelStatus = 0;
var updated = false;
var selectDateT =
$"SELECT id_tender, date_version, cancel FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND type_fz = @type_fz";
var cmd2 = new MySqlCommand(selectDateT, connect);
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd2.Parameters.AddWithValue("@type_fz", TypeFz);
var adapter2 = new MySqlDataAdapter {
SelectCommand = cmd2
};
var dt2 = new DataTable();
adapter2.Fill(dt2);
foreach (DataRow row in dt2.Rows)
{
//DateTime dateNew = DateTime.Parse(pr.DatePublished);
updated = true;
if (dateUpd >= (DateTime)row["date_version"])
{
row["cancel"] = 1;
//row.AcceptChanges();
//row.SetModified();
}
else
{
cancelStatus = 1;
}
}
var commandBuilder =
new MySqlCommandBuilder(adapter2)
{
ConflictOption = ConflictOption.OverwriteChanges
};
adapter2.Update(dt2);
var printForm = _tn.Href;
var customerId = 0;
var organiserId = 0;
if (!string.IsNullOrEmpty(_tn.OrgName))
{
var selectOrg =
$"SELECT id_organizer FROM {AppBuilder.Prefix}organizer WHERE full_name = @full_name";
var cmd3 = new MySqlCommand(selectOrg, connect);
cmd3.Prepare();
cmd3.Parameters.AddWithValue("@full_name", _tn.OrgName);
var dt3 = new DataTable();
var adapter3 = new MySqlDataAdapter {
SelectCommand = cmd3
};
adapter3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
organiserId = (int)dt3.Rows[0].ItemArray[0];
}
else
{
var phone = "";
var email = "";
var contactPerson = "";
var addOrganizer =
$"INSERT INTO {AppBuilder.Prefix}organizer SET full_name = @full_name, contact_phone = @contact_phone, contact_person = @contact_person, contact_email = @contact_email";
var cmd4 = new MySqlCommand(addOrganizer, connect);
cmd4.Prepare();
cmd4.Parameters.AddWithValue("@full_name", _tn.OrgName);
cmd4.Parameters.AddWithValue("@contact_phone", phone);
cmd4.Parameters.AddWithValue("@contact_person", contactPerson);
cmd4.Parameters.AddWithValue("@contact_email", email);
cmd4.ExecuteNonQuery();
organiserId = (int)cmd4.LastInsertedId;
}
}
GetEtp(connect, out var idEtp);
GetPlacingWay(connect, out var idPlacingWay);
var navigator = (HtmlNodeNavigator)htmlDoc.CreateNavigator();
var biddingDateT = (navigator
.SelectSingleNode(
"//td[span[contains(., 'начала') and contains(., 'торгов')]]/following-sibling::td/span")
?.Value ?? "").Trim();
biddingDateT = Regex.Replace(biddingDateT, @"\s+", " ");
var biddingDate = biddingDateT.ParseDateUn("dd.MM.yyyy HH:mm");
if (biddingDate != DateTime.MinValue)
{
biddingDate = biddingDate.AddHours(-4);
}
var scoringDateT = (navigator
.SelectSingleNode(
"//td[span[contains(., 'вскрытия') and contains(., 'конвертов')]]/following-sibling::td/span")
?.Value ?? "").Trim();
scoringDateT = Regex.Replace(scoringDateT, @"\s+", " ");
var scoringDate = scoringDateT.ParseDateUn("dd.MM.yyyy");
if (scoringDate != DateTime.MinValue)
{
scoringDate = scoringDate.AddHours(-4);
}
var insertTender =
$"INSERT INTO {AppBuilder.Prefix}tender SET id_region = @id_region, id_xml = @id_xml, purchase_number = @purchase_number, doc_publish_date = @doc_publish_date, href = @href, purchase_object_info = @purchase_object_info, type_fz = @type_fz, id_organizer = @id_organizer, id_placing_way = @id_placing_way, id_etp = @id_etp, end_date = @end_date, scoring_date = @scoring_date, bidding_date = @bidding_date, cancel = @cancel, date_version = @date_version, num_version = @num_version, notice_version = @notice_version, xml = @xml, print_form = @print_form";
var cmd9 = new MySqlCommand(insertTender, connect);
cmd9.Prepare();
cmd9.Parameters.AddWithValue("@id_region", 0);
cmd9.Parameters.AddWithValue("@id_xml", _tn.PurNum);
cmd9.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd9.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
cmd9.Parameters.AddWithValue("@href", _tn.Href);
cmd9.Parameters.AddWithValue("@purchase_object_info", _tn.PurName);
cmd9.Parameters.AddWithValue("@type_fz", TypeFz);
cmd9.Parameters.AddWithValue("@id_organizer", organiserId);
cmd9.Parameters.AddWithValue("@id_placing_way", idPlacingWay);
cmd9.Parameters.AddWithValue("@id_etp", idEtp);
cmd9.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd9.Parameters.AddWithValue("@scoring_date", scoringDate);
cmd9.Parameters.AddWithValue("@bidding_date", biddingDate);
cmd9.Parameters.AddWithValue("@cancel", cancelStatus);
cmd9.Parameters.AddWithValue("@date_version", dateUpd);
cmd9.Parameters.AddWithValue("@num_version", 1);
cmd9.Parameters.AddWithValue("@notice_version", _tn.Status);
cmd9.Parameters.AddWithValue("@xml", _tn.Href);
cmd9.Parameters.AddWithValue("@print_form", printForm);
var resInsertTender = cmd9.ExecuteNonQuery();
var idTender = (int)cmd9.LastInsertedId;
Counter(resInsertTender, updated);
if (!string.IsNullOrEmpty(_tn.OrgName))
{
var selectCustomer =
$"SELECT id_customer FROM {AppBuilder.Prefix}customer WHERE full_name = @full_name";
var cmd13 = new MySqlCommand(selectCustomer, connect);
cmd13.Prepare();
cmd13.Parameters.AddWithValue("@full_name", _tn.OrgName);
var reader7 = cmd13.ExecuteReader();
if (reader7.HasRows)
{
reader7.Read();
customerId = (int)reader7["id_customer"];
reader7.Close();
}
else
{
reader7.Close();
var insertCustomer =
$"INSERT INTO {AppBuilder.Prefix}customer SET reg_num = @reg_num, full_name = @full_name, is223=1";
var cmd14 = new MySqlCommand(insertCustomer, connect);
cmd14.Prepare();
var customerRegNumber = Guid.NewGuid().ToString();
cmd14.Parameters.AddWithValue("@reg_num", customerRegNumber);
cmd14.Parameters.AddWithValue("@full_name", _tn.OrgName);
cmd14.ExecuteNonQuery();
customerId = (int)cmd14.LastInsertedId;
}
}
var finSource = (navigator
.SelectSingleNode(
"//td[span[contains(., 'Источник финансирования')]]/following-sibling::td/span")
?.Value ?? "").Trim();
var deliveryPlace = (navigator
.SelectSingleNode(
"//td[span[contains(., 'Место') and contains(., 'поставки')]]/following-sibling::td/span")
?.Value ?? "").Trim();
var deliveryTerm = (navigator
.SelectSingleNode(
"//td[span[contains(., 'Сроки') and contains(., 'поставки')]]/following-sibling::td/span")
?.Value ?? "").Trim();
var nmck = (navigator
.SelectSingleNode(
"//td[span[contains(., 'Начальная') and contains(., 'цена')]]/following-sibling::td/a")
?.Value ?? "").Trim();
nmck = nmck.Replace(" ", "").Replace(",", ".");
nmck = Regex.Replace(nmck, @"\s+", "");
var lots = htmlDoc.DocumentNode.SelectNodes(
"//table[@id = 'MainContent_carTabPage_dgProducts_LotPage']//tr") ??
new HtmlNodeCollection(null);
if (lots.Count == 0)
{
var lotNum = 1;
var insertLot =
$"INSERT INTO {AppBuilder.Prefix}lot SET id_tender = @id_tender, lot_number = @lot_number, max_price = @max_price, currency = @currency, finance_source = @finance_source";
var cmd18 = new MySqlCommand(insertLot, connect);
cmd18.Prepare();
cmd18.Parameters.AddWithValue("@id_tender", idTender);
cmd18.Parameters.AddWithValue("@lot_number", lotNum);
cmd18.Parameters.AddWithValue("@max_price", nmck);
cmd18.Parameters.AddWithValue("@currency", "");
cmd18.Parameters.AddWithValue("@finance_source", finSource);
cmd18.ExecuteNonQuery();
var idLot = (int)cmd18.LastInsertedId;
var insertLotitem =
$"INSERT INTO {AppBuilder.Prefix}purchase_object SET id_lot = @id_lot, id_customer = @id_customer, name = @name, sum = @sum";
var cmd19 = new MySqlCommand(insertLotitem, connect);
cmd19.Prepare();
cmd19.Parameters.AddWithValue("@id_lot", idLot);
cmd19.Parameters.AddWithValue("@id_customer", customerId);
cmd19.Parameters.AddWithValue("@name", _tn.PurName);
cmd19.Parameters.AddWithValue("@sum", nmck);
cmd19.ExecuteNonQuery();
if (!string.IsNullOrEmpty(deliveryPlace) || !string.IsNullOrEmpty(deliveryTerm))
{
var insertCustomerRequirement =
$"INSERT INTO {AppBuilder.Prefix}customer_requirement SET id_lot = @id_lot, id_customer = @id_customer, delivery_place = @delivery_place, max_price = @max_price, delivery_term = @delivery_term";
var cmd16 = new MySqlCommand(insertCustomerRequirement, connect);
cmd16.Prepare();
cmd16.Parameters.AddWithValue("@id_lot", idLot);
cmd16.Parameters.AddWithValue("@id_customer", customerId);
cmd16.Parameters.AddWithValue("@delivery_place", deliveryPlace);
cmd16.Parameters.AddWithValue("@max_price", nmck);
cmd16.Parameters.AddWithValue("@delivery_term", deliveryTerm);
cmd16.ExecuteNonQuery();
}
}
else
{
lots.RemoveAt(0);
foreach (var lot in lots)
{
try
{
var numLotT = (lot.SelectSingleNode(".//td[1]")
?.InnerText ?? "1").Trim();
var lotNum = int.Parse(numLotT);
var nameLot = (lot.SelectSingleNode(".//td[2]/a")
?.InnerText ?? "").Trim();
nameLot = nameLot.Replace(" ", " ");
var hrefLot = (lot.SelectSingleNode(".//td[2]/a")
?.Attributes["href"]?.Value ?? "").Trim();
var okei = (lot.SelectSingleNode(".//td[3]")
?.InnerText ?? "").Trim();
var quantity = (lot.SelectSingleNode(".//td[4]")
?.InnerText ?? "").Trim();
var nmckLot = (lot.SelectSingleNode(".//td[5]")
?.InnerText ?? "").Trim();
nmckLot = nmckLot.Replace(" ", "").Replace(",", ".");
nmckLot = Regex.Replace(nmckLot, @"\s+", "");
var insertLot =
$"INSERT INTO {AppBuilder.Prefix}lot SET id_tender = @id_tender, lot_number = @lot_number, max_price = @max_price, currency = @currency, finance_source = @finance_source";
var cmd18 = new MySqlCommand(insertLot, connect);
cmd18.Prepare();
cmd18.Parameters.AddWithValue("@id_tender", idTender);
cmd18.Parameters.AddWithValue("@lot_number", lotNum);
cmd18.Parameters.AddWithValue("@max_price", nmckLot);
cmd18.Parameters.AddWithValue("@currency", "");
cmd18.Parameters.AddWithValue("@finance_source", finSource);
cmd18.ExecuteNonQuery();
var idLot = (int)cmd18.LastInsertedId;
if (!string.IsNullOrEmpty(deliveryPlace) || !string.IsNullOrEmpty(deliveryTerm))
{
var insertCustomerRequirement =
$"INSERT INTO {AppBuilder.Prefix}customer_requirement SET id_lot = @id_lot, id_customer = @id_customer, delivery_place = @delivery_place, max_price = @max_price, delivery_term = @delivery_term";
var cmd16 = new MySqlCommand(insertCustomerRequirement, connect);
cmd16.Prepare();
cmd16.Parameters.AddWithValue("@id_lot", idLot);
cmd16.Parameters.AddWithValue("@id_customer", customerId);
cmd16.Parameters.AddWithValue("@delivery_place", deliveryPlace);
cmd16.Parameters.AddWithValue("@max_price", nmck);
cmd16.Parameters.AddWithValue("@delivery_term", deliveryTerm);
cmd16.ExecuteNonQuery();
}
if (!string.IsNullOrEmpty(hrefLot))
{
hrefLot = $"http://agro.zakupki.tomsk.ru/Competition/{hrefLot}";
hrefLot = hrefLot.Replace("&", "&");
var po = DownloadString.DownL1251(hrefLot);
if (string.IsNullOrEmpty(po))
{
Log.Logger("Empty string in parser PO", hrefLot);
continue;
}
var htmlPo = new HtmlDocument();
htmlPo.LoadHtml(po);
var poList =
htmlPo.DocumentNode.SelectNodes(
"//table[@rules = 'all' and @bordercolor = 'black']//tr") ??
new HtmlNodeCollection(null);
if (poList.Count != 0)
{
poList.RemoveAt(0);
foreach (var pp in poList)
{
var namePo = (pp.SelectSingleNode(".//td[1]/span")
?.InnerText ?? "").Trim();
namePo = $"{nameLot} {namePo}".Trim();
namePo = namePo.Replace(" ", " ");
var okeiP = (pp.SelectSingleNode(".//td[2]/span")
?.InnerText ?? "").Trim();
okeiP = okeiP.Replace(" ", " ");
var quantityP = (pp.SelectSingleNode(".//td[3]/span")
?.InnerText ?? "").Trim();
quantityP = quantityP.Replace(" ", "").Replace(",", ".");
quantityP = Regex.Replace(quantityP, @"\s+", "");
var insertLotitem =
$"INSERT INTO {AppBuilder.Prefix}purchase_object SET id_lot = @id_lot, id_customer = @id_customer, name = @name, quantity_value = @quantity_value, okei = @okei, customer_quantity_value = @customer_quantity_value";
var cmd19 = new MySqlCommand(insertLotitem, connect);
cmd19.Prepare();
cmd19.Parameters.AddWithValue("@id_lot", idLot);
cmd19.Parameters.AddWithValue("@id_customer", customerId);
cmd19.Parameters.AddWithValue("@name", namePo);
cmd19.Parameters.AddWithValue("@quantity_value", quantityP);
cmd19.Parameters.AddWithValue("@okei", okeiP);
cmd19.Parameters.AddWithValue("@customer_quantity_value", quantityP);
cmd19.ExecuteNonQuery();
}
}
}
}
catch (Exception e)
{
Log.Logger(e);
}
}
}
TenderKwords(connect, idTender);
AddVerNumber(connect, _tn.PurNum, TypeFz);
}
}
private void update_Click(object sender, EventArgs e)
{
scb = new MySqlCommandBuilder(sda);
sda.Update(dbdataset);
}
public static int updateData(MySqlCommand command, DataTable sourceTable)
{
int executionResult = 0;
//Creating the connection object and assigning it to the command object
MySqlConnection conn = getConnection(BUDGET_MANAGER_CONN_STRING);
command.Connection = conn;
//Creating the transaction(it is created here and initialised to null to allow its use in the catch block)
MySqlTransaction tx = null;
//Creating the DataAdapter object for updating the DB with the changes performed by the user in the GUI
MySqlDataAdapter dataAdapter = getDataAdapter(command);
//Creating the CommandBuilder object for the automatic creation of the INSERT, UPDATE, DELETE commands which will reflect the changes from the source DataTable into the DB
MySqlCommandBuilder commandBuilder = new MySqlCommandBuilder(dataAdapter);
try {
conn.Open();
tx = conn.BeginTransaction();
command.Transaction = tx;
//The number of affected rows after the execution of the SQL statement command is stored in this variable(if the number is greater than 0 is means that the command was executed successfully otherwise it means that it has failed)
executionResult = dataAdapter.Update(sourceTable);
sourceTable.AcceptChanges();
//The changes are submitted to the DB
tx.Commit();
} catch (MySqlException ex) {
//Retrieving the error code
int errorCode = ex.Number;
//The message is composed based on the error code returned (in order to improve the error understanding for the end user)
String message;
if (errorCode == 1042)
{
message = "Unable to connect to the database! Please check the connection and try again.";
}
else
{
message = ex.Message;
}
MessageBox.Show(message, "DBConnectionManager", MessageBoxButtons.OK, MessageBoxIcon.Error);
//Null check for the transaction object to avoid NPE when there's no DB connectionn(in that case the transaction remains null since the conn.Object() statement throws an exception and the rest of the code is not executed anymore)
if (tx != null)
{
tx.Rollback();//Reverting the DB to its original state
}
} finally {
conn.Close();
}
//If the execution was successfull the number of affected rows is returned, otherwise the method returns -1 which means that the update operation failed
if (executionResult != 0)
{
return(executionResult);
}
return(-1);
}
public void ParsingTender()
{
using (var connect = ConnectToDb.GetDbConnection())
{
connect.Open();
var selectTend =
$"SELECT id_tender FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND end_date = @end_date AND type_fz = @type_fz AND doc_publish_date = @doc_publish_date";
var cmd = new MySqlCommand(selectTend, connect);
cmd.Prepare();
cmd.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd.Parameters.AddWithValue("@type_fz", TypeFz);
cmd.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
var dt = new DataTable();
var adapter = new MySqlDataAdapter { SelectCommand = cmd };
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Log.Logger("This tender is exist in base", PurNum);
return;
}
var dateUpd = DateTime.Now;
var cancelStatus = 0;
var updated = false;
var selectDateT =
$"SELECT id_tender, date_version, cancel FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND type_fz = @type_fz";
var cmd2 = new MySqlCommand(selectDateT, connect);
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd2.Parameters.AddWithValue("@type_fz", TypeFz);
var adapter2 = new MySqlDataAdapter { SelectCommand = cmd2 };
var dt2 = new DataTable();
adapter2.Fill(dt2);
foreach (DataRow row in dt2.Rows)
{
//DateTime dateNew = DateTime.Parse(pr.DatePublished);
updated = true;
if (dateUpd >= (DateTime)row["date_version"])
{
row["cancel"] = 1;
//row.AcceptChanges();
//row.SetModified();
}
else
{
cancelStatus = 1;
}
}
var commandBuilder =
new MySqlCommandBuilder(adapter2) { ConflictOption = ConflictOption.OverwriteChanges };
adapter2.Update(dt2);
var printForm = _tn.Href;
var customerId = 0;
var organiserId = 0;
if (!string.IsNullOrEmpty(_tn.OrgName))
{
var selectOrg =
$"SELECT id_organizer FROM {AppBuilder.Prefix}organizer WHERE full_name = @full_name";
var cmd3 = new MySqlCommand(selectOrg, connect);
cmd3.Prepare();
cmd3.Parameters.AddWithValue("@full_name", _tn.OrgName);
var dt3 = new DataTable();
var adapter3 = new MySqlDataAdapter { SelectCommand = cmd3 };
adapter3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
organiserId = (int)dt3.Rows[0].ItemArray[0];
}
else
{
var phone = "";
var email = "";
var contactPerson = "";
var addOrganizer =
$"INSERT INTO {AppBuilder.Prefix}organizer SET full_name = @full_name, contact_phone = @contact_phone, contact_person = @contact_person, contact_email = @contact_email";
var cmd4 = new MySqlCommand(addOrganizer, connect);
cmd4.Prepare();
cmd4.Parameters.AddWithValue("@full_name", _tn.OrgName);
cmd4.Parameters.AddWithValue("@contact_phone", phone);
cmd4.Parameters.AddWithValue("@contact_person", contactPerson);
cmd4.Parameters.AddWithValue("@contact_email", email);
cmd4.ExecuteNonQuery();
organiserId = (int)cmd4.LastInsertedId;
}
}
const int idPlacingWay = 0;
GetEtp(connect, out var idEtp);
var insertTender =
$"INSERT INTO {AppBuilder.Prefix}tender SET id_region = @id_region, id_xml = @id_xml, purchase_number = @purchase_number, doc_publish_date = @doc_publish_date, href = @href, purchase_object_info = @purchase_object_info, type_fz = @type_fz, id_organizer = @id_organizer, id_placing_way = @id_placing_way, id_etp = @id_etp, end_date = @end_date, scoring_date = @scoring_date, bidding_date = @bidding_date, cancel = @cancel, date_version = @date_version, num_version = @num_version, notice_version = @notice_version, xml = @xml, print_form = @print_form";
var cmd9 = new MySqlCommand(insertTender, connect);
cmd9.Prepare();
cmd9.Parameters.AddWithValue("@id_region", 0);
cmd9.Parameters.AddWithValue("@id_xml", _tn.PurNum);
cmd9.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd9.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
cmd9.Parameters.AddWithValue("@href", _tn.Href);
cmd9.Parameters.AddWithValue("@purchase_object_info", _tn.PurName);
cmd9.Parameters.AddWithValue("@type_fz", TypeFz);
cmd9.Parameters.AddWithValue("@id_organizer", organiserId);
cmd9.Parameters.AddWithValue("@id_placing_way", idPlacingWay);
cmd9.Parameters.AddWithValue("@id_etp", idEtp);
cmd9.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd9.Parameters.AddWithValue("@scoring_date", DateTime.MinValue);
cmd9.Parameters.AddWithValue("@bidding_date", DateTime.MinValue);
cmd9.Parameters.AddWithValue("@cancel", cancelStatus);
cmd9.Parameters.AddWithValue("@date_version", dateUpd);
cmd9.Parameters.AddWithValue("@num_version", 1);
cmd9.Parameters.AddWithValue("@notice_version", "");
cmd9.Parameters.AddWithValue("@xml", _tn.Href);
cmd9.Parameters.AddWithValue("@print_form", printForm);
var resInsertTender = cmd9.ExecuteNonQuery();
var idTender = (int)cmd9.LastInsertedId;
Counter(resInsertTender, updated);
try
{
GetDocuments(idTender, connect);
}
catch (Exception e)
{
Log.Logger(e);
}
const int lotNum = 1;
var insertLot =
$"INSERT INTO {AppBuilder.Prefix}lot SET id_tender = @id_tender, lot_number = @lot_number, max_price = @max_price, currency = @currency";
var cmd18 = new MySqlCommand(insertLot, connect);
cmd18.Prepare();
cmd18.Parameters.AddWithValue("@id_tender", idTender);
cmd18.Parameters.AddWithValue("@lot_number", lotNum);
cmd18.Parameters.AddWithValue("@max_price", "");
cmd18.Parameters.AddWithValue("@currency", "");
cmd18.ExecuteNonQuery();
var idLot = (int)cmd18.LastInsertedId;
if (!string.IsNullOrEmpty(_tn.OrgName))
{
var selectCustomer =
$"SELECT id_customer FROM {AppBuilder.Prefix}customer WHERE full_name = @full_name";
var cmd13 = new MySqlCommand(selectCustomer, connect);
cmd13.Prepare();
cmd13.Parameters.AddWithValue("@full_name", _tn.OrgName);
var reader7 = cmd13.ExecuteReader();
if (reader7.HasRows)
{
reader7.Read();
customerId = (int)reader7["id_customer"];
reader7.Close();
}
else
{
reader7.Close();
var insertCustomer =
$"INSERT INTO {AppBuilder.Prefix}customer SET reg_num = @reg_num, full_name = @full_name, is223=1";
var cmd14 = new MySqlCommand(insertCustomer, connect);
cmd14.Prepare();
var customerRegNumber = Guid.NewGuid().ToString();
cmd14.Parameters.AddWithValue("@reg_num", customerRegNumber);
cmd14.Parameters.AddWithValue("@full_name", _tn.OrgName);
cmd14.ExecuteNonQuery();
customerId = (int)cmd14.LastInsertedId;
}
}
var insertLotitem =
$"INSERT INTO {AppBuilder.Prefix}purchase_object SET id_lot = @id_lot, id_customer = @id_customer, name = @name, sum = @sum";
var cmd19 = new MySqlCommand(insertLotitem, connect);
cmd19.Prepare();
cmd19.Parameters.AddWithValue("@id_lot", idLot);
cmd19.Parameters.AddWithValue("@id_customer", customerId);
cmd19.Parameters.AddWithValue("@name", _tn.PurName);
cmd19.Parameters.AddWithValue("@sum", "");
cmd19.ExecuteNonQuery();
TenderKwords(connect, idTender);
AddVerNumber(connect, _tn.PurNum, TypeFz);
}
}
public static void GrabarDbDetalle(DataSet dt, MySqlConnection conn, MySqlTransaction tr)
{
MySqlDataAdapter da = AdaptadorAbmDetalle(conn, tr);
da.Update(dt, "VentasDetalle");
}
public static void GrabarDbVentas(DataSet dt, MySqlConnection conn, MySqlTransaction tr)
{
MySqlDataAdapter da = AdaptadorAbmVentas(dt, conn, tr);
da.Update(dt, "Ventas");
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 9)
{
string task = dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString();
if (task == "Delete")
{
if (MessageBox.Show("Удавить эту строку?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
== DialogResult.Yes)
{
int rowIndex = e.RowIndex;
dataGridView1.Rows.RemoveAt(rowIndex);
dataSet.Tables["project implementation"].Rows[rowIndex].Delete();
SqlDataAdapter.Update(dataSet, "project implementation");
}
}
else if (task == "Insert") // заполнение с конца + Project ID нужно ввести
{
int rowIndex = dataGridView1.Rows.Count - 2;
DataRow row = dataSet.Tables["project implementation"].NewRow();
row["Project_ID"] = dataGridView1.Rows[rowIndex].Cells["Project_ID"].Value;
row["Equipment list"] = dataGridView1.Rows[rowIndex].Cells["Equipment list"].Value;
row["Services"] = dataGridView1.Rows[rowIndex].Cells["Services"].Value;
row["Data"] = dataGridView1.Rows[rowIndex].Cells["Data"].Value;
row["Time"] = dataGridView1.Rows[rowIndex].Cells["Time"].Value;
row["Cabinets"] = dataGridView1.Rows[rowIndex].Cells["Cabinets"].Value;
row["Customer"] = dataGridView1.Rows[rowIndex].Cells["Customer"].Value;
row["Project Manager"] = dataGridView1.Rows[rowIndex].Cells["Project Manager"].Value;
row["Customer_ID"] = dataGridView1.Rows[rowIndex].Cells["Customer_ID"].Value;
dataSet.Tables["project implementation"].Rows.Add(row);
dataSet.Tables["project implementation"].Rows.RemoveAt(dataSet.Tables["project implementation"].Rows.Count - 1);
dataGridView1.Rows.RemoveAt(dataGridView1.Rows.Count - 2);
dataGridView1.Rows[e.RowIndex].Cells[9].Value = "Delete";
SqlDataAdapter.Update(dataSet, "project implementation");
NewRowAdding = false; // Update New Rows
}
else if (task == "Update")
{
int r = e.RowIndex;
dataSet.Tables["project implementation"].Rows[r]["Project_ID"] = dataGridView1.Rows[r].Cells["Project_ID"].Value;
dataSet.Tables["project implementation"].Rows[r]["Equipment list"] = dataGridView1.Rows[r].Cells["Equipment list"].Value;
dataSet.Tables["project implementation"].Rows[r]["Services"] = dataGridView1.Rows[r].Cells["Services"].Value;
dataSet.Tables["project implementation"].Rows[r]["Data"] = dataGridView1.Rows[r].Cells["Data"].Value;
dataSet.Tables["project implementation"].Rows[r]["Time"] = dataGridView1.Rows[r].Cells["Time"].Value;
dataSet.Tables["project implementation"].Rows[r]["Cabinets"] = dataGridView1.Rows[r].Cells["Cabinets"].Value;
dataSet.Tables["project implementation"].Rows[r]["Customer"] = dataGridView1.Rows[r].Cells["Customer"].Value;
dataSet.Tables["project implementation"].Rows[r]["Project Manager"] = dataGridView1.Rows[r].Cells["Project Manager"].Value;
dataSet.Tables["project implementation"].Rows[r]["Customer_ID"] = dataGridView1.Rows[r].Cells["Customer_ID"].Value;
SqlDataAdapter.Update(dataSet, "project implementation");
dataGridView1.Rows[e.RowIndex].Cells[9].Value = "Delete";
}
ReloadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка А103", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Insert()
{
var timerSQL = new Stopwatch();
timerSQL.Start();
var collectionCompanyFromFile = DeSerializeObject <List <CompanyModels> >("SerializationOverview");
// BULKING
DataTable tbl = new DataTable();
tbl.Columns.Add(new DataColumn("Id", typeof(string)));
tbl.Columns.Add(new DataColumn("CompanyId", typeof(string)));
tbl.Columns.Add(new DataColumn("RegistrationNumber", typeof(string)));
tbl.Columns.Add(new DataColumn("Name", typeof(string)));
tbl.Columns.Add(new DataColumn("NIP", typeof(string)));
tbl.Columns.Add(new DataColumn("Pesel", typeof(string)));
tbl.Columns.Add(new DataColumn("Country", typeof(string)));
tbl.Columns.Add(new DataColumn("Address", typeof(string)));
tbl.Columns.Add(new DataColumn("PostalCode", typeof(string)));
tbl.Columns.Add(new DataColumn("Teryt", typeof(string)));
foreach (var item in collectionCompanyFromFile)
{
DataRow row = tbl.NewRow();
row["Id"] = item.Id;
row["CompanyId"] = item.CompanyId;
row["RegistrationNumber"] = item.RegistrationNumber;
row["Name"] = item.Name;
row["NIP"] = item.NIP;
row["Pesel"] = item.Pesel;
row["Country"] = item.Country;
row["Address"] = item.Address;
row["PostalCode"] = item.PostalCode;
row["Teryt"] = item.Teryt;
tbl.Rows.Add(row);
}
using (var sqlConnection = new MySqlConnection(_connectionString))
{
sqlConnection.Open();
using (MySqlTransaction tran = sqlConnection.BeginTransaction(IsolationLevel.Serializable))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = sqlConnection;
cmd.Transaction = tran;
cmd.CommandText = "SELECT * FROM Company";
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
da.UpdateBatchSize = 1000;
using (MySqlCommandBuilder cb = new MySqlCommandBuilder(da))
{
da.Update(tbl);
tran.Commit();
}
}
}
}
}
// WITHOUT BULKING
//using (MySqlConnection sqlConnection = new MySqlConnection(_connectionString))
//{
// sqlConnection.Open();
// foreach (var item in collectionCompanyFromFile)
// {
// string sqlInsert = "INSERT INTO Company (Id,CompanyId,RegistrationNumber,Name,NIP,Pesel,Country,Address,PostalCode,Teryt) " +
// "VALUES ('" + item.Id + "','" + item.CompanyId + "','" + item.RegistrationNumber + "','" + item.Name + "','" + item.NIP + "','" + item.Pesel + "','" + item.Country + "','" + item.Address + "','" + item.PostalCode + "','" + item.Teryt + "')";
// MySqlCommand mySqlCmd = new MySqlCommand(sqlInsert, sqlConnection);
// mySqlCmd.ExecuteNonQuery();
// }
//}
timerSQL.Stop();
TimeSpan timeTaken = timerSQL.Elapsed;
var timeLog = timeTaken.ToString();
var logs = new LogModels();
logs.OperationDate = DateTime.Now;
logs.Database = "SQL-MySQL";
logs.OperationTime = timeLog;
logs.OperationName = "INSERT";
logs.NameAPI = "SearchCompany";
logs.NumberOfRecords = dbSQL.LogModels.FirstOrDefault(m => m.OperationName == "LOAD").NumberOfRecords;
logs.NumberOfFieldsModel = dbSQL.LogModels.FirstOrDefault(m => m.OperationName == "LOAD").NumberOfFieldsModel;
logs.SizeFile = dbSQL.LogModels.FirstOrDefault(m => m.OperationName == "LOAD").SizeFile;
logs.EntityFramework = true;
logs.BulkLoading = false;
logs.NoTracing = false;
dbSQL.LogModels.Add(logs);
dbSQL.SaveChanges();
return(RedirectToAction("Index"));
}
private void UpdateAdmissions()
{
_admissionsAdapter.Update(AdmissionsTable);
}
private void button13_Click_1(object sender, EventArgs e)//generating ot upgrading prescriptions
{
doctorSQL checkforPRID = new doctorSQL();
if (button13.Text == "GENERATE PRESCRIPTION")
{
try
{
//gnerating prescription
checkforPRID.generateprescription(label65.Text, textBox17.Text, textBox15.Text + " " + textBox13.Text, this.special_id, this.name, label66.Text);
//updating diagnose
checkforPRID.UPdateDIAGNOSE(textBox17.Text, textBox20.Text);
MessageBox.Show("Prescription generated successfully", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Please contact support", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
string query = "datasource=35.194.46.32;port=3306;username=m3dic;password=\"M3dic\"";
//making connection
MySqlConnection conDataBase = new MySqlConnection(query);
MySqlCommand cmdDataBase = new MySqlCommand($"select patient_id as 'Special ID', patient_name as 'Name', dignose from M3dic.patients_appointment where doctor_name = '{this.name}' ", conDataBase);
try
{
//getting query
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bSorce = new BindingSource();
bSorce.DataSource = dbdataset;
dataGridView2.DataSource = bSorce;
sda.Update(dbdataset);
}
catch (Exception)
{
MessageBox.Show("Database error, please contact support", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
//updating dagnose
checkforPRID.UPdateDIAGNOSE(textBox17.Text, textBox20.Text);
MessageBox.Show("Prescription updated successfully", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
string query = "datasource=35.194.46.32;port=3306;username=m3dic;password=\"M3dic\"";
MySqlConnection conDataBase = new MySqlConnection(query);
MySqlCommand cmdDataBase = new MySqlCommand($"select patient_id as 'Special ID', patient_name as 'Name', dignose from M3dic.patients_appointment where doctor_name = '{this.name}' ", conDataBase);
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bSorce = new BindingSource();
bSorce.DataSource = dbdataset;
dataGridView2.DataSource = bSorce;
sda.Update(dbdataset);
}
catch (Exception)
{
MessageBox.Show("Database error, please contact support", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void UpdateDataSet()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, blob1 LONGBLOB, text1 LONGTEXT, PRIMARY KEY(id))");
execSQL("INSERT INTO Test VALUES( 1, NULL, 'Text field' )");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
string s = (string)dt.Rows[0][2];
Assert.AreEqual("Text field", s);
byte[] inBuf = Utils.CreateBlob(512);
dt.Rows[0].BeginEdit();
dt.Rows[0]["blob1"] = inBuf;
dt.Rows[0].EndEdit();
DataTable changes = dt.GetChanges();
da.Update(changes);
dt.AcceptChanges();
dt.Clear();
da.Fill(dt);
cb.Dispose();
byte[] outBuf = (byte[])dt.Rows[0]["blob1"];
Assert.AreEqual(inBuf.Length, outBuf.Length,
"checking length of updated buffer");
for (int y = 0; y < inBuf.Length; y++)
Assert.AreEqual(inBuf[y], outBuf[y], "checking array data");
}
// View debtor filter by PRODUCT NAME.
public void viewDebtorFilterBystockID()
{
try
{
string db = databaseConnectionStringTextBox.Text;
DateTime dtt = DateTime.Now;
string dateNow = dtt.ToString("yyyy-MM-dd");
MySqlCommand com = new MySqlCommand("SELECT `debtor`.`id` AS 'DEBTOR ID',`debtor`.`name` AS 'NAME',`product`.`name` AS 'PRODUCT NAME',`debtor`.`quantity` AS 'QUANTITY',`debtor`.`price` AS 'PRICE',(`debtor`.`quantity`*`debtor`.`price`) AS 'AMOUNT',((`debtor`.`quantity`*`debtor`.`price`)-`debtor`.`deposit`) AS 'BALANCE',`debtor`.`date_borrowed` AS 'DATE BORROWED',`debtor`.`phone` AS 'PHONE',`debtor`.`deposit` AS 'DEPOSIT',`debtor`.`date_of_payment` AS 'DATE OF PAYMENT',`debtor`.`pfno` AS 'REGISTERED BY',`debtor`.`registered_date` AS 'REGISTRATION DATE',`debtor`.`stock_id` AS 'STOCK ID' FROM `product` JOIN `stock` ON `product`.`id`=`stock`.`product_id` JOIN `debtor` ON `stock`.`stock_id`=`debtor`.`stock_id` WHERE (((`debtor`.`quantity`*`debtor`.`price`)>`debtor`.`deposit`) AND (`debtor`.`id`='" + this.searchDebtorIDTextBox.Text + "') AND (`debtor`.`quantity` > 0)) ORDER BY `product`.`name` ASC", con);
MySqlDataAdapter a = new MySqlDataAdapter();
a.SelectCommand = com;
dataTable = new DataTable();
// Add autoincrement column.
dataTable.Columns.Add("#", typeof(string));
dataTable.PrimaryKey = new DataColumn[] { dataTable.Columns["#"] };
dataTable.Columns["#"].AutoIncrement = true;
dataTable.Columns["#"].AutoIncrementSeed = 1;
dataTable.Columns["#"].ReadOnly = true;
// End adding AI column.
// Format titles.
dataTable.Columns.Add("DEBTOR ID");
dataTable.Columns.Add("NAME");
dataTable.Columns.Add("PRODUCT NAME");
dataTable.Columns.Add("QUANTITY");
dataTable.Columns.Add("PRICE");
dataTable.Columns.Add("AMOUNT");
dataTable.Columns.Add("DEPOSIT");
dataTable.Columns.Add("BALANCE");
dataTable.Columns.Add("DATE BORROWED", typeof(string));
dataTable.Columns.Add("PHONE");
dataTable.Columns.Add("DATE OF PAYMENT", typeof(string));
dataTable.Columns.Add("REGISTERED BY");
dataTable.Columns.Add("REGISTRATION DATE", typeof(string));
dataTable.Columns.Add("STOCK ID");
// End formating titles.
a.Fill(dataTable);
BindingSource bs = new BindingSource();
bs.DataSource = dataTable;
debtroReportDataGridView.DataSource = bs;
a.Update(dataTable);
// Count number of rows to return records.
Int64 count = Convert.ToInt64(debtroReportDataGridView.Rows.Count) - 1;
rowCountLabel.Text = count.ToString() + " Records";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
amount();
DepositAmount();
RemainingAmount();
}
public void InsertDateTimeValue()
{
using (MySqlConnection c = new MySqlConnection(conn.ConnectionString +
";allow zero datetime=yes"))
{
c.Open();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT id, dt FROM Test", c);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("id", typeof(int)));
dt.Columns.Add(new DataColumn("dt", typeof(DateTime)));
da.Fill(dt);
DateTime now = DateTime.Now;
DataRow row = dt.NewRow();
row["id"] = 1;
row["dt"] = now;
dt.Rows.Add(row);
da.Update(dt);
dt.Clear();
da.Fill(dt);
cb.Dispose();
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(now.Date, ((DateTime)dt.Rows[0]["dt"]).Date);
}
}
private void TabControl_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (e.Source is TabControl)
{
if (users_tab.IsSelected)
{
//users
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select * from users", connection);
MySqlDataAdapter user_adapter = new MySqlDataAdapter(command);
DataTable dt = new DataTable("users");
user_adapter.Fill(dt);
Users_datatable.ItemsSource = dt.DefaultView;
user_adapter.Update(dt);
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (aggelies_tab.IsSelected)
{
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select * from ads", connection);
MySqlDataAdapter user_adapter = new MySqlDataAdapter(command);
DataTable dt = new DataTable("ads");
user_adapter.Fill(dt);
Ads_datatable.ItemsSource = dt.DefaultView;
user_adapter.Update(dt);
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (actions_tab.IsSelected)
{
}
if (alerts_tab.IsSelected)
{
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select * from ads where ban_status='alert' ", connection);
MySqlDataAdapter addresses_adapter = new MySqlDataAdapter(command);
DataTable dt = new DataTable("ads");
addresses_adapter.Fill(dt);
alerts_datatable.ItemsSource = dt.DefaultView;
addresses_adapter.Update(dt);
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (addresses_tab.IsSelected)
{
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select * from addresses", connection);
MySqlDataAdapter addresses_adapter = new MySqlDataAdapter(command);
DataTable dt = new DataTable("addresses");
addresses_adapter.Fill(dt);
Addresses_datatable.ItemsSource = dt.DefaultView;
addresses_adapter.Update(dt);
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.Text == "Quiz")
{
string constring = "Server=localhost;Database=GradingSystem;Uid=root;Pwd=";
MySqlConnection condatabase = new MySqlConnection(constring);
MySqlCommand cmddatabase = new MySqlCommand("Select QuizNo,Score,Items from Quiz ", condatabase);
try
{
MySqlDataAdapter loaddb = new MySqlDataAdapter();
loaddb.SelectCommand = cmddatabase;
dtable = new DataTable();
loaddb.Fill(dtable);
BindingSource bsource = new BindingSource();
bsource.DataSource = dtable;
dataGridView2.DataSource = bsource;
loaddb.Update(dtable);
btnscore.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (comboBox1.Text == "Seatwork")
{
string constring = "Server=localhost;Database=GradingSystem;Uid=root;Pwd=";
MySqlConnection condatabase = new MySqlConnection(constring);
MySqlCommand cmddatabase = new MySqlCommand("Select SeatworkNo , Score , Items from Seatwork ", condatabase);
try
{
MySqlDataAdapter loaddb = new MySqlDataAdapter();
loaddb.SelectCommand = cmddatabase;
dtable = new DataTable();
loaddb.Fill(dtable);
BindingSource bsource = new BindingSource();
bsource.DataSource = dtable;
dataGridView2.DataSource = bsource;
loaddb.Update(dtable);
btnscore.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (comboBox1.Text == "Attendance")
{
string constring = "Server=localhost;Database=GradingSystem;Uid=root;Pwd=";
MySqlConnection condatabase = new MySqlConnection(constring);
MySqlCommand cmddatabase = new MySqlCommand("Select MonthDesc as 'Month' , PresentDays , AbsentDays from attendance ", condatabase);
try
{
MySqlDataAdapter loaddb = new MySqlDataAdapter();
loaddb.SelectCommand = cmddatabase;
dtable = new DataTable();
loaddb.Fill(dtable);
BindingSource bsource = new BindingSource();
bsource.DataSource = dtable;
dataGridView2.DataSource = bsource;
loaddb.Update(dtable);
btnscore.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void BunifuThinButton21_Click_1(object sender, EventArgs e)
{
messe mi = new messe();
mi.ShowDialog();
DateTime std = bunifuDatepicker1.Value.Date;
DateTime end = bunifuDatepicker2.Value.Date;
int dd = std.Day;
int mm = std.Month;
int yyyy = std.Year;
int dd1 = end.Day;
int mm1 = end.Month;
int yyyy1 = end.Year;
Manager m = new Manager()
{
Id = Login.SetValueForId.ToString()
};
Dao tm = new Dao();
tm.Connect();
tm.takeManagerDepartment(m);
tm.Disconnect();
try
{
string myConnection = "datasource=localhost;port=3306;username=root;password="******"SELECT leavedescription.employeeid as 'NIC',Employee.FIRSTNAME as 'first name',employee.lasTNAME as 'last name',leavedescription.description,leavedescription.type as 'type', leavedescription.fromd as 'from', leavedescription.tod as 'to', leavedescription.tempDif as 'Number of dates',Employee.sickC as 'available sick leaves',Employee.casualC as 'available casual leaves',Employee.pregnantC as 'available pregnant leaves',Employee.withoutC as 'available without pay leaves' FROM aurora.employee INNER JOIN aurora.leavedescription ON aurora.employee.id = aurora.leavedescription.employeeid where leavedescription.accept=1 and employee.Department='" + m.Department + "' and tod between '" + yyyy + "-" + mm + "-" + dd + "' and '" + yyyy1 + "-" + mm1 + "-" + dd1 + "' ;", myCon);
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable ta = new DataTable();
sda.Fill(ta);
BindingSource BS = new BindingSource();
BS.DataSource = ta;
bunifuCustomDataGrid1.DataSource = BS;
sda.Update(ta);
myCon.Close();
}
catch (Exception ex)
{
}
Manager mw = new Manager()
{
Id = Login.SetValueForId.ToString()
};
Dao d = new Dao();
d.Connect();
d.takeManagerDepartment(m);
d.Disconnect();
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(messe.dname + ".pdf", FileMode.Create));
doc.Open();
Paragraph pa = new Paragraph("\t" + "This report include all the details related to " + m.Department + "department.\n" + "\n\n\n");
doc.Add(pa);
PdfPTable table = new PdfPTable(bunifuCustomDataGrid1.Columns.Count);
for (int j = 0; j < bunifuCustomDataGrid1.Columns.Count; j++)
{
table.AddCell(new Phrase(bunifuCustomDataGrid1.Columns[j].HeaderText));
}
table.HeaderRows = 1;
for (int i = 0; i < bunifuCustomDataGrid1.Rows.Count; i++)
{
for (int k = 0; k < bunifuCustomDataGrid1.Columns.Count; k++)
{
if (bunifuCustomDataGrid1[k, i].Value != null)
{
table.AddCell(new Phrase(bunifuCustomDataGrid1[k, i].Value.ToString()));
}
}
}
doc.Add(table);
doc.Close();
}
public void AutoIncrementColumnsOnInsert2()
{
execSQL("CREATE TABLE Test (id INT UNSIGNED NOT NULL " +
"AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
MySqlCommand cmd = (MySqlCommand)(cb.GetInsertCommand() as ICloneable).Clone();
cmd.CommandText += "; SELECT last_insert_id() as id";
cmd.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
da.InsertCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows.Clear();
DataRow row = dt.NewRow();
row["name"] = "Test";
dt.Rows.Add(row);
da.Update(dt);
Assert.AreEqual(1, dt.Rows[0]["id"]);
Assert.AreEqual("Test", dt.Rows[0]["name"]);
row = dt.NewRow();
row["name"] = "Test2";
dt.Rows.Add(row);
da.Update(dt);
Assert.AreEqual(2, dt.Rows[1]["id"]);
Assert.AreEqual("Test2", dt.Rows[1]["name"]);
Assert.AreEqual(1, dt.Rows[0]["id"]);
}
private void getContactList()
{
string query;
query = @"select * from
(
SELECT
date `DATE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
dob `BIRTHDAY`,
age `AGE`,
IF(sex = 'MALE','M','F') `GENDER`,
civil_status `CIVIL STATUS`,
religion `RELIGION`,
birthplace `BIRTHPLACE`,
concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`,
email `EMAIL`,
cp_no `CONTACT`,
`4ps` `4Ps`,
emp_status `EMP. STATUS`,
job_pre `JOB PREF.`,
educ_level `EDUC. LEVEL`,
skills `SKILLS`,
`from` `FROM`
FROM schoolar_coll
union all
SELECT
event_date `DATE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
dob `BIRTHDAY`,
age `AGE`,
IF(sex = 'MALE','M','F') `GENDER`,
civil_status `CIVIL STATUS`,
religion `RELIGION`,
'BIRTHPLACE' `BIRTHPLACE`,
concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`,
email `EMAIL`,
cp_no `CONTACT`,
`4ps` `4Ps`,
emp_status `EMP. STATUS`,
job_pre `JOB PREF.`,
educ_level `EDUC. LEVEL`,
skills `SKILLS`,
`from` `FROM`
FROM sra2
union all
SELECT
event_date `DATE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
dob `BIRTHDAY`,
age `AGE`,
IF(sex = 'MALE','M','F') `GENDER`,
civil_status `CIVIL STATUS`,
religion `RELIGION`,
'BIRTHPLACE' `BIRTHPLACE`,
concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`,
email `EMAIL`,
cp_no `CONTACT`,
`4ps` `4Ps`,
emp_status `EMP. STATUS`,
job_pre `JOB PREF.`,
educ_level `EDUC. LEVEL`,
skills `SKILLS`,
`from` `FROM`
FROM jobfair2
union all
SELECT
date `DATE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
dob `BIRTHDAY`,
age `AGE`,
IF(sex = 'MALE','M','F') `GENDER`,
civil_status `CIVIL STATUS`,
religion `RELIGION`,
'BIRTHPLACE' `BIRTHPLACE`,
concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`,
email `EMAIL`,
cp_no `CONTACT`,
`4ps` `4Ps`,
emp_status `EMP. STATUS`,
job_pre `JOB PREF.`,
educ_level `EDUC. LEVEL`,
skills `SKILLS`,
`from` `FROM`
FROM kasambahay2
union all
SELECT
date `DATE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
dob `BIRTHDAY`,
age `AGE`,
IF(sex = 'MALE','M','F') `GENDER`,
civil_status `CIVIL STATUS`,
religion `RELIGION`,
'BIRTHPLACE' `BIRTHPLACE`,
concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`,
email `EMAIL`,
cp_no `CONTACT`,
`4ps` `4Ps`,
emp_status `EMP. STATUS`,
job_pre `JOB PREF.`,
educ_level `EDUC. LEVEL`,
skills `SKILLS`,
`from` `FROM`
FROM ofw2
) fin
where `from` like '%%{0}%%'
order by date asc";
string FinalQuery = string.Format(query, comboBox2.Text);
MySqlConnection conn = new MySqlConnection(DBConn.connstring);
MySqlCommand cmd = new MySqlCommand(FinalQuery, conn);
try
{
MySqlDataAdapter dgv = new MySqlDataAdapter();
dgv.SelectCommand = cmd;
DataTable dbdatasec = new DataTable();
dgv.Fill(dbdatasec);
BindingSource bsource = new BindingSource();
bsource.DataSource = dbdatasec;
dataGridView1.DataSource = bsource;
dgv.Update(dbdatasec);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
public void UpdateReturnFirstRecord()
{
string createTable =
"CREATE TABLE `bugtable` ( " +
"`id_auto` int(11) NOT NULL AUTO_INCREMENT," +
"`field` varchar(50) DEFAULT NULL," +
"counter int NOT NULL DEFAULT 0," +
"PRIMARY KEY (`id_auto`)" +
")";
string procGetAll =
"CREATE PROCEDURE sp_getall_bugtable()" +
" BEGIN " +
"select * from bugtable;" +
" END ";
string procUpdate =
"CREATE PROCEDURE sp_updatebugtable(" +
"in p_id_auto int, " +
"in p_field varchar(50)) " +
"BEGIN " +
"update bugtable set field = p_field, counter = counter+1 where id_auto=p_id_auto; " +
"select * from bugtable where id_auto=p_id_auto; " + /*retrieve updated row*/
"END ";
execSQL(createTable);
execSQL(procGetAll);
execSQL(procUpdate);
/* Add one row to the table */
MySqlCommand cmd = new MySqlCommand(
"insert into bugtable(field) values('x')", conn);
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = conn.CreateCommand();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.CommandText = "sp_getall_bugtable";
da.UpdateCommand = conn.CreateCommand();
da.UpdateCommand.CommandType = CommandType.StoredProcedure;
da.UpdateCommand.CommandText = "sp_updatebugtable";
da.UpdateCommand.Parameters.Add("p_id_auto", MySqlDbType.Int32, 4, "id_auto");
da.UpdateCommand.Parameters.Add("p_field", MySqlDbType.VarChar, 4, "field");
da.UpdateCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
da.Fill(ds, "bugtable");
DataTable table = ds.Tables["bugtable"];
DataRow row = table.Rows[0];
row["field"] = "newvalue";
Assert.AreEqual(row.RowState, DataRowState.Modified);
Assert.AreEqual((int)row["counter"], 0);
da.Update(table);
// Verify that "counter" field was changed by updating stored procedure.
Assert.AreEqual((int)row["counter"], 1);
}
void calculate_expenses_ofpatient()
{
try
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
dataGridView1.Rows.RemoveAt(i);
i--;
while (dataGridView1.Rows.Count == 0)
{
continue;
}
}
String spatientid = textBox12.Text;
String constring = "datasource=localhost;port=3306;username=root;password=vijay";
MySqlConnection conDataBase = new MySqlConnection(constring);
string Query = "select Particulars, sum(Charges) as Amount from hospital.tempcharge where PatientID='" + textBox12.Text + "' group by(Particulars) order by(Particulars) desc ; ";
MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
sda.Update(dbdataset);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
double amount = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);
sum = sum + amount;
}
tax = 0.13 * sum;
netamount = tax + sum;
/*
* dbdataset.Rows.Add();
* dbdataset.Rows.Add("Taxable Amount", sum.ToString());
* double tax = 0.13 * sum;
* dbdataset.Rows.Add("Tax(13%)", tax.ToString());
* double netamount = tax + sum;
* dbdataset.Rows.Add("Net Amount",netamount.ToString()); */
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=frs_school;SslMode=none;";
string query = "SELECT bleuid,gatewayid,datetime,rssi,distance,status FROM frs_blelocation";
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand cmdDataBase = new MySqlCommand(query, databaseConnection);
cmdDataBase.CommandTimeout = 60;
//MySqlDataReader dataReader;
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
sda.Update(dbdataset);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dataGridView1.BorderStyle = BorderStyle.None;
dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(238, 239, 249);
dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal;
dataGridView1.DefaultCellStyle.SelectionBackColor = Color.DarkTurquoise;
dataGridView1.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke;
dataGridView1.BackgroundColor = Color.White;
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72);
dataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
//await Task.Run(() => {
// while (true)
// {
// string imagePath = @"C:\\xampp\\htdocs\\frs2018\\db\\floor\\floor14.jpg";
// Image imag = Image.FromFile(imagePath);
// System.IO.FileInfo file = new System.IO.FileInfo(imagePath);
// Bitmap img = new Bitmap(imagePath);
// pictureBox1.Invoke(new Action(() => pictureBox1.Image = img));
// pictureBox1.Invoke(new Action(() => pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage));
// Image<Bgr, Byte> CapturedImage = new Emgu.CV.Image<Bgr, byte>(imagePath);
// Rectangle rec = new Rectangle(15, 650, 10, 10);
// CapturedImage.Draw(rec, new Bgr(Color.Red), 2);//accepts byte array
// CvInvoke.Resize(CapturedImage, CapturedImage, new Size(pictureBox1.Width, pictureBox1.Height), 0, 0, Emgu.CV.CvEnum.Inter.Linear);
// pictureBox1.Invoke(new Action(() => pictureBox1.Image = CapturedImage.Bitmap));
// //Rectangle rect=new Rectangle (150,650,6,6);
// ////Rectangle rect2 = new Rectangle(100, 100, 5, 5);
// //using (Graphics gfx = Graphics.FromImage(this.pictureBox1.Image))
// //{
// // gfx.DrawEllipse(Pens.Blue, rect);
// // this.pictureBox1.Refresh();
// //}
// //SQL Connection
// try
// {
// string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=frs_school;SslMode = none;";
// MySqlConnection mcon = new MySqlConnection(connectionString);
// mcon.Open();
// MySqlDataAdapter MyDA = new MySqlDataAdapter();
// string sqlSelectAll = "SELECT bleuid,ble_location from frs_blelocation";
// MyDA.SelectCommand = new MySqlCommand(sqlSelectAll, mcon);
// DataTable table = new DataTable();
// MyDA.Fill(table);
// BindingSource bSource = new BindingSource();
// bSource.DataSource = table;
// for (int i = 0; i < table.Rows.Count; i++)
// {
// string b_location = table.Rows[i]["ble_location"].ToString();
// Console.Write(table.Rows[i]["ble_location"]);
// string[] splitString = b_location.Split('(', ',', ')');//separates into 0,1,2
// Console.WriteLine("BLE X-Value: " + splitString[1]);//gives the x values
// Console.WriteLine("BLE y-Value: " + splitString[2]);//gives the y values
// int x = Convert.ToInt32(splitString[1]);
// int y = Convert.ToInt32(splitString[2]);
// Rectangle newrect = new Rectangle(x, y, 6, 6);
// //Rectangle rect2 = new Rectangle(100, 100, 5, 5);
// using (Graphics gfx = Graphics.FromImage(pictureBox1.Image))//shows error--> object is used somewhere else
// {
// gfx.DrawEllipse(Pens.Blue, newrect);
// }
// }
// pictureBox1.Invoke(new Action(() => pictureBox1.Refresh()));
// mcon.Close();
// }
// catch (Exception )
// {
// //MessageBox.Show(ex.ToString());
// }
// }
//});
}
public static void mysqltest()
{
string MyConString = "SERVER=localhost;" +
"DATABASE=ssc;" +
"UID=root;" +
"PASSWORD=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
//connection.ConnectionTimeout = 1000 * 10;
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from fl_area where fl_code = 'fl_1'";
MySqlDataAdapter da = new MySqlDataAdapter(command);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
da.Fill(ds);
dt = ds.Tables[0];
dt.Rows[0]["name"] = "Africa-africa";
//da.(dt);
//dt.AcceptChanges();
da.UpdateCommand = new MySqlCommand("update fl_area set name=@name where fl_code = 'fl_1'", connection);
da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 45, "name");
//da.UpdateCommand.Parameters.AddWithValue("@name", "Hello world");
da.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
try
{
da.Update(ds.Tables[0]);
}
catch (Exception e) {
e.ToString();
}
MySqlCommand cmd = new MySqlCommand("update fl_area set name=@name where fl_code = 'fl_1'", connection);
da.Fill(ds);
string ss;
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
ss = ds.Tables[0].Rows[k]["g_time"].ToString();
}
}
da.SelectCommand.CommandText = "select * from fl_area f";
da.Fill(ds);
ss = ds.Tables[0].Rows[1][1].GetType().ToString();
try
{
connection.Open();
Reader = command.ExecuteReader();
command.CommandText = "select * from fl_area fa";
Reader = command.ExecuteReader();
while (Reader.Read())
{
string thisrow = "";
for (int i = 0; i < Reader.FieldCount; i++)
{
thisrow += Reader.GetValue(i).ToString() + ",";
}
}
Reader.Close();
connection.Close();
}
catch (Exception e)
{
GrabAgent.trace_log(e.Message);
}
}
public void Save()
{
mySqlDataAdapter.ContinueUpdateOnError = true;
mySqlDataAdapter.Update(dataTable);
}
private void OrderSlip_FormClosing(object sender, FormClosingEventArgs e)
{
int added = 0;
int deleted = 0;
int modified = 0;
foreach (DataRow dr in myds.Tables["訂單明細資料表"].Rows)
{
switch (dr.RowState)
{
case DataRowState.Added:
added++;
break;
case DataRowState.Deleted:
deleted++;
break;
case DataRowState.Modified:
modified++;
break;
case DataRowState.Unchanged:
break;
default:
break;
}
}
if (added != 0 || deleted != 0 || modified != 0)
{
String result = "";
result += (added == 0 ? "" : "【新增】 " + added + "筆新資料\n")
+ (deleted == 0 ? "" : "【刪除】 " + deleted + "筆資料\n")
+ (modified == 0 ? "" : "【變更】 " + modified + "筆資料\n")
+ "要儲存嗎？";
DialogResult dialogResult = MessageBox.Show(result, "要儲存嗎？", MessageBoxButtons.YesNoCancel);
if (dialogResult == DialogResult.Yes)
{
if (checkAll())
{
try
{
scheduleAdapter.Update(myds, "訂單明細資料表");
}
catch
{
DataRow dr = myds.Tables["訂單資料表"].NewRow();
dr["客戶代號"] = comboBox1.SelectedValue.ToString();
dr["單別"] = radioButton1.Checked ? 1 : 0; //國內為true（資料庫記1），國外為false
dr["匯率表id"] = myds.Tables["匯率資料表"].Rows[imagedComboBox1.SelectedIndex][0].ToString();
myds.Tables["訂單資料表"].Rows.Add(dr);
adapter.Update(myds, "訂單資料表");
scheduleAdapter.Update(myds, "訂單明細資料表");
}
}
else
{
//MessageBox.Show("請檢查是否有未填欄位\n或是庫存量不足的情況！");
e.Cancel = true;
}
}
else if (dialogResult == DialogResult.No)
{
//do something
}
else if (dialogResult == DialogResult.Cancel)
{
e.Cancel = true;
}
}
檢視訂單完成度();
}
public void BatchUpdatesAndDeletes()
{
st.execSQL("CREATE TABLE test (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20))");
st.execSQL("INSERT INTO test VALUES (1, 'boo'), (2, 'boo'), (3, 'boo')");
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
string connStr = st.GetConnectionString(true) + ";logging=true;allow batch=true";
using (MySqlConnection c = new MySqlConnection(connStr))
{
c.Open();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM test", c);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
da.UpdateCommand = cb.GetUpdateCommand();
da.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
da.UpdateBatchSize = 100;
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["name"] = "boo2";
dt.Rows[1]["name"] = "boo2";
dt.Rows[2]["name"] = "boo2";
da.Update(dt);
}
Assert.Equal(1, listener.Find("Query Opened: UPDATE"));
}
public void ParsingTender()
{
using (var connect = ConnectToDb.GetDbConnection())
{
connect.Open();
var selectTend =
$"SELECT id_tender FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND end_date = @end_date AND type_fz = @type_fz AND doc_publish_date = @doc_publish_date";
var cmd = new MySqlCommand(selectTend, connect);
cmd.Prepare();
cmd.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd.Parameters.AddWithValue("@type_fz", TypeFz);
cmd.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
var dt = new DataTable();
var adapter = new MySqlDataAdapter {
SelectCommand = cmd
};
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Log.Logger("This tender is exist in base", PurNum);
return;
}
var s = DownloadString.DownLUserAgent(_tn.Href);
if (string.IsNullOrEmpty(s))
{
Log.Logger("Empty string in ParsingTender()", _tn.Href);
return;
}
var htmlDoc = new HtmlDocument();
htmlDoc.LoadHtml(s);
var navigator = (HtmlNodeNavigator)htmlDoc.CreateNavigator();
var dateUpd = DateTime.Now;
var cancelStatus = 0;
var updated = false;
var selectDateT =
$"SELECT id_tender, date_version, cancel FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND type_fz = @type_fz";
var cmd2 = new MySqlCommand(selectDateT, connect);
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd2.Parameters.AddWithValue("@type_fz", TypeFz);
var adapter2 = new MySqlDataAdapter {
SelectCommand = cmd2
};
var dt2 = new DataTable();
adapter2.Fill(dt2);
foreach (DataRow row in dt2.Rows)
{
updated = true;
if (dateUpd >= (DateTime)row["date_version"])
{
row["cancel"] = 1;
}
else
{
cancelStatus = 1;
}
}
var commandBuilder =
new MySqlCommandBuilder(adapter2)
{
ConflictOption = ConflictOption.OverwriteChanges
};
adapter2.Update(dt2);
var printForm = _tn.Href;
var customerId = 0;
var organiserId = 0;
var orgName = EtpName;
if (!string.IsNullOrEmpty(orgName))
{
var selectOrg =
$"SELECT id_organizer FROM {AppBuilder.Prefix}organizer WHERE full_name = @full_name";
var cmd3 = new MySqlCommand(selectOrg, connect);
cmd3.Prepare();
cmd3.Parameters.AddWithValue("@full_name", orgName);
var dt3 = new DataTable();
var adapter3 = new MySqlDataAdapter {
SelectCommand = cmd3
};
adapter3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
organiserId = (int)dt3.Rows[0].ItemArray[0];
}
else
{
var phone = "";
var email = "";
var inn = "";
var kpp = "";
var contactPerson = _tn.OrgContact;
var address = "";
var addOrganizer =
$"INSERT INTO {AppBuilder.Prefix}organizer SET full_name = @full_name, contact_phone = @contact_phone, contact_person = @contact_person, contact_email = @contact_email, inn = @inn, kpp = @kpp, fact_address = @fact_address";
var cmd4 = new MySqlCommand(addOrganizer, connect);
cmd4.Prepare();
cmd4.Parameters.AddWithValue("@full_name", orgName);
cmd4.Parameters.AddWithValue("@contact_phone", phone);
cmd4.Parameters.AddWithValue("@contact_person", contactPerson);
cmd4.Parameters.AddWithValue("@contact_email", email);
cmd4.Parameters.AddWithValue("@inn", inn);
cmd4.Parameters.AddWithValue("@kpp", kpp);
cmd4.Parameters.AddWithValue("@fact_address", address);
cmd4.ExecuteNonQuery();
organiserId = (int)cmd4.LastInsertedId;
}
}
var idPlacingWay = 0;
GetEtp(connect, out var idEtp);
var notice1 = navigator.SelectSingleNode(
"//td[contains(text(), 'Для вопросов по содержанию закупочной документации')]/following-sibling::td")
?.Value?.Trim() ?? "";
var notice2 = navigator.SelectSingleNode(
"//td[contains(text(), 'Для вопросов по порядку предоставления предложений')]/following-sibling::td")
?.Value?.Trim() ?? "";
var noticeVer =
$"Для вопросов по содержанию закупочной документации: {notice1}\nДля вопросов по порядку предоставления предложений: {notice2}";
var insertTender =
$"INSERT INTO {AppBuilder.Prefix}tender SET id_region = @id_region, id_xml = @id_xml, purchase_number = @purchase_number, doc_publish_date = @doc_publish_date, href = @href, purchase_object_info = @purchase_object_info, type_fz = @type_fz, id_organizer = @id_organizer, id_placing_way = @id_placing_way, id_etp = @id_etp, end_date = @end_date, scoring_date = @scoring_date, bidding_date = @bidding_date, cancel = @cancel, date_version = @date_version, num_version = @num_version, notice_version = @notice_version, xml = @xml, print_form = @print_form";
var cmd9 = new MySqlCommand(insertTender, connect);
cmd9.Prepare();
cmd9.Parameters.AddWithValue("@id_region", 0);
cmd9.Parameters.AddWithValue("@id_xml", _tn.PurNum);
cmd9.Parameters.AddWithValue("@purchase_number", _tn.PurNum);
cmd9.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub);
cmd9.Parameters.AddWithValue("@href", _tn.Href);
cmd9.Parameters.AddWithValue("@purchase_object_info", _tn.PurName);
cmd9.Parameters.AddWithValue("@type_fz", TypeFz);
cmd9.Parameters.AddWithValue("@id_organizer", organiserId);
cmd9.Parameters.AddWithValue("@id_placing_way", idPlacingWay);
cmd9.Parameters.AddWithValue("@id_etp", idEtp);
cmd9.Parameters.AddWithValue("@end_date", _tn.DateEnd);
cmd9.Parameters.AddWithValue("@scoring_date", DateTime.MinValue);
cmd9.Parameters.AddWithValue("@bidding_date", DateTime.MinValue);
cmd9.Parameters.AddWithValue("@cancel", cancelStatus);
cmd9.Parameters.AddWithValue("@date_version", dateUpd);
cmd9.Parameters.AddWithValue("@num_version", 1);
cmd9.Parameters.AddWithValue("@notice_version", noticeVer);
cmd9.Parameters.AddWithValue("@xml", _tn.Href);
cmd9.Parameters.AddWithValue("@print_form", printForm);
var resInsertTender = cmd9.ExecuteNonQuery();
var idTender = (int)cmd9.LastInsertedId;
Counter(resInsertTender, updated);
if (!string.IsNullOrEmpty(orgName))
{
var selectCustomer =
$"SELECT id_customer FROM {AppBuilder.Prefix}customer WHERE full_name = @full_name";
var cmd13 = new MySqlCommand(selectCustomer, connect);
cmd13.Prepare();
cmd13.Parameters.AddWithValue("@full_name", orgName);
var reader7 = cmd13.ExecuteReader();
if (reader7.HasRows)
{
reader7.Read();
customerId = (int)reader7["id_customer"];
reader7.Close();
}
else
{
reader7.Close();
var insertCustomer =
$"INSERT INTO {AppBuilder.Prefix}customer SET reg_num = @reg_num, full_name = @full_name, is223=1, inn = @inn";
var cmd14 = new MySqlCommand(insertCustomer, connect);
cmd14.Prepare();
var customerRegNumber = Guid.NewGuid().ToString();
cmd14.Parameters.AddWithValue("@reg_num", customerRegNumber);
cmd14.Parameters.AddWithValue("@full_name", orgName);
cmd14.Parameters.AddWithValue("@inn", "");
cmd14.ExecuteNonQuery();
customerId = (int)cmd14.LastInsertedId;
}
}
var lotNum = 1;
var insertLot =
$"INSERT INTO {AppBuilder.Prefix}lot SET id_tender = @id_tender, lot_number = @lot_number, max_price = @max_price, currency = @currency, finance_source = @finance_source";
var cmd18 = new MySqlCommand(insertLot, connect);
cmd18.Prepare();
cmd18.Parameters.AddWithValue("@id_tender", idTender);
cmd18.Parameters.AddWithValue("@lot_number", lotNum);
cmd18.Parameters.AddWithValue("@max_price", "");
cmd18.Parameters.AddWithValue("@currency", "");
cmd18.Parameters.AddWithValue("@finance_source", "");
cmd18.ExecuteNonQuery();
var idLot = (int)cmd18.LastInsertedId;
var insertLotitem =
$"INSERT INTO {AppBuilder.Prefix}purchase_object SET id_lot = @id_lot, id_customer = @id_customer, name = @name, sum = @sum";
var cmd19 = new MySqlCommand(insertLotitem, connect);
cmd19.Prepare();
cmd19.Parameters.AddWithValue("@id_lot", idLot);
cmd19.Parameters.AddWithValue("@id_customer", customerId);
cmd19.Parameters.AddWithValue("@name", _tn.PurName);
cmd19.Parameters.AddWithValue("@sum", "");
cmd19.ExecuteNonQuery();
var delivPlace = navigator.SelectSingleNode(
"//td[contains(text(), 'Грузополучатель/место оказания услуги')]/following-sibling::td")
?.Value?.Trim() ?? "";
var delivTerm = navigator.SelectSingleNode(
"//td[contains(text(), 'Информация об условиях и порядке проведения процедуры')]/following-sibling::td")
?.Value?.Trim() ?? "";
if (delivTerm != "" || delivPlace != "")
{
var insertCustomerRequirement =
$"INSERT INTO {AppBuilder.Prefix}customer_requirement SET id_lot = @id_lot, id_customer = @id_customer, max_price = @max_price, delivery_place = @delivery_place, delivery_term = @delivery_term";
var cmd16 = new MySqlCommand(insertCustomerRequirement, connect);
cmd16.Prepare();
cmd16.Parameters.AddWithValue("@id_lot", idLot);
cmd16.Parameters.AddWithValue("@id_customer", customerId);
cmd16.Parameters.AddWithValue("@delivery_place", delivPlace);
cmd16.Parameters.AddWithValue("@delivery_term", delivTerm);
cmd16.Parameters.AddWithValue("@max_price", "");
cmd16.ExecuteNonQuery();
}
TenderKwords(connect, idTender);
AddVerNumber(connect, _tn.PurNum, TypeFz);
}
}
public void InsertValueAfterNull()
{
execSQL("DROP TABLE Test");
execSQL("CREATE TABLE Test (id int auto_increment primary key, foo int)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommand c = new MySqlCommand("INSERT INTO Test (foo) values (?foo)", conn);
c.Parameters.Add("?foo", MySqlDbType.Int32, 0, "foo");
da.InsertCommand = c;
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
dt.Rows.Add(row);
row = dt.NewRow();
row["foo"] = 2;
dt.Rows.Add(row);
da.Update(dt);
dt.Clear();
da.Fill(dt);
Assert.AreEqual(2, dt.Rows.Count);
Assert.AreEqual(2, dt.Rows[1]["foo"]);
}
private void button2_Click(object sender, EventArgs e)
{
mySqlDataAdapter.Update(dataTable);
}
public void UpdateDecimalColumns()
{
execSQL("CREATE TABLE Test (id int not null auto_increment primary key, " +
"dec1 decimal(10,1))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
row["id"] = DBNull.Value;
row["dec1"] = 23.4;
dt.Rows.Add(row);
da.Update(dt);
dt.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(1, dt.Rows[0]["id"]);
Assert.AreEqual(23.4, dt.Rows[0]["dec1"]);
cb.Dispose();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
String name = textBox1.Text;
String choice = comboBox1.Text;
MySqlConnection con = new MySqlConnection(mycon.conn);
con.Open();
if (comboBox3.SelectedItem == "ID")
{
MySqlCommand cmdDatabase = new MySqlCommand("select pid as 'Product ID', pname as 'Product Name', ptype as 'Type',pbrand as 'Brand', pqty as 'Stocks',pprice as 'Price' from sales.products where pid='" + name + "'", con);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = cmdDatabase;
dbdataset = new DataTable();
myDataAdapter.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbdataset);
}
else if (comboBox3.SelectedItem == "Name")
{
MySqlCommand cmdDatabase = new MySqlCommand("select pid as 'Product ID', pname as 'Product Name', ptype as 'Type',pbrand as 'Brand', pqty as 'Stocks',pprice as 'Price' from sales.products where pname='" + name + "'", con);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = cmdDatabase;
dbdataset = new DataTable();
myDataAdapter.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbdataset);
}
else if (comboBox3.SelectedItem == "Brand")
{
MySqlCommand cmdDatabase = new MySqlCommand("select pid as 'Product ID', pname as 'Product Name', ptype as 'Type',pbrand as 'Brand', pqty as 'Stocks',pprice as 'Price' from sales.products where pbrand='" + name + "'", con);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = cmdDatabase;
dbdataset = new DataTable();
myDataAdapter.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbdataset);
}
else if (comboBox3.SelectedItem == "Type")
{
MySqlCommand cmdDatabase = new MySqlCommand("select pid as 'Product ID', pname as 'Product Name', ptype as 'Type',pbrand as 'Brand', pqty as 'Stocks',pprice as 'Price' from sales.products where ptype='" + name + "'", con);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = cmdDatabase;
dbdataset = new DataTable();
myDataAdapter.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbdataset);
}
//select * from eztan.products where pname='Milk'
}
catch (Exception ex)
{
}
}
public void TokenizerBatching()
{
execSQL("CREATE TABLE Test (id INT, expr INT,name VARCHAR(20), PRIMARY KEY(id))");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test",
conn);
MySqlCommand ins = new MySqlCommand(
"INSERT INTO test (id, expr, name) VALUES(?p1, (?p2 * 2) + 3, ?p3)",
conn);
da.InsertCommand = ins;
ins.UpdatedRowSource = UpdateRowSource.None;
ins.Parameters.Add("?p1", MySqlDbType.Int32).SourceColumn = "id";
ins.Parameters.Add("?p2", MySqlDbType.Int32).SourceColumn = "expr";
ins.Parameters.Add("?p3", MySqlDbType.VarChar, 20).SourceColumn = "name";
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 1; i <= 100; i++)
{
DataRow row = dt.NewRow();
row["id"] = i;
row["expr"] = i;
row["name"] = "name " + i;
dt.Rows.Add(row);
}
da.UpdateBatchSize = 10;
da.Update(dt);
}
//private void NextButton_Click(object sender, EventArgs e)
//{
// if (SqlQueries.page <= (RDZAviaNumber-1) / numericUpDown1.Value - 1 )
// {
// SqlQueries.page++;
// PagesLoad();
// }
//}
private void AcceptButton_Click(object sender, EventArgs e)
{
RDZAviaAdapter.Update(RDZAviaDataset.Tables[0]);
Form1_Load(sender, e);
}
public void DateTimeInDataTable()
{
execSQL("INSERT INTO Test VALUES(1, Now(), '0000-00-00', NULL, NULL)");
using (MySqlConnection c = new MySqlConnection(
conn.ConnectionString + ";pooling=false;AllowZeroDatetime=true"))
{
c.Open();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", c);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
row["id"] = 2;
row["dt"] = new MySqlDateTime(DateTime.Now);
row["d"] = new MySqlDateTime(DateTime.Now);
row["t"] = new TimeSpan(1, 1, 1);
row["ts"] = DBNull.Value;
dt.Rows.Add(row);
da.Update(dt);
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(2, dt.Rows.Count);
cb.Dispose();
}
}
public void NotLastOneWins()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), dt DATETIME, tm TIME, `multi word` int, PRIMARY KEY(id))");
execSQL("INSERT INTO Test (id, name) VALUES (1, 'Test')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
cb.ConflictOption = ConflictOption.CompareAllSearchableValues;
DataTable dt = new DataTable();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
execSQL("UPDATE Test SET name='Test2' WHERE id=1");
try
{
dt.Rows[0]["name"] = "Test3";
da.Update(dt);
Assert.Fail("This should not work");
}
catch (DBConcurrencyException)
{
}
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("Test2", dt.Rows[0]["name"]);
}
public void TestAllowZeroDateTime()
{
execSQL("TRUNCATE TABLE Test");
execSQL("INSERT INTO Test (id, d, dt) VALUES (1, '0000-00-00', '0000-00-00 00:00:00')");
using (MySqlConnection c = new MySqlConnection(
conn.ConnectionString + ";pooling=false;AllowZeroDatetime=true"))
{
c.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test", c);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
reader.Read();
Assert.IsTrue(reader.GetValue(1) is MySqlDateTime);
Assert.IsTrue(reader.GetValue(2) is MySqlDateTime);
Assert.IsFalse(reader.GetMySqlDateTime(1).IsValidDateTime);
Assert.IsFalse(reader.GetMySqlDateTime(2).IsValidDateTime);
try
{
reader.GetDateTime(1);
Assert.Fail("This should not succeed");
}
catch (MySqlConversionException)
{
}
}
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", c);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
da.Fill(dt);
dt.Rows[0]["id"] = 2;
DataRow row = dt.NewRow();
row["id"] = 3;
row["d"] = new MySqlDateTime("2003-9-24");
row["dt"] = new MySqlDateTime("0000/0/00 00:00:00");
dt.Rows.Add(row);
da.Update(dt);
dt.Clear();
da.Fill(dt);
Assert.AreEqual(2, dt.Rows.Count);
MySqlDateTime date = (MySqlDateTime)dt.Rows[1]["d"];
Assert.AreEqual(2003, date.Year);
Assert.AreEqual(9, date.Month);
Assert.AreEqual(24, date.Day);
cb.Dispose();
}
}
public void SpecialCharactersInFieldNames()
{
execSQL("CREATE TABLE Test (`col%1` int PRIMARY KEY, `col()2` int, `col<>3` int, `col/4` int)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
cb.ToString(); // keep the compiler happy
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.NewRow();
row[0] = 1;
row[1] = 2;
row[2] = 3;
row[3] = 4;
dt.Rows.Add(row);
da.Update(dt);
}
public void MultiUpdate()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), dt DATETIME, tm TIME, `multi word` int, PRIMARY KEY(id))");
execSQL("INSERT INTO Test (id, name) VALUES (1, 'test1')");
execSQL("INSERT INTO Test (id, name) VALUES (2, 'test2')");
execSQL("INSERT INTO Test (id, name) VALUES (3, 'test3')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["id"] = 4;
dt.Rows[0]["name"] = "test4";
dt.Rows[1]["id"] = 5;
dt.Rows[1]["name"] = "test5";
dt.Rows[2]["id"] = 6;
dt.Rows[2]["name"] = "test6";
DataTable changes = dt.GetChanges();
da.Update(changes);
dt.AcceptChanges();
dt.Rows[0]["id"] = 7;
dt.Rows[0]["name"] = "test7";
dt.Rows[1]["id"] = 8;
dt.Rows[1]["name"] = "test8";
dt.Rows[2]["id"] = 9;
dt.Rows[2]["name"] = "test9";
changes = dt.GetChanges();
da.Update(changes);
dt.AcceptChanges();
cb.Dispose();
}
// Usuwanie usługi z listy usług wykonywanych przez pracownika
private void dgPUUslugi_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
id_usluga = Convert.ToInt32(dgPUUslugi.Rows[e.RowIndex].Cells[0].Value);
if (MessageBox.Show("Czy chcesz usunąć usługę pracownikowi?", "Uwaga!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
try
{
string query3 = $"DELETE FROM uzytkownik_usluga WHERE id_uzytkownik= '{id_rekordu}' AND uslugi_id = '{id_usluga}';";
MySqlCommand cmd3 = new MySqlCommand(query3, conn);
conn.Open();
cmd3.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Usługa została usunięta z usług pracownika.");
}
catch (Exception komunikat)
{
MessageBox.Show(komunikat.Message);
}
}
string query = $"SELECT uslugi.uslugi_id, uslugi.nazwa, uslugi.cena, uslugi.czas FROM uslugi, uzytkownik_usluga WHERE uslugi.uslugi_id = uzytkownik_usluga.uslugi_id AND uzytkownik_usluga.id_uzytkownik = '{id_rekordu}' ORDER BY nazwa;";
MySqlCommand cmd = new MySqlCommand(query, conn);
conn.Open();
try
{
MySqlDataAdapter moja = new MySqlDataAdapter();
moja.SelectCommand = cmd;
DataTable tabela = new DataTable();
moja.Fill(tabela);
BindingSource zrodlo = new BindingSource();
zrodlo.DataSource = tabela;
dgPUUslugi.DataSource = zrodlo;
moja.Update(tabela);
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
string query2 = $"SELECT * FROM uslugi ORDER BY nazwa;";
MySqlCommand cmd2 = new MySqlCommand(query2, conn);
conn.Open();
try
{
MySqlDataAdapter moja = new MySqlDataAdapter();
moja.SelectCommand = cmd2;
DataTable tabela = new DataTable();
moja.Fill(tabela);
BindingSource zrodlo = new BindingSource();
zrodlo.DataSource = tabela;
dgPUUslugiNowe.DataSource = zrodlo;
moja.Update(tabela);
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void SemicolonAtEndOfSQL()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), PRIMARY KEY(id))");
execSQL("INSERT INTO Test VALUES(1, 'Data')");
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM `Test`;", conn);
da.FillSchema(ds, SchemaType.Source, "Test");
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["id"] = 2;
da.Update(dt);
dt.Clear();
da.Fill(dt);
cb.Dispose();
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(2, dt.Rows[0]["id"]);
}
public void TestUpdate()
{
CreateDefaultTable();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow dr = dt.NewRow();
dr["id2"] = 2;
dr["name"] = "TestName1";
dt.Rows.Add(dr);
int count = da.Update(dt);
// make sure our refresh of auto increment values worked
Assert.AreEqual(1, count, "checking insert count");
Assert.IsNotNull(dt.Rows[dt.Rows.Count - 1]["id"],
"Checking auto increment column");
dt.Rows.Clear();
da.Fill(dt);
dt.Rows[0]["id2"] = 3;
dt.Rows[0]["name"] = "TestName2";
dt.Rows[0]["ts"] = DBNull.Value;
DateTime day1 = new DateTime(2003, 1, 16, 12, 24, 0);
dt.Rows[0]["dt"] = day1;
dt.Rows[0]["tm"] = day1.TimeOfDay;
count = da.Update(dt);
Assert.IsNotNull(dt.Rows[0]["ts"], "checking refresh of record");
Assert.AreEqual(3, dt.Rows[0]["id2"], "checking refresh of primary column");
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(1, count, "checking update count");
DateTime dateTime = (DateTime)dt.Rows[0]["dt"];
Assert.AreEqual(day1.Date, dateTime.Date, "checking date");
Assert.AreEqual(day1.TimeOfDay, dt.Rows[0]["tm"], "checking time");
dt.Rows[0].Delete();
count = da.Update(dt);
Assert.AreEqual(1, count, "checking insert count");
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(0, dt.Rows.Count, "checking row count");
cb.Dispose();
}
public void UpdatingWithDateInKey()
{
execSQL("CREATE TABLE Test (cod INT, dt DATE, PRIMARY KEY(cod, dt))");
execSQL("INSERT INTO Test (cod, dt) VALUES (1, '2006-1-1')");
execSQL("INSERT INTO Test (cod, dt) VALUES (2, '2006-1-2')");
execSQL("INSERT INTO Test (cod, dt) VALUES (3, '2006-1-3')");
execSQL("INSERT INTO Test (cod, dt) VALUES (4, '2006-1-4')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test ORDER BY cod", conn);
MySqlCommandBuilder bld = new MySqlCommandBuilder(da);
bld.ConflictOption = ConflictOption.OverwriteChanges;
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["cod"] = 6;
da.Update(dt);
dt.Clear();
da.SelectCommand.CommandText = "SELECT * FROM Test WHERE cod=6";
da.Fill(dt);
Assert.AreEqual(6, dt.Rows[0]["cod"]);
}
private void update_Click_1(object sender, EventArgs e)
{
builder = new MySqlCommandBuilder(da2);
da2.Update(ds2, "Subscriptions");
}
public void UpdateExtendedTextFields()
{
execSQL("CREATE TABLE Test (id int, notes MEDIUMTEXT, PRIMARY KEY(id))");
execSQL("INSERT INTO Test VALUES(1, 'This is my note')");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
cb.ToString(); // keep the compiler happy
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["notes"] = "This is my new note";
da.Update(dt);
dt.Clear();
da.Fill(dt);
Assert.AreEqual("This is my new note", dt.Rows[0]["notes"]);
}
public void UpdateNullTextFieldToEmptyString()
{
CreateDefaultTable();
execSQL("INSERT INTO Test (id, id2, name) VALUES (1, 1, NULL)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
cb.ToString(); // keep the compiler happy
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["name"] = "";
int updateCnt = da.Update(dt);
Assert.AreEqual(1, updateCnt);
dt.Rows.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("", dt.Rows[0]["name"]);
}
public void AutoIncrementColumns()
{
execSQL("CREATE TABLE Test (id int(10) unsigned NOT NULL auto_increment primary key)");
execSQL("INSERT INTO Test VALUES(NULL)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
DataRow row = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(row);
da.Update(ds);
ds.Clear();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
Assert.AreEqual(2, ds.Tables[0].Rows[1]["id"]);
cb.Dispose();
}
/// <summary>
/// Aktualisert geänderte Daten in der Datenbank
/// Siehe auch: https://www.dreamincode.net/forums/topic/82058-c%23-update-record-in-a-mysql-database/
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void aktualisierenToolStripMenuItem_Click(object sender, EventArgs e)
{
builder.GetUpdateCommand();
dataAdapter_Wst.Update(dataSet_Wst);
dataSet_Wst.AcceptChanges();
}
