private void frmMain_Load(object sender, EventArgs e)
{
mysql.constring = "Data Source= localhost;Database=;User ID=root;Password="******";charset=utf8";
mysql.tablename = "check";
mysql.cmdText = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'engineering_school'";
mysql.DataBind();
dst = mysql.dst;
if (dst.Tables["check"].Rows.Count > 0)
{
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8";
dgvMain.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Myanmar3", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
}
else
{
//mysql.cmdText = "DROP DATABASE engineering_school";
//mysql.DataBind();
//mysql.constring = "Data Source= localhost;Database=;User ID=root;Password="******";charset=utf8";
mysql.cmdText = "CREATE DATABASE engineering_school COLLATE utf8_unicode_ci";
mysql.DataBind();
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8";
using (MySqlConnection con = new MySqlConnection(mysql.constring))
{
using (MySqlCommand cmd = new MySqlCommand())
{
using (MySqlBackup backup = new MySqlBackup(cmd))
{
cmd.Connection = con;
con.Open();
// File.Create(fbdlBackup.SelectedPath + "\\MES.sql");
backup.ImportFromFile(Application.StartupPath + "\\NewDb.sql");
con.Close();
//DialogResult result = MessageBox.Show("Database အား restore ပြုလုပ်ပြီးဖြစ်ပါသည်။ Software အား restart ပြုလုပ်မည်ဖြစ်ပါသည်။", "သင်တန်းဆိုင်ရာ သတင်းပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
//Application.Restart();
}
try
{
string uname = string.Empty;
string pass = string.Empty;
frmlogin login = new frmlogin();
login.ShowDialog();
string logName = login.txtUname.Text;
this.WindowState = FormWindowState.Minimized;
if (login.DialogResult == System.Windows.Forms.DialogResult.Cancel)
{
Environment.Exit(0);
}
else
{
mysql.tablename = "auth";
mysql.cmdText = "select * from auth where uname = '" + login.txtUname.Text + "'";
mysql.DataBind();
if (mysql.dst.Tables["auth"].Rows.Count > 0)
{
//string mm = mysql.dst.Tables["setting"].Rows[0]["log"].ToString();
pass = mysql.dst.Tables["auth"].Rows[0]["pass"].ToString();
if (pass == login.txtpass.Text)
{
this.WindowState = FormWindowState.Maximized;
mysql.tablename = "logs";
mysql.AddParams("@uname", logName);
mysql.AddParams("@log", DateTime.Now.ToString());
mysql.cmdText = "INSERT INTO logs(uname,status,dateTIme) VALUES ('" + logName + "','Successfully Login','" + DateTime.Now.ToString() + "')";
mysql.insert();
login.Dispose();
load_training_name();
}
else
{
this.Hide();
WrongAuth(logName);
}
}
else
{
this.Hide();
WrongAuth(logName);
}
}
}
catch
{
MessageBox.Show("Database Server ချိတ်ဆက်မှုမအောင်မြင်ပါ။ Server အားပြန်လည်စစ်ဆေးရန်။", "System ဆိုင်ရာသတိပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Information);
Environment.Exit(0);
}
}