/// <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;; } }