public void processLogin()
{
this.Cursor = Cursors.WaitCursor;
kryptonButton1.Enabled = false;
string text = comboBox1.SelectedItem.ToString();
string store_name = getBetween(text, "SUBE_ADI =", ",").Trim();
string server_type = getBetween(text, "TYPE =", ",").Trim();
string server_ip = getBetween(text, "SERVER_IP =", ",").Trim();
string db_name = getBetween(text, "DB_NAME =", ",").Trim();
string user_id = getBetween(text, "USER_ID =", ",").Trim();
string user_pwd = getBetween(text, "USER_PWD =", "*PWD*").Trim();
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
if (server_type == "REMOTE")
{
connectionStringsSection.ConnectionStrings["carkMsSQLHelper"].ConnectionString = @"data source=" + server_ip + ";initial catalog=" + db_name + ";User Id=" + user_id + ";Password="******";";
}
if (server_type == "LOCAL")
{
connectionStringsSection.ConnectionStrings["carkMsSQLHelper"].ConnectionString = @"data source=" + server_ip + ";initial catalog=" + db_name + ";integrated security=True;";
}
config.Save();
ConfigurationManager.RefreshSection("connectionStrings");
carkSQLHelper.carkMsSQLHelper helper = new carkSQLHelper.carkMsSQLHelper();
string sql = "SELECT*FROM KULLANICILAR WHERE AKTIF=1 AND EPOSTA_ADRESI=@USERNAME AND PAROLA=@PASSWORD";
string[] param = { "@USERNAME", "@PASSWORD" };
string[] values = { txtUser.Text, txtPwd.Text };
DataTable dt = helper.getDataTableWithParameters(sql, param, values);
if (dt.Rows.Count == 1)
{
string user_name = dt.Rows[0]["AD"].ToString();
string user_last_name = dt.Rows[0]["SOYAD"].ToString();
MDI_FORM frm = new MDI_FORM();
frm.Text = store_name;
frm.toolStripStatusLabel1.Text = "MAĞAZA : " + store_name;
frm.toolStripStatusLabel2.Text = " KULLANICI : " + user_name + " " + user_last_name;
frm.Show();
this.Hide();
}
else
{
kryptonButton1.Enabled = true;
label4.Text = "Hatalı giriş...";
}
this.Cursor = Cursors.Default;
}
