public ActionResult EditImg(int Id)
        {
            SqlConnection con = new SqlConnection(constring);
            string        q   = "SELECT * from AboutUs where Id=@Id";

            con.Open();
            SqlCommand cmd = new SqlCommand(q, con);

            cmd.Parameters.AddWithValue("@Id", Id);

            cmd.ExecuteNonQuery();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable      dt      = new DataTable();

            adapter.Fill(dt);
            AboutUsModel ob = new AboutUsModel();

            if (dt.Rows.Count == 1)
            {
                ob.imgid = dt.Rows[0][5].ToString();
            }


            return(View(ob));
        }
        public ActionResult Create(AboutUsModel ob, HttpPostedFileBase file)
        {
            SqlConnection con = new SqlConnection(constring);
            string        q   = "INSERT into AboutUs(Name, Position,Department,Workplace,imgid,Email,Pass) " +
                                "values(@Name,@Position,@Department,@Workplace,@imgid,@Email,@Pass)";

            SqlCommand cmd = new SqlCommand(q, con);

            con.Open();
            cmd.Parameters.AddWithValue("@Name", ob.Name);
            cmd.Parameters.AddWithValue("@Position", ob.Position);
            cmd.Parameters.AddWithValue("@Department", ob.Department);
            cmd.Parameters.AddWithValue("@Workplace", ob.Workplace);

            cmd.Parameters.AddWithValue("@Email", ob.Email);
            cmd.Parameters.AddWithValue("@Pass", "Ad1234");


            if (file != null && file.ContentLength > 0)
            {
                string filename = Path.GetFileName(file.FileName);
                string imgpath  = Path.Combine(Server.MapPath("/aboutimages/"), filename);
                file.SaveAs(imgpath);
            }
            cmd.Parameters.AddWithValue("@imgid", "/aboutimages/" + file.FileName);

            cmd.ExecuteNonQuery();
            return(RedirectToAction("Index"));
        }
Ejemplo n.º 3
0
        // GET: Home
        public virtual ActionResult Index()
        {
            AboutUsModel aboutUsModel = new AboutUsModel();

            aboutUsModel.aboutUsViewModel       = _optionService.GetByCulterAboutUsV();
            aboutUsModel.settingViewModelCultur = _optionService.GetAllSettingByCultur();
            return(View(aboutUsModel));
        }
Ejemplo n.º 4
0
        public ActionResult AdminLogin(AboutUsModel ob)
        {
            SqlConnection con = new SqlConnection(constring);
            String        q   = "Select * From AboutUs where Email=@Email and Pass=@Pass ";

            SqlCommand cmd = new SqlCommand(q, con);

            con.Open();
            //cmd.Parameters.AddWithValue("@Qsn_no", ob.Qsn_no);
            //cmd.Parameters.AddWithValue("@Id", ob.Id);

            //  cmd.Parameters.AddWithValue("@Id", Id);
            cmd.Parameters.AddWithValue("@Email", ob.Email);
            cmd.Parameters.AddWithValue("@Pass", ob.Pass);

            cmd.ExecuteNonQuery();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable      dt      = new DataTable();

            adapter.Fill(dt);
            if (dt.Rows.Count == 1)
            {
                ob.Name          = dt.Rows[0][1].ToString();
                ob.imgid         = dt.Rows[0][5].ToString();
                Session["imgid"] = ob.imgid;
                Session["Name"]  = ob.Name;
            }

            // cmd.Parameters.AddWithValue("@Department", ob.Department);
            //  cmd.Parameters.AddWithValue("@Position", ob.Position);
            //  cmd.Parameters.AddWithValue("@Workplace", ob.Workplace);
            // cmd.Parameters.AddWithValue("@Email", ob.Email);
            //cmd.Parameters.AddWithValue("@imgid", ob.imgid);

            SqlDataReader sdr = cmd.ExecuteReader();

            if (sdr.Read())
            {
                //Session["Name"] = ob.Name.ToString();
                Session["Email"] = ob.Email.ToString();

                Session["Pass"] = ob.Pass.ToString();
                //  Session["Position"] = Position;
                // Session["Department"] = "+AboutusController.Deartment";
                // Session["Workplace"] = "+AboutusController.Workplace";
                // Session["Email"] = "+AboutusController.Email";
                // Session["imgid"] = "+AboutusController.imgid";

                return(RedirectToAction("Index"));
            }
            else
            {
                string message = "Incorrect Password or Email";
                ViewBag.Message = message;
                //ViewData["Messages"] = "Incorrect Name or Password !";
                return(View());
            }
        }
