public static string EditProfile(string jSonUserRecToEditProfile) //OK { string retValue = string.Empty; foreach (DataRow dr in jsonStringToTable(jSonUserRecToEditProfile).Rows) { UserDataObj user = new UserDataObj(); user.UserID = long.Parse(dr["userID"].ToString()); user.Username = dr["username"].ToString(); user.Password = dr["password"].ToString(); UserReps userRps = new UserReps(); userRps.Update(user); retValue = GetAsJson_Simple("userID", user.UserID.ToString()); } return(retValue); }
public static string SignUp(string UserDataToAdd) //OK { string retValue = string.Empty; foreach (DataRow dr in jsonStringToTable(UserDataToAdd).Rows) { // New User will be added to database UserDataObj user = new UserDataObj(); user.Username = dr["username"].ToString(); user.Password = dr["password"].ToString(); user.Point = 100; //Default UserReps userRps = new UserReps(); userRps.Insert(user); retValue = CnvDataTableToJsonString(userRps.Athenticate(user)); } return(retValue); }
//// Update Point //public void UpdatePoint(string userID, int pointToAdd) //{ // string strCmd = string.Format("Update public.\"{0}\" set \"point\" = \"point\" + {1} where \"userID\" = {2}", TblName, pointToAdd.ToString(), userID); // using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) // { // cmd.ExecuteNonQuery(); // } //} // Set Admin and add Point public void SetAdminUpdatePoint(UserDataObj user, int pointToAdd) { string strCmd = string.Format("Update public.\"{0}\" set \"isAdmin\" = 1, \"point\" = \"point\" + {1} where \"userID\" = {2}", TblName, pointToAdd.ToString(), user.UserID.ToString()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { cmd.ExecuteNonQuery(); } }
public static string IsUserAdmin(string userID) //OK { UserDataObj user = new UserDataObj(); user.UserID = long.Parse(userID); return(new UserReps().IsUserAdmin(user)); }
public static string GetUserRec(string json_userID) //OK { long userID = long.Parse(GetSingleValueFromJson(json_userID, "userID")); UserDataObj user = new UserDataObj(); user.UserID = userID; DataTable dtPlayers = new UserReps().GetUserRec(user); return(CnvDataTableToJsonString(dtPlayers)); }
public PartialViewResult UserDetail() { var user = new UserDataSettings().GetUserData(); if (user == null) { user = new UserDataObj(); } //parentRepeater.DataSource = rst; //parentRepeater.DataBind(); return(PartialView(user)); }
public string IsUserAdmin(UserDataObj user) //OK { string retVaue = "false"; string strCmd = string.Format("select \"isAdmin\" from public.\"{0}\" where \"userID\" = {1} ", TblName, user.UserID.ToString()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { retVaue = cmd.ExecuteScalar().ToString().Trim(); } return(retVaue); }
public UserDataObj Insert(UserDataObj user) //OK { string strCmd = string.Format("Insert into public.\"{0}\" (username, password, set, point, \"isAdmin\") values ( '{1}', '{2}', '{3}', {4}, '0') ", TblName, user.Username.Trim(), user.Password.Trim(), user.Set, user.Point); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { cmd.ExecuteNonQuery(); cmd.CommandText = string.Format("select max(\"userID\") from public.\"{0}\" ", TblName); user.UserID = (long)cmd.ExecuteScalar(); } return(user); }
public DataTable Athenticate(UserDataObj user) { var dataTable = new DataTable(); string strCmd = string.Format("select * from public.\"{0}\" where ltrim(rtrim(username)) = '{1}' and ltrim(rtrim(password)) = '{2}' ", TblName, user.Username.Trim(), user.Password.Trim()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { using (NpgsqlDataReader reader = cmd.ExecuteReader()) { dataTable.Load(reader); } } return(dataTable); }
public DataTable GetUserRec(UserDataObj user) //OK { var dataTable = new DataTable(); string strCmd = string.Format("select * from public.\"{0}\" where \"userID\" = {1} ", TblName, user.UserID.ToString()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { using (NpgsqlDataReader reader = cmd.ExecuteReader()) { dataTable.Load(reader); } } return(dataTable); }
public void Update(UserDataObj user) //OK { //string strCmd = "Update public.\"Users\" set username = @username, name=@name, password=@password where \"userID\" = @userID"; string strCmd = string.Format("Update public.\"{0}\" set username = '******', password = '******' where \"userID\" = {2}", TblName, user.Username.Trim(), user.Password.Trim(), user.UserID.ToString()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { //cmd.Parameters.AddWithValue("@userID", this.UserID); //cmd.Parameters.AddWithValue("@username", this.Username ); //cmd.Parameters.AddWithValue("@password", this.Password ); cmd.ExecuteNonQuery(); } }
// Define Set / Update Set public string UpdateSet(UserDataObj user) //OK { string retValue = " Your Set added succesfully"; try { string strCmd = string.Format("Update public.\"{0}\" set set = '{1}' where \"userID\" = {2}", TblName, user.Set.Trim(), user.UserID.ToString()); using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection())) { cmd.ExecuteNonQuery(); } } catch (Exception ex) { retValue = ex.Message; } return(retValue); }
// Define Set public static string DefineSet(string jSonUserRecToDefineSet) //OK { string retValue = string.Empty; UserDataObj user = new UserDataObj(); foreach (DataRow dr in jsonStringToTable(jSonUserRecToDefineSet).Rows) { user.UserID = long.Parse(dr["userID"].ToString()); user.Set = dr["set"].ToString(); retValue = new UserReps().UpdateSet(user); } return(retValue); }
public string SignIn(string UserDataToSignIn) //OK { string retValue = string.Empty; foreach (DataRow dr in jsonStringToTable(UserDataToSignIn).Rows) { UserDataObj user = new UserDataObj(); user.Username = dr["username"].ToString(); user.Password = dr["password"].ToString(); UserReps userRps = new UserReps(); userRps.Athenticate(user); retValue = JSonUtil_Server.CnvDataTableToJsonString(userRps.Athenticate(user)); } return(retValue); }
public static string StartToPlay() { if (BattleSupport.log != string.Empty) { return(BattleSupport.log); } new UserReps().ResetAllAdmin(); string log = " \r\n"; string padLeft = ""; TPlayerDataObj tPlayer = new TPlayerDataObj(); tPlayer.UserID = 0; DataTable dtPlayers = new TPlayersReps().GetPlayers(tPlayer); dtPlayers.Columns.Add("score", typeof(int)); foreach (DataRow dr in dtPlayers.Rows) { dr["score"] = 0; } int cnt = dtPlayers.Rows.Count; for (int i = 1; i < cnt; i++) { for (int j = 1; i + j < cnt + 1; j++) { int result = Fight(dtPlayers.Rows[i - 1]["set"].ToString(), dtPlayers.Rows[i - 1 + j]["set"].ToString()); if (result == 1) { dtPlayers.Rows[i - 1]["score"] = int.Parse(dtPlayers.Rows[i - 1]["score"].ToString()) + 1; log += dtPlayers.Rows[i - 1]["username"].ToString() + " defeated " + dtPlayers.Rows[i - 1 + j]["username"].ToString() + " \r\n"; } else if (result == 2) { dtPlayers.Rows[i - 1 + j]["score"] = int.Parse(dtPlayers.Rows[i - 1 + j]["score"].ToString()) + 1; log += padLeft + padLeft + dtPlayers.Rows[i - 1 + j]["username"].ToString() + " defeated " + dtPlayers.Rows[i - 1]["username"].ToString() + " \r\n"; } else // 0 { log += padLeft + "draw between " + dtPlayers.Rows[i - 1 + j]["username"].ToString() + " and " + dtPlayers.Rows[i - 1]["username"].ToString() + " \r\n"; } } } int indexOfMaxScore = 0; int maxScore = int.Parse(dtPlayers.Rows[0]["score"].ToString()); for (int i = 1; i < dtPlayers.Rows.Count; i++) { int nextScore = int.Parse(dtPlayers.Rows[i]["score"].ToString()); if (nextScore > maxScore) { maxScore = nextScore; indexOfMaxScore = i; } } string winerUserID = dtPlayers.Rows[indexOfMaxScore]["userID"].ToString(); UserDataObj user = new UserDataObj(); user.UserID = long.Parse(winerUserID); new UserReps().SetAdminUpdatePoint(user, 5); log += Environment.NewLine; log += "---------------------------------------------------------------" + Environment.NewLine; log += padLeft + dtPlayers.Rows[indexOfMaxScore]["username"].ToString() + " has won the Tournament and is now the Administator" + Environment.NewLine; log += "---------------------------------------------------------------" + Environment.NewLine; // Players.EmptyTournament(); BattleSupport.log = log; return(log); }