public string getDetailsTsk(string id_)
{
MySqlConnection sqlConn = GetSqlConn();
outputMessage opt = new outputMessage();
Dictionary <string, string> result = new Dictionary <string, string>();
sqlConn.Open();
String strUsr = "******";
MySqlCommand instUsr = new MySqlCommand(strUsr, sqlConn);
instUsr.Parameters.AddWithValue("@id", id_);
MySqlDataReader sqlRes = instUsr.ExecuteReader();
while (sqlRes.Read())
{
try { result["id"] = (string)sqlRes["id"]; } catch (Exception e) { result["id"] = "None_id"; }
try { result["title"] = (string)sqlRes["title"]; } catch (Exception e) { result["title"] = "None_title"; }
try { result["content"] = (string)sqlRes["content"]; } catch (Exception e) { result["content"] = "None_content"; }
try { result["coin"] = (string)sqlRes["coin"]; } catch (Exception e) { result["content"] = "None_coin"; }
try { result["exp"] = (string)sqlRes["exp"]; } catch (Exception e) { result["exp"] = "None_exp"; }
try { result["owner"] = (string)sqlRes["owner"]; } catch (Exception e) { result["owner"] = "None_owner"; }
try { result["taker"] = (string)sqlRes["taker"]; } catch (Exception e) { result["taker"] = "None_taker"; }
}
opt.addResult(result);
return(opt.getString());
}
/// <summary>
/// go to find the tasks you have accepted.
/// Input: argument must have "taker".
/// Output: Outputmessage, Results are dictionary, each subDictionary is a detailed information for each dictionary
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public string getAcceptedTsk(string msg)
{
inputMessage input = new inputMessage(msg);
outputMessage output = new outputMessage();
MySqlConnection sqlConn = GetSqlConn();
try
{
sqlConn.Open();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
output.addErrorMsg("getOwnedTsk: Connection between mysql doesn't work correctly");
output.addSuccess(false);
return(output.getString());
}
string taker = input.getArg("taker");
try
{
String strsql = "SELECT * FROM taker = @taker ;";
MySqlCommand sqlComm = new MySqlCommand(strsql, sqlConn);
sqlComm.Parameters.AddWithValue("@taker", taker);
MySqlDataReader sqlRes = sqlComm.ExecuteReader();
output.addSuccess(true);
while (sqlRes.Read())
{
string id = sqlRes["id"].ToString();
string title = sqlRes["title"].ToString();
string content = (string)sqlRes["content"];
string owner = (string)sqlRes["owner"];
string coin = sqlRes["coin"].ToString();
string exp = sqlRes["exp"].ToString();
var lst = new Dictionary <string, string>();
lst["id"] = id;
lst["title"] = title;
lst["content"] = content;
lst["coin"] = coin;
lst["exp"] = exp;
lst["owner"] = owner;
output.addResult(lst);
}
}
catch (Exception ex)
{
sqlConn.Close();
Console.Write("getAcceptedTsk may can not work");
Console.Write(ex.Message);
output.addSuccess(false);
output.addErrorMsg("have problem in getAcceptedTsk");
}
return(output.getString());
}
/*
* string search(string msg)
*
* input msg is actually a inputMessage(I will do the serialize part):
* way: "searchUsr"
* argument [it is a dictionary]:
* key(string) : value(string)
* "name" : "shabi"
* "pwd" : "wo si le"
*
*
* output msg(string)
* Defining success: there is a user
* false : (1)there is no such a usr (2) the pwd is not correct
* success: True (search Success) / False (search doesn't success)
* ErrorMessage (if False) : will have the reason why it is false);
* lst (if success) : lst["result"] = a dictionary: {"name":"shabi", "pwd":"zhe shi mi ma", "coin":"#", "exp": "#"}
* (False : null):
*/
public string searchUsr(string msg)
{
inputMessage input = new inputMessage(msg);
outputMessage output = new outputMessage();
string name = "null";
string pwd = "null";
MySqlConnection sqlConn = GetSqlConn();
try
{
sqlConn.Open();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
output.addErrorMsg("addUsr: Connection between mysql doesn't work correctly" + ex.ToString());
output.addSuccess(false);
return(output.getString());
}
try
{
name = input.getArg("name");
pwd = input.getArg("pwd");
}
catch (Exception ex)
{
output.addSuccess(false);
output.addErrorMsg("name/pwd cannot be empty, Please try again");
return(output.getString());
}
try
{
String strUsr = "******";
MySqlCommand findUsr = new MySqlCommand(strUsr, sqlConn);
findUsr.Parameters.AddWithValue("@name", name);
MySqlDataReader resUsr = findUsr.ExecuteReader();
resUsr.Read();
if (resUsr.HasRows)
{
if (pwd.Equals(resUsr["pwd"]))
{
var lst = new Dictionary <string, string>();
lst.Add("name", resUsr["name"].ToString());
lst.Add("pwd", resUsr["pwd"].ToString());
lst.Add("coin", resUsr["coin"].ToString());
lst.Add("exp", resUsr["exp"].ToString());
output.addResult(lst);
output.addSuccess(true);
}
else
{
output.addSuccess(false);
output.addErrorMsg("Wrong password, please try again");
}
return(output.getString());
}
else
{
sqlConn.Close();
output.addSuccess(false);
output.addErrorMsg("Cannot find the usr, please re-enter");
return(output.getString());
}
}
catch (Exception ex)
{
sqlConn.Close();
output.addSuccess(false);
output.addErrorMsg("searchUsr has some problem, please try again or ask Developer about that");
return(output.getString());
}
}
