public bool DeleteOpenNet(OpenNetObject openNet)
{
try
{
Config.Conn.Execute("DELETE FROM dat_OpenNet WHERE OpenNetId = @OpenNetId", openNet);
}
catch (Exception ex)
{
ErrorLogObject.LogError("OpenNetObject::DeleteOpenNet", ex);
return(false);
}
return(true);
}
public OpenNetObject SaveOpenNet(OpenNetObject openNet)
{
if (openNet.OpenNetId.HasValue) // Update
{
string sql = @"
UPDATE dat_OpenNet
SET SortMainId = @SortMainId,
AccessNumber = @AccessNumber,
DocLocation = @DocLocation,
FieldOfficeAym = @FieldOfficeAym,
DeclassificationStatus = @DeclassificationStatus,
DeclassificationDate = @DeclassificationDate,
KeyWords = @KeyWords
WHERE OpenNetId = @OpenNetId";
Config.Conn.Execute(sql, openNet);
}
else
{
string sql = @"
INSERT INTO dat_OpenNet (
SortMainId,
AccessNumber,
DocLocation,
FieldOfficeAym,
DeclassificationStatus,
DeclassificationDate,
KeyWords
)
VALUES (
@SortMainId,
@AccessNumber,
@DocLocation,
@FieldOfficeAym,
@DeclassificationStatus,
@DeclassificationDate,
@KeyWords
)
SELECT CAST(SCOPE_IDENTITY() AS INT)";
openNet.OpenNetId = Config.Conn.Query <int>(sql, openNet).Single();
}
return(openNet);
}
