public ActionResult CreateCharacter(CharacterPO form)
{
ActionResult response = null;
if ((Int64)Session["RoleID"] >= 2)
{
CharacterMap map = new CharacterMap();
if (ModelState.IsValid)
{
CharacterDO characterObject = map.CharacterPOToDO(form);
dl.CreateCharacter(characterObject);
response = RedirectToAction("CharacterIndex", new { gameID = form.GameID });
}
else
{
ViewBag.gameID = form.GameID;
response = View(form);
}
}
else
{
response = RedirectToAction("CharacterIndex", new { gameID = form.GameID });
}
return(response);
}
public void UpdateCharacter(CharacterDO characterObject)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("UPDATE_CHARACTER", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@characterID", characterObject.CharacterID);
command.Parameters.AddWithValue("@firstName", characterObject.FirstName);
command.Parameters.AddWithValue("@lastName", characterObject.LastName);
command.Parameters.AddWithValue("@gameID", characterObject.GameID);
command.Parameters.AddWithValue("@alignment", characterObject.Alignment);
command.Parameters.AddWithValue("@weaponOfChoice", characterObject.WeaponOfChoice);
command.Parameters.AddWithValue("@bio", characterObject.Bio);
command.Parameters.AddWithValue("@maleOrFemale", characterObject.MaleOrFemale);
command.ExecuteNonQuery();
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "UpdateCharacter", "DAL", "Error");
}
}
public CharacterBO GetCharacter(int _characterID)
{
CharacterDO retval = dataContext.GetCharacterDOByID(_characterID);
if (retval == null)
{
return(null);
}
return(new CharacterBO(retval));
}
public CharacterPO CharacterDOToPO(CharacterDO characterDO)
{
CharacterPO po = new CharacterPO();
po.CharacterID = characterDO.CharacterID;
po.FirstName = characterDO.FirstName;
po.LastName = characterDO.LastName;
po.GameID = characterDO.GameID;
po.Alignment = characterDO.Alignment;
po.WeaponOfChoice = characterDO.WeaponOfChoice;
po.Bio = characterDO.Bio;
po.MaleOrFemale = characterDO.MaleOrFemale;
return(po);
}
public CharacterDO CharacterPOToDO(CharacterPO po)
{
CharacterDO characterDO = new CharacterDO();
characterDO.CharacterID = po.CharacterID;
characterDO.FirstName = po.FirstName;
characterDO.LastName = po.LastName;
characterDO.GameID = po.GameID;
characterDO.Alignment = po.Alignment;
characterDO.WeaponOfChoice = po.WeaponOfChoice;
characterDO.Bio = po.Bio;
characterDO.MaleOrFemale = po.MaleOrFemale;
return(characterDO);
}
// Constructor to map a DataAccessLayer object to a BusinessLogicLayer object
public CharacterBO(CharacterDO _characterDO)
{
CharacterID = _characterDO.CharacterID;
Name = _characterDO.Name;
Class = _characterDO.Class;
AC = _characterDO.AC;
Strength = _characterDO.Strength;
Dexterity = _characterDO.Dexterity;
Constitution = _characterDO.Constitution;
Intelligence = _characterDO.Intelligence;
Wisdom = _characterDO.Wisdom;
Charisma = _characterDO.Charisma;
Description = _characterDO.Description;
SeriesID_FK = _characterDO.SeriesID_FK;
}
public ActionResult UpdateCharacter(Int64 characterID, long gameId)
{
ActionResult response = null;
if ((Int64)Session["RoleID"] >= 2)
{
ViewBag.GameID = gameId;
CharacterMap map = new CharacterMap();
CharacterDO characterObject = dl.ViewCharacterByID(characterID);
CharacterPO form = map.CharacterDOToPO(characterObject);
response = View(form);
}
else
{
response = RedirectToAction("CharacterIndex", new { gameID = gameId });
}
return(response);
}
public List <CharacterDO> ViewCharactersByGame(Int64 gameID)
{
List <CharacterDO> characterList = new List <CharacterDO>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("VIEW_CHARACTERS_BY_GAME_ID", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@gameID", gameID);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
CharacterDO characterObject = new CharacterDO();
characterObject.CharacterID = reader.GetInt64(0);
characterObject.FirstName = reader.GetString(1);
characterObject.LastName = reader.GetString(2);
characterObject.GameID = reader.GetInt64(3);
characterObject.Alignment = reader.GetString(4);
characterObject.WeaponOfChoice = reader.GetString(5);
characterObject.Bio = reader.GetString(6);
if (!reader.IsDBNull(7))
{
characterObject.MaleOrFemale = reader.GetString(7);
}
else
{
}
characterList.Add(characterObject);
}
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "ViewCharacterByGame", "DAL", "Error");
}
return(characterList);
}
public CharacterDO ViewCharacterByID(Int64 characterID)
{
CharacterDO characterObject = new CharacterDO();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("VIEW_CHARACTER_BY_ID", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@characterID", characterID);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
characterObject.FirstName = reader.GetString(0);
characterObject.LastName = reader.GetString(1);
characterObject.Alignment = reader.GetString(2);
characterObject.WeaponOfChoice = reader.GetString(3);
characterObject.Bio = reader.GetString(4);
if (!reader.IsDBNull(5))
{
characterObject.MaleOrFemale = reader.GetString(5);
}
else
{
}
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "ViewCharacterByID", "DAL", "Error");
}
return(characterObject);
}