Ejemplo n.º 5
0
        /************** ABOUT **************/

        public ActionResult AboutUs()
        {
            using (db_informaticsEntities _db = new db_informaticsEntities()){
                AboutUsModel model = new AboutUsModel();
                model.aboutList = _db.about_information.ToList();
                model.staffList = _db.staff_information.ToList();
                return(PartialView(model));
            }
        }
Ejemplo n.º 6
0
        public App()
        {
            InitializeComponent();

            apiServicesManager = new ApiServicesManager(new ApiServices());
            user     = new User();
            aum      = new AboutUsModel();
            MainPage = new NavigationPage(new MainPage());
        }
Ejemplo n.º 7
0
    private void FillPage()
    {
        AboutUsModel aboutUsModel = new AboutUsModel();
        aboutu       aboutu       = aboutUsModel.GetAboutus(1);

        lblText1.Text = aboutu.aboutText1;
        lblText2.Text = aboutu.aboutText2;
        img1.ImageUrl = aboutu.Image1;
        img2.ImageUrl = aboutu.Image2;
    }
        public IActionResult Index()
        {
            ViewBag.CurrentPage = "AboutUs";
            var model = new AboutUsModel
            {
                definition = _definitionService.GetDefinition(),
                customers  = _customerService.GetAll()
            };

            return(View(model));
        }
Ejemplo n.º 9
0
 public void InsertOrUpdateAboutUs(AboutUsModel aboutUs)
 {
     if (database.Table <AboutUsModel>().Any(x => x.Id == aboutUs.Id))
     {
         database.Update(aboutUs);
     }
     else
     {
         database.Insert(aboutUs);
     }
 }
Ejemplo n.º 10
0
        private void ListView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
        {
            AboutUsModel item = (AboutUsModel)e.SelectedItem;

            if (item == null)
            {
                return;
            }

            Navigation.PushAsync(new AboutUsPage(item.Id));
            ((ListView)sender).SelectedItem = null;
        }
Ejemplo n.º 11
0
        //
        // GET: /AboutUs/
        // Won't Allow Spaces
        // Use Umb_ to make it harder for users to land on alternate template until solution is found
        public ActionResult Umb_AboutUs(RenderModel model)
        {
            var aboutUsModel = new AboutUsModel(model.Content, model.CurrentCulture);

            // Properties
            aboutUsModel.BodyText = model.Content.GetPropertyValue <string>("bodyText");
            aboutUsModel.QuoteOne = model.Content.GetPropertyValue <string>("quoteOne");
            aboutUsModel.QuoteTwo = model.Content.GetPropertyValue <string>("quoteTwo");

            // Changed from View to CurrentTemplate
            return(CurrentTemplate(aboutUsModel));
        }
Ejemplo n.º 12
0
        public void Save(AboutUsModel model, ResultObject result_object)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(conStr))
                {
                    SqlDataAdapter da = new SqlDataAdapter();
                    DataSet        ds = new DataSet();
                    using (SqlCommand cmd = new SqlCommand("[dbo].[sp_Systbl_AboutUs_Section_Save]", conn))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@section_details_id", Convert.ToInt32(model.section_details_id));
                        cmd.Parameters.AddWithValue("@section_id", Convert.ToInt32(model.section_id));
                        //cmd.Parameters.AddWithValue("@section_name", Convert.ToString(model.section_name));
                        cmd.Parameters.AddWithValue("@section_notes", Convert.ToString(model.section_notes));
                        if (model.image_url == "")
                        {
                            cmd.Parameters.AddWithValue("@image_url", DBNull.Value);
                        }
                        else
                        {
                            cmd.Parameters.AddWithValue("@image_url", Convert.ToString(model.image_url));
                        }

                        if (HttpContext.Current.Session["UserID"] == null)
                        {
                            cmd.Parameters.AddWithValue("@created_by", DBNull.Value);
                        }
                        else
                        {
                            cmd.Parameters.AddWithValue("@created_by", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
                        }
                        cmd.Parameters.AddWithValue("@ip_address", result_object.ipAddress);
                        cmd.CommandTimeout = 0;
                        conn.Open();
                        da = new SqlDataAdapter(cmd);
                        da.Fill(ds);
                        conn.Close();
                        result_object.success = true;
                    }
                }
            }
            catch (Exception ex)
            {
                Error.log(ex, "DataAccess.Actions.AboutUsAction.Save");
                result_object.success         = false;
                result_object.message         = "Unexpected Error occured.Please contact to development team.";
                result_object.is_error_raised = true;
            }
        }
