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); } }