public static String GetTopicAnswer(int TopicId)
{
String commStr = "select * from Answer where TopicId = " + TopicId;
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static bool CancelRecommandAnswer(int id)
{
String commStr = "update Answer set Recommand = 0 where id = " + id;
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool DeleteFocusPart(String UserName, String Part)
{
String commStr = "update Users set FocusPart = '" + GetMessage(UserName, "FocusPart").Replace(Part+",","") + "' where UserName = '******'";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static String GetRecommandAnswer()
{
String commStr = "select * from Answer where Recommand = 1";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static String GetUserTopic(String Author)
{
String commStr = "select * from Topic where Author = '" + Author + "'";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static String GetRecommandTopic(String Part)
{
String commStr = "select * from Topic where Recommand = 1 and Part in ('" + Part.Substring(0,Part.Length-1).Replace(",","','") + "')";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static bool ModifyMessage(int TopicId, String key, String values)
{
String commStr = "update Topic set " + key + " = '" + values + "' where id = " + TopicId;
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool DeleteTopic(int TopicId)
{
String commStr = "delete from Topic where id = "+TopicId;
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static String GetPartTopic(String Part)
{
String commStr = "select * from Topic where Part = '" + Part + "'";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static String GetAllRecommandTopic()
{
String commStr = "select * from Topic where Recommand = 1";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static bool AddPoint(String UserName, int Point)
{
String commStr = "update Users set AccumulatePoint = " + (int.Parse(GetMessage(UserName, "AccumulatePoint"))+Point) + " where UserName = '******'";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool DeleteAnswer(int id)
{
String commStr = "delete from Answer where id = " + id;
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static String GetXml(int id)
{
String commStr = "select * from Topic where id = " + id;
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static bool ModifyMessage(String UserName,String key,String values)
{
String commStr = "update Users set " + key + " = '" + values + "' where UserName = '******'";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool Login(String UserName,String Password)
{
String commStr = "select * from Users where UserName = '******' and Password = '******'";
SQL sql = new SQL();
bool f = sql.ExecuteReader(commStr).Read();
sql.Dispose();
return f;
}
public static String GetXml(String UserName)
{
String commStr = "select UserName,Email,StudentNumber,Major,AccumulatePoint,FocusPart from Users where UserName = '******'";
SQL sql = new SQL();
String ans = sql.ExecuteXml(commStr);
sql.Dispose();
return ans;
}
public static String GetMessage(int id, String key)
{
String ans = "";
String commStr = "select " + key + " from Topic where id = " + id;
SQL sql = new SQL();
SqlDataReader r = sql.ExecuteReader(commStr);
if (r == null)
return ans;
if (r.Read())
ans += r[0].ToString();
r.Close();
sql.Dispose();
return ans;
}
public static String GetMessage(String UserName,String key)
{
String ans = "";
String commStr = "select " + key + " from Users where UserName = '******'";
SQL sql = new SQL();
SqlDataReader r = sql.ExecuteReader(commStr);
if(r==null)
return ans;
if (r.Read())
ans += r[0].ToString();
r.Close();
sql.Dispose();
return ans;
}
public static int PostTopic(String Author,String Title,String Part,String Text)
{
String commStr1 = "select max(id) as lastId from Topic";
SQL sql = new SQL();
SqlDataReader r = sql.ExecuteReader(commStr1);
int id = 0;
if(r.Read())
id = int.Parse(r[0].ToString())+1;
r.Close();
String date = DateTime.Now.ToShortDateString();
String commStr2 = "insert into Topic values (" + id + ",'" + Author + "','" + date + "','"+ Title + "','" + Part + "','" + Text + "')";
sql.ExecuteNonQuery(commStr2);
sql.Dispose();
return id;
}
public static bool Register(String UserName,String Password)
{
String commStr = "insert into Users values ('" + UserName + "','" + Password + "','','','',0,'')";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool PostTopic(String Author,String Title,String Part,String Text)
{
String commStr = "insert into Topic (Author,Date,Title,Part,Text) values ('" + Author + "',getdate(),'"+ Title + "','" + Part + "','" + Text + "')";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
public static bool PostAnswer(int TopicId,String Author,String Text)
{
String commStr = "insert into Answer(TopicId,Author,Date,Text) values (" + TopicId + ",'" + Author + "',getdate(),'" + Text + "')";
SQL sql = new SQL();
bool f = sql.ExecuteNonQuery(commStr);
sql.Dispose();
return f;
}
