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