private void btn_ok_Click(object sender, EventArgs e)
{
Frm_Home.txtvalidate_Code(txtbx_coursecode, err_crs_code, label_status);
Frm_Home.txtvalidate_Name(txtbx_coursename, err_crs_name, label_status);
if ((Frm_Home.var == 0) && (Frm_Home.var1 == 0))
{
SqlConnection con = new SqlConnection(connectionString);
try
{
SqlCommand cmd = new SqlCommand("PrcCourseInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Course_Code", txtbx_coursecode.Text);
cmd.Parameters.AddWithValue("@Course_Name", txtbx_coursename.Text);
cmd.Parameters.AddWithValue("@Course_Descript", txtbx_coursedescrp.Text);
cmd.Parameters.AddWithValue("@Course_Date", dateTimePicker1.Value.Date);
cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);
cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@ERROR"].Value;
label_status.Text = message;
MessageBox.Show("Operation Successful.");
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong please try again !! \n\n" + ex);
}
finally
{
con.Close();
ClearTextBoxes();
}
}
}
public void btn_Update_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MessageBox.Show("Updating will affect to all the existing related data. \n Are you sure, Do you wan't to Update? ", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
Frm_Home.txtvalidate_Code(txtbx_coursecode, err_crs_code, label_status);
Frm_Home.txtvalidate_Name(txtbx_coursename, err_crs_name, label_status);
if ((Frm_Home.var == 0) && (Frm_Home.var1 == 0))
{
SqlConnection con = new SqlConnection(connectionString);
try
{
SqlCommand cmd = new SqlCommand("Prc_CourseUpdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Course_Id", Frm_CourseView.crs_id);
cmd.Parameters.AddWithValue("@Course_Code", txtbx_coursecode.Text);
cmd.Parameters.AddWithValue("@Course_Name", txtbx_coursename.Text);
cmd.Parameters.AddWithValue("@Course_Descript", txtbx_coursedescrp.Text);
cmd.Parameters.AddWithValue("@Course_Date", dateTimePicker1.Value.Date);
con.Open();
cmd.ExecuteNonQuery();
label_status.Text = "Course Updated Successfully.";
MessageBox.Show("Operation Successful.");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong please try again !! \n\n" + ex);
}
finally
{
con.Close();
ClearTextBoxes();
btn_Update.Visible = false;
}
}
}
}
// Method to insert and update subject //
private void InsertUpdateSubject(string prc, int temp)
{
int sum = 0;
Frm_Home.txtvalidate_Code(txtbx_SubCode, err_SubCode, label_status);
Frm_Home.txtvalidate_Name(txtbx_SubName, err_SubName, label_status);
Txtvalidate_ThMaxMarks(txtbx_sub_thMax, err_SubThMax, label_status);
Txtvalidate_ThMinMarks(txtbx_sub_thMin, err_SubThMin, label_status);
Txtvalidate_IAMaxMarks(txtbx_sub_IAMax, err_IAMax, label_status);
Txtvalidate_IAMinMarks(txtbx_sub_IAMin, err_IAMin, label_status);
cmbcheck(cmb_coursename, err_SubCrs, label_status);
if ((Frm_Home.var == 0) && (Frm_Home.var1 == 0) && (flag2 == 0) && (flag3 == 0) && (flag == 0) && (flag1 == 0) && (my.Contains(0)))
{
SqlConnection con = new SqlConnection(connectionString);
try
{
SqlCommand cmd = new SqlCommand(prc, con);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@CrsId", cmb_coursename.SelectedValue);
if (temp == 1)
{
cmd.Parameters.AddWithValue("@Sub_Id", Frm_SubView.id);
}
cmd.Parameters.AddWithValue("@Sub_Code", txtbx_SubCode.Text);
cmd.Parameters.AddWithValue("@Sub_Name", txtbx_SubName.Text);
cmd.Parameters.AddWithValue("@Sub_Descript", txtbx_SubDesc.Text);
cmd.Parameters.AddWithValue("@Sub_Category", cmb_Category.Text);
cmd.Parameters.AddWithValue("@Sub_th_Max", txtbx_sub_thMax.Text);
cmd.Parameters.AddWithValue("@Sub_th_Min", txtbx_sub_thMin.Text);
cmd.Parameters.AddWithValue("@Sub_IA_Max", txtbx_sub_IAMax.Text);
cmd.Parameters.AddWithValue("@Sub_IA_Min", txtbx_sub_IAMin.Text);
if ((txtbx_sub_IAMax.Enabled == false) && (txtbx_sub_IAMin.Enabled == false))
{
sum = (0) + (Convert.ToInt32(txtbx_sub_thMax.Text));
}
else
{
sum = (Convert.ToInt32(txtbx_sub_IAMax.Text)) + (Convert.ToInt32(txtbx_sub_thMax.Text));
}
cmd.Parameters.AddWithValue("@Sub_Sum_th_IA", sum.ToString());
cmd.Parameters.AddWithValue("@Sub_Ins_Date", dateTimePicker1.Value.Date);
cmd.Parameters.AddWithValue("@Course_Id", cmb_coursename.SelectedValue);
cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);
cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@ERROR"].Value;
label_status.Text = message;
// MessageBox.Show(" Operation Successful.");
}
catch (Exception ex)
{
MessageBox.Show("\t Something went wrong please try again !! \n\n" + ex);
}
finally
{
con.Close();
ClearTextBoxes();
cmb_Category.Text = "";
}
}
my.Clear();
}
