using RestSharp;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace HiranandaniCommunities.nri_fortune_city
{
    public partial class index : System.Web.UI.Page
    {
        DataTable dt = new DataTable();
        public static string Source = "";
        public static string utm_source = "";
        public static string utm_medium = "";
        public static string utm_content = "";
        public static string utm_campaign = "";
        public static string utm_term = "";
        public static string utm_adgroup = "";
        public static string utm_ad = "";
        public static string utm_keyword = "";

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Source = Request.QueryString["Source"];
                utm_source = Request.QueryString["utm_source"];
                Session["utm_source"] = utm_source;
                utm_medium = Request.QueryString["utm_medium"];
                utm_content = Request.QueryString["utm_content"];
                utm_campaign = Request.QueryString["utm_campaign"];
                utm_term = Request.QueryString["utm_term"];
                utm_keyword = Request.QueryString["keyword"];
                utm_adgroup = Request.QueryString["utm_adgroup"];
                utm_ad = Request.QueryString["utm_ad"];


            }
        }

        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            var data = string.Empty;

            //if (utm_content != null)
            //{
            //    if (!utm_content.Contains("affiliate"))
            //        data = GenerateLeadSalesDoMain(txtName.Text, txtEmail.Text, txtMobile.Text, utm_content);
            //}
            //else if (utm_content == null)
            //{
            //    data = GenerateLeadSalesDoMain(txtName.Text, txtEmail.Text, txtMobile.Text, utm_content);
            //}

            List<Tuple<string, string>> parametersList = new List<Tuple<string, string>>();
            parametersList.Add(new Tuple<string, string>("@Name", txtName.Text));
            parametersList.Add(new Tuple<string, string>("@Mobile", txtMobile.Text));
            parametersList.Add(new Tuple<string, string>("@Email", txtEmail.Text));
            parametersList.Add(new Tuple<string, string>("@Configuration", ddlConfiguration.SelectedValue));
            parametersList.Add(new Tuple<string, string>("@source", Source));
            parametersList.Add(new Tuple<string, string>("@utm_source", utm_source));
            parametersList.Add(new Tuple<string, string>("@utm_medium", utm_medium));
            parametersList.Add(new Tuple<string, string>("@utm_campaign", utm_campaign));
            parametersList.Add(new Tuple<string, string>("@utm_content", utm_content));
            parametersList.Add(new Tuple<string, string>("@utm_keyword", utm_keyword));
            parametersList.Add(new Tuple<string, string>("@pageSource", "NRIFortuneCity"));
            parametersList.Add(new Tuple<string, string>("@SRDStatus", data));
            parametersList.Add(new Tuple<string, string>("@PageName", "Mobile"));
            parametersList.Add(new Tuple<string, string>("@utm_term", utm_term));
            parametersList.Add(new Tuple<string, string>("@FormType", "Phase22"));
            parametersList.Add(new Tuple<string, string>("@ISDCode", txtISDCode.Text));
            var SaveData = SaveDataByStoredProcedure("sp_SaveLandingPageDetails", "HiranandaniPanvelPhase16", parametersList);
            if (SaveData > 0)
            {
                ////SendDataToCRM();
                //ClearFields();
                //Response.Redirect("thank-you.html");

                ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alertMessage", "PostLead('201911141244101726814643630787065dccfec22e188362369953','" + txtName.Text + "','" + txtMobile.Text + "','" + txtEmail.Text + "','" + ddlConfiguration.SelectedValue + "','','HFC_EBrochure');", true);
                Response.Redirect("thank-you.html");


            }
        }

        private void ClearFields()
        {
            txtName.Text = string.Empty;
            txtEmail.Text = string.Empty;
            txtMobile.Text = string.Empty;
            ddlConfiguration.ClearSelection();
        }

        public static int SaveDataByStoredProcedure(string procedureName, string connectionStringName, IEnumerable<Tuple<string, string>> parametersList = null)
        {
            SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString);
            int result = 0;
            try
            {
                sqlConnection.Open();
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(procedureName, sqlConnection);
                sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                if (parametersList != null)
                {
                    foreach (var item in parametersList)
                        sqlDataAdapter.SelectCommand.Parameters.AddWithValue(item.Item1, item.Item2);
                }
                result = sqlDataAdapter.SelectCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
                //Do something
            }
            finally
            {
                if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed && sqlConnection.State != ConnectionState.Broken)
                    sqlConnection.Close();
            }
            return result;
        }

        public static string GenerateLeadSalesDoMain(string name, string email, string phone, string utm_content)
        {
            System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls | System.Net.SecurityProtocolType.Ssl3;
            ServicePointManager.Expect100Continue = true;
            ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;

            string SRDID = string.Empty;
            if (!string.IsNullOrWhiteSpace(utm_content))
            {
                if (utm_content.ToLower() == "brand_ad_1")
                    SRDID = "a2Y2v0000059Zux";
                else if (utm_content.ToLower() == "brand_ad_2")
                    SRDID = "a2Y2v0000059Zv2";
                else if (utm_content.ToLower() == "brand_ad_3")
                    SRDID = "a2Y2v0000059Zv7";
                else if (utm_content.ToLower() == "brand_ad_4")
                    SRDID = "a2Y2v0000059ZvC";
                else if (utm_content.ToLower() == "brand_ad_5")
                    SRDID = "a2Y2v0000059ZvH";
                else if (utm_content.ToLower() == "generic_ad_1")
                    SRDID = "a2Y2v0000059ZvM";
                else if (utm_content.ToLower() == "generic_ad_2")
                    SRDID = "a2Y2v0000059ZvR";
                else if (utm_content.ToLower() == "generic_ad_3")
                    SRDID = "a2Y2v0000059ZvW";
                else if (utm_source.ToLower() == "generic_ad_4")
                    SRDID = "a2Y2v0000059Zvb";
                else if (utm_source.ToLower() == "1bhk_ad_1")
                    SRDID = "a2Y2v0000059Zvg";
                else if (utm_source.ToLower() == "1bhk_ad_2")
                    SRDID = "a2Y2v0000059Zvl";
                else if (utm_source.ToLower() == "2bhk_ad_1")
                    SRDID = "a2Y2v0000059Zvq";
                else if (utm_source.ToLower() == "2bhk_ad_2")
                    SRDID = "a2Y2v0000059Zvv";
                else if (utm_source.ToLower() == "competitor_ad_1")
                    SRDID = "a2Y2v0000059Zw0";
                else if (utm_source.ToLower() == "competitor_ad_2")
                    SRDID = "a2Y2v0000059Zw5";
                else if (utm_source.ToLower() == "competitor_ad_3")
                    SRDID = "a2Y2v0000059ZwA";
                else
                    SRDID = "a2Y2v0000059Zux";
            }
            else
                SRDID = "a2Y2v0000059Zux";

            //var client = new RestClient("https://evita-hiranandanicommunities.cs58.force.com/CIFForm/services/apexrest/EnquiryFromWeb?Name=test Malay&Email=malay11@id8labs.com&MobileNo=917007987897&Source=Online Ads&ProjectId=a1s0l000000ZV1a&SRDId=a2Y0l0000001YCp");
            var client = new RestClient("https://hiranandanicommunities.secure.force.com/callback/services/apexrest/EnquiryFromWeb?Name=" + name + "&Email=" + email + "&MobileNo=91" + phone + "&Source=Online Ads&ProjectId=a1s7F000001IDuf&SRDId=" + SRDID + "");
            var request = new RestRequest(Method.POST);
            request.AddHeader("cache-control", "no-cache");
            request.AddHeader("source", "WEB");
            request.AddHeader("content-type", "application/json");
            IRestResponse response = client.Execute(request);
            return response.Content.ToString();
        }

        private void SendDataToCRM()
        {
            if (utm_term != null)
            {
                if (utm_term.Contains("aff"))
                {
                    SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Icogz"].ConnectionString);
                    sqlConnection.Open();
                    SqlDataAdapter sda = new SqlDataAdapter("usp_SendDataOfHiranandaniToCRM", sqlConnection);
                    sda.SelectCommand.CommandType = CommandType.StoredProcedure;
                    sda.SelectCommand.Parameters.AddWithValue("@firstname", txtName.Text);
                    sda.SelectCommand.Parameters.AddWithValue("@mobile", txtMobile.Text);
                    sda.SelectCommand.Parameters.AddWithValue("@email", txtEmail.Text);
                    sda.SelectCommand.Parameters.AddWithValue("@utm_source", utm_source);
                    sda.SelectCommand.Parameters.AddWithValue("@utm_medium", utm_medium);
                    sda.SelectCommand.Parameters.AddWithValue("@utm_content", utm_content);
                    sda.SelectCommand.Parameters.AddWithValue("@utm_campaign", utm_campaign);
                    sda.SelectCommand.Parameters.AddWithValue("@utm_term", utm_term);
                    sda.SelectCommand.ExecuteNonQuery();
                    sqlConnection.Close();
                }
            }
        }
    }
}