/// <summary>
/// інформація по користувачах
/// </summary>
/// <param name="query">запит</param>
/// <returns></returns>
static private /* List<Lib.User>*/ void UsersInfo(object qs)
{
List <Lib.User> list = new List <Lib.User>();
ConnectionCMD cn = new ConnectionCMD();
try
{
cn.cn.Open();
cn.cmd.CommandText = (qs as QueryStatus).query;
SqlDataReader reader = cn.cmd.ExecuteReader();
while (reader.Read())
{
Lib.User temp = new Lib.User();
temp.id = Convert.ToInt32(reader[0]);
temp.username = reader[1].ToString();
temp.photo = null;//reader[4];
temp.birthDate = Convert.ToDateTime(reader[5]);
temp.online = Convert.ToBoolean(reader[6]);
}
(qs as QueryStatus).container = reader[0];
cn.cn.Close();
(qs as QueryStatus).status = Status.Finished_True;
//return list;
}
catch (SqlException ex)
{
cn.cn.Close();
(qs as QueryStatus).container = null;
(qs as QueryStatus).status = Status.Finished_False;
}
}
static private void Execute(object x)
{
ConnectionCMD temp = x as ConnectionCMD;
try
{
temp.cn.Open();
temp.cmd.ExecuteNonQuery();
temp.cn.Close();
}
catch (SqlException ex)
{
temp.cn.Close();
throw;
}
}
/// <summary>
/// Активація та виконання запитів в базі даних
/// </summary>
/// <param name="str">запит</param>
/// <returns></returns>
static private void DBWork(object qs)
{
ConnectionCMD cn = new ConnectionCMD();
try
{
cn.cn.Open(); // запит до бд
cn.cmd.CommandText = (qs as QueryStatus).query;
cn.cmd.ExecuteNonQuery();
cn.cn.Close();
(qs as QueryStatus).status = Status.Finished_True;
}
catch (Exception e)
{
cn.cn.Close();
(qs as QueryStatus).status = Status.Finished_False;
}
}
/// <summary>
/// Метод для роботи з бд для повернення результатів
/// </summary>
/// <param name="query">запит</param>
/// <returns>зміну типу sql</returns>
static private void ReturnMethods(object qs)
{
ConnectionCMD cn = new ConnectionCMD();
try
{
cn.cn.Open();
cn.cmd.CommandText = (qs as QueryStatus).query;
SqlDataReader reader = cn.cmd.ExecuteReader();
while (reader.Read())
{
(qs as QueryStatus).container = reader[0];
}
cn.cn.Close();
(qs as QueryStatus).status = Status.Finished_True;
}
catch (SqlException ex)
{
cn.cn.Close();
(qs as QueryStatus).container = null;
(qs as QueryStatus).status = Status.Finished_False;;
}
}
