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; }