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;
}
