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