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