#region Imports...
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using WMS.Web.UI;
using WMS.Services;
using WMS.Entities;
#endregion

public partial class Project_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        FormUtil.SetPageIndex(ProjectGridView, "page");

        if (Request.Cookies["ProjectId"] != null)
        {
            string MyProjectId = Request.Cookies["ProjectId"].Value.Trim().Substring(Request.Cookies["ProjectId"].Value.Trim().LastIndexOf("=") + 1);
            if (MyProjectId.Equals(""))
            {
                Response.Redirect("Default.aspx", true);

            }
            else
            {
                ProjectBLL ProjectBLL = new ProjectBLL();
                Project ProjectEntity = ProjectBLL.GetByProjectId(ProjectId);
                LB_FormMSG.Text = ProjectEntity.ProjectName;
            }
        }
        else
        {
            //Hide the Buttons
            BT_Drawings.Visible = false;
            BT_Spools.Visible = false;
        }
    }

    protected void ProjectGridView_SelectedIndexChanged(object sender, EventArgs e)
    {
        HttpCookie myCookie = new HttpCookie("ProjectId", string.Format("ProjectId={0}", ProjectGridView.SelectedDataKey.Values[0]));
        Response.Cookies.Add(myCookie);

        ProjectBLL ProjectBLL = new ProjectBLL();
        Project ProjectEntity = ProjectBLL.GetByProjectId(ProjectId);
        LB_FormMSG.Text = ProjectEntity.ProjectName;

        Response.Redirect("Managers/ProjectManager.aspx?ProjectId=" + ProjectGridView.SelectedDataKey.Values[0]);

    }
    public int ProjectId
    {
        get
        {
            return int.Parse(Request.Cookies["ProjectId"].Value.Trim().Substring(Request.Cookies["ProjectId"].Value.Trim().LastIndexOf("=") + 1));
        }
    }
    protected void BT_Drawings_Click(object sender, EventArgs e)
    {
        Response.Redirect("Drawings.aspx", true);
    }
    protected void BT_Spools_Click(object sender, EventArgs e)
    {
        Response.Redirect("Spools.aspx", true);
    }
    protected void uploadExcel_Click(object sender, EventArgs e)
    {
        try
        {
            if (!(filename.PostedFile.FileName == null))
            {
                excelMessages.Text = "";
                //A reference to our dataset
                DataSet projectData;

                //Populate our dataset by using our ExcelReading functions
                WeldBLL weldBLL = new WeldBLL();
                projectData = weldBLL.UploadExcel(ProjectId, filename.PostedFile.FileName.ToString());
                
                //New datatable for parsing our dataset
                DataTable failedObjects = projectData.Tables[0];
                DataRow row;
                
                if (failedObjects.Rows.Count > 0)
                {
                    //Kill off any rows that don't contain errors
                    for (int i = 0; i < failedObjects.Rows.Count; i++)
                    {
                        row = failedObjects.Rows[i];
                        if (row["Reason"].ToString().Equals(""))
                        {
                            failedObjects.Rows[i].Delete();
                        }
                        
                    }
                    if (failedObjects.Rows.Count > 0)
                    {

                        //This is the code that will export our gridview
                        Response.Clear();
                        Response.AddHeader("content-disposition", "attachment;filename=FailedObjects.xls");
                        Response.Charset = "";

                        // If you want the option to open the Excel file without saving then
                        // comment out the line below
                        // Response.Cache.SetCacheability(HttpCacheability.NoCache);
                        Response.ContentType = "application/vnd.xls";
                        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
                        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

                        //This grid view is created because the RenderControl() function
                        //Cannot be used with a gridview inside a form
                        GridView ExportGridView = new GridView();
                        ExportGridView.DataSource = failedObjects;
                        ExportGridView.DataBind();
                        //Write our excel file
                        ExportGridView.RenderControl(htmlWrite);
                        Response.Write(stringWrite.ToString());
                        Response.End();
                    }
                    else
                    {
                        excelMessages.Text = "Upload complete.";
                    }
                }
                else
                {
                    excelMessages.Text = "Upload complete.";
                }
                
                
            }
            else
            {
                excelMessages.Text = "Please select a file to upload.";
            }
        }
        catch (Exception ex)
        {
            excelMessages.Text = ex.Message;
        }
    }
    protected void BT_AddProject_Click(object sender, EventArgs e)
    {
        Response.Redirect("Managers/ProjectManager.aspx");
    }

    protected void uploadExcel_Click(object sender, EventArgs e)
    {
        String savePath = @"G:/Temp";
        if (FileUpload.HasFile)
        {
            String fileName = FileUpload.FileName;
            savePath += "/"+fileName;
            FileUpload.SaveAs(savePath);
            LB_FormMSG.Text = "Your file was saved as " + fileName;
        }
        else
        {
            // Notify the user that a file was not uploaded.
            LB_FormMSG.Text = "You did not specify a file to upload.";
        }
    }
}