public static DataTable InsertUpdateFeeVouchers(BusinessEntities.FeeVouchers objFeeVouchers)
{
try
{
DataKernal.FeeVouchers objDFeeVouchers = new DataKernal.FeeVouchers();
return(objDFeeVouchers.InsertUpdateFeeVouchers(objFeeVouchers.VoucherID, objFeeVouchers.StudentID, objFeeVouchers.DateVoucherIssue, objFeeVouchers.DateVoucherSubmit, objFeeVouchers.CollectedFee, objFeeVouchers.UserID, objFeeVouchers.IsEnabled, objFeeVouchers.Remarks).Tables[0]);
}
catch (System.Exception ex)
{
return(null);
}
}
private void txtSubmit_Click(object sender, EventArgs e)
{
if (lblChallanID.Text != "")
{
DataTable dtChallan = LogicKernal.FeeVouchers.GetFeeVouchersByID(Convert.ToInt16(lblChallanID.Text));
BusinessEntities.FeeVouchers ObjVoucher = new BusinessEntities.FeeVouchers();
ObjVoucher.VoucherID = Convert.ToInt16(lblChallanID.Text);
ObjVoucher.StudentID = Convert.ToInt16(dtChallan.Rows[0]["StudentID"]);
ObjVoucher.DateVoucherIssue = Convert.ToDateTime(dtChallan.Rows[0]["DateVoucherIssue"]);
ObjVoucher.CollectedFee = dtChallan.Rows[0]["CollectedFee"].ToString();
ObjVoucher.Remarks = txtRemarks.Text;
ObjVoucher.IsEnabled = false;
ObjVoucher.UserID = LogicKernal.Users.LoginInfo.UserID;
ObjVoucher.DateVoucherSubmit = txtSubmittedDate.Text;
if (LogicKernal.FeeVouchers.InsertUpdateFeeVouchers(ObjVoucher).Rows.Count > 0)
{
MessageBox.Show("Voucher Submitted Successfuly...");
UnpaidVouchers();
lblChallanID.Text = "";
txtAddress.Text = "";
txtCNIC.Text = "";
txtContactNo.Text = "";
txtFatherName.Text = "";
txtRemarks.Text = "";
txtStudentName.Text = "";
txtSubmittedDate.Text = "";
}
else
{
MessageBox.Show("Error. Try Again....");
}
}
else
{
MessageBox.Show("Please Select a Voucher First.....!!");
}
}
private void pdPrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
BusinessEntities.FeeVouchers ObjFeeVoucher = new BusinessEntities.FeeVouchers();
ObjFeeVoucher.VoucherID = 0;
ObjFeeVoucher.StudentID = Convert.ToInt16(cmbStudents.SelectedValue);
ObjFeeVoucher.CollectedFee = txtFee.Text;
ObjFeeVoucher.DateVoucherIssue = DateTime.Now;
ObjFeeVoucher.DateVoucherSubmit = "";
ObjFeeVoucher.IsEnabled = true;
ObjFeeVoucher.Remarks = "";
ObjFeeVoucher.UserID = LogicKernal.Users.LoginInfo.UserID;
DataTable dtInserted = LogicKernal.FeeVouchers.InsertUpdateFeeVouchers(ObjFeeVoucher);
if (dtInserted.Rows.Count > 0)
{
e.Graphics.Clear(SystemColors.Control);
e.Graphics.RotateTransform(90);
e.Graphics.DrawString("Islamia University Bahawalpur", new Font("Arial", 15, FontStyle.Bold), SystemBrushes.ControlText, 20, -800);
e.Graphics.DrawString("Phone No. 03007027795", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 70, -765);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 10, -785);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 10, -780);
e.Graphics.DrawString("Challan No: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -700);
e.Graphics.DrawString(dtInserted.Rows[0]["Column1"].ToString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -700);
e.Graphics.DrawString("A/C " + "0641852583686", new Font("Arial", 8, FontStyle.Bold), SystemBrushes.ControlText, 120, -730);
e.Graphics.DrawString("Student Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -600);
e.Graphics.DrawString(cmbStudents.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -600);
e.Graphics.DrawString("Father Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -550);
e.Graphics.DrawString(txtFatherName.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -550);
e.Graphics.DrawString("CNIC/B-Form: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -500);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -500);
e.Graphics.DrawString("Address: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -450);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -450);
e.Graphics.DrawString("Admission Fee: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -300);
e.Graphics.DrawString("RS." + txtFee.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -300);
e.Graphics.DrawString("Date Issue: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 40, -250);
e.Graphics.DrawString(DateTime.Now.ToShortDateString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 140, -250);
e.Graphics.DrawString("Islamia University Bahawalpur", new Font("Arial", 15, FontStyle.Bold), SystemBrushes.ControlText, 360, -800);
e.Graphics.DrawString("Phone No. 03007027795", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 410, -770);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 360, -785);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 360, -780);
e.Graphics.DrawString("Challan No: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -700);
e.Graphics.DrawString(dtInserted.Rows[0]["Column1"].ToString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -700);
e.Graphics.DrawString("A/C " + "0641852583686", new Font("Arial", 8, FontStyle.Bold), SystemBrushes.ControlText, 460, -730);
e.Graphics.DrawString("Student Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -600);
e.Graphics.DrawString(cmbStudents.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -600);
e.Graphics.DrawString("Father Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -550);
e.Graphics.DrawString(txtFatherName.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -550);
e.Graphics.DrawString("CNIC/B-Form: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -500);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -500);
e.Graphics.DrawString("Address: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -450);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -450);
e.Graphics.DrawString("Admission Fee: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -300);
e.Graphics.DrawString("RS." + txtFee.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -300);
e.Graphics.DrawString("Date Issue: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 380, -250);
e.Graphics.DrawString(DateTime.Now.ToShortDateString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 480, -250);
e.Graphics.DrawString("Islamia University Bahawalpur", new Font("Arial", 15, FontStyle.Bold), SystemBrushes.ControlText, 710, -800);
e.Graphics.DrawString("Phone No. 03007027795", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 760, -770);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 710, -785);
e.Graphics.DrawString("--------------------------------------------------------------------", new Font("Arial", 10, FontStyle.Regular), SystemBrushes.ControlText, 710, -780);
e.Graphics.DrawString("Challan No: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -700);
e.Graphics.DrawString(dtInserted.Rows[0]["Column1"].ToString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -700);
e.Graphics.DrawString("A/C " + "0641852583686", new Font("Arial", 8, FontStyle.Bold), SystemBrushes.ControlText, 800, -730);
e.Graphics.DrawString("Student Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -600);
e.Graphics.DrawString(cmbStudents.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -600);
e.Graphics.DrawString("Father Name: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -550);
e.Graphics.DrawString(txtFatherName.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -550);
e.Graphics.DrawString("CNIC/B-Form: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -500);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -500);
e.Graphics.DrawString("Address: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -450);
e.Graphics.DrawString(txtCnic.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -450);
e.Graphics.DrawString("Admission Fee: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -300);
e.Graphics.DrawString("RS." + txtFee.Text, new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -300);
e.Graphics.DrawString("Date Issue: ", new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 720, -250);
e.Graphics.DrawString(DateTime.Now.ToShortDateString(), new Font("Arial", 8, FontStyle.Regular), SystemBrushes.ControlText, 820, -250);
}
else
{
MessageBox.Show("Try Again");
}
}
