public static List<myUser> GetAllUser() { myUserData tempADO = new myUserData(); List<myUser> list = new List<myUser>(); DataSet tempDS = tempADO.GetAllUser(); if (tempADO.HasData) { foreach (DataRow row in tempDS.Tables[0].Rows) list.Add(new myUser(row)); return list; } return new List<myUser>(); }
public void UpdateGameRoom(int val) { myUserData tempADO = new myUserData(); tempADO.UpdateUserByGameRoomID(val, UserID); }
public bool UpdateData() { myUser n = new myUser(); n.GetUserBySessionID(mySessionID); if (n.UserID != 0 && n.UserID != myUserID) { return false; } n = new myUser(); n.GetUserByUserName(myUserName); if (n.UserID != 0 && n.UserID != myUserID) { return false; } myUserData data = new myUserData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP; tempP = new SqlParameter(); tempP.ParameterName = "@UserID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myUserID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@SessionID"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = mySessionID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@UserName"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myUserName; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@Password"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myPassword; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); data.RunProcedure("csp_UpdateUser", tempAL); return true; }
public bool InsertData() { myUser n = new myUser(); n.GetUserBySessionID(mySessionID); if (n.UserID != 0) return false; n = new myUser(); n.GetUserByUserName(myUserName); if (n.UserID != 0) return false; myUserData data = new myUserData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP; DataSet tempDS; tempP = new SqlParameter(); tempP.ParameterName = "@SessionID"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = mySessionID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@UserName"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myUserName; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@Password"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myPassword; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempDS = data.RunProcedure("csp_InsertUser", tempAL); myUserID = int.Parse(tempDS.Tables[0].Rows[0][0].ToString()); tempDS.Dispose(); return true; }
public bool GetUserByUserName(string val) { myUserData tempADO = new myUserData(); DataSet tempDS = tempADO.GetUserByUserName(val); if (tempADO.HasData) { UpdateUser(tempDS.Tables[0].Rows[0]); return true; } return false; }
public static List<myUser> GetUserByGameRoom(myGameRoom val) { myUserData tempADO = new myUserData(); List<myUser> list = new List<myUser>(); DataSet tempDS = tempADO.GetUserByGameRoomID(val.GameRoomID); if (tempADO.HasData) { foreach (DataRow row in tempDS.Tables[0].Rows) list.Add(new myUser(row)); return list; } return new List<myUser>(); }