private static void AddCommonParams(ExternalLinkAddRequest model, SqlParameterCollection col) { col.AddWithValue("@UserId", model.UserId); col.AddWithValue("@UrlTypeId", model.UrlTypeId); col.AddWithValue("@Url", model.Url); col.AddWithValue("@EntityId", model.EntityId); col.AddWithValue("@EntityTypeId", model.EntityTypeId); }
public int Add(ExternalLinkAddRequest model) { int id = 0; string procName = "[dbo].[ExternalLinks_Insert]"; _dataProvider.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { AddCommonParams(model, col); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCollection) { object oId = returnCollection["@Id"].Value; int.TryParse(oId.ToString(), out id); }); return(id); }