void ListPopupPopulate(int? id, FormCollection collection)
{
int pageSize = 5;
int pageCalled = 0;
if (id == null)
pageCalled = 1;
else
pageCalled = (int)id;
DataSet.DSParameter ds = (DataSet.DSParameter)System.Web.HttpContext.Current.Cache["data"];
string filter = " state = '" + collection["state"].ToString() + "'";
DataRow[] rows = ds.Distributor.Select(filter, " distributor asc");
int totalItems = rows.Length;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/SearchDealer/ListPopup/");
pagination.TrailingQueryString = "state="+collection["state"].ToString();
pagination.Is_UserClickFunction = true;
pagination.ClickFunctionName = "GetDealerPage";
Session["QSCurDL"] = "state=" + collection["state"].ToString();
pagination.TotalRows = totalItems;
pagination.CurPage = pageCalled;
pagination.PerPage = pageSize;
pagination.PrevLink = "Prev";
pagination.NextLink = "Next";
pagination.UpdateTargetId = "divLoading";
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 = rows.Cast<DataRow>().AsQueryable();
ViewData[UIDealerSearch.listDealer.ToString()] = dt.Skip(start).Take(offset).ToList();// dt.Skip((pageCalled) * pageSize).Take(pageSize).ToList();
}
private ViewDataDictionary LoadList(int? id, FormCollection collection)
{
int _totalCount = 0;
DataSet.DSParameter ds = (DataSet.DSParameter)System.Web.HttpContext.Current.Cache["data"];
//_totalCount = ds.Tables[BusinessLogic.Base.Tables.ItemLineDetail.ToString()].Rows.Count;
int pageSize = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PageSize"].ToString());
string filter = " 1=1 ";
string searchCritaria = "";
if (collection != null)
{
if (collection[UIStore.srhCode.ToString()].Trim().Length != 0)
{
filter += " and Code like '*" + collection[UIStore.srhCode.ToString()].ToString().ToString().Replace("'", "") + "*' ";
}
if (collection[UIStore.srhStore.ToString()].Trim().Length != 0)
{
filter += " and Distributor like '" + collection[UIStore.srhStore.ToString()].ToString().Replace("'", "") + "*'";
}
if (collection[UIStore.srhAddress.ToString()].Trim().Length != 0)
{
filter += " and Address like '" + collection[UIStore.srhAddress.ToString()].ToString().Replace("'", "") + "*'";
}
if (collection[UIStore.srhCity.ToString()].Trim().Length != 0)
{
filter += " and City like '" + collection[UIStore.srhCity.ToString()].ToString() + "*'";
}
if (collection[UIStore.srhState.ToString()].Trim().Length != 0)
{
filter += " and State like '" + collection[UIStore.srhState.ToString()].ToString() + "*'";
}
if (collection[UIStore.srhEmail.ToString()].Trim().Length != 0)
{
filter += " and Email like '" + collection[UIStore.srhEmail.ToString()].ToString() + "*'";
}
if (collection[UIStore.srhPhone1.ToString()].Trim().Length != 0)
{
filter += " and Phone like '" + collection[UIStore.srhState.ToString()].ToString() + "*'";
}
if (collection[UIStore.srhStatus.ToString()] == null)
{
filter += " and is_Active = false ";
searchCritaria += " Status : In-Active" + " ,";
}
else
{
filter += " and is_Active = true ";
searchCritaria += " Code : Active" + " ,";
}
if (collection[UIAll.gridSize.ToString()].Trim().Length != 0)
{
pageSize = Convert.ToInt32(collection[UIAll.gridSize.ToString()]);
}
}
DataRow[] rows = ds.Distributor.Select(filter," Code ");
_totalCount = rows.Length;
int pageCalled = 0;
if (id == null)
pageCalled = 1;
else
pageCalled = (int)id;
try
{
//----------------------------------------------
//Fill Custom Data
string temp = "";
int totalItems = _totalCount;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/Store/GetList/");
pagination.TrailingQueryString = "";
pagination.TrailingQueryString = "";
pagination.Is_UserClickFunction = true;
pagination.ClickFunctionName = "javascript:GetList";
Session["QSCurDL"] = "";
ViewData["queryString"] = "";
ViewData["product_IDs"] = "";
pagination.TotalRows = totalItems;
pagination.CurPage = pageCalled;
pagination.PerPage = pageSize;
pagination.PrevLink = "Prev";
pagination.NextLink = "Next";
pagination.UpdateTargetId = "dealerList";
pagination._class = " class='navButton'";
string pageLinks = pagination.GetPageLinks();
int start = (pageCalled - 1) * pagination.PerPage;
int offset = pagination.PerPage;
ViewData["pageLinks"] = pageLinks;
ViewData["Count"] = totalItems;
ViewData["start"] = (start + 1).ToString();
IQueryable<DataRow> dt = rows.Cast<DataRow>().AsQueryable();
ViewData[UIStore.listStore.ToString()] = dt.Skip(start).Take(offset).ToList();
}
catch (Exception e)
{
}
return ViewData;
}
private void LoadProductTypeList(FormCollection collection, int pageSize, int pageCalled)
{
//int _start;
//int _count;
int _totalCount = 0;
string _product_Type;
_product_Type = collection[UIProductType.txtSerProductType.ToString()];
if (_product_Type != null)
_product_Type = _product_Type.Trim().Length == 0 ? null : _product_Type;
BusinessLogic.Product_Type.Product_Type con = new BusinessLogic.Product_Type.Product_Type();
System.Data.DataSet ds = con.GetPage(((pageCalled - 1) * pageSize + 1), pageSize, ref _totalCount, _product_Type);
try
{
//----------------------------------------------
//Fill Custom Data
//string temp = "";
int totalItems = _totalCount;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/ProductType/List/");
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;
IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable();
ViewData[UIProductType.listProductType.ToString()] = dt.ToList();
ViewData[UIProductType.hidCurrentPage.ToString()] = pageCalled;
}
catch
{
}
}
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();
}
private ViewDataDictionary LoadList(int? id, FormCollection collection)
{
int _totalCount = 0;
DataSet.DSParameter ds = (DataSet.DSParameter)System.Web.HttpContext.Current.Cache["data"];
//_totalCount = ds.Tables[BusinessLogic.Base.Tables.ItemLineDetail.ToString()].Rows.Count;
int pageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"].ToString());
string filter = " 1=1 ";
string searchCritaria = " ";
StringBuilder orderBy = new StringBuilder();
int orderByCount = 0;
if (collection != null)
{
if (collection[UIProductType.srhProductType.ToString()].Split(',')[1].Trim().Length != 0)
{
filter += " and Product_Type like '" + collection[UIProductType.srhProductType.ToString()].Split(',')[1].ToString() + "*'";
searchCritaria += " Category : " + collection[UIProductType.srhProductType.ToString()].Split(',')[1].ToString() + "* ,";
}
if (collection[UIProductType.srhStatus.ToString()] != null)
{
if (collection[UIProductType.srhStatus.ToString()].Split(',').Length > 1)
{
if (collection[UIProductType.srhStatus.ToString()].Split(',')[1].ToString() == null)
{
filter += " and is_Active = false ";
searchCritaria += " Status : In-Active" + " ,";
}
else
{
filter += " and is_Active = true ";
searchCritaria += " Status : Active" + " ,";
}
}
else
{
filter += " and is_Active = false ";
searchCritaria += " Status : In-Active" + " ,";
}
}
else
{
filter += " and is_Active = false ";
searchCritaria += " Status : In-Active" + " ,";
}
if (collection[UIProductType.ordProductType.ToString()].Split(',')[1].ToString() != "0")
{
orderBy.Append(", Product_Type ").Append(collection[UIProductType.ordProductType.ToString()].Split(',')[1].ToString() == "1" ? " ASC " : " DESC ");
orderByCount++;
}
if (collection[UIAll.gridSize.ToString()].Split(',')[1].Trim().Length != 0)
{
pageSize = Convert.ToInt32(collection[UIAll.gridSize.ToString()].Split(',')[1].Trim());
}
searchCritaria = searchCritaria.Remove(searchCritaria.Length - 1);
}
else
{
searchCritaria += " Status : In-Active" + " ,";
searchCritaria += " Type : All ,";
}
if (orderByCount > 0)
orderBy = orderBy.Remove(0, 1);
ViewData["searchCritaria"] = searchCritaria.Remove(searchCritaria.Length - 1);
DataRow[] rows = ds.Product_Type.Select(filter, orderBy.ToString());
_totalCount = rows.Length;
int pageCalled = 0;
if (id == null)
pageCalled = 1;
else
pageCalled = (int)id;
try
{
//----------------------------------------------
//Fill Custom Data
//string temp = "";
int totalItems = _totalCount;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/Category/GetList/");
pagination.TrailingQueryString = "";
pagination.TrailingQueryString = "";
pagination.Is_UserClickFunction = true;
pagination.ClickFunctionName = "javascript:GetList";
Session["QSCurDL"] = "";
ViewData["queryString"] = "";
ViewData["product_IDs"] = "";
pagination.TotalRows = totalItems;
pagination.CurPage = pageCalled;
pagination.PerPage = pageSize;
pagination.PrevLink = "Prev";
pagination.NextLink = "Next";
pagination.UpdateTargetId = "dealerList";
pagination._class = " class='navButton'";
string pageLinks = pagination.GetPageLinks();
int start = (pageCalled - 1) * pagination.PerPage;
int offset = pagination.PerPage;
ViewData["pageLinks"] = pageLinks;
ViewData["Count"] = totalItems;
ViewData["start"] = (start + 1).ToString();
IQueryable<DataRow> dt = rows.Cast<DataRow>().AsQueryable();
ViewData[UIProductType.listProductType.ToString()] = dt.Skip(start).Take(offset).ToList();
searchCritaria = (start + 1).ToString() + " - " + (start + dt.Skip(start).Take(offset).ToList().Count).ToString() + " from " + totalItems.ToString() + " : " + searchCritaria;
ViewData["SearchCritaria"] = searchCritaria;
}
catch
{
}
return ViewData;
}
void ListPopulate(int? id, FormCollection collection)
{
int distance = 0;
string postalCode = "";
string filter = "";
if (collection[UIProductSearch.search.ToString()] != null)
{
string text = collection[UIProductSearch.search.ToString()].ToString();
if (Convert.ToInt32(collection["cat"]) == 0)
{
filter = "( product like '*" + text + "*' or Description like '*" + text + "*' )";
}
else
{
filter = " Product_Type_ID = " + collection["cat"].ToString() + " and ( product like '*" + text + "*' or Description like '*" + text + "*' )";
}
ViewData[UIProductSearch.is_Category_Search.ToString()] = true;
ViewData[UIProductSearch.search.ToString()] = text;
base.Activity((int)Activities.viewList, "category = " + collection["cat"].ToString() + " text= " + text, 0);
}
else
{
ViewData[UIProductSearch.is_Category_Search.ToString()] = false;
ViewData[UIProductSearch.search.ToString()] = "";
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(","));
}
filter = " product_ID in ( " + product_IDs + " ) ";
base.Activity((int)Activities.viewList, "postalCode=" + postalCode + " distance= " + distance.ToString() + " miles" + " product_IDs = " + product_IDs, Convert.ToInt32(id));
}
DataSet.DSParameter ds = (DataSet.DSParameter)System.Web.HttpContext.Current.Cache["data"];
//DataRow[] rows = ds.Product_Type.Select();
//BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search();
//System.Data.DataSet ds = ser.GetProductList(postalCode, distance,, "", "", "");
int pageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"].ToString());
int pageCalled = 0;
if (id == null)
pageCalled = 1;
else
pageCalled = (int)id;
//BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search();
//obj._ID = 1;
//System.Data.DataSet ds = obj.GetSearchCritariaBy(1);
DataRow[] rows = ds.Product.Select( filter );
int totalItems = rows.Length;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/SearchProduct/List/");
pagination.TrailingQueryString = "?" + GetRawUrl();
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;
IQueryable<DataRow> dt = rows.Cast<DataRow>().AsQueryable();
ViewData[ UIProductSearch.listProduct.ToString()] = dt.Skip(start).Take(offset).ToList();// dt.Skip((pageCalled) * pageSize).Take(pageSize).ToList();
}
void ListPopulate(int? id)
{
ViewData[UIProductSearch.is_Category_Search.ToString()] = false;
ViewData[UIProductSearch.search.ToString()] = "";
DataSet.DSParameter ds = (DataSet.DSParameter)System.Web.HttpContext.Current.Cache["data"];
//DataRow[] rows = ds.Product_Type.Select();
//BusinessLogic.Search.Search ser = new BusinessLogic.Search.Search();
//System.Data.DataSet ds = ser.GetProductList(postalCode, distance,, "", "", "");
int pageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"].ToString());
int pageCalled = 0;
if (id == null)
pageCalled = 1;
else
pageCalled = (int)id;
//BusinessLogic.Search.Search obj = new BusinessLogic.Search.Search();
//obj._ID = 1;
//System.Data.DataSet ds = obj.GetSearchCritariaBy(1);
DataRow[] rows = ds.Product.Select(" "," product_Type_ID asc ");
int totalItems = rows.Length;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/SearchProduct/List/");
pagination.TrailingQueryString = "";
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;
IQueryable<DataRow> dt = rows.Cast<DataRow>().AsQueryable();
ViewData[UIProductSearch.listProduct.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;
}
private void LoadVisitList(FormCollection collection, int pageSize, int pageCalled)
{
int _start;
int _count;
int _totalCount = 0;
string _UCI;
int? _company;
string _first_Name;
string _middle_Name;
string _last_Name;
string _phone_1;
string _phone_2;
string _from_Date;
string _to_Date;
_UCI = collection["txtUCI"];
if (collection["cobCompany"] == null)
{
_company = null;
}
else
{
_company = null;// Convert.ToInt32(collection["cobCompany"].ToString());
}
_first_Name = collection["txtFirst_Name"];
_middle_Name = collection["txtMiddle_Name"];
_last_Name = collection["txtLast_Name"];
_phone_1 = collection["txtPhone_1"];
_phone_2 = collection["txtPhone_2"];
_from_Date = collection["txtFrom_Date"];
_to_Date = collection["txtTo_Date"];
if (_UCI != null)
{
_UCI = _UCI.Trim().Length == 0 ? null : _UCI;
}
if (_first_Name != null)
_first_Name = _first_Name.Trim().Length == 0 ? null : _first_Name;
if (_middle_Name != null)
_middle_Name = _middle_Name.Trim().Length == 0 ? null : _middle_Name;
if (_last_Name != null)
_last_Name = _last_Name.Trim().Length == 0 ? null : _last_Name;
if (_phone_1 != null)
_phone_1 = _phone_1.Trim().Length == 0 ? null : _phone_1;
if (_phone_2 != null)
_phone_2 = _phone_2.Trim().Length == 0 ? null : _phone_2;
if (_from_Date != null)
_from_Date = _from_Date.Trim().Length == 0 ? null : _from_Date;
if (_to_Date != null)
_to_Date = _to_Date.Trim().Length == 0 ? null : _to_Date;
GlobalVariables.Visit.IVisit iv= this;
iv.count = pageSize;
iv.totalCount= _totalCount;
iv.start= pageCalled;
iv.City = collection["txtTo_Date"];;
iv.Country= collection["txtTo_Date"];
iv.start_Date= collection["txtTo_Date"];
iv.end_Date= collection["txtTo_Date"];
iv.State= collection["txtTo_Date"];
BusinessLogic.Tracking.Visit con = new BusinessLogic.Tracking.Visit(iv);
System.Data.DataSet ds = con.GetPage(ref _totalCount);
try
{
//----------------------------------------------
//Fill Custom Data
string temp = "";
int totalItems = _totalCount;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/Consumer/List/");
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["start"] = (start + 1).ToString();
IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable();
ViewData["ConsumerList"] = dt.ToList();
}
catch (Exception e)
{
}
}
