private static DbConStringBuilder GetConnectionString(string passSql, string IPAddress)
{
DbConStringBuilder strBuilder = new DbConStringBuilder();
strBuilder.Server = IPAddress == "..."?"localhost":IPAddress;
strBuilder.UserID = "root";
strBuilder.Password = passSql;
strBuilder.Database = "clinic";
return(strBuilder);
}
private void button1_Click(object sender, EventArgs e)
{
string IP = maskedTextBox1.Text.Trim();
IP = Regex.Replace(IP, @"\s", "");
string[] lines = { textBox1.Text, IP };
// WriteAllLines creates a file, writes a collection of strings to the file,
// and then closes the file.
System.IO.File.WriteAllLines("WriteLines.txt", lines);
File.SetAttributes(
"WriteLines.txt",
FileAttributes.Archive |
FileAttributes.Hidden
);
//test connection ;
try
{
if (checkBox1.Checked == false)
{
///Old structure
DbConStringBuilder strBuilder = new DbConStringBuilder();
strBuilder.Server = "localhost";
strBuilder.UserID = "root";
strBuilder.Password = textBox1.Text;
//Program.conn = new MySqlConnection(strBuilder.ConnectionString);
//Program.conn.Open();
//InitDatabase(Program.conn, textBox1.Text);
///New Structure
///
DatabaseFactory.CreateNewDatabase("", strBuilder);
IDatabase database = DatabaseFactory.Instance;
database.CreateDatabase(textBox1.Text);
}
else
{
DbConStringBuilder strBuilder = new DbConStringBuilder();
strBuilder.Server = IP == " . . ." ? "localhost" : IP;
strBuilder.UserID = "root";
strBuilder.Password = textBox1.Text;
DatabaseFactory.CreateNewDatabase("", strBuilder);
IDatabase database = DatabaseFactory.Instance;
}
}
catch (Exception ex)
{
MessageBox.Show("Kết nối SQl server thất bại , vui lòng thử lại !" + ex.Message);
File.Delete("WriteLines.txt");
return;
}
this.DialogResult = DialogResult.OK;
}
