public List <CharacterListItem> GetCharactersByLocationId(int locationId)
{
List <CharacterListItem> result = new List <CharacterListItem>();
using (var ctx = new ApplicationDbContext())
{
var query =
ctx.Locations
.Single(e => e.Id == locationId);
foreach (Character c in query.ListOfCharacters)
{
CharacterListItem e = new CharacterListItem();
e.Affiliation = c.Affiliation;
e.Age = c.Age;
e.CharacterId = c.CharacterId;
e.CharacterName = c.CharacterName;
e.GameId = c.GameId;
e.HistoryId = c.HistoryId;
e.IsHostile = c.IsHostile;
e.IsNPC = c.IsNPC;
e.SpeciesId = c.SpeciesId;
result.Add(e);
}
return(result);
}
}
public bool UpdateCharacter(CharacterListItem model)
{
using (var ctx = new ApplicationDbContext())
{
var query =
ctx
.Characters
.SingleOrDefault(e => e.CharacterId == model.CharacterId);
if (query != null)
{
query.CharacterName = model.CharacterName;
query.Age = model.Age;
query.Affiliation = model.Affiliation;
query.IsNPC = model.IsNPC;
query.IsHostile = model.IsHostile;
query.SpeciesId = model.SpeciesId;
query.GameId = model.GameId;
query.HistoryId = model.HistoryId;
return(ctx.SaveChanges() == 1);
}
else
{
return(false);
}
}
}
public List <CharacterListItem> GenerateTeamById(int teamId)
{
using (var ctx = new ApplicationDbContext())
{
var characters = new List <CharacterListItem>();
var query =
ctx
.TeamCharacters
.Where(q => q.TeamId == teamId)
.ToList();
foreach (var item in query)
{
var character = new CharacterListItem
{
CharacterId = item.CharacterId,
CharacterName = item.Character.CharacterName,
House = item.Character.House,
ImageLink = item.Character.ImageLink
};
characters.Add(character);
}
return(characters);
}
}
public IEnumerable <CharacterListItem> GetAllCharactersByVaultId(int vaultId)
{
List <CharacterListItem> result = new List <CharacterListItem>();
using (var ctx = new ApplicationDbContext())
{
var foundItems =
ctx.Vaults.Single(c => c.Id == vaultId);
foreach (Character c in foundItems.ListOfCharacters)
{
CharacterListItem e = new CharacterListItem();
e.CharacterId = c.CharacterId;
e.CharacterName = c.CharacterName;
e.Age = c.Age;
e.Affiliation = c.Affiliation;
e.IsNPC = c.IsNPC;
e.IsHostile = c.IsHostile;
e.SpeciesId = c.SpeciesId;
e.GameId = c.GameId;
e.HistoryId = c.HistoryId;
result.Add(e);
}
return(result);
}
}
private void OnCharacterSelected(CharacterListItem value)
{
Connecting = true;
chatManager = Mvx.GetSingleton <IChatManager>();
chatManager.Connected += OnChatManagerConnected;
chatManager.Connect(value.Name, Host);
}
void CreateItems()
{
ClearItems();
foreach (CharacterRecord character in characterTable.response.records)
{
CharacterListItem item = Instantiate(characterListItem, transform.position, transform.rotation, transform);
item.character = character;
}
}
public virtual CharacterListItem BuilderCharacterListItem()
{
CharacterListItem item = new CharacterListItem()
{
Id = Id,
Class = Class,
Name = Name,
Level = Level,
Sex = Sex
};
return(item);
}
// 使用Newtonsoft.Json 序列化/反序列化
void HowToUseNewtonsoft()
{
var product = new CharacterListItem();
product.Id = 0;
product.Name = "haha";
//将Product对象转换为Json字符串
string json = JsonConvert.SerializeObject(product);
//Debug.Log(json);
//将Json字符串转换为CharacterListItem类对象
var Object = JsonConvert.DeserializeObject <CharacterListItem>(json);
//Debug.Log(Object.Name);
}
public IHttpActionResult Put(CharacterListItem model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var service = CreateCharacterService();
if (!service.UpdateCharacter(model))
{
return(InternalServerError());
}
return(Ok());
}
public CharacterListItem GetCharacterById(int characterId)
{
CharacterListItem result = new CharacterListItem();
using (var ctx = new ApplicationDbContext())
{
var query =
ctx
.Characters
.Single(b => b.CharacterId == characterId);
result.CharacterId = query.CharacterId;
result.CharacterName = query.CharacterName;
result.Age = query.Age;
result.Affiliation = query.Affiliation;
result.IsNPC = query.IsNPC;
result.IsHostile = query.IsHostile;
result.SpeciesId = query.SpeciesId;
result.GameId = query.GameId;
result.HistoryId = query.HistoryId;
return(result);
}
}
public void SelectedItem(CharacterListItem currentSelectedItem, IPlayerHasCharacters selectedItem)
{
this.currentSelectedItem = currentSelectedItem;
}
