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();
}
