public static void InsertMailFormatType(MailFormatType mailFormatType)
{
SQLDataAccess.ExecuteNonQuery("INSERT INTO [Settings].[MailFormatType] (TypeName, SortOrder, Comment) VALUES (@TypeName, @SortOrder, @Comment); SELECT SCOPE_IDENTITY()",
CommandType.Text,
new SqlParameter("@TypeName", mailFormatType.TypeName),
new SqlParameter("@SortOrder", mailFormatType.SortOrder),
new SqlParameter("@Comment", mailFormatType.Comment));
}
public static void UpdateMailFormatType(MailFormatType mailFormatType)
{
SQLDataAccess.ExecuteNonQuery("UPDATE [Settings].[MailFormatType] SET TypeName = @TypeName, SortOrder = @SortOrder, Comment = @Comment WHERE (MailFormatTypeID = @MailFormatTypeID)",
CommandType.Text,
new SqlParameter("@MailFormatTypeID", mailFormatType.MailFormatTypeID),
new SqlParameter("@TypeName", mailFormatType.TypeName),
new SqlParameter("@SortOrder", mailFormatType.SortOrder),
new SqlParameter("@Comment", mailFormatType.Comment)
);
}
