public User_Permission()
{
adt = new DBTableAdapters.User_PermisionTableAdapter();
dt = new DB.User_PermisionDataTable();
adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
}
private void btLogin_Click(object sender, EventArgs e)
{
try
{
String connection = "Data Source=42.112.28.93;Initial Catalog=QT_2;Persist Security Info=True;User ID=wss_price;Password=HzlRt4$$axzG-*UlpuL2gYDu;connection timeout=200";
//String connectionCrawler = "Data Source=192.168.100.183;Initial Catalog=QTCrawler;Integrated Security=False;User=sa;Password=123";
//String connectionCrawler = @"Data Source=192.168.100.183;Initial Catalog=SaleNews;Integrated Security=False;User=sa;Password=123";
String connectionCrawler = "Data Source=172.22.30.82,1452;Initial Catalog=QTCrawler;Persist Security Info=True;User ID=qt_vn;Password=@F4sJ=l9/ryJt9MT;connection timeout=200";
String logConnection = "Data Source=172.22.30.86,1455;Initial Catalog=QT_2;Persist Security Info=True;User ID=qt_vn;Password=@F4sJ=l9/ryJt9MT;connection timeout=200";
switch (QT.Entities.Server.ServerRun)
{
case "store":
connection = connection.Replace("42.112.28.93", ".");
break;
case "hvtcphc":
logConnection = logConnection.Replace("118.70.205.94", "172.16.34.86");
connectionCrawler = connectionCrawler.Replace("118.70.205.94", ".");
break;
case "hvtcdn":
logConnection = logConnection.Replace("118.70.205.94", "10.168.200.86");
connectionCrawler = connectionCrawler.Replace("118.70.205.94", "10.168.200.82");
break;
case "fpt":
connection = connection.Replace("42.112.28.93", "172.22.1.82");
break;
}
QT.Entities.Server.ConnectionString = connection;
QT.Entities.Server.ConnectionStringCrawler = connectionCrawler;
QT.Entities.Server.LogConnectionString = logConnection;
adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
//adt.FillBy_UserPass(dt, txtUser.Text.Trim(), Common.GetPassWord(txtPass.Text.Trim()));
adt.FillBy_UserPass(dt, txtUser.Text.Trim(), Bussiness.CryptoWSS.Encrypt(txtPass.Text.Trim()));
if (dt.Rows.Count > 0)
{
DialogResult = DialogResult.OK;
QT.Users.User.UserName = txtUser.Text.Trim();
QT.Users.User.UserID = Common.Obj2Int(dt.Rows[0]["ID"].ToString());
//Check Quyền
DBTableAdapters.User_PermisionTableAdapter userpermisionAdapter = new DBTableAdapters.User_PermisionTableAdapter();
userpermisionAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
DB.User_PermisionDataTable userpermissionTable = new DB.User_PermisionDataTable();
userpermisionAdapter.FillBy_IDUser(userpermissionTable, QT.Users.User.UserID);
if (userpermissionTable.Rows.Count > 0)
{
List <int> listper = new List <int>();
for (int i = 0; i < userpermissionTable.Rows.Count; i++)
{
listper.Add(Common.Obj2Int(userpermissionTable.Rows[i]["IDPermission"].ToString()));
}
QT.Users.User.PermisionID = listper;
}
QT.Entities.Server.UserID = QT.Users.User.UserID;
//Log đăng nhập
LogJobAdapter.SaveLog(JobName.Login, "Đăng nhập Manager", 0, (int)JobTypeData.KhongXacDinh);
this.Close();
}
else
{
MessageBox.Show("User hoặc mật khẩu không dúng, liên hệ với admin");
this.txtUser.Focus();
this.txtUser.SelectAll();
}
}
catch (Exception)
{
MessageBox.Show("Không kết nối được, bạn hãy thử kiểm tra lại mạng");
}
}
