using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

namespace infoExpediters
{
    public partial class EditComapanyDetails : System.Web.UI.Page
    {
        AddCompany obj = new AddCompany();
       
        protected void Page_Load(object sender, EventArgs e)
        { 
            if (!IsPostBack)
            {
                GetStates();
                GetRegions();
                GetPaperStates();
                GetPartStates();
                GetTimeZone();
                GetCompanyNames();
                GetCompanyDetails();
            }

        }
        
        public void GetCompanyDetails()
        {
            DataSet ds = obj.fillvalues(1);
            txtCompanyName.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
            txtCompanyTag.Text = ds.Tables[0].Rows[0]["Tag"].ToString();
            txtCity.Text = ds.Tables[0].Rows[0]["City"].ToString();

            ddlState.SelectedValue = ds.Tables[0].Rows[0]["StateType"].ToString();
            txtAddress1.Text = ds.Tables[0].Rows[0]["Address1"].ToString();
            txtAddress2.Text = ds.Tables[0].Rows[0]["Address2"].ToString();
            txtCustomerNo1.Text = ds.Tables[0].Rows[0]["CompanyCSPre"].ToString();
            txtCustomerNo2.Text = ds.Tables[0].Rows[0]["CompanyCSArea"].ToString();
            txtCustomerNo3.Text = ds.Tables[0].Rows[0]["CompanyCSSuffix"].ToString();
            txtPaperAddress1.Text = ds.Tables[0].Rows[0]["PaperAddress1"].ToString();
            txtPaperAddress2.Text = ds.Tables[0].Rows[0]["PaperAddress2"].ToString();
            txtPaperCity.Text = ds.Tables[0].Rows[0]["PaperCity"].ToString();
            txtPaperZip.Text = ds.Tables[0].Rows[0]["PaperZip"].ToString();
            ddlPaperStateType.Text = ds.Tables[0].Rows[0]["PaperStateType"].ToString();
            txtPartsAddress1.Text = ds.Tables[0].Rows[0]["PartsAddress1"].ToString();
            txtPartsAddress2.Text = ds.Tables[0].Rows[0]["PartsAddress2"].ToString();
            txtPartsCity.Text = ds.Tables[0].Rows[0]["PartsCity"].ToString();
            txtPartsZip.Text = ds.Tables[0].Rows[0]["PartsZip"].ToString();
            ddlPartsStateType.Text = ds.Tables[0].Rows[0]["PartsStateType"].ToString();
            txtPh1.Text = ds.Tables[0].Rows[0]["CompanyPhonePre"].ToString();
            txtPh2.Text = ds.Tables[0].Rows[0]["CompanyPhoneArea"].ToString();
            txtPh3.Text = ds.Tables[0].Rows[0]["CompanyPhoneSuffix"].ToString();
            txtPriceList.Text = ds.Tables[0].Rows[0]["PriceList"].ToString();
            string date = ds.Tables[0].Rows[0]["Pricelistdate"].ToString();
            //DateTime dt=DateTime.Parse(date);
            //dt = DateTime.SpecifyKind(dt, DateTimeKind.Local);

            txtPriceListDate.Text = String.Format("{0:dd-MMM-yyyy}", DateTime.Parse(date));
            //if (date.Trim().Length > 0)
            //{
            //    dt = DateTime.Parse(date.ToString());
            //    txtPriceListDate.Text = dt.Date.ToString();
            //}
           // ds.Tables[0].Rows[0]["PriceListDate"].ToString();
            txtShippingCutOffTime.Text = ds.Tables[0].Rows[0]["ShippingCutOffTime"].ToString();
            txtFax1.Text = ds.Tables[0].Rows[0]["CompanyFaxPre"].ToString();
            txtFax2.Text = ds.Tables[0].Rows[0]["CompanyFaxArea"].ToString();
            txtFax3.Text = ds.Tables[0].Rows[0]["CompanyFaxSuffix"].ToString();

            txtTechPh1.Text = ds.Tables[0].Rows[0]["CompanyTechPre"].ToString();
            txtTechPh2.Text = ds.Tables[0].Rows[0]["CompanyTechArea"].ToString();
            txtTechPh3.Text = ds.Tables[0].Rows[0]["CompanyTechSuffix"].ToString();
            txttf1.Text = ds.Tables[0].Rows[0]["CompanyTollPre"].ToString();
            txttf2.Text = ds.Tables[0].Rows[0]["CompanyTollArea"].ToString();
            txttf3.Text = ds.Tables[0].Rows[0]["CompanyTollSuffix"].ToString();
            txtWebsite.Text = ds.Tables[0].Rows[0]["WebSite"].ToString();
            txtEmail.Text = ds.Tables[0].Rows[0]["EmailId"].ToString();
            txtZip.Text = ds.Tables[0].Rows[0]["Zip"].ToString();
            txtKeywords.Text = ds.Tables[0].Rows[0]["Keywords"].ToString();
            ddlCompanyParent.SelectedValue = ds.Tables[0].Rows[0]["ParentCompanyId"].ToString();
            ddlTimeZoneCode.SelectedValue = ds.Tables[0].Rows[0]["TimeZoneCode"].ToString();
           string Url= ds.Tables[0].Rows[0]["LogoUrl"].ToString();

            ImageUrl.ImageUrl = "CompanyLogos/" +Url;
            h1.Value = Url;
           // fu1. = ds.Tables[0].Rows[0]["LogoUrl"].ToString();
            //hdnRegions.Value = ds.Tables[1].Columns["RegionId"][0].ToString();
            for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
            {
                 Select1.Items.Add(ds.Tables[1].Rows[i]["CodeName"].ToString());
                 //Select1.Items.Add(ds.Tables[1].Rows[i]["CodeValue"].ToString());

                //string name = ds.Tables[1].Rows[i]["CodeName"].ToString();
                //string value = ds.Tables[1].Rows[i]["CodeValue"].ToString();
                hdnRegions.Value += ds.Tables[1].Rows[i]["CodeValue"].ToString()+",";
            }
           
            


        }
        public void GetStates()
        {
            try
            {
                DataSet ds = obj.GetStates();
                ddlState.DataSource = ds.Tables["Codes"];
                ddlState.DataTextField = "CodeName";
                ddlState.DataValueField = "CodeValue";
                ddlState.DataBind();
                int val;
                val = 0;
                ddlState.Items.Insert(0, "[Select State]");
                ddlState.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public void GetRegions()
        {
            try
            {
                DataSet ds = obj.GetRegions();
                ddlRegions.DataSource = ds.Tables["Codes"];
                ddlRegions.DataTextField = "CodeName";
                ddlRegions.DataValueField = "CodeValue";
                ddlRegions.DataBind();
                int val;
                val = 0;
                ddlRegions.Items.Insert(0, "[Select Region]");
                ddlRegions.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        public void GetPartStates()
        {
            try
            {
                DataSet ds = obj.GetPartStates();
                ddlPartsStateType.DataSource = ds.Tables["Codes"];
                ddlPartsStateType.DataTextField = "CodeName";
                ddlPartsStateType.DataValueField = "CodeValue";
                ddlPartsStateType.DataBind();
                int val;
                val = 0;
                ddlPartsStateType.Items.Insert(0, "[Select State]");
                ddlPartsStateType.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        public void GetPaperStates()
        {
            try
            {
                DataSet ds = obj.GetPaperStates();
                ddlPaperStateType.DataSource = ds.Tables["Codes"];
                ddlPaperStateType.DataTextField = "CodeName";
                ddlPaperStateType.DataValueField = "CodeValue";
                ddlPaperStateType.DataBind();
                int val;
                val = 0;
                ddlPaperStateType.Items.Insert(0, "[Select State]");
                ddlPaperStateType.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        public void GetTimeZone()
        {
            try
            {
                DataSet ds = obj.GetTimeZone();
                ddlTimeZoneCode.DataSource = ds.Tables["Codes"];
                ddlTimeZoneCode.DataTextField = "CodeName";
                ddlTimeZoneCode.DataValueField = "CodeValue";
                ddlTimeZoneCode.DataBind();
                int val;
                val = 0;
                ddlTimeZoneCode.Items.Insert(0, "[Select TimeZone]");
                ddlTimeZoneCode.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        public void GetCompanyNames()
        {
            try
            {
                DataSet ds = obj.GetCompanyNames();
                ddlCompanyParent.DataSource = ds.Tables["Company"];
                ddlCompanyParent.DataTextField = "CompanyName";
                ddlCompanyParent.DataValueField = "CompanyId";
                ddlCompanyParent.DataBind();
                int val;
                val = 0;
                ddlCompanyParent.Items.Insert(0, "[None]");
                ddlCompanyParent.Items[0].Value = val.ToString();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                Hashtable ht=new Hashtable();
                ht.Add("@companyname",txtCompanyName.Text);
                ht.Add("@tag",txtCompanyTag.Text);
                ht.Add("@parentcompanyid",ddlCompanyParent.SelectedItem.Value.ToString());
                ht.Add("@address1",txtAddress1.Text);
                ht.Add("@address2",txtAddress2.Text);
                ht.Add("@city",txtCity.Text);
                ht.Add("@statetype",ddlState.SelectedItem.Value.ToString());
                ht.Add("@zip",txtZip.Text);
                ht.Add("@paperaddress1",txtPaperAddress1.Text);
                ht.Add("@paperaddress2",txtPaperAddress2.Text);
                ht.Add("@papercity",txtPaperCity.Text);
                ht.Add("@paperstatetype",ddlPaperStateType.SelectedItem.Value.ToString());
                ht.Add("@paperzip",txtPaperZip.Text);
                ht.Add("@partsaddress1",txtPartsAddress1.Text);
                ht.Add("@partsaddress2",txtPartsAddress2.Text);
                ht.Add("@partscity",txtPartsCity.Text);
                ht.Add("@partsstatetype", ddlPartsStateType.SelectedItem.Value.ToString());
                ht.Add("@partszip",txtPartsZip.Text);
                ht.Add("@shippingcutofftime",txtShippingCutOffTime.Text);
                ht.Add("@timezonecode", ddlTimeZoneCode.SelectedItem.Value.ToString());
                ht.Add("@companyphonearea",txtPh1.Text);
                ht.Add("@companyphonepre",txtPh2.Text);
                ht.Add("@companyphonesuffix",txtPh3.Text);
                ht.Add("@companyfaxarea",txtFax1.Text);
                ht.Add("@companyfaxpre",txtFax2.Text);
                ht.Add("@companyfaxsuffix",txtFax3.Text);
                ht.Add("@companyTollarea",txttf1.Text);
                ht.Add("@companyTollpre",txttf2.Text);
                ht.Add("@companyTollsuffix",txttf3.Text);
                ht.Add("@companyTecharea",txtTechPh1.Text);
                ht.Add("@companyTechpre",txtTechPh2.Text);
                ht.Add("@companyTechsuffix",txtTechPh3.Text);
                ht.Add("@companyCSarea",txtCustomerNo1.Text);
                ht.Add("@companyCSpre",txtCustomerNo2.Text);
                ht.Add("@companyCSsuffix",txtCustomerNo3.Text);
                ht.Add("@webSite",txtWebsite.Text);
                ht.Add("@emailId",txtEmail.Text);
                ht.Add("@pricelist",txtPriceList.Text);
                ht.Add("@keywords",txtKeywords.Text);
                ht.Add("@pricelistdate", txtPriceListDate.Text);
                ht.Add("@Status","1");
                ht.Add("@CompanyId", "1627");
           //    string Url = ImageUrl.ImageUrl.ToString();
           //     int length=Url.Length;
           //string UpdateUrl=Url.Substring(14,length);
                //if (chkSave.Checked)
                //{
                //    if ((fu1.PostedFile.ContentLength == 0))
                //    {
                //        ht.Add("@logoUrl", h1.Value);
                //    }

                //}
                //if (chkSave.Checked == false)
                //{
                //    if ((fu1.PostedFile.ContentLength == 0))
                //    {
                //        ht.Add("@logoUrl", h1.Value);
                //    }

                //}

                 //if ((fu1.PostedFile.ContentLength == 0))
                 //{

                 //    ht.Add("@logoUrl", h1.Value);

                 //}
                if (chkSave.Checked)
                {
                    obj.Delete(1627);

                }
                if ((fu1.PostedFile != null) && (fu1.PostedFile.ContentLength > 0))
                   {
                    //   string filepath = Server.MapPath("CompanyLogos");
                       string filepath = Request.PhysicalApplicationPath + "CompanyLogos";
                       string strFileName = System.IO.Path.GetFileName(fu1.PostedFile.FileName);
                       fu1.PostedFile.SaveAs(filepath +  ("\\" + strFileName));
                       ht.Add("@logoUrl", fu1.FileName.ToString());
                       
                        lbMessage.Text = "uploaded successfully....";
                    }
                    //else
                    //{
                    //    lbMessage.Text = "uploaded failed"; 
                    //}

                    string Regvalues = "";
                    string Reg = hdnRegions.Value;
                    

                    
               
                ht.Add("@string", Reg.ToString());
              //obj.UpdateData(ht);
              ////int restatus = obj.InsertData(ht);
              //if (restatus == 1)
              //{
              //    Response.Redirect("Message.aspx");
              //}
              //else
              //{
              //   // lbErrorMessage.Text = "Insufficient Data to Update the Details";
              //}
               
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
         
        }
    }
}