public List <EventTable> GetTodayUpdates(string currentlocation)
{
List <EventTable> results = new List <EventTable>();
String query = "select * from [Event],[Location] where (Event.ispresent=1 and Event.LocationID = (select Location.LocationID from [Location] where (Location.LocationName='" + currentlocation + "')))and Location.LocationID=Event.LocationID; ";
using (SqlConnection sql = new SqlConnection())
{
sql.ConnectionString = RTSMSdbConnectionString;
SqlCommand cmd = new SqlCommand(query, sql);
try
{
sql.Open();
}
catch (Exception ex)
{
DateTime tm = DateTime.Now;
results.Add(new EventTable(1, "123", true, false, tm, tm, "Killed !.Quadidabd,Karachi", "3 people killed in Quaidabad.", 67.2162619, 24.8601083));
var connectionFault = new ConnectionFault();
connectionFault.Operation = "UpdateAccount";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
DateTime tm = DateTime.Now;
while (reader.Read())
{
// bool status = reader.GetBoolean(8);
//string alert = reader.GetString(8);
results.Add(new EventTable(reader.GetInt32(0), reader.GetString(1), true, false, tm, tm, reader.GetString(4), reader.GetString(5), reader.GetDouble(18), reader.GetDouble(19)));
}
}
else
{
DateTime tm = DateTime.Now;
results.Add(new EventTable(1, " ", true, false, tm, tm, "No Result", "No Result", 0.0, 0.0));
}
}
catch (Exception ex)
{
DateTime tm = DateTime.Now;
results.Add(new EventTable(1, "123", true, false, tm, tm, "Killed !.Quadidabd,Karachi", "3 people killed in Quaidabad.", 67.2162619, 24.8601083));
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(results);
}
public bool ValidateUser(User usr)
{
string query;
bool val = false;
query = @"SELECT COUNT(*) FROM [User] AS u where u.UserName = '******' AND u.hashPassword = '******';";
string connectionString = RTSMSdbConnectionString;
using (SqlConnection cnn = new SqlConnection())
{
cnn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand(query, cnn);
try
{
cnn.Open();
}
catch (Exception ex)
{
var connectionFault = new ConnectionFault();
connectionFault.Operation = "ListCustomers";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
SqlDataReader readerS = cmd.ExecuteReader();
int check = 5;
while (readerS.Read())
{
check = Int32.Parse(readerS[0].ToString());
}
if (check == 0)
{
val = false;
}
else
{
val = true;
}
}
catch (Exception ex)
{
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(true);
// return val;
// return connectionString;
}
public bool CreateAccount(string firstname, string lastname, string username, string email, string password, string homelattitude, string homelongitude, string officelattitude, string officelongitude)
{
bool check;
string query;
query = @"insert into [User] values (" + 1 + "," + 1 + "," + 1 + ",'" + firstname + "','" + lastname + "','" + username + "','" + password + "','" + DateTime.Now.ToString() + "')";
string connectionString = RTSMSdbConnectionString;
using (SqlConnection cnn = new SqlConnection())
{
cnn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand(query, cnn);
try
{
cnn.Open();
}
catch (Exception ex)
{
var connectionFault = new ConnectionFault();
connectionFault.Operation = "ListCustomers";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
int i = cmd.ExecuteNonQuery();
if (i < 0)
{
check = false;
return(false);
}
else
{
check = true;
}
}
catch (Exception ex)
{
check = false;
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
return(false);
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(check);
}
public User GetUserProfile(string username)
{
string query;
User usr = new User();
query = @"select * from [User] AS u where u.UserName='******'";
string connectionString = RTSMSdbConnectionString;
using (SqlConnection cnn = new SqlConnection())
{
cnn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand(query, cnn);
try
{
cnn.Open();
}
catch (Exception ex)
{
var connectionFault = new ConnectionFault();
connectionFault.Operation = "ListCustomers";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
SqlDataReader readerS = cmd.ExecuteReader();
int check = 5;
while (readerS.Read())
{
usr.HomeLocation = readerS[1].ToString();
usr.OfficeLocation = readerS[2].ToString();
usr.FirstName = readerS[4].ToString();
usr.LastName = readerS[5].ToString();
usr.UserName = readerS[6].ToString();
usr.Password = readerS[7].ToString();
}
}
catch (Exception ex)
{
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(usr);
}
public string UpdateAccount(User usr)
{
string query;
query = @"update [User] set [HomeLocationID]=" + usr.HomeLocation + ", [OfficeLocationID]=" + usr.OfficeLocation + ", [FirstName]='" + usr.FirstName + "', [LastName]='" + usr.LastName + "' where [UserName]='" + usr.UserName + "';";
string connectionString = RTSMSdbConnectionString;
using (SqlConnection cnn = new SqlConnection())
{
cnn.ConnectionString = connectionString;
SqlCommand cmd = new SqlCommand(query, cnn);
try
{
cnn.Open();
}
catch (Exception ex)
{
var connectionFault = new ConnectionFault();
connectionFault.Operation = "UpdateAccount";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(query);
}
/* SELECT [demoEventID] ,[RSSItemID] ,[CategoryID] ,[Title] ,[demoEvent].[Description],[Link],[RiskLevel],[Status],[Alert],[Message],[pubDate],[heldDate],[Location].LocationName FROM [demoEvent] inner join [Location] on ([demoEvent].LocationID = [Location] .LocationID and [demoEvent].[iscatastrophe] = 1 )
* GO*/
public List <EventTable> GetEvent(Double latt, Double lngt, Decimal radius, string screentype, string clienttype)
{
String query = " SELECT [demoEventID] ,[RSSItemID] ,[CategoryID] ,[Title] ,[demoEvent].[Description],[Link],[RiskLevel],[Status],[Alert],[Message],[pubDate],[heldDate],[Location].LocationName FROM [demoEvent] inner join [Location] on ([demoEvent].LocationID = [Location] .LocationID and [demoEvent].[iscatastrophe] = 1 ) ";
using (SqlConnection sql = new SqlConnection())
{
sql.ConnectionString = RTSMSdbConnectionString;
SqlCommand cmd = new SqlCommand(query, sql);
try
{
sql.Open();
}
catch (Exception ex)
{
DateTime tm = DateTime.Now;
var connectionFault = new ConnectionFault();
connectionFault.Operation = "UpdateAccount";
connectionFault.Reason =
"Can't connect to the database";
connectionFault.Details = ex.Message;
throw new FaultException <ConnectionFault>(
connectionFault);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
DateTime tm = DateTime.Now;
while (reader.Read())
{
// bool status = reader.GetBoolean(8);
//string alert = reader.GetString(8);
results.Add(new EventTable(reader.GetInt32(0), reader.GetString(1), true, false, tm.ToString(), tm.ToString(), reader.GetString(4), reader.GetString(5), reader.GetDouble(18), reader.GetDouble(19), "45"));
results.Add(new EventTable("1adcdsf", "http://192.168.1.101/rtsms_pic/logo3.jpg", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", screentype, article.Distance.ToString(), "AryNews", dat.ToString(), article.Summary + tmp, "http://www.geo.tv/archive/12334.htm", false, i, dat.ToString()));
}
}
else
{
// DateTime tm = DateTime.Now;
// results.Add(new EventTable("1adcdsf", "http://192.168.1.101/rtsms_pic/logo3.jpg", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", screentype, article.Distance.ToString(), "AryNews", dat.ToString(), article.Summary + tmp, "http://www.geo.tv/archive/12334.htm", false, i, dat.ToString()));
}
}
catch (Exception ex)
{
DateTime tm = DateTime.Now;
// results.Add(new EventTable("1adcdsf", "http://192.168.1.101/rtsms_pic/logo3.jpg", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", screentype, article.Distance.ToString(), "AryNews", dat.ToString(), article.Summary + tmp, "http://www.geo.tv/archive/12334.htm", false, i, dat.ToString()));
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
}
return(results);
/*
* //EventTable(string rssitemid,string iconurl,Double longi,Double latti, string locname,string evntname,string distance,string reportedby,string releasedate,string description,string weburl,Boolean isalert,Int32 alertlevel, string helddate)
* List<EventTable> results = new List<EventTable>();
* String query;
* try
* {
* FindNearBy fn = new FindNearBy(latt, lngt);
* List<WikipediaArticle> wiki;
* if (radius > 0)
* {
* wiki = fn.GetNearByLocations(radius);
* }
* else
* {
* wiki = fn.GetNearByLocations(10);
* }
* int i = 0;
*
* Double latt1 = 24.8601083;
* Double lngi1 = 67.2162619;
* Double latt2 = 24.8933790;
* Double lngi2 = 67.0280610;
*
* double e=(3.1415926538*latt1/180);
* double f=(3.1415926538*lngi1/180);
* double g=(3.1415926538*latt2/180);
* double h=(3.1415926538*lngi2/180);
* double P=(Math.Cos(e)*Math.Cos(g)*Math.Cos(f)*Math.Cos(h)+Math.Cos(e)*Math.Sin(f)*Math.Cos(g)*Math.Sin(h)+Math.Sin(e)*Math.Sin(g));
* double j=(Math.Acos(P));
* double k=(6371*j);
*
* String tmp = "sdfjlsjflsjfl sjfl sjf lsjf lsjf lsjflsjf klsjf lsjf lsjf lsjf dsl fjsl fjdsl fjsld fjiwrjovcxlvlvjsl fjls djfsld fjs fljdsfl sj flsj<b>testsfsdf sfjsldf</b> cvlxvljflsjdoie rfdljf sdlf";
*
* foreach (WikipediaArticle article in wiki)
* {
* // DateTime tm;
* // long dat = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000);
* String dat = DateTime.Now.AddSeconds(i++).ToString();
* results.Add(new EventTable("1adcdsf", "http://192.168.1.101/rtsms_pic/logo3.jpg", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", screentype, article.Distance.ToString(), "AryNews", dat.ToString(), article.Summary+tmp, "http://www.geo.tv/archive/12334.htm", false, i, dat.ToString()));
*
* }
* }
* catch (Exception ex)
* {
* var dataFault = new DataFault();
* dataFault.Operation = "AddOrder";
* dataFault.Reason = "ErrError writing to the database";
* dataFault.Details = ex.Message;
* throw new FaultException<DataFault>(dataFault,
* new FaultReason("Error writing to the database"));
* }
* return results;
*/
}
public List <EventTable> GetMyNearBy(Double latt, Double lngt, Decimal radius)
{
//EventTable(string rssitemid,string iconurl,Double longi,Double latti, string locname,string evntname,string distance,string reportedby,string releasedate,string description,string weburl,Boolean isalert,Int32 alertlevel, string helddate)
List <EventTable> results = new List <EventTable>();
String query;
try
{
FindNearBy fn = new FindNearBy(latt, lngt);
List <WikipediaArticle> wiki;
if (radius > 0)
{
wiki = fn.GetNearByLocations(radius);
}
else
{
wiki = fn.GetNearByLocations(10);
}
foreach (WikipediaArticle article in wiki)
{
// DateTime tm;
long dat = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000);
results.Add(new EventTable("rssitemid", "http://192.168.1.1014/logo1.jpg", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", "NearBy", article.Distance.ToString(), "Geo News", dat.ToString(), article.Summary, "http://www.geo.tv/archive/12334.htm", false, 1, dat.ToString()));
/*
* query = @"select * from [Event],[Location] where (Event.pubDate <= GETDATE() and Event.LocationID = (select Location.LocationID from [Location] where (Location.LocationName='" + article.Title + "'))) and Location.LocationID=Event.LocationID;";
* using (SqlConnection sql = new SqlConnection())
* {
* sql.ConnectionString = RTSMSdbConnectionString;
* SqlCommand cmd = new SqlCommand(query, sql);
* try
* {
* sql.Open();
* }
* catch (Exception ex)
* {
* DateTime tm = DateTime.Now;
* results.Add(new EventTable(1, "123", true, false, tm, tm, "Killed !.Quadidabd,Karachi", "3 people killed in Quaidabad.", 67.2162619, 24.8601083));
* var connectionFault = new ConnectionFault();
* connectionFault.Operation = "UpdateAccount";
* connectionFault.Reason =
* "Can't connect to the database";
* connectionFault.Details = ex.Message;
* throw new FaultException<ConnectionFault>(
* connectionFault);
* }
* try
* {
* SqlDataReader reader = cmd.ExecuteReader();
* DateTime tm = DateTime.Now;
*
* results.Add(new EventTable(0, article.Title, true, false, tm, tm, "", "", 4.1, 2.2));
*
* // if (reader.HasRows == true)
* {
*
* DateTime tm = DateTime.Now;
*
* while (reader.Read())
* {
* // bool status = reader.GetBoolean(8);
* //string alert = reader.GetString(8);
* //lng 19 lat20
* results.Add(new EventTable(reader.GetInt32(0), reader.GetString(1), true, false, tm, tm, reader.GetString(4), reader.GetString(5), reader.GetDouble(18), reader.GetDouble(19)));
* }
* }
* else
* {
* DateTime tm = DateTime.Now;
* results.Add(new EventTable(1, " ", true, false, tm, tm, "No Result", "No Result", 0.0, 0.0));
* }
*
*
*
* }
* catch (Exception ex)
* {
* DateTime tm = DateTime.Now;
* results.Add(new EventTable(1, "123", true, false, tm, tm, "Killed !.Quadidabd,Karachi", "3 people killed in Quaidabad.", 67.2162619, 24.8601083));
* var dataFault = new DataFault();
* dataFault.Operation = "AddOrder";
* dataFault.Reason = "ErrError writing to the database";
* dataFault.Details = ex.Message;
* throw new FaultException<DataFault>(dataFault,
* new FaultReason("Error writing to the database"));
* }
* } */
}
}
catch (Exception ex)
{
DateTime tm = DateTime.Now;
//results.Add(new EventTable(1, "123", true, false, tm.ToString(), tm.ToString(), "Killed !.Quadidabd,Karachi", "3 people killed in Quaidabad.", 67.2162619, 24.8601083, "45"));
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
return(results);
}
public List <EventTable> GetEvent(Double latt, Double lngt, Decimal radius, string screentype, string clienttype)
{
/* List<EventTable> results = new List<EventTable>();
* String query = " SELECT [RSSItemID] ,[Title] ,[demoEvent].[Description],[Link],[RiskLevel],[Alert],[Message],[pubDate],[heldDate],[Location].LocationName FROM [demoEvent] inner join [Location] on ([demoEvent].LocationID = [Location] .LocationID and [demoEvent].[iscatastrophe] = 1 ) ";
* using (SqlConnection sql = new SqlConnection())
* {
* sql.ConnectionString = RTSMSdbConnectionString;
* SqlCommand cmd = new SqlCommand(query, sql);
* try
* {
* sql.Open();
* }
* catch (Exception ex)
* {
* DateTime tm = DateTime.Now;
* var connectionFault = new ConnectionFault();
* connectionFault.Operation = "UpdateAccount";
* connectionFault.Reason =
* "Can't connect to the database";
* connectionFault.Details = ex.Message;
* throw new FaultException<ConnectionFault>(
* connectionFault);
* }
* try
* {
* SqlDataReader reader = cmd.ExecuteReader();
* if (reader.HasRows == true)
* {
*
* DateTime tm = DateTime.Now;
*
* while (reader.Read())
* {
* // bool status = reader.GetBoolean(8);
* //string alert = reader.GetString(8);
* String rssitemid = reader.GetString(0); // rssitemid
* String eventtype = reader.GetString(1); // eventtype
* String Description = reader.GetString(2) ;// descr
* String Link= reader.GetString(3); // link
* Int32 risklevel = reader.GetInt32(4); // riskleve
* Boolean isalertType = reader.GetBoolean(5);// alert
* String pubdate = reader.GetDateTime(7).ToString(); // pub
* String helddate = reader.GetDateTime(8).ToString(); // held
* String locationname = reader.GetString(9); //locaname
* // results.Add(new EventTable(reader.GetInt32(0), reader.GetString(1), true, false, tm.ToString(), tm.ToString(), reader.GetString(4), reader.GetString(5), reader.GetDouble(18), reader.GetDouble(19), "45"));
* // results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", Double.Parse(article.Longitude.ToString()), Double.Parse(article.Latitude.ToString()), article.Title, "Kill-Firing", screentype, article.Distance.ToString(), "AryNews", dat.ToString(), article.Summary + tmp, "http://www.geo.tv/archive/12334.htm", false, i, dat.ToString()));
* results.Add(new EventTable(rssitemid, "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, locationname,eventtype, screentype,"2.1", "RTSMS News", pubdate, Description, "http://www.geo.tv/", isalertType, risklevel, helddate));
*
* }
* }
* else
* {
* DateTime tm = DateTime.Now;
* }
*
*
* }
* catch (Exception ex)
* {
* DateTime tm = DateTime.Now;
* results.Add(new EventTable("", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "", "", screentype, "2.1", "RTSMS News", "", "", "http://www.geo.tv/", true, 2, ""));
*
* var dataFault = new DataFault();
* dataFault.Operation = "AddOrder";
* dataFault.Reason = "ErrError writing to the database";
* dataFault.Details = ex.Message;
* throw new FaultException<DataFault>(dataFault,
* new FaultReason("Error writing to the database"));
* }
* }
*
* return results;
*/
//EventTable(string rssitemid,string iconurl,Double longi,Double latti, string locname,string evntname,string distance,string reportedby,string releasedate,string description,string weburl,Boolean isalert,Int32 alertlevel, string helddate)
List <EventTable> results = new List <EventTable>();
String query;
try
{
// FindNearBy fn = new FindNearBy(latt, lngt);
//List<WikipediaArticle> wiki;
/*if (radius > 0)
* {
* wiki = fn.GetNearByLocations(radius);
* }
* else
* {
* wiki = fn.GetNearByLocations(10);
* }*/
int i = 0;
Double latt1 = 24.8601083;
Double lngi1 = 67.2162619;
Double latt2 = 24.8933790;
Double lngi2 = 67.0280610;
double e = (3.1415926538 * latt1 / 180);
double f = (3.1415926538 * lngi1 / 180);
double g = (3.1415926538 * latt2 / 180);
double h = (3.1415926538 * lngi2 / 180);
double P = (Math.Cos(e) * Math.Cos(g) * Math.Cos(f) * Math.Cos(h) + Math.Cos(e) * Math.Sin(f) * Math.Cos(g) * Math.Sin(h) + Math.Sin(e) * Math.Sin(g));
double j = (Math.Acos(P));
double k = (6371 * j);
String tmp = "sdfjlsjflsjfl sjfl sjf lsjf lsjf lsjflsjf klsjf lsjf lsjf lsjf dsl fjsl fjdsl fjsld fjiwrjovcxlvlvjsl fjls djfsld fjs fljdsfl sj flsj<b>testsfsdf sfjsldf</b> cvlxvljflsjdoie rfdljf sdlf";
/*foreach (WikipediaArticle article in wiki)
* {
* // DateTime tm;
* // long dat = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000);
* String dat = DateTime.Now.AddSeconds(i++).ToString();
*/
if (screentype == "lastcates")
{
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "Quaidabad,Karachi", "Clash", screentype, "4.2", "RTSMS News", "31/5/2011", "There was a clash between two political groups at Quaidabad Karachi. Traffic jam reported.", "http://www.geo.tv", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "Pakistan", "Drone strike targeting militants", screentype, "4.2", "RTSMS News", "31/5/2011", "For the first time, the Pakistani military has publicly acknowledged that U.S. drones are targeting militants on Pakistani soil.", "http://rss.cnn.com/~r/rss/edition_asia/~3/BDvvgDvz8tI/index.html", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "ISLAMABAD,ISLAMABAD CAPITAL TERRITORY,PAKISTAN", "Petition filed against US operation in Abbottabad", screentype, "4.2", "RTSMS News", "31/5/2011", "Islamabad A petition seeking to declare the US operation in Abbottabad against the sovereignty of the country and not handing over Osama bin Laden?", "http://www.thenews.com.pk/TodaysPrintDetail.aspx?ID=46891&Cat=6", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "Lahore,Punjab,Pakistan", "Over 2bn infected with TB bacilli", screentype, "4.2", "RTSMS News", "31/5/2011", "LAHORE, March 23: MPA Dr Zamurd Hasmeen Rana says more than two billion people, nearly one third of the world`s total population, are infected with Tuberculosis (TB) bacilli, the microbes that cause TB. She was speaking at an advocacy seminar in connection with “World TB Day 2011” held under the auspices of Pakistan Medical Society [...]", "http://www.dawn.com/2011/03/24/over-2bn-infected-with-tb-bacilli.html", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "KARACHI,SINDH,PAKISTAN", "Tanker owners threaten strike", screentype, "4.2", "RTSMS News", "31/5/2011", "Karachi The All-Pakistan Oil Tankers Association( APOTA) has given a deadline of 10 days to the government to either withdraw the recent fuel pric", "http://www.thenews.com.pk/TodaysPrintDetail.aspx?ID=41143&Cat=4", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "KARACHI,SINDH,PAKISTAN", "Attackers were in contact with commander", screentype, "4.2", "RTSMS News", "31/5/2011", "KARACHI: The PNS Mehran attackers who stormed the naval air base Sunday night were in contact with their commander via high-tech wireless system, Geo ", "http://www.thenews.com.pk/NewsDetail.aspx?ID=16104", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "KARACHI,SINDH,PAKISTAN", "KARACHI 10 years back", screentype, "4.2", "RTSMS News", "31/5/2011", "Karachi, March 2001", "http://www.thenews.com.pk/TodaysPrintDetail.aspx?ID=36138&Cat=4", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "PAKISTAN", "Taliban abducts 72 road workers", screentype, "4.2", "RTSMS News", "31/5/2011", "At least three dozen road workers in southeastern Afghanistan were killed early Thursday when Taliban forces attacked their camp, a local Afghan official said.", "http://rss.cnn.com/~r/rss/edition_world/~3/12Mh8MjGkDc/index.html", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "PAKISTAN", "Six reasons why ISI did not support Osama bin laden", screentype, "4.2", "RTSMS News", "31/5/2011", "KARACHI: Generally speaking, Americans become cocky when they accomplish something. The same can be said about the Osama episode. It is shameful to po", "http://www.thenews.com.pk/TodaysPrintDetail.aspx?ID=46962&Cat=2", false, 2, "1/6/2011"));
results.Add(new EventTable("1adcdsf", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "PAKISTAN", "Suicide bomber targets police in Pakistan", screentype, "4.2", "RTSMS News", "31/5/2011", "A suicide bomber in an explosive-laden car rammed into a police station building in Peshawar, Pakistan, on Wednesday, killing one policeman and injuring 19 other people, a senior police official said.", "http://rss.cnn.com/~r/rss/edition_asia/~3/jBH1kPE3Ys4/index.html", false, 2, "1/6/2011"));
}
else if (screentype == "mynearby")
{
results.Add(new EventTable("", "http://10.11.15.102/rtsms_pic/logo2.png", 0.0, 0.0, "", "", screentype, "2.1", "RTSMS News", "", "", "http://www.geo.tv/", true, 2, ""));
}
//}
}
catch (Exception ex)
{
var dataFault = new DataFault();
dataFault.Operation = "AddOrder";
dataFault.Reason = "ErrError writing to the database";
dataFault.Details = ex.Message;
throw new FaultException <DataFault>(dataFault,
new FaultReason("Error writing to the database"));
}
return(results);
}