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