public bool DeleteProtectedData(ProtectedDataObject protectedData)
{
try
{
Config.Conn.Execute("DELETE FROM dat_ProtectedData WHERE ProtectedDataId = @ProtectedDataId", protectedData);
}
catch (Exception ex)
{
ErrorLogObject.LogError("ProtectedDataObject::DeleteProtectedData", ex);
return(false);
}
return(true);
}
public ProtectedDataObject SaveProtectedData(ProtectedDataObject protectedData)
{
if (protectedData.ProtectedDataId.HasValue) // Update
{
string sql = @"
UPDATE dat_ProtectedData
SET SortMainId = @SortMainId,
Crada = @Crada,
Description = @Description,
ReleaseDate = @ReleaseDate,
ExemptNumber = @ExemptNumber
WHERE ProtectedDataId = @ProtectedDataId";
Config.Conn.Execute(sql, protectedData);
}
else
{
string sql = @"
INSERT INTO dat_ProtectedData (
SortMainId,
Crada,
Description,
ReleaseDate,
ExemptNumber
)
VALUES (
@SortMainId,
@Crada,
@Description,
@ReleaseDate,
@ExemptNumber
)
SELECT CAST(SCOPE_IDENTITY() AS INT)";
protectedData.ProtectedDataId = Config.Conn.Query <int>(sql, protectedData).Single();
}
return(protectedData);
}