using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.Odbc;

namespace ATTP_WS
{
    /// <summary>
    /// Summary description for OrderService
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class OrderService : System.Web.Services.WebService
    {
        [WebMethod]
        public bool TestOrderAmt(int storeNum, int orderId, double amt)
        {
            bool ret = false;
            string query = "";

            try
            {
                DataTable results = new DataTable("OrderResult");

                OdbcConnection odbc = new OdbcConnection();
                odbc.ConnectionString = "DSN=xfODBC";
                odbc.Open();

                query = "SELECT * FROM POSHDR WHERE PSTOR=" + storeNum.ToString() + " AND PORDR=" + orderId.ToString();
                OdbcCommand cmd = new OdbcCommand(query, odbc);
                OdbcDataReader r = cmd.ExecuteReader();
                results.Load(r);
                cmd.Dispose();
                r.Dispose();

                if (results.Rows.Count > 0)
                {
                    double actualAmt = double.Parse(results.Rows[0]["PPAMT"].ToString());

                    if (amt == actualAmt)
                        ret = true;
                }
            }
            catch (Exception ex)
            {
                ret = true;
            }

            return ret;
        }

        [WebMethod]
        public bool DoesOrderExist(int storeNum, int orderId)
        {
            bool ret = false;
            string query = "";

            try
            {
                DataTable results = new DataTable("OrderResult");

                OdbcConnection odbc = new OdbcConnection();
                odbc.ConnectionString = "DSN=xfODBC";
                odbc.Open();

                query = "SELECT * FROM POSHDR WHERE PSTOR=" + storeNum.ToString() + " AND PORDR=" + orderId.ToString();
                OdbcCommand cmd = new OdbcCommand(query, odbc);
                OdbcDataReader r = cmd.ExecuteReader();
                results.Load(r);
                cmd.Dispose();
                r.Dispose();

                if (results.Rows.Count > 0)
                    ret = true;
            }
            catch (Exception ex)
            {
                ret = true;
            }

            return ret;
        }
    }
}