public void Mailer(int FeedId) { ErrorExceptionHandler _handler = new ErrorExceptionHandler(); _handler.Webservice_initialize("Web service initialized for subscribers"); try { var path = Path.Combine(Server.MapPath("~/WebService"), "MailContent.html"); string html = File.ReadAllText(path); string Email_Subscribe = ""; Feed _feed = new Feed(); string connectionString = ConfigurationManager.ConnectionStrings[ConnectionName].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlCommand("select TOP 1 * from GS_FEED WHERE Rowstatus='A' order by 1 desc", con); cmd.CommandType = CommandType.Text; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { _feed.ID = (int)rdr["FeedID"]; _feed.Title = rdr["Title"].ToString(); _feed.Description = rdr["Description"].ToString(); _feed.image = rdr["Images"].ToString(); _feed.link = rdr["link"].ToString(); _feed.CategoryID = (int)rdr["Category_Id"]; _feed.Rowstatus = Convert.ToChar(rdr["Rowstatus"]); } } html = html.Replace("Title", _feed.Title); html = html.Replace("Description", _feed.Description); html = html.Replace("link", _feed.link); html = html.Replace("PicName", _feed.image); List <Subscribers> _Subscribers = GetSubscribers.ToList(); for (int i = 0; i < _Subscribers.Count; i++) { Email_Subscribe = _Subscribers[i].Email; Sentmail(html, Email_Subscribe, _feed.Title); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(_Subscribers)); } catch (Exception ex) { string Module_name = "MailerWebservice"; string Action = "Get_All_Subscribers"; _handler.ReportError(Module_name, ex.Message, Action); } }
private bool CheckSubscribes(Subscribe sub) { GetSubscribers subs = new GetSubscribers(); foreach (string str in Ale.getSubscribers(subs)) { Console.WriteLine(str); } return(true); }