예제 #1
0
        /// <SetCouponById>
        /// Update coupon by coupon id (Guid).
        /// </summary>
        /// <param name="coupon">Set coupon value in a coupon Property Class and Pass the Object of coupon Class as a paremeter.(SocioBoard.Domain.Admin).</param>
        /// <returns>1 for success and 0 for fail</returns>
        //public int SetCouponById(Domain.Socioboard.Domain.Coupon coupon)
        //{
        //    int res = 0;

        //    try
        //    {
        //        //Creates a database connection and opens up a session
        //        using (NHibernate.ISession session = SessionFactory.GetNewSession())
        //        {
        //            using (NHibernate.ITransaction transaction = session.BeginTransaction())
        //            {
        //                //Proceed action, to update existing data by coupon id.
        //                res = session.CreateQuery("Update Coupon set CouponCode=:couponCode,EntryCouponDate=:entryCouponDate,ExpCouponDate=:expCouponDate,Status=:status where Id = :id")
        //                           .SetParameter("couponCode", coupon.CouponCode)
        //                           .SetParameter("entryCouponDate", coupon.EntryCouponDate)
        //                           .SetParameter("expCouponDate", coupon.ExpCouponDate)
        //                           .SetParameter("status", coupon.Status)
        //                           .SetParameter("id", coupon.Id)
        //                           .ExecuteUpdate();
        //                transaction.Commit();

        //            }//End transaction
        //        }//End session
        //    }
        //    catch (Exception ex)
        //    {
        //        Console.WriteLine("Error : " + ex.StackTrace);
        //    }
        //    return res;
        //}

        public int SetCouponById(Domain.Socioboard.Domain.Coupon coupon)
        {
            int res = 0;

            try
            {
                //Creates a database connection and opens up a session
                using (NHibernate.ISession session = SessionFactory.GetNewSession())
                {
                    using (NHibernate.ITransaction transaction = session.BeginTransaction())
                    {
                        //Proceed action, to update existing data by coupon id.
                        res = session.CreateQuery("Update Coupon set EntryCouponDate=:entryCouponDate,ExpCouponDate=:expCouponDate,Status=:status where CouponCode=:couponCode")
                              .SetParameter("couponCode", coupon.CouponCode)
                              .SetParameter("entryCouponDate", coupon.EntryCouponDate)
                              .SetParameter("expCouponDate", coupon.ExpCouponDate)
                              .SetParameter("status", coupon.Status)
                              .ExecuteUpdate();
                        transaction.Commit();
                    } //End transaction
                }     //End session
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error : " + ex.StackTrace);
            }
            return(res);
        }
예제 #2
0
        /// <GetCouponByCouponId>
        /// Get the coupon detail by coupon Id.
        /// </summary>
        /// <param name="coupon">Set coupon value in a coupon Property Class and Pass the Object of coupon Class as a paremeter.(SocioBoard.Domain.Admin).</param>
        /// <returns>coupon values in the list of coupon properties classes.(List<Domain.Coupon>) </returns>
        public List <Domain.Socioboard.Domain.Coupon> GetCouponByCouponId(Domain.Socioboard.Domain.Coupon coupon)
        {
            //Coupon res = null;
            List <Domain.Socioboard.Domain.Coupon> res = new List <Domain.Socioboard.Domain.Coupon>();

            try
            {
                //Creates a database connection and opens up a session
                using (NHibernate.ISession session = SessionFactory.GetNewSession())
                {
                    using (NHibernate.ITransaction transaction = session.BeginTransaction())
                    {
                        //Proceed action, to get coupon detail by coupon id.
                        res = session.CreateQuery("from Coupon u where u.Id = : id")
                              .SetParameter("id", coupon.Id)
                              .List <Domain.Socioboard.Domain.Coupon>().ToList <Domain.Socioboard.Domain.Coupon>();
                    } //End transaction
                }     //End session
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error : " + ex.StackTrace);
            }
            return(res);
        }
예제 #3
0
        /// <Add>
        /// Add new Coupon.
        /// </summary>
        /// <param name="user">Set Values in a coupon Class Property and Pass the Object of coupon Class (SocioBoard.Domain.Admin).</param>
        /// <returns>When successfully added it return Added otherwise  it return null.</returns>
        public string Add(Domain.Socioboard.Domain.Coupon coupon)
        {
            string res = null;

            try
            {
                //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 add new row.
                        session.Save(coupon);
                        transaction.Commit();
                        res = "Added";
                    } //End transaction
                }     //End session
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error : " + ex.StackTrace);
            }
            return(res);
        }