using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Text;
using System.IO;
using System.Globalization;

public partial class homecontrol : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Get_CarDetail();
        Getalbumfilename();



    }

    protected void Getalbumfilename()
    { 
	
	 SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);

        try
        {
            DataSet dq = new DataSet();
            DataTable dt = new DataTable();
            dq.Tables.Add(dt);

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConnection;
            cmd.CommandText = "SELECT car_plate FROM cardatabase WHERE car_approve = 'Approved'";
            myConnection.Open();
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            da.Fill(dt);

            string[] allowplate = new string[dt.Rows.Count];
			
			for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
			  allowplate[i] = Uri.EscapeDataString(dt.Rows[i][0].ToString());
			  platenum.Items.Add(new ListItem(allowplate[i], allowplate[i]));
			  
			}
			
		}
		
		catch (Exception f)
        {
            Console.WriteLine(f.ToString());
        }


        finally
        {
            // Close Connection
            myConnection.Close();

        }



        //DirectoryInfo dinfo = new DirectoryInfo(@"\\mazdaanshin.com.my\Pre-Owned\customasp\carpicture");
		/*
		DirectoryInfo dinfo = new DirectoryInfo(Server.MapPath("/Pre-Owned/customasp/carpicture"));

        DirectoryInfo[] diArr = dinfo.GetDirectories();


        foreach (DirectoryInfo file in diArr)
        {

            platenum.Items.Add(new ListItem(file.Name, file.Name));

        }
		*/


    }

    protected void Submit_Click(object sender, EventArgs e)
    {


        if (platenum.SelectedValue == "0")
        {
            Session["year"] = year.SelectedValue;
            Session["model"] = model.SelectedValue;
            Session["location"] = location.SelectedValue;
            Session["counter"] = 1;
            //Response.Redirect("~/searchlist.aspx?currentvalue=1" + "&var1=" + (string)(Session["year"]) + "&var2=" + (string)(Session["model"]) +"&var3="+(string)(Session["location"]));
            Response.Redirect("~/searchlist.aspx?currentvalue=1");
        }

        else
        {

            Response.Redirect("~/vehicledetail.aspx?plate=" + platenum.SelectedValue);

        }

    }


    protected void Get_CarDetail()
    {
	
	
/*	SELECT car_model,car_year,car_price,car_location,car_plate,car_status,status_date From cardatabase
where car_approve = 'Approved' AND car_status = 'Available'

UNION ALL

SELECT car_model,car_year,car_price,car_location,car_plate,car_status,status_date From cardatabase
where car_approve = 'Approved' AND car_status = 'Booked' AND status_date Between DateAdd(DD,-7,GETDATE() ) and GETDATE() 


UNION ALL

SELECT car_model,car_year,car_price,car_location,car_plate,car_status,status_date From cardatabase
where car_approve = 'Approved' AND car_status = 'Sold' AND status_date Between DateAdd(DD,-14,GETDATE() ) and GETDATE() 




SELECT TOP 7 car_model,car_year,car_price,car_location,car_plate,car_status,status_date FROM
(
SELECT * FROM cardatabase WHERE car_approve = 'Approved' AND  car_status = 'Available'  

UNION ALL

SELECT * FROM cardatabase
where car_approve = 'Approved' AND car_status = 'Booked' AND status_date Between DateAdd(DD,-7,GETDATE() ) and GETDATE() 

UNION ALL

SELECT * FROM cardatabase
where car_approve = 'Approved' AND car_status = 'Sold' AND status_date Between DateAdd(DD,-14,GETDATE() ) and GETDATE()
   
) AS a  ORDER BY car_year DESC, car_price ASC 






*/


        SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);

        try
        {
            DataSet dq = new DataSet();
            DataTable dt = new DataTable();
            dq.Tables.Add(dt);

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConnection;
            // cmd.CommandType = CommandType.StoredProcedure;
            //cmd.CommandText = "SELECT car_model,car_year,car_price,car_location,car_plate,car_status,status_date FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY car_year DESC) as row FROM cardatabase WHERE car_approve = 'Approved') a WHERE row >= 0 AND row <= 7" + " " + "ORDER BY car_price ASC";
	    	//cmd.CommandText = "SELECT TOP 7 car_model,car_year,car_price,car_location,car_plate,car_status,status_date FROM(SELECT * FROM cardatabase WHERE car_approve = 'Approved' AND  car_status = 'Available' UNION ALL SELECT * FROM cardatabase where car_approve = 'Approved' AND car_status = 'Booked' AND status_date Between DateAdd(DD,-7,GETDATE() ) and GETDATE() UNION ALL SELECT * FROM cardatabase where car_approve = 'Approved' AND car_status = 'Sold' AND status_date Between DateAdd(DD,-14,GETDATE() ) and GETDATE()) AS a  ORDER BY car_year DESC, car_price ASC";
			
			cmd.CommandText = "SELECT TOP 7 car_model,car_year,car_price,car_location,car_plate,car_status,status_date FROM cardatabase WHERE car_approve = 'Approved' AND  (car_status = 'Available' OR car_status = 'Booked' OR (car_status = 'Sold' AND status_date Between DateAdd(DD,-7,GETDATE() ) and GETDATE()) ) ORDER BY car_year DESC, car_price ASC"; 

            myConnection.Open();
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            da.Fill(dt);

            string[] myallsearch = new string[dt.Rows.Count];
            string[] mybigsearch = new string[dt.Rows.Count];
            string[] myyear = new string[dt.Rows.Count];
            string[] mymodel = new string[dt.Rows.Count];
            string[] imgplate = new string[dt.Rows.Count];
            string[] myprice = new string[dt.Rows.Count];
            string[] mylocation = new string[dt.Rows.Count];
            string[] myplate = new string[dt.Rows.Count];
			string[] mystatus = new string[dt.Rows.Count];
			int[] whyohwhy = new int[dt.Rows.Count];
			
		    int[] checkdays = new int[dt.Rows.Count];
			DateTime [] startDate = new DateTime[dt.Rows.Count];


            StringBuilder sb = new StringBuilder();

            StringBuilder sb2 = new StringBuilder();




            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                mymodel[i] = dt.Rows[i][0].ToString();
                myyear[i] = dt.Rows[i][1].ToString();
				whyohwhy[i]=Convert.ToInt32(dt.Rows[i][2]);
                myprice[i] = string.Format("{0:#,###0}",whyohwhy[i]);
                mylocation[i] = dt.Rows[i][3].ToString();
                myplate[i] = Uri.EscapeDataString(dt.Rows[i][4].ToString());
                imgplate[i] = myplate[i].Replace("%20", "_");
				mystatus[i] = dt.Rows[i][5].ToString();
				
				startDate[i] = Convert.ToDateTime(dt.Rows[i][6]);
				checkdays[i] = (DateTime.Today - startDate[i]).Days;
			
				



                if ( i <= 3 )

                {
				    //<img width=100px  src=Pre-Owned/customasp/carpicture/nopicture/sold.png style=\"position: absolute; top:0px; left:0px; z-index:500;\"/>
					if ( mystatus[i] == "Sold")
			        {
                       mybigsearch[i] = "<li><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\"  /></a><span>" + mymodel[i] + " " + myyear[i] + " &nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span><img   src=Pre-Owned/customasp/carpicture/nopicture/sold.png style=\" width=400px !important; height:267px !important;position: absolute; top:-415px; left:0px; z-index:500;\"/></span></li>";
			        }
			       else if ( mystatus[i] == "Booked" && checkdays[i] <= 7)
			        {
			   
			          mybigsearch[i] = "<li><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\"  /></a><span>" + mymodel[i] + " " + myyear[i] + " &nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span><img width=100px  src=Pre-Owned/customasp/carpicture/nopicture/booked.png style=\" height:175px !important;position: absolute; top:-415px; left:0px; z-index:500;\"/></span></li>";
			
			        }
			
			        else
			
			        {
			  
			           mybigsearch[i] = "<li><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\"  /></a><span>" + mymodel[i] + " " + myyear[i] + " &nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span></span></li>";
			
			        } 

                   

                }

                else

                {
				
				
				    if ( mystatus[i] == "Sold")
			        {
					
					myallsearch[i] = "<div class=img><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img  width=200px  src=Pre-Owned/customasp/carpicture/nopicture/sold.png style=\"position: absolute; top:20px; left:3px; z-index:500;\"/><img class=hotimage width=360px height=240px src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\" /></a><div class=desc><p>" + mymodel[i] + " " + myyear[i] + "&nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span></p></div></div>";
               
			        }
			       else if ( mystatus[i] == "Booked")
			        {
			   
			        myallsearch[i] = "<div class=img><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img  width=200px  src=Pre-Owned/customasp/carpicture/nopicture/booked.png style=\"position: absolute; top:20px; left:3px; z-index:500;\"/><img class=hotimage width=360px height=240px src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\" /></a><div class=desc><p>" + mymodel[i] + " " + myyear[i] + "&nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span></p></div></div>";
			
			        }
			
			        else
			
			        {
			  
			        myallsearch[i] = "<div class=img><a href=vehicledetail.aspx?plate=" + myplate[i] + "><img class=hotimage width=360px height=240px src=Pre-Owned/customasp/carpicture/" + imgplate[i] + "/main.jpg onerror=\"this.onerror=null;this.src='Pre-Owned/customasp/carpicture/nopicture/notavailable01.jpg'\" /></a><div class=desc><p>" + mymodel[i] + " " + myyear[i] + "&nbsp;<span class=rm>RM</span><span class=valuerm>" + myprice[i] + "</span></p></div></div>";
			
			        } 

                   
					
               

                }


                sb.Append(myallsearch[i]);
                sb2.Append(mybigsearch[i]);

                smallhot.InnerHtml = "</br></br></br></br>" + sb.ToString();
                gettheimage.InnerHtml ="<ul id=thumbnailss>" +  sb2.ToString() + "</ul>";



            }










        }

        catch (Exception f)
        {
            Console.WriteLine(f.ToString());
        }


        finally
        {
            // Close Connection
            myConnection.Close();
            //valuecheck.Text = dt.Rows[4][0].ToString();
            //valuecheck.Text = "ahahhahahahahahsduajancan198237172412542174192";

        }

    }



      





}