private void button1_Click(object sender, EventArgs e)
{
//
String current = System.IO.Directory.GetCurrentDirectory();
string fileName = current + "\\Connectstring.txt";
string connection_string = "";
string st1 = "";
string st2 = "";
string st3 = "";
string st4 = "";
const Int32 BufferSize = 128;
string line;
Model.SercurityFucntion bm2 = new Model.SercurityFucntion();
line = bm2.Readtextfromfile(fileName);
string line2 = bm2.Decryption(line);
string[] parts = line2.Split(';');
st1 = parts[0].Trim();
st2 = parts[1].Trim();
st3 = parts[2].Trim();
st4 = parts[3].Trim();
//string[] parts = line.Split(';');
//st1 = parts[0].Trim();
//st2 = parts[1].Trim();
//st3 = parts[2].Trim();
//st4 = parts[3].Trim();
// string s = txtservername.Text + ";" + txtusername.Text + ";" + txtpassword.Text + ";" + txt_dbname.Text;
connection_string = ("Data Source =" + st1 + "; Initial Catalog = " + st4 + "; User Id =" + st2 + "; Password ="******"Data Source = DESKTOP-8D4F853\\SQLEXPRESS; Initial Catalog = ARconfirmationletter; User Id = SA; Password = 123123";
if (txtusername.Text != "" & txtpassword.Text != "")
{
string queryText = @"SELECT Count(*) FROM tbl_Temp
WHERE username = @Username AND password = @Password";
using (SqlConnection cn = new SqlConnection(connection_string))
using (SqlCommand cmd = new SqlCommand(queryText, cn))
{
cmd.CommandTimeout = 60;
try
{
cn.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString() + "Lỗi đường truyền dữ liệu !", "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
cmd.Parameters.AddWithValue("@Username", txtusername.Text);
cmd.Parameters.AddWithValue("@Password", txtpassword.Text);
int result = (int)cmd.ExecuteScalar();
if (result > 0)
{
#region ghi vao data pass, user, connectstring
string s1 = st1 + ";" + st2 + ";" + st3 + ";" + st4 + ";" + txtusername.Text;
Model.SercurityFucntion bm = new Model.SercurityFucntion();
string s2 = bm.Encryption(s1);
bm.WritestringtoFile(fileName, s2);
#endregion
Username user = new Username();
int Ver = user.Version;
if (Ver == 20)
{
this.Hide();
View.Main main = new Main(); //
main.Closed += (s, args) => this.Close();
main.Show();
}
else
{
MessageBox.Show("You are using old version \n please use the new KA Version: " + Ver.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.Close();
}
}
else
{
MessageBox.Show("Wrong Username and Password !", "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//
String current = System.IO.Directory.GetCurrentDirectory();
string fileName = current + "\\String.txt";
string connection_string = "";
string st1 = "";
string st2 = "";
string st3 = "";
string st4 = "";
Model.SercurityFucntion bm2 = new Model.SercurityFucntion();
string line = bm2.Readtextfromfile(fileName);
string line2 = bm2.Decryption(line);
string[] parts = line2.Split(';');
st1 = parts[0].Trim();
st2 = parts[1].Trim();
st3 = parts[2].Trim();
st4 = parts[3].Trim();
// if (st4 =="cn")
// {
connection_string = ("Data Source =" + st1 + "; Initial Catalog = " + st4 + "; User Id =" + st2 + "; Password ="******"" & textBox2.Text != "")
{
string queryText = @"SELECT Count(*) FROM tbl_Temp
WHERE username = @Username AND password = @Password";
using (SqlConnection cn = new SqlConnection(connection_string))
using (SqlCommand cmd = new SqlCommand(queryText, cn))
{
try
{
cn.Open();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi đường truyền dữ liệu !" + ex.ToString(), "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
cmd.Parameters.AddWithValue("@Username", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
int result = (int)cmd.ExecuteScalar();
if (result > 0)
{
#region ghi vao data pass, user, connectstring
string s1 = st1 + ";" + st2 + ";" + st3 + ";" + st4 + ";" + textBox1.Text;
Model.SercurityFucntion bm = new Model.SercurityFucntion();
string s2 = bm.Encryption(s1);
bm.WritestringtoFile(fileName, s2);
#endregion
Model.Username user = new Model.Username();
int Ver = Model.Username.getVersion();
if (Ver == 80)
{
this.Hide();
View.Main main = new Main(); //
main.Closed += (s, args) => this.Close();
main.Show();
}
else
{
MessageBox.Show("You are using old version \n please use the new one: " + Ver.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.Close();
}
}
else
{
MessageBox.Show("Wrong Username and Password !", "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//
String current = System.IO.Directory.GetCurrentDirectory();
string fileName = current + "\\Connectstring.txt";
string connection_string = "";
string st1 = "";
string st2 = "";
string st3 = "";
// string st4 = "";
const Int32 BufferSize = 128;
using (var fileStream = File.OpenRead(fileName))
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true, BufferSize))
{
string line;
while ((line = streamReader.ReadLine()) != null)
{
Model.SercurityFucntion bm2 = new Model.SercurityFucntion();
line = bm2.Readtextfromfile(fileName);
string line2 = bm2.Decryption(line);
string[] parts = line2.Split(';');
st1 = parts[0].Trim();
st2 = parts[1].Trim();
st3 = parts[2].Trim();
// if (st4 =="cn")
// {
connection_string = ("Data Source =" + st1 + "; Initial Catalog = KAmanagement; User Id =" + st2 + "; Password ="******"Data Source = DESKTOP-8D4F853\\SQLEXPRESS; Initial Catalog = KAmanagement; User Id = SA; Password = 123123";
}
}
if (textBox1.Text != "" & textBox2.Text != "")
{
string queryText = @"SELECT Count(*) FROM tbl_Temp
WHERE username = @Username AND password = @Password";
using (SqlConnection cn = new SqlConnection(connection_string))
using (SqlCommand cmd = new SqlCommand(queryText, cn))
{
try
{
cn.Open();
}
catch (Exception)
{
MessageBox.Show("Lỗi đường truyền dữ liệu !", "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
cmd.Parameters.AddWithValue("@Username", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
int result = (int)cmd.ExecuteScalar();
if (result > 0)
{
//#region ghi vao data pass, user, connectstring
//string s1 = st1 + ";" + st2 + ";" + st3 + ";" + textBox1.Text;
//using (StreamWriter sw = new StreamWriter(fileName))
//{
// try
// {
// sw.WriteLine(s1);
// }
// catch (Exception)
// {
// // MessageBox.Show("Không ghi được, file server lost !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
//#endregion
#region ghi vao data pass, user, connectstring
string s1 = st1 + ";" + st2 + ";" + st3 + ";" + textBox1.Text;
// string s1 = st1 + ";" + st2 + ";" + st3 + ";" + st4 + ";" + textBox1.Text;
Model.SercurityFucntion bm = new Model.SercurityFucntion();
string s2 = bm.Encryption(s1);
bm.WritestringtoFile(fileName, s2);
#endregion
Model.Username user = new Model.Username();
int Ver = user.Version;
if (Ver == 65)
{
this.Hide();
View.Main main = new Main(); //
main.Closed += (s, args) => this.Close();
main.Show();
}
else
{
MessageBox.Show("You are using old version \n Please use The KA Ver: " + Ver.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.Close();
}
#region// read file xml và sửa app. config
/// connection_string = connection_string + "111";
//LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
//var rs = from tblCustomer in db.tblCustomers
// select tblCustomer;
//if (rs!= null)
//{
// MessageBox.Show(rs.Count().ToString() + " ok");
//}
//// string conString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
#endregion//read file xml và sửa app. config
}
else
{
MessageBox.Show("Wrong Username and Password !", "Connection !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}