public List <CarsInfo.UsedCarsInfo> GetCarsSearchJSON(string carMakeid, string CarModalId, string ZipCode, string WithinZip, string pageNo, string pageresultscount, string orderby, string AuthenticationID, string CustomerID)
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List <CarsInfo.UsedCarsInfo>();
MobileBL objMobileBL = new MobileBL();
string sort = string.Empty;
if (orderby != "")
{
orderby = "price";
}
if (sort != "")
{
sort = "desc";
}
string IPAddress = string.Empty;
string SearchName = string.Empty;
if (CustomerID.Trim() != "")
{
string parameters = carMakeid + "," + CarModalId + "," + ZipCode + "," + WithinZip + "," + orderby;
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("GetCarsSearchJSON", CustomerID, AuthenticationID, parameters);
}
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
obj = (List <CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCars(carMakeid, CarModalId, ZipCode, WithinZip, pageNo, pageresultscount, orderby, sort);
}
return(obj);
}
public List<CarsInfo.UsedCarsInfo> FindCarID(string sCarid, string AuthenticationID, string CustomerID)
{
List<CarsInfo.UsedCarsInfo> obUsedCarsInfo = new List<CarsInfo.UsedCarsInfo>();
UsedCarsSearch obj = new UsedCarsSearch();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("FindCarID", CustomerID,AuthenticationID,sCarid);
}
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)obj.FindCarID(sCarid);
}
return obUsedCarsInfo;
}
public List<CarsInfo.UsedCarsInfo> FindCarID(string sCarid)
{
List<CarsInfo.UsedCarsInfo> obUsedCarsInfo = new List<CarsInfo.UsedCarsInfo>();
UsedCarsSearch obj = new UsedCarsSearch();
//if (Session["SearchCarsdata"] != null)
//{
// obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)Session["SearchCarsdata"];
// obUsedCarsInfo = obUsedCarsInfo.FindAll(p => p.Carid == Convert.ToInt32(sCarid));
// Session["SearchedData"] = obUsedCarsInfo;
//}
//else
//{
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)obj.FindCarID(sCarid);
// }
return obUsedCarsInfo;
}
public List<CarsInfo.UsedCarsInfo> GetCarsSearchJSON(string carMakeid, string CarModalId, string ZipCode, string WithinZip, string pageNo, string pageresultscount, string orderby, string AuthenticationID, string CustomerID)
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List<CarsInfo.UsedCarsInfo>();
MobileBL objMobileBL = new MobileBL();
string sort = string.Empty;
if (orderby != "")
{
orderby = "price";
}
if (sort != "")
{
sort = "desc";
}
string IPAddress = string.Empty;
string SearchName = string.Empty;
if (CustomerID.Trim() != "")
{
string parameters=carMakeid+","+CarModalId+","+ZipCode+","+WithinZip+","+orderby;
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("GetCarsSearchJSON", CustomerID,AuthenticationID,parameters);
}
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCars(carMakeid, CarModalId, ZipCode, WithinZip, pageNo, pageresultscount, orderby, sort);
}
return obj;
}
private void SimialarCars(string MakeId, string ModelID, string zipcode, string Price)
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List<CarsInfo.UsedCarsInfo>();
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SimialarCars(MakeId, ModelID, zipcode, Price);
dlSimilarResults.DataSource = obj;
Session["SimilarResults"] = obj;
dlSimilarResults.DataBind();
}
/// <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;
}
public List<CarsInfo.UsedCarsInfo> GetCarsSearchJSON(string carMakeid, string CarModalId, string ZipCode, string WithinZip, string pageNo, string pageresultscount, string orderby)
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List<CarsInfo.UsedCarsInfo>();
string sort = string.Empty;
if (orderby != "")
{
orderby = "price";
}
if (sort != "")
{
sort = "desc";
}
string IPAddress = string.Empty;
string SearchName = string.Empty;
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCars(carMakeid, CarModalId, ZipCode, WithinZip, pageNo, pageresultscount, orderby, sort);
return obj;
}
public List<CarsInfo.UsedCarsInfo> GetCarsAds()
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List<CarsInfo.UsedCarsInfo>();
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.GetCarAdsNew();
return obj;
}
public List<CarsInfo.UsedCarsInfo> GetCarsFilterMulti(ArrayList AFilter, int PageResultsCount)
{
//List<CarsInfo.UsedCarsInfo> obj = null;
Session["FilterArray"] = AFilter;
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
List<CarsInfo.UsedCarsInfo> obAddedItems = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objMileage = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objYear = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objPrice = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objBodytype = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objFuelType = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> objSellerType = new List<CarsInfo.UsedCarsInfo>();
Filter objFilter = new Filter();
string carMakeid = string.Empty;
string CarModalId = string.Empty;
string ZipCode = string.Empty;
string WithinZip = string.Empty;
//Session["Orderby"] = Orderby;
carMakeid = Session["carMake"].ToString();
CarModalId = Session["CarModalId"].ToString();
ZipCode = Session["ZipCode"].ToString();
WithinZip = Session["WithinZip"].ToString();
List<CarsInfo.UsedCarsInfo> objUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)Session["SearchFullCarsdata"];
///objUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchMultiUsedCars(carMakeid, CarModalId, ZipCode, WithinZip, "1", "25", "Price");
CarsInfo.UsedCarsInfo OBJ = new CarsInfo.UsedCarsInfo();
List<CarsInfo.UsedCarsInfo> objFilterdata = new List<CarsInfo.UsedCarsInfo>();
for (int i = 0; i < AFilter.Count; i++)
{
//objMileage = objFilter.FilterData(obj, arr[i].ToString());
switch (AFilter[i].ToString())
{
case "Mileage1":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) < Convert.ToDecimal(5000));
obAddedItems = objMileage;
break;
case "Mileage2":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 5000 && Convert.ToDecimal(x.Mileage) < 10000);
obAddedItems.AddRange(objMileage);
//obAddedItems.AddRange(objMileage[0]);
break;
case "Mileage3":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 10000 && Convert.ToDecimal(x.Mileage) < 25000);
obAddedItems.AddRange(objMileage);
break;
case "Mileage4":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 25000 && Convert.ToDecimal(x.Mileage) < 50000);
obAddedItems.AddRange(objMileage);
break;
case "Mileage5":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 50000 && Convert.ToDecimal(x.Mileage) < 75000);
obAddedItems.AddRange(objMileage);
break;
case "Mileage6":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 75000 && Convert.ToDecimal(x.Mileage) < 100000);
obAddedItems.AddRange(objMileage);
break;
case "Mileage7":
objMileage = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Mileage) >= 100000);
obAddedItems.AddRange(objMileage);
break;//--30
case "Year1a":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2011);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2013);
objYear.AddRange(objFilterdata);
}
break;
case "Year1b":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2011);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2012);
objYear.AddRange(objFilterdata);
}
//objYear = objUsedCarsInfoFiltered;
break;
case "Year1":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2011);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2011);
objYear.AddRange(objFilterdata);
}
//objYear = objUsedCarsInfoFiltered;
break;
case "Year2":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2010);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2010);
objYear.AddRange(objFilterdata);
}
//obAddedItems = Additem(objYear);
break;
case "Year3":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2009);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2009);
objYear.AddRange(objFilterdata);
}
break;
case "Year4":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2008);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2008);
objYear.AddRange(objFilterdata);
}
break;
case "Year5":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2007);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) == 2007);
objYear.AddRange(objFilterdata);
}
break;
case "Year6":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) >= 2002 && Convert.ToInt32(x.YearOfMake) <= 2006);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) >= 2002 && Convert.ToInt32(x.YearOfMake) <= 2006);
objYear.AddRange(objFilterdata);
}
break;
case "Year7":
//if (obAddedItems.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToInt32(x.YearOfMake) < 2002);
// objYear.AddRange(objFilterdata);
//}
//else
{
objFilterdata = obAddedItems.FindAll(x => Convert.ToInt32(x.YearOfMake) < 2002);
objYear.AddRange(objFilterdata);
}
break;
case "Price1":
//if (objYear.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Price) < 20000);
// objPrice.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objYear.FindAll(x => Convert.ToDecimal(x.Price) < 20000);
objPrice.AddRange(objFilterdata);
}
break;
case "Price2":
//if (objYear.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Price) >= 20000 && Convert.ToDecimal(x.Price) < 50000);
// objPrice.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objYear.FindAll(x => Convert.ToDecimal(x.Price) >= 20000 && Convert.ToDecimal(x.Price) < 50000);
objPrice.AddRange(objFilterdata);
}
break;
case "Price3":
//if (objYear.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Price) >= 50000 && Convert.ToDecimal(x.Price) < 75000);
// objPrice.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objYear.FindAll(x => Convert.ToDecimal(x.Price) >= 50000 && Convert.ToDecimal(x.Price) < 75000);
objPrice.AddRange(objFilterdata);
}
break;
case "Price4":
if (objYear.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Price) >= 75000 && Convert.ToDecimal(x.Price) < 100000);
// objPrice.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objYear.FindAll(x => Convert.ToDecimal(x.Price) >= 75000 && Convert.ToDecimal(x.Price) < 100000);
objPrice.AddRange(objFilterdata);
}
break;
case "Price5":
//if (objYear.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => Convert.ToDecimal(x.Price) >= 100000);
// objPrice = objFilterdata;
//}
//else
{
objFilterdata = objYear.FindAll(x => Convert.ToDecimal(x.Price) >= 100000);
objPrice.AddRange(objFilterdata);
}
break;
case "Body1":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Convertible");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Convertible");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body2":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Coupe");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Coupe");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body3":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Hatchback");
// objBodytype.AddRange(objFilterdata);
//}
// else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Hatchback");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body4":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Sedan");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Sedan");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body5":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "SUV");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "SUV");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body6":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Truck");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Truck");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body7":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Van");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Van");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body8":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Wagon");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Wagon");
objBodytype.AddRange(objFilterdata);
}
break;
case "Body9":
//if (objPrice.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Bodytype.Trim()) == "Other");
// objBodytype.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objPrice.FindAll(x => (x.Bodytype.Trim()) == "Other");
objBodytype.AddRange(objFilterdata);
}
break;
case "Fuel1":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Fueltype.Trim()) == "Diesel");
// objFuelType.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Diesel");
objFuelType.AddRange(objFilterdata);
}
break;
case "Fuel2":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Fueltype.Trim()) == "Petrol");
// objFuelType.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Petrol");
objFuelType.AddRange(objFilterdata);
}
//objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Petrol");
break;
case "Fuel3":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Fueltype.Trim()) == "Hybrid");
// objFuelType.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Hybrid");
objFuelType.AddRange(objFilterdata);
}
break;
case "Fuel4":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Fueltype.Trim()) == "Electric");
// objFuelType.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Electric");
objFuelType.AddRange(objFilterdata);
}
//objFuelType.AddRange(objFilterdata);
break;
case "Fuel5":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.Fueltype.Trim()) == "Other");
// objFuelType.AddRange(objFilterdata);
//}
//else
{
objFilterdata = objBodytype.FindAll(x => (x.Fueltype.Trim()) == "Other");
objFuelType.AddRange(objFilterdata);
}
break;
case "Seller1":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.SellerType.Trim()) == "Invidual");
// objSellerType .AddRange( objFilterdata);
//}
//else
{
objFilterdata = objFuelType.FindAll(x => (x.SellerType.Trim()) == "Private Seller");
objSellerType.AddRange(objFilterdata);
}
break;
case "Seller2":
//if (objBodytype.Count == 0)
//{
// objFilterdata = objUsedCarsInfo.FindAll(x => (x.SellerType.Trim()) == "Dealers");
// objSellerType .AddRange( objFilterdata);
//}
//else
{
objFilterdata = objFuelType.FindAll(x => (x.SellerType.Trim()) == "Dealers");
objSellerType.AddRange(objFilterdata);
}
//objFilterdata = objFuelType.FindAll(x => (x.SellerType.Trim()) == "");
break;
};
//objMileage
}
Session["SearchCarsdata"] = objSellerType;
//if (Session["SortType"] != null)
//{
// objSellerType = SortData(Session["SortType"].ToString(), PageResultsCount);
//}
//objSellerType = pagingdata(PageResultsCount, 1, objSellerType);
return objSellerType;
//
}
public List<CarsInfo.UsedCarsInfo> MinandMax(string carMakeid, string CarModalId, string ZipCode, string WithinZip)
{
var obj = new List<CarsInfo.UsedCarsInfo>();
try
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.MinandMaxValues(carMakeid, CarModalId, ZipCode, WithinZip);
Session["SearchFullCarsdata"] = obj;
Session["SearchCarsdata"] = obj;
}
catch (Exception EX)
{
}
return obj;
}
public List<CarsInfo.UsedCarsInfo> SortData(string sFilterType, int PageSize)
{
List<CarsInfo.UsedCarsInfo> obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)Session["SearchFullCarsdata"];
string CurrentPage = "1";
string pageresultscount = PageSize.ToString();
string Orderby = Session["Orderby"].ToString();
string carMakeid = Session["carMake"].ToString();
string CarModalId = Session["CarModalId"].ToString();
string ZipCode = Session["ZipCode"].ToString();
string WithinZip = Session["WithinZip"].ToString();
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
switch (sFilterType)
{
case "1":
Session["Orderby"] = "Price";
Session["sort"] = "asc";
//<option value="1">Price low to high</option>
//obUsedCarsInfo.OrderBy(p => p.Price).ToList();// ("Name desc");
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "Price asc");
//obUsedCarsInfo = obUsedCarsInfo.OrderBy(p => p.Price).ToList();// ("Name desc");
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "Price", "asc");
//rderBy(person => person.LastName);
break;
case "2":
Session["Orderby"] = "Price";
Session["sort"] = "desc";
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "Price", "desc");
//obUsedCarsInfo = obUsedCarsInfo.OrderBy(p => p.Price).Reverse().ToList();
//<option value="2">Price high to low</option>
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "Price desc");
break;
case "3":
Session["Orderby"] = "YearOfMake";
Session["sort"] = "asc";
//<option value="3">Year old to new</option>
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "YearOfMake", "asc");
//obUsedCarsInfo = obUsedCarsInfo.OrderBy(p => p.YearOfMake).ToList();
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "YearOfMake desc");
break;
case "4":
Session["Orderby"] = "YearOfMake";
Session["sort"] = "desc";
//<option value="4">Year new to old</option>
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "YearOfMake", "desc");
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "YearOfMake asc");
break;
case "5":
Session["Orderby"] = "Mileage";
Session["sort"] = "asc";
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "Mileage", "asc");
//obUsedCarsInfo = obUsedCarsInfo.OrderBy(p => p.Mileage).ToList();
//<option value="5">Mileage low to high</option>
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "Mileage desc");
break;
case "6":
Session["Orderby"] = "Mileage";
Session["sort"] = "desc";
obUsedCarsInfo = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSort(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, "Mileage", "desc");
//<option value="6">Mileage high to low</option>
//Extensions.Extensions.OrderBy(obUsedCarsInfo, "Mileage asc");
break;
}
Session["SearchCarsdata"] = obUsedCarsInfo;
Session["SortType"] = sFilterType;
//obUsedCarsInfo = pagingdata(PageSize, 1, obUsedCarsInfo);
return obUsedCarsInfo;
}
public List<CarsInfo.UsedCarsInfo> GetRecentListings()
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
var obj = new List<CarsInfo.UsedCarsInfo>();
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.GetRecentListings();
return obj;
}
public List<CarsInfo.UsedCarsInfo> GetPageDataSpeed(int PageSize, int page)
{
var obj = new List<CarsInfo.UsedCarsInfo>();
if (Session["FilterOn"] != null)
{
if (Convert.ToInt32(Session["FilterOn"].ToString()) == 1)
{
ArrayList AFilter = (ArrayList)Session["Filter"];
obj = GetCarsFilterNextSpeed(AFilter, PageSize.ToString(), page);
}
}
else
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
string CurrentPage = page.ToString();
string pageresultscount = PageSize.ToString();
string Orderby = string.Empty;
string sort = string.Empty;
if (Session["Orderby"] != null && Session["Orderby"] != "")
{
Orderby = Session["Orderby"].ToString();
}
else
{
Session["Orderby"] = "price";
}
if (Session["sort"] != null)
{
sort = Session["sort"].ToString();
}
else
{
sort = "desc";
}
string carMakeid = Session["carMake"].ToString();
string CarModalId = Session["CarModalId"].ToString();
string ZipCode = Session["ZipCode"].ToString();
string WithinZip = Session["WithinZip"].ToString();
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSpeed(carMakeid, CarModalId, ZipCode, WithinZip, CurrentPage, pageresultscount, Orderby, sort);
Session["SearchCarsdata"] = obj;
}
return obj;
}
public List<CarsInfo.UsedCarsInfo> GetCarsSearchSpeed(string carMakeid, string CarModalId, string ZipCode, string WithinZip, string pageNo, string pageresultscount, string orderby)
{
var obj = new List<CarsInfo.UsedCarsInfo>();
try
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
Session["carMake"] = carMakeid;
Session["CarModalId"] = CarModalId;
Session["ZipCode"] = ZipCode;
Session["WithinZip"] = WithinZip;
string sort = string.Empty;
if (Session["Orderby"] != null && Session["Orderby"] != "")
{
orderby = Session["Orderby"].ToString();
}
else
{
Session["Orderby"] = "price";
}
if (Session["sort"] != null)
{
sort = Session["sort"].ToString();
}
else
{
sort = "desc";
}
string IPAddress = string.Empty;
string SearchName = string.Empty;
String strHostName = HttpContext.Current.Request.UserHostAddress.ToString();
IPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
GeneralFunc.SaveSearchLog(IPAddress, carMakeid, CarModalId, WithinZip, ZipCode, "Genral");
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchUsedCarsSpeed(carMakeid, CarModalId, ZipCode, WithinZip, pageNo, pageresultscount, orderby, sort);
Session["SearchFullCarsdata"] = obj;
Session["SearchCarsdata"] = obj;
}
catch (Exception EX)
{
}
return obj;
}
public List<CarsInfo.UsedCarsInfo> GetCarsMultiSearch(ArrayList SearchArray)
{
string Orderby = string.Empty;
if (Session["Orderby"] != null)
{
Orderby = Session["Orderby"].ToString();
}
else
{
Orderby = "Price";
}
var obj = new List<CarsInfo.UsedCarsInfo>();
List<CarsInfo.UsedCarsInfo> obj2 = new List<CarsInfo.UsedCarsInfo>();
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
string[] SerachType;
string carMakeid = string.Empty;
string CarModalId = string.Empty;
string ZipCode = string.Empty;
string WithinZip = string.Empty;
for (int i = 0; i < SearchArray.Count; i++)
{
SerachType = SearchArray[i].ToString().Split(',');
if (i == 0)
{
carMakeid = SerachType[0];
CarModalId = SerachType[1];
ZipCode = SerachType[2];
WithinZip = SerachType[3];
}
else
{
//sLocationsRebill + ",'" + Items.Value + "'";
carMakeid = carMakeid + "," + SerachType[0] + "";
CarModalId = CarModalId + "," + SerachType[1] + "";
}
}
Session["Orderby"] = Orderby;
Session["carMake"] = carMakeid;
Session["CarModalId"] = CarModalId;
Session["ZipCode"] = ZipCode;
Session["WithinZip"] = WithinZip;
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchMultiUsedCars(carMakeid, CarModalId, ZipCode, WithinZip, "1", "25", Orderby);
Session["SearchFullCarsdata"] = obj;
//Session["SearchCarsdata"] = obj2;
Session["SearchCarsdata"] = obj;
if (Session["FilterArray"] != null)
{
ArrayList FilterArray = (ArrayList)Session["FilterArray"];
if (Session["PageSize"] != null)
{
obj2 = GetCarsFilterMulti(FilterArray, 25);
}
else
{
obj2 = GetCarsFilterMulti(FilterArray, Convert.ToInt32(Session["PageSize"]));
}
}
obj2 = GetPageMultiData(25, 1);
//carMakeid, CarModalId, ZipCode, WithinZip
//for (int k = 0; k < obj2.Count; k++)
//{
//obj2[k].pa
//}
return obj2;
}
public List<CarsInfo.UsedCarsInfo> GetCarsMatchedData(string carMakeid, string CarModalId, string ZipCode, string Price)
{
var obj = new List<CarsInfo.UsedCarsInfo>();
try
{
CarsBL.UsedCarsSearch objCarsearch = new CarsBL.UsedCarsSearch();
//Session["carMake"] = carMakeid;
//Session["CarModalId"] = CarModalId;
//Session["ZipCode"] = ZipCode;
//Session["Price"] = Price;
obj = (List<CarsInfo.UsedCarsInfo>)objCarsearch.SearchMatchedCars(carMakeid, CarModalId, ZipCode, Price);
Session["SearchFullCarsdata"] = obj;
Session["SearchCarsdata"] = obj;
}
catch (Exception EX)
{
}
return obj;
}
