public void Bind_data()
 {
     bllobjcompany.Userid = Session["MarketingUser"].ToString();
     status = bllobjcompany.BLLCheckcompanyexist(bllobjcompany);
     if (status == 1)
     {
     }
     else
     {
         status = bllobjcompany.BLLChecklatestjobexist(bllobjcompany);
         if (status == 1)
         {
             DataSet ds = bllobjcompany.BLLViewCompanyDetailsonly(bllobjcompany);
             txtCompanyName.Text           = Convert.ToString(ds.Tables[0].Rows[0]["companyname"]);
             ddlState.SelectedItem.Text    = Convert.ToString(ds.Tables[0].Rows[0]["stateName"]);
             ddlDistrict.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["distName"]);
             ddlCity.SelectedItem.Text     = Convert.ToString(ds.Tables[0].Rows[0]["cityName"]);
             txtAddress.Text               = Convert.ToString(ds.Tables[0].Rows[0]["address"]);
             txtContactPerson.Text         = Convert.ToString(ds.Tables[0].Rows[0]["contactperson"]);
             txtcontactnumber.Text         = Convert.ToString(ds.Tables[0].Rows[0]["contactno"]);
             ddlCategory.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["Functions"]);
             rdbCompanyType.SelectedIndex  = 0;
             btnPostJob.Text               = "Edit";
             btnSubmit.Visible             = true;
             txtCompanyName.Enabled        = false;
             ddlState.Enabled              = false;
             ddlDistrict.Enabled           = false;
             ddlCity.Enabled               = false;
             txtAddress.Enabled            = false;
             txtcontactnumber.Enabled      = false;
             txtContactPerson.Enabled      = false;
             ddlCategory.Enabled           = false;
         }
     }
 }
    public void Bind_data()
    {
        bllobjCompanyDetails.Userid = Session["MarketingUser"].ToString();
        status = bllobjCompanyDetails.BLLCheckcompanyexist(bllobjCompanyDetails);
        if (status == 1)
        {
        }
        else
        {
            status = bllobjCompanyDetails.BLLCheckAdvertiseexist(bllobjCompanyDetails);
            if (status == 1)
            {
                DataSet ds = bllobjCompanyDetails.BLLViewCompanyDetailsonly(bllobjCompanyDetails);
                txtCompanyName.Text           = Convert.ToString(ds.Tables[0].Rows[0]["companyname"]);
                txtCompanyName1.Text          = Convert.ToString(ds.Tables[0].Rows[0]["companyname"]);
                ddlState.SelectedItem.Text    = Convert.ToString(ds.Tables[0].Rows[0]["stateName"]);
                ddlDistrict.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["distName"]);
                ddlCity.SelectedItem.Text     = Convert.ToString(ds.Tables[0].Rows[0]["cityName"]);
                txtAddress.Text               = Convert.ToString(ds.Tables[0].Rows[0]["address"]);
                txtaddress1.Text              = Convert.ToString(ds.Tables[0].Rows[0]["address"]);
                txtContactPerson.Text         = Convert.ToString(ds.Tables[0].Rows[0]["contactperson"]);
                txtcontactnumber.Text         = Convert.ToString(ds.Tables[0].Rows[0]["contactno"]);
                ddlCategory.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["Functions"]);
                string companytype = Convert.ToString(ds.Tables[0].Rows[0]["companytype"]);
                if (companytype == "Government")
                {
                    rdbCompanyType.SelectedIndex = 0;
                }
                else
                {
                    rdbCompanyType.SelectedIndex = 1;
                }
                btnPostJob.Text          = "Edit";
                btnSubmit1.Visible       = true;
                txtCompanyName.Enabled   = false;
                ddlState.Enabled         = false;
                ddlDistrict.Enabled      = false;
                ddlCity.Enabled          = false;
                txtAddress.Enabled       = false;
                txtcontactnumber.Enabled = false;
                txtContactPerson.Enabled = false;
                ddlCategory.Enabled      = false;
                rdbCompanyType.Enabled   = false;
            }
            //else
            //{
            //    DataSet ds = bllobjCompanyDetails.BLLViewCompanyDetailsonly(bllobjCompanyDetails);
            //    txtCompanyName.Text = Convert.ToString(ds.Tables[0].Rows[0]["companyname"]);
            //    ddlState.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["stateName"]);
            //    ddlDistrict.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["distName"]);
            //    ddlCity.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["cityName"]);
            //    txtAddress.Text = Convert.ToString(ds.Tables[0].Rows[0]["address"]);
            //    txtContactPerson.Text = Convert.ToString(ds.Tables[0].Rows[0]["contactperson"]);
            //    txtcontactnumber.Text = Convert.ToString(ds.Tables[0].Rows[0]["contactno"]);
            //    ddlCategory.SelectedItem.Text = Convert.ToString(ds.Tables[0].Rows[0]["Functions"]);
            //    btnPostJob.Text = "Edit";
            //    btnSubmit1.Text = "Edit";
            //    DataSet ds1 = bllobjCompanyDetails.BLLViewCompanyAdvertisment(bllobjCompanyDetails);
            //    //btnSearch.Visible = false;
            //   // txtmobileNo.Text = Convert.ToString(ds1.Tables[0].Rows[0]["contactno"]);
            //    txtCompanyName1.Text = Convert.ToString(ds1.Tables[0].Rows[0]["companyname"]);
            //    txtaddress1.Text = Convert.ToString(ds1.Tables[0].Rows[0]["address"]);
            //    txtFrom.Text = Convert.ToString(ds1.Tables[0].Rows[0]["advertise_Fromdate"]);
            //    txtTo.Text = Convert.ToString(ds1.Tables[0].Rows[0]["advertise_Todate"]);
            //    string adv = Convert.ToString(ds1.Tables[0].Rows[0]["advertise_to"]);
            //    foreach (DataRow dr in ds1.Tables[0].Rows)
            //    {

            //        string Id = Convert.ToString(dr["advertise_to"]);
            //        string[] arr = Id.Split(',');
            //        foreach (string s in arr)
            //        {
            //            for (int i = 0; i < lstNewspaper.Items.Count; i++)
            //            {
            //                if (lstNewspaper.Items[i].Text == s.ToString())
            //                {
            //                    lstNewspaper.Items[i].Selected = true;
            //                }
            //            }
            //        }
            //    }
            //    txtCompanyName.Enabled = false;
            //    ddlState.Enabled = false;
            //    ddlDistrict.Enabled = false;
            //    ddlCity.Enabled = false;
            //    txtAddress.Enabled = false;
            //    txtcontactnumber.Enabled = false;
            //    txtContactPerson.Enabled = false;
            //    ddlCategory.Enabled = false;
            //  //  btnSearch.Visible = false;
            //   // txtmobileNo.Enabled = false;
            //    txtCompanyName1.Enabled = false;
            //    txtaddress1.Enabled = false;
            //    fileAdvertise.Enabled = false;
            //    txtFrom.Enabled = false;
            //    txtTo.Enabled = false;
            //    lstNewspaper.Enabled = false;


            //}
        }
    }