using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
//using AjaxControlToolkit;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.Linq.Mapping;
using System.Linq.Expressions;
using System.Reflection;
using System.Data.SqlClient;
using System.Globalization;

public partial class _Default : System.Web.UI.Page
{
    public string thisConnectionString = ConfigurationManager.ConnectionStrings["TradeSelectorConnectionString"].ConnectionString;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.IsAuthenticated)
        {
            FormsAuthentication.SetAuthCookie(HttpContext.Current.User.Identity.Name, false);
            Response.Redirect("Customers.aspx");
        }

        BindData();
    }

    protected void Page_PreRender(object sender, EventArgs e)
    {
        //BindData();
    }

    private void BindData()
    {
        TradeSelectorDataContext db = new TradeSelectorDataContext();

        var query =
           (
             from tt in db.tblTraders
             join ttcl in db.tblCityLookups on tt.city_id equals ttcl.city_id
             join lctt in db.tblCountryLookups on tt.country_id equals lctt.country_id
             join tcl in db.tblCountyLookups on tt.county_id equals tcl.county_id
             join twal in db.tblTraderWorkingAreaLookups on tt.trader_working_area_id equals twal.trader_working_area_id
             join ttrade in db.tblTraderTrades on tt.UserId equals ttrade.UserId
             join trade in db.tblTrades on ttrade.trade_id equals trade.trade_id
             join ttt in db.tblTradeTradeTypes on trade.trade_id equals ttt.trade_id
             join tradet in db.tblTradeTypes on ttrade.trade_type_id equals tradet.trade_type_id
             join cj in db.tblCustomerJobs on trade.trade_id equals cj.trade_id
             join tr in db.tblTraderRatings on tt.UserId equals tr.UserId
             //join tc in db.tblCustomers on cj.UserId equals tc.UserId
             orderby tt.trader_firstname ascending
             select new
             {
                 tt.UserId
               ,
                 tt.trader_title
               ,
                 tt.trader_firstname
               ,
                 tt.trader_surname
               ,
                 tt.trader_phone1
               ,
                 tt.trader_phone2
               ,
                 tt.trader_working_area_id
               ,
                 tt.trader_overall_rating
               ,
                 trader_working_area_name = twal.trader_working_area_name.Substring(0, twal.trader_working_area_name.IndexOf('(')).Trim()
               ,
                 trader_working_area_postcodes = twal.trader_working_area_name.Substring(twal.trader_working_area_name.IndexOf('(') + 1, twal.trader_working_area_name.LastIndexOf(')') - twal.trader_working_area_name.IndexOf('(') - 1).Trim()
               ,
                 trade_type_name = tradet.trade_type_name == null ? "" : tradet.trade_type_name
               ,
                 trade.trade_name
               ,
                 ttrade.trade_type_id
               ,
                 ttrade.trade_id
               ,
                 tr.Rating01
               ,
                 tr.Rating02
               ,
                 tr.Rating03
               ,
                 tr.Rating04
               ,
                 tr.Rating05
             }
           ).Distinct();

        lvTrustAccounts.DataSource = query;
        lvTrustAccounts.DataBind();
    }

    protected void lvTrustAccounts_ItemDataBound(object sender, ListViewItemEventArgs e)
    {
        Object dataRecord = ((ListViewDataItem)e.Item).DataItem; // Get the dataitem and place it into dataRecord
        Type anonType = dataRecord.GetType(); // get the anonymous type

        // Get user id and rating values using reflection
        Guid userid = (Guid)anonType.GetProperty("UserId").GetValue(dataRecord, null);
        int rating1 = (int)anonType.GetProperty("Rating01").GetValue(dataRecord, null);
        int rating2 = (int)anonType.GetProperty("Rating02").GetValue(dataRecord, null);
        int rating3 = (int)anonType.GetProperty("Rating03").GetValue(dataRecord, null);
        int rating4 = (int)anonType.GetProperty("Rating04").GetValue(dataRecord, null);
        int rating5 = (int)anonType.GetProperty("Rating05").GetValue(dataRecord, null);

        // Put rating values in array
        int[] rateValues = new int[] 
        { 
            rating1, rating2, rating3, rating4, rating5 
        };

        // Get a reference to the rating control, and set and bind the data
        Spaanjaars.Toolkit.ContentRating ratingControl = (Spaanjaars.Toolkit.ContentRating)e.Item.FindControl("ContentRating1");

        if (e.Item.ItemType == ListViewItemType.DataItem)
        {
            ratingControl.ItemId = userid;
            ratingControl.DataSource = rateValues;
            ratingControl.DataBind();
        }
    }

    [System.Web.Services.WebMethod]
    [System.Web.Script.Services.ScriptMethod]
    public static string[] GetCompletionList(string contextKey, string prefixText, int count)
    {
        //  prefixText: the text the user has entered thus far
        //  count: the number of suggestions to return
        //  contextKey: the column name to fetch suggestions for           
        return new SelectCustomers().GetCompletionList(contextKey, prefixText, count);
    }
}