public static List<myGameRoom> GetAllGameRoom() { myGameRoomData tempADO = new myGameRoomData(); List<myGameRoom> list=new List<myGameRoom>(); DataSet tempDS = tempADO.GetAllGameRoom(); if (tempADO.HasData) { foreach (DataRow row in tempDS.Tables[0].Rows) list.Add(new myGameRoom(row)); return list; } return new List<myGameRoom>(); }
public bool InsertData() { myGameRoom n = new myGameRoom(); n.GetGameRoomByGameRoomName(myGameRoomName); if (n.GameRoomID != 0) return false; myGameRoomData data=new myGameRoomData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP;DataSet tempDS; tempP = new SqlParameter(); tempP.ParameterName = "@GameRoomName"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myGameRoomName; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempDS = data.RunProcedure("csp_InsertGameRoom", tempAL); myGameRoomID= int.Parse(tempDS.Tables[0].Rows[0][0].ToString()); foreach(myUser temp in myUser.GetUserByGameRoom(this)) temp.DeleteGameRoom(myGameRoomID); foreach(myUser temp in myUser_) temp.UpdateGameRoom(myGameRoomID); tempDS.Dispose(); return true; }
public bool UpdateData() { myGameRoom n = new myGameRoom(); n.GetGameRoomByGameRoomName(myGameRoomName); if (n.GameRoomID != 0 && n.GameRoomID != myGameRoomID){ return false;} myGameRoomData data=new myGameRoomData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP; tempP = new SqlParameter(); tempP.ParameterName = "@GameRoomID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myGameRoomID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@GameRoomName"; tempP.Size = 200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myGameRoomName; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); data.RunProcedure("csp_UpdateGameRoom", tempAL); foreach(myUser temp in myUser.GetUserByGameRoom(this)) temp.DeleteGameRoom(myGameRoomID); foreach(myUser temp in myUser_) temp.UpdateGameRoom(myGameRoomID); return true; }
public bool GetGameRoomByGameRoomName(string val) { myGameRoomData tempADO = new myGameRoomData(); DataSet tempDS = tempADO.GetGameRoomByGameRoomName(val); if (tempADO.HasData){ UpdateGameRoom(tempDS.Tables[0].Rows[0]); return true;}return false; }