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