//,convert(nvarchar(max),decryptByPassPhrase('root@',Phone)) as P,convert(nvarchar(max),decryptByPassPhrase('root@',Email)) as E
#region GetLover
public List <ElementDataList> GetLover(double sLatitude, double sLongitude, string Gender, int Age)
{
var dataList = new List <ElementDataList>();
ElementDataList mg;
try
{
DataTable dt = db.getAllByQuery("select * from Lover where Gender='" + Gender + "' and Age=" + Age);
#region Looping Lover
foreach (DataRow rows in dt.Rows)
{
//if (GetDistance(sLatitude, sLongitude, Convert.ToDouble(rows["Lat"]), Convert.ToDouble(rows["Lng"])) < 3)
//{
mg = new ElementDataList
{
Element1 = rows["ID"].ToString(),
Element2 = rows["Lat"].ToString(),
Element3 = rows["Lng"].ToString()
};
dataList.Add(mg);
//}
}
#endregion
return(dataList);
}
catch
{
return(dataList);
}
}
public List <ElementDataList> GetTownByStateRegionID(int StateRegionID)
{
var dataList = new List <ElementDataList>();
ElementDataList mg;
DataTable dt = db.getAllByQuery("select * from Town where StateRegionID=" + StateRegionID);
foreach (DataRow rows in dt.Rows)
{
mg = new ElementDataList
{
Element1 = rows["ID"].ToString(),
Element2 = rows["MName"].ToString(),
Element3 = rows["EName"].ToString()
};
dataList.Add(mg);
}
return(dataList);
}