private void LoadMyActivities() { SqlDataReader reader = ShiduchActivity.GetActivities(true, MyPeople); lstMyActivity.Items.Clear(); ListView lst = lstMyActivity; ListViewItem item; lstMyActivity.BeginUpdate(); while (reader.Read()) { string notes = reader["NotesSummary"].ToString(); string name = reader["FullNameB"] != System.DBNull.Value ? (string)reader["FullNameB"] : ""; if ((ShiduchActivity.ActionType)(int) reader["Action"] == ShiduchActivity.ActionType.other) { notes = notes.Substring(notes.IndexOf('^') + 3); } item = new ListViewItem(new string[] { DateTime.Parse(reader["Date"].ToString()).ToShortDateString(), ShiduchActivity.ConvertAction((ShiduchActivity.ActionType)(int) reader["Action"], reader), name, ShiduchActivity.ConvertStatus((ShiduchActivity.ActionStatus)(int) reader["Status"]), notes, reader["IdSideB"].ToString() }); item.Tag = reader["Id"]; lst.Items.Add(item); } lstMyActivity.EndUpdate(); reader.Close(); }
public void DiaryListResult(ref SqlDataReader reader) { List <ShiduchActivity> s = new List <ShiduchActivity>(); ListViewItem item; olstActivityDiary.Items.Clear(); olstActivityDiary.BeginUpdate(); while (reader.Read()) { ShiduchActivity sh = new ShiduchActivity(); ShiduchActivity.readerToShiduchActivity(ref reader, ref sh); string nameA = reader["FullNameA"] != System.DBNull.Value ? (string)reader["FullNameA"] : ""; string nameB = reader["FullNameB"] != System.DBNull.Value ? (string)reader["FullNameB"] : ""; sh.FullNameA = nameA; sh.FullNameB = nameB; sh.ActionConvert = ShiduchActivity.ConvertAction((ShiduchActivity.ActionType)sh.Action, reader); sh.StatusConvert = ShiduchActivity.ConvertStatus((ShiduchActivity.ActionStatus)sh.Status); sh.UserName = (string)reader["Name"]; item = new ListViewItem(new string[] { sh.Date.ToShortDateString(), sh.ActionConvert, sh.FullNameA, sh.FullNameB, sh.StatusConvert, sh.reminder.Date.ToShortDateString(), sh.NotesSummary }); item.Tag = sh.Id; s.Add(sh); olstActivityDiary.Items.Add(item); } olstActivityDiary.EndUpdate(); }
public void LoadReminder() { SqlDataReader reader = ShiduchActivity.GetActivities(false, null, false, true); lstReminder.Items.Clear(); ListView lst = lstReminder; ListViewItem item; ShiduchActivity.ActionType action; lstReminder.BeginUpdate(); while (reader.Read()) { string name = reader["FullNameB"] != System.DBNull.Value ? (string)reader["FullNameB"] : ""; action = (ShiduchActivity.ActionType)(int) reader["Action"]; item = new ListViewItem(new string[] { DateTime.Parse(reader["Date"].ToString()).ToShortDateString(), (string)reader["FullNameA"], ShiduchActivity.ConvertAction(action, reader), name }); item.Tag = reader["Id"]; //item.ImageKey = "phone-icon (1).png"; switch (action) { case ShiduchActivity.ActionType.proposal: item.BackColor = Color.FromArgb(234, 195, 152); break; case ShiduchActivity.ActionType.date: item.BackColor = Color.FromArgb(234, 133, 129); break; case ShiduchActivity.ActionType.details: item.BackColor = Color.FromArgb(234, 206, 187); break; case ShiduchActivity.ActionType.other: item.BackColor = Color.FromArgb(183, 183, 183); break; } lst.Items.Add(item); } lstReminder.EndUpdate(); reader.Close(); }
private void LoadAllActivities() { SqlDataReader reader = ShiduchActivity.GetActivities(false, MyPeople, true); lstAllActivity.Items.Clear(); ListView lst = lstAllActivity; ListViewItem item; lstAllActivity.BeginUpdate(); while (reader.Read()) { string name = reader["FullNameB"] != System.DBNull.Value ? (string)reader["FullNameB"] : ""; item = new ListViewItem(new string[] { DateTime.Parse(reader["Date"].ToString()).ToShortDateString(), (string)reader["Name"], ShiduchActivity.ConvertAction((ShiduchActivity.ActionType)(int) reader["Action"], reader), name }); lst.Items.Add(item); } lstAllActivity.EndUpdate(); reader.Close(); }
private void LoadTxt() { groupBoxSideA.Text += MyPeople.FirstName + " " + MyPeople.Lasname; if (MyPeople.Sexs == 2) { lblSearchShiduch.Visible = false; } lblActiveFor.Text += MyPeople.FirstName + " " + MyPeople.Lasname; //if (lblActiveFor.Location.X + lblActiveFor.Width > btnSaveOpenB.Location.X) //{ // lblActiveFor.Location = new Point(btnSaveOpenB.Location.X - lblActiveFor.Width - 20, lblActiveFor.Location.Y); //} txtName.Text = MyPeople.FirstName + " " + MyPeople.Lasname; txtAge.Value = decimal.Parse(MyPeople.Age.ToString()); txtSchool.Text = MyPeople.Details.YeshivaGorSeminary; txtAdress.Text = MyPeople.Details.Street + " " + MyPeople.City; txtWork.Text = MyPeople.WorkPlace; txtPhoneDad.Text = MyPeople.Details.Tel1; txtPhoneMom.Text = MyPeople.Details.Tel2; txtPhone.Text = MyPeople.Details.Telephone; txtDate.Text = DateTime.Now.ToString(); if (newActivity && ShiduchActivity.IdSideB == 0) { LoadSearchShiduch(); } // if (updateActivity || ShiduchActivity.IdSideB > 0) //אם הפעילות נוצרה עם צד' ב if (ShiduchActivity.IdSideB != -1 && ShiduchActivity.IdSideB != 0) { SqlDataReader reader = People.ReadById(ShiduchActivity.IdSideB); if (reader.Read()) { Shiduch = new People(); PeopleManipulations.ReaderToPeople(ref Shiduch, ref reader, true, true); } reader.Close(); KeyValueClass item = new KeyValueClass(); item.Text = Shiduch.FirstName + " " + Shiduch.Lasname + " " + Shiduch.Details.YeshivaGorSeminary + " " + Shiduch.Details.Street + " " + Shiduch.City; item.Value = Shiduch.ID.ToString(); txtSearchShiduch.Items.Add(item); txtSearchShiduch.SelectedIndex = 0; //שיהיה אותה הפעילות לשני הצדדים ולא לאפשר לשנות if (thisSideB || updateActivity) { radDate.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.date; radProposal.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.proposal; radProposal.Enabled = radDate.Enabled = radOther.Enabled = radDetails.Enabled = txtOther.Enabled = false; txtNotesSummary.Text = ShiduchActivity.NotesSummary; } } if (updateActivity) { Text = "פעילות " + ShiduchActivity.ConvertAction((ShiduchActivity.ActionType)ShiduchActivity.Action) + " ל"; txtDate.Text = ShiduchActivity.Date.ToString(); txtDateReminder.Value = ShiduchActivity.reminder.Date; radDate.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.date; radProposal.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.proposal; radDetails.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.details; radOther.Checked = ShiduchActivity.Action == (int)ShiduchActivity.ActionType.other; if (radOther.Checked) { string text = ShiduchActivity.NotesSummary.Substring(0, ShiduchActivity.NotesSummary.IndexOf('^')); string t = ShiduchActivity.NotesSummary.Substring(ShiduchActivity.NotesSummary.IndexOf('^') + 3); txtOther.Text = text; txtNotesSummary.Text = t; } else { txtNotesSummary.Text = ShiduchActivity.NotesSummary; } radComplete.Checked = ShiduchActivity.Status == 1; radNoRelevant.Checked = ShiduchActivity.Status == 2; radProposal.Enabled = radDate.Enabled = radOther.Enabled = radDetails.Enabled = txtOther.Enabled = false; //אחרי שהפעילות נוצרה רק המנהל הראשי יכול לשנות אצ בטיפול של if (GLOBALVARS.MyUser.Control != User.TypeControl.Admin) { txtReminderInCare.Enabled = false; } } Text += MyPeople.FirstName + " " + MyPeople.Lasname; }