private void viewFines_Click(object sender, EventArgs e) { FineRecorddb db = new FineRecorddb(); DataSet ds = db.AllPendingFines(); dataGridView1.DataSource = ds; paneView.BringToFront(); }
private void button1_Click(object sender, EventArgs e) { FineRecorddb db = new FineRecorddb(); if (db.sendMail(txtRollNo.Text, txtFineDetail2.Text)) { MessageBox.Show("Email Sent Successfully!"); } else { MessageBox.Show("Email Not Sent! Problem with Connection!"); } }
private void button2_Click(object sender, EventArgs e) { if (txtRollNo.Text.Length > 0) { FineRecord fr = new FineRecord(); fr.RollNo = txtRollNo.Text; fr.FineDate = DateTime.Now; fr.Amount = Convert.ToInt32(txtFineAmount.Text); fr.Charges = 5; fr.DueDate = DateTime.Now.AddDays(Convert.ToInt32(txtDueDays.Text)); fr.FineDetail = txtDetail.Text; FineRecorddb frdb = new FineRecorddb(); if (frdb.EnterFineRecord(fr)) { MessageBox.Show("New Record Entry Done!"); } } }
private void btnSearch_Click(object sender, EventArgs e) { if (txtRollNo2.Text.Length > 0) { string rollno = txtRollNo2.Text; FineRecorddb frdb = new FineRecorddb(); FineRecord fr; fr = frdb.SearchFine(rollno); if (fr != null) { txtAmount2.Text = fr.Amount + ""; txtDueDate.Text = fr.DueDate.ToString(); txtFineDetail2.Text = fr.FineDetail; } } else { MessageBox.Show("Student Has No Fine on his Head!"); } }
private void btnSave_Click(object sender, EventArgs e) { frmConnection con = new frmConnection(); con.ShowDialog(); con.GetPort(); //frmDemo demo = new frmDemo(); //demo.ShowDialog(); sendSMS sndsms = new sendSMS(); FineRecorddb db = new FineRecorddb(); string contact = db.GetGContact(txtRollNo.Text); string[] com = { "COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8" }; //MessageBox.Show(contact); string comNum = "0"; //contact = "+923336374591"; for (int i = 0; i < 8; i++) { if (sndsms.SetCOMNum(com[i])) { comNum = com[i]; } } if (contact != "0") { string msg = "Fine Amount:" + txtFineAmount.Text; msg += "\nFine Detail:" + txtDetail; sndsms.SetCOMNum(comNum); sndsms.Sendsms(msg, contact); } else { MessageBox.Show("Error No Guardian Contact number or invalid!"); } }