public override string ToString()
{
return("ID: " + CharacterRelationshipID.ToString() +
" CharacterID: " + CharacterID.ToString() +
" RelationCharacterID: " + RelationCharacterID.ToString() +
" RelationTypeID: " + RelationTypeID.ToString());
}
///TODO JLB Fix cPicture Save to use cUtilities
/// <summary>
/// Save an picture record to the database. Use this if you have a connection open.
/// </summary>
/// <param name="sUserUpdating">Name of the user who is saving the record.</param>
public void Save(string sUserUpdating)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
if (RecordStatus == RecordStatuses.Delete)
{
SortedList sParams = new SortedList();
sParams.Add("@CharacterItemID", ItemPictureID.ToString());
cUtilities.LoadDataTable("uspDelCHCharacterItem", sParams, "LARportal", "", lsRoutineName);
}
else
{
SortedList sParams = new SortedList();
sParams.Add("@CharacterItemID", ItemPictureID.ToString());
sParams.Add("@CharacterID", CharacterID.ToString());
sParams.Add("@ItemDescription", ItemDescription);
sParams.Add("@ItemPictureID", ItemPictureID.ToString());
DataTable dtItem = new DataTable();
dtItem = cUtilities.LoadDataTable("uspInsUpdCHCharacterItems", sParams, "LARportal", "", lsRoutineName);
foreach (DataRow dRow in dtItem.Rows)
{
int ItemID;
if (int.TryParse(dRow["CharacterItemID"].ToString(), out ItemID))
{
CharacterItemID = ItemID;
}
}
}
}
private void btn_Search_Click(object sender, EventArgs e)
{
int CharacterID;
try
{
CharacterID = int.Parse(txt_CharacterID.Text);
if (CharacterID > 0 && CharacterID < 2139)
{
FindCharacter(CharacterID.ToString());
}
else
{
MessageBox.Show("The Character ID entered is not valid, please try again!");
}
}
catch (FormatException)
{
MessageBox.Show("The Character ID entered is not valid, please try again!");
}
}
public override string ToString()
{
return(CharacterID.ToString() + ": " + ClassID.ToString() + " // lv" + Level.ToString() + " exp" + Experience.ToString());
}
public CharacterEquipment SaveCharacterEquipment()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdate_CharacterEquipment";
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterEquipmentID", SqlDbType.Int, CharacterEquipmentID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, CharacterID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@EquipmentID", SqlDbType.Int, EquipmentID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Notes", SqlDbType.VarChar, Notes, 100));
command.Parameters.Add(dbconn.GenerateParameterObj("@Quantity", SqlDbType.Int, Quantity.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterLevelArmor", SqlDbType.Int, CharacterLevelArmor.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@AbilityMod", SqlDbType.Int, AbilityMod.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@ClassMod", SqlDbType.Int, ClassMod.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@RaceMod", SqlDbType.Int, RaceMod.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@FeatTalentMod", SqlDbType.Int, FeatTalentMod.ToString(), 0));
// command.Parameters.Add(dbconn.GenerateParameterObj("@MiscellaneousMod", SqlDbType.Int, MiscellaneousMod.ToString(), 0));
result = command.ExecuteReader();
result.Read();
SetReaderToObject(ref result);
}
catch
{
Exception e = new Exception();
this._insertUpdateOK = false;
this._insertUpdateMessage.Append(e.Message.ToString());
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this);
}
/// <summary>
/// Saves the character class level.
/// </summary>
/// <returns>CharacterWeapon Object</returns>
public CharacterWeapon SaveCharacterWeapon()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdate_CharacterWeapon";
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterWeaponID", SqlDbType.Int, CharacterWeaponID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, CharacterID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@WeaponID", SqlDbType.Int, WeaponID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@RangeAttackBonus", SqlDbType.Int, RangeAttackBonus.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@RangeDamageBonus", SqlDbType.Int, RangeDamageBonus.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@MeleeAttackBonus", SqlDbType.Int, MeleeAttackBonus.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@MeleeDamageBonus", SqlDbType.Int, MeleeDamageBonus.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Notes", SqlDbType.VarChar, Notes.ToString(), 100));
result = command.ExecuteReader();
result.Read();
SetReaderToObject(ref result);
}
catch
{
Exception e = new Exception();
this._insertUpdateOK = false;
this._insertUpdateMessage.Append(e.Message + " Inner Exception= " + e.InnerException);
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this);
}
/// <summary>
/// Delete the CharacterWeapon.
/// </summary>
/// <returns>Boolean</returns>
public bool DeleteCharacterWeapon()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Delete_CharacterWeapon";
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, CharacterID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@WeaponID", SqlDbType.Int, WeaponID.ToString(), 0));
result = command.ExecuteReader();
}
catch
{
Exception e = new Exception();
this._deleteOK = false;
this._deletionMessage.Append(e.Message + " Inner Exception= " + e.InnerException);
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this.DeleteOK);
}
/// <summary>
/// Saves the character class level.
/// </summary>
/// <returns>CharacterSkill Object</returns>
public CharacterSkill SaveCharacterSkill()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdate_CharacterSkill";
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, CharacterID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@SkillID", SqlDbType.Int, SkillID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@HalfLevel", SqlDbType.Int, HalfLevel.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@AbilityMod", SqlDbType.Int, AbilityMod.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Trained", SqlDbType.Int, Trained.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@SkillFocus", SqlDbType.Int, SkillFocus.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Miscellaneous", SqlDbType.Int, Miscellaneous.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@FeatTalentMod", SqlDbType.Int, FeatTalentMod.ToString(), 0));
result = command.ExecuteReader();
result.Read();
SetReaderToObject(ref result);
}
catch
{
Exception e = new Exception();
this._insertUpdateOK = false;
this._insertUpdateMessage.Append(e.Message + " Inner Exception= " + e.InnerException);
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this);
}
public void LoadTexture(CharacterID characterID)
{
textures[characterID.ToString()] = contentManager.Load <Texture2D>(characterID.ToString());
}
// 画像のサイズを持ってくる
public Vector2 GetHalfSize(CharacterID characterID)
{
return(new Vector2(textures[characterID.ToString()].Width / 2, textures[characterID.ToString()].Height));
}
public void DrawTexture(CharacterID name, Vector2 position, Color color)
{
spriteBatch.Draw(textures[name.ToString()], position, color);
}
public CharacterAbility SaveCharacterAbility()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdate_CharacterAbility";
command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, CharacterID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@AbilityID", SqlDbType.Int, AbilityID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Score", SqlDbType.Int, Score.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ScoreMod", SqlDbType.Int, ScoreMod.ToString(), 0));
result = command.ExecuteReader();
result.Read();
SetReaderToObject(ref result);
}
catch
{
Exception e = new Exception();
this._insertUpdateOK = false;
this._insertUpdateMessage.Append(e.Message.ToString());
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this);
}