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