public void AddCharacter(Character character)
{
SqlConnection sqlConnection = new SqlConnection(connectioString);
string sqlInsert = @"INSERT INTO [dbo].[skpCharacter] VALUES('" + character.Name + "'," + character.GeneralExperience + "," + character.KrdExperience + ")";
SqlDataReader dataReader = null;
try
{
sqlConnection.Open();
SqlCommand command = new SqlCommand(sqlInsert, sqlConnection);
command.ExecuteNonQuery();
}
finally
{
if (sqlConnection != null)
{
sqlConnection.Close();
}
}
try
{
sqlConnection.Open();
SqlCommand selectId = new SqlCommand(@"SELECT CharacterId FROM [dbo].[skpCharacter] WHERE Name='" + character.Name + "'", sqlConnection);
dataReader = selectId.ExecuteReader();
while (dataReader.Read())
{
string sqlInsertSkill = null;
var id = dataReader[0];
foreach (var skill in character.Skills)
{
sqlInsertSkill += String.Format(@"INSERT INTO [dbo].[Skill] VALUES ('{0}','{1}',{2}),", skill.Name, skill.Value, id);
}
sqlInsertSkill = sqlInsertSkill.Remove(sqlInsertSkill.LastIndexOf(','));
SqlCommand insertSkill = new SqlCommand(sqlInsertSkill, sqlConnection);
insertSkill.ExecuteNonQuery();
}
}
finally
{
if (dataReader != null)
{
dataReader.Close();
}
if (sqlConnection != null)
{
sqlConnection.Close();
}
}
}
static void Main(string[] args)
{
var character = new Character(new CharacterParameters("test2",2,2,Character.DefaultSkills()));
SqlConnection sqlConnection = new SqlConnection(connectioString);
string sqlInsert = @"INSERT INTO [dbo].[skpCharacter] VALUES('" + character.Name + "'," + character.GeneralExperience + "," + character.KrdExperience + ")";
try
{
sqlConnection.Open();
SqlCommand command = new SqlCommand(sqlInsert, sqlConnection);
command.ExecuteNonQuery();
}
finally
{
if (sqlConnection != null)
{
sqlConnection.Close();
}
}
try
{
sqlConnection.Open();
SqlCommand selectId = new SqlCommand(@"SELECT CharacterId FROM [dbo].[skpCharacter] WHERE Name='" + character.Name + "'", sqlConnection);
var dataReader = selectId.ExecuteReader();
dataReader.Read();
string sqlInsertSkill = null;
var id = dataReader[0];
dataReader.Close();
foreach (var skill in character.Skills)
{
sqlInsertSkill += String.Format(@"INSERT INTO [dbo].[Skill] VALUES ('{0}','{1}',{2}) ", skill.Name, skill.Value, id);
}
SqlCommand insertSkill = new SqlCommand(sqlInsertSkill, sqlConnection);
insertSkill.ExecuteNonQuery();
}
finally
{
if (sqlConnection != null)
{
sqlConnection.Close();
}
}
}
public bool AddCharacter(Character character)
{
throw new System.NotImplementedException();
}
public CharacterDetailsForm(Character character)
{
InitializeComponent();
dataGridView1.DataSource = character._skills;
}
