private void RenderReport(HomeFixesProject homeFixesProject) { List<PersonsInProjects> allFamiliesinProj = new List<PersonsInProjects>(); ZakahEntities db = new ZakahEntities(); var query = from p in db.HomeFixesProjects.Where(x => (x.date >= dateFrom.Value) && (x.date <= dateTo.Value)) select p; List<HomeFixesProject> allprj = query.ToList<HomeFixesProject>(); foreach (HomeFixesProject item in allprj) { PersonsInProjects _personinproject = new PersonsInProjects(item.familyID); _personinproject.date = Convert.ToDateTime(item.date).ToString("M/d/yyyy"); _personinproject.Amount = item.amount ; _personinproject.Titleamount = "مبلغ الترميم"; _personinproject.AdditionalData+= "عدد الغرف :"+ item.RoomNumbers +"\n"; _personinproject.AdditionalData += " احتياجات الترميم :" + item.Tarmimdemands + "\n"; _personinproject.AdditionalData += " تكاليف الترميم :" + item.TarmimTakalef + "\n"; _personinproject.AdditionalData += " ملاحظات :" + item.Note + "\n"; // _personinproject.ProjectName = comboBox1.Text; allFamiliesinProj.Add(_personinproject); } this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet_PersoninFamily", allFamiliesinProj)); ReportParameter p1 = new ReportParameter("DateFrom", dateFrom.Value.ToString("mm/dd/yyyy")); ReportParameter p2 = new ReportParameter("DateTo", dateTo.Value.ToString("mm/dd/yyyy")); ReportParameter p3 = new ReportParameter("project", comboBox1.Text); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 }); reportViewer1.Visible = true; this.reportViewer1.RefreshReport(); }
private void RenderReport(moslemFamilyProject moslemFamilyProject) { List<PersonsInProjects> allFamiliesinProj=new List<PersonsInProjects>(); ZakahEntities db = new ZakahEntities(); var query = from p in db.moslemFamilyProjects.Where(x => (x.date >= dateFrom.Value) && (x.date <= dateTo.Value)) select p; List<moslemFamilyProject> allprj = query.ToList<moslemFamilyProject>(); foreach (moslemFamilyProject item in allprj) { PersonsInProjects _personinproject = new PersonsInProjects(item.familyID); _personinproject.date = Convert.ToDateTime(item.date).ToString("M/d/yyyy"); _personinproject.Amount = item.amount; _personinproject.Titleamount = "المبلغ"; // _personinproject.ProjectName = comboBox1.Text; allFamiliesinProj.Add(_personinproject); } this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet_PersoninFamily", allFamiliesinProj)); ReportParameter p1 = new ReportParameter("DateFrom", dateFrom.Value.ToString("mm/dd/yyyy")); ReportParameter p2 = new ReportParameter("DateTo", dateTo.Value.ToString("mm/dd/yyyy")); ReportParameter p3 = new ReportParameter("project", comboBox1.Text); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 }); reportViewer1.Visible = true; this.reportViewer1.RefreshReport(); }
private void RenderReport(SchoolBagsProject schoolBagsProject) { List<PersonsInProjects> allFamiliesinProj = new List<PersonsInProjects>(); ZakahEntities db = new ZakahEntities(); var query = from p in db.SchoolBagsProjects.Where(x => (x.date >= dateFrom.Value) && (x.date <= dateTo.Value)) select p; string MasrofSummary = string.Empty; long? sum = query.Sum(x => x.amount); MasrofSummary = "عدد الحقائب التي وزعت بين هذه التواريخ : " + sum.ToString(); List<SchoolBagsProject> allprj = query.ToList<SchoolBagsProject>(); foreach (SchoolBagsProject item in allprj) { PersonsInProjects _personinproject = new PersonsInProjects(item.familyID); _personinproject.date = Convert.ToDateTime(item.date).ToString("M/d/yyyy"); _personinproject.Amount = item.amount; _personinproject.Titleamount = "عدد الحقائب"; // _personinproject.ProjectName = comboBox1.Text; allFamiliesinProj.Add(_personinproject); } this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet_PersoninFamily", allFamiliesinProj)); ReportParameter p1 = new ReportParameter("DateFrom", dateFrom.Value.ToString("mm/dd/yyyy")); ReportParameter p2 = new ReportParameter("DateTo", dateTo.Value.ToString("mm/dd/yyyy")); ReportParameter p3 = new ReportParameter("project", comboBox1.Text); ReportParameter p4 = new ReportParameter("MasrofSummary", MasrofSummary); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3,p4 }); reportViewer1.Visible = true; this.reportViewer1.RefreshReport(); }