private void btnCautionCreate_Click(object sender, EventArgs e) { CautionMoney cCaution = new CautionMoney(); cCaution.Description = "Memo"; sourceCautions.Add(cCaution); sourceCautions.Refresh(); }
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); } }