private void button1_Click(object sender, EventArgs e)
{
// add new project event to family
// add new project event to family
//oPerson = new tblPersonsDB(vars.mstrCnn);
HomeFixesProject newFamilyProj = new HomeFixesProject();
newFamilyProj.amount = Convert.ToInt32(txtAmount.Text);
newFamilyProj.familyID = familyid;
newFamilyProj.Address = txtAddress.Text;
newFamilyProj.date = dateTimePicker1.Value.Date;
newFamilyProj.Note = txtNote.Text;
newFamilyProj.RoomNumbers = Convert.ToInt32(txtRoomNum.Text);
newFamilyProj.Tarmimdemands = txtTarmimdemands.Text;
newFamilyProj.TarmimTakalef = txtTakalif.Text;
db.AddToHomeFixesProjects (newFamilyProj);
db.SaveChanges();
btnAddFamily.Enabled = false;
var query = from p in db.HomeFixesProjects.Where(x => x.familyID == familyid)
select p;
dtGridFamilyProjectHistory.DataSource = query.ToList<HomeFixesProject>();
}
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();
}