Ejemplo n.º 13
0
        public ActionResult About()
        {
            HttpCookie ThisLanguage = System.Web.HttpContext.Current.Request.Cookies["NOPLanguage"];
            var        aboutUsModel = new AboutUsModel();

            if (ThisLanguage != null)
            {
                var xpoDAO            = new XpoDAO();
                var provideUnitOfWork = xpoDAO.ProvideUnitOfWork();
                var ResultData        = provideUnitOfWork.FindObject <About>(null);
                switch (ThisLanguage.Value)
                {
                case "en":
                {
                    aboutUsModel.Language    = "en";
                    aboutUsModel.BannerTitle = ResultData.TitleP01;
                    break;
                }

                case "vi":
                {
                    aboutUsModel.Language    = "vi";
                    aboutUsModel.BannerTitle = ResultData.TitleVNP01;
                    break;
                }

                default:
                {
                    aboutUsModel.Language    = "en";
                    aboutUsModel.BannerTitle = ResultData.TitleP01;
                    break;
                }
                }
            }
            else
            {
            }
            return(View("AboutUs", aboutUsModel));


            var dao    = new XpoDAO();
            var uow    = dao.ProvideUnitOfWork();
            var result = uow.FindObject <About>(null);

            string       language = "vi";
            AboutUsModel model    = new AboutUsModel();

            return(View("AboutUs", model));
        }
        public ActionResult AboutUs() //calls and renders the about us view
        {
            AboutUsModel model = new AboutUsModel();

            model.Title   = "About Us";
            model.Message = @"The Shelter Pet Project is the result of a collaborative effort between two leading animal
    welfare groups, the Humane Society of the United States and Maddie’s Fund, and the leading 
    producer of public service advertising (PSA) campaigns, The Ad Council.
    Our goal is to make shelters the first place potential adopters turn when looking to get a 
    new pet, ensuring that all healthy and treatable pets find loving homes. We do this by 
    breaking down misconceptions surrounding shelter pets and celebrating the unique bond between
    every shelter pet and parent.";

            return(View(model));
        }
Ejemplo n.º 15
0
        /// <summary>
        /// This is the default Action.
        /// </summary>
        public ActionResult Index()
        {
            var model = new AboutUsModel();

            if (string.IsNullOrEmpty(this.Message))
            {
                model.Message = "Hello, World!";
            }
            else
            {
                model.Message = this.Message;
            }

            return(View("Default", model));
        }
        public async Task <AboutUsPageModel> getAboutUsPageDetail()
        {
            var http = HttpClientFactory.Create();
            int id   = (int)Pages.AboutUs;
            AboutUsPageModel aboutUsPageModel = new AboutUsPageModel();

            //Message Of Committee
            HttpResponseMessage httpResponseAbout = await http.GetAsync(AboutRoutes.GetAboutUsDetails);

            var    contentAbout   = httpResponseAbout.Content;
            string mycontentAbout = await contentAbout.ReadAsStringAsync();

            AboutUsModel itemAbout = JsonConvert.DeserializeObject <AboutUsModel>(mycontentAbout);

            aboutUsPageModel.AboutUsModel = itemAbout;

            //Message Of Committee
            HttpResponseMessage httpResponseMessage = await http.GetAsync(AboutRoutes.GetMessageOFCommitte + "?PageId=" + itemAbout._id);

            var    content   = httpResponseMessage.Content;
            string mycontent = await content.ReadAsStringAsync();

            MessageModel items = JsonConvert.DeserializeObject <MessageModel>(mycontent);

            aboutUsPageModel.MsgCmtModel = items;

            //Feedback Of People
            HttpResponseMessage httpResponsePeople = await http.GetAsync(AboutRoutes.GetAlumniDetails + "?PageId=" + itemAbout._id);

            var    peopleContent   = httpResponsePeople.Content;
            string myPeopleContent = await peopleContent.ReadAsStringAsync();

            List <Alumni> peopleitems = JsonConvert.DeserializeObject <List <Alumni> >(myPeopleContent);

            aboutUsPageModel.Alumnis = peopleitems;

            //Vission Mission
            HttpResponseMessage httpResponseVM = await http.GetAsync(CommonRoutes.GetVissionMission + "?PageId=" + itemAbout._id);

            var    VMContent   = httpResponseVM.Content;
            string myVMContent = await VMContent.ReadAsStringAsync();

            VissionMission item2 = JsonConvert.DeserializeObject <VissionMission>(myVMContent);

            aboutUsPageModel.VissionMission = item2;

            return(aboutUsPageModel);
        }
