public JsonResult FillSubscriptionPlan(Int64 ID_SubscriptionPlan)
 {
     try
     {
         DataTable          dtbl = new DataTable();
         BlSubscriptionPlan blSubscriptionPlan = new BlSubscriptionPlan();
         blSubscriptionPlan.MasterID   = ID_SubscriptionPlan;
         blSubscriptionPlan.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
         blSubscriptionPlan.FK_Company = Convert.ToInt64(Session["ID_Company"]);
         dtbl = blSubscriptionPlan.SelectAllData();
         return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(ex));
     }
 }
        public ActionResult UpdateSubscriptionPlan(BlSubscriptionPlan ObjBlSubscriptionPlan)
        {
            long statusCode = 0;

            ObjBlSubscriptionPlan.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
            ObjBlSubscriptionPlan.FK_Company = Convert.ToInt64(Session["ID_Company"]);
            if (ObjBlSubscriptionPlan.MasterID == 0)
            {
                statusCode = ObjBlSubscriptionPlan.InsertData();
            }
            else
            {
                statusCode = ObjBlSubscriptionPlan.UpdateData();
            }

            return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult DeleteSubscriptionPlan(Int64 ID_SubscriptionPlan)
        {
            try
            {
                long statusCode = 0;
                BlSubscriptionPlan blSubscriptionPlan = new BlSubscriptionPlan();
                blSubscriptionPlan.MasterID   = ID_SubscriptionPlan;
                blSubscriptionPlan.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
                blSubscriptionPlan.FK_Company = Convert.ToInt64(Session["ID_Company"]);

                statusCode = blSubscriptionPlan.DeleteData();
                return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(ex));
            }
        }
        public JsonResult SelectSubscriptionPlanAll(string PageIndex = "1", string SearchItem = "")
        {
            try
            {
                int                statusCode         = 1;
                DataTable          dtbl               = new DataTable();
                BlSubscriptionPlan blSubscriptionPlan = new BlSubscriptionPlan();
                blSubscriptionPlan.PageIndex  = Convert.ToInt32(PageIndex);
                blSubscriptionPlan.FK_Company = Convert.ToInt64(Session["ID_Company"]);

                blSubscriptionPlan.SubscriptionPlanCode = SearchItem;
                blSubscriptionPlan.SubscriptionPlanName = SearchItem;

                dtbl = blSubscriptionPlan.SelectAllData();
                return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                ///
                return(Json(ex));
            }
        }