private void button2_Click(object sender, EventArgs e) { if (textBox3.Text != "" && textBox4.Text != "") { if (textBox3.Text == textBox4.Text) { u1.password = textBox3.Text; DataBase_connector dc = new DataBase_connector(); string update = "UPDATE `sim_registaration`.`user` SET `Password`='" + u1.password + "' WHERE `UserID`='" + u1.userID + "';"; dc.datainput(update); MessageBox.Show("Succsessfully reset you password"); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; } else { MessageBox.Show("Password not match please re check"); } } else { MessageBox.Show("fill the all fields"); } }
private void button1_Click(object sender, EventArgs e) { if (textBox2.Text != "") { string nic_num = textBox2.Text; DataBase_connector dc = new DataBase_connector(); string check = "SELECT * FROM sim_registaration.user where nic_num='" + nic_num + "';"; DataTable dt = dc.read(check); if (dt.Rows.Count != 0) { foreach (DataRow row in dt.Rows) { textBox1.Text = row[1].ToString();; groupBox2.Visible = true; label9.Text = row[8].ToString(); u1.c_answer = row[9].ToString(); u1.userID = Convert.ToInt32(row[0]); } } else { MessageBox.Show("User name or NIC incorrect"); } } else { MessageBox.Show("Empty user name or password"); } }
private void button1_Click_1(object sender, EventArgs e) { if (textBox1.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" && pictureBox1.Image != null && pictureBox2.Image != null && (radioButton1.Checked || radioButton2.Checked)) { //pass customer details to Sim class Sim s1 = new Sim(); s1.sim_num = textBox1.Text; s1.P_num = textBox2.Text; s1.F_name = textBox3.Text; s1.L_name = textBox4.Text; s1.nic = textBox5.Text; s1.address = textBox6.Text; s1.img1Loc = textBox8.Text; s1.img2Loc = textBox7.Text; string newFileName1 = s1.img1Loc.Replace("\\", "\\\\"); string newFileName2 = s1.img2Loc.Replace("\\", "\\\\"); if (radioButton1.Checked) { s1.Gender = "Male"; } else if (radioButton2.Checked) { s1.Gender = "Female"; } s1.SIM_Category = label9.Text; // pass data to database s1.date = DateTime.Now.ToString("yyyy/MM/dd"); string add = "INSERT INTO `sim_registaration`.`sim` (`phonnumbr`, `SIM_Number`, `First Name`, `Last Name`, `NIC Number`, `Address`, `Gender`, `SIM Category`, `Date`, `img1Location`, `img2Location`) VALUES ('" + s1.P_num + "', '" + s1.sim_num + "', '" + s1.F_name + "', '" + s1.L_name + "', '" + s1.nic + "', '" + s1.address + "', '" + s1.Gender + "', '" + s1.SIM_Category + "', '" + s1.date + "', '" + newFileName1 + "', '" + newFileName2 + "');"; DataBase_connector db2 = new DataBase_connector(); db2.datainput(add); MessageBox.Show("Successfuly save details"); //image backup save // File.Copy(textBox7.Text, Path.Combine(@"C:\Users\Chinthaka\Desktop\saveiamge\", Path.GetFileName(textBox7.Text)), true); //auto clear form data textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; pictureBox1.Image = null; pictureBox2.Image = null; } else { MessageBox.Show("Please fill the all filed"); } }
private void btn_lgn_Click_3(object sender, EventArgs e) { if (txt_user.Text != "" && txt_pswd.Text != "") { string username = txt_user.Text; DataBase_connector dc = new DataBase_connector(); string add = "SELECT * FROM sim_registaration.user where UserName='******';"; DataTable dt = dc.read(add); if (dt.Rows.Count != 0) { foreach (DataRow row in dt.Rows) { Userclass u1 = new Userclass(); u1.password = row[2].ToString(); u1.job = row[10].ToString(); if (u1.password == txt_pswd.Text) { if (u1.job == "Admin") { Form2 f2 = new Form2(); f2.menuStripadmin.Visible = true; f2.label7.Text = "Admin"; this.Hide(); f2.ShowDialog(); this.Show(); } else { Form2 f2 = new Form2(); f2.menuStrip2.Visible = true; f2.label7.Text = "employee"; this.Hide(); f2.ShowDialog(); this.Show(); } } else { MessageBox.Show(" passsword incorrect"); } } } else { MessageBox.Show("wrong user name"); } } else { MessageBox.Show("Empty User name or Password"); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" && textBox7.Text != "" && textBox8.Text != "" && textBox9.Text != "") { if (textBox7.Text == textBox8.Text) { //pass user input to user class Userclass u1 = new Userclass(); u1.F_name = textBox1.Text; u1.L_name = textBox2.Text; u1.address = textBox3.Text; u1.nic = textBox4.Text; u1.contact = textBox5.Text; u1.u_name = textBox6.Text; u1.password = textBox7.Text; u1.c_question = comboBox1.Text; u1.c_answer = textBox9.Text; //pass data to database string add = "INSERT INTO `sim_registaration`.`user` (`UserName`, `Password`, `F_name`, `L_name`, `address`, `nic_num`, `contact_num`, `confirm_qustn`, `confirm_anwr`) VALUES('" + u1.u_name + "', '" + u1.password + "', '" + u1.F_name + "', '" + u1.L_name + "', '" + u1.address + "', '" + u1.nic + "', '" + u1.contact + "', '" + u1.c_question + "', '" + u1.c_answer + "');"; DataBase_connector db1 = new DataBase_connector(); db1.datainput(add); MessageBox.Show("You have been successfuly"); // data clear textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; textBox7.Text = ""; textBox8.Text = ""; textBox9.Text = ""; comboBox1.Text = "Select"; } else { MessageBox.Show("not match password please recheck"); } } else { MessageBox.Show("Fill all fields"); } }
private void dataload() { string date = dateTimePicker1.Value.ToString("yyyy/MM/dd"); Sim s2 = new Sim(); Form2 f1 = new Form2(); DataBase_connector bd1 = new DataBase_connector(); string select = "SELECT * FROM sim_registaration.sim where Date = '" + date + "' ;"; DataTable dt1 = bd1.read(select); foreach (DataRow dr in dt1.Rows) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = dr[0].ToString(); row.Cells[1].Value = dr[1].ToString(); row.Cells[2].Value = dr[3].ToString(); row.Cells[3].Value = dr[4].ToString(); row.Cells[4].Value = dr[2].ToString(); row.Cells[5].Value = dr[5].ToString(); row.Cells[6].Value = dr[9].ToString(); row.Cells[7].Value = "More deteils"; dataGridView1.Rows.Add(row); } }
private void button2_Click_1(object sender, EventArgs e) { if (textBox1.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" && pictureBox1.Image != null && pictureBox2.Image != null && (radioButton1.Checked || radioButton2.Checked)) { //pass customer details to Sim class Sim s1 = new Sim(); s1.sim_num = textBox1.Text; s1.P_num = textBox2.Text; s1.F_name = textBox3.Text; s1.L_name = textBox4.Text; s1.nic = textBox5.Text; s1.address = textBox6.Text; s1.img1Loc = textBox8.Text; s1.img2Loc = textBox7.Text; string newFileName1 = s1.img1Loc.Replace("\\", "\\\\"); string newFileName2 = s1.img2Loc.Replace("\\", "\\\\"); Int32 id = Convert.ToInt32(label10.Text); if (radioButton1.Checked) { s1.Gender = "Male"; } else if (radioButton2.Checked) { s1.Gender = "Female"; } s1.SIM_Category = label9.Text; // update database data s1.date = DateTime.Now.ToString("yyyy/MM/dd"); string update = "UPDATE `sim_registaration`.`sim` SET `phonnumbr`='" + s1.P_num + "', `SIM_Number`='" + s1.sim_num + "', `First Name`='" + s1.F_name + "', `Last Name`='" + s1.L_name + "', `NIC Number`='" + s1.nic + "', `Address`='" + s1.address + "', `Gender`='" + s1.Gender + "', `SIM Category`='" + s1.SIM_Category + "', `Date`='" + s1.date + "', `img1Location`='" + newFileName1 + "', `img2Location`='" + newFileName2 + "' WHERE `SIM_Id`='" + id + "';"; DataBase_connector db3 = new DataBase_connector(); db3.datainput(update); //image backup save // File.Copy(textBox7.Text, Path.Combine(@"C:\Users\Chinthaka\Desktop\saveiamge\", Path.GetFileName(textBox7.Text)), true); //print printDocument1.PrintPage += printDocument1_PrintPage; if (printDialog1.ShowDialog() == DialogResult.OK) { button1.Hide(); button2.Hide(); button3.Hide(); button4.Hide(); button5.Hide(); button6.Hide(); button7.Hide(); printDocument1.Print(); } //auto clear form data textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; pictureBox1.Image = null; pictureBox2.Image = null; } else { MessageBox.Show("Please fill the all filed"); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { Sim s3 = new Sim(); Int32 rows = (e.RowIndex); DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[rows]; s3.userID = Convert.ToInt32(row.Cells[0].Value); string select = "SELECT * FROM sim_registaration.sim where SIM_Id='" + s3.userID + "';"; DataBase_connector db1 = new DataBase_connector(); DataTable dt = db1.read(select); foreach (DataRow dr in dt.Rows) { Form3 f1 = new Form3(); f1.textBox1.Text = dr[2].ToString(); if (row.Cells[1].Value.ToString() == "") { f1.textBox2.Enabled = false; } else { f1.textBox2.Text = dr[1].ToString(); } f1.textBox3.Text = dr[3].ToString(); f1.textBox4.Text = dr[4].ToString(); f1.textBox5.Text = dr[5].ToString(); f1.textBox6.Text = dr[6].ToString(); f1.label9.Text = dr[8].ToString(); f1.label10.Text = dr[0].ToString(); string mobiletype = dr[8].ToString(); f1.Text = "SIMRegistration [" + mobiletype + "]"; f1.textBox8.Text = dr[10].ToString(); f1.textBox7.Text = dr[11].ToString(); string img1location = dr[10].ToString(); string img2location = dr[11].ToString(); f1.pictureBox1.Image = Image.FromFile(img1location); f1.pictureBox2.Image = Image.FromFile(img2location); string Gender = dr[7].ToString(); if (Gender == "Male") { f1.radioButton1.Checked = true; } else { f1.radioButton2.Checked = true; } Form2 f2 = new Form2(); { f1.button1.Visible = false; f1.button2.Visible = true; } this.Hide(); f1.ShowDialog(); dataGridView1.Rows.Clear(); this.dataload(); this.Show(); } }