/// <summary>
/// do the update statement
/// </summary>
private void DOTemp()
{
if (TempLst.CheckedItems.Count <= 0)
{
MessageBox.Show("לא נבחרו שורות", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
general = personal = false;
return;
}
string sql = "", AllSql = "";
sql = "update peoples set Temp='false'";
if (personal)
{
sql += ", Show=5,Chadchan='" + ShadchanHandler + "'";
}
sql += " where ID=";
int i = TempLst.CheckedObjects.Count - 1;
int nChecked = -1;
//loop for creta string of all updates with length untill 7500 chars
//to avoid exception of 'index out of range'
while (i > nChecked)
{
for (; i > nChecked && AllSql.Length < 7450; i--)
{
People p = TempLst.CheckedObjects[i] as People;
AllSql += sql + p.ID.ToString() + "; ";
TempLst.RemoveObject(TempLst.CheckedObjects[i]);
}
bool succees = DBFunction.Execute(AllSql);
AllSql = "";
}
TempbtnPersonalCancel_Click(new object(), new EventArgs());
}
private void TempLoad()
{
string sql = "";
sql = " select firstname,lastname,sexs,age,City,Eda,Background,DadWork,Status, p.id," +
"LearnStatus,Temp, pd.schools,MomWork,WorkPlace,r.ByUserName,r.RegDate"
+ " from peoples p inner join peopledetails pd on p.ID=pd.relatedid inner join RegisterInfo r on pd.relatedid=r.relatedid where Temp= 'true' ";
SqlDataReader reader = DBFunction.ExecuteReader(sql);
List <People> peoples = new List <People>();
while (reader.Read())
{
People p = new People();
PeopleManipulations.ConvertTempPeople(ref reader, ref p);
peoples.Add(p);
}
TempLst.BeginUpdate();
TempLst.SetObjects(peoples);
TempLst.EndUpdate();
reader.Close();
}
