public Domain.Socioboard.Domain.NewsLetter getAllNewsLetterDetailsbyId(Guid nlid) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to get news details by id. NHibernate.IQuery query = session.CreateQuery("from NewsLetter where Id=:adsid"); query.SetParameter("adsid", nlid); Domain.Socioboard.Domain.NewsLetter grou = (Domain.Socioboard.Domain.NewsLetter)query.UniqueResult(); return(grou); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
public ActionResult SendAddNewsLatter(string Subject, string NewsBody, string SendDate, string UserIds) { DateTime dt = Convert.ToDateTime(SendDate).Date; string[] UsersId = UserIds.Split(','); string mailsender = null; string returnmsg = null; foreach (var item in UsersId) { Api.User.User ApiObjUser=new Api.User.User(); Domain.Socioboard.Domain.User objUser = (Domain.Socioboard.Domain.User)(new JavaScriptSerializer().Deserialize(ApiObjUser.getUsersById(item.ToString()), typeof(Domain.Socioboard.Domain.User))); Domain.Socioboard.Domain.NewsLetter ObjNewsLatter = new NewsLetter(); if (dt == DateTime.Now.Date) { try { Api.MailSender.MailSender ApiObjMailForNewsLtr = new Api.MailSender.MailSender(); mailsender = ApiObjMailForNewsLtr.SendAddNewsLatterMail(objUser.EmailId.ToString(), NewsBody, Subject); ObjNewsLatter.Id = Guid.NewGuid(); ObjNewsLatter.Subject = Subject; ObjNewsLatter.NewsLetterBody = NewsBody; ObjNewsLatter.SendDate = DateTime.Parse(SendDate); ObjNewsLatter.SendStatus = true; ObjNewsLatter.UserId = Guid.Parse(item.ToString()); ObjNewsLatter.EntryDate = DateTime.Now; string Objltr=new JavaScriptSerializer().Serialize(ObjNewsLatter); Api.NewsLetter.NewsLetter objApiNewsltr = new Api.NewsLetter.NewsLetter(); returnmsg = (string)(new JavaScriptSerializer().Deserialize(objApiNewsltr.AddNewsLatter(Objltr), typeof(string))); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } else { ObjNewsLatter.Id = Guid.NewGuid(); ObjNewsLatter.Subject = Subject; ObjNewsLatter.NewsLetterBody = NewsBody; ObjNewsLatter.SendDate = DateTime.Parse(SendDate); ObjNewsLatter.SendStatus = false; ObjNewsLatter.UserId = Guid.Parse(item.ToString()); ObjNewsLatter.EntryDate = DateTime.Now; string Objltr = new JavaScriptSerializer().Serialize(ObjNewsLatter); Api.NewsLetter.NewsLetter objApiNewsltr = new Api.NewsLetter.NewsLetter(); returnmsg = (string)(new JavaScriptSerializer().Deserialize(objApiNewsltr.AddNewsLatter(Objltr),typeof(string))); } } return Content(returnmsg); }
public string AddNewsLatter(string ObjNewsLatter) { try { Domain.Socioboard.Domain.NewsLetter objnewsLatter = (Domain.Socioboard.Domain.NewsLetter)(new JavaScriptSerializer().Deserialize(ObjNewsLatter, typeof(Domain.Socioboard.Domain.NewsLetter))); objNewsLetterRepository.AddNewsLetter(objnewsLatter); return("Success"); } catch (Exception ex) { return("Something went wrong!"); } }
/// <AddNewsLetter> /// Add News Letter /// </AddNewsLetter> /// <param name="nl">Set Values in a NewsLetter Class Property and Pass the Object of NewsLetter Class.(Domein.NewsLetter)</param> public void AddNewsLetter(Domain.Socioboard.Domain.NewsLetter nl) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to save data. session.Save(nl); transaction.Commit(); } //End Transaction } //End Session }
public string AddNewsLatter(string ObjNewsLatter) { try { Domain.Socioboard.Domain.NewsLetter objnewsLatter = (Domain.Socioboard.Domain.NewsLetter)(new JavaScriptSerializer().Deserialize(ObjNewsLatter, typeof(Domain.Socioboard.Domain.NewsLetter))); ObjNewsLetterRepository.AddNewsLetter(objnewsLatter); return(new JavaScriptSerializer().Serialize("Success")); } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); return(new JavaScriptSerializer().Serialize("Something went wrong!")); } }
//[WebMethod] //[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)] public string SendNewsLetter(string body, string Subject, string userid,string NewsLetterId, string email, string name) { UserRepository objUserRepository = new UserRepository(); Domain.Socioboard.Domain.User objUser = new Domain.Socioboard.Domain.User(); objNewsLetter = new Domain.Socioboard.Domain.NewsLetter(); string res = string.Empty; string ret = string.Empty; try { string from = ConfigurationManager.AppSettings["fromemail"]; string tomail = ConfigurationManager.AppSettings["tomail"]; string username = ConfigurationManager.AppSettings["Mandrillusername"]; string host = ConfigurationManager.AppSettings["Mandrillhost"]; string port = ConfigurationManager.AppSettings["Mandrillport"]; string pass = ConfigurationManager.AppSettings["Mandrillpassword"]; //string sss = ConfigurationSettings.AppSettings["host"]; objUser = objUserRepository.getUsersById(Guid.Parse(userid)); GlobusMailLib.MailHelper objMailHelper = new GlobusMailLib.MailHelper(); ret = objMailHelper.SendMailByMandrill(host, Convert.ToInt32(port), from, "", objUser.EmailId, string.Empty, string.Empty, Subject, body, username, pass); //NewsLetterRepository objNewsLetterRepository = new NewsLetterRepository(); if (ret.Contains("Success")) { objNewsLetter.Id = Guid.Parse(NewsLetterId); objNewsLetter.SendStatus = true; objNewsLetterRepository.UpdateNewsLetter(objNewsLetter); } //return ret; } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return ret; }
//[WebMethod] //[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)] public string SendNewsLetter(string body, string Subject, string userid, string NewsLetterId, string email, string name) { UserRepository objUserRepository = new UserRepository(); Domain.Socioboard.Domain.User objUser = new Domain.Socioboard.Domain.User(); objNewsLetter = new Domain.Socioboard.Domain.NewsLetter(); string res = string.Empty; string ret = string.Empty; try { string from = ConfigurationManager.AppSettings["fromemail"]; string tomail = ConfigurationManager.AppSettings["tomail"]; string username = ConfigurationManager.AppSettings["Mandrillusername"]; string host = ConfigurationManager.AppSettings["Mandrillhost"]; string port = ConfigurationManager.AppSettings["Mandrillport"]; string pass = ConfigurationManager.AppSettings["Mandrillpassword"]; //string sss = ConfigurationSettings.AppSettings["host"]; objUser = objUserRepository.getUsersById(Guid.Parse(userid)); GlobusMailLib.MailHelper objMailHelper = new GlobusMailLib.MailHelper(); ret = objMailHelper.SendMailByMandrill(host, Convert.ToInt32(port), from, "", objUser.EmailId, string.Empty, string.Empty, Subject, body, username, pass); //NewsLetterRepository objNewsLetterRepository = new NewsLetterRepository(); if (ret.Contains("Success")) { objNewsLetter.Id = Guid.Parse(NewsLetterId); objNewsLetter.SendStatus = true; objNewsLetterRepository.UpdateNewsLetter(objNewsLetter); } //return ret; } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(ret); }
public string GetAllNewsLetters() { MailSender _MailSender = new MailSender(); //List<NewsLetter> = ObjNewsLetterRepository.getAllNewsLetter(); try { List <Domain.Socioboard.Domain.NewsLetter> lstNewsLetter = new List <Domain.Socioboard.Domain.NewsLetter>(); lstNewsLetter = objNewsLetterRepository.getAllNewsLetters(); if (lstNewsLetter.Count == 0) { return("No record found"); } foreach (Domain.Socioboard.Domain.NewsLetter item in lstNewsLetter) { //string ret = string.Empty; try { objNewsLetter = new Domain.Socioboard.Domain.NewsLetter(); string ret = _MailSender.SendAddNewsLatterMail(item.Email, item.NewsLetterBody, item.Subject); if (ret == "Success") { objNewsLetter.Id = item.Id; objNewsLetter.SendStatus = true; objNewsLetterRepository.UpdateNewsLetter(objNewsLetter); } //SendMail(item); //SendNewsLetter(item.NewsLetterBody, item.Subject, item.UserId.ToString(), item.Id.ToString()); } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } } return("New Latter Sent successfully"); } catch (Exception ex) { return("Please try Again"); } }
/// <UpdateNewsLetter> /// Update News Letter /// </summary> /// <param name="nl">Set Values in a NewsLetter Class Property and Pass the Object of NewsLetter Class.(Domein.NewsLetter)</param> public void UpdateNewsLetter(Domain.Socioboard.Domain.NewsLetter nl) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to update existing news. // session.CreateQuery("Update NewsLetter set SendStatus =1 where UserId = :UserId,SendDate = :SendDate and Id= :adsid") // int i = session.CreateQuery("Update NewsLetter set SendStatus ='1' where Id = :id") // .SetParameter("id",nl.Id) // // .SetParameter("uid", nl.UserId) // //.SetParameter("SendDate", nl.SendDate) // //.SetParameter("nid", nl.Id) // .ExecuteUpdate(); //transaction.Commit(); // List<NewsLetter> alst = session.CreateQuery("from NewsLetter where Id ="+nl.Id+ " ") ////.SetParameter("id", nl.Id) //.List<NewsLetter>() //.ToList<NewsLetter>(); int i = session.CreateQuery("Update NewsLetter set SendStatus ='1' where Id = :id") .SetParameter("id", nl.UserId) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); // return 0; } } //End Transaction } //End Session }
public string GetAllNewsLetters() { MailSender _MailSender=new MailSender(); //List<NewsLetter> = ObjNewsLetterRepository.getAllNewsLetter(); try { List<Domain.Socioboard.Domain.NewsLetter> lstNewsLetter = new List<Domain.Socioboard.Domain.NewsLetter>(); lstNewsLetter = objNewsLetterRepository.getAllNewsLetters(); if(lstNewsLetter.Count == 0) { return "No record found"; } foreach (Domain.Socioboard.Domain.NewsLetter item in lstNewsLetter) { //string ret = string.Empty; try { objNewsLetter=new Domain.Socioboard.Domain.NewsLetter(); string ret = _MailSender.SendAddNewsLatterMail(item.Email, item.NewsLetterBody, item.Subject); if(ret=="Success") { objNewsLetter.Id = item.Id; objNewsLetter.SendStatus = true; objNewsLetterRepository.UpdateNewsLetter(objNewsLetter); } //SendMail(item); //SendNewsLetter(item.NewsLetterBody, item.Subject, item.UserId.ToString(), item.Id.ToString()); } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } } return "New Latter Sent successfully"; } catch (Exception ex) { return "Please try Again"; } }
/// <UpdateNewsLetter> /// Update News Letter /// </summary> /// <param name="nl">Set Values in a NewsLetter Class Property and Pass the Object of NewsLetter Class.(Domein.NewsLetter)</param> public void UpdateNewsLetter(Domain.Socioboard.Domain.NewsLetter nl) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { int i = session.CreateQuery("Update NewsLetter set SendStatus =:SendStatus where Id = :id") .SetParameter("id", nl.UserId) .SetParameter("SendStatus", true) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } //End Transaction } //End Session }
/// <getNewsLetterDetails> /// Get news letter details by news boy /// </summary> /// <param name="nlDetail">Message(Body) of new latter</param> /// <returns></returns> public Domain.Socioboard.Domain.NewsLetter getNewsLetterDetails(string nlDetail) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to get news detail by new body. NHibernate.IQuery query = session.CreateQuery("from NewsLetter where NewsLetterBody=:nlDetail"); query.SetParameter("nlDetail", nlDetail); Domain.Socioboard.Domain.NewsLetter grou = query.UniqueResult <Domain.Socioboard.Domain.NewsLetter>(); return(grou); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
public ActionResult SendAddNewsLatter(string Subject, string NewsBody, string SendDate, string UserIds, string UserEmails, string UserNames) { if (Session["User"] != null) { Domain.Socioboard.Domain.User _User = (Domain.Socioboard.Domain.User)Session["User"]; if (_User.UserType != "SuperAdmin") { return RedirectToAction("Index", "Index"); } } else { return RedirectToAction("Index", "Index"); } DateTime dt = Convert.ToDateTime(SendDate).Date; string[] UsersId = UserIds.Split(','); string[] UserEmail = UserEmails.Split(','); string[] UserName = UserNames.Split(','); //string mailsender = null; string returnmsg = string.Empty; int i = 0; foreach (var item in UsersId) { Api.User.User ApiObjUser=new Api.User.User(); //Domain.Socioboard.Domain.User objUser = (Domain.Socioboard.Domain.User)(new JavaScriptSerializer().Deserialize(ApiObjUser.getUsersById(item.ToString(), Session["access_token"].ToString()), typeof(Domain.Socioboard.Domain.User))); Domain.Socioboard.Domain.NewsLetter objNewsLatter = new NewsLetter(); //if (dt == DateTime.Now.Date) //{ // try // { // Api.MailSender.MailSender ApiObjMailForNewsLtr = new Api.MailSender.MailSender(); // mailsender = ApiObjMailForNewsLtr.SendAddNewsLatterMail(objUser.EmailId.ToString(), NewsBody, Subject); // ObjNewsLatter.Id = Guid.NewGuid(); // ObjNewsLatter.Subject = Subject; // ObjNewsLatter.NewsLetterBody = NewsBody; // ObjNewsLatter.SendDate = DateTime.Parse(SendDate); // ObjNewsLatter.SendStatus = true; // ObjNewsLatter.UserId = Guid.Parse(item.ToString()); // ObjNewsLatter.EntryDate = DateTime.Now; // string Objltr=new JavaScriptSerializer().Serialize(ObjNewsLatter); // Api.NewsLetter.NewsLetter objApiNewsltr = new Api.NewsLetter.NewsLetter(); // returnmsg = (string)(new JavaScriptSerializer().Deserialize(objApiNewsltr.AddNewsLatter(Objltr), typeof(string))); // } // catch (Exception ex) // { // Console.WriteLine(ex.StackTrace); // } //} //else { objNewsLatter.Id = Guid.NewGuid(); objNewsLatter.Subject = Subject; objNewsLatter.NewsLetterBody = NewsBody; objNewsLatter.SendDate = DateTime.Parse(SendDate); objNewsLatter.SendStatus = false; objNewsLatter.UserId = Guid.Parse(item.ToString()); objNewsLatter.Email = UserEmail[i]; objNewsLatter.Name=UserName[i]; objNewsLatter.EntryDate = DateTime.Now; string objltr = new JavaScriptSerializer().Serialize(objNewsLatter); Api.NewsLetter.NewsLetter objApiNewsltr = new Api.NewsLetter.NewsLetter(); returnmsg = objApiNewsltr.AddNewsLatter(objltr); //} i++; } return Content(returnmsg); }