snippet.crudsave

<?xml version="1.0" encoding="utf-8" ?>
<CodeSnippets  xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
	<CodeSnippet Format="1.0.0">
		<Header>
			<Title>CrudSave</Title>
			<Shortcut>crudsave</Shortcut>
			<Description>Code snippet for Basic Saving</Description>
			<Author>AiTech Solutions</Author>
			<SnippetTypes>
				<SnippetType>Expansion</SnippetType>				
			</SnippetTypes>
		</Header>
		<Snippet>
			<Declarations>
				<Literal>
					<ID>expression</ID>
					<ToolTip>Name of Method</ToolTip>
					<Default>MyFunctionName</Default>
				</Literal>
			</Declarations>
			<Code Language="csharp"><![CDATA[var result = 0;
            var db = new SqlConnection();

            if (hasOwnDbConnection)
                db = DbConnection;
            else
                db = Connection.CreateConnection();

            try
            {
                result += ExecuteDeleteQuery(db);
                result += ExecuteUpdateQuery(db);
                result += ExecuteInsertQuery(db);

                return result != 0;
            }
            catch (Exception ex)
            {
                throw new Exception("Error Saving $expression$", ex);
            }
            finally
            {
                if (!hasOwnDbConnection)
                {
                    db.Close();db.Dispose();
                }
            }]]>
			</Code>
		</Snippet>
	</CodeSnippet>
</CodeSnippets>