private void CheckAction(string action)
{
try
{
switch (action)
{
case "Insert":
if (CheckAuth() && (txtNewPass.Text == txtConfirmPass.Text))
{
mysql.cmdText = "insert into auth (uname,pass) values ('" + txtNewUser.Text + "','" + txtNewPass.Text + "')";
mysql.insert();
Refresh();
MessageBox.Show("New account is successfully added", "Login Account");
}
break;
case "Update":
if (CheckAuth() && (txtNewPass.Text == txtConfirmPass.Text))
{
mysql.cmdText = "update auth set uname = '" + txtNewUser.Text + "',pass='******' where uname='" + txtOldUser.Text + "'";
mysql.DataBind();
Refresh();
MessageBox.Show("Account is successfully updated", "Login Account");
}
break;
case "Delete":
if (!string.Equals(txtOldUser.Text, ""))
{
mysql.cmdText = "delete from auth where uname='" + txtOldUser.Text + "'";
mysql.DataBind();
Refresh();
MessageBox.Show("Account is successfully removed", "Login Account");
}
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmTraining_Load(object sender, EventArgs e)
{
try
{
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8";
dgvTrainner.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Myanmar3", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dgvTrainner.Invalidate();
dst.Tables.Clear();
mysql.tablename = "training";
mysql.cmdText = "SELECT id,training_name_id,training_name,batch,start_date,end_date,trainner_quantity FROM training_info WHERE training_name='" + training_name + "' AND batch='" + batch + "'";
mysql.DataBind();
dst = mysql.dst;
lblTraining.Text = dst.Tables["training"].Rows[0]["training_name"].ToString() + " အမှတ်စဉ်(" + dst.Tables["training"].Rows[0]["batch"].ToString() + ")";
lblS_date.Text = dst.Tables["training"].Rows[0]["start_date"].ToString();
lblE_date.Text = dst.Tables["training"].Rows[0]["end_date"].ToString();
switch (training_row)
{
case "1":
rdoOfficer.Checked = true;
rdoOtherRank.Enabled = false;
break;
case "2":
rdoOtherRank.Checked = true;
rdoOfficer.Enabled = false;
break;
case "3":
rdoOfficer.Checked = true;
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void load_training_name(string training_name_filter)
{
//to get training name from table
mysql.tablename = "training_name";
mysql.cmdText = "SELECT * FROM training_name WHERE training_name LIKE '" + training_name_filter + "'";
mysql.DataBind();
dst = mysql.dst;
}
private void Usage_Log_Load(object sender, EventArgs e)
{
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******"log";
mysql.cmdText = "select * from logs";
mysql.DataBind();
dataGridView1.Rows.Clear();
int count = mysql.dst.Tables["log"].Rows.Count;
dataGridView1.Rows.Add(count);
for (int i = 0; i < count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = mysql.dst.Tables["log"].Rows[i]["uname"].ToString();
dataGridView1.Rows[i].Cells[1].Value = mysql.dst.Tables["log"].Rows[i]["dateTime"].ToString();
dataGridView1.Rows[i].Cells[2].Value = mysql.dst.Tables["log"].Rows[i]["status"].ToString();
}
}
private void frmOfficer_Load(object sender, EventArgs e)
{
try
{
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8";
//dgvOfficer.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Myanmar3", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//Display Columns Header
dgvOfficer.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dgvOfficer.ColumnHeadersHeight = 25;
dgvOfficer.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvOfficer.CellPainting += new DataGridViewCellPaintingEventHandler(dgvOfficer_CellPainting);
dgvOfficer.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//dgvOfficer.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
dgvOfficer.Invalidate();
//dgvOfficer.AutoSizeRowsMode = DataGridViewAutoSizeRowMode.RowHeader;
this.WindowState = FormWindowState.Maximized;
if (dst.Tables.Count != 0)
{
dst.Tables.Clear();
}
dgvOfficer.Columns.Clear();
dgvOfficer.Rows.Clear();
dgvOfficer.Refresh();
cbotrainningName.Items.Clear();
//to get training information
mysql.tablename = "training_name";
mysql.cmdText = "SELECT * FROM training_name WHERE row=1 OR row=3";
mysql.DataBind();
dst = mysql.dst;
//to get officer name
mysql.tablename = "officer_name";
mysql.cmdText = "SELECT * FROM officer_name";
mysql.DataBind();
dst = mysql.dst;
//datagridview add columns
dgvOfficer.Columns.Add(dst.Tables["officer_name"].Columns["officer_id"].ToString(), "စဉ်");
dgvOfficer.Columns[dst.Tables["officer_name"].Columns["officer_id"].ToString()].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvOfficer.Columns.Add(dst.Tables["officer_name"].Columns["bc_no"].ToString(), "ပြန်တမ်း၀င်အမှတ်");
dgvOfficer.Columns.Add(dst.Tables["officer_name"].Columns["rank"].ToString(), "အဆင့်");
dgvOfficer.Columns.Add(dst.Tables["officer_name"].Columns["name"].ToString(), "အမည်");
dgvOfficer.Columns.Add(dst.Tables["officer_name"].Columns["battalion"].ToString(), "တပ်");
dst.Tables.Remove("officer_name");
for (int i = 0; i < dst.Tables["training_name"].Rows.Count; i++)
{
dgvOfficer.Columns.Add(dst.Tables["training_name"].Rows[i]["training_name_id"].ToString(), dst.Tables["training_name"].Rows[i]["training_name"].ToString());
Size titleSize = TextRenderer.MeasureText(dst.Tables["training_name"].Rows[i]["training_name"].ToString(), font);
if (this.dgvOfficer.ColumnHeadersHeight < titleSize.Width)
{
this.dgvOfficer.ColumnHeadersHeight = titleSize.Width - 20;
}
}
//get training name from table to combobox
if (dst.Tables["training_name"].Rows.Count > 0)
{
for (int i = 0; i < dst.Tables["training_name"].Rows.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = dst.Tables["training_name"].Rows[i]["training_name"].ToString();
item.Value = dst.Tables["training_name"].Rows[i]["training_name_id"].ToString();
cbotrainningName.Items.Add(item);
cboSearchTRaining.Items.Add(item);
}
}
else
{
MessageBox.Show("သင်တန်းအမည် ထည့်သွင်းထားခြင်းမရှိသေးပါ။", "သင်တန်းဆိုင်ရာ သတင်းပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
load_officer_info("%");
load_training_state();
//DataTable dt = new DataTable();
//foreach (DataGridViewColumn col in dgvOfficer.Columns)
//{
// dt.Columns.Add(col.Name);
//}
//foreach (DataGridViewRow row in dgvOfficer.Rows)
//{
// DataRow dRow = dt.NewRow();
// foreach (DataGridViewCell cell in row.Cells)
// {
// dRow[cell.ColumnIndex] = cell.Value;
// }
// dt.Rows.Add(dRow);
//}
//DataView dv;
//dv = new DataView(dt ,"rank = 'ဗိုလ်' ", "rank Desc", DataViewRowState.CurrentRows );
//dgvOfficer.DataSource = dv;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmOther_rank_Load(object sender, EventArgs e)
{
try
{
this.WindowState = FormWindowState.Maximized;
mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8";
dgvOther_rank.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Myanmar3", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//Display Columns Header
dgvOther_rank.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dgvOther_rank.ColumnHeadersHeight = 25;
dgvOther_rank.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvOther_rank.CellPainting += new DataGridViewCellPaintingEventHandler(dgvOther_rank_CellPainting);
dgvOther_rank.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//dgvOfficer.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
//to get officer name
mysql.tablename = "other_rank_name";
mysql.cmdText = "SELECT * FROM other_rank_name";
mysql.DataBind();
dst = mysql.dst;
//to get training information
mysql.tablename = "training_name";
mysql.cmdText = "SELECT * FROM training_name WHERE row=2 OR row=3";
mysql.DataBind();
dst = mysql.dst;
//datagridview add columns
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["other_rank_id"].ToString(), "စဉ်");
dgvOther_rank.Columns[dst.Tables["other_rank_name"].Columns["other_rank_id"].ToString()].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["service_no"].ToString(), "ကိုယ်ပိုင်နံပါတ်");
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["rank"].ToString(), "အဆင့်");
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["name"].ToString(), "အမည်");
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["battalion"].ToString(), "တပ်");
dgvOther_rank.Columns.Add(dst.Tables["other_rank_name"].Columns["edu_level"].ToString(), "ပညာရပ်");
dst.Tables.Remove("other_rank_name");
for (int i = 0; i < dst.Tables["training_name"].Rows.Count; i++)
{
dgvOther_rank.Columns.Add(dst.Tables["training_name"].Rows[i]["training_name_id"].ToString(), dst.Tables["training_name"].Rows[i]["training_name"].ToString());
Size titleSize = TextRenderer.MeasureText(dst.Tables["training_name"].Rows[i]["training_name"].ToString(), font);
if (this.dgvOther_rank.ColumnHeadersHeight < titleSize.Width)
{
this.dgvOther_rank.ColumnHeadersHeight = titleSize.Width - 20;
}
}
if (dst.Tables["training_name"].Rows.Count > 0)
{
for (int i = 0; i < dst.Tables["training_name"].Rows.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = dst.Tables["training_name"].Rows[i]["training_name"].ToString();
item.Value = dst.Tables["training_name"].Rows[i]["training_name_id"].ToString();
cbotrainningName.Items.Add(item);
cboSearchTRaining.Items.Add(item);
}
}
else
{
MessageBox.Show("သင်တန်းအမည် ထည့်သွင်းထားခြင်းမရှိသေးပါ။", "သင်တန်းဆိုင်ရာ သတင်းပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
load_training_info("%");
load_training_state();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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);
}
}
void load_training_name()
{
try
{
dst = new DataSet();
//clear the datagridview
dgvTraining_name.Rows.Clear();
dgvTraining_name.Refresh();
//to get training name from table
mysql.tablename = "training_name";
mysql.cmdText = "SELECT * FROM training_name";
mysql.DataBind();
dst = mysql.dst;
//datagridview columns adding and set width by ratio
dgvTraining_name.Columns.Clear();
dgvTraining_name.Columns.Add("no", "စဉ်");
dgvTraining_name.Columns.Add("trainingName", "သင်တန်းအမည်");
dgvTraining_name.Columns.Add("row", "မှတ်ချက်");
dgvTraining_name.Columns[0].FillWeight = 30;
dgvTraining_name.Columns[1].FillWeight = 200;
dgvTraining_name.Columns[0].FillWeight = 100;
//to set data from database table to datagridview
if (dst.Tables["training_name"].Rows.Count > 0)
{
dgvTraining_name.Rows.Add(dst.Tables["training_name"].Rows.Count);
for (int i = 0; i < dst.Tables["training_name"].Rows.Count; i++)
{
dgvTraining_name.Rows[i].Tag = dst.Tables["training_name"].Rows[i]["training_name_id"].ToString();
dgvTraining_name.Rows[i].Cells["no"].Value = Eng_2_Myan((i + 1).ToString());
dgvTraining_name.Rows[i].Cells["trainingName"].Value = dst.Tables["training_name"].Rows[i]["training_name"].ToString();
switch (dst.Tables["training_name"].Rows[i]["row"].ToString())
{
case "1":
dgvTraining_name.Rows[i].Cells["row"].Value = "အရာရှိ";
break;
case "2":
dgvTraining_name.Rows[i].Cells["row"].Value = "အခြားအဆင့်";
break;
case "3":
dgvTraining_name.Rows[i].Cells["row"].Value = "အရာရှိ/အခြားအဆင့်";
break;
}
}
}
else
{
MessageBox.Show("သင်တန်းအမည် ထည့်သွင်းထားခြင်းမရှိသေးပါ။", "သင်တန်းဆိုင်ရာ သတင်းပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//clear table in the dateset
dst.Tables.Clear();
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}