public returned Get(string Team_ID)
{
if (!GF.session_check())
{
return(new returned(5));
}
if (!GF.Check_if_Joined(Team_ID))
{
return(new returned(4));
}
paralist = new List <SqlParameter>
{
new SqlParameter("@teamid", Team_ID)
};
DB_Connection.O_reader = DB_Connection.sql_reader(Admin_NameQ, paralist);
if (DB_Connection.O_reader == null)
{
return(new returned(404));
}
DB_Connection.O_reader.Read();
String A_NM = DB_Connection.O_reader.GetString(0) + " " + DB_Connection.O_reader.GetString(1);
DB_Connection.O_reader.Close();
return(new returned(A_NM));
}
public int Get(string team_id, string password, string Title)
{
if (!GF.session_check())
{
return(5);
}
usid = GF.get_usid();
paralist = new List <SqlParameter>();
paralist.Add(new SqlParameter("@tm_id", team_id));
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(0);//team Id wrong
}
DB_Connection.O_reader.Read();
if (!DB_Connection.O_reader.GetString(1).Equals(password))
{
DB_Connection.O_reader.Close();
return(2);//password wrong
}
DB_Connection.O_reader.Close();
if (GF.Check_if_Joined(team_id))
{
return(3);
}
paralist = new List <SqlParameter>
{
new SqlParameter("@usid", usid),
new SqlParameter("@team_id", team_id),
new SqlParameter("@title", Title)
};
try
{
DB_Connection.sql_insert_update(query_add_team, paralist);
return(1);
}
catch
{
return(4);
}
}
public Ann_Result Get(string Team_ID)
{
if (!GF.session_check())
{
return(new Ann_Result(5));
}
User_Id = GF.get_usid();
if (GF.Check_if_Joined(Team_ID))
{
return(new Ann_Result(Get_Ann(Team_ID)));
}
else
{
return(new Ann_Result(0));
}
}
public int Get(string Team_ID, string Task_Name, string Desc, string Date, string R_C)
{
if (!GF.session_check())
{
return(5);
}
if (!GF.Check_if_Joined(Team_ID))
{
return(4);
}
usid = GF.get_usid();
this.Team_ID = Team_ID;
this.Task_Name = Task_Name;
while (true)
{
R_UUID = Guid.NewGuid().ToString();
if (check_id(R_UUID))
{
break;
}
}
DateTime R;
try { R = DateTime.Parse(Date); }
catch
{
R = DateTime.Now;
}
DateTime S = R.Date;
S = S.AddHours(R.Hour); S = S.AddMinutes(R.Minute); S = S.AddSeconds(R.Second);
try
{
Report_Content = JsonConvert.DeserializeObject <List <Day> >(R_C.Replace("\\\"", "\""));
}
catch (Newtonsoft.Json.JsonException e)
{
Report_Content = new List <Day>();
}
if (!Check_Task_f())
{
Insert_Task();
}
foreach (Day x in Report_Content)
{
k += (int)x.Hours;
}
paralist = new List <SqlParameter>
{
new SqlParameter("@rid", R_UUID),
new SqlParameter("@usid", usid),
new SqlParameter("@team_id", Team_ID),
new SqlParameter("@date", S),
new SqlParameter("@hours", k),
new SqlParameter("@desc", Desc),
new SqlParameter("@task_n", Task_Name)
};
Query = add_Report_1;
foreach (Day x in Report_Content)
{
para1 = "@parai" + i;
para2 = "@paraii" + i;
paralist.Add(new SqlParameter(para1, ((int)x.Hours)));
paralist.Add(new SqlParameter(para2, x.Date));
Query += add_Report_2 + para1 + "," + para2 + ");";
i++;
}
Query += add_Report_3;
try
{
if (DB_Connection.sql_insert_update(Query, paralist))
{
return(1);
}
return(0);
}
catch
{
return(0);
}
}
