public int Get(string team_id) { if (!GF.session_check()) { return(5); } usid = GF.get_usid(); if (!GF.Check_if_Admin(team_id)) { return(0); } paralist = new List <SqlParameter> { new SqlParameter("@team_id", team_id) }; try { DB_Connection.sql_insert_update(query_leave_team, paralist); } catch { return(44); } return(1); }
public Get_TeamMembers_Result Get(string Team_ID) { if (!GF.session_check()) { return(new Get_TeamMembers_Result(5)); } if (!GF.Check_if_Admin(Team_ID)) { return(new Get_TeamMembers_Result(0)); } usid = GF.get_usid(); paralist = new List <SqlParameter> { new SqlParameter("@team_id", Team_ID), new SqlParameter("@usid2", usid) }; if (!DB_Connection.O_reader.IsClosed) { DB_Connection.O_reader.Close(); } DB_Connection.O_reader = DB_Connection.sql_reader(query, paralist); if (!DB_Connection.O_reader.HasRows) { DB_Connection.O_reader.Close(); return(new Get_TeamMembers_Result(new List <Team_Member>())); } members = new List <Team_Member>(); while (DB_Connection.O_reader.Read()) { members.Add(new Team_Member(DB_Connection.O_reader.GetString(0), DB_Connection.O_reader.GetString(1) + " " + DB_Connection.O_reader.GetString(2), DB_Connection.O_reader.GetString(3))); } DB_Connection.O_reader.Close(); return(new Get_TeamMembers_Result(members)); }
public int Get(string team_id, string USID) { if (!GF.session_check()) { return(5); } if (!GF.Check_if_Admin(team_id)) { return(0); } if (USID.Equals(GF.get_usid())) { return(2); } paralist = new List <SqlParameter> { new SqlParameter("@usid", USID), new SqlParameter("@team_id", team_id) }; try { DB_Connection.sql_insert_update(query_leave_team, paralist); return(1); } catch { return(4); } }
public Report_Result Get(string USID, string Team_ID) { if (!GF.session_check()) { return(new Report_Result(5)); } usid = GF.get_usid(); this.Team_ID = Team_ID; if (USID.Equals("Me")) { this.USID = usid; } else { this.USID = USID; } if (!GF.Check_if_Admin(Team_ID)) { if (this.USID != usid) { return(new Report_Result(0)); } } Reports_list = new List <Report>(); GET_REPORTS(); return(new Report_Result(Reports_list)); }
public int Get(string USID, string Team_ID, string New_Title) { if (!GF.session_check()) { return(5); } this.USID = GF.get_usid(); if (!GF.Check_if_Admin(Team_ID)) { return(4); } paralist = new List <SqlParameter> { new SqlParameter("@ntitle", New_Title), new SqlParameter("@usid", USID), new SqlParameter("@teamid", Team_ID) }; try { DB_Connection.sql_insert_update(query, paralist); } catch { return(0); } return(1); }
public string Get(string Team_ID) { if (!GF.session_check()) { return("Error:5"); } if (!GF.Check_if_Admin(Team_ID)) { return("Error:4"); } paralist = new List <SqlParameter> { new SqlParameter("@teamid", Team_ID) }; if (!DB_Connection.O_reader.IsClosed) { DB_Connection.O_reader.Close(); } DB_Connection.O_reader = DB_Connection.sql_reader(pass_query, paralist); if (DB_Connection.O_reader == null) { return("Error:404"); } if (DB_Connection.O_reader.HasRows) { DB_Connection.O_reader.Read(); string s = DB_Connection.O_reader.GetString(0); return(s); } else { return("Error:0"); } }
public Tasks_result Get(string Team_ID) { if (!GF.session_check()) { return(new Tasks_result(5)); } if (!GF.Check_if_Admin(Team_ID)) { return(new Tasks_result(0)); } usid = GF.get_usid(); Get_Tasks(Team_ID); return(new Tasks_result(Tasks)); }