public int Insert(KeysAddRequest data) { int keyId = 0; string storeProc = "[dbo].[Keys_Insert]"; _dataProvider.ExecuteNonQuery(storeProc , delegate(SqlParameterCollection sqlParams) { sqlParams.AddWithValue("@KeyName", data.KeyName); sqlParams.AddWithValue("@Value", data.Value); sqlParams.AddWithValue("@DataTypeId", data.DataTypeId); sqlParams.AddWithValue("@IsSecured", data.IsSecured); sqlParams.AddWithValue("@ModifiedBy", data.ModifiedBy); SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int); idParameter.Direction = System.Data.ParameterDirection.Output; sqlParams.Add(idParameter); }, returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@Id"].Value.ToString(), out keyId); } ); return(keyId); }
public void Update(KeysAddRequest data) { if (data == null) { throw new ArgumentNullException("A parameter data is required!"); } string storeProc = "[dbo].[Keys_Update]"; _dataProvider.ExecuteNonQuery(storeProc , delegate(SqlParameterCollection sqlParams) { sqlParams.AddWithValue("@KeyName", data.KeyName); sqlParams.AddWithValue("@Value", data.Value); sqlParams.AddWithValue("@DataTypeId", data.DataTypeId); sqlParams.AddWithValue("@IsSecured", data.IsSecured); sqlParams.AddWithValue("@ModifiedBy", data.ModifiedBy); }); }