public void checkClassFeesPaid() { try { MysqlConn msc2 = new MysqlConn(); msc2.query = "select * from escolaya_db.class_fee where month=" + DateTime.Now.ToString("MM") + " and student_id=" + studentId; MySqlConnection conn = new MySqlConnection(msc2.con); conn.Open(); msc2.command = new MySqlCommand(msc2.query, conn); msc2.mdr = msc2.command.ExecuteReader(); while (msc2.mdr.Read()) { if (msc2.mdr["id"] != DBNull.Value) { return; } } pictureBox2.Visible = true; } catch (Exception ex) { } }
private void metroButton1_Click(object sender, EventArgs e) { Random rnd = new Random(); int barcode = rnd.Next(100000000, 900000000); byte[] imageBt = null; FileStream fStream = new FileStream(picPath, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fStream); imageBt = br.ReadBytes((int)fStream.Length); MysqlConn sql = new MysqlConn(); string query = "insert into escolaya_db.student(full_name,dob,address,email,gender,nic,contact_no,parent_contact_no,class,added_date,barcode,image) values('" + txtfname.Text + "','" + dateTimePicker1.Value.ToString("dd-MM-yyyy") + "','" + txtaddress.Text + "','" + txtemail.Text + "','" + gender + "','" + txtnic.Text + "','" + txtcontactno.Text + "','" + txtpcontactno.Text + "','" + comboclass.Text + "','" + DateTime.Now.ToString() + "','" + barcode.ToString() + "',@IMG)"; MySqlConnection conDatabase = new MySqlConnection(sql.con); MySqlCommand cmdDatabase = new MySqlCommand(query, conDatabase); MySqlDataReader myReader; //try { conDatabase.Open(); cmdDatabase.Parameters.Add(new MySqlParameter("@IMG", imageBt)); myReader = cmdDatabase.ExecuteReader(); PopupNotifier popup = new PopupNotifier(); popup.HeaderColor = Color.DarkSlateGray; popup.HeaderHeight = 20; popup.TitleText = "Register New Student"; //popup.TitleFont = new Font(FontFamily.GenericSansSerif, 12.0f,FontStyle.Regular); popup.ContentText = "New user added successfully!!!"; popup.ContentColor = Color.DarkSlateGray; popup.Popup(); while (myReader.Read()) { } FrmAutogenCard card = new FrmAutogenCard(barcode.ToString(), txtfname.Text, barcode.ToString()); card.Viewcard(txtfname.Text, txtaddress.Text, dateTimePicker1.Value.ToString("dd-MM-yyyy"), picPath); card.getClassDetails(); card.ShowDialog(); //} //catch (Exception ex) { //} }
private void txtbarcode_leave(object sender, EventArgs e) { try { MysqlConn msc = new MysqlConn(); msc.query = "select full_name from escolaya_db.student where barcode=" + txtbarcode.Text; MySqlConnection conn = new MySqlConnection(msc.con); conn.Open(); msc.command = new MySqlCommand(msc.query, conn); msc.mdr = msc.command.ExecuteReader(); msc.mdr.Read(); lblname.Text = msc.mdr.GetString("full_name"); } catch (Exception ex) { } }
public void getClassDetails() { try { MysqlConn msc = new MysqlConn(); msc.query = "select institute_name,institute_address from escolaya_db.institute_detail"; MySqlConnection conn = new MySqlConnection(msc.con); conn.Open(); msc.command = new MySqlCommand(msc.query, conn); msc.mdr = msc.command.ExecuteReader(); while (msc.mdr.Read()) { lblinstitutename.Text = msc.mdr.GetString("institute_name"); lblinstituteaddress.Text = msc.mdr.GetString("institute_address"); } conn.Close(); } catch (Exception ex) { } }
public void fillClass() { try { MysqlConn msc = new MysqlConn(); msc.query = "select class_name from escolaya_db.class "; MySqlConnection conn = new MySqlConnection(msc.con); conn.Open(); msc.command = new MySqlCommand(msc.query, conn); msc.mdr = msc.command.ExecuteReader(); while (msc.mdr.Read()) { string className = msc.mdr.GetString("class_name"); comboclass.Items.Add(className); } conn.Close(); } catch (Exception ex) { } }