public void LoadResultToList(ref People p, ListView lst, bool TempPeople = false) { ListViewItem item = new ListViewItem(); // DateTime temp = DateTime.Parse("11/07/2015 23:22:22"); item.Text = p.FirstName; item.SubItems.Add(p.Lasname); item.SubItems.Add(p.Details.Schools); item.SubItems.Add(p.Age.ToString()); item.SubItems.Add(p.Tall.ToString()); item.SubItems.Add(p.Details.Notes); item.SubItems.Add(p.ID.ToString()); if (!TempPeople) { // if (p.Register.LastUpdate < temp) // item.ForeColor = Color.Gray; } if (TempPeople) { item.Tag = p.ByUser; item.SubItems.Add(p.TempId.ToString()); item.SubItems.Add(p.Reason.ToString()); } if (p.Sexs == 2) { item.ImageIndex = 0; } else { item.ImageIndex = 1; } switch (p.Reason) { case (int)People.ReasonType.Wedding: item.ForeColor = Color.Red; break; case (int)People.ReasonType.ShadChan: item.ForeColor = Color.Blue; break; case (int)People.ReasonType.AllowLimited: item.ForeColor = Color.Green; break; } switch (p.Show) { case (int)People.ShowTypes.HideDetails: item.BackColor = Color.LightGreen; if (GLOBALVARS.MyUser.Control == User.TypeControl.User) { item.Text = "חסוי"; item.SubItems[1].Text = "חסוי"; } break; case (int)People.ShowTypes.HideFromUsers: item.BackColor = Color.LightBlue; break; case (int)People.ShowTypes.VIP: item.BackColor = Color.Gold; break; case (int)People.ShowTypes.Personal: item.BackColor = Color.LightGreen; break; } lst.Items.Add(item); }
public static ArrayList GetMatches(People people) { ArrayList list = new ArrayList(); mydic_whoami.Clear(); mydic_whoiwant.Clear(); foreach (DictinorayRow row in DictinorayRow.DictinorayList) { int temp = row.IsMatchWord(people.Details.WhoAmI); if (temp == 1 || temp == -1) { if (temp == -1) { row.ChangeToUpSitewords(); } mydic_whoami.Add(row); mydic_not_type.Add(row); } } foreach (DictinorayRow row in DictinorayRow.DictinorayList) { int temp = row.IsMatchWord(people.Details.WhoAmI); if (temp == 1 || temp == -1) { if (temp == -1) { row.ChangeToUpSitewords(); } mydic_whoiwant.Add(row); mydic_not_type.Add(row); } } MatchesChecks xmatch = new MatchesChecks(); xmatch.p = people; string show = " AND SHOW <> 8 AND (show <2 or (show=5 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%') or (show=4 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%'))"; if (GLOBALVARS.MyUser.Control == User.TypeControl.Manger || GLOBALVARS.MyUser.Control == User.TypeControl.Admin) { show = " and show <> 8"; } string sql = "select zerem,looks,show,chadchan,whoami,whoiwant,[peopledetails].[relatedid],[Peoples].[ID],FirstName,facecolor,sexs,Lastname,tall,status,fat,age,show,notes from peoples inner join peopledetails on ID=relatedid "; sql += xmatch.GetSqlCheck() + show; SqlDataReader reader = DBFunction.ExecuteReader(sql); while (reader.Read()) { Match result = new Match(); result.Name = reader["firstname"].ToString() + " " + reader["lastname"].ToString(); result.ID = (int)reader["id"]; //FAT CHECK result.FatCheckString = xmatch.FatCheck(reader["fat"].ToString(), ref result.FatMatchLevel); //FACECOLOR CHECK result.FaceColorCheckString = xmatch.FaceColorCheck(reader["facecolor"].ToString(), ref result.FaceColorMatchLevel); //Looks CHECK result.LooksCheckString = xmatch.LooksCheck(reader["looks"].ToString(), ref result.LooksMatchLevel); //FromDic CHECK result.DicCheckString.AddRange(xmatch.CheckFromDic(reader["looks"].ToString(), "LookChange", ref result.DicMatchLevel)); // result.DicCheckString.AddRange(xmatch.CheckFromDic(reader["zerem"].ToString(), "ZeremChange", ref result.DicMatchLevel)); result.DicCheckString.AddRange(xmatch.CheckFromDic(reader["facecolor"].ToString(), "FaceChange", ref result.DicMatchLevel)); // STATUS CHECK result.StatusCheckString = xmatch.StatusCheck(reader["status"].ToString(), ref result.MatchLevel); //EDA CHECK NEEEED TO FIXXX result.ZeremOfEdaString = xmatch.ZeremCheck(reader["zerem"].ToString(), ref result.ZeremOfEdaMatchLevel); //WHOAMI + LOOKFOR CHECK result.WhoamiCheckString.AddRange(xmatch.FindPropties(reader["whoiwant"] as string, ref result.WhoAmIMatchLevel, false)); result.LookForCheckString.AddRange(xmatch.FindPropties(reader["whoami"] as string, ref result.LookForMatchLevel, true)); result.MatchLevel += result.FaceColorMatchLevel + result.FatMatchLevel + result.LooksMatchLevel + result.ZeremOfEdaMatchLevel + result.LookForMatchLevel + result.WhoAmIMatchLevel + result.DicMatchLevel; list.Add(result); } reader.Close(); return(list); }
public static bool ReaderToPeople(ref People peopleobj, ref SqlDataReader reader, bool register = false, bool detail = false) { peopleobj.Background = (string)reader["Background"]; peopleobj.Age = float.Parse(reader["Age"].ToString()); peopleobj.City = (string)reader["city"]; peopleobj.Eda = (string)reader["Eda"]; peopleobj.DadWork = (string)reader["DadWork"]; peopleobj.ID = (int)reader["relatedid"]; peopleobj.Lasname = (string)reader["Lastname"]; peopleobj.WorkPlace = (string)reader["WorkPlace"]; peopleobj.Sexs = (int)reader["Sexs"]; peopleobj.Register.ByUserName = (string)reader["ByUserName"]; peopleobj.Status = (string)reader["Status"]; peopleobj.LearnStaus = (string)reader["LearnStatus"]; peopleobj.FirstName = (string)reader["FirstName"]; peopleobj.FutureLearn = (bool)reader["FutureLearn"]; peopleobj.Beard = (string)reader["Beard"]; peopleobj.CoverHead = (string)reader["CoverHead"]; peopleobj.FaceColor = (string)reader["FaceColor"]; peopleobj.GorTorN = (string)reader["GorTorN"]; peopleobj.Looks = (string)reader["Looks"]; peopleobj.OpenHead = (int)reader["OpenHead"]; peopleobj.Show = int.Parse(reader["Show"].ToString()); peopleobj.StakeM = (string)reader["StakeM"]; peopleobj.Details.OwnChildrenCount = int.Parse((string)reader["OwnChildrenCount"].ToString()); peopleobj.Tall = float.Parse(reader["Tall"].ToString()); peopleobj.TneedE = (string)reader["TneedE"]; peopleobj.Weight = reader["fat"].ToString(); peopleobj.Zerem = (string)reader["Zerem"]; peopleobj.Details.MoneyToShadchan = (string)reader["MoneyToShadchan"]; peopleobj.Tz = (string)reader["Tz"]; peopleobj.KindChasidut = (string)reader["KindChasidut"]; peopleobj.ShiducNum = (string)reader["ShiducNum"]; peopleobj.HealthStatus = (string)reader["HealthStatus"]; peopleobj.HealthDetails = (string)reader["HealthDetails"]; peopleobj.ZeremMom = (string)reader["ZeremMom"]; peopleobj.BirthDayHebrew = (string)reader["BirthDayHebrew"]; if (register) { peopleobj.Register.ID = (int)reader["ID"]; peopleobj.Register.RegDate = DateTime.Parse(reader["regdate"].ToString()); //peopleobj.Register.RegType=(RegisterInfo.RegTypeE)reader["type"]; peopleobj.Register.RelatedId = (int)reader["relatedid"]; peopleobj.Register.LastUpdate = DateTime.Parse(reader["lastupdate"].ToString()); } if (detail) { //need to addd chadcan try { peopleobj.Chadchan = reader["chadchan"].ToString(); } catch (Exception e) { }; peopleobj.Details.ChildrenCount = (int)reader["ChildrenCount"]; peopleobj.Details.DadName = (string)reader["DadName"]; peopleobj.Details.FriendsInfo = (string)reader["FriendsInfo"]; peopleobj.Details.HomeRav = (string)reader["HomeRav"]; peopleobj.Details.MechutanimNames = (string)reader["MechutanimNames"]; peopleobj.Details.MomLname = (string)reader["MomLname"]; peopleobj.Details.MomName = (string)reader["MomName"]; peopleobj.Details.MomWork = (string)reader["MomWork"]; peopleobj.Details.MoneyGives = float.Parse(reader["MoneyGives"].ToString()); peopleobj.Details.MoneyRequired = float.Parse(reader["MoneyRequired"].ToString()); peopleobj.Details.MoneyNotesFlex = (bool)reader["MoneyNotesFlex"]; // peopleobj.Details.Pic = (string)reader["Pic"]; peopleobj.Details.RelatedId = (int)reader["relatedid"]; peopleobj.Details.Schools = (string)reader["Schools"]; peopleobj.Details.SiblingsSchools = (string)reader["SiblingsSchools"]; peopleobj.Details.Street = (string)reader["street"]; peopleobj.Details.Tel1 = (string)reader["tel1"]; peopleobj.Details.Tel2 = (string)reader["tel2"]; peopleobj.Details.WhoAmI = (string)reader["whoami"]; peopleobj.Details.Notes = (string)reader["notes"]; peopleobj.Details.WhoIWant = (string)reader["WhoIWant"]; peopleobj.Details.ZevetInfo = (string)reader["ZevetInfo"]; peopleobj.Details.YesivaKorHighSchool = (string)reader["YesivaKorHighSchool"]; peopleobj.Details.YeshivaGorSeminary = (string)reader["YeshivaGorSeminary"]; peopleobj.Details.KibutzorMaslul = (string)reader["KibutzorMaslul"]; peopleobj.Details.Licence = (bool)reader["Licence"]; peopleobj.Details.Smoker = (bool)reader["Smoker"]; peopleobj.Details.EdaExpectation = (string)reader["EdaExpectation"]; peopleobj.Details.AgeExpectation = float.Parse(reader["AgeExpectation"].ToString()); peopleobj.Details.DadYeshiva = (string)reader["DadYeshiva"]; peopleobj.Details.MomSeminary = (string)reader["MomSeminary"]; peopleobj.Details.StatusParents = (string)reader["StatusParents"]; peopleobj.Details.CommunityTo = (string)reader["CommunityTo"]; peopleobj.Details.ParentHealth = (string)reader["ParentHealth"]; peopleobj.Details.ParentHealthDetails = (string)reader["ParentHealthDetails"]; peopleobj.Details.LocationChild = (int)reader["LocationChild"]; peopleobj.Details.NumMarriedSibilings = (int)reader["NumMarriedSibilings"]; peopleobj.Details.ContactShiduch = (string)reader["ContactShiduch"]; peopleobj.Details.ContactPhone = (string)reader["ContactPhone"]; peopleobj.Details.FamilyAbout = (string)reader["FamilyAbout"]; peopleobj.Details.Telephone = (string)reader["Telephone"]; peopleobj.Details.PhoneOfBachur = (string)reader["PhoneOfBachur"]; peopleobj.Details.PhoneKosherLevel = (string)reader["PhoneKosherLevel"]; peopleobj.Details.Mail = (string)reader["Mail"]; } if (GLOBALVARS.MyUser.Control > User.TypeControl.User && DBFunction.ColumnExists(reader, "Reason")) { peopleobj.Reason = (int)reader["reason"]; peopleobj.RealId = int.Parse(reader["mrelatedID"].ToString()); peopleobj.TempId = (int)reader["TID"]; peopleobj.ByUser = (int)reader["ByUser"]; } return(true); }
public static SqlDataReader GetActivities(bool my, People p = null, bool all = false, bool inCare = false, bool allForManagerReport = false, DateTime date1 = default(DateTime), DateTime date2 = default(DateTime), int peopleId = 0, int userId = 0, bool MyAllForDiary = false, int action = -1, int status = -1, bool DiaryManager = false) { List <ShiduchActivity> list = new List <ShiduchActivity>(); ShiduchActivity item; if (p == null) { p = new People(); } //פעילויות שלי string select, from, where = "", sql, orderBy = "", sActionNUmber = " s.Action<4 "; select = "select s.*,p2.FirstName+' '+p2.LastName as FullNameB "; from = "from ShiduchActivity s left join Peoples p2 on s.IdSideB=p2.ID "; where = " where s.PeopleId=" + p.ID; if (my)//פעיליות שהשדכן עשה לכרטיס זה { if (GLOBALVARS.MyUser.Control == User.TypeControl.Admin || GLOBALVARS.MyUser.Control == User.TypeControl.Manger) { where += " and " + sActionNUmber; } else { where += " and s.UserId=" + GLOBALVARS.MyUser.ID + " and s.action<4"; } } if (all)//פעילויות של כלל השדכנים לכרטיס זה לא כולל פגישה { select += ",u.Name "; from += " inner join users u on u.id =s.userid "; if (GLOBALVARS.MyUser.Control != User.TypeControl.Admin && GLOBALVARS.MyUser.Control != User.TypeControl.Manger) { where += " and s.Action in(0,2,3,5)"; } } if (inCare) { select += " ,p.FirstName+' '+p.LastName as FullNameA,r.Date as remindDate "; from += " left join Peoples p on s.peopleid = p.id inner join ReminderActivity r on r.IdActivity=s.Id "; where = " where s.UserId=" + GLOBALVARS.MyUser.ID + " and s.action<4 and s.Status=0 and r.Done=0 and r.Date<=getdate() "; } if (allForManagerReport) { if (DiaryManager) { sActionNUmber = "s.action<5"; if (action > 0)//-1 לא נבחר 0 הכל { sActionNUmber = "s.Action=" + (action - 1); } //אם זה מנהל שבודק פעילות של שדכן מסוים אז הוא יכול לראות את הכל if (status > 0)//אם לא בחר סטטוס מסוים אז מביאים את הכל { where += " and s.Status=" + (status - 1); } } select += " ,p.FirstName+' '+p.LastName as FullNameA,u.Name,u.id as userID," + "r.Date as remindDate,r.id as remindID ,r.IdUser as remindIdUser ,Done "; from += " left join Peoples p on s.peopleid = p.id inner join users u on u.id =s.userid" + " inner join ReminderActivity r on r.IdActivity=s.Id "; where = " where " + sActionNUmber + " and s.Date between'" + date1.ToString("yyyy-MM-dd h:mm tt") + "' and '" + date2.ToString("yyyy-MM-dd h:mm tt") + "' "; if (peopleId != 0) { where += " and s.PeopleId=" + peopleId; } if (userId != 0) { where += " and s.UserId=" + userId; } orderBy = " order by s.Action,s.Status "; } if (MyAllForDiary) { select += ",r.Date as remindDate,r.Done,p.FirstName+' '+p.LastName as FullNameA,u.Name "; from += " left join Peoples p on s.peopleid = p.id inner join ReminderActivity r on" + " r.IdActivity=s.Id inner join users u on u.id =s.userid "; where = " where s.UserId=" + userId + " and s.Date between'" + date1.ToString("yyyy-MM-dd h:mm tt") + "' and '" + date2.ToString("yyyy-MM-dd h:mm tt") + "' "; if (action > 0)//-1 לא נבחר 0 הכל { where += " and s.Action=" + (action - 1); } else if (DiaryManager)//אם זה מנהל שבודק פעילות של שדכן מסוים אז הוא יכול לראות את הכל { where += " and s.action<5"; } else { where += " and s.action<4"; } if (status > 0)//אם לא בחר סטטוס מסוים אז מביאים את הכל { where += " and s.Status=" + (status - 1); } } sql = select + from + where + orderBy; SqlDataReader reader = DBFunction.ExecuteReader(sql); return(reader); }
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; } }
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; }
private void Search(object obj) { SqlDataReader reader; SqlParameter[] prms = new SqlParameter[25]; string Sql = ""; string AgeSql = ""; string whoami = ""; string whoiwant = ""; string sqlwhoiwant = ""; string sqlwhoami = ""; string noteswhoami = ""; string noteswhoiwant = ""; string LearnStatus = ""; string Subscription = ""; string sexs = ""; int fromage = (int)txtfromage.Value; int tillage = (int)txttillage.Value; string show = " AND SHOW <> 8 AND (show <2 or (show=5 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%') or (show=4 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%'))"; string IdFilter = ""; if (GLOBALVARS.MyUser.Control == User.TypeControl.Manger || GLOBALVARS.MyUser.Control == User.TypeControl.Admin) { show = " and show <> 8"; } if (txtlearnstatus.SelectedIndex != -1) { LearnStatus = BuildSql.GetSql(out prms[16], txtlearnstatus.Text, "LearnStatus", BuildSql.SqlKind.EQUAL); } if (tillage > 0) { AgeSql = BuildSql.GetSql(out prms[0], fromage, "age", BuildSql.SqlKind.BETWEEN, true, tillage); } // if(chksubscription.Checked) // Subscription= BuildSql.GetSql(out prms[17], chksubscription.Checked, "Subscription", BuildSql.SqlKind.EQUAL,false); if (txtid.Value != 0) { IdFilter = " peoples.ID=" + txtid.Value + " AND "; } if (txtwhoami.Text.Length > 0) { noteswhoami = whoami = "("; foreach (string s in splitwords(txtwhoami.Text)) { if (s.Trim().Length > 0) { whoami += " whoami like N'%" + s + "%' and"; noteswhoami += " notes like N'%" + s + "%' and"; } } whoami = whoami.Remove(whoami.Length - 3, 3); noteswhoami = noteswhoami.Remove(noteswhoami.Length - 3, 3); noteswhoami += ")"; whoami += ")"; sqlwhoami = "(" + whoami + " or " + noteswhoami + ")"; } if (txtwhoiwant.Text.Length > 0) { whoiwant = noteswhoiwant = "("; foreach (string s in splitwords(txtwhoiwant.Text)) { if (s.Trim().Length > 0) { whoiwant += " whoiwant like N'%" + s + "%' and"; noteswhoiwant += " notes like N'%" + s + "%' and"; } } whoiwant = whoiwant.Remove(whoiwant.Length - 3, 3); noteswhoiwant = noteswhoiwant.Remove(noteswhoiwant.Length - 3, 3); noteswhoiwant += ")"; whoiwant += ")"; sqlwhoiwant = "(" + whoiwant + " or " + noteswhoiwant + ")"; } if (!string.IsNullOrEmpty(whoiwant) && !string.IsNullOrEmpty(whoami)) { sqlwhoami += " and "; } if (txtsexs.SelectedIndex != -1) { sexs = BuildSql.GetSql(out prms[12], txtsexs.SelectedIndex + 1, "sexs", BuildSql.SqlKind.EQUAL); } Sql = " select schools,sexs,firstname,lastname,tall,age,City,fat," + "FaceColor,Looks,WorkPlace,Beard,Zerem,Eda,LearnStatus,DadWork," + "Background,Status,Tz,KindChasidut,HealthStatus,ZeremMom,Street," + "DadName,MomName,MomWork," + "[peopledetails].[relatedid],[Peoples].[ID],Tel1,Tel2,Telephone,PhoneOfBachur from peoples inner join peopledetails on ID=relatedid where temp='false' AND " + BuildSql.GetSql(out prms[1], txtfname.Text, "FirstName", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[2], txtlname.Text, "Lastname", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[3], txtbeard.Text, "beard", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[4], txtbg.Text, "background", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[5], txtcoverhead.Text, "coverhead", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[6], txtdadwork.Text, "dadwork", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[7], txtfacecolor.Text, "facecolor", BuildSql.SqlKind.LIKE) + IdFilter + BuildSql.GetSql(out prms[8], txtfat.Text, "fat", BuildSql.SqlKind.LIKE) + AgeSql + BuildSql.GetSql(out prms[9], txtlooks.Text, "looks", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[10], txtpeticut.Text, "openhead", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[11], txtschool.Text, "schools", BuildSql.SqlKind.LIKE) + sexs + BuildSql.GetSql(out prms[13], txtzerem.Text, "(eda", BuildSql.SqlKind.LIKE, false, null, true) + BuildSql.GetSql(out prms[14], txtzerem.Text, "zerem", BuildSql.SqlKind.LIKE, false, null, false, ") AND ") + BuildSql.GetSql(out prms[15], txtstatus.Text, "Status", BuildSql.SqlKind.EQUAL) + BuildSql.GetSql(out prms[17], txtCity.Text, "City", BuildSql.SqlKind.LIKE) + BuildSql.GetSql(out prms[18], txtPhone.Text, "(Tel1", BuildSql.SqlKind.LIKE, false, null, true) + BuildSql.GetSql(out prms[19], txtPhone.Text, "Tel2", BuildSql.SqlKind.LIKE, false, null, true) + BuildSql.GetSql(out prms[20], txtPhone.Text, "Telephone", BuildSql.SqlKind.LIKE, false, null, true) + BuildSql.GetSql(out prms[21], txtPhone.Text, "PhoneOfBachur", BuildSql.SqlKind.LIKE, false, null, false, " ) AND ") + sqlwhoami + sqlwhoiwant + LearnStatus + Subscription; Sql = BuildSql.CheckForLastAnd(ref Sql); Sql += show; Sql += " ORDER BY ID DESC"; reader = DBFunction.ExecuteReader(Sql, prms); // fs.Search(txtfreeserach.Text, (FreeSearch.accuracy)cmb_accuracy.SelectedIndex); List <People> lst = new List <People>(); while (reader.Read()) { People p = new People(); PeopleManipulations.ReaderToPeople(ref p, ref reader, PeopleManipulations.RtpFor.ForSearch); lst.Add(p); } olstpeople.BeginUpdate(); olstpeople.SetObjects(lst); olstpeople.EndUpdate(); reader.Close(); DBFunction.CloseConnections(); //picload.Visible = false; btnfilter.Enabled = true; }
public static bool InsretNew(People people, out int ID) { int n = people.Note.Count * 5; SqlParameter[] prms = new SqlParameter[92 + n]; string sql, sqlpeoples, sqldetails, sqlregister, sqlNotes = ""; sqlpeoples = "INSERT INTO Peoples VALUES(" + BuildSql.InsertSql(out prms[0], people.FirstName) + BuildSql.InsertSql(out prms[1], people.Lasname) + BuildSql.InsertSql(out prms[2], people.Sexs) + BuildSql.InsertSql(out prms[3], people.Age) + BuildSql.InsertSql(out prms[4], people.Tall) + BuildSql.InsertSql(out prms[5], people.Weight) + BuildSql.InsertSql(out prms[6], people.FaceColor) + BuildSql.InsertSql(out prms[7], people.Looks) + BuildSql.InsertSql(out prms[8], people.Beard) + BuildSql.InsertSql(out prms[9], people.City) + BuildSql.InsertSql(out prms[10], people.Zerem) + BuildSql.InsertSql(out prms[11], people.Eda) + BuildSql.InsertSql(out prms[12], people.FutureLearn) + BuildSql.InsertSql(out prms[13], people.Background) + BuildSql.InsertSql(out prms[14], people.DadWork) + BuildSql.InsertSql(out prms[15], people.CoverHead) + BuildSql.InsertSql(out prms[16], people.GorTorN) + BuildSql.InsertSql(out prms[17], people.TneedE) + BuildSql.InsertSql(out prms[18], people.StakeM) + BuildSql.InsertSql(out prms[19], people.OpenHead) + BuildSql.InsertSql(out prms[20], people.Status) + people.Show + "," + BuildSql.InsertSql(out prms[21], people.LearnStaus) + BuildSql.InsertSql(out prms[22], people.Tz) + BuildSql.InsertSql(out prms[23], people.KindChasidut) + BuildSql.InsertSql(out prms[24], people.ShiducNum) + BuildSql.InsertSql(out prms[25], people.HealthStatus) + BuildSql.InsertSql(out prms[26], people.HealthDetails) + BuildSql.InsertSql(out prms[27], people.ZeremMom) + BuildSql.InsertSql(out prms[28], people.BirthDayHebrew) + BuildSql.InsertSql(out prms[29], people.DeleteReason) + BuildSql.InsertSql(out prms[30], people.Temp) + BuildSql.InsertSql(out prms[31], people.Chadchan, true) + ");"; sqldetails = "INSERT INTO PeopleDetails VALUES(" + BuildSql.InsertSql(out prms[32], people.Details.Street) + BuildSql.InsertSql(out prms[33], people.Details.Schools) + BuildSql.InsertSql(out prms[34], people.Details.Tel1) + BuildSql.InsertSql(out prms[35], people.Details.Tel2) + BuildSql.InsertSql(out prms[36], people.Details.WhoAmI) + BuildSql.InsertSql(out prms[37], people.Details.WhoIWant) + BuildSql.InsertSql(out prms[39], people.Details.DadName) + BuildSql.InsertSql(out prms[40], people.Details.MomName) + BuildSql.InsertSql(out prms[41], people.Details.ChildrenCount) + BuildSql.InsertSql(out prms[42], people.Details.SiblingsSchools) + BuildSql.InsertSql(out prms[43], people.Details.MomLname) + BuildSql.InsertSql(out prms[44], people.Details.MomWork) + BuildSql.InsertSql(out prms[45], people.Details.MoneyGives) + BuildSql.InsertSql(out prms[46], people.Details.MoneyRequired) + BuildSql.InsertSql(out prms[47], people.Details.MoneyNotesFlex) + BuildSql.InsertSql(out prms[48], people.Details.HomeRav) + BuildSql.InsertSql(out prms[49], people.Details.MechutanimNames) + "@DataID," + BuildSql.InsertSql(out prms[50], people.Details.ZevetInfo) + BuildSql.InsertSql(out prms[51], people.Details.FriendsInfo) + BuildSql.InsertSql(out prms[54], people.Details.Notes) + BuildSql.InsertSql(out prms[55], people.Details.OwnChildrenCount) + BuildSql.InsertSql(out prms[56], people.WorkPlace) + BuildSql.InsertSql(out prms[57], people.Details.MoneyToShadchan) + BuildSql.InsertSql(out prms[58], people.Details.YesivaKorHighSchool) + BuildSql.InsertSql(out prms[59], people.Details.YeshivaGorSeminary) + BuildSql.InsertSql(out prms[60], people.Details.KibutzorMaslul) + BuildSql.InsertSql(out prms[61], people.Details.Licence) + BuildSql.InsertSql(out prms[62], people.Details.Smoker) + BuildSql.InsertSql(out prms[63], people.Details.EdaExpectation) + BuildSql.InsertSql(out prms[64], people.Details.AgeExpectation) + BuildSql.InsertSql(out prms[65], people.Details.DadYeshiva) + BuildSql.InsertSql(out prms[66], people.Details.MomSeminary) + BuildSql.InsertSql(out prms[69], people.Details.StatusParents) + BuildSql.InsertSql(out prms[70], people.Details.CommunityTo) + BuildSql.InsertSql(out prms[71], people.Details.ParentHealth) + BuildSql.InsertSql(out prms[72], people.Details.ParentHealthDetails) + BuildSql.InsertSql(out prms[73], people.Details.LocationChild) + BuildSql.InsertSql(out prms[74], people.Details.NumMarriedSibilings) + BuildSql.InsertSql(out prms[75], people.Details.ContactShiduch) + BuildSql.InsertSql(out prms[76], people.Details.ContactPhone) + BuildSql.InsertSql(out prms[77], people.Details.FamilyAbout) + BuildSql.InsertSql(out prms[78], people.Details.Telephone) + BuildSql.InsertSql(out prms[79], people.Details.PhoneOfBachur) + BuildSql.InsertSql(out prms[80], people.Details.PhoneKosherLevel) + BuildSql.InsertSql(out prms[81], people.Details.Mail, true) + ");"; sqlregister = "INSERT INTO RegisterInfo VALUES(" + BuildSql.InsertSql(out prms[82], DateTime.Now) + "@DataID" + "," + GLOBALVARS.MyUser.ID + "," + BuildSql.InsertSql(out prms[83], GLOBALVARS.MyUser.Name) + BuildSql.InsertSql(out prms[84], DateTime.Now, true) + ");"; int iPrm = 90; foreach (var item in people.Note) { sqlNotes += "INSERT INTO NotesOfPeople VALUES(" + BuildSql.InsertSql(out prms[iPrm++], GLOBALVARS.MyUser.ID) + BuildSql.InsertSql(out prms[iPrm++], GLOBALVARS.MyUser.Name) + "@DataID" + "," + BuildSql.InsertSql(out prms[iPrm++], item.NoteText) + BuildSql.InsertSql(out prms[iPrm++], DateTime.Now, true) + "); "; } prms[85] = new SqlParameter("@D", SqlDbType.Int); prms[85].Direction = ParameterDirection.Output; sql = "BEGIN TRANSACTION " + "DECLARE @DataID int;" + sqlpeoples + "SELECT @DataID = scope_identity();" + "SELECT @D = scope_identity();" + sqldetails + sqlregister + sqlNotes + "COMMIT"; int length = sql.Length; // return DBFunction.Execute(sql, prms); bool f = DBFunction.Execute(sql, prms); ID = 0; if (prms[85].Value != DBNull.Value) { ID = Convert.ToInt32(prms[85].Value); } ShiduchActivity Activity = new ShiduchActivity(); Activity.Date = DateTime.Now; Activity.UserId = GLOBALVARS.MyUser.ID; Activity.PeopleId = ID; Activity.Action = (int)ShiduchActivity.ActionType.reception; ShiduchActivity.insertActivity(Activity); return(f); }
public static bool UpdatePeople(People p, bool Wedding, bool Shadchan = false, string Notes = null, bool PublishClient = false) { string sql = ""; string where = " where id=" + p.ID + " "; string Rwhere = " where relatedid=" + p.ID + " "; bool PlusTblReg = true; SqlParameter[] prms = new SqlParameter[100]; //if (p.Show != 5) //{ // check is not personal user // PlusTblReg = true; // for future use // // if (Shadchan) // // return ShadchanUpdate(); // if (Wedding) // return WeddingUpdate(p); // //if (!GLOBALVARS.MyUser.CanEdit) // // return UpdateTemp(Notes); //} //else //{ // if (!PublishClient) // p.Show = 5; // p.Chadchan = "{" + GLOBALVARS.MyUser.ID.ToString() + "}"; //} sql = "BEGIN TRANSACTION "; sql += "update peoples SET " + BuildSql.UpdateSql(out prms[0], p.Age, "age") + BuildSql.UpdateSql(out prms[1], p.Background, "background") + BuildSql.UpdateSql(out prms[2], p.Beard, "Beard") + BuildSql.UpdateSql(out prms[3], p.City, "City") + BuildSql.UpdateSql(out prms[4], p.CoverHead, "CoverHead") + BuildSql.UpdateSql(out prms[5], p.DadWork, "DadWork") + BuildSql.UpdateSql(out prms[6], p.Eda, "eda") + BuildSql.UpdateSql(out prms[7], p.FaceColor, "FaceColor") + BuildSql.UpdateSql(out prms[8], p.FirstName, "FirstName") + BuildSql.UpdateSql(out prms[9], p.FutureLearn, "FutureLearn") + BuildSql.UpdateSql(out prms[10], p.GorTorN, "GorTorN") + BuildSql.UpdateSql(out prms[11], p.Lasname, "Lastname") + BuildSql.UpdateSql(out prms[12], p.Looks, "Looks") + BuildSql.UpdateSql(out prms[13], p.OpenHead, "OpenHead") + BuildSql.UpdateSql(out prms[15], p.Sexs, "Sexs") + BuildSql.UpdateSql(out prms[16], p.Show, "show") + BuildSql.UpdateSql(out prms[17], p.StakeM, "StakeM") + BuildSql.UpdateSql(out prms[18], p.Status, "Status") + BuildSql.UpdateSql(out prms[19], p.Tall, "Tall") + BuildSql.UpdateSql(out prms[20], p.TneedE, "TneedE") + BuildSql.UpdateSql(out prms[59], p.LearnStaus, "LearnStatus") + BuildSql.UpdateSql(out prms[21], p.Zerem, "Zerem") + BuildSql.UpdateSql(out prms[70], p.Tz, "Tz") + BuildSql.UpdateSql(out prms[71], p.KindChasidut, "KindChasidut") + BuildSql.UpdateSql(out prms[72], p.ShiducNum, "ShiducNum") + BuildSql.UpdateSql(out prms[73], p.HealthStatus, "HealthStatus") + BuildSql.UpdateSql(out prms[74], p.HealthDetails, "HealthDetails") + BuildSql.UpdateSql(out prms[88], p.ZeremMom, "ZeremMom") + BuildSql.UpdateSql(out prms[91], p.BirthDayHebrew, "BirthDayHebrew") + BuildSql.UpdateSql(out prms[23], p.Chadchan, "Chadchan") + BuildSql.UpdateSql(out prms[93], p.Temp, "Temp") + BuildSql.UpdateSql(out prms[22], p.Weight, "fat", true) + where + ";"; sql += " update peopledetails SET " + BuildSql.UpdateSql(out prms[24], p.Details.ChildrenCount, "ChildrenCount") + BuildSql.UpdateSql(out prms[25], p.Details.DadName, "DadName") + BuildSql.UpdateSql(out prms[27], p.Details.FriendsInfo, "FriendsInfo") + BuildSql.UpdateSql(out prms[28], p.Details.HomeRav, "HomeRav") + BuildSql.UpdateSql(out prms[29], p.Details.MechutanimNames, "MechutanimNames") + BuildSql.UpdateSql(out prms[30], p.Details.MomLname, "MomLname") + BuildSql.UpdateSql(out prms[31], p.Details.MomName, "MomName") + BuildSql.UpdateSql(out prms[32], p.Details.MomWork, "MomWork") + BuildSql.UpdateSql(out prms[33], p.Details.MoneyGives, "MoneyGives") + BuildSql.UpdateSql(out prms[34], p.Details.MoneyNotesFlex, "MoneyNotesFlex") + BuildSql.UpdateSql(out prms[35], p.Details.MoneyRequired, "MoneyRequired") + BuildSql.UpdateSql(out prms[36], p.Details.Notes, "Notes") + BuildSql.UpdateSql(out prms[37], p.Details.OwnChildrenCount, "OwnChildrenCount") + BuildSql.UpdateSql(out prms[38], p.Details.RelatedId, "RelatedId") + BuildSql.UpdateSql(out prms[39], p.Details.Schools, "Schools") + BuildSql.UpdateSql(out prms[40], p.Details.SiblingsSchools, "SiblingsSchools") + BuildSql.UpdateSql(out prms[41], p.Details.Street, "Street") + BuildSql.UpdateSql(out prms[42], p.Details.Tel1, "Tel1") + BuildSql.UpdateSql(out prms[43], p.Details.Tel2, "Tel2") + BuildSql.UpdateSql(out prms[44], p.Details.WhoAmI, "WhoAmI") + BuildSql.UpdateSql(out prms[45], p.Details.WhoIWant, "WhoIWant") + BuildSql.UpdateSql(out prms[48], p.WorkPlace, "WorkPlace") + BuildSql.UpdateSql(out prms[49], p.Details.ZevetInfo, "ZevetInfo") + BuildSql.UpdateSql(out prms[75], p.Details.YesivaKorHighSchool, "YesivaKorHighSchool") + BuildSql.UpdateSql(out prms[76], p.Details.YeshivaGorSeminary, "YeshivaGorSeminary") + BuildSql.UpdateSql(out prms[77], p.Details.KibutzorMaslul, "KibutzorMaslul") + BuildSql.UpdateSql(out prms[78], p.Details.Licence, "Licence") + BuildSql.UpdateSql(out prms[79], p.Details.Smoker, "Smoker") + BuildSql.UpdateSql(out prms[80], p.Details.EdaExpectation, "EdaExpectation") + BuildSql.UpdateSql(out prms[81], p.Details.AgeExpectation, "AgeExpectation") + BuildSql.UpdateSql(out prms[82], p.Details.DadYeshiva, "DadYeshiva") + BuildSql.UpdateSql(out prms[83], p.Details.MomSeminary, "MomSeminary") + BuildSql.UpdateSql(out prms[84], p.Details.StatusParents, "StatusParents") + BuildSql.UpdateSql(out prms[85], p.Details.CommunityTo, "CommunityTo") + BuildSql.UpdateSql(out prms[86], p.Details.ParentHealth, "ParentHealth") + BuildSql.UpdateSql(out prms[87], p.Details.ParentHealthDetails, "ParentHealthDetails") + BuildSql.UpdateSql(out prms[89], p.Details.LocationChild, "LocationChild") + BuildSql.UpdateSql(out prms[90], p.Details.NumMarriedSibilings, "NumMarriedSibilings") + BuildSql.UpdateSql(out prms[63], p.Details.ContactShiduch, "ContactShiduch") + BuildSql.UpdateSql(out prms[64], p.Details.ContactPhone, "ContactPhone") + BuildSql.UpdateSql(out prms[65], p.Details.FamilyAbout, "FamilyAbout") + BuildSql.UpdateSql(out prms[66], p.Details.Telephone, "Telephone") + BuildSql.UpdateSql(out prms[67], p.Details.PhoneOfBachur, "PhoneOfBachur") + BuildSql.UpdateSql(out prms[68], p.Details.PhoneKosherLevel, "PhoneKosherLevel") + BuildSql.UpdateSql(out prms[69], p.Details.Mail, "Mail") + BuildSql.UpdateSql(out prms[61], p.Details.MoneyToShadchan, "MoneyToShadchan", true) + Rwhere + ";"; // ^ it right sql += " update RegisterInfo SET "; sql += BuildSql.UpdateSql(out prms[62], DateTime.Now.Date, "LastUpdate", true) + Rwhere + "; "; sql += "COMMIT"; DBFunction.Execute(sql, prms); PopUpMessage(false); ShiduchActivity Activity = new ShiduchActivity(); Activity.Date = DateTime.Now; Activity.UserId = GLOBALVARS.MyUser.ID; Activity.PeopleId = p.ID; Activity.Action = (int)ShiduchActivity.ActionType.update; ShiduchActivity.insertActivity(Activity); return(true); }
public static SqlDataReader ReadAll(int temp = 0, bool all = false, bool login = false, bool persnoal_vip = false, bool vip = false, bool openForActivity = false, People p = null) { //try //{ string show = " AND show <> 8 AND (show <2 or (show=5 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%') or (show=4 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%'))"; if (persnoal_vip) { show = " where (show=5 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%') or (show=4 and chadchan like '%{" + GLOBALVARS.MyUser.ID + "}%')"; } if (GLOBALVARS.MyUser.Control == User.TypeControl.Manger || GLOBALVARS.MyUser.Control == User.TypeControl.Admin) { show = " where show <> 8"; if (persnoal_vip) { show = " where show > 0 and show <> 8"; } } show += " and Temp='false'"; string sql = "select * from peoples p inner join peopledetails pd on p.ID=pd.relatedid inner join " + "registerinfo r on pd.relatedid=r.relatedid " + show; if (openForActivity) { string where = " and sexs="; if (p.Sexs == 1) { where += "2 "; } else { where += "1 "; } sql = "select FirstName, LastName, YeshivaGorSeminary,Street,City,ID from peoples p inner join" + " peopledetails pd on p.ID=pd.relatedid " + show + where; } if (temp == 1) { sql = "select * from peoples p left join peopledetails pd on p.ID=pd.relatedid where temp='true'" + show; } if (all) { sql = "select p.ID,p.FirstName+' '+p.LastName as FullName from peoples p " + show; } if (login) { sql = "select top 50 id,schools,sexs,firstname,lastname,tall,age,City,fat," + "FaceColor,Looks,WorkPlace,Beard,Zerem,Eda,LearnStatus,DadWork," + "Background,Status,Tz,KindChasidut,HealthStatus,ZeremMom,Street," + "DadName,MomName,MomWork from peoples p inner join peopledetails pd on p.ID=pd.relatedid " + show + " order by id desc"; } if (persnoal_vip) { sql = "select top 50 id,schools,sexs,firstname,lastname,tall,age,City,fat," + "FaceColor,Looks,WorkPlace,Beard,Zerem,Eda,LearnStatus,DadWork," + "Background,Status,Tz,KindChasidut,HealthStatus,ZeremMom,Street," + "DadName,MomName,MomWork from peoples p inner join peopledetails pd on p.ID=pd.relatedid " + show + " order by show desc"; } if (vip) { sql = "select MONEYTOSHADCHAN,chadchan,id,show,schools,sexs,firstname,lastname,tall,age,notes,City,Tel1,Tel2,Telephone,PhoneOfBachur from peoples p inner join peopledetails pd on p.ID=pd.relatedid " + show + " order by show desc"; } SqlDataReader reader = DBFunction.ExecuteReader(sql); return(reader); //} //catch (Exception) //{ // return null; //} }