// // GET: /Search/ public ActionResult Index(int? id) { ViewData["ZipCode"] = id.ToString(); base.Activity((int)Activities.clickSearch, "Zipcode=" + ViewData["ZipCode"].ToString(), 0); BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search(); obj._ID = 1; System.Data.DataSet ds = obj.GetSearchCritariaBy(1); DataRow[] rows = ds.Tables["List"].Select(""); //getLocation(Request.ServerVariables["REMOTE_ADDR"].Trim()); IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable(); ViewData[UIProductType.listProductType.ToString()] = dt.ToList(); //MailMessage message = new MailMessage(); //message.From = new MailAddress("*****@*****.**"); //message.To.Add(new MailAddress("*****@*****.**")); ////message.CC.Add(new MailAddress("*****@*****.**")); //message.Subject = "This is my subject"; //message.Body = "This is the content"; //SmtpClient client = new SmtpClient() //{ // Credentials = new NetworkCredential("*****@*****.**", "has537167"), // EnableSsl = true //}; //client.Host = "smtp.gmail.com"; //client.Port = 587; //client.Send(message); return SetViewPage("Index"); }
// // GET: /Event/ public ActionResult Index(int? id) { ViewData["ZipCode"] = id.ToString(); base.Activity((int)Activities.clickSearch, "Zipcode=" + ViewData["ZipCode"].ToString(), 0); BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search(); return View(); }
// // GET: /Search/ public ActionResult Index(int? id) { ViewData["ZipCode"] = id.ToString(); base.Activity((int)Activities.clickSearch, "Zipcode=" + ViewData["ZipCode"].ToString(), 0); BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search(); obj._ID = 1; System.Data.DataSet ds = obj.GetSearchCritariaBy(1); DataRow[] rows = ds.Tables["List"].Select(""); //getLocation(Request.ServerVariables["REMOTE_ADDR"].Trim()); IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable(); ViewData[UIProductType.listProductType.ToString()] = dt.ToList(); return SetViewPage("Index"); }
public ActionResult Home(string txtZipcode) { base.Activity( ( int ) Activities.clickSearch, "Zipcode=" + txtZipcode, 0); if (base.IsNumeric(txtZipcode)) { txtZipcode = String.Format("{0:d5}", Convert.ToInt32(txtZipcode)); } else { ViewData["txtErrorMessage"] = "Enter valid US zipcode"; return View("Index"); } BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); if (!ser.ValidateZipcode(txtZipcode)) { ViewData["txtErrorMessage"] = "Enter valid US zipcode"; return View("Index"); } return RedirectToAction("Index", "Search", new { id = txtZipcode }); }
void ListPopulate(int? id, FormCollection collection) { int distance = 0; string postalCode = collection[UISearch.txtzipcode.ToString()].ToString();// CultureInfo.InvariantCulture string.Format("{D5}", "210");// "210".ToString("D5"); if (base.IsNumeric(postalCode)) { postalCode = String.Format("{0:d5}", Convert.ToInt32(postalCode)); distance = Convert.ToInt32(collection[UISearch.cobDistance.ToString()].ToString()); } string product_IDs = ""; foreach (string col_id in collection) { if (col_id.Contains("pro-")) { product_IDs += col_id.Replace("pro-", "") + ","; } } if (product_IDs.Length > 0) { product_IDs += product_IDs.Remove(product_IDs.LastIndexOf(",")); } decimal startLatitude=0; decimal startLongitude=0; bool is_Valid_Postal_Code = true; BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); System.Data.DataSet ds = ser.GetProductDealerList(postalCode, distance, product_IDs, ref startLatitude, ref startLongitude,ref is_Valid_Postal_Code); int pageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"].ToString()); int pageCalled = 0; if (id == null) pageCalled = 1; else pageCalled = (int)id; base.Activity((int)Activities.viewList, "postalCode=" + postalCode + " distance= " + distance.ToString() + " miles" + " product_IDs = " + product_IDs, Convert.ToInt32(id)); //BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search(); //obj._ID = 1; //System.Data.DataSet ds = obj.GetSearchCritariaBy(1); DataRow[] rows = ds.Tables["List"].Select(""," distance asc"); int totalItems = rows.Length; Web.Model.Pagination pagination = new Web.Model.Pagination(true); pagination.BaseUrl = Url.Content("~/SearchDealer/List/"); pagination.TrailingQueryString = "?" + GetRawUrl() ; Session["QSCurDL"] = "?" + HttpUtility.UrlDecode( GetRawUrl() ); ViewData["product_IDs"] = product_IDs; pagination.TotalRows = totalItems; pagination.CurPage = pageCalled; pagination.PerPage = pageSize; pagination.PrevLink = "Prev"; pagination.NextLink = "Next"; pagination.UpdateTargetId = "mainSearchPanel"; string pageLinks = pagination.GetPageLinks(); int start = (pageCalled - 1) * pagination.PerPage; int offset = pagination.PerPage; ViewData["pageLinks"] = pageLinks; ViewData["Count"] = totalItems; ViewData["startLatitude"] = startLatitude.ToString(); ViewData["startLongitude"] = startLongitude.ToString(); IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable(); ViewData[ UIDealerSearch.listDealer.ToString()] = dt.Skip(start).Take(offset).ToList();// dt.Skip((pageCalled) * pageSize).Take(pageSize).ToList(); }
ViewDataDictionary ListPopulateSearch(int? id, FormCollection collection) { int distance = 0; string postalCode = collection[UISearch.txtzipcode.ToString()].ToString(); if (base.IsNumeric(postalCode)) { postalCode = String.Format("{0:d5}", Convert.ToInt32(postalCode)); distance = Convert.ToInt32(collection[UISearch.cobDistance.ToString()].ToString()); ViewData["Error"] = ""; } else { ViewData["Error"] = "Enter valid Zip code"; return ViewData; } string product_IDs = ""; foreach (string col_id in collection) { if (col_id.Contains("pro-")) { product_IDs += col_id.Replace("pro-", "") + ","; } } if (product_IDs.Length > 0) { product_IDs += product_IDs.Remove(product_IDs.LastIndexOf(",")); } decimal startLatitude = 0; decimal startLongitude = 0; bool is_Valid_Postal_Code = true; BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); System.Data.DataSet ds = ser.GetProductDealerList(postalCode, distance, product_IDs, ref startLatitude, ref startLongitude, ref is_Valid_Postal_Code); int pageSize = 5; int pageCalled = 0; if (id == null) pageCalled = 1; else pageCalled = (int)id; if (collection["cobRows"] != null) { pageSize = Convert.ToInt32(collection["cobRows"]); } base.Activity((int)Activities.viewList, "postalCode=" + postalCode + " distance= " + distance.ToString() + " miles" + " product_IDs = " + product_IDs, Convert.ToInt32(id)); // no product find and postal code not valid if ( !is_Valid_Postal_Code) { ViewData["Error"] = "Enter valid U.S Zip code"; return ViewData; } string error = "No stores were found in your search. Your product may be available at one of our national, regional, or online distributors below. All products are available from Jatai.net."; if( ds.Tables.Count == 0 ) { ViewData["Error"] = error; return ViewData; } if (ds.Tables["List"].Rows.Count == 0 ) { ViewData["Error"] = error; return ViewData; } DataRow[] rows = ds.Tables["List"].Select("", " distance asc"); int totalItems = rows.Length; Web.Model.Pagination pagination = new Web.Model.Pagination(true); pagination.BaseUrl = Url.Content("~/SearchDealer/ListSearch/"); pagination.TrailingQueryString = ConvertCollectionToQuerystring(collection); pagination.TrailingQueryString = ConvertCollectionToQuerystring(collection); pagination.Is_UserClickFunction = true; pagination.ClickFunctionName = "javascript:GetDealerListFromNavigator"; pagination._class = " class=gradbutton "; Session["QSCurDL"] = ConvertCollectionToQuerystring(collection); ViewData["queryString"] = ConvertCollectionToQuerystring(collection); ViewData["product_IDs"] = product_IDs; pagination.TotalRows = totalItems; pagination.CurPage = pageCalled; pagination.PerPage = pageSize; pagination.PrevLink = "Prev"; pagination.NextLink = "Next"; pagination.UpdateTargetId = "dealerList"; string pageLinks = pagination.GetPageLinks(); int start = (pageCalled - 1) * pagination.PerPage; int offset = pagination.PerPage; ViewData["pageLinks"] = pageLinks; ViewData["Count"] = totalItems; ViewData["PageSize"] = pageSize; ViewData["startLatitude"] = startLatitude.ToString(); ViewData["startLongitude"] = startLongitude.ToString(); ViewData["start"] = (start + 1).ToString(); IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable(); ViewData[UIDealerSearch.listDealer.ToString()] = dt.Skip(start).Take(offset).ToList();// dt.Skip((pageCalled) * pageSize).Take(pageSize).ToList(); return ViewData; }
public ActionResult DealerCount(FormCollection collection) { string postalCode = collection[UISearch.txtzipcode.ToString()].ToString();// CultureInfo.InvariantCulture string.Format("{D5}", "210");// "210".ToString("D5"); int distance = 0; if (base.IsNumeric(postalCode)) { postalCode = String.Format("{0:d5}", Convert.ToInt32(postalCode)); distance = Convert.ToInt32(collection[UISearch.cobDistance.ToString()].ToString()); } else { return Content(""); } BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); if (!ser.ValidateZipcode(postalCode)) { return Content(""); } string product_IDs = ""; int product_Count = 0; foreach (string id in collection) { if (id.Contains("pro-")) { product_IDs += id.Replace("pro-", "") + ","; product_Count++; } } if (product_IDs.Length > 0) { product_IDs = product_IDs.Remove(product_IDs.LastIndexOf(",")); } return Content( ser.GetProductDealerCount(postalCode, distance, product_IDs).ToString() ); }
public ViewDataDictionary DealerLocator(FormCollection collection) { string postalCode = collection[UISearch.txtzipcode.ToString()].ToString();// CultureInfo.InvariantCulture string.Format("{D5}", "210");// "210".ToString("D5"); int distance = 0; if( base.IsNumeric( postalCode ) ) { postalCode = String.Format("{0:d5}", Convert.ToInt32( postalCode ) ); distance = Convert.ToInt32(collection[UISearch.cobDistance.ToString()].ToString()); } else { return InvalidPostalCode(); } BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); if (!ser.ValidateZipcode(postalCode)) { return InvalidPostalCode(); } string product_IDs = ""; int product_Count = 0; foreach( string id in collection) { if( id.Contains("pro-") ) { product_IDs += id.Replace("pro-","") + ","; product_Count++; } } if (product_IDs.Length > 0) { product_IDs = product_IDs.Remove(product_IDs.LastIndexOf(",")); } base.Activity((int)Activities.viewList, "postalCode=" + postalCode + " distance= " + distance.ToString() + " miles" + " product_IDs = " + product_IDs, 0); ViewData["Total_Dealers"] = ser.GetProductDealerCount(postalCode, distance, product_IDs); ViewData["Total_Products"] = product_Count.ToString(); ViewData["product_IDs"] = product_IDs; //ViewData["Querystring"] = Request.Form.ToString(); ; ViewData["Querystring"] = "data=" + HttpUtility.UrlEncode( Request.Form.ToString() );//ViewData["Querystring"].ToString()); //ViewData["Querystring"] = Request.Form; return ViewData; }
public ActionResult ProductList(FormCollection collection) { int distance = 0; collection = new FormCollection(ConvertRawUrlToQuerystring()); string postalCode = collection[UISearch.txtzipcode.ToString()].ToString();// CultureInfo.InvariantCulture string.Format("{D5}", "210");// "210".ToString("D5"); if (base.IsNumeric(postalCode)) { postalCode = String.Format("{0:d5}", Convert.ToInt32(postalCode)); distance = Convert.ToInt32(collection[UISearch.cobDistance.ToString()].ToString()); } else { return Content(""); } base.Activity((int)Activities.viewList, "postalCode=" + postalCode + " distance= " + distance.ToString() + " miles", 0); BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search(); if (!ser.ValidateZipcode(postalCode)) { return Content(""); } System.Data.DataSet ds = ser.GetProductList(postalCode, distance, "", "", ""); ViewData["Querystring"] = Request.Form; ; ViewData["Querystring"] = Server.UrlEncode(ViewData["Querystring"].ToString()); IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable(); ViewData[UIProductType.listProductType.ToString()] = dt.ToList(); return View(); }