private void btnSave_Click(object sender, EventArgs e) { if (SubjectCode.Text == "") { MessageBox.Show("Please enter subject code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectCode.Focus(); return; } if (SubjectName.Text == "") { MessageBox.Show("Please enter subject name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectName.Focus(); return; } if (cmbCourse.Text == "") { MessageBox.Show("Please select course name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbCourse.Focus(); return; } if (cmbBranch.Text == "") { MessageBox.Show("Please select Branch name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbBranch.Focus(); return; } if (Semester.Text == "") { MessageBox.Show("Please select semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Semester.Focus(); return; } try { con = new SqlConnection(cs.DBConn); con.Open(); string ct = "select subjectcode from subjectinfo where subjectcode=@find"; cmd = new SqlCommand(ct); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "subjectcode")); cmd.Parameters["@find"].Value = SubjectCode.Text; rdr = cmd.ExecuteReader(); if (rdr.Read()) { MessageBox.Show("Subject Code Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectCode.Text = ""; SubjectCode.Focus(); if ((rdr != null)) { rdr.Close(); } return; } con = new SqlConnection(cs.DBConn); con.Open(); string cb = "insert into subjectinfo(subjectcode,subjectname,coursename,branch,semester) VALUES (@d1,@d2,@d4,@d5,@d6)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "SubjectCode")); cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.VarChar, 250, "subjectname")); cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 20, "coursename")); cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 50, "branchname")); cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 10, "semester")); cmd.Parameters["@d1"].Value = SubjectCode.Text.Trim(); cmd.Parameters["@d2"].Value = SubjectName.Text.Trim(); cmd.Parameters["@d4"].Value = cmbCourse.Text.Trim(); cmd.Parameters["@d5"].Value = cmbBranch.Text.Trim(); cmd.Parameters["@d6"].Value = Semester.Text.Trim(); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); btnSave.Enabled = false; Autocomplete(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { if (SubjectCode.Text == "") { MessageBox.Show("Please enter subject code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectCode.Focus(); return; } if (SubjectName.Text == "") { MessageBox.Show("Please enter subject name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectName.Focus(); return; } if (cmbClass.Text == "") { MessageBox.Show("Please select course name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbClass.Focus(); return; } try { con = new SqlConnection(cs.DBcon); con.Open(); string ct = "select subjectcode from subject where subjectcode=@find"; cmd = new SqlCommand(ct); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "subjectcode")); cmd.Parameters["@find"].Value = SubjectCode.Text; rdr = cmd.ExecuteReader(); if (rdr.Read()) { MessageBox.Show("Subject Code Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SubjectCode.Text = ""; SubjectCode.Focus(); if ((rdr != null)) { rdr.Close(); } return; } con = new SqlConnection(cs.DBcon); con.Open(); string cb = "insert into subject(subjectcode,subjectname,classname) VALUES (@d1,@d2,@d4)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "SubjectCode")); cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.VarChar, 250, "subjectname")); cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 20, "classname")); cmd.Parameters["@d1"].Value = SubjectCode.Text.Trim(); cmd.Parameters["@d2"].Value = SubjectName.Text.Trim(); cmd.Parameters["@d4"].Value = cmbClass.Text; cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); st1 = lblUser.Text; st2 = "Added New subject whose subjectCode is'" + SubjectCode.Text + "'"; cf.LogFunc(st1, System.DateTime.Now, st2); btnSave.Enabled = false; Autocomplete(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }