public void bindRdlc(int?Admissionid)
{
try
{
getAdmissionById_Result objadm = new getAdmissionById_Result();
List <getAdmissionById_Result> ListAdmistion = new List <getAdmissionById_Result>();
objadm = objAdmOp.GetAdminssionById(Admissionid);
h3StudentName.InnerText = objadm.fname.ToUpper() + " " + objadm.Lname.ToUpper();
ListAdmistion.Add(objadm);
DataTable DT = Comman.CommanUtils.ToDataTable(ListAdmistion.ToList());
//rptAdmissionForm.SizeToReportContent = true;
//rptAdmissionForm.LocalReport.ReportPath = Server.MapPath("~/admin/Reports/rdlc/AdmissioForm.rdlc");
//rptAdmissionForm.LocalReport.DataSources.Clear();
//ReportDataSource _rsource = new ReportDataSource("AdmissionFormData", DT);
//rptAdmissionForm.LocalReport.DataSources.Add(_rsource);
//rptAdmissionForm.LocalReport.Refresh();
DataTable dt = DT;
ReportViewer1.SizeToReportContent = true;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/admin/Reports/rdlc/AdmissionForm.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource _rsource = new ReportDataSource("DataSet1", dt);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{
}
}
public void bindReciptDetails()
{
try
{
if (Request.QueryString["id"] != null && Request.QueryString["InstallmentNo"] != null)
{
Admissionid = Convert.ToInt32(Request.QueryString["id"].ToString());
hdnAdmissionid.Value = Convert.ToString(Admissionid);
int InstallmentNo = Convert.ToInt32(Request.QueryString["InstallmentNo"].ToString());
getAdmissionById_Result objadm = new getAdmissionById_Result();
List <getAdmissionById_Result> ListAdmistion = new List <getAdmissionById_Result>();
objadm = objAdmOp.GetAdminssionById(Admissionid);
h3StudentName.InnerText = objadm.fname.ToUpper() + " " + objadm.Lname.ToUpper();
ListAdmistion.Add(objadm);
DataTable DT = Comman.CommanUtils.ToDataTable(ListAdmistion.ToList());
DataTable dt = DT;
string ReceiptNo = "1";
string InstallmentDate = string.Empty;
string InstallmentRsWord = string.Empty;
string InstallmentRs = string.Empty;
if (InstallmentNo == 1)
{
InstallmentDate = objadm.Installment1Date_S;
InstallmentRsWord = objadm.Installment1RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment1Rs);
}
else if (InstallmentNo == 2)
{
InstallmentDate = objadm.Installment2Date_S;
InstallmentRsWord = objadm.Installment2RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment2Rs);
}
else if (InstallmentNo == 3)
{
InstallmentDate = objadm.Installment3Date_S;
InstallmentRsWord = objadm.Installment3RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment3Rs);
}
else if (InstallmentNo == 4)
{
InstallmentDate = objadm.Installment4Date_S;
InstallmentRsWord = objadm.Installmen4RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment4Rs);
}
else if (InstallmentNo == 5)
{
InstallmentDate = objadm.Installment5Date_S;
InstallmentRsWord = objadm.Installment5RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment5Rs);
}
else if (InstallmentNo == 6)
{
InstallmentDate = objadm.Installment6Date_S;
InstallmentRsWord = objadm.Installment6RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment6Rs);
}
else if (InstallmentNo == 7)
{
InstallmentDate = objadm.Installment7Date_S;
InstallmentRsWord = objadm.Installment7RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment7Rs);
}
else if (InstallmentNo == 8)
{
InstallmentDate = objadm.Installment7Date_S;
InstallmentRsWord = objadm.Installment7RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment7Rs);
}
else if (InstallmentNo == 9)
{
InstallmentDate = objadm.Installment8Date_S;
InstallmentRsWord = objadm.Installment8RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment8Rs);
}
else if (InstallmentNo == 10)
{
InstallmentDate = objadm.Installment10Date_S;
InstallmentRsWord = objadm.Installment10RsInWord;
InstallmentRs = Convert.ToString(objadm.Installment10Rs);
}
ReportParameter rp1 = new ReportParameter("ReceiptNo", ReceiptNo.ToString());
ReportParameter rp2 = new ReportParameter("InstallmentDate", InstallmentDate.ToString());
ReportParameter rp3 = new ReportParameter("InstallmentRsWord", InstallmentRsWord.ToString());
ReportParameter rp4 = new ReportParameter("InstallmentRs", InstallmentRs.ToString());
rptReciptPrint.SizeToReportContent = true;
rptReciptPrint.ShowPrintButton = true;
rptReciptPrint.LocalReport.ReportPath = Server.MapPath("~/admin/Reports/rdlc/RecepitPrint.rdlc");
rptReciptPrint.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4 });
rptReciptPrint.LocalReport.DataSources.Clear();
ReportDataSource _rsource = new ReportDataSource("Receipt", dt);
rptReciptPrint.LocalReport.DataSources.Add(_rsource);
rptReciptPrint.LocalReport.Refresh();
}
}
catch (Exception ex)
{
throw;
}
}
public void bindAdmissionDetails(int?Admissionid)
{
try
{
getAdmissionById_Result objadm = new getAdmissionById_Result();
objadm = objAdmOp.GetAdminssionById(Admissionid);
txtAdmissionNo.Text = objadm.AdmissionNo;
txtAdmissionDate.Text = objadm.AdmissionDate_S;
txtRegNo.Text = objadm.RegNo;
txtFirstName.Text = objadm.fname;
txtLastName.Text = objadm.Lname;
txtMiddelName.Text = objadm.Mname;
txtAdress.InnerText = objadm.Address;
txtMobileF.Text = objadm.MobileF;
txtMobileH.Text = objadm.MobileH;
txtMobileP.Text = objadm.MobileP;
ddlArea.SelectedValue = Convert.ToString(objadm.AreId);
txtQualification.Text = objadm.QualificationId;
ddlStream.SelectedValue = Convert.ToString(objadm.StreamId);
ddloccupation.SelectedValue = Convert.ToString(objadm.OccupationId);
string[] courseId = Convert.ToString(objadm.CourseId).Split(',');
foreach (ListItem item in ddlCourse.Items)
{
foreach (var id in courseId)
{
if (item.Value == id)
{
item.Selected = true;
}
}
}
txtSchoolName.Text = objadm.SchoolName;
txtBirthDate.Text = objadm.BirthDate_S;
txtAge.Text = Convert.ToString(objadm.Age);
txtFromTime.Text = objadm.PreferTimeFrom;
txtToTime.Text = objadm.PreferTimeTO;
txtRemark.InnerText = objadm.Remark;
txtTotalFees.Text = Convert.ToString(objadm.TotalFees);
txtDisCount.Text = Convert.ToString(objadm.DisCount);
txtNetFees.Text = Convert.ToString(objadm.NetFees);
txtNoofInstallment.Text = Convert.ToString(objadm.NoOfInstallment);
int NoofInstallment = Convert.ToInt32(txtNoofInstallment.Text);
bindDdlInstallment(NoofInstallment);
txtNoofInstallment_TextChanged(NoofInstallment);
List <string> InstallmentDatetotal = Request.Form.AllKeys.Where(key => key.Contains("txtdateInstallment")).ToList();
List <string> InstallmentRstotal = Request.Form.AllKeys.Where(key => key.Contains("txtrdInstallment")).ToList();
foreach (TextBox textBox in pnlInstallmentBoxes.Controls.OfType <TextBox>())
{
if (textBox.ID == "txtdateInstallment1")
{
textBox.Text = Convert.ToString(objadm.Installment1Date_S);
}
if (textBox.ID == "txtrdInstallment1")
{
textBox.Text = Convert.ToString(objadm.Installment1Rs);
}
if (textBox.ID == "txtdateInstallment2")
{
textBox.Text = Convert.ToString(objadm.Installment2Date_S);
}
if (textBox.ID == "txtrdInstallment2")
{
textBox.Text = Convert.ToString(objadm.Installment2Rs);
}
if (textBox.ID == "txtdateInstallment3")
{
textBox.Text = Convert.ToString(objadm.Installment3Date_S);
}
if (textBox.ID == "txtrdInstallment3")
{
textBox.Text = Convert.ToString(objadm.Installment3Rs);
}
if (textBox.ID == "txtdateInstallment4")
{
textBox.Text = Convert.ToString(objadm.Installment4Date_S);
}
if (textBox.ID == "txtrdInstallment4")
{
textBox.Text = Convert.ToString(objadm.Installment4Rs);
}
if (textBox.ID == "txtdateInstallment5")
{
textBox.Text = Convert.ToString(objadm.Installment5Date_S);
}
if (textBox.ID == "txtrdInstallment5")
{
textBox.Text = Convert.ToString(objadm.Installment5Rs);
}
if (textBox.ID == "txtdateInstallment6")
{
textBox.Text = Convert.ToString(objadm.Installment6Date_S);
}
if (textBox.ID == "txtrdInstallment6")
{
textBox.Text = Convert.ToString(objadm.Installment6Rs);
}
if (textBox.ID == "txtdateInstallment7")
{
textBox.Text = Convert.ToString(objadm.Installment7Date_S);
}
if (textBox.ID == "txtrdInstallment7")
{
textBox.Text = Convert.ToString(objadm.Installment7Rs);
}
if (textBox.ID == "txtdateInstallment8")
{
textBox.Text = Convert.ToString(objadm.Installment8Date_S);
}
if (textBox.ID == "txtrdInstallment8")
{
textBox.Text = Convert.ToString(objadm.Installment8Rs);
}
if (textBox.ID == "txtdateInstallment9")
{
textBox.Text = Convert.ToString(objadm.Installment9Date_S);
}
if (textBox.ID == "txtrdInstallment9")
{
textBox.Text = Convert.ToString(objadm.Installment9Rs);
}
if (textBox.ID == "txtdateInstallment10")
{
textBox.Text = Convert.ToString(objadm.Installment10Date_S);
}
if (textBox.ID == "txtrdInstallment10")
{
textBox.Text = Convert.ToString(objadm.Installment10Rs);
}
}
}
catch (Exception ex)
{
com.Loginsert(HttpContext.Current.Request.Url.AbsolutePath, "bindAdmissionDetails", ex.StackTrace, ex.Message);
}
}
