public void openShiduchActivityForm(ListView lst, People MyPeople = null) { //עדכון פעילות if (lst.SelectedItems.Count <= 0) { return; } if (lst.Name == "lstReminder") { openReminder = true; } int idActivity = int.Parse(lst.SelectedItems[0].Tag.ToString()); // int idSideB = int.Parse(lstMyActivity.SelectedItems[0].SubItems[5].Text); s = ReadById(idActivity); //להביא את ההערות של הכרטיס השני string notesSide = removeFromString(s.NotesSummary) + "\r\n" + "=====צד ב'=====" + Environment.NewLine; string sql = "select NotesSummary from ShiduchActivity s " + "where s.UserId=" + s.UserId + " and PeopleId=" + s.IdSideB + " and IdSideB=" + s.PeopleId + " and Action=" + s.Action + " and abs(DATEDIFF(day,s.Date,'" + s.Date.ToString("yyyy-MM-dd h:mm tt") + "'))" + " between 0 and 15"; SqlDataReader reader = DBFunction.ExecuteReader(sql); if (reader.Read()) { notesSide += removeFromString(reader["NotesSummary"].ToString()); } reader.Close(); s.NotesSummary = notesSide; if (MyPeople == null) { MyPeople = new People(); SqlDataReader reader1 = People.ReadById(s.PeopleId); if (reader1.Read()) { PeopleManipulations.ReaderToPeople(ref MyPeople, ref reader1); } reader1.Close(); } ShiduchActivityForm sForm; if (openReminder)//אם נפתח דרך התזכורות { sForm = new ShiduchActivityForm(s, MyPeople, false, true, false, true); } else { sForm = new ShiduchActivityForm(s, MyPeople, false, true, false); } sForm.Show(); sForm.FormClosed += SForm_FormClosed; }
private void btnshowinfo_Click(object sender, EventArgs e) { if (MyPeople.OpenDetailsForAdd || MyPeople.OpenForPersonalAdd) { MessageBox.Show("לא זמין במצב הוספה. " + Environment.NewLine + "שמרו את הכרטיס החדש ולאחר מכן פתחו שוב", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { ShiduchActivityForm activityForm = new ShiduchActivityForm(new ShiduchActivity(), MyPeople); activityForm.Show(); activityForm.FormClosed += s.SForm_FormClosed; // string info = ""; // info = txtDadPhone.Text + "\n" + txtMomPhone.Text + "\n" + txtTelephone.Text + "\n" + txtMail.Text; // Forms.FrmPhone frmphone = new Forms.FrmPhone(info, txtfname.Text + " " + txtlname.Text + "^" + MyPeople.ID.ToString(), MyPeople.ID.ToString()); // Log.AddAction(Log.ActionType.PhoneFormOpen, new Log(Log.ActionType.PhoneFormOpen, txtfname.Text + " " + txtlname.Text + "^" + MyPeople.ID.ToString())); // frmphone.ShowDialog(); } }
public void SForm_FormClosed(object sender, FormClosedEventArgs e) { ShiduchActivityForm f = (sender as ShiduchActivityForm); ShiduchActivityForm form2; if (f.save) { SaveOpenReminder = true; if (f.OpenNewActivity) { ShiduchActivity s = new ShiduchActivity(); s.UserId = f.Activity.UserId; s.PeopleId = f.Activity.PeopleId; s.IdSideB = f.Activity.IdSideB; form2 = new ShiduchActivityForm(s, f.MyPeople); form2.isNew_Active_From_Complete_Active = true; form2.Show(); form2.FormClosed += SForm_FormClosed; } } if ((sender as ShiduchActivityForm).OpenSideB)//אם רוצה לפתוח פעילות של הצד השני { //f.Close(); People person = f.Shiduch; People shiduch = f.MyPeople; string sql = "select s.*,r.id as remindID, r.Date as remindDate,r.Done,r.IdUser as remindIdUser from ShiduchActivity s inner join ReminderActivity r " + "on s.Id=r.IdActivity " + "where s.UserId=" + f.Activity.UserId + " and PeopleId=" + person.ID + " and IdSideB=" + shiduch.ID + " and Action=" + f.Activity.Action + " and abs(DATEDIFF(day,s.Date,'" + f.Activity.Date.ToString("yyyy-MM-dd h:mm tt") + "'))" + " between 0 and 15"; // " and ( convert(varchar(10), s.Date, 103)='" + f.Activity.Date.ToShortDateString() + "' "+ //"or convert(varchar(10), s.Date, 103)>'" + f.Activity.Date.ToShortDateString() + // "' or s.Date >= DATEADD(DAY, -14,'" + f.Activity.Date.ToString("yyyy-MM-dd h:mm tt") + "'))"; SqlDataReader reader = DBFunction.ExecuteReader(sql); ShiduchActivity s = new ShiduchActivity(); string notesSide = removeFromString(f.Activity.NotesSummary); if (reader.Read()) { ShiduchActivity.readerToShiduchActivity(ref reader, ref s); s.NotesSummary = removeFromString(s.NotesSummary) + "=====צד ב'=====" + Environment.NewLine + notesSide; form2 = new ShiduchActivityForm(s, person, false, true); } else { s.IdSideB = shiduch.ID; s.Action = f.Activity.Action; s.UserId = f.Activity.UserId; s.NotesSummary += "\r\n =====צד ב'=====\r\n" + notesSide; form2 = new ShiduchActivityForm(s, person, true, false, true); } reader.Close(); form2.Show(); form2.FormClosed += SForm_FormClosed; //אם יש כבר פעילות דומה אז לפתוח אותה //אחרת לפתוח טופס חדש של פעילות } if ((sender as ShiduchActivityForm).save) { //foreach (Form frm in Application.OpenForms) //{ // if (frm.GetType() ==typeof( MainForm)) // { // (frm as MainForm).LoadReminder(); // } //} //saveReminder = true; } }