private void button1_Click(object sender, EventArgs e)
{
if (txtYear1.Text == "")
{
MessageBox.Show("Please enter Year", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtYear1.Focus();
return;
}
if (txtTerm1.Text == "")
{
MessageBox.Show("Please enter Term", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtTerm1.Focus();
return;
}
if (txtSubject1.Text == "")
{
MessageBox.Show("Please enter Sub name.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtSubject1.Focus();
return;
}
//Main place to save data to the database
ConnectionString cs = new ConnectionString();
CommonClasses cc = new CommonClasses();
clsFunc cf = new clsFunc();
// string st1;
//string st2;
cc.con = new SqlConnection(cs.DBConn);
cc.con.Open();
string cb = "insert into Entry(Year,Term,Subject,Teacher,DateTime) VALUES (@d1,@d2,@d3,@d4,@d5)";
cc.cmd = new SqlCommand(cb);
cc.cmd.Connection = cc.con;
cc.cmd.Parameters.AddWithValue("@d1", txtYear1.Text);
cc.cmd.Parameters.AddWithValue("@d2", txtTerm1.Text);
cc.cmd.Parameters.AddWithValue("@d3", txtSubject1.Text);
cc.cmd.Parameters.AddWithValue("@d4", txtTeacherName1.Text);
cc.cmd.Parameters.AddWithValue("@d5", dateTimePicker1.Value);
year1 = txtYear1.Text;
term1 = txtTerm1.Text;
sub1 = txtSubject1.Text;
teacher1 = txtTeacherName1.Text;
date1 = dateTimePicker1.Value;
/*MemoryStream ms = new MemoryStream();
* Bitmap bmpImage = new Bitmap(Picture.Image);
* bmpImage.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
* byte[] data = ms.GetBuffer();
* SqlParameter p = new SqlParameter("@d8", SqlDbType.Image);
*/
/* p.Value = data;
* cc.cmd.Parameters.Add(p);*/
cc.cmd.ExecuteReader();
cc.con.Close();
/*st1 = lblUser.Text;
* st2 = "added the new Student'" + name + "' having Student id '" + txtStudentID.Text + "'";
* cf.LogFunc(st1, System.DateTime.Now, st2);
* btnSave.Enabled = false;*/
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
/* catch (Exception ex)
* {
* MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
Training train = new Training();
train.Show();
this.Hide();
}