tiseza_oss_live/Repositories/DistrictRepository.cs

using OSS.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace OSS.Repositories
{
    public class DistrictRepository
    {
       
        public IEnumerable<SelectListItem> GetDistricts()
        {
            List<SelectListItem> districts = new List<SelectListItem>()
            {
                new SelectListItem
                {
                    Value = null,
                    Text = " "
                }
            };
            return districts;
        }

        public IEnumerable<SelectListItem> GetDistricts(string RegionName)
        {
            if (!String.IsNullOrWhiteSpace(RegionName))
            {
                using (var context = new  OSSDBContext())
                {
                    IEnumerable<SelectListItem> districts = context.Districts.AsNoTracking()
                        .OrderBy(n => n.DistrictCode)
                        .Where(n => n.RegionName == RegionName )
                        .Select(n =>
                           new SelectListItem
                           {
                               Value = n.DistrictName,
                               Text = n.DistrictName
                           }).ToList();
                    return new SelectList(districts, "Value", "Text");
                }
            }
            return null;
        }
        public IEnumerable<SelectListItem> GetDistrictsAll()
        {
           
                using (var context = new OSSDBContext())
                {
                    List<SelectListItem> districts = context.Districts.AsNoTracking()
                    
                        .Select(n =>
                           new SelectListItem
                           {
                               Value = n.DistrictName,
                               Text = n.DistrictName
                           }).ToList();
                var countrytip = new SelectListItem()
                {
                    Value = null,
                    Text = "Select District"
                };
                districts.Insert(0, countrytip);
                return new SelectList(districts, "Value", "Text");
                }
            
        }

        public IEnumerable<SelectListItem> GetDistByName()
        {

            using (var context = new OSSDBContext())
            {
                List<SelectListItem> districts = context.Districts.AsNoTracking()

                    .Select(n =>
                       new SelectListItem
                       {
                           Value = n.DistrictName,
                           Text = n.DistrictName
                       }).ToList();
                var countrytip = new SelectListItem()
                {
                    Value = "",
                    Text = "Select District"
                };
                districts.Insert(0, countrytip);
                return new SelectList(districts, "Value", "Text");
            }

        }

        public IEnumerable<SelectListItem> GetDistrictsNameByRegion(string RegionName)
        {
            if (!String.IsNullOrWhiteSpace(RegionName.ToString()))
            {
                using (var context = new  OSSDBContext())
                {
                    IEnumerable<SelectListItem> districts = context.Districts.AsNoTracking()
                        .OrderBy(n => n.DistrictName)
                        .Where(n => n.RegionName == RegionName.ToString())
                        .Select(n =>
                           new SelectListItem
                           {
                               Value = n.DistrictName,
                               Text = n.DistrictName
                           }).ToList();
                    return new SelectList(districts, "Value", "Text");
                }
            }
            return null;
        }
    }
}