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