Ejemplo n.º 17
0
        public void ExecuteLoadNewsCommand()
        {
            if (IsBusy)
            {
                return;
            }

            IsBusy  = true;
            AboutUs = db.GetAboutUs(Key);
            Title   = AboutUs.Title;
            string ParsedDescription = AboutUs.Description.Replace("src=\"/", "src=\"https://www.aims.org.au/");

            Description = ParsedDescription;
            Link        = AboutUs.Link;
            IsBusy      = false;
        }
Ejemplo n.º 18
0
        private async void getAboutExam()
        {
            progress.Show();

            try
            {
                AboutUsModel response = await aboutusapi.GetAboutExamList();

                ResData resddat = response.res_data;
                content1 = resddat.content;

                mWebView.Settings.JavaScriptEnabled = true;

                mWebView.SetWebViewClient(new MyWebViewClientAboutUs());

                mWebView.LoadData("<html>" + content1 + "</html>", "text/html", "utf-8");



                //  Toast.MakeText(this.Activity, "-->" + myFinalList[0].name,ToastLength.Short).Show();


                //  MyList.Adapter = new ArrayAdapter(Activity, Android.Resource.Layout.SimpleListItem1, aboutExamCoursename);

                progress.Dismiss();

                if (about_us.Length <= 0)
                {
                    ISharedPreferences       pref = Android.App.Application.Context.GetSharedPreferences("AboutUsInfo", FileCreationMode.Private);
                    ISharedPreferencesEditor edit = pref.Edit();
                    edit.PutString("content", content1);

                    edit.Apply();
                }


                Intent intent = new Intent(Activity, typeof(AboutUsFragment));
                Activity.StartActivity(intent);
            }
            catch (Exception e)
            {
            }
        }
