/// <summary>
/// Sets the reader to the parameter Force Technique object..
/// </summary>
/// <param name="objForceTechnique">The object force Technique.</param>
/// <param name="result">SqlDataReader</param>
private void SetReaderToObject(ref ForceTechnique objForceTechnique, ref SqlDataReader result)
{
if (result.HasRows)
{
objForceTechnique.ForceTechniqueID = (int)result.GetValue(result.GetOrdinal("ForceTechniqueID"));
objForceTechnique.ForceTechniqueName = result.GetValue(result.GetOrdinal("ForceTechniqueName")).ToString();
objForceTechnique.ForceTechniqueDescription = result.GetValue(result.GetOrdinal("ForceTechniqueDescription")).ToString();
}
}
/// <summary>
/// Clones the specified LST ForceTechnique.
/// </summary>
/// <param name="lstForceTechnique">The LST ForceTechnique.</param>
/// <returns>List<ForceTechnique></returns>
static public List <ForceTechnique> Clone(List <ForceTechnique> lstForceTechnique)
{
List <ForceTechnique> lstCForceTechnique = new List <ForceTechnique>();
foreach (ForceTechnique objForceTechnique in lstForceTechnique)
{
lstCForceTechnique.Add(ForceTechnique.Clone(objForceTechnique));
}
return(lstCForceTechnique);
}
/// <summary>
/// Gets the force Technique list.
/// </summary>
/// <param name="strSprocName">Name of the string sproc.</param>
/// <param name="strWhere">The string where.</param>
/// <param name="strOrderBy">The string order by.</param>
/// <returns> List<ForceTechnique></returns>
private List <ForceTechnique> GetForceTechniqueList(string strSprocName, string strWhere, string strOrderBy)
{
List <ForceTechnique> ForceTechniques = new List <ForceTechnique>();
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 = strSprocName;
command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000));
command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000));
result = command.ExecuteReader();
while (result.Read())
{
ForceTechnique objForceTechnique = new ForceTechnique();
SetReaderToObject(ref objForceTechnique, ref result);
ForceTechniques.Add(objForceTechnique);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(ForceTechniques);
}
/// <summary>
/// Saves the ClassLevelInfo.
/// </summary>
/// <returns>ClassLevelInfo Object</returns>
public ClassLevelInfo SaveClassLevelInfo()
{
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_ClassLevel";
command.Parameters.Add(dbconn.GenerateParameterObj("@ClassLevelID", SqlDbType.Int, ClassLevelID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ClassID", SqlDbType.Int, ClassID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ClassLevel", SqlDbType.Int, ClassLevel.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@BonusFeat", SqlDbType.Int, BonusFeat.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@Talent", SqlDbType.Int, Talent.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@BaseAttack", SqlDbType.Int, BaseAttack.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ForcePointBase", SqlDbType.Int, ForcePointBase.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ForceTechnique", SqlDbType.Int, ForceTechnique.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@ForceSecret", SqlDbType.Int, ForceSecret.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@MedicalSecret", SqlDbType.Int, MedicalSecret.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);
}
/// <summary>
/// Clones the specified object ForceTechnique.
/// </summary>
/// <param name="objForceTechnique">The object ForceTechnique.</param>
/// <returns>ForceTechnique</returns>
static public ForceTechnique Clone(ForceTechnique objForceTechnique)
{
ForceTechnique objCForceTechnique = new ForceTechnique(objForceTechnique.ForceTechniqueID);
return(objCForceTechnique);
}
