public ArrayList GetCarFeatures(string sCarId, string AuthenticationID, string CustomerID)
{
DataSet ds = new DataSet();
CarFeatures objCarFeatures = new CarFeatures();
ArrayList arr = new ArrayList();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("GetCarFeatures", CustomerID,AuthenticationID,sCarId);
}
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
ds = objCarFeatures.GetCarFeatures(sCarId);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
arr.Add(ds.Tables[0].Rows[i]["FeatureTypeName"].ToString() + "," + ds.Tables[0].Rows[i]["FeatureName"].ToString());
}
}
}
return arr;
}
public ArrayList GetCarFeatures(string sCarId)
{
DataSet ds = new DataSet();
CarFeatures objCarFeatures = new CarFeatures();
ArrayList arr = new ArrayList();
ds = objCarFeatures.GetCarFeatures(sCarId);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
arr.Add(ds.Tables[0].Rows[i]["FeatureTypeName"].ToString() + "," + ds.Tables[0].Rows[i]["FeatureName"].ToString());
}
}
return arr;
}
public DataSet GetCarFeatures(string sCarId)
{
DataSet ds = new DataSet();
CarFeatures objCarFeatures = new CarFeatures();
ArrayList arr = new ArrayList();
DataSet dsNewFeatures = new DataSet();
dsNewFeatures.Tables.Add();
dsNewFeatures.Tables[0].Columns.Add("FeatureTypeName");
dsNewFeatures.Tables[0].Columns.Add("FeatureName");
ds = objCarFeatures.GetCarFeatures_New(sCarId);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
dsNewFeatures.Tables[0].Rows.Add();
dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][0] = ds.Tables[0].Rows[i]["FeatureTypeName"].ToString();
dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][1] = ds.Tables[0].Rows[i]["FeatureName"].ToString();
}
else
{
if (ds.Tables[0].Rows[i - 1]["FeatureTypeName"].ToString().Trim() != ds.Tables[0].Rows[i]["FeatureTypeName"].ToString().Trim())
{
dsNewFeatures.Tables[0].Rows.Add();
dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][0] = ds.Tables[0].Rows[i]["FeatureTypeName"].ToString();
dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][1] = ds.Tables[0].Rows[i]["FeatureName"].ToString();
}
else if (ds.Tables[0].Rows[i - 1]["FeatureTypeName"].ToString().Trim() == ds.Tables[0].Rows[i]["FeatureTypeName"].ToString().Trim())
{
dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][1] = dsNewFeatures.Tables[0].Rows[dsNewFeatures.Tables[0].Rows.Count - 1][1] + ", " + ds.Tables[0].Rows[i]["FeatureName"].ToString();
}
}
}
}
return dsNewFeatures;
}
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");
}
}
/// <summary>
/// New Modified shravan 0614 2012
/// </summary>
/// <param name="strMailFormat"></param>
/// <param name="dtMultiSite"></param>
/// <param name="CarsDetails"></param>
public string SendMultiListMail(ref string strMailFormat, DataTable dtMultiSite, string Carid, string PackageName, string RegName, string UniqueID)
{
string strMail = string.Empty;
List<CarsInfo.UsedCarsInfo> obUsedCarsInfo = new List<CarsInfo.UsedCarsInfo>();
UsedCarsSearch obj = new UsedCarsSearch();
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)obj.FindCarID(Carid);
string SellerName = obUsedCarsInfo[0].SellerName;
string Phone = obUsedCarsInfo[0].Phone;
string Address = obUsedCarsInfo[0].Address1;
string City = obUsedCarsInfo[0].City;
string State = obUsedCarsInfo[0].State;
int PriceAsk = Convert.ToInt32(obUsedCarsInfo[0].Price.ToString());
string Price = string.Empty;
if (PriceAsk != 0)
{
Price = string.Format("{0:C0}", PriceAsk);
}
else
{
Price = "";
}
int MileageGiven = Convert.ToInt32(obUsedCarsInfo[0].Mileage.ToString());
System.Globalization.NumberFormatInfo nfi;
nfi = new System.Globalization.NumberFormatInfo();
nfi.CurrencySymbol = "";
string Mileage = string.Empty;
if (MileageGiven != 0)
{
Mileage = string.Format(nfi, "{0:C0}", MileageGiven);
}
else
{
Mileage = "";
}
if (Address == "Emp")
{
Address = "";
}
if (City == "Emp")
{
City = "";
}
if (RegName == "")
{
SellerName = "";
}
else
{
SellerName = RegName;
}
if (Phone == "Emp")
{
Phone = " ";
}
else
{
Phone = objGeneralFunc.filPhnm(obUsedCarsInfo[0].Phone.ToString());
}
string path = string.Empty;
if (obUsedCarsInfo[0].PIC0 != "Emp")
{
path = obUsedCarsInfo[0].PICLOC0 + "/" + obUsedCarsInfo[0].PIC0;
for (int k = 0; k < 3; k++)
{
path = path.Replace("\\", "/");
}
path = path.Replace("//", "/");
path = path.Replace(" ", "%20");
}
else
{
string carMake = obUsedCarsInfo[0].Make;
string carModel = obUsedCarsInfo[0].Model;
carMake = carMake.Replace(' ', '-');
carModel = carModel.Replace(' ', '-');
carModel = carModel.Replace('/', '@');
//if (carModel.IndexOf('/') > 0)
//{
// carModel = "Other";
//}
var MakeModel = carMake + "_" + carModel;
MakeModel = MakeModel.Replace(' ', '-');
path = "images/MakeModelThumbs/" + MakeModel + ".jpg";
}
string sDescription = string.Empty;
if (obUsedCarsInfo[0].Description == "Emp")
{
sDescription = "";
}
else
{
sDescription = obUsedCarsInfo[0].Description;
}
string makeForUrl = obUsedCarsInfo[0].Make;
makeForUrl = makeForUrl.Replace(" ", "%20");
string ModelForUrl = obUsedCarsInfo[0].Model;
ModelForUrl = ModelForUrl.Replace(" ", "%20");
ModelForUrl = ModelForUrl.Replace("&", "@");
strMail += "<table width=\"100%\" bgcolor=\"#fff\" style=\"float:left;background-color:rgb(255,255,255);font-family:Arial,'sans serif'\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td align=\"center\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
strMail += "<tbody>";
strMail += "<tr>"; ;
strMail += "<td colspan=\"3\"> </td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td colspan=\"2\" valign=\"top\" height=\"359\"><img src=\"http://smartz.unitedcarexchange.com/images/shadow-top-left.png\"></td>";
strMail += "<td rowspan=\"2\"><table width=\"730\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td bgcolor=\"#2d2d2d\" height=\"42\" valign=\"middle\"><table width=\"100%\" cellspacing=\"0\" valign=\"middle\" cellpadding=\"0\">";
strMail += "<tbody>";
strMail += "<tr>"; ;
strMail += "<td colspan=\"4\" height=\"2\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td width=\"12\"></td>";
strMail += "<td width=\"453\" style=\"color:#fff;font-size:12px;font-family:Arial,'sans serif'\"> Multi-Site Promotion Report for: ";
//Car Year Make Model text start
strMail += "<strong>";
strMail += obUsedCarsInfo[0].YearOfMake + " " + obUsedCarsInfo[0].Make + " " + obUsedCarsInfo[0].Model;
strMail += "</strong></td>";
strMail += "<td width=\"243\" align=\"right\" style=\"font-size:12px;color:rgb(255,197,190);padding-right:10px; font-weight:normal;\">";
//Customer Name and Phone Number string
///strMail += "Cynthia Nusbaum (518-821-9009)";
strMail += SellerName + " " + (Phone) + "<br />";
//report date start
strMail += "<span style=\"color:#fff;font-size:12px; font-weight:normal;\">Report Date: ";
strMail += string.Format("{0:MM/dd/yyy}", System.DateTime.Now.ToString());
strMail += "</span></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td bgcolor=\"#c32c2c\" height=\"6\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"239\" style=\"background:url(http://smartz.unitedcarexchange.com/images/newsletter.jpg) center no-repeat\"><table cellpadding=\"0\" cellspacing=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td height=\"156\"></td>";
strMail += "<td></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td width=\"8\"></td>";
strMail += "<td height=\"30\" style=\"text-shadow:rgb(102,102,102) 1px 1px;color:#fff;font-size:14px;font-weight:bold;font-family:Arial,'sans serif'\"><a href=\"http://unitedcarexchange.com/\" target=\"_blank\">";
strMail += "<div style=\"width:214px;min-height:68px;border:none;outline:none; position:relative; top:-158px\"> </div>";
strMail += " </a></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += "</table>";
strMail += "<table width=\"730\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td>";
strMail += "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td width=\"30\">";
strMail += "</td>";
strMail += "<td style=\"color: rgb(51,51,51); font-size: 14px; line-height: 20px; font-family: Arial,'sans serif'\"";
strMail += "valign=\"top\">";
strMail += "<h3 style=\"font-family: HelveticaNeueBold,HelveticaNeue-Bold,'Helvetica Neue Bold',helvetica,arial,'sans serif';";
strMail += "line-height: 25px; font-size: 22px; color: #CB3024; text-align: left; margin-bottom: 10px\">";
strMail += "Key Listing Parameters</h3>";
strMail += "<table style=\"margin: 0px; padding: 0px; font-size: 12px; color: #232323; width: 438px;";
strMail += "background: #ccc;\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\" width=\"125\">";
strMail += "<strong>Registrant Name</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += SellerName;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Email Address</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += obUsedCarsInfo[0].Email;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Phone</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += Phone;
strMail += "</td>";
strMail += "</tr>";
//strMail += "<tr>";
//strMail += "<td style=\"background: #fff; padding: 5px\">";
//strMail += "<strong>Package Type</strong>";
//strMail += "</td>";
//strMail += "<td style=\"background: #fff; padding: 5px\">";
//strMail += PackageName;
//strMail += "</td>";
//strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Make</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += obUsedCarsInfo[0].Make;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Model</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += obUsedCarsInfo[0].Model;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Year</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += obUsedCarsInfo[0].YearOfMake;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Mileage</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
if (Mileage != "")
{
strMail += Mileage + "ml";
}
else
{
strMail += Mileage;
}
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>Asking Price</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += Price;
strMail += "</td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<strong>United Car Exchange Listing Link</strong>";
strMail += "</td>";
strMail += "<td style=\"background: #fff; padding: 5px\">";
strMail += "<a href='http://unitedcarexchange.com/Buy-Sell-UsedCar/" + obUsedCarsInfo[0].YearOfMake + "-" + makeForUrl + "-" + ModelForUrl + "-" + UniqueID + "'" + " style=\"color: #CB3024\" target=\"_blank\">";
strMail += " Click here</a>";
strMail += "</td>";
strMail += "</tr>";
strMail += "</tbody>";
strMail += "</table>";
strMail += "</td>";
strMail += "<td width=\"30\">";
strMail += "</td>";
strMail += "<td style=\"width: 200px;padding-top:50px;\" valign=\"top\">";
//strMail += "<a target=\"_blank\" href='http://unitedcarexchange.com/SearchCarDetails.aspx?Make=" + obUsedCarsInfo[0].Make.ToString() + "&Model=" + obUsedCarsInfo[0].Model.ToString() + "&ZipCode=0&WithinZip=5&C=4zVbl2Mc" + obUsedCarsInfo[0].Carid.ToString() + "'";
strMail += "<img src='http://unitedcarexchange.com/" + path + "'" + " style=\"margin-top: 4px\" border=\"0\" width=\"200\">";
//strMail += "</a>";
strMail += " <br>";
strMail += "</td>";
strMail += "<td width=\"30\">";
strMail += "</td>";
strMail += "</tr>";
strMail += "</tbody>";
strMail += "</table>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"1\" style=\"border-top:1px dotted #C7C7C7\"> </td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
if (dtMultiSite.Rows.Count > 0)
{
strMail += "<tr>";
strMail += "<td><table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td width=\"30\"></td>";
strMail += "<td valign=\"top\" style=\"color:rgb(51,51,51);font-size:14px;line-height:20px;font-family:Arial,'sans serif'\">";
strMail += "<h3 style=\"font-family:HelveticaNeueBold,HelveticaNeue-Bold,'Helvetica Neue Bold',helvetica,arial,'sans serif';line-height:25px;font-size:22px;color:#CB3024;text-align:left;margin-bottom:10px\">Multi - Site Submitted URLs</h3>";
strMail += "<table border=\"0\" cellspacing=\"1\" cellpadding=\"0\" style=\"margin:0px;padding:0px;font-size:12px;width:668px;color:rgb(18,18,18);overflow:hidden; background:#ccc;\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td style=\"width:200px; background:#ccc; padding:5px\"><strong style=\"color:#333; text-decoration:none\">Site Name</strong></td>";
strMail += "<td style=\"background:#ccc; padding:5px\"><strong style=\"color:#333; text-decoration:none\">Posted URL</strong></td>";
strMail += "<td style=\"width:80px;background:#ccc; padding:5px\"><strong style=\"color:#333; text-decoration:none\">Post Date</strong></td>";
//strMail += "<td style=\"width:80px;background:#ccc; padding:5px\"><strong style=\"color:#333; text-decoration:none\">Expiry Date</strong></td>";
strMail += "</tr>";
for (int i = 0; i < dtMultiSite.Rows.Count; i++)
{
strMail += "<tr>";
strMail += "<td style=\"width:200px; background:#fff; padding:5px\"><strong style=\"color:#333; text-decoration:none\">";
strMail += "<a href=\"#\" style=\"color:#232323\">" + objGeneralFunc.WrapTextByMaxCharacters(dtMultiSite.Rows[i]["SiteName"].ToString(), 30) + "</a></strong></td>";
strMail += "<td style=\"background:#fff; padding:5px\"><a href='http://" + dtMultiSite.Rows[i]["URL"].ToString() + "'" + " target=\"_blank\" style=\"color:#CB3024\">";
strMail += "" + objGeneralFunc.WrapTextByMaxCharacters(dtMultiSite.Rows[i]["URL"].ToString(), 40) + "</a></td>";
strMail += "<td style=\"width:80px;background:#fff; padding:5px\">";
DateTime dtPostDt = Convert.ToDateTime(dtMultiSite.Rows[i]["UrlPostDate"].ToString());
string urlPostDate = string.Empty;
string urlExpiryDate = string.Empty;
urlPostDate = dtPostDt.ToString("MM/dd/yy");
if (dtMultiSite.Rows[i]["ValidDays"].ToString() != "")
{
int ValidDays = Convert.ToInt32(dtMultiSite.Rows[i]["ValidDays"].ToString());
DateTime dtValidTill = Convert.ToDateTime(dtPostDt.AddDays(ValidDays).ToString());
urlExpiryDate = dtValidTill.ToString("MM/dd/yy");
}
else
{
urlExpiryDate = "Not Available";
}
strMail += urlPostDate + "</td>";
//strMail += "<td style=\"width:80px;background:#fff; padding:5px\">";
//strMail += urlExpiryDate + "</td>";
strMail += "</tr>";
}
strMail += " </tbody>";
strMail += " </table>";
strMail += " </td>";
strMail += "<td width=\"30\"></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"18\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"1\" style=\"border-top:1px dotted #C7C7C7\"> </td>";
strMail += "</tr>";
}
strMail += "<tr>";
strMail += "<td><table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td width=\"30\"></td>";
strMail += "<td valign=\"top\" style=\"color:#333; font-size:12px;\"><h3 style=\"font-family:HelveticaNeueBold,HelveticaNeue-Bold,'Helvetica Neue Bold',helvetica,arial,'sans serif';line-height:25px;font-size:22px;color:#CB3024;text-align:left;margin-bottom:10px\">";
strMail += "UCE Listing Preview</h3>";
strMail += "<table style=\"width: 100%; margin-top: 25px; font-size:12px; color:#333;\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td colspan=\"2\"><h2 style=\"font-size:15px; margin:0 0 2px 0; line-height:15px; padding:0\">";
strMail += obUsedCarsInfo[0].YearOfMake + " " + obUsedCarsInfo[0].Make + " " + obUsedCarsInfo[0].Model;
if (Price != "")
{
strMail += " - ";
}
strMail += "<span style=\"color:#ff9900\">" + Price + "</span></h2></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td style=\" width:50%; vertical-align: top; line-height:17px\"><strong>Phone: </strong>" + Phone + " <br>";
strMail += "<strong>Email: </strong>" + obUsedCarsInfo[0].Email + " <br>";
strMail += "</td>";
strMail += "<td style=\"vertical-align: top; line-height:17px\"><span style=\"text-transform: capitalize; \">";
strMail += "<strong>Car Location: </strong>";
if (City != "")
{
if (State != "Unspecified")
{
strMail += City + ", ";
}
else
{
strMail += City + " ";
}
}
if (State != "Unspecified")
{
strMail += State + " ";
}
strMail += obUsedCarsInfo[0].Zipcode;
strMail += "</span><br />";
strMail += "<strong>Seller Type: </strong>Private Seller<br>";
strMail += "</td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table>";
strMail += " <br />";
strMail += "<h2 style=\"font-size:15px; color:#ff9900; margin:0 0 2px 0; line-height:15px; padding:0;\">";
//Make Model
strMail += "About This " + obUsedCarsInfo[0].Make.ToString() + " " + obUsedCarsInfo[0].Model.ToString() + "</h2>";
strMail += "<table style=\"width:99%; margin:0; font-size:12px; color:#333;\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td style=\"width:50%;vertical-align:top; line-height:17px\"><strong>Make: </strong>" + obUsedCarsInfo[0].Make.ToString() + "<br>";
strMail += "<strong>Model: </strong> " + obUsedCarsInfo[0].Model.ToString() + "<br>";
strMail += "<strong>Year: </strong> ";
strMail += obUsedCarsInfo[0].YearOfMake.ToString() + "<br>";
strMail += "<strong>Body Style: </strong> ";
if (obUsedCarsInfo[0].Bodytype.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].Bodytype.ToString();
}
strMail += "<br><strong>Exterior Color: </strong>";
if (obUsedCarsInfo[0].ExteriorColor.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].ExteriorColor.ToString();
}
strMail += "<br><strong>Interior Color: </strong>";
if (obUsedCarsInfo[0].InteriorColor.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].InteriorColor.ToString();
}
strMail += "<br><strong>Doors: </strong>";
if (obUsedCarsInfo[0].NumberOfDoors.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].NumberOfDoors.ToString();
}
strMail += "<br><strong>Vehicle Condition: </strong>";
if (obUsedCarsInfo[0].ConditionDescription.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].ConditionDescription.ToString();
}
strMail += " <br></td><td valign=\"top\" style=\"line-height:17px\"><strong>Price: </strong>" + Price + "<br>";
strMail += "<strong>Mileage: </strong>";
if (Mileage != "")
{
strMail += Mileage + "ml";
}
strMail += "<br><strong>Fuel: </strong>";
if (obUsedCarsInfo[0].Fueltype.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].Fueltype.ToString();
}
strMail += "<br><strong>Engine: </strong>";
if (obUsedCarsInfo[0].NumberOfCylinder.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].NumberOfCylinder.ToString();
}
strMail += "<br><strong>Transmission: </strong>";
if (obUsedCarsInfo[0].Transmission.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].Transmission.ToString();
}
strMail += "<br><strong>DriveTrain: </strong>";
if (obUsedCarsInfo[0].DriveTrain.ToString() != "Unspecified")
{
strMail += obUsedCarsInfo[0].DriveTrain.ToString();
}
strMail += "<br><strong>VIN: </strong>";
if (obUsedCarsInfo[0].VIN.ToString() != "Emp")
{
strMail += obUsedCarsInfo[0].VIN.ToString();
}
strMail += "<br></td></tr>";
strMail += " </tbody>";
strMail += " </table>";
strMail += " <p style=\"font-size:12px; padding:0; line-height:18px\">";
strMail += " <h2 style=\"font-size:15px; margin:0 0 2px 0; line-height:15px; padding:0; color:#ff9900\">Car Specifications</h2>";
string lblComFeature = string.Empty;
string lblSeatsFea = string.Empty;
string lblSafetyFea = string.Empty;
string lblSoundFea = string.Empty;
string lblWindowsFea = string.Empty;
string lblOtherFea = string.Empty;
string lblNewFea = string.Empty;
string lblSpecialsFea = string.Empty;
CarFeatures objCarFeatures = new CarFeatures();
DataSet CarsDetails = objCarFeatures.GetCarFeatures(Carid);
if (CarsDetails.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < CarsDetails.Tables[0].Rows.Count; k++)
{
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "1")
{
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "1")
{
if (lblComFeature == "")
{
lblComFeature = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblComFeature = lblComFeature + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "2")
{
if (lblSeatsFea == "")
{
lblSeatsFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblSeatsFea = lblSeatsFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "3")
{
if (lblSafetyFea == "")
{
lblSafetyFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblSafetyFea = lblSafetyFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "4")
{
if (lblSoundFea == "")
{
lblSoundFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblSoundFea = lblSoundFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "5")
{
if (lblWindowsFea == "")
{
lblWindowsFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblWindowsFea = lblWindowsFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "6")
{
if (lblOtherFea == "")
{
lblOtherFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblOtherFea = lblOtherFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "7")
{
if (lblNewFea == "")
{
lblNewFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblNewFea = lblNewFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
if (CarsDetails.Tables[0].Rows[k]["FeatureTypeID"].ToString() == "8")
{
if (lblSpecialsFea == "")
{
lblSpecialsFea = CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
else
{
lblSpecialsFea = lblSpecialsFea + ", " + CarsDetails.Tables[0].Rows[k]["FeatureName"].ToString();
}
}
}
}
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Comfort: </strong>" + lblComFeature + "</p>";
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Seats: </strong>" + lblSeatsFea + "</p>";
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Safety: </strong>" + lblSafetyFea + "</p>";
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Sound: </strong>" + lblSoundFea + "</p>";
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Windows: </strong>" + lblWindowsFea + "</p>";
strMail += " <p style=\"line-height:18px; padding:0; margin:0;\"><strong>Other: </strong>" + lblOtherFea + "</p>";
strMail += " </p>";
strMail += " <p style=\" font-size:12px; padding:0\"> <strong style=\"font-size:15px; color:#ff9900\">Description: </strong>" + sDescription + "</p>";
//strMail += " <p style=\"font-size:11px; padding:0\"> <strong style=\" font-size: 15px; color:#ff9900\">Surrounding towns: </strong>Berlin, CONNECTICUT(CT); Bloomfield, CONNECTICUT(CT); Branford, CONNECTICUT(CT); Coventry, CONNECTICUT(CT); Danbury, CONNECTICUT(CT); Hamden, CONNECTICUT(CT); </p>";
//strMail += " <p style=\"font-size:11px; padding:0\"> <strong style=\" font-size:15px; color:#ff9900\">Near by zip codes: </strong>11701, 06401, 07712, 01721, 07716, 01501, 07001, 01436, 06063, 11706, 07002, 11361, 12508, 10506, 10507, 11426, 11710, 07719, 07621, 02779, 06037 </p></td>";
strMail += "<td width=\"30\"></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"1\" style=\"border-top:1px dotted #C7C7C7\"> </td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td><table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">";
strMail += "<tbody>";
strMail += "<tr>";
strMail += "<td width=\"30\"></td>";
strMail += "<td valign=\"top\" style=\"color:rgb(51,51,51);font-size:12px;line-height:20px;font-family:Arial,'sans serif'\"><h1 style=\"font-family:HelveticaNeueBold,HelveticaNeue-Bold,'Helvetica Neue Bold',helvetica,arial,'sans serif';color:rgb(32,31,31);font-size:22px;line-height:25px\"> About United Car Exchange</h1>";
strMail += "<p><span style=\"color:#CB3024\">United Car Exchange</span> is the america's most trusted online buy & sell used car agency. United car exchange helps in providing an online platform where car buyers and sellers can search, buy, sell and come together to talk about their used/new cars.</p>";
strMail += "You can contact us any time at our customer contact no: <span style=\"color:#CB3024\">888-786-8307</span> </td>";
strMail += "<td width=\"30\"></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"1\" style=\"border-top:1px dotted #C7C7C7\"> </td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td align=\"center\" style=\"color:underline;font-size:12px;font-weight:normal;font-family:Arial,'sans serif'\"><a href=\"http://unitedcarexchange.com/Default.aspx\" style=\"color:#0000FF;text-decoration:underline\" target=\"_blank\">unitedcarexchange.com</a> | <a href=\"http://unitedcarexchange.com/usedcars.aspx\" style=\"color:#0000FF;text-decoration:underline\" target=\"_blank\">Used Cars</a> | <a href=\"http://unitedcarexchange.com/Packages.aspx\" style=\"color:#0000FF;text-decoration:underline\" target=\"_blank\">Sell A Car</a> | <a href=\"http://unitedcarexchange.com/TermsandConditions.aspx\" style=\"color:#0000FF;text-decoration:underline\" target=\"_blank\">T&C </a> | <a href=\"http://unitedcarexchange.com/ContactUs.aspx\" style=\"color:#0000FF;text-decoration:underline\" target=\"_blank\">Contact Us</a></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"10\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td bgcolor=\"#efefef\" height=\"10\"></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += " </table></td>";
strMail += "<td colspan=\"2\" valign=\"top\"><img src=\"http://smartz.unitedcarexchange.com/images/shadow-top-right.png\" style=\"margin-top:1px\"></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td> </td>";
strMail += "<td width=\"4\" background=\"http://smartz.unitedcarexchange.com/images/shadow-left.png\"></td>";
strMail += "<td width=\"4\" background=\"http://smartz.unitedcarexchange.com/images/shadow-right.png\"></td>";
strMail += "<td> </td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td colspan=\"2\"></td>";
strMail += "<td><img src=\"http://smartz.unitedcarexchange.com/images/shadow-bottom.png\" ></td>";
strMail += "<td colspan=\"2\"></td>";
strMail += "</tr>";
strMail += " </tbody>";
strMail += "</table></td>";
strMail += "</tr>";
strMail += "<tr>";
strMail += "<td height=\"40\"></td>";
strMail += "</tr>";
strMail += "</tbody>";
strMail += "</table>";
return strMail;
}
