private void cmbBranch_SelectedIndexChanged(object sender, EventArgs e)
{
cmbBranch.Text = cmbBranch.Text.Trim();
Semester.Items.Clear();
Semester.Text = "";
Semester.Enabled = true;
Semester.Focus();
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select distinct RTRIM(SemesterName) from Semester where course = '" + cmbCourse.Text + "' order by 1 ";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Semester.Items.Add(rdr[0]);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
if (Course.Text == "")
{
MessageBox.Show("Please select course", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Course.Focus();
return;
}
if (Branch.Text == "")
{
MessageBox.Show("Please select branch", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Branch.Focus();
return;
}
if (Session.Text == "")
{
MessageBox.Show("Please select session", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Session.Focus();
return;
}
if (Semester.Text == "")
{
MessageBox.Show("Please select semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Semester.Focus();
return;
}
if (Section.Text == "")
{
MessageBox.Show("Please select section", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Section.Focus();
return;
}
con = new SqlConnection("Data Source=GHAFFARI\\ALIGHAFFARI;Initial Catalog=CMS;Integrated Security=True;");
con.Open();
cmd = new SqlCommand("select RTrim(ScholarNo)[Scholar No.], RTRIM(Student_Name)[Student Name], RTRIM(Admission_No)[Admission No.], RTRIM(DateOfAdmission)[Date Of Admission], RTRIM(Roll_No)[Roll No.], RTRIM(Fathers_Name)[Father's Name],RTRIM(Mother_name)[Mother's Name], RTRIM(Gender)[Gender], RTRIM(DOB)[DOB],RTRIM(Category)[Category],RTRIM(Religion)[Religion],RTRIM(Session)[Session], RTRIM(Address)[Address], RTRIM(Contact_No)[Contact No.], RTRIM(Email)[Email], RTRIM(Course)[Course], RTRIM(Branch)[Branch],RTRIM(Semester)[Semester],RTRIM(Section)[Section], RTRIM(Submitted_Documents)[Documents Submitted], RTRIM(Nationality)[Nationality], RTRIM(High_School_name)[High School], RTRIM(HS_Year_of_passing)[Year Of Passing], RTRIM(HS_Percentage)[Percentage], RTRIM(HS_Board)[Board], RTRIM(Higher_secondary_Name)[Higher Secondary], RTRIM(H_year_of_passing)[HS Year Of Passing], RTRIM(H_percentage)[HS Percentage], RTRIM(H_board)[HS Board] from student where Course= '" + Course.Text + "'and branch='" + Branch.Text + "'and Session='" + Session.Text + "'", con);
SqlDataAdapter myDA = new SqlDataAdapter(cmd);
DataSet myDataSet = new DataSet();
myDA.Fill(myDataSet, "Student");
dataGridView1.DataSource = myDataSet.Tables["Student"].DefaultView;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
if (Course.Text == "")
{
MessageBox.Show("Please select course", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Course.Focus();
return;
}
if (Branch.Text == "")
{
MessageBox.Show("Please select branch", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Branch.Focus();
return;
}
if (Semester.Text == "")
{
MessageBox.Show("Please select semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Semester.Focus();
return;
}
var _with1 = listView1;
_with1.Clear();
_with1.Columns.Add("Subject Code", 100, HorizontalAlignment.Left);
_with1.Columns.Add("Subject Name", 500, HorizontalAlignment.Center);
con = new SqlConnection(cs.DBConn);
con.Open();
cmd = new SqlCommand("select RTrim(SubjectCode)[Subject Code], RTRIM(SubjectName)[Subject Name] from subjectinfo where CourseName= '" + Course.Text + "'and branch='" + Branch.Text + "'and Semester='" + Semester.Text + "'", con);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var item = new ListViewItem();
item.Text = rdr[0].ToString();
item.SubItems.Add(rdr[1].ToString());
listView1.Items.Add(item);
}
con.Close();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Course.Text == "")
{
MessageBox.Show("Please select course", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Course.Focus();
return;
}
if (Branch.Text == "")
{
MessageBox.Show("Please select branch", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Branch.Focus();
return;
}
if (Semester.Text == "")
{
MessageBox.Show("Please select semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Semester.Focus();
return;
}
if (TutionFees.Text == "")
{
MessageBox.Show("Please enter tution fees", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TutionFees.Focus();
return;
}
if (UDFees.Text == "")
{
MessageBox.Show("Please enter university development fees", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
UDFees.Focus();
return;
}
if (LibraryFees.Text == "")
{
MessageBox.Show("Please enter library fees", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
LibraryFees.Focus();
return;
}
if (USFees.Text == "")
{
MessageBox.Show("Please enter university student welfare fees", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
USFees.Focus();
return;
}
if (OtherFees.Text == "")
{
MessageBox.Show("Please enter other fees", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
OtherFees.Focus();
return;
}
if (Semester.Text == "1st")
{
if (CautionMoney.Text == "")
{
MessageBox.Show("Please enter caution money", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CautionMoney.Focus();
return;
}
}
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select Semester,Course,Branch from FeesDetails where Semester= '" + Semester.Text + "' and Course = '" + Course.Text + "' and branch= '" + Branch.Text + "'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Record Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Reset();
if ((rdr != null))
{
rdr.Close();
}
return;
}
if (Semester.Text == "1st")
{
TotalFees.Text = (int.Parse(TutionFees.Text) + int.Parse(LibraryFees.Text) + int.Parse(UDFees.Text) + int.Parse(USFees.Text) + int.Parse(OtherFees.Text) + int.Parse(CautionMoney.Text)).ToString();
}
else
{
TotalFees.Text = (int.Parse(TutionFees.Text) + int.Parse(LibraryFees.Text) + int.Parse(UDFees.Text) + int.Parse(USFees.Text) + int.Parse(OtherFees.Text)).ToString();
}
auto();
con = new SqlConnection(cs.DBConn);
con.Open();
string ct1 = "select feeid from feesdetails where feeid=@find";
cmd = new SqlCommand(ct1);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "feeid"));
cmd.Parameters["@find"].Value = FeeID.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Fee ID Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
FeeID.Text = "";
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into feesdetails(FeeID,Course,Branch,Semester,TutionFees,LibraryFees,UniversityDevelopmentFees,UniversityStudentWelfareFees,CautionMoney,OtherFees,TotalFees) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9,@d10,@d11)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "FeeId"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 20, "Course"));
cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.NChar, 30, "Branch"));
cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 10, "Semester"));
cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 10, "TutionFees"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 10, "LibraryFees"));
cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 10, "UniversityDevelopmentFees"));
cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 15, "UniversityStudentWelfareFees"));
cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 10, "CautionMoney"));
cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.NChar, 10, "OtherFees"));
cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.NChar, 10, "TotalFees"));
cmd.Parameters["@d1"].Value = FeeID.Text.Trim();
cmd.Parameters["@d2"].Value = Course.Text.Trim();
cmd.Parameters["@d3"].Value = Branch.Text.Trim();
cmd.Parameters["@d4"].Value = Semester.Text.Trim();
cmd.Parameters["@d5"].Value = (TutionFees.Text);
cmd.Parameters["@d6"].Value = (LibraryFees.Text);
cmd.Parameters["@d7"].Value = (UDFees.Text);
cmd.Parameters["@d8"].Value = (USFees.Text);
if (Semester.Text == "1st")
{
cmd.Parameters["@d9"].Value = (CautionMoney.Text);
}
else
{
cmd.Parameters["@d9"].Value = 0;
}
cmd.Parameters["@d10"].Value = (OtherFees.Text);
cmd.Parameters["@d11"].Value = (TotalFees.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Fees Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
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 (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);
}
}