public static int Insert(CharacterAddRequest model) { int id = 0; using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "dbo.Character_Insert"; MapCommonCharacterParameters(model, cmd); SqlParameter outputId = new SqlParameter("@Id", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; cmd.Parameters.Add(outputId); cmd.ExecuteNonQuery(); id = (int)outputId.Value; } conn.Close(); } return(id); }
private static void AddValues(CharacterAddRequest model, SqlCommand cmd) { cmd.Parameters.AddWithValue("@Name", model.Name); cmd.Parameters.AddWithValue("@TypeId", model.TypeId); cmd.Parameters.AddWithValue("@SpeciesId", model.SpeciesId); cmd.Parameters.AddWithValue("@GenderId", model.GenderId); cmd.Parameters.AddWithValue("@SideId", model.SideId); cmd.Parameters.AddWithValue("@Tier2", model.Tier2); cmd.Parameters.AddWithValue("@PhysicalAtk", model.PhysicalAtk); cmd.Parameters.AddWithValue("@EnergyAtk", model.EnergyAtk); cmd.Parameters.AddWithValue("@AtkSpeed", model.AtkSpeed); cmd.Parameters.AddWithValue("@CritRate", model.CritRate); cmd.Parameters.AddWithValue("@CritDmg", model.CritDmg); cmd.Parameters.AddWithValue("@IgnoreDef", model.IgnoreDef); cmd.Parameters.AddWithValue("@IgnoreDodge", model.IgnoreDodge); cmd.Parameters.AddWithValue("@FireDmg", model.FireDmg); cmd.Parameters.AddWithValue("@ColdDmg", model.ColdDmg); cmd.Parameters.AddWithValue("@LightningDmg", model.LightningDmg); cmd.Parameters.AddWithValue("@PoisonDmg", model.PoisonDmg); cmd.Parameters.AddWithValue("@MindDmg", model.MindDmg); cmd.Parameters.AddWithValue("@PhysicalDef", model.PhysicalDef); cmd.Parameters.AddWithValue("@EnergyDef", model.EnergyDef); cmd.Parameters.AddWithValue("@HP", model.HP); cmd.Parameters.AddWithValue("@RecoveryRate", model.RecoveryRate); cmd.Parameters.AddWithValue("@Dodge", model.Dodge); cmd.Parameters.AddWithValue("@FireResist", model.FireResist); cmd.Parameters.AddWithValue("@ColdResist", model.ColdResist); cmd.Parameters.AddWithValue("@LightningResist", model.LightningResist); cmd.Parameters.AddWithValue("@PoisonResist", model.PoisonResist); cmd.Parameters.AddWithValue("@MindResist", model.MindResist); cmd.Parameters.AddWithValue("@MoveSpd", model.MoveSpd); cmd.Parameters.AddWithValue("@Debuff", model.Debuff); cmd.Parameters.AddWithValue("@SkillCooldown", model.SkillCooldown); }
private static void MapCommonCharacterParameters(CharacterAddRequest model, SqlCommand cmd) { cmd.Parameters.AddWithValue("@Name", model.Name); cmd.Parameters.AddWithValue("@Want", model.Want); cmd.Parameters.AddWithValue("@Need", model.Need); cmd.Parameters.AddWithValue("@Biography", model.Biography); cmd.Parameters.AddWithValue("@ProjectId", model.ProjectId); }
public HttpResponseMessage Insert(CharacterAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = CharacterService.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage Post(CharacterAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <int> response = new ItemResponse <int>(); response.Item = svc.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int Insert(CharacterAddRequest model) { int id = 0; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("Character_Insert", conn)) { cmd.CommandType = CommandType.StoredProcedure; AddValues(model, cmd); SqlParameter param = new SqlParameter("@Id", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); id = (int)cmd.Parameters["@Id"].Value; } conn.Close(); } return(id); }