private void FillCarDetails(List<CarsInfo.UsedCarsInfo> objCarInfo, string sCarid) { if (objCarInfo.Count > 0) { //------p--------// Hmake.Value = objCarInfo[0].MakeID.ToString(); Hmodel.Value = objCarInfo[0].MakeModelID.ToString(); HZip.Value = objCarInfo[0].Zip.ToString(); HPrice.Value = objCarInfo[0].Price.ToString(); //------------end-------// if (objCarInfo[0].IsActive == false) { soldCar.Visible = true; if (objCarInfo[0].AdStatus == "Active") { lblCarsoldStatus.Text = "This car is in Inactive status!"; mailsend.Visible = false; //return; } else if (objCarInfo[0].AdStatus != "Active") { soldcarid1.Visible = false; lblCarsoldStatus.Text = "This car is in " + objCarInfo[0].AdStatus + " status!"; mailsend.Visible = false; //return; } Session["zipId"] = objCarInfo[0].Zip; //yourZip.Value = objCarInfo[0].Zip; Title = "Buy Sell Used Cars " + (objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper() + " in " + objCarInfo[0].City.ToString().ToUpper() + ", " + objCarInfo[0].State.ToString().ToUpper(); if (objCarInfo[0].Title != "Emp") { //Title = "Buy " + lblTitle.Text.ToString() + " at UnitedCarExchange.com"; //lblTitle.Text = "Buy Sell Used " + EmptyCheck(objCarInfo[0].Title) + "in" + objCarInfo[0].City.ToString().ToUpper() + "," + objCarInfo[0].State.ToString().ToUpper(); lblTitle.Text = EmptyCheck(objCarInfo[0].Title); } else { lblTitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); } } else { if (objCarInfo[0].AdStatus != "Active") { soldCar.Visible = true; sold.Visible = false; lblCarsoldStatus.Text = "This car is in " + objCarInfo[0].AdStatus + " status!"; } else { soldCar.Visible = false; sold.Visible = false; } Session["zipId"] = objCarInfo[0].Zip; Title = "Buy Sell Used Cars " + (objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper() + " in " + objCarInfo[0].City.ToString().ToUpper() + ", " + objCarInfo[0].State.ToString().ToUpper(); if (objCarInfo[0].Title != "Emp") { //Title = "Buy " + lblTitle.Text.ToString() + " at UnitedCarExchange.com"; //lblTitle.Text = "Buy Sell Used " + EmptyCheck(objCarInfo[0].Title) + "in" + objCarInfo[0].City.ToString().ToUpper() + "," + objCarInfo[0].State.ToString().ToUpper(); lblTitle.Text = EmptyCheck(objCarInfo[0].Title); } else { lblTitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); } } Session["zipId"] = objCarInfo[0].Zip; Title = "Buy Sell Used Cars " + (objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper() + " in " + objCarInfo[0].City.ToString().ToUpper() + ", " + objCarInfo[0].State.ToString().ToUpper(); if (objCarInfo[0].Title != "Emp") { //Title = "Buy " + lblTitle.Text.ToString() + " at UnitedCarExchange.com"; //lblTitle.Text = "Buy Sell Used " + EmptyCheck(objCarInfo[0].Title) + "in" + objCarInfo[0].City.ToString().ToUpper() + "," + objCarInfo[0].State.ToString().ToUpper(); lblTitle.Text = EmptyCheck(objCarInfo[0].Title); LabelSubtitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); } else { //Main Title lblTitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); LabelSubtitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); //try //{ // DbDataReader dr; // string spNameString = string.Empty; // Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME); // spNameString = "[Usp_Caption]"; // DbCommand dbCommand = null; // dbCommand = dbDatabase.GetStoredProcCommand(spNameString); // dbDatabase.AddInParameter(dbCommand, "@CarID", DbType.Int64, sCarid); // IDataReader iDR = dbDatabase.ExecuteReader(dbCommand); // dr = (SqlDataReader)iDR; // if (dr.Read()) // { // LabelSubtitle.Text = dr["Caption"].ToString(); // } // else // { // lblTitle.Text = GeneralFunc.WrapTextByMaxCharacters((objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model).ToString().ToUpper(), 30); // } // dr.Close(); //} //catch { } } if (objCarInfo[0].Price.ToString() != "0") { lblPrice1.Text = "-$" + (EmptyCheck(objCarInfo[0].Price.ToString()) == "" ? "0" : EmptyCheck(objCarInfo[0].Price.ToString())); lblPrice.Text = "$" + (EmptyCheck(objCarInfo[0].Price.ToString()) == "" ? "0" : EmptyCheck(objCarInfo[0].Price.ToString())); } string city = GeneralFunc.ToProper(EmptyCheck(objCarInfo[0].City)); string address = EmptyCheck(objCarInfo[0].Address1.ToLower()).Trim(); address = GeneralFunc.ToProper(address); string state; if (objCarInfo[0].State.ToLower() != "unspecified") { state = EmptyCheck(objCarInfo[0].State.ToLower()).Trim(); } else { state = ""; } hdnCarid.Value = objCarInfo[0].Carid.ToString(); if (address != "" && address != " " && address != " " && (city != "" || state != "")) { address = (address).Trim(); address += ""; } else { address = ""; } HtmlMeta tag = new HtmlMeta(); tag.Name = "keywords"; //tag.Content = "Buy " + lblTitle.Text.ToString() + " at UnitedCarExchange.com"; tag.Content = "Buy Used Cars, Sell Used Cars, Buy Used " + objCarInfo[0].Make + ' ' + objCarInfo[0].Model.ToString().ToUpper() + " Car, Sell " + objCarInfo[0].Make + ' ' + objCarInfo[0].Model.ToString().ToUpper() + " Car, Buy Cars in " + objCarInfo[0].City + ' ' + objCarInfo[0].State.ToString().ToUpper() + ", Sell Cars in " + objCarInfo[0].City + ' ' + objCarInfo[0].State.ToString().ToUpper() + ""; Header.Controls.Add(tag); HtmlMeta tag1 = new HtmlMeta(); tag1.Name = "description"; //tag1.Content = EmptyCheck(objCarInfo[0].Description); tag1.Content = "Buy or Sell Used Cars " + objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make + ' ' + objCarInfo[0].Model.ToString().ToUpper() + " in " + objCarInfo[0].City.ToString().ToUpper() + "," + objCarInfo[0].State.ToString().ToUpper() + " for Price - " + objCarInfo[0].Price.ToString().ToUpper() + " Buy or Sell Used Cars at UnitedCarExchange.com"; Header.Controls.Add(tag1); // Page.Controls.Add(header); if (city != "" && state != "") { city = (city).Trim(); city += ", "; } else { city = ""; } if (state == "UN" || state == "0") { state = ""; } //address + ", " + if (Hadd.Value != "true") { yourZip.Value = EmptyCheck(objCarInfo[0].Zip.ToString()); } lblSellerAddress.Text = EmptyCheck(city + "" + state.ToUpper() + "" + EmptyCheck(objCarInfo[0].Zip.ToString()) + ""); lblSellerAddress2.Text = EmptyCheck(objCarInfo[0].Address2); if (EmptyCheck(objCarInfo[0].Phone.ToString()) != "") { lblSellerNo.Text = GeneralFunc.FormatUsTelephoneNo(Convert.ToInt64(EmptyCheck(objCarInfo[0].Phone))); } //lblSellerEmail.Value= EmptyCheck(objCarInfo[0].Email); Session["CustEmail"] = EmptyCheck(objCarInfo[0].Email); lblSellerType.Text = EmptyCheck(objCarInfo[0].SellerType); if (objCarInfo[0].Fueltype != "Unspecified") { lblFuelType.Text = EmptyCheck(objCarInfo[0].Fueltype); } lblSellerName.Text = EmptyCheck(objCarInfo[0].SellerName); zipcode.Value = EmptyCheck(objCarInfo[0].Zip.ToString()); //lblSellerAddress.Text = EmptyCheck(objCarInfo[0].Address1); //lblAxle.Text = (EmptyCheck(objCarInfo[0].Axle.ToString()) == "" ? "0" : EmptyCheck(objCarInfo[0].Axle.ToString())); lblMake.Text = EmptyCheck(objCarInfo[0].Make); lblModel.Text = EmptyCheck(objCarInfo[0].Model); lblSubTitle.Text = EmptyCheck(objCarInfo[0].Make) + " " + EmptyCheck(objCarInfo[0].Model); lblYear.Text = EmptyCheck(objCarInfo[0].YearOfMake.ToString()); if (objCarInfo[0].Mileage.ToString() != "0") { lblMileage.Text = EmptyCheck(objCarInfo[0].Mileage.ToString()) + " miles"; } //SimialarCars(objCarInfo[0].MakeID.ToString(), objCarInfo[0].MakeModelID.ToString(), objCarInfo[0].Zipcode.ToString(), objCarInfo[0].Price.ToString()); //For inline Adds Displaying data try { bool yearValid = false; bool Sellertype = false; String Year = DateTime.Now.Year.ToString(); if (Convert.ToInt32(Year) >= Convert.ToInt32(objCarInfo[0].YearOfMake.ToString()) && (Convert.ToInt32(Year) - 8) <= Convert.ToInt32(objCarInfo[0].YearOfMake.ToString())) { yearValid = true; } string Seller = objCarInfo[0].SellerType.ToString(); if (Seller == "Private Seller") { Sellertype = true; } if (Convert.ToInt32(objCarInfo[0].Price.ToString()) < 10000 && yearValid == true && Sellertype == true) { LinkAdd1.Visible = true; linkAdd2.Visible = false; LinkAdd3.Visible = false; } else if (Convert.ToInt32(objCarInfo[0].Price.ToString()) > 10000 && yearValid == true && Sellertype == true) { LinkAdd1.Visible = false; linkAdd2.Visible = true; LinkAdd3.Visible = true; } else { LinkAdd1.Visible = false; linkAdd2.Visible = false; LinkAdd3.Visible = false; } } catch { } //lblAxle.Text = EmptyCheck(objCarInfo[0].Axle); //lblType.Text = EmptyCheck(objCarInfo[0].TypeName); //lblCategory.Text = EmptyCheck(objCarInfo[0].Category); if (objCarInfo[0].ExteriorColor != "Unspecified") { lblExteriorColor.Text = EmptyCheck(objCarInfo[0].ExteriorColor); } if (objCarInfo[0].NumberOfCylinder != "Unspecified") { lblEngine.Text = EmptyCheck(objCarInfo[0].NumberOfCylinder); } if (objCarInfo[0].InteriorColor != "Unspecified") { lblInteriorColor.Text = EmptyCheck(objCarInfo[0].InteriorColor); } if (objCarInfo[0].ConditionDescription != "Unspecified") { lblVehicleCondition.Text = EmptyCheck(objCarInfo[0].ConditionDescription); } lblVin.Text = EmptyCheck(objCarInfo[0].VIN); if (objCarInfo[0].NumberOfDoors != "Unspecified") { lblDoors.Text = EmptyCheck(objCarInfo[0].NumberOfDoors); } if (objCarInfo[0].Bodytype != "Unspecified") { lblBodyStyle.Text = EmptyCheck(objCarInfo[0].Bodytype); } if (objCarInfo[0].Transmission != "Unspecified") { lblTransMission.Text = EmptyCheck(objCarInfo[0].Transmission); } //lblRear.Text = (EmptyCheck(objCarInfo[0].Rear.ToString()) == "" ? "0" : EmptyCheck(objCarInfo[0].Rear.ToString())); lblDescription.Text = Server.HtmlEncode(EmptyCheck(objCarInfo[0].Description)); if (objCarInfo[0].DriveTrain != "Unspecified") { lblDriveTrain.Text = EmptyCheck(objCarInfo[0].DriveTrain); } CarsBL.Transactions.NearZonesBL objNearZonesBL = new CarsBL.Transactions.NearZonesBL(); DataSet dsCities = new DataSet(); //if (Session["zipId"] != null) //{ // dsCities = objNearZonesBL.GetNearCities(Session["zipId"].ToString()); // if (dsCities.Tables[0].Rows.Count > 0) // { // for (int i = 0; i < dsCities.Tables[0].Rows.Count; i++) // { // if (i == 0) // { // lblNearbyzipcodes.Text = dsCities.Tables[0].Rows[i][1].ToString(); // } // else // { // lblNearbyzipcodes.Text = lblNearbyzipcodes.Text + ',' + dsCities.Tables[0].Rows[i][1].ToString(); // } // } // } //} //if (Session["zipId"] != null) //{ // dsCities = objNearZonesBL.GetNearCities(Session["zipId"].ToString()); // if (dsCities.Tables[0].Rows.Count > 0) // { // for (int i = 0; i < dsCities.Tables[0].Rows.Count; i++) // { // Literal Li = new Literal(); // if (i == 0) // { // lblNearbyzipcodes.Text = dsCities.Tables[0].Rows[i][1].ToString(); // } // else // { // lblNearbyzipcodes.Text = lblNearbyzipcodes.Text + ", " + dsCities.Tables[0].Rows[i][1].ToString(); // } // } // } //} //lblsellerName1.Text = objCarInfo[0].SellerName; lblSellarname2.Text = EmptyCheck(objCarInfo[0].SellerName); if (EmptyCheck(objCarInfo[0].Phone.ToString()) != "") { lblphone.Text = GeneralFunc.FormatUsTelephoneNo(Convert.ToInt64(EmptyCheck(objCarInfo[0].Phone))); } lblPrice3.Text = "$" + (EmptyCheck(objCarInfo[0].Price.ToString()) == "" ? "0" : EmptyCheck(objCarInfo[0].Price.ToString())); lblCartitle.Text = objCarInfo[0].YearOfMake.ToString() + ' ' + objCarInfo[0].Make.ToString().ToUpper() + ' ' + objCarInfo[0].Model.ToString().ToUpper(); lblSellarAddress.Text = EmptyCheck(city + "" + state.ToUpper() + "" + EmptyCheck(objCarInfo[0].Zip.ToString()) + ""); dsCities = objNearZonesBL.GetNearStates(Session["zipId"].ToString()); //allegan, Michigan (MI); caledonia if (dsCities.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsCities.Tables[0].Rows.Count; i++) { Literal Li = new Literal(); if (i == dsCities.Tables[0].Rows.Count - 1) { Li.Text = (dsCities.Tables[0].Rows[i][2].ToString()).Trim() + " " + ((dsCities.Tables[0].Rows[i][1].ToString()).Trim()) +" " +"(" + (dsCities.Tables[0].Rows[i][3].ToString()) + "); "; } else { // Li.Text = (dsCities.Tables[0].Rows[i][2].ToString()).Trim() + " " + ((dsCities.Tables[0].Rows[i][1].ToString()).Trim()) + "(" + (dsCities.Tables[0].Rows[i][3].ToString()) + "), "; //---- starts 05-08-2013------------// string s = dsCities.Tables[0].Rows[i][1].ToString(); s = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(s.ToLower()); Li.Text = " "+(dsCities.Tables[0].Rows[i][2].ToString()) + "," + s + " "+"(" + (dsCities.Tables[0].Rows[i][3].ToString()) + "); "; //--------End-----------------------// ///('ul.towns').append('<li class="st">'+$.trim(state[2])+', '+$.trim(state[1])+'('+$.trim(state[3])+');</li>'); } ulTowns.Controls.Add(Li); } } GetCarPictures(sCarid); try { lblMileage.Text = lblMileage.Text + "mi"; } catch { } ClientScript.RegisterStartupScript(this.GetType(), "KyAUIDFCS", "<script language='javascript' type='text/javascript'>slidershow();</script>"); CarFeatures objCarFeatures = new CarFeatures(); DataSet ds = GetCarFeatures(sCarid); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { dlFeature.DataSource = ds.Tables[0]; dlFeature.DataBind(); } } } else { Response.Redirect("errorpage.aspx"); } }
public ArrayList GetNearStates() { ArrayList Al = new ArrayList(); DataSet dsCities = new DataSet(); CarsBL.Transactions.NearZonesBL objNearZonesBL = new CarsBL.Transactions.NearZonesBL(); if (Session["zipId"] != null) { dsCities = objNearZonesBL.GetNearStates(Session["zipId"].ToString()); if (dsCities.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsCities.Tables[0].Rows.Count; i++) { Al.Add(dsCities.Tables[0].Rows[i][0].ToString() + ',' + dsCities.Tables[0].Rows[i][1].ToString() + ',' + dsCities.Tables[0].Rows[i][2].ToString() + ',' + dsCities.Tables[0].Rows[i][3].ToString()); } } } ///XmlWriteMode OBJ = new XmlWriteMode(); //CarsBL.Transactions. objCarsearch = new CarsBL.UsedCarsSearch(); return Al; }