Ejemplo n.º 19
0
        public ActionResult EditAboutUs(AboutUsModel aum)
        {
            CommonDataService cds = new CommonDataService();

            CommonModel cm = new CommonModel();

            cm = cds.GenerateCommonModel();
            Session["FaceBook"]      = cm.FaceBook;
            Session["Twitter"]       = cm.Twitter;
            Session["Youtube"]       = cm.Youtube;
            Session["Instagram"]     = cm.Instagram;
            Session["PhoneNumber"]   = cm.PhoneNumber;
            Session["Email"]         = cm.Email;
            Session["ShoppingHours"] = cm.ShoppingHours;
            AboutUsDataService auDS         = new AboutUsDataService();
            string             aboutUsId    = (string)Request.Form["edit_AboutUsId"];
            string             aboutUsTitle = (string)Request.Form["edit_AboutUsTitle"];

            try
            {
                if (ModelState.IsValid)
                {
                    aum.AboutUsId = int.Parse(aboutUsId);
                    auDS.UpdateAboutUs(aum);
                    return(RedirectToAction("Edit", "About"));
                }
                else
                {
                    aum              = new AboutUsModel();
                    aum.AboutUsId    = int.Parse(aboutUsId);
                    aum.AboutUsTitle = aboutUsTitle;
                    return(View(aum));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                auDS = null;
            }
        }
Ejemplo n.º 20
0
        public void UpdateAboutUs(AboutUsModel aum)
        {
            try
            {
                AboutUs au = new AboutUs();
                using (VenturadaDataContext vdc = new VenturadaDataContext())
                {
                    au                  = vdc.AboutUs.Single(a => a.AboutUsId == aum.AboutUsId);
                    au.AboutUsId        = aum.AboutUsId;
                    au.AboutUsParagraph = aum.AboutUsParagraph;
                    au.AboutUsTitle     = aum.AboutUsTitle;

                    vdc.SubmitChanges();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 21
0
        public List <AboutUsModel> GetSections(int?section_id, ResultObject result_object)
        {
            List <AboutUsModel> _sections = new List <AboutUsModel>();

            using (SqlConnection conn = new SqlConnection(conStr))
            {
                SqlDataAdapter da = new SqlDataAdapter();
                DataSet        ds = new DataSet();
                using (SqlCommand cmd = new SqlCommand("[dbo].[spGetAboutUsSectionInfo]", conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    if (section_id == null)
                    {
                        cmd.Parameters.AddWithValue("@section_id", DBNull.Value);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@section_id", section_id);
                    }
                    cmd.CommandTimeout = 0;
                    da = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    conn.Close();
                }

                if (ds.Tables.Count != 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        AboutUsModel _section = new AboutUsModel();
                        _section.section_id   = Convert.ToInt32(ds.Tables[0].Rows[i]["section_id"]);
                        _section.section_name = Convert.ToString(ds.Tables[0].Rows[i]["section_name"]);
                        _sections.Add(_section);
                    }
                }
            }
            return(_sections);
        }
        public ActionResult EditImg(AboutUsModel ob, HttpPostedFileBase file)
        {
            SqlConnection con = new SqlConnection(constring);
            string        q   = "Update AboutUs set  Image=@imgid where Id=@Id";

            con.Open();
            SqlCommand cmd = new SqlCommand(q, con);

            cmd.Parameters.AddWithValue("@Id", ob.Id);


            if (file != null && file.ContentLength > 0)
            {
                string filename = Path.GetFileName(file.FileName);
                string imgpath  = Path.Combine(Server.MapPath("/aboutimages/"), filename);
                file.SaveAs(imgpath);
            }
            cmd.Parameters.AddWithValue("@imgid", "/aboutimages/" + file.FileName);
            ViewData["img"] = "/aboutimages/" + file.FileName;

            cmd.ExecuteNonQuery();
            return(RedirectToAction("AboutInfoTable"));
        }
Ejemplo n.º 23
0
        public AboutUsModel GenerateAboutUsModel()
        {
            AboutUsModel aum = new AboutUsModel();

            try
            {
                using (VenturadaDataContext vdc = new VenturadaDataContext())
                {
                    var aboutus = from about in vdc.AboutUs.ToList()
                                  orderby about.AboutUsId ascending
                                  select about;
                    aum                  = new AboutUsModel();
                    aum.AboutUsId        = aboutus.FirstOrDefault().AboutUsId;
                    aum.AboutUsParagraph = aboutus.FirstOrDefault().AboutUsParagraph;
                    aum.AboutUsTitle     = aboutus.FirstOrDefault().AboutUsTitle;
                    aum.ImageUrl         = aboutus.FirstOrDefault().ImageUrl;
                    return(aum);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 24
0
        public int InsertCareer(AboutUsModel aboutUs)
        {
            int output = database.Insert(aboutUs);

            return(output);
        }
Ejemplo n.º 25
0
 public void Save(AboutUsModel model, ResultObject result_object)
 {
     _aboutUsAction_DL.Save(model, result_object);
 }
Ejemplo n.º 26
0
        //public ActionResult LoadContent(string dirName, string pageName)
        //{
        //    var page = ContentService.GetPage(dirName, pageName);
        //    if (page == null) page = new Content();
        //    if (pageName == "index") return View("Index");
        //    else return View("Content", page);
        //}
        public ActionResult LoadContent(string pageName)
        {
            pageName = pageName.ToLower();

            if (pageName == "index")
            {
                var im = new IndexModel();
                var blm = new BlogListModel();
                var posts = BlogService.GetLatestPosts(5);

                blm.ListTitle = "NEWSFLASH";
                blm.Posts = posts;

                im.BlogList = blm;

                return View(pageName, im);
            }
            else if (pageName == "juniors")
            {
                var jm = new JuniorsModel();
                var blm = new BlogListModel();
                var posts = BlogService.GetPostsByCategory("juniors");

                blm.ListTitle = "JUNIORS UPDATES";
                blm.Posts = posts;

                jm.BlogList = blm;

                return View(pageName, jm);
            }
            else if (pageName == "adults")
            {
                var am = new AdultsModel();
                var blm = new BlogListModel();
                var posts = BlogService.GetPostsByCategory("adults");

                blm.ListTitle = "ADULTS UPDATES";
                blm.Posts = posts;

                am.BlogList = blm;

                return View(pageName, am);
            }
            else if (pageName == "construction")
            {
                var cm = new ConstructionModel();
                var blm = new BlogListModel();
                var posts = BlogService.GetPostsByCategory("construction");

                blm.ListTitle = "CONSTRUCTION UPDATES";
                blm.Posts = posts;

                cm.BlogList = blm;

                return View(pageName, cm);
            }
            else if (pageName == "about-us")
            {
                var am = new AboutUsModel();
                var blm = new BlogListModel();
                var posts = BlogService.GetPostsByCategory("general");

                blm.ListTitle = "CLUB NEWS";
                blm.Posts = posts;

                am.BlogList = blm;

                return View(pageName, am);

            }
            else if (pageName == "gallery")
            {
                Flickr flickr = new Flickr(ConfigurationManager.AppSettings["FlickrKey"], ConfigurationManager.AppSettings["FlickrSecret"]);

                FoundUser user = flickr.PeopleFindByEmail("*****@*****.**");

                var photos = flickr.PhotosetsGetList(user.UserId);

                foreach (var set in photos)
                {
                    Response.Write(set.Title + "<br>");
                }

                return View(pageName);
            }
            else
            {
                return View(pageName);
            }
        }
Ejemplo n.º 27
0
 public ResultModel Post([FromBody] AboutUsModel obj)
 {
     return(_svr.Insert(obj, AppUser));
 }
        public ActionResult Create()
        {
            AboutUsModel ob = new AboutUsModel();

            return(View("Create"));
        }
Ejemplo n.º 29
0
        public List <AboutUsModel> Get(int?section_id, int?section_details_id, string searchText, int status, ResultObject result_object)
        {
            List <AboutUsModel> _sections = new List <AboutUsModel>();

            using (SqlConnection conn = new SqlConnection(conStr))
            {
                SqlDataAdapter da = new SqlDataAdapter();
                DataSet        ds = new DataSet();
                using (SqlCommand cmd = new SqlCommand("[dbo].[sp_Systbl_AboutUs_Section_Details_Get]", conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;

                    if (section_id == null)
                    {
                        cmd.Parameters.AddWithValue("@section_id", DBNull.Value);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@section_id", section_id);
                    }

                    if (section_details_id == null)
                    {
                        cmd.Parameters.AddWithValue("@section_details_id", DBNull.Value);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@section_details_id", section_details_id);
                    }

                    if (searchText == null || searchText == "")
                    {
                        cmd.Parameters.AddWithValue("@search_text", DBNull.Value);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@search_text", searchText);
                    }

                    if (status == 1)
                    {
                        cmd.Parameters.AddWithValue("@status", 1);
                    }
                    else if (status == 0)
                    {
                        cmd.Parameters.AddWithValue("@status", 0);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@status", DBNull.Value);
                    }

                    cmd.CommandTimeout = 0;
                    da = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    conn.Close();
                }

                if (ds.Tables.Count != 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        AboutUsModel _section = new AboutUsModel();
                        _section.section_id         = Convert.ToInt32(ds.Tables[0].Rows[i]["section_id"]);
                        _section.section_details_id = Convert.ToInt32(ds.Tables[0].Rows[i]["section_details_id"]);
                        _section.section_name       = Convert.ToString(ds.Tables[0].Rows[i]["section_name"]);
                        _section.section_notes      = Convert.ToString(ds.Tables[0].Rows[i]["section_notes"]);
                        _section.image_url          = Convert.ToString(ds.Tables[0].Rows[i]["image_url"]);
                        _section.isactive           = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[i]["is_active"]) == "" ? 0 : ds.Tables[0].Rows[i]["is_active"]);
                        _sections.Add(_section);
                    }
                }
            }
            result_object.success = true;
            return(_sections);
        }