private void FeeDeposit_Load(object sender, EventArgs e)
{
//txtAdmissionNo.Focus();
lblSession.Text = CommonFunctions.GetCurrentSession;
LoadMonths();
if (AdmissionNo > 0)
{
txtAdmissionNo.Text = AdmissionNo.ToString();
GetDetails();
//txtMisc.Focus();
}
LoadBanksForCheque();
}
private void button1_Click(object sender, EventArgs e)
{
if (AdmissionNo.Text == "")
{
MessageBox.Show("Please select Admission no.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AdmissionNo.Focus();
return;
}
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
RptClassFeePaymentsReport rpt = new RptClassFeePaymentsReport();
//The report you created.
SqlConnection myConnection = default(SqlConnection);
SqlCommand MyCommand = new SqlCommand();
SqlDataAdapter myDA = new SqlDataAdapter();
ERPS_DBDataSet myDS = new ERPS_DBDataSet();
//The DataSet you created.
myConnection = new SqlConnection(cs.DBcon);
MyCommand.Connection = myConnection;
MyCommand.CommandText = "select * from CourseFeePayment,Student where CourseFeePayment.AdmissionNo=Student.AdmissionNo and CourseFeePayment.AdmissionNo= '" + AdmissionNo.Text + "'order by PaymentDate";
MyCommand.CommandType = CommandType.Text;
myDA.SelectCommand = MyCommand;
myDA.Fill(myDS, "CourseFeePayment");
myDA.Fill(myDS, "Student");
rpt.SetDataSource(myDS);
crystalReportViewer2.ReportSource = rpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Reset()
{
FeePaymentID.Text = "";
AdmissionNo.Text = "";
StudentName.Text = "";
txtclass.Text = "";
txtSection.Text = "";
txtBusCharges.Text = "";
txtSourceLocation.Text = "";
txtModeOfPayment.Text = "";
PaymentDate.Text = DateTime.Today.ToString();
txtPaymentModeDetails.Text = "";
txtFine.Text = "";
txtTotalPaid.Text = "";
txtDueFees.Text = "";
btnSave.Enabled = true;
Delete.Enabled = false;
Update_record.Enabled = false;
Print.Enabled = false;
AdmissionNo.Focus();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (AdmissionNo.Text == "")
{
MessageBox.Show("Please select Admission No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AdmissionNo.Focus();
return;
}
if (txtModeOfPayment.Text == "")
{
MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtModeOfPayment.Focus();
return;
}
if (txtTotalPaid.Text == "")
{
MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTotalPaid.Focus();
return;
}
con = new SqlConnection(cs.DBcon);
con.Open();
string ct = "select AdmissionNo from BusFeePayment where AdmissionNo= '" + AdmissionNo.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 (AdmissionNo.Text == "")
{
MessageBox.Show("Please select Admission No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AdmissionNo.Focus();
return;
}
if (txtModeOfPayment.Text == "")
{
MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtModeOfPayment.Focus();
return;
}
if (txtTotalPaid.Text == "")
{
MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTotalPaid.Focus();
return;
}
auto();
con = new SqlConnection(cs.DBcon);
con.Open();
string cb = "insert into BusFeePayment(FeePaymentID,AdmissionNo,BusCharges,DateOfPayment,ModeOfPayment,PaymentModeDetails,TotalPaid,Fine,DueFees) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.AddWithValue("@d1", FeePaymentID.Text.Trim());
cmd.Parameters.AddWithValue("@d2", AdmissionNo.Text.Trim());
cmd.Parameters.AddWithValue("@d3", Convert.ToInt32(txtBusCharges.Text));
cmd.Parameters.AddWithValue("@d4", (PaymentDate.Text));
cmd.Parameters.AddWithValue("@d5", (txtModeOfPayment.Text));
cmd.Parameters.AddWithValue("@d6", txtPaymentModeDetails.Text);
cmd.Parameters.AddWithValue("@d7", Convert.ToInt32(txtTotalPaid.Text));
if (txtFine.Text == "")
{
cmd.Parameters.AddWithValue("@d8", 0);
}
else
{
cmd.Parameters.AddWithValue("@d8", Convert.ToInt32(txtFine.Text));
}
cmd.Parameters.AddWithValue("@d9", Convert.ToInt32(txtDueFees.Text));
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
st1 = lblUser.Text;
st2 = "Bus Fee Paid '" + AdmissionNo.Text + "' having StudentName='" + StudentName.Text + "'";
cf.LogFunc(st1, System.DateTime.Now, st2);
btnSave.Enabled = false;
Print.Enabled = true;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (AdmissionNo.Text == "")
{
MessageBox.Show("Please select AdmissionNo.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AdmissionNo.Focus();
return;
}
if (cmbHostelName.Text == "")
{
MessageBox.Show("Please select hostel name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbHostelName.Focus();
return;
}
con = new SqlConnection(cs.DBcon);
con.Open();
string ct = "select AdmissionNo from Hosteler where AdmissionNo='" + AdmissionNo.Text + "'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Record Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbHostelName.Text = "";
cmbsection.Text = "";
txtClass.Text = "";
StudentName.Text = "";
cmbHostelName.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBcon);
con.Open();
string cb = "insert into Hosteler(AdmissionNo,HostelName,joiningDate) VALUES (@d1,@d2,@d3)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.AddWithValue("@d1", AdmissionNo.Text);
cmd.Parameters.AddWithValue("@d2", cmbHostelName.Text);
cmd.Parameters.AddWithValue("@d3", dtpJoiningDate.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
st1 = lblUser.Text;
st2 = "Added the New Hosteler '" + StudentName.Text + "'";
cf.LogFunc(st1, System.DateTime.Now, st2);
btnSave.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
