public bool LoadData(bool reset = false)
{
ListNameColumnPeople = new List <KeyValueClass>();
ListNameColumnPeople.Add(new KeyValueClass("Status", 0));
ListNameColumnPeople.Add(new KeyValueClass("Tz", 0));
ListNameColumnPeople.Add(new KeyValueClass("HealthStatus", 0));
List <People> lst = new List <People>();
SqlDataReader myreader;
myreader = People.ReadAll(0, false, true);
while (myreader.Read())
{
People p = new People();
PeopleManipulations.ReaderToPeople(ref p, ref myreader, PeopleManipulations.RtpFor.ForSearch);
lst.Add(p);
}
olstpeople.BeginUpdate();
olstpeople.SetObjects(lst);
olstpeople.EndUpdate();
myreader.Close();
DBFunction.CloseConnections();
formloadmsg.Close();
return(true);
}
public static User GetUser(string suser, string spass)
{
User retuser = null;
SqlDataReader reader;
spass = SetPassword(spass);
SqlParameter puser = new SqlParameter("@user", suser);
SqlParameter ppass = new SqlParameter("@pass", spass);
reader = DBFunction.ExecuteReader("SELECT * from users where username=@user and password=@pass", puser, ppass);
if (reader != null && reader.Read())
{
retuser = new User();
retuser.Name = (string)reader["name"];
retuser.UserName = (string)reader["username"];
retuser.Password = ReturnPassword(reader["password"].ToString());
retuser.Email = (string)reader["email"];
retuser.ID = int.Parse(reader["id"].ToString());
retuser.Tel = (string)reader["tel"];
retuser.Control = (User.TypeControl)reader["control"];
retuser.TempPersonal = (bool)reader["TempPersonal"];
retuser.TempGeneral = (bool)reader["TempGeneral"];
retuser.Sector = (string)reader["Sector"];
GLOBALVARS.LastUserChangeFile = DateTime.Now;
UpdateManager.UpdateLastTimeCheck();
}
reader.Close();
DBFunction.CloseConnections();
return(retuser);
}
private void MainForm_FormClosed(object sender, FormClosedEventArgs e)
{
for (int i = 0; i < 1; i++)
{
Log.SetDurationLogin();
}
for (int i = 0; i < 1; i++)
{
WriteSettings();
}
DBFunction.CloseConnections();
Program.IdleTimer.Stop();
Environment.Exit(0);
}
public void LoadShadcanim()
{
string sql, where;
int controlhide = 1, index = -1;
Shadchanim = new ArrayList();
if (GLOBALVARS.MyUser.Control == User.TypeControl.Admin || GLOBALVARS.MyUser.Control == User.TypeControl.Manger)
{
where = "";
}
else if (thisSideB)
{
where = " where id=" + ShiduchActivity.UserId;
}
else
{
where = "where id=" + GLOBALVARS.MyUser.ID;
}
sql = "select name,id from users " + where;
SqlDataReader reader = DBFunction.ExecuteReader(sql);
while (reader != null && reader.Read())
{
KeyValueClass temp = new KeyValueClass((string)reader["name"], (int)reader["ID"]);
if (int.Parse(temp.Value.ToString()) == GLOBALVARS.MyUser.ID)
{
if (index < 0)
{
index = txtReminderInCare.Items.Count;
}
temp.Text = "שלי";
}
//אם הטיפול הוא אצל מישהו אחר ממני
if (updateActivity && int.Parse(temp.Value.ToString()) == ShiduchActivity.reminder.IdUser)
{
index = txtReminderInCare.Items.Count;
}
Shadchanim.Add(temp);
txtReminderInCare.Items.Add(temp);
}
reader.Close();
DBFunction.CloseConnections();
txtReminderInCare.SelectedIndex = index;
}
private void OpenDetails(int id, bool show = true)
{
FormCollection fc = Application.OpenForms;
foreach (Form frm in fc)
{
if (frm is DetailForm)
{
((DetailForm)frm).btnceratehtml.Enabled = false;
((DetailForm)frm).btnconfirm.Enabled = false;
//((DetailForm)frm).btnshowinfo.Enabled = false;
}
}
if (id == 0)
{
return;
}
SqlDataReader reader;
People p = new People();
p.ID = id;
reader = People.ReadById(p.ID);
while (reader.Read())
{
PeopleManipulations.ReaderToPeople(ref p, ref reader, true, true);
}
reader.Close();
DBFunction.CloseConnections();
if (GLOBALVARS.MyUser.Control == User.TypeControl.User && p.Show == (int)People.ShowTypes.Personal)
{
p.OpenForPersonalEdit = true;
}
DetailForm detail = new DetailForm(p);
if (show)
{
detail.Show(this);
}
}
public void LoadShadcanim()
{
string sql;
// string txt="";
int controlhide = 1;
GLOBALVARS.Shadchanim = new ArrayList();
GLOBALVARS.Users = new List <User>();
User u;
// cmbusers.Items.Add(new KeyValueClass("הכל", 0));
if (GLOBALVARS.MyUser.Control == User.TypeControl.Admin)
{
controlhide = 100;
}
sql = @"select u.ID,u.name,u.tel,u.email,count(r.ByUser) as d,t1.mdate,t2.mdateexit,Sector
from users u left join RegisterInfo r on u.ID=r.ByUser left join
(select l.UserId, max(l.date) mdate from log l where l.Action=1 group by l.UserId ) t1 on t1.UserId=u.ID left join
(select l.UserId, max(l.DateExit) mdateexit from log l where l.Action=1 group by l.UserId ) t2 on t2.UserId=u.ID
where u.Control<" + controlhide + @"
group by u.ID,u.name,u.tel,u.email,t1.mdate,t2.mdateexit,Sector
order by d desc";
SqlDataReader reader;
reader = DBFunction.ExecuteReader(sql);
lstchadcan.Items.Clear();
ConnetKnow = 0;
while (reader != null && reader.Read())
{
u = new User();
u.Name = (string)reader["name"];
u.ID = (int)reader["ID"];
u.Tel = (string)reader["tel"];
u.Email = (string)reader["email"];
u.Sector = (string)reader["Sector"];
if (u.Sector.Length > 0)
{
string[] s = u.Sector.Split(',');
for (int i = 0; i < s.Length; i++)
{
if (u.SectorView.Length > 0)
{
u.SectorView += ", ";
}
u.SectorView += GLOBALVARS.Sectors.ToArray()[int.Parse(s[i])].SectorName;
}
}
GLOBALVARS.Users.Add(u);
KeyValueClass temp = new KeyValueClass((string)reader["name"], (int)reader["ID"]);
GLOBALVARS.Shadchanim.Add(temp);
lstchadcan.Items.Add(new ListViewItem(new string[] { (string)reader["name"],
(string)reader["tel"], (string)reader["email"], reader["ID"].ToString(),
reader["d"].ToString(), Connect(ref reader) }, 2));
}
reader.Close();
DBFunction.CloseConnections();
if (controlhide != 1)
{
lblconnect.Visible = true;
lblconnect.Text += ConnetKnow + " מתוך " + GLOBALVARS.Shadchanim.Count;
}
}
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;
}