private void btnAccept_Click(object sender, EventArgs e)
{
bool validate = !(Machine_txt.Text.Equals("") && User_text.Text.Equals("") && Password_txt.Text.Equals(""));
if (validate)
{
InfoLogin info = new InfoLogin(Machine_txt.Text, Instance_txt.Text, User_text.Text, Password_txt.Text);
try
{
frmDatabaseList frm = new frmDatabaseList(info);
frm.MdiParent = Owner;
DialogResult = DialogResult.OK;
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
catch (Exception eb)
{
MessageBox.Show("Login failed: " + eb.Message);
}
if (rbtnTestAcc.Checked && cbxSave.Checked)
{
string saveAcc = String.Format("{0}:{1}:{2}:{3}",
Machine_txt.Text, Instance_txt.Text, User_text.Text, Password_txt.Text);
Properties.Settings.Default.test_login = saveAcc;
Properties.Settings.Default.Save();
}
}
else
{
MessageBox.Show("Vui lòng điền đủ thông tin đăng nhập");
}
}
//Get List DBInfo
private List <InfoDB> GetDBs(InfoLogin infoLogin)
{
List <InfoDB> list = new List <InfoDB>();
var monitoring_db = Properties.Settings.Default.default_monitoring_dbname;
string connectString = attConnect[0] + infoLogin.Machine +
attConnect[2] + infoLogin.User +
attConnect[3] + infoLogin.Password;
using (SqlConnection con = new SqlConnection(connectString))
{
con.Open();
string query = String.Format(
@"SELECT s.datasource, ds.[catalog] , d.createdDate, d.brandname, d.domainname, s.[user],s.password
FROM [{0}].[dbo].[storage] as s,
[{0}].[dbo].[domain_storage] as ds,
[{0}].[dbo].[domain] as d
WHERE S.ID = DS.storageid AND d.ID = ds.domainid AND s.[user] = '{1}'; " , monitoring_db, infoLogin.User);
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader dbList = cmd.ExecuteReader())
{
while (dbList.Read())
{
InfoDB dB = new InfoDB();
dB.DataSource = dbList["datasource"].ToString();
dB.Catalog = dbList["catalog"].ToString();
dB.CreatedDate = dbList["createdDate"].ToString();
dB.BrandName = dbList["brandName"].ToString();
dB.DomainName = dbList["domainName"].ToString();
dB.User = dbList["user"].ToString();
dB.Password = dbList["password"].ToString();
dB.UpdateChoice = false;
list.Add(dB);
}
}
}
}
return(list);
}
public frmDatabaseList(InfoLogin info)
{
InitializeComponent();
infoLogin = new InfoLogin(info.Machine, info.SeverName, info.User, info.Password);
frm_GetListDB();
}