public Domain.Myfashion.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.Myfashion.Domain.NewsLetter grou = (Domain.Myfashion.Domain.NewsLetter)query.UniqueResult();
                        return(grou);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.StackTrace);
                        return(null);
                    }
                } //End Transaction
            }     //End Session
        }
 public string AddNewsLatter(string ObjNewsLatter)
 {
     try
     {
         Domain.Myfashion.Domain.NewsLetter objnewsLatter = (Domain.Myfashion.Domain.NewsLetter)(new JavaScriptSerializer().Deserialize(ObjNewsLatter, typeof(Domain.Myfashion.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!"));
     }
 }
 /// <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.Myfashion.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
 }
        /// <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.Myfashion.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
        }
 /// <getNewsLetterDetails>
 /// Get news letter details by news boy
 /// </summary>
 /// <param name="nlDetail">Message(Body) of new latter</param>
 /// <returns></returns>
 public Domain.Myfashion.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.Myfashion.Domain.NewsLetter grou = query.UniqueResult <Domain.Myfashion.Domain.NewsLetter>();
                 return(grou);
             }
             catch (Exception ex)
             {
                 Console.WriteLine(ex.StackTrace);
                 return(null);
             }
         } //End Transaction
     }     //End Session
 }