//
// 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();
}
