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 getAdmissionById_Result GetAdminssionById(int?id) { try { getAdmissionById_Result objAdminssion = new getAdmissionById_Result(); using (aspccEntities db = new aspccEntities()) { objAdminssion = db.getAdmissionById(id).FirstOrDefault(); return(objAdminssion); } } catch (Exception ex) { com.Loginsert("admin/AdmissionAddEdit", "GetAdminssionById", ex.StackTrace, ex.Message); return(null); } }
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); } }