public static string[] get_user_information(string user_id, int month, int year_number) { current_user CurrentUser = new current_user(user_id); string[] list_befor_month; string[] list_curent_month; string[] list_after_month; list_curent_month = CurrentUser.get_records_for_month(month, year_number); if (month != 1) { list_befor_month = CurrentUser.get_records_for_month(month - 1, year_number); } else { list_befor_month = CurrentUser.get_records_for_month(12, year_number - 1); } if (month != 12) { list_after_month = CurrentUser.get_records_for_month(month + 1, year_number); } else { list_after_month = CurrentUser.get_records_for_month(1, year_number + 1); } string[] finish_arr = CurrentUser.get_information(list_befor_month, list_curent_month, list_after_month, month, year_number); return(finish_arr); }
public static int session_time(int day, int month, int year, int sec, int min, int hour, string id) { int count_sec = 0; int count_min = 0; int count_hour = 0; int count_day = 0; user_time time_current = new user_time(day, month, year, sec, min, hour); database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); List <string> list; list = Database.get_from_datebase("data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec", "user_session", "where user_id='" + CurrentUser.Get_user_id() + "' and start_status='1'"); if (list.LongCount() == 6) { int Day = int.Parse(list[0]); int Month = int.Parse(list[1]); int Year = int.Parse(list[2]); int Hour = int.Parse(list[3]); int Min = int.Parse(list[4]); int Sec = int.Parse(list[5]); user_time time_in_datebase = new user_time(Day, Month, Year, Sec, Min, Hour); user_time different = new user_time(); different = time_in_datebase; count_day = different.day_difference(time_current); count_hour = time_current.Get_hour() - time_in_datebase.Get_hour(); count_min = time_current.Get_min() - time_in_datebase.Get_min(); count_sec = time_current.Get_sec() - time_in_datebase.Get_sec(); count_sec = count_sec + (count_min + (count_hour + count_day * 24) * 60) * 60; } save_session_time(count_sec, id); return(count_sec); }
public void update_user_recording(current_user CurrentUser, string[] time_start_befor, string[] time_finish_befor, string[] time_start_after, string[] time_finish_after) { try { string sql = string.Format("UPDATE user_recording set data_start_Day=" + time_start_after[2] + ", data_start_Month=" + time_start_after[1] + ", data_start_Year=" + time_start_after[0] + ", data_start_Min=" + time_start_after[4] + ", data_start_Hour=" + time_start_after[3] + ", data_finish_Day=" + time_finish_after[2] + ", data_finish_Month=" + time_finish_after[1] + ", data_finish_Year=" + time_finish_after[0] + ", data_finish_Min=" + time_finish_after[4] + ", data_finish_Hour=" + time_finish_after[3] + ", type_created='Edit'" + " where user_id='" + CurrentUser.Get_user_id() + "' and " + "data_start_Day=" + time_start_befor[2] + " and data_start_Month=" + time_start_befor[1] + " and data_start_Year=" + time_start_befor[0] + " and data_start_Min=" + time_start_befor[4] + " and data_start_Hour=" + time_start_befor[3] + " and data_finish_Day=" + time_finish_befor[2] + " and data_finish_Month=" + time_finish_befor[1] + " and data_finish_Year=" + time_finish_befor[0] + " and data_finish_Min=" + time_finish_befor[4] + " and data_finish_Hour=" + time_finish_befor[3]); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } } catch (SqlException) { } }
// вставить запись сессии после нажатия кнопки старт public void insert_datbase_session_start(current_user CurrentUser, user_time time, database Database) { bool start = true; bool finish = false; bool connection = true; int finish_time = 0; try { List <string> list; list = Database.get_from_datebase("data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec", "user_session", "where user_id='" + CurrentUser.Get_user_id() + "' and start_status='1'"); if (list == null || list.LongCount() == 0) { string sql = string.Format("Insert Into user_session " + "(user_id, start_status, finish_status, connection_status, data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec, data_finish_Day, data_finish_Month, data_finish_Year, data_finish_Sec, data_finish_Min, data_finish_Hour)Values('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}', '{8}','{9}','{10}','{11}','{12}','{13}', '{14}', '{15}')", CurrentUser.Get_user_id(), start, finish, connection, time.Get_day(), time.Get_month(), time.Get_year(), time.Get_hour(), time.Get_min(), time.Get_sec(), finish_time, finish_time, finish_time, finish_time, finish_time, finish_time); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } insert_datebase_session_on_file(CurrentUser, time, Database); } } catch (SqlException ex) { } }
public static void delete_session_time(string id) { database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); Database.delete_datebase("user_session", "where user_id='" + id + "' and start_status='0'"); Database.close_connection(); }
private static void save_session_time(int count_sec, string id) { database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); Database.update_datebase_session_time_count(count_sec, CurrentUser); Database.close_connection(); }
public static void create_session(int day, int month, int year, int sec, int min, int hour, string id) { current_user CurrentUser = new current_user(id); database Database = new database(); user_time time = new user_time(day, month, year, sec, min, hour); Database.open_connection(); Database.insert_datbase_session_start(CurrentUser, time, Database); Database.close_connection(); }
public static void session_finish(string id, int day, int month, int year, int sec, int min, int hour) { current_user CurrentUser = new current_user(id); database Database = new database(); Database.open_connection(); user_time time = new user_time(day, month, year, sec, min, hour); Database.update_datebase_user_session_finish(CurrentUser, time); Database.close_connection(); }
public static bool check_is_user(string id) { bool boolean = false; database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); boolean = CurrentUser.function_registration_check(Database); Database.close_connection(); return(boolean); }
public static bool start_status(string id) { bool boolean = false; database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); boolean = Database.session_button(CurrentUser); Database.close_connection(); return(boolean); }
public static string[] generation_table(string id) { current_user CurrentUser = new current_user(id); database _database_ = new database(); _database_.open_connection(); List <string> list; list = _database_.get_from_datebase("data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec, data_finish_Day, data_finish_Month, data_finish_Year, data_finish_Hour, data_finish_Min, data_finish_Sec, count_hours_all, count_hours_for_day, type_created", "user_recording", "where user_id='" + CurrentUser.Get_user_id() + "'"); string[] arr = list.ToArray(); string[] finalarr = new string[(list.LongCount() / 15) * 4]; int k = arr.Length / 15; int j = 0; for (int i = 0; i < arr.Length / 15; i++) { //минути if (int.Parse(arr[i + k * 4]) < 10) { arr[i + k * 4] = "0" + arr[i + k * 4]; } if (int.Parse(arr[i + k * 10]) < 10) { arr[i + k * 10] = "0" + arr[i + k * 10]; } //месяц if (int.Parse(arr[i + k]) < 10) { arr[i + k] = "0" + arr[i + k]; } if (int.Parse(arr[i + k * 7]) < 10) { arr[i + k * 7] = "0" + arr[i + k * 7]; } //секунди /*if (int.Parse(arr[i + k * 5]) < 10) * arr[i + k * 5] = "0" + arr[i + k * 5]; * if (int.Parse(arr[i + k * 11]) < 10) * arr[i + k * 11] = "0" + arr[i + k * 11]; * */ finalarr[j + 0] = arr[i] + "." + arr[i + k] + "." + arr[i + 2 * k] + " " + arr[i + k * 3] + ":" + arr[i + k * 4]; finalarr[j + 1] = arr[i + k * 6] + "." + arr[i + k * 7] + "." + arr[i + k * 8] + " " + arr[i + k * 9] + ":" + arr[i + k * 10]; //finalarr[j + 0] = arr[i] + "." + arr[i + k] + "." + arr[i + 2 * k] + " " + arr[i + k * 3] + ":" + arr[i + k * 4] + ":" + arr[i + k * 5]; // finalarr[j + 1] = arr[i + k * 6] + "." + arr[i + k * 7] + "." + arr[i + k * 8] + " " + arr[i + k * 9] + ":" + arr[i + k * 10] + ":" + arr[i + k * 11]; finalarr[j + 2] = arr[i + k * 12] = countInterval(arr, k, i); finalarr[j + 3] = arr[i + k * 14]; j += 4; } _database_.close_connection(); return(finalarr); }
// обновить что-то в базе public void update_datebase_user_session_finish_on_file(current_user user, user_time time) { string sql = string.Format("UPDATE user_recording" + " " + "set data_finish_Day=" + time.Get_day() + ", data_finish_Month=" + time.Get_month() + ", data_finish_Year=" + time.Get_year() + ", data_finish_Sec=" + time.Get_sec() + ", data_finish_Min=" + time.Get_min() + ", data_finish_Hour=" + time.Get_hour() + " " + "where user_id='" + user.Get_user_id() + "'" + " and data_finish_Hour=0;"); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } }
public static bool initialization(string id, string first_name, string last_name, string email, string type) { bool boolean = false; current_user CurrentUser = new current_user(id, first_name, last_name, email); database Database = new database(); Database.open_connection(); if (type == "registration") { boolean = CurrentUser.function_registration(Database); } Database.close_connection(); return(boolean); }
public bool initialization_login(string id, string type) { bool boolean = false; current_user CurrentUser = new current_user(id); database Database = new database(); Database.open_connection(); if (type == "login") { boolean = CurrentUser.function_registration_check(Database); } Database.close_connection(); return(boolean); }
// обновить запись сессии (количество времени после нажатия кнопки старт) public void update_datebase_session_time_count(int counts, current_user CurrentUser) { try { string sql = string.Format("UPDATE user_session" + " " + "set data_timer=" + counts + " " + "where user_id='" + CurrentUser.Get_user_id() + "'" + ";"); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } } catch (SqlException ex) { } }
// обновить запись сессии после нажатия кнопки стоп public void update_datebase_user_session_finish(current_user user, user_time time) { try { string sql = string.Format("UPDATE user_session" + " " + "set data_finish_Day=" + time.Get_day() + ", data_finish_Month=" + time.Get_month() + ", data_finish_Year=" + time.Get_year() + ", data_finish_Sec=" + time.Get_sec() + ", data_finish_Min=" + time.Get_min() + ", data_finish_Hour=" + time.Get_hour() + ", finish_status='true'" + ", " + "start_status='false'" + " " + "where user_id='" + user.Get_user_id() + "'" + ";"); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } update_datebase_user_session_finish_on_file(user, time); } catch (SqlException ex) { } }
// вставить записи в табличку записей public void insert_datebase_session_on_file(current_user CurrentUser, user_time time, database Database) { int finish_time = 0; int count_hours_all = 0; int count_hours_for_day = 0; string type_created = "button"; try { string sql = string.Format("Insert Into user_recording " + "(user_id, data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec, data_finish_Day, data_finish_Month, data_finish_Year, data_finish_Sec, data_finish_Min, data_finish_Hour, type_created, count_hours_all, count_hours_for_day)Values('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}', '{8}','{9}','{10}','{11}','{12}', '{13}', '{14}', '{15}')", CurrentUser.Get_user_id(), time.Get_day(), time.Get_month(), time.Get_year(), time.Get_hour(), time.Get_min(), time.Get_sec(), finish_time, finish_time, finish_time, finish_time, finish_time, finish_time, type_created, count_hours_all, count_hours_for_day); using (SqlCommand cmd = new SqlCommand(sql, this.connect)) { cmd.ExecuteNonQuery(); } } catch (SqlException ex) { } }
public static void changeEditStatus(string id, string[] time_start_after, string[] time_finish_after, string[] time_start_befor, string[] time_finish_befor) { database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); Database.update_user_recording(CurrentUser, time_start_befor, time_finish_befor, time_start_after, time_finish_after); /*string aa = "reg"; * //UPDATE SET type_created = 'reg' where user_id='665603526895217' * Database.update_datebase("user_recording","SET type_created = '123'" + "where user_id='1392912441014483'"); * //and data_stop_Month='"+old1[1]+"' and data_stop_Day='"+old1[2]+"' and data_stop_Hour='"+old1[3]+"' and data_stop_Min="+old1[4]+"'and data_stop_Year='"+old2[0]+"' and data_stop_Month='"+old2[1]+"' and data_stop_Day='"+old2[2]+"' and data_stop_Hour='"+old2[3]+"' and data_stop_Min="+old2[4]+"'"); * * // string sql = string.Format("UPDATE user_recording" + " " +"set type_created='" + aa + "'"+"where user_id='1392912441014483'"); */ Database.close_connection(); }
// статус кнопок public bool session_button(current_user CurrentUser) { bool boolean = false; List <string> list; list = get_from_datebase("start_status", "user_session", "where user_id='" + CurrentUser.Get_user_id() + "' and start_status='true'"); if (list == null) { boolean = false; } else if (list.LongCount() > 0) { boolean = true; } else { boolean = false; } return(boolean); }
public static bool checkTimeDelete(string id, int day, int month, int year, int sec, int min, int hour) { bool boolean = false; database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); user_time time_curent = new user_time(day, month, year, sec, min, hour); List <string> list; list = Database.get_from_datebase("data_start_Day, data_start_Month, data_start_Year, data_start_Hour, data_start_Min, data_start_Sec", "user_session", "where user_id='" + CurrentUser.Get_user_id() + "'"); if (list != null) { if (list.LongCount() != 0) { user_time time_start = new user_time(int.Parse(list[0]), int.Parse(list[1]), int.Parse(list[2]), int.Parse(list[5]), int.Parse(list[4]), int.Parse(list[3])); user_time different = new user_time(); different = time_start; int count_day = different.day_difference(time_curent); int count_hour = time_curent.Get_hour() - time_start.Get_hour(); int count_min = time_curent.Get_min() - time_start.Get_min(); int count_sec = time_curent.Get_sec() - time_start.Get_sec(); count_sec = count_sec + (count_min + (count_hour + count_day * 24) * 60) * 60; if (count_sec < 60) { Database.delete_datebase("user_recording", "where user_id='" + id + "' and data_finish_Day='0'"); boolean = true; } } } Database.close_connection(); return(boolean); }
public bool check_is_user_and_connected(string id) { bool boolean = false; database _database_ = new database(); _database_.open_connection(); current_user CurrentUser = new current_user(id); bool registration_check = false; registration_check = CurrentUser.function_registration_check(_database_); bool authorization_check = false; authorization_check = CurrentUser.function_authorization_check(_database_); if (registration_check == true && authorization_check == true) { boolean = true; } else { boolean = false; } _database_.close_connection(); return(boolean); }
public int get_timer_time(user_time time, current_user CurrentUser, database Database) { int timer = 0; return(timer); }