using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FrameworkDAL.Query.WebServiceParameter
{
    public class WebServiceParameterQB
    {

        public const string GET_WEBSERVICEPARAMETER = @"SELECT
                                                        WEBSERVICEPARAMETERID AS WebServiceParameterId,
                                                        WEBSERVICEID AS WebServiceId,
                                                        SLNO AS WebServiceParameterSlNo,
                                                        PARAMETERNAME AS WebServiceParameterParameterName,
                                                        PARAMETERDATATYPE AS WebServiceParameterParameterDataType,
                                                        PARAMETERDESCRIPTION AS WebServiceParameterParameterDescription,
                                                        ISCOMPULSARY AS WebServiceParameterIsCompulsory
                                                    FROM MWEBSERVICEPARAMETER
                                                    WHERE WEBSERVICEPARAMETERID = @webserviceparameterid;";

        public const string SAVE_WEBSERVICEPARAMETER = @"INSERT INTO MWEBSERVICEPARAMETER
                                                        (
                                                            WEBSERVICEPARAMETERID,
                                                            WEBSERVICEID,
                                                            SLNO,
                                                            PARAMETERNAME,
                                                            PARAMETERDATATYPE,
                                                            PARAMETERDESCRIPTION,
                                                            ISCOMPULSARY
                                                        )
                                                        VALUES
                                                        (
                                                            @WebServiceParameterId,
                                                            @WebServiceId,
                                                            @WebServiceParameterSlNo,
                                                            @WebServiceParameterParameterName,
                                                            @WebServiceParameterParameterDataType,
                                                            @WebServiceParameterParameterDescription,
                                                            @WebServiceParameterIsCompulsory
                                                        );"; 

        public const string UPDATE_WEBSERVICEPARAMETER = @"UPDATE MWEBSERVICEPARAMETER
                                                        SET
                                                            WEBSERVICEID = @WebServiceId,
                                                            SLNO = @WebServiceParameterSlNo,
                                                            PARAMETERNAME = @WebServiceParameterParameterName,
                                                            PARAMETERDATATYPE = @WebServiceParameterParameterDataType,
                                                            PARAMETERDESCRIPTION = @WebServiceParameterParameterDescription,
                                                            ISCOMPULSARY = @WebServiceParameterIsCompulsory
                                                        WHERE
                                                            WEBSERVICEPARAMETERID = @WebServiceParameterId;";

        public const string DELETE_WEBSERVICEPARAMETER = @"DELETE FROM MWEBSERVICEPARAMETER
                                                            WHERE WEBSERVICEPARAMETERID = @webserviceparameterid;";
    }
}