//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()); }
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()); }