public MsLocation[] GetLocation() { List <MsLocation> mLocation = new List <MsLocation>(); dc = new DCAssetDataContext(); try { var query = dc.MsLocation_View("", "G"); foreach (var res in query) { MsLocation location = new MsLocation(); location.LocationCode = res.LocationCode; location.LocationName = res.LocationName; mLocation.Add(location); } } catch (Exception ex) { ViewBag.Error = ex.Message; } return(mLocation.ToArray()); }
private MsLocation[] GridLokasi() { dc = new DCAssetDataContext(); List <MsLocation> mslocation = new List <MsLocation>(); try { var query = dc.MsLocation_View("", "G"); foreach (var res in query) { string Aktif = ""; MsLocation lokasi = new MsLocation(); if (res.bActive.ToString() == "True") { Aktif = "Y"; } else { Aktif = "T"; } lokasi.Id = res.Id; lokasi.LocationCode = res.LocationCode; lokasi.LocationName = res.LocationName; lokasi.SiteCode = res.SiteCode; lokasi.SiteName = res.SiteName; lokasi.bActive = res.bActive; lokasi.Aktif = Aktif; mslocation.Add(lokasi); } } catch { mslocation = null; } return(mslocation.ToArray()); }