private void frmLogin_Load(object sender, EventArgs e) { //todo-:Connection Settings choose //cmbSirket.Items.Clear(); string sql = "select * from efatura.baglantilar order by alias"; Conn.OpenConn(); MySqlDataAdapter daBaglantilar = Conn.OpenAdapter(sql); DataTable dtBaglantilar = new DataTable(); daBaglantilar.Fill(dtBaglantilar); foreach (DataRow row in dtBaglantilar.Rows) { cbConnection.Items.Add(new ComboboxItem(row["alias"].ToString(), new Baglanti(row["alias"].ToString(), row["hostip"].ToString(), row["hostport"].ToString(), row["hostdb"].ToString(), row["SaveXmlPath"].ToString(), row["INGEntVar"].ToString() == "True"?true:false, row["INGKullanici"].ToString(), row["INGSifre"].ToString(), row["INGVKN"].ToString(), row["INGAlias"].ToString() ) ) ); } if (dtBaglantilar.Rows.Count > 0) { BaglantiYukle(0); } dtBaglantilar = null; daBaglantilar = null; Conn.CloseConn(); if (cbConnection.Items.Count > 0) { cbConnection.SelectedIndex = 0; } lblVersion.Text = Application.ProductVersion.ToString(); Properties.Settings s = new Properties.Settings(); if (s.IbemSifre == "18") { txtUserName.Text = "iadmin"; txtPassword.Text = "183m8745"; } }
private void button1_Click(object sender, EventArgs e) { string kadi, sifre, db = ""; kadi = Conn.convert2Latin(txtUserName.Text); sifre = Conn.convert2Latin(txtPassword.Text); string checkSql = "select {0} as deger from yetkimuhasebe where durum='Aktif' and kullaniciadi='" + kadi + "' and pwd='" + Conn.CalculateMD5Hash(sifre) + "'"; string sql = string.Format(checkSql, "count(*)"); Conn.OpenConn(); int ok = Int32.Parse(Conn.ReadSingleField(sql, "0")); if (ok > 0) { string userId = Conn.ReadSingleField(string.Format(checkSql, "id"), "0"); sql = string.Format("select cast(accessright as char) from yetkimuhasebe_yetkiler where userid={0} and zone='acEFaturaIslemleri'", userId); int yetki = 0; try { yetki = Int32.Parse(Conn.ReadSingleField(sql, "0")); } catch (Exception exx) { yetki = 0; } if (yetki > 0) { frmMain f = new frmMain(); this.Hide(); Conn.CloseConn(); Properties.Settings s = new Properties.Settings(); s.MysqlDB = db; f.ShowDialog(); txtPassword.Clear(); this.Show(); txtPassword.Focus(); } } else { Conn.CloseConn(); } }
public static void OpenConn() { Properties.Settings mySettings = new Properties.Settings(); try { myConn = new MySqlConnection(); if (hostIP.Trim() == "") { hostIP = mySettings.MysqlHost; } if (hostDB.Trim() == "") { hostDB = mySettings.MysqlDB; } if (hostPort.Trim() == "") { hostPort = mySettings.MysqlPort; } if (SaveXmlPath.Trim() == "") { SaveXmlPath = mySettings.SaveXmlPath; } myConn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; port={3}; " + "database=mysql; pooling=false; Allow User Variables=True; " + "Allow Zero Datetime=True; Character Set=utf8; " + "Convert Zero Datetime=True; Connect Timeout=30; " + "Default Command Timeout=60; Use Compression=True; " + "Keep Alive=15; Charset=utf8; database={4}; respect binary flags=false;", hostIP, "ibem", "mosgatim1", hostPort, hostDB); myConn.Open(); MySqlCommand c = new MySqlCommand(); c.Connection = myConn; c.CommandText = "create database if not exists efatura collate=utf8_general_ci"; c.ExecuteNonQuery(); c.CommandText = "create table if not exists efatura.efatura ( " + " id double unsigned not null auto_increment, " + " faturaid double unsigned not null, " + " faturatipi varchar(20), " + " faturadb varchar(20), " + " faturatarihi date, " + " row_time timestamp default CURRENT_TIMESTAMP()," + " faturaxml longblob, " + " faturaxslt longblob, " + " faturazip longblob, " + " faturalog longblob, " + " primary key (id), " + " key fid(faturaid), " + " key ftip(faturatipi), " + " key fdb(faturadb) " + ") engine=myisam collate=utf8_general_ci"; c.ExecuteNonQuery(); c.CommandText = "create table if not exists efatura.efaturalog ( " + " id double unsigned not null , " + " faturaid double unsigned not null, " + " faturatipi varchar(20), " + " faturadb varchar(20), " + " faturatarihi date, " + " row_time datetime," + " faturaxml longblob, " + " faturaxslt longblob, " + " faturazip longblob, " + " faturalog longblob, " + " delete_time timestamp default CURRENT_TIMESTAMP(), " + " delid double unsigned not null auto_increment, " + " primary key (delid), " + " key fid(faturaid), " + " key ftip(faturatipi), " + " key fdb(faturadb)" + ") engine=myisam collate=utf8_general_ci"; c.ExecuteNonQuery(); c.CommandText = "create table if not exists efatura.baglantilar ( " + " id double unsigned not null auto_increment, " + " alias varchar(255), " + " hostip varchar(30), " + " hostport varchar(8), " + " hostdb varchar(255), " + " SaveXmlPath varchar(255), " + " primary key(id)," + " unique key alho(alias,hostip) " + ") engine=myisam collate=utf8_general_ci"; c.ExecuteNonQuery(); CheckField("efatura.baglantilar", "INGEntVar", "tinyint(1)", " default 0"); CheckField("efatura.baglantilar", "INGKullanici", "varchar(255)", " default ''"); CheckField("efatura.baglantilar", "INGSifre", "varchar(255)", " default ''"); CheckField("efatura.baglantilar", "INGVKN", "varchar(255)", " default ''"); CheckField("efatura.baglantilar", "INGAlias", "varchar(255)", " default ''"); } catch (MySqlException ex) { MessageBox.Show("Error connecting to the server: " + ex.Message); } }