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