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