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.Windows.Forms;
using System.IO;
//to use smtp function
using System.Net.Mail;
using System.Net;
using System.Globalization;

public partial class Pre_Owned_customasp_addcar : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
       //Session["myuser1"]=(string)(Session["myuser"]);
	   
	   string clearupload = Server.MapPath(@"~\Pre-Owned\customasp\uploads\");
	   Array.ForEach(Directory.GetFiles(clearupload), File.Delete);
    }

    protected void register()
    {

        var folder = Server.MapPath("~/Pre-Owned/customasp/carpicture/" + carplate.Text);
        if (!Directory.Exists(folder))
        {
            Directory.CreateDirectory(folder);
			string check = Server.MapPath(@"~\Pre-Owned\customasp\uploads\1.jpg");
			string sourcePath = Server.MapPath(@"~\Pre-Owned\customasp\uploads");
			string targetPath = Server.MapPath(@"~\Pre-Owned\customasp\carpicture\") + carplate.Text;
			
			if (File.Exists(check))
			{
			  
			  foreach (var srcPath in Directory.GetFiles(sourcePath))
              {
                 File.Copy(srcPath, srcPath.Replace(sourcePath,targetPath), true);
              }
			
			}
			
			/* if (FileUploadControl.HasFile)
            {
			 if (FileUploadControl.PostedFile.ContentType == "image/jpeg" || FileUploadControl.PostedFile.ContentType == "image/png")
                {
                    if (FileUploadControl.PostedFile.ContentLength < 5120000)
                    {

                        //Array.ForEach(Directory.GetFiles(@"c:\inetpub\wwwroot\Bermaz_Portal\Pre-Owned\customasp\carpicture\" + platenum.SelectedValue), File.Delete);
						Array.ForEach(Directory.GetFiles(Server.MapPath(@"~\Pre-Owned\customasp\carpicture\") + carplate.Text), File.Delete);
                        string filename = Path.GetFileName(FileUploadControl.FileName);
                        FileUploadControl.SaveAs(Server.MapPath("~/Pre-Owned/customasp/carpicture/" + carplate.Text + "/") + filename);

                    }
                    else
                    {
                        StatusLabel2.Text = "Upload status: The file has to be less than 4MB! Please Go to UPLOAD tab to reupload content";
                    }
                }
                else
                {
                    StatusLabel2.Text = "Upload status: Only JPEG files are accepted! Please Go to UPLOAD tab to reupload content";
                }

            }*/
			
			else
			{
			 StatusLabel2.Text = "Please Go to UPLOAD tab to upload car images";
			}

              //edited by aifa 18/11/2015
		      string myusername = (string)(Session["myuser"]);
		      //end

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


            try
            {
                SqlCommand myCommand = myConnection.CreateCommand();

               //myCommand.CommandText = "INSERT INTO cardatabase (car_model,car_cc,car_trans,car_plate,car_colour,car_year,car_mileage,car_price,car_location,car_owner,car_details,car_image) VALUES (@model,@cc,@trans,@plate,@colour,@year,@mileage,@price,@location,REPLACE(@owner,' ','_'),NULL,NULL)";
			    //  myCommand.CommandText = "INSERT INTO cardatabase (car_model,car_cc,car_trans,car_plate,car_colour,car_year,car_mileage,car_price,car_location,car_seat,car_details,car_approve,car_status,car_warranty) VALUES ('haha','hoho','tapirla','noobafiq','kodtakjalan','20218','209','10','hq','leatherla','administrator','Pending','available','tak dok')";
 //myCommand.CommandText = "INSERT INTO cardatabase (car_model,car_cc,car_trans,car_plate,car_colour,car_year,car_mileage,car_price,car_location,car_seat,car_details,car_approve,car_status,car_warranty) VALUES (@model,@cc,@trans,@plate,@colour,@year,@mileage,@price,@location,@seat,@myuser,'Pending','available',@warranty)";
 myCommand.CommandText = "INSERT INTO cardatabase (car_model,car_cc,car_trans,car_plate,car_colour,car_year,car_mileage,car_price,car_location,car_seat,car_details,car_approve,car_status,car_warranty,car_reg,user_date,hide) VALUES (@model,@cc,'notusedfornow',@plate,@colour,@year,@mileage,@price,@location,@seat,@myuser,'Pending','Available',@warranty,@reg,@userdate,'No')";
			   
			

			   

                myCommand.Parameters.Add(new SqlParameter("@model", System.Data.SqlDbType.Text));
                myCommand.Parameters.Add(new SqlParameter("@cc", System.Data.SqlDbType.VarChar, 50));
                //myCommand.Parameters.Add(new SqlParameter("@trans", System.Data.SqlDbType.VarChar, 50));
                myCommand.Parameters.Add(new SqlParameter("@plate", System.Data.SqlDbType.VarChar, 50));
                myCommand.Parameters.Add(new SqlParameter("@colour", System.Data.SqlDbType.VarChar, 50));
                myCommand.Parameters.Add(new SqlParameter("@year", System.Data.SqlDbType.Int));
                myCommand.Parameters.Add(new SqlParameter("@mileage", System.Data.SqlDbType.Int));
                myCommand.Parameters.Add(new SqlParameter("@price", System.Data.SqlDbType.Int));
                myCommand.Parameters.Add(new SqlParameter("@location", System.Data.SqlDbType.VarChar, 50));
				myCommand.Parameters.Add(new SqlParameter("@seat", System.Data.SqlDbType.VarChar, 50));
				myCommand.Parameters.Add(new SqlParameter("@myuser", System.Data.SqlDbType.VarChar, 50));
				myCommand.Parameters.Add(new SqlParameter("@warranty", System.Data.SqlDbType.Text));
				myCommand.Parameters.Add(new SqlParameter("@reg", System.Data.SqlDbType.Text));
				myCommand.Parameters.Add(new SqlParameter("@userdate", System.Data.SqlDbType.DateTime));
				

                myCommand.Parameters["@model"].Value = carmodel.SelectedValue;
                myCommand.Parameters["@cc"].Value = carcc.SelectedValue;
                //myCommand.Parameters["@trans"].Value = cartrans.SelectedValue;
                myCommand.Parameters["@plate"].Value = carplate.Text;
                myCommand.Parameters["@colour"].Value = carcolour.SelectedValue;
                myCommand.Parameters["@year"].Value = caryear.SelectedValue;
                myCommand.Parameters["@mileage"].Value = carmileage.Text;
                myCommand.Parameters["@price"].Value = carprice.Text;
                myCommand.Parameters["@location"].Value = carlocation.SelectedValue;
                myCommand.Parameters["@seat"].Value = carseat.SelectedValue;
			    myCommand.Parameters["@myuser"].Value = myusername;
				//myCommand.Parameters["@warranty"].Value = carwarranty.SelectedValue; 
				myCommand.Parameters["@warranty"].Value = carwarranty.Text; 
				myCommand.Parameters["@reg"].Value = carreg.Text; 
				myCommand.Parameters["@userdate"].Value = DateTime.Now; 
				
				
                myCommand.ExecuteNonQuery();
            }

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


            finally
            {

                myConnection.Close();
                //StatusLabel.Text = "Records Successfully Added!!" + carmodel.SelectedValue + "," + carcc.SelectedValue + "," + cartrans.SelectedValue + "," + carplate.Text+ ","  + carcolour.SelectedValue+ ","  + caryear.SelectedValue+ "," + carmileage.Text+ ","  + carprice.Text+ ","  + carlocation.SelectedValue+ ","  + carseat.SelectedValue+ ","  + myusername+ ","  + carwarranty.SelectedValue  ;
                StatusLabel.Text = "Records Successfully Added!!";
				
			
			if (myusername == "kahnuen" || myusername == "administrator")
				
		    {
			
			string fulltext = "New Mazda Car Added by" + " " + myusername + "." + "Please click this link : http://mazdaanshin.com.my/edit.aspx";
		    string to = "muzamil@mazda.com.my";
            string from = "micrositeemail@mazda.com.my";
            string subject = "Mazda Anshin Update by" + " " + myusername ;
            string body =  fulltext;
			
			var message = new MailMessage();
			
			message.To.Add("muzamil@mazda.com.my");
            message.To.Add("aifa.abdulaziz@mazda.com.my");
            message.From = new MailAddress(from);
            message.Subject = subject;
            message.Body = body;
			
			
            message.IsBodyHtml = true;
			SmtpClient client = new SmtpClient("smtp.office365.com");
            client.Port = 587;
            client.DeliveryMethod = SmtpDeliveryMethod.Network;
            client.UseDefaultCredentials = false;
			client.Credentials = new NetworkCredential("micrositeemail@mazda.com.my", "Bypass123!");
			client.EnableSsl = true; //This is the you need to do
            client.Send(message);		
			
			}
			
			else
			
			{
			string fulltext = "New Mazda Car Added by" + " " + myusername + "." + "Please click this link : http://mazdaanshin.com.my/edit.aspx";
		    string to = "kahnuen@mazda.com.my";
            string from = "micrositeemail@mazda.com.my";
            string subject = "Mazda Anshin Update by" + " " + myusername ;
            string body =  fulltext;
            
			
			var message = new MailMessage();
			
			message.To.Add("kahnuen@mazda.com.my");
            message.To.Add("aifa.abdulaziz@mazda.com.my");
            message.From = new MailAddress(from);
            message.Subject = subject;
            message.Body = body;
			
            message.IsBodyHtml = true;
			SmtpClient client = new SmtpClient("smtp.office365.com");
            client.Port = 587;
            client.DeliveryMethod = SmtpDeliveryMethod.Network;
            client.UseDefaultCredentials = false;
			client.Credentials = new NetworkCredential("micrositeemail@mazda.com.my", "Bypass123!");
			client.EnableSsl = true; //This is the you need to do
            client.Send(message);		
			
			} 

            }

        }

        else
        {

            StatusLabel.Text = "The Vehicle Record Already Exist!";

        }
       

    }

    protected void Reset_Click(object sender, EventArgs e)
    {

        Response.Redirect("~/register.aspx");

    }




    protected void Submit_Click(object sender, EventArgs e)
    {
      

            register();

        
    }




   

}