private void Frm_Subject_Load(object sender, EventArgs e) { if (Frm_SubView.flag == 1) { SqlConnection con = new SqlConnection(connectionString); try { SqlCommand cmd = new SqlCommand("Prc_ComboSubView", con); cmd.Parameters.AddWithValue("@Course_id", Frm_SubView.course_Id); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataAdapter adt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adt.Fill(dt); cmb_coursename.DataSource = dt; cmb_coursename.DisplayMember = "value"; cmb_coursename.ValueMember = "keys"; } catch (Exception ex) { MessageBox.Show("Something went wrong please try again !! \n\n" + ex); } finally { con.Close(); } //populates textbox with values// txtbx_SubCode.Text = Frm_SubView.code; txtbx_SubName.Text = Frm_SubView.name; txtbx_SubDesc.Text = Frm_SubView.descript; cmb_Category.Text = Frm_SubView.category; txtbx_sub_thMax.Text = Frm_SubView.thmax; txtbx_sub_thMin.Text = Frm_SubView.thmin; txtbx_sub_IAMax.Text = Frm_SubView.iamax; txtbx_sub_IAMin.Text = Frm_SubView.iamin; txtbx_SubCode.Enabled = false; txtbx_SubName.Enabled = false; txtbx_SubDesc.Enabled = false; cmb_coursename.Enabled = false; cmb_Category.Enabled = false; txtbx_sub_thMax.Enabled = false; txtbx_sub_thMin.Enabled = false; txtbx_sub_IAMax.Enabled = false; txtbx_sub_IAMin.Enabled = false; btn_ok1.Visible = false; btn_crsEdit.Visible = false; btn_update.Visible = false; btn_cancle1.Visible = false; btn_edit.Visible = true; Frm_SubView.flag = 0; } else { Frm_Home.Load_SubjectCombo(cmb_coursename); } }
private void Frm_CrsMgmt_Load(object sender, EventArgs e) { Frm_Home.Load_SubjectCombo(cmb_coursename); Frm_Home.Load_SubjectCombo(cmb_CrsMapInsert); flag = 1; DisplayChkLst(); }
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(); } } }
private void Frm_MarksCardView_Load(object sender, EventArgs e) { Frm_Home.Load_SubjectCombo(cmb_course_sort); cmb_course_sort.Text = ""; pictureBox1.Visible = false; btn_Print.Visible = false; }
private void btn_login_Click(object sender, EventArgs e) { if ((txtbx_userid.Text == "admin") && (txtbx_pswd.Text == "admin")) { this.Hide(); Frm_Home objhm = new Frm_Home(); objhm.Show(); } else { MessageBox.Show("Invalid User-Id & Password !!"); } }
private void Frm_Stu_Application_Load(object sender, EventArgs e) { Frm_Home.Load_SubjectCombo(cmb_coursename); LoadLangCombo(); flag = 1; if (Frm_StuView.flag == 1) { // ----------------- Populate feilds all feilds ----------------- // txtbx_regno.Text = Frm_StuView.RegNo; txtbx_name.Text = Frm_StuView.StuName; dateTimePicker1.Text = Frm_StuView.DOB; txtbx_aadhar.Text = Frm_StuView.AadhaarNo; txtbx_StuPhno.Text = Frm_StuView.StuPhNo; txtbx_StuEmail.Text = Frm_StuView.StuEmail; txtbx_fname.Text = Frm_StuView.FName; txtbx_fphno.Text = Frm_StuView.FPhNo; txtbx_FEmail.Text = Frm_StuView.FEmail; cmb_Gender.Text = Frm_StuView.Gender; cmb_coursename.Text = Frm_StuView.CourseName; cmb_lang.Text = Frm_StuView.ILang; // Disable all feilds // txtbx_regno.Enabled = false; txtbx_name.Enabled = false; dateTimePicker1.Enabled = false; cmb_Gender.Enabled = false; txtbx_aadhar.Enabled = false; txtbx_StuPhno.Enabled = false; txtbx_StuEmail.Enabled = false; txtbx_fname.Enabled = false; txtbx_fphno.Enabled = false; txtbx_FEmail.Enabled = false; cmb_coursename.Enabled = false; cmb_lang.Enabled = false; btn_Cancle.Enabled = false; btn_save.Enabled = false; btn_Edit.Visible = true; btn_Update.Visible = true; btn_Update.Enabled = false; Frm_StuView.flag = 0; } }
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; } } } }
private void Frm_SubView_Load(object sender, EventArgs e) { Frm_Home.Load_SubjectCombo(cmb_coursename); }
private void btn_crsEdit_Click(object sender, EventArgs e) { Frm_Home.Load_SubjectCombo(cmb_coursename); }
// 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(); }