add

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;


namespace Database_Lecture
{
public partial class frmAddRecord : Form
{
public frmAddRecord()
{
InitializeComponent();
}


Form1 _owner;
//string f2Snumber;
public frmAddRecord(Form1 owner)
{
InitializeComponent();
//f2Snumber = snumber;
// lblStudentNumber.Text = f2Snumber;
_owner = owner;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.frmAddRecord_FormClosing);
}


private void frmAddRecord_Load(object sender, EventArgs e)
{
initializeValues();
}


private void initializeValues()
{


string query = "Select * from tbl_student_record";
string queryCourse = "Select * from tbl_course";
string queryCountRecord = "SELECT MAX([Student Number]) FROM tbl_student_record";
clsDatabaseManager obj = new clsDatabaseManager();
obj.fillComboBox(cboCourse, queryCourse, ComboBoxStyle.DropDownList);


DateTime dt = DateTime.Now;










string strLast3Digits = obj.getSingleValue(queryCountRecord);
int max_rec_num = 0;
if (obj.getSingleValue(query).Equals(""))
{
lblStudentNumber.Text = dt.ToString("yyyyMMdd") + "-" + String.Format("{0:000}", (max_rec_num + 1)).ToString();
}
else
{
max_rec_num = Convert.ToInt32(strLast3Digits.Substring(strLast3Digits.Length - 3, 3));
lblStudentNumber.Text = dt.ToString("yyyyMMdd") + "-" + String.Format("{0:000}", (max_rec_num + 1)).ToString();
}


}


private void btnAdd_Click(object sender, EventArgs e)
{
clsDatabaseManager addRecord = new clsDatabaseManager(); 
string query = " Insert into tbl_student_record " +
@" values ('" + lblStudentNumber.Text + "'," +
@" '" + txtFirstName.Text + "', " +
@" '" + txtLastName.Text + "'," +
@" '" + txtMiddleName.Text + "', " +
@" " + int.Parse(txtAge.Text) + "," +
@" '" + cboCourse.Text + "'," +
@" '" + txtAddress.Text + "')";
addRecord.execute(query);
MessageBox.Show ("New Record was created!!!");
this.DialogResult = DialogResult.OK;
}


private void frmAddRecord_FormClosing(object sender, FormClosingEventArgs e)
{
_owner.PerformRefresh();
}
}
}