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