$sp_ExecutefromRepository

by mtambulut

JavaScript

/*
domain.mapping > Hbm > IsValidDeliveryArea.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
  
  <sql-query name="IsValidDeliveryArea">
    <query-param name="@DeliveryArea" type="String"/>
    <return-scalar column="IsValid" type="int"/>

    exec dbo.MCF_IsValidDeliveryArea @DeliveryArea=:DeliveryArea
  </sql-query>

</hibernate-mapping>

*/

/*dbo.MCF_IsValidDeliveryArea

USE [DB_Dominos_OnlineOrder_Merge]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



ALTER PROCEDURE [dbo].[MCF_IsValidDeliveryArea]

	@DeliveryArea NVARCHAR(max)

AS
BEGIN
	DECLARE @GeoDeliveryArea geometry;

	BEGIN TRY
		SET @GeoDeliveryArea = geometry::STGeomFromText('POLYGON(('+ dbo.MCF_DeliveryAreaFormat(@DeliveryArea) + '))', 4326);
		IF @GeoDeliveryArea.STIsValid() = 1
		BEGIN
			SELECT 1 as IsValid;
		END
	END TRY
	BEGIN CATCH
		SELECT 0 as IsValid;
	END CATCH

END
GO

*/

/* repository.cs
        public bool IsValidDeliveryArea(string deliveryArea)
        {
            IList<Store> entities = null;

            IQuery query = Session.GetNamedQuery("IsValidDeliveryArea");
            if (deliveryArea != "")
                query.SetString("DeliveryArea", deliveryArea);

            var result = query.UniqueResult<int>();

            return result == 1 ? true : false;
        }
*/