/// <summary>
        /// Created By :: Sakthivel.R
        /// Created On :: 15-9-2015
        /// Comments :: Insertion function of UserPlan details.
        /// </summary>
        #region Insert_UserPlanCreation
        public string UserPlanInsert(UserPlan objUserPlan)
        {
            objEmailCampDataContext = new EmailCampDataContext();
            int?totrow = 0;
            var Insert = (from cde in objEmailCampDataContext.spUserPlan_AllActions(objUserPlan.PK_UserPlanID, objUserPlan.FK_UserID, objUserPlan.FK_PlanID, objUserPlan.ActiveFrom, objUserPlan.ActiveTo, objUserPlan.IsActive, objUserPlan.CreatedBy, objUserPlan.CreatedOn, objUserPlan.UpdatedBy, objUserPlan.UpdatedOn, "i")
                          select cde).ToList();

            Insert = null;

            objEmailCampDataContext = null;
            return(totrow.ToString());
        }
        /// <summary>
        /// Created By :: Sakthivel.R
        /// Created On :: 15-9-2015
        /// Comments :: Updation function of UserPlan details.
        /// </summary>
        #region Delete_UserPlanCreation
        public void UserPlanDelete(int UserPlanid)
        {
            try
            {
                objEmailCampDataContext = new EmailCampDataContext();

                var Delete = (from cde in objEmailCampDataContext.spUserPlan_AllActions(UserPlanid, null, null, null, null, null, null, null, null, null, "d")
                              select cde).ToList();

                Delete                  = null;
                objUserPlan             = null;
                objEmailCampDataContext = null;
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
        }
        /// <summary>
        /// Created By :: Sakthivel.R
        /// Created On :: 15-9-2015
        /// Comments :: Updation function of UserPlan details.
        /// </summary>
        #region Update_UserPlanCreation
        public void UserPlanUpdate(UserPlan objUserPlan)
        {
            try
            {
                objEmailCampDataContext = new EmailCampDataContext();

                var Update = (from cde in objEmailCampDataContext.spUserPlan_AllActions(objUserPlan.PK_UserPlanID, objUserPlan.FK_UserID, objUserPlan.FK_PlanID, objUserPlan.ActiveFrom, objUserPlan.ActiveTo, objUserPlan.IsActive, objUserPlan.CreatedBy, objUserPlan.CreatedOn, objUserPlan.UpdatedBy, objUserPlan.UpdatedOn, "u")
                              select cde).ToList();

                Update                  = null;
                objUserPlan             = null;
                objEmailCampDataContext = null;
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
        }
        /// <summary>
        /// Created By :: Sakthivel.R
        /// Created On :: 15-9-2015
        /// Comments :: Select all records for UserPlan details.
        /// </summary>
        #region Select_Records_CreateUserPlan
        public List <UserPlan> UserPlanSelect(int PK_UserPlanID)
        {
            objEmailCampDataContext = new EmailCampDataContext();
            lstUserPlan             = new List <UserPlan>();

            var Select = (from cde in objEmailCampDataContext.spUserPlan_AllActions(PK_UserPlanID, null, null, null, null, true, null, null, null, null, "s")
                          select cde).ToList();

            if (Select.Count > 0)
            {
                lstUserPlan = new List <UserPlan>();
                foreach (var item in Select)
                {
                    objUserPlan            = new UserPlan();
                    objUserPlan.ActiveFrom = item.ActiveFrom;
                    objUserPlan.ActiveTo   = item.ActiveTo;

                    if (item.FK_PlanID != null)
                    {
                        objUserPlan.FK_PlanID = Convert.ToInt32(item.FK_PlanID);
                    }

                    objUserPlan.FK_UserID     = item.FK_UserID;
                    objUserPlan.IsActive      = item.IsActive;
                    objUserPlan.PK_UserPlanID = item.PK_UserPlanID;
                    objUserPlan.CreatedOn     = item.CreatedOn;
                    objUserPlan.CreatedBy     = item.CreatedBy;
                    objUserPlan.UpdatedBy     = item.UpdatedBy;
                    objUserPlan.UpdatedOn     = item.UpdatedOn;
                    lstUserPlan.Add(objUserPlan);
                }
            }
            objEmailCampDataContext = null;
            objUserPlan             = null;
            return(lstUserPlan);
        }