Beispiel #1
0
        //Site
        private MsSite[] GridSite()
        {
            dc = new DCAssetDataContext();
            List <MsSite> mssite = new List <MsSite>();

            try
            {
                var query = dc.MsSite_View("", "G");
                foreach (var res in query)
                {
                    string Aktif = "";
                    MsSite site  = new MsSite();
                    if (res.bActive.ToString() == "True")
                    {
                        Aktif = "Y";
                    }
                    else
                    {
                        Aktif = "T";
                    }

                    site.Id         = res.Id;
                    site.SiteCode   = res.SiteCode;
                    site.SiteName   = res.SiteName;
                    site.Address    = res.Address;
                    site.City       = res.City;
                    site.PostalCode = res.PostalCode;
                    site.Telephone  = res.Telephone;
                    site.bActive    = res.bActive;
                    site.Aktif      = Aktif;

                    mssite.Add(site);
                }
            }
            catch
            {
                mssite = null;
            }
            return(mssite.ToArray());
        }
Beispiel #2
0
        public MsSite[] GetSite()
        {
            List <MsSite> msite = new List <MsSite>();

            dc = new DCAssetDataContext();
            try
            {
                var query = dc.MsSite_View("", "G");
                foreach (var res in query)
                {
                    MsSite site = new MsSite();
                    site.SiteCode = res.SiteCode;
                    site.SiteName = res.SiteName;
                    msite.Add(site);
                }
            }
            catch (Exception ex)
            {
                ViewBag.Error = ex.Message;
            }
            return(msite.ToArray());
        }