public OleDbDataReader selectquery(string query)
{
try
{
cmd = new OleDbCommand(query, con);
return cmd.ExecuteReader();
}
catch (Exception ex)
{
Out.Print.Line(ex.Message);
}
return null;
}
private void btnSearch_Click(object sender, EventArgs e)
{
string sql = "SELECT * from PROPERTIES ";
bool searchFilters = true;
//Search using the Property Reference Number
if (!string.IsNullOrEmpty(txtPropRef.Text))
{
sql += "WHERE [Numb] = " + txtPropRef.Text.ToString() + "";
searchFilters = false;
}
if (searchFilters)
{
//Searching by Agent SQL statement
if ((radioAgent.Checked) && !(radioProperty.Checked))
{
if (cboEmployee.Text == "")
{
MessageBox.Show("Please, select an Agent as search cirteria!", "Select a Remax Agent", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
sql += "WHERE ReferEmp = " + cboEmployee.SelectedValue.ToString() + "";
if (cboType.Text != "")
{
sql += " AND [Type] = '" + cboType.Text.ToString() + "'";
}
if (cboCity.Text != "")
{
sql += " AND [City] = '" + cboCity.Text.ToString() + "'";
}
if (cboBedrooms.Text != "")
{
if (cboBedrooms.Text == "4+")
{
sql += " AND [Bedrooms] >= 4";
}
else
{
sql += " AND [Bedrooms] = " + cboBedrooms.Text.ToString() + "";
}
}
if (cboBathrooms.Text != "")
{
if (cboBathrooms.Text == "4+")
{
sql += " AND [Bathrooms] >= 4";
}
else
{
sql += " AND [Bathrooms] = " + cboBathrooms.Text.ToString() + "";
}
}
}
//Searching by Property SQL statement
if ((radioProperty.Checked) && !(radioAgent.Checked))
{
sql += "WHERE ReferEmp >= 0 ";
if (cboType.Text != "")
{
sql += " AND [Type] = '" + cboType.Text.ToString() + "'";
}
if (cboCity.Text != "")
{
sql += " AND [City] = '" + cboCity.Text.ToString() + "'";
}
if (cboBedrooms.Text != "")
{
if (cboBedrooms.Text == "4+")
{
sql += " AND [Bedrooms] >= 4";
}
else
{
sql += " AND [Bedrooms] = " + cboBedrooms.Text.ToString() + "";
}
}
if (cboBathrooms.Text != "")
{
if (cboBathrooms.Text == "4+")
{
sql += " AND [Bathrooms] >= 4";
}
else
{
sql += " AND [Bathrooms] = " + cboBathrooms.Text.ToString() + "";
}
}
}
}
//Displaying the results
OleDbCommand myCmd = new OleDbCommand(sql, clsGlobal.myCon);
OleDbDataReader myReader = myCmd.ExecuteReader();
DataTable Table = new DataTable();
Table.Load(myReader);
gridResult.DataSource = Table;
gridResult.Columns[0].Visible = false;
gridResult.Columns[8].Visible = false;
gridResult.Columns[9].Visible = false;
if (gridResult.Rows.Count == 1)
{
MessageBox.Show("Sorry, no Property is available for you under these conditions.", "Remax Search", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (selection == "add")
{
mc.conn.Open();
cmd = new OleDbCommand("insert into Vendor Values(@VID,@VName,@VCode,@VCity,@PH1,@PH2,@VAddress,@CPName,@CPPH,@VEmail,@VFax,@VGroup,'Inactive')", mc.conn);
cmd.Parameters.AddWithValue("@VID", textBox12.Text);
cmd.Parameters.AddWithValue("@VName", textBox1.Text);
cmd.Parameters.AddWithValue("@VCode", textBox2.Text);
cmd.Parameters.AddWithValue("@VCity", textBox3.Text);
cmd.Parameters.AddWithValue("@PH1", textBox4.Text);
cmd.Parameters.AddWithValue("@PH2", textBox5.Text);
cmd.Parameters.AddWithValue("@VAddress", textBox6.Text);
cmd.Parameters.AddWithValue("@CPName", textBox7.Text);
cmd.Parameters.AddWithValue("@CPPH", textBox8.Text);
cmd.Parameters.AddWithValue("@VEmail", textBox9.Text);
cmd.Parameters.AddWithValue("@VFax", textBox10.Text);
cmd.Parameters.AddWithValue("@VGroup", comboBox2.Text);
cmd.ExecuteNonQuery();
mc.conn.Close();
MessageBox.Show("Vendor added!");
textBox1.ReadOnly = true;
textBox2.ReadOnly = true;
textBox3.ReadOnly = true;
textBox4.ReadOnly = true;
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
textBox7.ReadOnly = true;
textBox8.ReadOnly = true;
textBox9.ReadOnly = true;
textBox10.ReadOnly = true;
comboBox2.Enabled = false;
}
else if (selection == "approve")
{
mc.conn.Open();
cmd = new OleDbCommand("update Vendor set VStatus='Active' where VID='" + comboBox1.Text + "';", mc.conn);
cmd.ExecuteNonQuery();
mc.conn.Close();
MessageBox.Show("Vendor activated!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox13.Text = "";
comboBox2.Text = "";
comboBox1.Text = "";
comboBox1.Items.Clear();
mc.conn.Open();
cmd = new OleDbCommand("select VID from Vendor where VStatus='Inactive';", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["VID"]);
}
mc.conn.Close();
button2.Enabled = false;
}
else if (selection == "update")
{
mc.conn.Open();
cmd = new OleDbCommand("update Vendor set VName=@VName, VCode=@VCode, VCity=@VCity, PH1=@PH1, PH2=@PH2, VAddress=@VAddress, CPName=@CPName, CPPH=@CPPH, VEmail=@VEmail, VFax=@VFax where VID=@VID;", mc.conn);
cmd.Parameters.AddWithValue("@VName", textBox1.Text);
cmd.Parameters.AddWithValue("@VCode", textBox2.Text);
cmd.Parameters.AddWithValue("@VCity", textBox3.Text);
cmd.Parameters.AddWithValue("@PH1", textBox4.Text);
cmd.Parameters.AddWithValue("@PH2", textBox5.Text);
cmd.Parameters.AddWithValue("@VAddress", textBox6.Text);
cmd.Parameters.AddWithValue("@CPName", textBox7.Text);
cmd.Parameters.AddWithValue("@CPPH", textBox8.Text);
cmd.Parameters.AddWithValue("@VEmail", textBox9.Text);
cmd.Parameters.AddWithValue("@VFax", textBox10.Text);
cmd.Parameters.AddWithValue("@VID", comboBox1.Text);
cmd.ExecuteNonQuery();
mc.conn.Close();
MessageBox.Show("Vendor updated!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox13.Text = "";
comboBox2.Text = "";
comboBox1.Text = "";
}
}
private void Save_Click(object sender, EventArgs e)
{
try
{
if (txtCustomerID.Text == "")
{
MessageBox.Show("Please retrieve Customer ID", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCustomerID.Focus();
return;
}
if (textBox3.Text == "")
{
MessageBox.Show("Please Insert Delivery Charges", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCustomerID.Focus();
return;
}
if (txtTaxPer.Text == "")
{
MessageBox.Show("Please enter tax percentage", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTaxPer.Focus();
return;
}
if (txtTotalPayment.Text == "")
{
MessageBox.Show("Please enter total payment", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTotalPayment.Focus();
return;
}
if (ListView1.Items.Count == 0)
{
MessageBox.Show("sorry no product added", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
auto();
con = new OleDbConnection(cs);
con.Open();
string ct = "select invoiceno from Sales where invoiceno=@find";
cmd = new OleDbCommand(ct);
cmd.Connection = con;
cmd.Parameters.Add(new OleDbParameter("@find", System.Data.OleDb.OleDbType.VarChar, 20, "invoiceno"));
cmd.Parameters["@find"].Value = txtInvoiceNo.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read() == true)
{
MessageBox.Show("Invoice No. Already Exists", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new OleDbConnection(cs);
con.Open();
string cb = "insert Into Sales(InvoiceNo,InvoiceDate,CustomerID,SubTotal,VATPercentage,VATAmount,GrandTotal,TotalPayment,PaymentDue,Remarks,dcharges) VALUES ('" + txtInvoiceNo.Text + "',#" + dtpInvoiceDate.Text + "#,'" + txtCustomerID.Text + "'," + txtSubTotal.Text + "," + txtTaxPer.Text + "," + txtTaxAmt.Text + "," + txtTotal.Text + "," + txtTotalPayment.Text + "," + txtPaymentDue.Text + ",'" + txtRemarks.Text + "','" + textBox3.Text + "')";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Close();
for (int i = 0; i <= ListView1.Items.Count - 1; i++)
{
con = new OleDbConnection(cs);
string cd = "insert Into ProductSold(InvoiceNo,ConfigID,Quantity,Price,TotalAmount) VALUES (@InvoiceNo,@ConfigID,@Quantity,@Price,@Totalamount)";
cmd = new OleDbCommand(cd);
cmd.Connection = con;
cmd.Parameters.AddWithValue("InvoiceNo", txtInvoiceNo.Text);
cmd.Parameters.AddWithValue("ConfigID", ListView1.Items[i].SubItems[1].Text);
cmd.Parameters.AddWithValue("Quantity", ListView1.Items[i].SubItems[4].Text);
cmd.Parameters.AddWithValue("Price", ListView1.Items[i].SubItems[3].Text);
cmd.Parameters.AddWithValue("TotalAmount", ListView1.Items[i].SubItems[5].Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
for (int i = 0; i <= ListView1.Items.Count - 1; i++)
{
con = new OleDbConnection(cs);
con.Open();
string cb1 = "update stock set Quantity = Quantity - " + ListView1.Items[i].SubItems[4].Text + " where ConfigID= " + ListView1.Items[i].SubItems[1].Text + "";
cmd = new OleDbCommand(cb1);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
for (int i = 0; i <= ListView1.Items.Count - 1; i++)
{
con = new OleDbConnection(cs);
con.Open();
string cb2 = "update stock set TotalPrice = Totalprice - '" + ListView1.Items[i].SubItems[5].Text + "' where ConfigID= " + ListView1.Items[i].SubItems[1].Text + "";
cmd = new OleDbCommand(cb2);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
}
Save.Enabled = false;
btnPrint.Enabled = true;
GetData();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//
// Генерировать отчет рассписания группы на неделю
//
private void button2_Click(object sender, EventArgs e)
{
string tmp = comboBoxGr.SelectedItem.ToString();
try
{
object ms = Missing.Value;
//
// Создание приложения Excel
//
Excel.Application app = new Excel.Application();
app.Visible = false;
//
// Создание нового документа
//
Excel.Workbook book = app.Workbooks.Add();
// Страница рассписания группы
Excel.Worksheet sheetFlats = book.Worksheets[1];
sheetFlats.Name = "Рассписание группы № " + tmp;
DataTable Schedule = new DataTable("Рассписание выбранной группы");
// День недели
DataColumn flatsColumn = new DataColumn();
flatsColumn.DataType = Type.GetType("System.String");
flatsColumn.ColumnName = "День недели";
Schedule.Columns.Add(flatsColumn);
// Лекция
flatsColumn = new DataColumn();
flatsColumn.DataType = Type.GetType("System.String");
flatsColumn.ColumnName = "Лекция";
Schedule.Columns.Add(flatsColumn);
// Преподователь
flatsColumn = new DataColumn();
flatsColumn.DataType = Type.GetType("System.String");
flatsColumn.ColumnName = "Преподователь";
Schedule.Columns.Add(flatsColumn);
// Кабинет
flatsColumn = new DataColumn();
flatsColumn.DataType = Type.GetType("System.Int32");
flatsColumn.ColumnName = "Кабинет";
Schedule.Columns.Add(flatsColumn);
// Начало
flatsColumn = new DataColumn();
flatsColumn.DataType = Type.GetType("System.String");
flatsColumn.ColumnName = "Начало";
Schedule.Columns.Add(flatsColumn);
//
// Очистка таблицы
//
Schedule.Clear();
//
// Запрос к БД на выборку данных о рассписании за неделю
//
myOleDbCommand.CommandText = "SELECT dayOfTheWeek.dayoftheweek as 'День недели', lessons.name_of_lesson as 'Лекция', lessons.teachers as 'Преподователь', cabinet.number_of_cab as 'Кабинет', lessonTime.start_time as 'Начало' FROM lessonTime INNER JOIN(lessons INNER JOIN (groupp INNER JOIN (dayOfTheWeek INNER JOIN (cabinet INNER JOIN schedule ON cabinet.id_cab = schedule.id_cabinet) ON dayOfTheWeek.id_days = schedule.id_dayOfTheWeek) ON groupp.id_gr = schedule.id_groupp) ON lessons.id_less = schedule.id_lessons) ON lessonTime.id_lessTime = schedule.id_lessonstime WHERE (((groupp.name_of_group)='" + tmp + "'))";
myOleDbConnection.Open();
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();
while (myOleDbDataReader.Read())
{
Schedule.Rows.Add(myOleDbDataReader.GetString(0), myOleDbDataReader.GetString(1), myOleDbDataReader.GetString(2), myOleDbDataReader.GetInt32(3), myOleDbDataReader.GetString(4));
}
myOleDbDataReader.Close();
myOleDbConnection.Close();
//
// Вывод информации о рассписании
//
sheetFlats.Range["A1"].Value = "День недели";
sheetFlats.Range["B1"].Value = "Лекция";
sheetFlats.Range["C1"].Value = "Преподователь";
sheetFlats.Range["D1"].Value = "Кабинет";
sheetFlats.Range["E1"].Value = "Начало";
sheetFlats.get_Range("A1:E1").Font.Color = Color.Green;
for (int i = 0; i < Schedule.Rows.Count; i++)
{
for (int j = 0; j < Schedule.Columns.Count; j++)
{
sheetFlats.Cells[i + 2, j + 1] = Schedule.Rows[i][j].ToString();
sheetFlats.Columns.EntireColumn.AutoFit();
}
}
sheetFlats.Columns.EntireColumn.AutoFit();
// Видимость документа Excel
app.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
// recupération de l'email et le mot de passe
user = mail.Text; //mail
pass = password.Text;
// les Tests de saisie
if (user == "" && pass != "")
{
MessageBox.Show("SVP saisissez votre E-mail");
}
if (user != "" && pass == "")
{
MessageBox.Show("SVP saisissez votre Mot de Passe");
}
if (user == "" && pass == "")
{
MessageBox.Show("SVP saisissez votre E-mail et Mot de Passe");
}
// Connexion au Data Base
try
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=../../../../database.accdb");
OleDbCommand cmd = con.CreateCommand();
con.Open();
Object[] meta = new object[10];
cmd.CommandText = "SELECT * From users where mail='" + mail.Text + "' and password='******'";
cmd.Connection = con;
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
int n = read.GetValues(meta); // le nombre de ligne dans DB
// si il ya un utilisateur avec mail et password saisie
if (n > 0)
{
//les tests sur le type de User authentifié
if (meta[5].ToString() == "0")
{
// demandeur
Demendeur d = new Demendeur();
// passer les données aux fenetre
d.firstname = meta[1].ToString();
d.lastname = meta[2].ToString();
d.id_user = meta[0].ToString();
// affichage
d.Show();
Hide();
}
if (meta[5].ToString() == "1")
{
// technicien
Technicien t = new Technicien();
// passer les données aux fenetre
t.firstname = meta[1].ToString();
t.lastname = meta[2].ToString();
t.id_user = meta[0].ToString();
// affichage
t.Show();
Hide();
}
if (meta[5].ToString() == "2")
{
// admin
Admin a = new Admin();
// passer les données aux fenetre
a.firstname = meta[1].ToString();
a.lastname = meta[2].ToString();
a.id_user = meta[0].ToString();
// affichage
a.Show();
Hide();
}
}
}
con.Close();
}
catch (System.Data.OleDb.OleDbException exp)
{
// cas de erreur lié a la conexion a DB
MessageBox.Show("Erreur de Connexion : " + exp.ToString());
}
}
private void Practise_Load(object sender, EventArgs e)
{
startForm.temp_id = 1;
string appPath = Application.StartupPath;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + appPath + "/eLearning_acc.accdb";
conn.Open();
string strSQL = "SELECT * FROM Accounts123";
OleDbCommand command = new OleDbCommand(strSQL, conn);
OleDbDataReader reader = command.ExecuteReader();
//int temp_correct;
while (reader.Read())
{
//label3.Text = "Correct: " + temp_cor;
if (startForm.temp_id == Convert.ToInt32(reader["ID"]))
{
temp_cor = Convert.ToInt32(reader["Correct4"]);
label3.Text = "Correct: " + temp_cor;
Console.WriteLine("==============================================================================================================ID LINE = " + temp_cor);
}
}
EnglishToGreek.quest_id = RandomNumber(4, 60000);
EnglishToGreek.answ1_id = EnglishToGreek.quest_id;
EnglishToGreek.answ2_id = RandomNumber(3, 67000);
EnglishToGreek.answ3_id = RandomNumber(3, 65000);
Console.WriteLine("answ1_id = " + answ1_id + " || answ1_id = " + answ2_id + " || answ1_id = " + answ3_id + " ||====()()====|| Corrects : " + temp_cor);
int correct = RandomNumber(0, 65000);
int fail1 = correct % 2;
int fail2 = correct % 3;
string cor = "1";
string fa1 = "2";
string fa2 = "3";
if (EnglishToGreek.en_gr == 0)
{
OleDbConnection conn2 = new OleDbConnection();
conn2.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + appPath + "/wordDB2.accdb";
conn2.Open();
string str2SQL = "SELECT * FROM Names123";
OleDbCommand command2 = new OleDbCommand(str2SQL, conn2);
OleDbDataReader reader2 = command2.ExecuteReader();
while (reader2.Read())
{
if (EnglishToGreek.answ1_id == Convert.ToInt32(reader2["ID"]))
{
cor = reader2["Field2"].ToString();
label1.Text = reader2["Field1"].ToString();
Console.WriteLine("Correct Word:" + cor + "-----------");
}
if (EnglishToGreek.answ2_id == Convert.ToInt32(reader2["ID"]))
{
fa1 = reader2["Field2"].ToString();
}
if (EnglishToGreek.answ3_id == Convert.ToInt32(reader2["ID"]))
{
fa2 = reader2["Field2"].ToString();
}
//===================================
EnglishToGreek.cor_answ = cor;
if (fail1 == 0)
{
radioButton1.Text = cor;
radioButton2.Text = fa2;
radioButton3.Text = fa1;
}
else if (fail2 == 0)
{
radioButton1.Text = fa1;
radioButton2.Text = fa2;
radioButton3.Text = cor;
}
else if (correct < 35162)
{
radioButton1.Text = fa2;
radioButton2.Text = cor;
radioButton3.Text = fa1;
}
}
Console.WriteLine("cor = _" + cor + "_ || fa1 = _" + fa1 + "_ || fa2 = _" + fa2 + "_");
reader2.Close();
conn2.Close();
}
//=======================================================================================================================================================================================
if (EnglishToGreek.en_gr == 1)
{
OleDbConnection conn2 = new OleDbConnection();
conn2.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + appPath + "/wordDB2.accdb";
conn2.Open();
string str2SQL = "SELECT * FROM Names123";
OleDbCommand command2 = new OleDbCommand(str2SQL, conn2);
OleDbDataReader reader2 = command2.ExecuteReader();
while (reader2.Read())
{
if (EnglishToGreek.answ1_id == Convert.ToInt32(reader2["ID"]))
{
cor = reader2["Field1"].ToString();
label1.Text = reader2["Field2"].ToString();
}
if (EnglishToGreek.answ2_id == Convert.ToInt32(reader2["ID"]))
{
fa1 = reader2["Field1"].ToString();
}
if (EnglishToGreek.answ3_id == Convert.ToInt32(reader2["ID"]))
{
fa2 = reader2["Field1"].ToString();
}
//====================
EnglishToGreek.cor_answ = cor;
if (fail1 == 0)
{
radioButton1.Text = cor;
radioButton2.Text = fa2;
radioButton3.Text = fa1;
}
else if (fail2 == 0)
{
radioButton1.Text = fa1;
radioButton2.Text = fa2;
radioButton3.Text = cor;
}
else if (correct < 35162)
{
radioButton1.Text = fa2;
radioButton2.Text = cor;
radioButton3.Text = fa1;
}
else
{
radioButton1.Text = cor;
radioButton2.Text = fa2;
radioButton3.Text = fa1;
}
}
Console.WriteLine("cor = _" + cor + "_ || fa1 = _" + fa1 + "_ || fa2 = _" + fa2 + "_");
reader2.Close();
conn2.Close();
}
//===============================================================
reader.Close();
conn.Close();
}
public FuncStatus DataBind(BindOperator _bo)
{
bool _tf = true;
OleDbConnection _conn = new OleDbConnection(Prument.Properties.Settings.Default.Properties["dataConnectionString"].DefaultValue.ToString());
OleDbCommand _cmd = new OleDbCommand();
OleDbDataReader _dr;
_cmd.Connection = _conn;
try
{
_conn.Open();
if (_bo == BindOperator.Select)
{
_cmd.CommandText = "select Products.ID,Products.Name,Products.Description from Products where " + (this.ID != 0 ? "ID=" + this.ID.ToString() : (this.Name != null ? "Name='" + this.Name : "Description like '_" + this.Description + "_") + "'");
}
if (_bo == BindOperator.Insert)
{
_cmd.CommandText = "insert into Products (Name,Description) values ('" + this.Name + "','" + this.Description + "')";
_cmd.ExecuteScalar();
_cmd.CommandText = "select ID,Name,Description from products where id = (select Max(ID) from Products)";
}
if (_bo == BindOperator.Update) {
_cmd.CommandText = "update products set Name='" + this.Name + "',Description='" + this.Description + "' where ID=" +this.ID;
_cmd.ExecuteNonQuery();
_cmd.CommandText = "select ID,Name,Description from products where id = " + this.ID;
}
if (_bo == BindOperator.Delete)
{
_cmd.CommandText = "select ID,Name,Description from products where id = " + this.ID;
}
_dr = _cmd.ExecuteReader();
_dr.Read();
this.ID = _dr.GetInt32(0);
this.Name = _dr.GetValue(1).ToString();
this.Description = _dr.GetValue(2).ToString();
this.Images.pID = this.ID;
_dr.Close();
if (_bo == BindOperator.Select) {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Insert) {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Update && this.Images.Path[0] != "") {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Delete)
{
_cmd.CommandText = "delete from products where ID=" + this.ID;
_cmd.ExecuteNonQuery();
this.Images.clear();
this.Images.DataBind(BindOperator.Update);
}
this.Status = ORMStatus.Saved;
}
catch (Exception ex)
{
_tf = false;
Exception _ex = new Exception("ORM.Products["+this.ID+"]:" + ex.Message);
throw _ex;
}
finally {
_conn.Close();
}
return _tf == false?FuncStatus.Fail:FuncStatus.Success;
}
private void btnRem_Click(object sender, EventArgs e)
{
//Check Null
if (cboxUTy.Text == "" || txtPW.Text == "" || txtUN.Text == "")
{
MessageBox.Show("Required fields cannot not be left blank.", "Blank Fields", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End;
}
//Remove aingle double quotes in textboxes
foreach (Control c in this.Controls)
{
if (c is TextBox || c is ComboBox)
{
c.Text = c.Text.Replace("'", ""); c.Text = c.Text.Replace("\"", "");
}
}
//Declarations
string UN = txtUN.Text, PW = txtPW.Text, Ty = cboxUTy.Text;
if (Ty == "Administrator")
{
Ty = "Admin";
}
//Check Valid
string sqlCheck = string.Format("SELECT * FROM UserAccount WHERE UName = '{0}' AND UType = '{1}' AND Pwd = '{2}'", UN, Ty, PW);
OleDbCommand cmdCheck = new OleDbCommand(sqlCheck, db.con);
if (db.con.State.Equals(ConnectionState.Closed))
{
db.con.Open();
}
OleDbDataReader drCheck = cmdCheck.ExecuteReader(); drCheck.Read();
if (!drCheck.HasRows)
{
MessageBox.Show("No User account with such combination exists.", "Invalid Credentials", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End;
}
//Verify Delete
DialogResult sure = MessageBox.Show("Are you sure you want to remove this account? This action cannot be undone.", "Are you sure?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (sure != DialogResult.Yes)
{
goto End;
}
string sqlRem = string.Format("DELETE FROM UserAccount WHERE UName = '{0}' AND UType = '{1}' AND Pwd = '{2}'", UN, Ty, PW);
OleDbCommand cmdRem = new OleDbCommand(sqlRem, db.con); cmdRem.ExecuteNonQuery();
//Success
MessageBox.Show("The user account has been deleted successfully.", "Removal Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Reset Controls
txtPW.Text = txtUN.Text = cboxUTy.Text = "";
End : if (db.con.State.Equals(ConnectionState.Open))
{
db.con.Close();
}
}
/* Загрузка прайсов из Плана закупок */
bool loadPrices()
{
priceList = new List <Price>();
Price price;
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL)
{
// OLEDB
try{
if (oleDbCommand != null)
{
oleDbCommand.Dispose();
}
oleDbCommand = new OleDbCommand("SELECT counteragentName, counteragentPricelist, " +
"docID FROM PurchasePlanPriceLists WHERE (docID = '" + docPPNumber +
"')", oleDbConnection);
oleDbConnection.Open();
oleDbDataReader = oleDbCommand.ExecuteReader();
while (oleDbDataReader.Read())
{
price = new Price();
price.counteragentName = oleDbDataReader["counteragentName"].ToString();
price.priceName = oleDbDataReader["counteragentPricelist"].ToString();
priceList.Add(price);
}
oleDbDataReader.Close();
oleDbConnection.Close();
if (priceList.Count > 0)
{
return(true);
}
else
{
return(false);
}
}catch (Exception ex) {
Utilits.Console.Log("[ОШИБКА] " + ex.Message.ToString(), false, true);
return(false);
}
}
else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER)
{
// MSSQL SERVER
try{
if (sqlCommand != null)
{
sqlCommand.Dispose();
}
sqlCommand = new SqlCommand("SELECT counteragentName, counteragentPricelist, " +
"docID FROM PurchasePlanPriceLists WHERE (docID = '" + docPPNumber +
"')", sqlConnection);
sqlConnection.Open();
sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
price = new Price();
price.counteragentName = sqlDataReader["counteragentName"].ToString();
price.priceName = sqlDataReader["counteragentPricelist"].ToString();
priceList.Add(price);
}
sqlDataReader.Close();
sqlConnection.Close();
if (priceList.Count > 0)
{
return(true);
}
else
{
return(false);
}
}catch (Exception ex) {
Utilits.Console.Log("[ОШИБКА] " + ex.Message.ToString(), false, true);
return(false);
}
}
return(false);
}
private void girisyapButon_Click(object sender, EventArgs e)
{
if (sayikontrol == 1)
{
siparisim.Open();
OleDbCommand select = new OleDbCommand("select * from kullanicilar", siparisim);
OleDbDataReader kayitOku = select.ExecuteReader();
while (kayitOku.Read())
{
if (kayitOku["kullaniciad"].ToString() == textBox1.Text && kayitOku["sifre"].ToString() == textBox2.Text)
{
durum = true;
label3.ForeColor = Color.White;
kullaniciId = int.Parse(kayitOku.GetValue(0).ToString());
adSoyad = kayitOku.GetValue(1).ToString();
kullaniciad = kayitOku.GetValue(2).ToString();
sifre = kayitOku.GetValue(3).ToString();
yetki = kayitOku.GetValue(4).ToString();
il = kayitOku.GetValue(5).ToString();
this.Hide();
KullaniciAnasayfa frm4 = new KullaniciAnasayfa();
frm4.Show();
break;
}
else
{
label3.ForeColor = Color.Red;
}
}
siparisim.Close();
}
else if (sayikontrol == 2)
{
siparisim.Open();
OleDbCommand select = new OleDbCommand("select * from saticilar", siparisim);
OleDbDataReader kayitOku = select.ExecuteReader();
while (kayitOku.Read())
{
if (kayitOku["saticikullaniciad"].ToString() == textBox1.Text && kayitOku["saticisifre"].ToString() == textBox2.Text)
{
durum = true;
label3.ForeColor = Color.White;
saticiId = int.Parse(kayitOku.GetValue(0).ToString());
saticiAdSoyad = kayitOku.GetValue(1).ToString();
saticikullaniciad = kayitOku.GetValue(2).ToString();
saticisifre = kayitOku.GetValue(3).ToString();
saticiyetki = kayitOku.GetValue(4).ToString();
saticidogumtarihi = kayitOku.GetValue(5).ToString();
sirketadi = kayitOku.GetValue(6).ToString();
this.Hide();
SaticiAnasayfa frm6 = new SaticiAnasayfa();
frm6.Show();
break;
}
else
{
label3.ForeColor = Color.Red;
}
}
siparisim.Close();
}
else if (sayikontrol == 3)
{
siparisim.Open();
OleDbCommand select = new OleDbCommand("select * from yöneticiler", siparisim);
OleDbDataReader kayitOku = select.ExecuteReader();
while (kayitOku.Read())
{
if (kayitOku["yoneticiad"].ToString() == textBox1.Text && kayitOku["yoneticisifre"].ToString() == textBox2.Text)
{
label3.ForeColor = Color.White;
yoneticiad = kayitOku.GetValue(0).ToString();
yoneticisifre = kayitOku.GetValue(1).ToString();
this.Hide();
YoneticiAnasayfa frm11 = new YoneticiAnasayfa();
frm11.Show();
break;
}
else
{
label3.ForeColor = Color.Red;
}
}
siparisim.Close();
}
}
void fill_profile()
{
if (Program.dataSource == Program.DataSources.Access)
{
try
{
dbcmd.CommandText = "select * from students where studid = " + Program.lstudid;
dbr = dbcmd.ExecuteReader();
dbr.Read();
}
catch (Exception ie)
{
MessageBox.Show(ie.Message);
this.Close();
}
}
else
{
try
{
Odbcmd.CommandText = "select * from students where studid = " + Program.lstudid;
Odbr = Odbcmd.ExecuteReader();
Odbr.Read();
}
catch (Exception ie)
{
MessageBox.Show(ie.Message);
this.Close();
}
}
txtID.Text = getLong("studid").ToString();
txtName.Text = getString("fullname");
sel_cb(ref cbSex, getLong("sex"));
sel_cb(ref cbLevel, getLong("ilevel"));
txtSchool.Text = getString("school");
sel_cb(ref cbCenter, getLong("center"));
txtShirtSize.Text = getString("shirtsize");
sel_cb(ref cbSchedule, getLong("schedule"));
txtEmail1.Text = getString("s_email");
txtEmail2.Text = getString("email");
txtRemarks.Text = getString("remarks");
txtProfile.Text = getString("profilescan");
txtDepSlip.Text = getString("depslipscan");
if (getLong("is_qualified") < 0)
{
chkQualified.Checked = true;
}
else
{
chkQualified.Checked = false;
}
if (getLong("depslip") < 0)
{
chkDepSlip.Checked = true;
}
else
{
chkDepSlip.Checked = false;
}
if (getLong("is_emailed") < 0)
{
chkEmailed.Checked = true;
}
else
{
chkEmailed.Checked = false;
}
if (Program.dataSource == Program.DataSources.Access)
{
dbr.Close();
}
else
{
Odbr.Close();
}
}
public static string GetOtherName()
{
string sql = "SELECT * FROM 非生產 WHERE 編號 = " + Global.NonProduct_Other;
OleDbCommand cmd = new OleDbCommand(sql, Instance.Connection);
Instance.Connection.Open();
OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
string name = dr["名稱"].ToString();
dr.Close();
Instance.Connection.Close();
return name;
}
public int DeleteEx(string id)
{
int retVal = 0;
OleDbConnection conn = Instance.Connection;
OleDbTransaction transaction = null;
OleDbCommand cmd = new OleDbCommand();
conn.Open();
try
{
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
//改正產品檢驗資料
//取得產品檢驗資料
cmd.CommandText = "SELECT * FROM 產品檢驗 WHERE 工時資料編號=?";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("工時資料編號", id));
OleDbDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
string last = reader["最後送檢編號"].ToString();
int inspectDel = (int)reader["送檢次數"];
reader.Close();
cmd.CommandText = "SELECT * FROM 產品檢驗 WHERE 最後送檢編號=? AND 工時資料編號<>? ORDER BY 送檢次數 ASC";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("最後送檢編號old", last));
cmd.Parameters.Add(new OleDbParameter("工時資料編號", id));
OleDbDataReader reader2 = cmd.ExecuteReader();
while (reader2.Read())
{
string nextID = reader2["工時資料編號"].ToString();
int inspect = (int)reader2["送檢次數"];
if (inspect > inspectDel)
{
//將該筆之後的檢驗資料做處理
OleDbCommand cmd2 = new OleDbCommand();
cmd2.Connection = conn;
cmd2.Transaction = transaction;
cmd2.CommandText = "UPDATE 產品檢驗 SET 送檢次數=送檢次數-1 WHERE 工時資料編號=?";
cmd2.Parameters.Clear();
cmd2.Parameters.Add(new OleDbParameter("工時資料編號", nextID));
cmd2.ExecuteNonQuery();
}
else
{
//將該筆之前的檢驗資料做處理
}
}
reader2.Close();
//刪除產品檢驗資料
cmd.CommandText = "DELETE FROM 產品檢驗 WHERE 工時資料編號=?";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("工時資料編號", id));
cmd.ExecuteNonQuery();
//挑出最後一筆檢驗紀錄
cmd.CommandText = "SELECT 工時資料編號 FROM 產品檢驗 WHERE 最後送檢編號 =? ORDER BY 送檢次數 DESC";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("最後送檢編號old", last));
reader2 = cmd.ExecuteReader();
if (reader2.Read())
{
string maxID = reader2["工時資料編號"].ToString();
reader2.Close();
//將原有的最後檢驗紀錄更新
cmd.CommandText = "UPDATE 產品檢驗 SET 最後送檢編號=?, 最後檢驗紀錄=FALSE, 重驗=TRUE WHERE 最後送檢編號=?";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("最後送檢編號new", maxID));
cmd.Parameters.Add(new OleDbParameter("最後送檢編號old", last));
cmd.ExecuteNonQuery();
//將最後一筆設成最後檢驗記錄
cmd.CommandText = "UPDATE 產品檢驗 SET 最後檢驗紀錄=TRUE, 重驗=FALSE WHERE 工時資料編號=?";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("工時資料編號", maxID));
cmd.ExecuteNonQuery();
}
if (!reader2.IsClosed)
reader2.Close();
}
if (!reader.IsClosed)
reader.Close();
//刪除工時資料
cmd.CommandText = "DELETE FROM 工時 WHERE 編號=?";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter("編號", id));
retVal = cmd.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
try
{
transaction.Rollback();
}
catch (Exception) { }
try
{
conn.Close();
}
catch (Exception) { }
throw ex;
}
conn.Close();
return retVal;
}
public static string CheckFeatureSAID_oledb(String connectionName, String tableName, String txtObjectIDText, String saidField)
{
string returnSAID = "";
//Check if the data record as a valie SiteAccess ID
string ConnStr = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
OleDbConnection Conn = new OleDbConnection(ConnStr);
string strSQL = string.Format("SELECT * FROM [{0}] WHERE [{1}] = {2}", tableName, "OBJECTID", txtObjectIDText);
OleDbCommand pDBC = new OleDbCommand(strSQL, Conn);
pDBC.Connection.Open();
OleDbDataReader pDReader = pDBC.ExecuteReader();
if (pDReader.HasRows)
{
pDReader.Read();
if ((pDReader[saidField] is System.DBNull) || String.IsNullOrEmpty(pDReader[saidField].ToString()))
{
//currently no SAID
OleDbConnection Conn2 = new OleDbConnection(ConnStr);
//assign temporary SAID
string newSAID = txtObjectIDText;
//check if feature class already uses this new SAID
string strSqlQuerySAID = string.Format("SELECT * FROM [{0}] WHERE [{1}]='{2}'", tableName, saidField, txtObjectIDText);
OleDbCommand queryCommand = new OleDbCommand(strSqlQuerySAID, Conn2);
queryCommand.Connection.Open();
int recordCount = queryCommand.ExecuteNonQuery();
queryCommand.Connection.Close();
if (recordCount == 0)
{
//OK, use OBJECTID as new SAID
//do nothing
}
else
{
//this SAID has already been used, find another one
string queryMaxSAID = string.Format("SELECT MAX(INT([{0}])) + 1 FROM [{1}]", saidField, tableName);
OleDbCommand maxSAIDCommand = new OleDbCommand(queryMaxSAID, Conn2);
maxSAIDCommand.Connection.Open();
newSAID = maxSAIDCommand.ExecuteScalar().ToString(); //this will not return null as we can only fall here if SAID already exists
maxSAIDCommand.Connection.Close();
}
//now assign SAID
string strSqlUpdate = string.Format("UPDATE [{0}] SET [{1}]='{2}' WHERE [{3}] = {4}", tableName, saidField, newSAID, "OBJECTID", txtObjectIDText);
OleDbCommand pUpdateCommand = new OleDbCommand(strSqlUpdate, Conn2);
pUpdateCommand.Connection.Open();
pUpdateCommand.ExecuteNonQuery();
pUpdateCommand.Connection.Close();
returnSAID = txtObjectIDText;
}
else
{
//SAID exists, use it!!
returnSAID = pDReader[saidField].ToString();
}
}
pDBC.Connection.Close();
return(returnSAID);
}
private void registerWrite_Click(object sender, EventArgs e)
{
connection.Open();
OleDbCommand command = new OleDbCommand(); // Establishes that a command is going to be used, usually a SQL statement.
command.Connection = connection; // States the command should be associated with the current connection.
command.CommandText = "select * from userAccount where Username='******'";
// SQL statement is stated here, used to detect if the username has already been used.
// username1 and password1 refer to the text boxes used in the login form.
OleDbDataReader reader = command.ExecuteReader(); // Goes through each record and tries to find appropriate matches with that above SQL.
int count = 0; // Stores a local variable to this method to allow the use of a loop.
while (reader.Read())
{
count++; // Implements variable count by 1 when a match is found.
}
if (count == 1)
{
MetroMessageBox.Show(this, "Username is already used, try another name.", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
// detects if username and passwords have duplicates, will be avoided in registration process to allowevery usernamne to be unique.
connection.Close();
}
else if (passwordRegister.Text == passwordRepeat.Text)
// Checks if the password repeated and the original matches, as to disallow mistakes to be made when entering the data in the value.
{
if (emailRegister.Text.Contains("@") && emailRegister.Text.Contains("."))
// Checks if the email contains the appropriate symbols for a valid email address
{
try
{
OleDbCommand command1 = new OleDbCommand();
command1.Connection = connection;
command1.CommandText = "insert into userAccount([Username],[Password],[EmailAddress],[FirstName],[SecondName]) values('" + usernameRegister.Text + "','"
+ passwordRegister.Text + "','" + emailRegister.Text + "', '" + firstNameReg.Text + "', '" + secondNameReg.Text + "')";
command1.ExecuteNonQuery();
MetroMessageBox.Show(this, "Account Registered successfully, login now available.", "Account Registered", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk);
connection.Close();
//This opens the database connection using the OleDb method first stated in 'using...'.
// It then establishes a new command wants to be executed using command, and the command 'text' is an SQL statement that will insert data
// into the appropriate collumns within the database, userAccount() refers to the collumns in the table, and
// values() captures the database from the textbox that is being used.
//Finally, the connection is closed as to not damage the database being used.
this.Hide();
login loginPage = new login();
loginPage.Show();
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "Error" + ex, "Error Registering Account", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
connection.Close();
}
}
else
{
MessageBox.Show("Email formatted incorrectly... ");
}
// Shows a message if the email is formatted incorrectly, to allow the user to ammend the data to make it appropriate.
}
else
{
MetroMessageBox.Show(this, "Ensure your repeated password matches with password", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
connection.Close();
// shows an error
}
connection.Close();
}
private void finish_Click(object sender, EventArgs e) //завершить
{
if (!Data.IsFilled(fields))
{
MessageBox.Show("Заполните пустые поля!", "Внимание");
return;
}
#region Запись в объекты
educationActivity.period = maskedTextBoxPeriod.Text;
educationActivity.levels = educationActivity.SetFromTables(educationActivity.levels, tables);
educationActivity.confessions = educationActivity.SetFromTables(educationActivity.confessions, tablesA);
#endregion
OleDbCommand command = new OleDbCommand("INSERT INTO Education (Период, Статус, Уровень1,Уровень2,Уровень3,Уровень4,Уровень5,УровеньА1, УровеньА2, УровеньА3, УровеньА4, УровеньА5, Результат)" +
"VALUES(@Период, @Статус, @Уровень1,@Уровень2,@Уровень3,@Уровень4,@Уровень5,@УровеньА1, @УровеньА2, @УровеньА3, @УровеньА4, @УровеньА5, @Результат)", Data.OleDbConnection);
command.Parameters.AddWithValue("Период", educationActivity.period.ToString());
command.Parameters.AddWithValue("Статус", educationActivity.status.ToString());
command.Parameters.AddWithValue("Уровень1", educationActivity.levels[0].SetEventsInDataBase());
command.Parameters.AddWithValue("Уровень2", educationActivity.levels[1].SetEventsInDataBase());
command.Parameters.AddWithValue("Уровень3", educationActivity.levels[2].SetEventsInDataBase());
command.Parameters.AddWithValue("Уровень4", educationActivity.levels[3].SetEventsInDataBase());
command.Parameters.AddWithValue("Уровень5", educationActivity.levels[4].SetEventsInDataBase());
command.Parameters.AddWithValue("УровеньА1", educationActivity.confessions[0].SetEventsInDataBase());
command.Parameters.AddWithValue("УровеньА2", educationActivity.confessions[1].SetEventsInDataBase());
command.Parameters.AddWithValue("УровеньА3", educationActivity.confessions[2].SetEventsInDataBase());
command.Parameters.AddWithValue("УровеньА4", educationActivity.confessions[3].SetEventsInDataBase());
command.Parameters.AddWithValue("УровеньА5", educationActivity.confessions[4].SetEventsInDataBase());
command.Parameters.AddWithValue("Результат", educationActivity.result.ToString());
command.ExecuteNonQuery();
int idEducation = 0;
command = new OleDbCommand("SELECT @@IDENTITY AS id", Data.OleDbConnection);
OleDbDataReader sqlReaderA = null;
sqlReaderA = command.ExecuteReader();
while (sqlReaderA.Read())
{
idEducation = Convert.ToInt32(sqlReaderA["id"]);
}
if (sqlReaderA != null)
{
sqlReaderA.Close();
}
educationActivity.human.SetInDataBase(idEducation); //запись человека в базу
#region Запись в Word
educationActivity.SetInWord();
#endregion
if (!Data.panel.Controls.Contains(Tables.Instance))
{
Data.panel.Controls.Add(Tables.Instance);
Tables.Instance.Dock = DockStyle.Fill;
Tables.Instance.BringToFront();
}
else
{
Tables.Instance.BringToFront();
}
}
private void button1_Click(object sender, EventArgs e)
{
//design
button1.Show();
label3.Show();
pictureBox1.Hide();
//button1.Text = " Submit ";
button1.Text = "Submit";
button1.BackColor = Color.DarkSlateGray;
button1.ForeColor = Color.White;
//
OleDbConnection conn = new OleDbConnection();
string appPath = Application.StartupPath;
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + appPath + "/eLearning_acc.accdb";
conn.Open();
int new_cor;
string strSQL;
if ((groupBox1.Controls[0].Text.Equals(EnglishToGreek.cor_answ) || groupBox1.Controls[0].Text.Equals(" " + EnglishToGreek.cor_answ)) && radioButton3.Checked)
{
new_cor = EnglishToGreek.temp_cor + 1;
EnglishToGreek.temp_cor = new_cor;
strSQL = "UPDATE Accounts123 SET Correct4=" + new_cor + " WHERE ID=" + startForm.temp_id;
OleDbCommand command = new OleDbCommand(strSQL, conn);
OleDbDataReader reader = command.ExecuteReader();
//groupBox1.Controls[0].Text += "_hi";
Console.WriteLine(groupBox1.Controls[0].Text + "---------------------===========================CORRECT!!!===========================---------------------");
}
else if ((groupBox1.Controls[1].Text.Equals(EnglishToGreek.cor_answ) || groupBox1.Controls[1].Text.Equals(" " + EnglishToGreek.cor_answ)) && radioButton2.Checked)
{
new_cor = EnglishToGreek.temp_cor + 1;
EnglishToGreek.temp_cor = new_cor;
strSQL = "UPDATE Accounts123 SET Correct4=" + new_cor + " WHERE ID=" + startForm.temp_id;
OleDbCommand command = new OleDbCommand(strSQL, conn);
OleDbDataReader reader = command.ExecuteReader();
//groupBox1.Controls[1].Text += "_hi";
Console.WriteLine(groupBox1.Controls[1].Text + "---------------------===========================CORRECT!!!===========================---------------------");
}
else if ((groupBox1.Controls[2].Text.Equals(EnglishToGreek.cor_answ) || groupBox1.Controls[2].Text.Equals(" " + EnglishToGreek.cor_answ)) && radioButton1.Checked)
{
new_cor = EnglishToGreek.temp_cor + 1;
EnglishToGreek.temp_cor = new_cor;
strSQL = "UPDATE Accounts123 SET Correct4=" + new_cor + " WHERE ID=" + startForm.temp_id;
OleDbCommand command = new OleDbCommand(strSQL, conn);
OleDbDataReader reader = command.ExecuteReader();
//groupBox1.Controls[2].Text += "_hi";
Console.WriteLine(groupBox1.Controls[2].Text + "---------------------===========================CORRECT!!!===========================---------------------");
}
else
{
Console.WriteLine("--------------------------------WRONG ANSWER--------------------------------");
}
Console.WriteLine("groupBox1.Controls[0].Text = _" + groupBox1.Controls[0].Text + "_ || groupBox1.Controls[1].Text = _" + groupBox1.Controls[1].Text + "_ || groupBox1.Controls[2].Text = _" + groupBox1.Controls[2].Text + "_");
Console.WriteLine("Practise.cor_answ = _" + EnglishToGreek.cor_answ + "_");
Console.WriteLine("Radio 1 = " + radioButton1.Checked);
Console.WriteLine("Radio 2 = " + radioButton2.Checked);
Console.WriteLine("Radio 3 = " + radioButton3.Checked);
Practise_Load(this, e);
}
public static List <Answer> GetAnswers()
{
Tasks buff = ViewModel.TasksViewModel.CurrentTask;
string connectString = "provider=Microsoft.ACE.Oledb.12.0;Data Source= " + System.AppDomain.CurrentDomain.BaseDirectory + "\\AducationBase.accdb;";
OleDbConnection connection = new OleDbConnection(connectString);
string query = "SELECT Ответы.ID, Ответы.ЗаданиеID, Ответы.УчительID, Ответы.УченикID, Ответы.Дата, Ответы.ТекстОтвета, Ответы.ДопФайлы, Ответы.Оценка, Ответы.Комментарий" +
" FROM Ответы WHERE( ((Ответы.ЗаданиеID) = " + buff.ID + " ) AND((Ответы.УчительID) = " + Data.TeacherUsr.ID + " ) );";
OleDbCommand command = new OleDbCommand(query, connection);
connection.Open();
OleDbDataReader dataReader = command.ExecuteReader();
List <Answer> result = new List <Answer>();
System.IO.Directory.CreateDirectory("ImageBuffFolder");
while (dataReader.Read())
{
try
{
Answer buffAnswer = new Answer();
buffAnswer.ID = (int)dataReader["ID"];
buffAnswer.TeacherID = (int)dataReader["УчительID"];
buffAnswer.StudentID = (int)dataReader["УченикID"];
buffAnswer.TaskID = (int)dataReader["ЗаданиеID"];
buffAnswer.Date = (DateTime)dataReader["Дата"];
buffAnswer.DateStr = ((DateTime)(dataReader["Дата"])).ToLongDateString();
buffAnswer.AnswerText = (string)dataReader["ТекстОтвета"];
try
{
buffAnswer.Mark = (string)dataReader["Оценка"];
}
catch
{
buffAnswer.Mark = "Не оценено";
}
try
{
buffAnswer.Comment = (string)dataReader["Комментарий"];
}
catch
{
buffAnswer.Comment = "";
}
buffAnswer.GetFIO();
try
{
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
memoryStream.Write((byte[])dataReader["ДопФайлы"], 0, ((byte[])dataReader["ДопФайлы"]).Length);
System.Drawing.Image image = System.Drawing.Image.FromStream(memoryStream);
image.Save(@"ImageBuffFolder\" + buffAnswer.ID + "answ.BMP");
memoryStream.Dispose();
ImageSourceConverter imageSourceConverter = new ImageSourceConverter();
buffAnswer.AnswerImage = new Image();
buffAnswer.AnswerImage.SetValue(System.Windows.Controls.Image.SourceProperty, imageSourceConverter.ConvertFromString(@"ImageBuffFolder\" + buffAnswer.ID + "answ.BMP"));
buffAnswer.IMGS = buffAnswer.AnswerImage.Source;
}
catch { }
result.Add(buffAnswer);
}
catch { }
}
try
{
NewTaskAnswer.TaskID = result[0].ID;
}
catch
{
NewTaskAnswer.TaskID = -1;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SID"] != null)
{
studentid.Text = Session["SID"].ToString();
}
con = new OleDbConnection();
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PPTPROJECT.mdb";
con.Open();
cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = "select * from studentlogin WHERE SID=" + studentid.Text + "";
rs = cmd.ExecuteReader();
while (rs.Read())
{
if (rs[0].ToString() == studentid.Text)
{
Studentsid.Text = rs.GetValue(0).ToString();
rollno.Text = rs.GetValue(3).ToString();
usernameLabel.Text = rs.GetValue(4).ToString();
passwordLabel.Text = rs.GetValue(5).ToString();
}
}
con.Close();
con.Open();
cmd = new OleDbCommand();
cmd.Connection = con;
//int a = Convert.ToInt32(tid.Text);
cmd.CommandText = "select * from studentinfo WHERE SID='" + studentid.Text + "'";
rs = cmd.ExecuteReader();
while (rs.Read())
{
if (rs[0].ToString() == studentid.Text)
{
firstname.Text = rs.GetValue(1).ToString();
middlename.Text = rs.GetValue(2).ToString();
lastname.Text = rs.GetValue(3).ToString();
emailLabel.Text = rs.GetValue(4).ToString();
dob.Text = rs.GetValue(5).ToString() + "/" + rs.GetValue(6).ToString() + "/" + rs.GetValue(7).ToString();
gender.Text = rs.GetValue(8).ToString();
mobno.Text = rs.GetValue(9).ToString();
address.Text = rs.GetValue(10).ToString();
bloodgroup.Text = rs.GetValue(11).ToString();
// ImageButton1.ImageUrl= rs.GetValue(10).ToString();
}
}
abc.Text = firstname.Text + " " + lastname.Text;
con.Close();
con.Open();
cmd = new OleDbCommand();
cmd.Connection = con;
//int a = Convert.ToInt32(tid.Text);
cmd.CommandText = "select * from studentinfo WHERE SID='" + studentid.Text + "'";
rs = cmd.ExecuteReader();
while (rs.Read())
{
if (rs[12].ToString().Length > 1)
{
ImageButton1.ImageUrl = rs[12].ToString();
}
}
con.Close();
}
protected void btnImportRecord_Click(object sender, EventArgs e)
{
if (IsValid)
{
// if you have Excel 2007 uncomment this line of code
//string excelConnectionString =string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0",path);
string ExcelContentType = "application/vnd.ms-excel";
string Excel2010ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
if (FileUpload1.HasFile)
{
//Check the Content Type of the file
if (FileUpload1.PostedFile.ContentType == ExcelContentType || FileUpload1.PostedFile.ContentType == Excel2010ContentType)
{
try
{
//Save file path
string path = string.Concat(Server.MapPath("../UploadFile/"), FileUpload1.FileName);
//Save File as Temp then you can delete it if you want
FileUpload1.SaveAs(path);
//string path = @"C:\Users\Johnney\Desktop\ExcelData.xls";
//For Office Excel 2010 please take a look to the followng link http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/0f03c2de-3ee2-475f-b6a2-f4efb97de302/#ae1e6748-297d-4c6e-8f1e-8108f438e62e
string excelConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", path);
// Create Connection to Excel Workbook
using (OleDbConnection connection =
new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand
("Select * FROM [Sheet1$]", connection);
connection.Open();
// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = ConfigurationManager.ConnectionStrings["PMCDBConnectionString"].ConnectionString;
// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy =
new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "tbl05_SinhVien";
bulkCopy.WriteToServer(dr);
panelError.Visible = true;
lblError.Text = "The data has been exported succefuly from Excel to SQL";
GridView1.DataBind();
}
}
}
StringBuilder sb = new StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("alert('Record Imported Successfully');");
sb.Append("$('#importModal').modal('hide');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ImportHideModalScript", sb.ToString(), false);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
}
}
}
private void button4_Click(object sender, EventArgs e)
{
String connection = "Provider=OraOLEDB.Oracle;Data Source=localhost;User Id=system;Password=system;OLEDB.NET=True";
OleDbConnection obj3 = new OleDbConnection(connection);
String query1 = "select max_books from reader where rid = '" + textBox4.Text + "'";
String query2 = "select count(rid) from current_borrowings where rid='" + textBox4.Text + "'";
OleDbCommand cm4 = new OleDbCommand(query1, obj3);
obj3.Open();
OleDbDataReader rd = cm4.ExecuteReader();
Int64 Max_books = 0;
while (rd.Read())
{
Max_books = int.Parse(rd[0].ToString());
}
obj3.Close();
OleDbConnection obj4 = new OleDbConnection(connection);
OleDbCommand cm5 = new OleDbCommand(query2, obj4);
obj4.Open();
OleDbDataReader rd1 = cm5.ExecuteReader();
Int64 current_taken = 0;
while (rd1.Read())
{
current_taken = int.Parse(rd1[0].ToString());
}
obj4.Close();
if (current_taken + 1 > Max_books)
{
string error_string = "The Reader has exceeded its maximum books limit";
MessageBox.Show(error_string);
comboBox1.ResetText();
textBox2.Clear();
textBox4.Clear();
}
else
{
OleDbConnection obj5 = new OleDbConnection(connection);
obj5.Open();
string query3 = "Select isbn from book where Title='" + comboBox1.Text + "'";
OleDbCommand cm6 = new OleDbCommand(query3, obj5);
OleDbDataReader rd2 = cm6.ExecuteReader();
String isbn = string.Empty;
while (rd2.Read())
{
isbn = rd2[0].ToString();
}
Int64 trans = Int64.Parse(textBox1.Text);
Int64 copy = Int64.Parse(textBox2.Text);
String query4 = "insert into borrowed_by(Transaction_no, isbn, copy_no, rid,return) values(" + trans + ",'" + isbn + "'," + copy + ",'" + textBox4.Text + "', NULL)";
try
{
OleDbCommand cm7 = new OleDbCommand(query4, obj5);
cm7.ExecuteNonQuery();
MessageBox.Show("Successful");
textBox1.Clear();
textBox2.Clear();
textBox4.Clear();
}
catch (Exception ee)
{
MessageBox.Show("Error...");
}
obj5.Close();
}
}
public wsINFOCliente dbObterCliente(string pNumeroProcesso)
{
StringBuilder strSQL = null;
OleDbConnection objConn = null;
OleDbCommand objCmd = null;
OleDbDataReader objDr = null;
wsINFOCliente objCliente = null;
try
{
strSQL = new StringBuilder();
strSQL.AppendLine(" SELECT c.id_cliente, c.cliente, c.nome, c.cnpj, p.id_processo ");
strSQL.AppendLine(" FROM clientes c, processos p WHERE c.id_cliente = p.id_cliente ");
strSQL.AppendLine(" AND p.nref = '" + pNumeroProcesso + "'");
objConn = new OleDbConnection(strConnection);
objConn.Open();
objCmd = new OleDbCommand(strSQL.ToString(), objConn);
objDr = objCmd.ExecuteReader();
if (objDr != null)
{
if (objDr.Read())
{
objCliente = new wsINFOCliente();
if (objDr["id_cliente"] != DBNull.Value)
{
objCliente.IdCliente = (int)objDr["id_cliente"];
}
if (objDr["cliente"] != DBNull.Value)
{
objCliente.NomeCliente = objDr["cliente"].ToString();
}
else
{
objCliente.NomeCliente = null;
}
if (objDr["nome"] != DBNull.Value)
{
objCliente.NomeMapa = objDr["nome"].ToString();
}
else
{
objCliente.NomeMapa = null;
}
if (objDr["cnpj"] != DBNull.Value)
{
objCliente.NumeroCNPJ = objDr["cnpj"].ToString();
}
else
{
objCliente.NumeroCNPJ = null;
}
if (objDr["id_processo"] != DBNull.Value)
{
objCliente.IdProcessoSigpa = (int)objDr["id_processo"];
}
}
}
return(objCliente);
}
catch (Exception ex)
{
throw ex;
}
finally {
if (objCmd != null)
{
objCmd.Dispose();
objCmd = null;
}
if (objDr != null)
{
if (objDr.IsClosed == false)
{
objDr.Close();
}
objDr = null;
}
if (objConn.State == System.Data.ConnectionState.Open)
{
objConn.Close();
objConn.Dispose();
objConn = null;
}
strSQL = null;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
string kullanici = textEdit1.Text;
string sifre = textEdit1.Text;
if (kullanici.Trim() != "" && sifre.Trim() != "")
{
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}
komut.Connection = baglanti;
komut.CommandText = "SELECT * FROM kullanicilar";
OleDbDataReader okuyucu = komut.ExecuteReader();
while (okuyucu.Read())
{
if (okuyucu["kullanici"].ToString() == kullanici.Trim() && okuyucu["sifre"].ToString() == sifre.Trim())
{
string nYasakli = okuyucu["yasakli"].ToString();
if (nYasakli == "SÜRESİZ")
{
MessageBox.Show("Yönetici tarafından süresiz olarak sistemden uzaklaştırıldınız.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
else
{
if (nYasakli != "")
{
int yasakli = DateTime.Compare(DateTime.Parse(nYasakli), DateTime.Now);
if (yasakli == 1)
{
MessageBox.Show("Yönetici tarafından " + nYasakli + " tarihine kadar sistemden uzaklaştırıldınız.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
else
{
gAs = Convert.ToBoolean(okuyucu["asyonetici"]);
OleDbCommand komut2 = new OleDbCommand("SELECT * FROM ayarlar WHERE id=1", baglanti);
OleDbDataReader okuyucu2 = komut2.ExecuteReader();
bool sistem = true;
while (okuyucu2.Read())
{
sistem = Boolean.Parse(okuyucu2["sistem"].ToString());
}
if (sistem == false)
{
if (gAs == false)
{
MessageBox.Show("Sistem yönetici tarafından kapatılmıştır.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
gID = Convert.ToInt32(okuyucu["id"]);
gKullanici = kullanici.Trim();
gSifre = sifre.Trim();
gTarih = Convert.ToDateTime(okuyucu["tarih"].ToString());
gYonetici = Convert.ToBoolean(okuyucu["yonetici"].ToString());
MessageBox.Show("Sistem yönetici tarafından kapatılmış, ancak siz yönetici olduğunuz için giriş yapabilirsiniz.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
Form2 form2 = new Form2(gKullanici.Trim(), gSifre.Trim(), gYonetici, gTarih, gID, gAs);
form2.ShowDialog();
}
}
else
{
gID = Convert.ToInt32(okuyucu["id"]);
gKullanici = kullanici.Trim();
gSifre = sifre.Trim();
gTarih = Convert.ToDateTime(okuyucu["tarih"].ToString());
gYonetici = Convert.ToBoolean(okuyucu["yonetici"].ToString());
MessageBox.Show("Giriş işlemi başarıyla tamamlanmıştır.");
Form2 form2 = new Form2(gKullanici.Trim(), gSifre.Trim(), gYonetici, gTarih, gID, gAs);
form2.ShowDialog();
}
}
}
else
{
gAs = Convert.ToBoolean(okuyucu["asyonetici"]);
OleDbCommand komut2 = new OleDbCommand("SELECT * FROM ayarlar WHERE id=1", baglanti);
OleDbDataReader okuyucu2 = komut2.ExecuteReader();
bool sistem = true;
while (okuyucu2.Read())
{
sistem = Boolean.Parse(okuyucu2["sistem"].ToString());
}
if (sistem == false)
{
if (gAs == false)
{
MessageBox.Show("Sistem yönetici tarafından kapatılmıştır.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
gID = Convert.ToInt32(okuyucu["id"]);
gKullanici = kullanici.Trim();
gSifre = sifre.Trim();
gTarih = Convert.ToDateTime(okuyucu["tarih"].ToString());
gYonetici = Convert.ToBoolean(okuyucu["yonetici"].ToString());
MessageBox.Show("Sistem yönetici tarafından kapatılmış, ancak siz yönetici olduğunuz için giriş yapabilirsiniz.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
Form2 form2 = new Form2(gKullanici.Trim(), gSifre.Trim(), gYonetici, gTarih, gID, gAs);
form2.ShowDialog();
}
}
else
{
gID = Convert.ToInt32(okuyucu["id"]);
gKullanici = kullanici.Trim();
gSifre = sifre.Trim();
gTarih = Convert.ToDateTime(okuyucu["tarih"].ToString());
gYonetici = Convert.ToBoolean(okuyucu["yonetici"].ToString());
MessageBox.Show("Giriş işlemi başarıyla tamamlanmıştır.");
Form2 form2 = new Form2(gKullanici.Trim(), gSifre.Trim(), gYonetici, gTarih, gID, gAs);
form2.ShowDialog();
}
}
}
}
}
baglanti.Close();
}
}
private void btnAggiungi_Click(object sender, EventArgs e)
{
string s = "";
int j = 0;
if (rdbImgNo.Checked)
{
path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\img/NoImage.jpg";
filePicked = true;
}
if (filePicked)
{
bool usato;
bool kmZero;
if (rdbUsatoSì.Checked)
{
usato = true;
}
else
{
usato = false;
}
if (rdbKmZeroSì.Checked)
{
kmZero = true;
}
else
{
kmZero = false;
}
if (txtMarca.Text == "")
{
s = "marca";
}
if (txtModello.Text == "")
{
s += "\nmodello";
}
if (txtPotenzakW.Text == "")
{
s += "\npotenzakW";
}
try
{
int cilind = Convert.ToInt32(nudCilindrata.Value);
}
catch (Exception)
{
s = "\ncilindrata";
}
try
{
int kmp = Convert.ToInt32(nudKmPercorsi.Value);
}
catch (Exception)
{
s += "\nnumero Km percorsi";
}
if (cmbTipoVeicolo.SelectedIndex == 0)
{
//AUTO
try
{
int nAirbag = Convert.ToInt32(nudNumeroAirbag.Value);
}
catch (Exception)
{
s += "\nnumero di airbag";
}
}
else
{
//MOTO
if (txtSella.Text == "")
{
s += "\nsella";
}
}
if (s != "")
{
MessageBox.Show("Inserire i dati correttamente." +
"\nI dati da correggere sono:\n" + s);
}
else if (cmbTipoVeicolo.SelectedIndex == 0) //AUTO
{
OleDbConnection con = new OleDbConnection(connStr);
con.Open();
OleDbCommand command2 = new OleDbCommand();
command2.Connection = con;
command2.CommandText = "SELECT CodVeicolo FROM Veicoli";
OleDbDataReader r2 = command2.ExecuteReader();
if (r2.HasRows)
{
while (r2.Read())
{
j = r2.GetInt32(0);
}
j++;
}
if (rdbImgSì.Checked)
{
path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\img/" + j + ".jpg";
File.Copy(f, Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\img/" + j + ".jpg");
}
bindingListVeicoli.Add(new Auto(j, txtMarca.Text, txtModello.Text, cmbColore.Text, Convert.ToInt32(nudCilindrata.Value), Convert.ToDouble(txtPotenzakW.Text), Convert.ToDateTime(dtpImmatricolazione.Value.ToShortDateString()), usato, kmZero, Convert.ToInt32(nudKmPercorsi.Value), Convert.ToInt32(nudNumeroAirbag.Value), path));
using (con)
{
OleDbCommand command = new OleDbCommand();
command.Connection = con;
command.CommandText = "INSERT INTO Veicoli (CodVeicolo, Tipologia, Marca, Modello, Colore, Cilindrata, PotenzaKw, Immatricolazione, IsUsato, IsKmZero, KmPercorsi, Informazioni, Immagine) VALUES" +
"(@codveicolo, @tipologia, @marca, @modello, @colore, @cilindrata, @potenzakw, @immatricolazione, @isusato, @iskmzero, @kmpercorsi, @informazioni, @immagine)";
command.Parameters.Add("@codveicolo", OleDbType.Integer).Value = j;
command.Parameters.Add(new OleDbParameter("@tipologia", OleDbType.VarChar, 255)).Value = cmbTipoVeicolo.Text;
command.Parameters.Add("@marca", OleDbType.VarChar, 255).Value = txtMarca.Text;
command.Parameters.Add("@modello", OleDbType.VarChar, 255).Value = txtModello.Text;
command.Parameters.Add("@colore", OleDbType.VarChar, 255).Value = cmbColore.Text;
command.Parameters.Add("@cilindrata", OleDbType.Integer).Value = Convert.ToInt32(nudCilindrata.Value);
command.Parameters.Add("@potenzakw", OleDbType.Integer).Value = Convert.ToInt32(txtPotenzakW.Text);
command.Parameters.Add("@immatricolazione", OleDbType.Date).Value = Convert.ToDateTime(dtpImmatricolazione.Value.ToShortDateString());
command.Parameters.Add("@isusato", OleDbType.Boolean).Value = usato;
command.Parameters.Add("@iskmzero", OleDbType.Boolean).Value = kmZero;
command.Parameters.Add("@kmpercorsi", OleDbType.Integer).Value = Convert.ToInt32(nudKmPercorsi.Value);
command.Parameters.Add("@informazioni", OleDbType.VarChar, 255).Value = nudNumeroAirbag.Value.ToString();
command.Parameters.Add("@immagine", OleDbType.VarChar, 255).Value = path;
command.Prepare();
command.ExecuteNonQuery();
con.Close();
}
clsMetodi.caricaDgv(bindingListVeicoli, ((DataGridView)formMain.Controls["dgvVeicoli"]));
clsMetodi.checkMarca(txtMarca.Text);
clsMetodi.checkColore(cmbColore.Text);
formMain.salva();
con.Close();
this.Close();
}
else //MOTO
{
OleDbConnection con = new OleDbConnection(connStr);
con.Open();
OleDbCommand command2 = new OleDbCommand();
command2.Connection = con;
command2.CommandText = "SELECT CodVeicolo FROM Veicoli";
OleDbDataReader r2 = command2.ExecuteReader();
if (r2.HasRows)
{
while (r2.Read())
{
j = r2.GetInt32(0);
}
j++;
}
if (rdbImgSì.Checked)
{
path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\img/" + j + ".jpg";
File.Copy(f, Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\img/" + j + ".jpg");
}
bindingListVeicoli.Add(new Moto(j, txtMarca.Text, txtModello.Text, cmbColore.Text, Convert.ToInt32(nudCilindrata.Value), Convert.ToDouble(txtPotenzakW.Text), Convert.ToDateTime(dtpImmatricolazione.Value.ToShortDateString()), usato, kmZero, Convert.ToInt32(nudKmPercorsi.Value), txtSella.Text, path));
using (con)
{
OleDbCommand command = new OleDbCommand();
command.Connection = con;
command.CommandText = "INSERT INTO Veicoli (CodVeicolo, Tipologia, Marca, Modello, Colore, Cilindrata, PotenzaKw, Immatricolazione, IsUsato, IsKmZero, KmPercorsi, Informazioni, Immagine) VALUES" +
"(@codveicolo, @tipologia, @marca, @modello, @colore, @cilindrata, @potenzakw, @immatricolazione, @isusato, @iskmzero, @kmpercorsi, @informazioni, @immagine)";
command.Parameters.Add("@codveicolo", OleDbType.Integer).Value = j;
command.Parameters.Add(new OleDbParameter("@tipologia", OleDbType.VarChar, 255)).Value = cmbTipoVeicolo.Text;
command.Parameters.Add("@marca", OleDbType.VarChar, 255).Value = txtMarca.Text;
command.Parameters.Add("@modello", OleDbType.VarChar, 255).Value = txtModello.Text;
command.Parameters.Add("@colore", OleDbType.VarChar, 255).Value = cmbColore.Text;
command.Parameters.Add("@cilindrata", OleDbType.Integer).Value = Convert.ToInt32(nudCilindrata.Value);
command.Parameters.Add("@potenzakw", OleDbType.Integer).Value = Convert.ToInt32(txtPotenzakW.Text);
command.Parameters.Add("@immatricolazione", OleDbType.Date).Value = Convert.ToDateTime(dtpImmatricolazione.Value.ToShortDateString());
command.Parameters.Add("@isusato", OleDbType.Boolean).Value = usato;
command.Parameters.Add("@iskmzero", OleDbType.Boolean).Value = kmZero;
command.Parameters.Add("@kmpercorsi", OleDbType.Integer).Value = Convert.ToInt32(nudKmPercorsi.Value);
command.Parameters.Add("@informazioni", OleDbType.VarChar, 255).Value = nudNumeroAirbag.Value.ToString();
command.Parameters.Add("@immagine", OleDbType.VarChar, 255).Value = path;
command.Prepare();
command.ExecuteNonQuery();
con.Close();
}
clsMetodi.caricaDgv(bindingListVeicoli, ((DataGridView)formMain.Controls["dgvVeicoli"]));
clsMetodi.checkMarca(txtMarca.Text);
clsMetodi.checkColore(cmbColore.Text);
formMain.salva();
con.Close();
this.Close();
}
}
else
{
MessageBox.Show("Non è stata selezionata l'immagine da associare al veicolo");
}
}
private void btnSubmit_Click(object sender, System.EventArgs e)
{
OleDbConnection connection = null;
try
{
string zjlbhStr = this.textBox_name.Text.ToString().Trim();
if (string.IsNullOrEmpty(zjlbhStr))
{
MessageBox.Show("转接工装代号为空!", "提示", MessageBoxButtons.OK);
return;
}
string converterTypeStr = this.textBox_ConverterType.Text.ToString().Trim();
if (string.IsNullOrEmpty(converterTypeStr))
{
MessageBox.Show("转接型号为空!", "提示", MessageBoxButtons.OK);
return;
}
string remarkStr = this.textBox_Remark.Text.ToString();
bool bExsitFlag = false;
try
{
connection = new OleDbConnection();
connection.ConnectionString = this.gLineTestProcessor.dbPathStr;
connection.Open();
string sqlcommand = "select top 1 * from TConverterLibrary where ConverterName = '" + zjlbhStr + "'";
OleDbCommand cmd = new OleDbCommand(sqlcommand, connection);
OleDbDataReader dataReader = cmd.ExecuteReader();
if (dataReader.Read())
{
bExsitFlag = true;
}
dataReader.Close();
if (!bExsitFlag)
{
string str = "','";
sqlcommand = "insert into TConverterLibrary(ConverterName,ConverterType,Remark) values('" + zjlbhStr + str + converterTypeStr + str + remarkStr + "')";
cmd = new OleDbCommand(sqlcommand, connection);
cmd.ExecuteNonQuery();
}
connection.Close();
connection = null;
}
catch (System.Exception arg_137_0)
{
KLineTestProcessor.ExceptionRecordFunc(arg_137_0.StackTrace);
if (connection != null)
{
connection.Close();
connection = null;
}
MessageBox.Show("数据库访问异常!", "提示", MessageBoxButtons.OK);
base.Close();
goto IL_17E;
}
if (!bExsitFlag)
{
goto IL_1A3;
}
MessageBox.Show("转接工装已存在!", "提示", MessageBoxButtons.OK);
IL_17E:
return;
}
catch (System.Exception arg_180_0)
{
KLineTestProcessor.ExceptionRecordFunc(arg_180_0.StackTrace);
MessageBox.Show("存在未知异常!", "提示", MessageBoxButtons.OK);
base.Close();
return;
}
IL_1A3:
MessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK);
this.bAddSuccFlag = true;
base.Close();
}
public void CbKontrol()
{
try
{
baglanti.Open();
komut = new OleDbCommand("SELECT * FROM OgrTkp where OgrTc_No=@OgrTc_No", baglanti);
// komut.Parameters.AddWithValue("@OgrTc_No", labelGızlıTc.Text);
komut.Connection = baglanti;
komut.Parameters.AddWithValue("@OgrTc_No", labelGızlıTc.Text);
OleDbDataReader dr = komut.ExecuteReader();
if (dr.Read())
{
tıkgel1 = dr["OgrSure_1"].ToString();
tıkgel2 = dr["OgrSure_2"].ToString();
tıkgel3 = dr["OgrSure_3"].ToString();
tıkgel4 = dr["OgrSure_4"].ToString();
tıkgel5 = dr["OgrSure_5"].ToString();
tıkgel6 = dr["OgrSure_6"].ToString();
tıkgel7 = dr["OgrSure_7"].ToString();
tıkgel8 = dr["OgrSure_8"].ToString();
tıkgel9 = dr["OgrSure_9"].ToString();
tıkgel10 = dr["OgrSure_10"].ToString();
tıkgel11 = dr["OgrSure_11"].ToString();
tıkgel12 = dr["OgrSure_12"].ToString();
tıkgel13 = dr["OgrSure_13"].ToString();
tıkgel14 = dr["OgrSure_14"].ToString();
tıkgel15 = dr["OgrSure_15"].ToString();
tıkgel16 = dr["OgrSure_16"].ToString();
tıkgel17 = dr["OgrSure_17"].ToString();
tıkgel18 = dr["OgrSure_18"].ToString();
tıkgel19 = dr["OgrSure_19"].ToString();
tıkgel20 = dr["OgrSure_20"].ToString();
tıkgel21 = dr["OgrSure_21"].ToString();
tıkgel22 = dr["OgrSure_22"].ToString();
tıkgel23 = dr["OgrSure_23"].ToString();
tıkgel24 = dr["OgrSure_24"].ToString();
tıkgel25 = dr["OgrSure_25"].ToString();
tıkgel26 = dr["OgrSure_26"].ToString();
tıkgel27 = dr["OgrSure_27"].ToString();
tıkgel28 = dr["OgrSure_28"].ToString();
tıkgel29 = dr["OgrSure_29"].ToString();
tıkgel30 = dr["OgrSure_30"].ToString();
tıkgel31 = dr["OgrSure_31"].ToString();
tıkgel32 = dr["OgrSure_32"].ToString();
tıkgel33 = dr["OgrSure_33"].ToString();
tıkgelVez1 = dr["OgrVecz_1"].ToString();
tıkgelVez2 = dr["OgrVecz_2"].ToString();
tıkgelVez3 = dr["OgrVecz_3"].ToString();
tıkgelVez4 = dr["OgrVecz_4"].ToString();
tıkgelVez5 = dr["OgrVecz_5"].ToString();
tıkgelVez6 = dr["OgrVecz_6"].ToString();
tıkgelVez7 = dr["OgrVecz_7"].ToString();
tıkgelVez8 = dr["OgrVecz_8"].ToString();
tıkgelVez9 = dr["OgrVecz_9"].ToString();
tıkgelVez10 = dr["OgrVecz_10"].ToString();
tıkgelVez11 = dr["OgrVecz_11"].ToString();
tıkgelVez12 = dr["OgrVecz_12"].ToString();
tıkgelVez13 = dr["OgrVecz_13"].ToString();
tıkgelVez14 = dr["OgrVecz_14"].ToString();
tıkgelVez15 = dr["OgrVecz_15"].ToString();
tıkgelVez16 = dr["OgrVecz_16"].ToString();
tıkgelVez17 = dr["OgrVecz_17"].ToString();
tıkgelVez18 = dr["OgrVecz_18"].ToString();
tıkgelVez19 = dr["OgrVecz_19"].ToString();
tıkgelVez20 = dr["OgrVecz_20"].ToString();
tıkgelVez21 = dr["OgrVecz_21"].ToString();
tıkgelVez22 = dr["OgrVecz_22"].ToString();
tıkgelVez23 = dr["OgrVecz_23"].ToString();
tıkgelVez24 = dr["OgrVecz_24"].ToString();
tıkgelVez25 = dr["OgrVecz_25"].ToString();
tıkgelVez26 = dr["OgrVecz_26"].ToString();
tıkgelVez27 = dr["OgrVecz_27"].ToString();
tıkgelVez28 = dr["OgrVecz_28"].ToString();
tıkgelVez29 = dr["OgrVecz_29"].ToString();
tıkgelVez30 = dr["OgrVecz_30"].ToString();
labelK1.Text = dr["OgrKtp_1"].ToString();
labelK2.Text = dr["OgrKtp_2"].ToString();
labelK3.Text = dr["OgrKtp_3"].ToString();
labelK4.Text = dr["OgrKtp_4"].ToString();
labelK5.Text = dr["OgrKtp_5"].ToString();
labelK6.Text = dr["OgrKtp_6"].ToString();
labelK7.Text = dr["OgrKtp_7"].ToString();
labelK8.Text = dr["OgrKtp_8"].ToString();
labelK9.Text = dr["OgrKtp_9"].ToString();
labelK10.Text = dr["OgrKtp_10"].ToString();
labelK11.Text = dr["OgrKtp_11"].ToString();
labelK12.Text = dr["OgrKtp_12"].ToString();
labelK13.Text = dr["OgrKtp_13"].ToString();
labelK14.Text = dr["OgrKtp_14"].ToString();
labelK15.Text = dr["OgrKtp_15"].ToString();
labelK16.Text = dr["OgrKtp_16"].ToString();
labelK17.Text = dr["OgrKtp_17"].ToString();
labelK18.Text = dr["OgrKtp_18"].ToString();
labelK19.Text = dr["OgrKtp_19"].ToString();
labelK20.Text = dr["OgrKtp_20"].ToString();
}
baglanti.Close();
}
catch (Exception HATA)
{
string hata = HATA.ToString();
MessageBox.Show(" cbKontrol(); için Veritabanı hatası oluştu ! " + HATA.Message, hata.Substring(0, hata.IndexOf(':')));
}
} //CbKontrol() END
private void Vendor_Load(object sender, EventArgs e)
{
mc = new MyConnection();
if (selection == "add")
{
this.Text = "Add Vender";
comboBox1.Visible = false;
textBox13.Visible = false;
comboBox2.Visible = true;
textBox12.Visible = true;
mc.conn.Open();
cmd = new OleDbCommand("select GrpName from CusGroup;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox2.Items.Add(dr["GrpName"]);
}
mc.conn.Close();
}
else if (selection == "approve")
{
this.Text = "Approve Vendor";
button2.Enabled = false;
button3.Enabled = false;
button2.Text = "Approve";
textBox1.ReadOnly = true;
textBox2.ReadOnly = true;
textBox3.ReadOnly = true;
textBox4.ReadOnly = true;
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
textBox7.ReadOnly = true;
textBox8.ReadOnly = true;
textBox9.ReadOnly = true;
textBox10.ReadOnly = true;
textBox13.ReadOnly = true;
mc.conn.Open();
cmd = new OleDbCommand("select VID from Vendor where VStatus='Inactive';", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["VID"]);
}
mc.conn.Close();
}
else if (selection == "search")
{
this.Text = "Search Vendor";
button1.Visible = false;
button2.Visible = false;
button3.Enabled = false;
comboBox2.Visible = false;
textBox12.Visible = false;
textBox1.ReadOnly = true;
textBox2.ReadOnly = true;
textBox3.ReadOnly = true;
textBox4.ReadOnly = true;
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
textBox7.ReadOnly = true;
textBox8.ReadOnly = true;
textBox9.ReadOnly = true;
textBox10.ReadOnly = true;
textBox11.ReadOnly = true;
textBox13.ReadOnly = true;
mc.conn.Open();
cmd = new OleDbCommand("select VID from Vendor;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["VID"]);
}
mc.conn.Close();
}
else if (selection == "update")
{
this.Text = "Update Vendor";
button2.Text = "Update";
button3.Enabled = false;
button2.Enabled = false;
comboBox2.Visible = false;
textBox12.Visible = false;
textBox13.ReadOnly = true;
mc.conn.Open();
cmd = new OleDbCommand("select VID from Vendor;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["VID"]);
}
mc.conn.Close();
}
}
private void buttonLogin_Click(object sender, RoutedEventArgs e)
{
// Хэш зарегистрированного пользователя должен браться из хранилища
// данных программы
if (textBoxLogin.Text == "" || passwordBox.Password == "")
{
MessageBox.Show("Не задан логин или пароль!", "LOGIN", MessageBoxButton.OK, MessageBoxImage.Exclamation);
textBoxLogin.Focus();
return;
}
var hPwd = "";
string bActive = "", bAdmin = "";
//bool bActive, bAdmin;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\CRM_Database.mdb";
OleDbConnection CRM_DB_Conn = new OleDbConnection(connectionString);
try
{
CRM_DB_Conn.Open();
//MessageBox.Show("Успешно подключено к базе данных:\n" + connectionString);
string queryString = "";
queryString = "SELECT Employee_Users.Login, Employee_Users.Hash_Pwd, Employee_Users.Active, Employee_Users.Admin FROM Employee_Users WHERE Employee_Users.Login = '******'";
//queryString = "UPDATE Employee_Users SET Hash_Pwd = '" + CalculateHash(passwordBox.Password) + "' WHERE Login = '******'";
OleDbCommand Cmd = new OleDbCommand(queryString, CRM_DB_Conn);
//Cmd.CommandText = "SELECT Employees.FIO, Employees.Position, Employee_Users.Login, Employee_Users.Hash_Pwd, Employee_Users.Active, Employee_Users.Admin " +
// "FROM Employees RIGHT JOIN Employee_Users ON Employees.Empl_ID = Employee_Users.Empl_ID WHERE Employee_Users.Login = '******'";
//MessageBox.Show(Cmd.CommandText);
OleDbDataReader Dr = Cmd.ExecuteReader();
//MessageBox.Show("Получено Fields = " + Dr.FieldCount + "; Rows = " + Dr.HasRows); // + "; Item[0] = " + Dr.GetValue(0));
if (Dr.Read())
{
hPwd = Dr["Hash_Pwd"].ToString();
bActive = Dr["Active"].ToString();
//bActive = Dr.GetBoolean();
bAdmin = Dr["Admin"].ToString();
//MessageBox.Show("PassWd = " + hPwd + "; Active =" + bActive + "; Admin = " + bAdmin);
}
else
{
MessageBox.Show("Нет пользователя: " + textBoxLogin.Text, "Авторизация");
}
Dr.Close();
}
catch (Exception ex)
{
MessageBox.Show("Нет подключения к базе данных:\n" + connectionString + "\n\n" + ex.ToString(), "Application Error");
}
finally
{
CRM_DB_Conn.Close();
}
//if (CalculateHash(passwordBox.Password) == hPwd)
if (passwordBox.Password == hPwd && hPwd != "")
{
//MessageBox.Show("Login/password - CORRECT!!!", "Авторизация");
if (bActive == "True")
{
// MessageBox.Show("Поздравляю! Вы активный пользователь.", "Проверка на активность");
if (bAdmin == "True")
{
// MessageBox.Show("Вы - Администратор.", "Проверка прав и полномочий");
NavigationService.Navigate(KDZ_CRM_Pages.Administrator_Menu);
KDZ_CRM_Pages.Administrator_Menu.Go_Out.Focus();
}
else
{
//MessageBox.Show("Вы - обычный Пользователь.", "Проверка прав и полномочий");
NavigationService.Navigate(KDZ_CRM_Pages.User_Menu);
KDZ_CRM_Pages.User_Menu.Go_Out.Focus();
UserName = textBoxLogin.Text;
MainWindow.MyUser.Login = UserName;
MainWindow.MyUser.User_CompanyList = new List <Company_Protected>();
int iComp = Company_From_DB(CRM_DB_Conn, UserName);
if (iComp > 0)
{
MessageBox.Show("Получено " + iComp + " компаний!!!");
}
else
{
MessageBox.Show("Не создан список компаний!!!");
}
}
}
else
{
MessageBox.Show("Сожалею! Вы НЕ активный пользователь.", "Проверка на активность");
}
}
else
{
MessageBox.Show("Incorrect login/password", "Авторизация");
textBoxLogin.Focus();
}
}
private void Personeller_Load(object sender, EventArgs e)
{
OleDbConnection baglanti;
OleDbDataAdapter adaptor;
OleDbCommand komut;
DataSet verikumesi;
OleDbDataReader asd;
baglanti = new OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0; Data Source=restaurant_veritabani.mdb");
adaptor = new OleDbDataAdapter("Select * from yetkiseviyesi", baglanti);
verikumesi = new DataSet();
komut = new OleDbCommand();
baglanti.Open();
komut.Connection = baglanti;
komut.CommandText = "SELECT * FROM yetkiseviyesi";
asd = komut.ExecuteReader();
while (asd.Read())
{
seviye.Items.Add(asd["yetkiseviyesi"]);
}
baglanti.Close();
listView1.GridLines = true;
label1.Visible = false;
label2.Visible = false;
label3.Visible = false;
label4.Visible = false;
label5.Visible = false;
guncelle.Visible = false;
ekle.Visible = false;
sil.Visible = false;
ad.Visible = false;
soyad.Visible = false;
sifre.Visible = false;
k_adi.Visible = false;
seviye.Visible = false;
listView1.Visible = false;
listView1.FullRowSelect = true;
listView1.View = View.Details;
listView1.GridLines = true;
OleDbConnection con;
OleDbDataReader dr;
OleDbCommand cmd;
listView1.Items.Clear();
con = new OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0; Data Source=restaurant_veritabani.mdb");
con.Open();
cmd = new OleDbCommand("Select * From personel_genel_bilgi", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ListViewItem item = new ListViewItem(dr["Id"].ToString());
item.SubItems.Add(dr["Adi"].ToString());
item.SubItems.Add(dr["Soyadi"].ToString());
item.SubItems.Add(dr["KullaniciAdi"].ToString());
item.SubItems.Add(dr["Sifre"].ToString());
item.SubItems.Add(dr["YetkiSeviyesi"].ToString());
listView1.Items.Add(item);
}
listView1.Columns[0].Width = 0;
listView1.Columns[4].Width = 0;
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string connString = "";
FileUpload1.SaveAs(Server.MapPath("~/Upload/" + FileUpload1.FileName));//for uploading files
string strFileType = Path.GetExtension(FileUpload1.FileName).ToLower();//getting path
string path1 = FileUpload1.PostedFile.FileName;
string path = System.IO.Path.GetFullPath(Server.MapPath("~/Upload/" + FileUpload1.FileName));//for storing files in .net folder
if (strFileType.Trim() == ".xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/Upload/" + FileUpload1.FileName) + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";//for xls
}
else if (strFileType.Trim() == ".xlsx")
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/Upload/" + FileUpload1.FileName) + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";//for xlsx
}
string query = "select * FROM [IF3G$]";//for fetching data from excel sheet(sheet1)
OleDbConnection conn = new OleDbConnection(connString);
ArrayList list1 = new ArrayList();
list1.Clear();
ArrayList list2 = new ArrayList();
list2.Clear();
ArrayList list3 = new ArrayList();
list3.Clear();
ArrayList list4 = new ArrayList();
list4.Clear();
ArrayList list5 = new ArrayList();
list5.Clear();
ArrayList list6 = new ArrayList();
list6.Clear();
ArrayList list7 = new ArrayList();
list7.Clear();
ArrayList list8 = new ArrayList();
list8.Clear();
ArrayList list9 = new ArrayList();
list9.Clear();
ArrayList list10 = new ArrayList();
list10.Clear();
ArrayList list11 = new ArrayList();
list11.Clear();
ArrayList list12 = new ArrayList();
list12.Clear();
ArrayList list13 = new ArrayList();
list13.Clear();
ArrayList list14 = new ArrayList();
list14.Clear();
ArrayList list15 = new ArrayList();
list15.Clear();
ArrayList list16 = new ArrayList();
list16.Clear();
ArrayList list17 = new ArrayList();
list17.Clear();
ArrayList list18 = new ArrayList();
list18.Clear();
ArrayList list19 = new ArrayList();
list19.Clear();
ArrayList list20 = new ArrayList();
list20.Clear();
ArrayList list21 = new ArrayList();
list21.Clear();
ArrayList list22 = new ArrayList();
list22.Clear();
conn.Open();
OleDbCommand cmd = new OleDbCommand();
OleDbDataReader rs1;
cmd.Connection = conn;
cmd.CommandText = "select * from [IF3G$]";
rs1 = cmd.ExecuteReader();
while (rs1.Read())
{
if (rs1.GetValue(0).ToString() != "")
{
list1.Add(rs1.GetValue(0).ToString());
list2.Add(rs1.GetValue(1).ToString());
list3.Add(rs1.GetValue(2).ToString());
list4.Add(rs1.GetValue(3).ToString());
list5.Add(rs1.GetValue(4).ToString());
list6.Add(rs1.GetValue(5).ToString());
list7.Add(rs1.GetValue(6).ToString());
list8.Add(rs1.GetValue(7).ToString());
list9.Add(rs1.GetValue(8).ToString());
list10.Add(rs1.GetValue(9).ToString());
list11.Add(rs1.GetValue(10).ToString());
list12.Add(rs1.GetValue(11).ToString());
list13.Add(rs1.GetValue(12).ToString());
list14.Add(rs1.GetValue(13).ToString());
list15.Add(rs1.GetValue(14).ToString());
list16.Add(rs1.GetValue(15).ToString());
list17.Add(rs1.GetValue(16).ToString());
list18.Add(rs1.GetValue(17).ToString());
list19.Add(rs1.GetValue(18).ToString());
list20.Add(rs1.GetValue(19).ToString());
list21.Add(rs1.GetValue(20).ToString());
list22.Add(rs1.GetValue(21).ToString());
}
}
rs1.Close();
cmd.Dispose();
conn.Close();
conn.Dispose();
int i = 0;
for (i = 0; i < list1.Count; i++)//for entering into the excel sheet
{
int count1 = 0;
cn.Open();// connection for inserting data in database
cmd1.Connection = cn;
cmd1.CommandText = "select count(*) from Semester3 where Enroll_No='" + list1[i].ToString() + "'";
rs = cmd1.ExecuteReader();
while (rs.Read())
{
count1 = int.Parse(rs.GetValue(0).ToString());
} rs.Close();
cmd1.Dispose();
cn.Close();
string qry = "";
if (count1 == 0)
{
Auto_Gen();//for inserting values into database
qry = "insert into Semester3 (ID,Enroll_No,Surname,Firstname,Middlename,Seatnumber,Ams_TH ,Dsu_TH ,Dsu_PR,Dsu_TW ,Ete_TH,Ete_TW,Rdm_TH ,Rdm_OR,Rdm_TW ,Dte_TH ,Dte_TW,Gui_PR,Ppo_TW,Sw ,Total,Percentage,Remarks)values('" + auto + "','" + list1[i].ToString() + "','" + list2[i].ToString() + "','" + list3[i].ToString() + "','" + list4[i].ToString() + "','" + list5[i].ToString() + "','" + list6[i].ToString() + "','" + list7[i].ToString() + "','" + list8[i].ToString() + "','" + list9[i].ToString() + "','" + list10[i].ToString() + "','" + list11[i].ToString() + "','" + list12[i].ToString() + "','" + list13[i].ToString() + "','" + list14[i].ToString() + "','" + list15[i].ToString() + "','" + list16[i].ToString() + "','" + list17[i].ToString() + "','" + list18[i].ToString() + "','" + list19[i].ToString() + "','" + list20[i].ToString() + "','" + list21[i].ToString() + "','" + list22[i].ToString() + "')";
}
else
{//for updating database
qry = "update Semester3 set Surname='" + list2[i].ToString() + "',Firstname='" + list3[i].ToString() + "',Middlename='" + list4[i].ToString() + "',Seatnumber='" + list5[i].ToString() + "',Ams_TH='" + list6[i].ToString() + "',Dsu_TH='" + list7[i].ToString() + "',Dsu_PR ='" + list8[i].ToString() + "',Dsu_TW ='" + list9[i].ToString() + "',Ete_TH='" + list10[i].ToString() + "',Ete_TW='" + list11[i].ToString() + "',Rdm_TH='" + list12[i].ToString() + "',Rdm_OR='" + list13[i].ToString() + "',Rdm_TW='" + list14[i].ToString() + "',Dte_TH ='" + list15[i].ToString() + "',Dte_TW='" + list16[i].ToString() + "',Gui_PR='" + list17[i].ToString() + "',Ppo_TW='" + list18[i].ToString() + "',Sw ='" + list19[i].ToString() + "',Total='" + list20[i].ToString() + "',Percentage='" + list21[i].ToString() + "',Remarks='" + list22[i].ToString() + "' where Enroll_No='" + list1[i].ToString() + "' ";
}
cn.Open();
cmd1.Connection = cn;
cmd1.CommandText = qry;
cmd1.ExecuteNonQuery();
cmd1.Dispose();
cn.Close();
Label1.Text = "Updated Successfully";
}
}
private void giris_Load(object sender, EventArgs e)
{
label13.Visible = false;
Mutex Mtx = new Mutex(false, "SINGLE_INSTANCE_APP_MUTEX");
if (Mtx.WaitOne(0, false) == false)
{
Mtx.Close();
Mtx = null;
MessageBox.Show("Program Zaten Açık");
//Application.Exit();
}
else
{
this.Opacity = 100;
}
cekbox1();
cekbox2();
cekbox3();
try
{
baglan.Close();
baglan.Open();
sorgu.Connection = baglan;
sorgu.CommandText = "select * from giriskismi";
dr = sorgu.ExecuteReader();
dr.Read();
text5 = dr[1].ToString();
cek2 = dr[6].ToString();
baglan.Close();
if (cek2 == "a")
{
checkBox4.Checked = true;
textBox5.Text = text5;
}
else
{
checkBox4.Checked = false;
textBox5.Text = "";
}
timer1.Start();
baglan.Close();
baglan.Open();
sorgu.Connection = baglan;
sorgu.CommandText = "select * from giriskismi";
dr = sorgu.ExecuteReader();
dr.Read();
sifreGirildimi = dr[0].ToString();
kul = dr[1].ToString();
sif = dr[2].ToString();
baglan.Close();
if (sifreGirildimi != "a")
{
button4.Visible = false;
}
}
catch
{
if (sifreGirildimi != "a")
{
try
{
button7.Visible = false;
button3.Visible = false;
girildi = "b";
baglan.Close();
baglan.Open();
sorgu.Connection = baglan;
sorgu.CommandText = "update giriskismi set sifre_girildi='" + girildi + "'";
sorgu.ExecuteNonQuery();
baglan.Close();
}
catch
{
MessageBox.Show("Office Programlarının Yüklü Olması Gerekiyor");
Application.Exit();
}
}
}
if (sifreGirildimi == "a")
{
button7.Visible = true;
button3.Visible = true;
groupBox1.Visible = false;
groupBox2.Visible = true;
groupBox2.Location = new Point(25, 85);
}
}
private void ShowStudentsDetails(string studentID)
{
try
{
string queryString =
@"SELECT
[Name],[Image],[Sex],[FatherName],[MotherName],[Religion],[PresentAddress],[PermanentAddress],[StudentMobileNumber],
[GuardianMobileNumber],[Email],[SchoolName],[Roll],[Group],[Batch],[MonthlyFee],[AdmissionDate]
from TblStudent WHERE [ID] = @srcID";
OleDbConnection connection = new OleDbConnection(Strings.DBconStr);
OleDbCommand command = new OleDbCommand(queryString, connection);
command.Parameters.AddWithValue("@srcID", studentID);
//Console.WriteLine(command.CommandText.ToString());
connection.Open();
OleDbDataReader reader = command.ExecuteReader();
//this.lstViewStudents.Items.Clear();
while (reader.Read())
{
txtName.Text = reader[0].ToString();
if (reader[1].ToString() != "")
{
byte[] data = (byte[])reader[1];
MemoryStream strm = new MemoryStream();
strm.Write(data, 0, data.Length);
strm.Position = 0;
System.Drawing.Image img = System.Drawing.Image.FromStream(strm);
BitmapImage bi = new BitmapImage();
bi.BeginInit();
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
ms.Seek(0, SeekOrigin.Begin);
bi.StreamSource = ms;
bi.EndInit();
imgStdnt.Source = bi;
}
else
{
imgStdnt.Source = null;
}
cmbBxSex.SelectedIndex = Convert.ToInt32(reader[2]);
txtFatherName.Text = reader[3].ToString();
txtMotherName.Text = reader[4].ToString();
cmbBxReligion.SelectedIndex = Convert.ToInt32(reader[5]);
txtPresentAddr.Text = reader[6].ToString();
txtPermanentAddr.Text = reader[7].ToString();
txtStdMob.Text = reader[8].ToString();
txtGuardianMob.Text = reader[9].ToString();
txtEmail.Text = reader[10].ToString();
string instituteName = reader[11].ToString();
if (cmbBxInstituteName.Items.IndexOf(instituteName) == -1)
{
cmTools.AddInstituteName(instituteName);
cmTools.GetInstituteNames(cmbBxInstituteName.Items);
cmbBxInstituteName.SelectedIndex = cmbBxInstituteName.Items.IndexOf(instituteName);
}
else
{
cmbBxInstituteName.SelectedIndex = cmbBxInstituteName.Items.IndexOf(instituteName);
}
//txtInstitute.Text = reader[11].ToString();
txtRoll.Text = reader[12].ToString();
cmbBxGroup.SelectedIndex = Convert.ToInt32(reader[13]);
txtBatchNo.Text = reader[14].ToString();
txtFee.Text = reader[15].ToString();
txtAdmissionDate.Text = Convert.ToDateTime(reader[16]).ToShortDateString();
}
cmbBxClass.SelectedIndex = cmbBxSelClass.SelectedIndex;
reader.Close();
connection.Close();
// Release Memory
command.Dispose();
connection.Dispose();
//if (this.lstViewStudents.Items.Count != 0)
// lstViewStudents.SelectedIndex = 0;
GetAttendance(studentID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Connect_Read_Raw(string strConnection)
{
// Create and open the connection in a using block. This ensures that all resources
// will be closed and disposed when the code exits.
Console.WriteLine("(raw)");
using (OleDbConnection connection = new OleDbConnection(strConnection))
{
// Open the connection in a try/catch block
try
{
if (m_eDbReadTechnology == DatabaseReadTechnology.eRbRead_DataReader)
{
// Using System.Data.OleDb.OleDbDataReader : IDataReader
Console.WriteLine("(OleDb.OleDbDataReader)");
// Create and open the connection in a using block. This ensures that all resources
// will be closed and disposed when the code exits.
// Note:
// * "DbConnection" is the base class for OleDbConnection, OdbcConnection
// * "DbCommand" is the base class for OleDbCommand, OdbcCommand
// * "DbParameterCollection" is the base class for OleDbParameterCollection, OdbcParameterCollection
// * "DbDataReader" is the base class for OleDbDataReader, OdbcDataReader
// We could write a generic function to access the database with OleDB or ODBC, but it
// is simpler to write an unique method for each technology.
// Create and execute the DataReader, writing the result to the console window
int recordsRead = 0;
Console.WriteLine("\t{0}{1}{2}",
Northwind_Products.colProductID.PadRight(Northwind_Products.colProductIDWidth),
Northwind_Products.colUnitPrice.PadRight(Northwind_Products.colUnitPriceWidth),
Northwind_Products.colProductName);
connection.Open();
OleDbCommand command = new OleDbCommand(m_cfgDatabase.querySELECT, connection);
command.Parameters.AddWithValue("@pricePoint", m_cfgDatabase.paramValue);
// This also works: command.Parameters.AddWithValue(string.Empty, paramValue);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
recordsRead++;
Console.WriteLine("\t{0}{1}{2}",
((int)reader[Northwind_Products.colProductID]).ToString().PadRight(Northwind_Products.colProductIDWidth),
((decimal)reader[Northwind_Products.colUnitPrice]).ToString("0.00").PadRight(Northwind_Products.colUnitPriceWidth),
(string)reader[Northwind_Products.colProductName]);
}
reader.Close();
Console.WriteLine(" ({0} records)", recordsRead);
}
else if (m_eDbReadTechnology == DatabaseReadTechnology.eRbRead_DataAdapter)
{
// This version uses:
// * System.Data.DataSet
// * System.Data.OleDb.OleDbDataAdapter : IDbDataAdapter
// * System.Data.DataRow
Console.WriteLine("(DataSet, OleDb.OleDbDataAdapter and DataRow)");
// Create and fill the DataSet, writing the result to the console window
int recordsRead = 0;
Console.WriteLine("\t{0}{1}{2}",
Northwind_Products.colProductID.PadRight(Northwind_Products.colProductIDWidth),
Northwind_Products.colUnitPrice.PadRight(Northwind_Products.colUnitPriceWidth),
Northwind_Products.colProductName);
connection.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(m_cfgDatabase.querySELECT, connection);
adapter.SelectCommand.Parameters.Add("@pricePoint", OleDbType.Integer).Value = m_cfgDatabase.paramValue;
adapter.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
recordsRead++;
Console.WriteLine("\t{0}{1}{2}",
((int)row[Northwind_Products.colProductID]).ToString().PadRight(Northwind_Products.colProductIDWidth),
((decimal)row[Northwind_Products.colUnitPrice]).ToString("0.00").PadRight(Northwind_Products.colUnitPriceWidth),
(string)row[Northwind_Products.colProductName]);
}
Console.WriteLine(" ({0} records)", recordsRead);
}
}
catch (Exception ex)
{
Console.WriteLine(UtilitiesGeneral.FormatException(
this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
}
Console.WriteLine();
}
public FuncStatus DataBind(BindOperator _bp)
{
bool _tf = true;
int i;
OleDbConnection _conn = new OleDbConnection(Prument.Properties.Settings.Default.Properties["dataConnectionString"].DefaultValue.ToString());
OleDbCommand _cmd = new OleDbCommand();
OleDbDataReader _dr;
_cmd.Connection = _conn;
try
{
_conn.Open();
if (_bp == BindOperator.Update) {
_cmd.CommandText = "delete from Images where pID = " + this.pID;
_cmd.ExecuteNonQuery();
}
if (_bp == BindOperator.Insert || _bp == BindOperator.Update)
{
i = 0;
while (i < _max)
{
_cmd.CommandText = "insert into Images (Path,pID) values ('" + this.Path[i] + "'," + this.pID + ")";
_cmd.ExecuteNonQuery();
i++;
}
}
_cmd.CommandText = "select ID,Path,pID from Images where pID=" + this.pID;
_dr = _cmd.ExecuteReader();
i = 0;
while (_dr.Read())
{
this.ID[i] = _dr.GetInt32(0);
this.Path[i] = _dr.GetValue(1).ToString();
this.pID = _dr.GetInt32(2);
i++;
}
}
catch (Exception ex) {
_tf = false;
Exception _ex = new Exception("ORM.Images:" + ex.Message);
throw _ex;
}
finally
{
_conn.Close();
}
return _tf == false ? FuncStatus.Fail : FuncStatus.Success;
}
