public List <GenVariable> GetDataComGenVariableStartWith(string variableStartWith) { using (var context = new AISContext <GenVariable>()) { return(context.Set <GenVariable>().Where(x => x.ValueName.StartsWith(variableStartWith)).ToList()); } }
public List <BukuTanah> GetAll() { using (var context = new AISContext <BukuTanah>()) { var result = (from a in context.DBEntities join b in context.Set <GenVariable>() on a.RecordStatus equals b.Variable into tmp from tmptest in tmp.DefaultIfEmpty() select new { a, tmptest.Keterangan }).ToList() .Select(i => new BukuTanah { RecordStatus = i.Keterangan, NB_Barcode = i.a.NB_Barcode, IDHak = i.a.IDHak, NomorHak = i.a.NomorHak, No_Album = i.a.No_Album, IDDesa = i.a.IDDesa, IDKecamatan = i.a.IDKecamatan, Luas = i.a.Luas, PemegangHak = i.a.PemegangHak, Status = i.a.Status }).ToList(); return(result); } }
public List <Warkah> GetAll() { using (var context = new AISContext <Warkah>()) { var result = (from a in context.DBEntities join b in context.Set <GenVariable>() on a.RecordStatus equals b.Variable into tmp from tmptest in tmp.DefaultIfEmpty() select new { a, tmptest.Keterangan }).ToList() .Select(i => new Warkah { RecordStatus = i.Keterangan, NW_Barcode = i.a.NW_Barcode, Jenis = i.a.Jenis, NomorWarkah = i.a.NomorWarkah, Tahun = i.a.Tahun, No_Album = i.a.No_Album, Status = i.a.Status }).ToList(); return(result); } }
public List <Jabatan> GetAll() { using (var context = new AISContext <Jabatan>()) { var result = (from a in context.DBEntities join b in context.Set <GenVariable>() on a.RecordStatus equals b.Variable into tmp from tmptest in tmp.DefaultIfEmpty() select new { a, tmptest.Keterangan }).ToList() .Select(i => new Jabatan { RecordStatus = i.Keterangan, IDJabatan = i.a.IDJabatan, NamaJabatan = i.a.NamaJabatan }).ToList(); return(result); } }
public List <Staff> GetAll() { using (var context = new AISContext <Staff>()) { var result = (from a in context.DBEntities join b in context.Set <GenVariable>() on a.RecordStatus equals b.Variable into tmp from tmptest in tmp.DefaultIfEmpty() select new { a, tmptest.Keterangan }).ToList() .Select(i => new Staff { RecordStatus = i.Keterangan, NIP = i.a.NIP, NamaLengkap = i.a.NamaLengkap, Alamat = i.a.Alamat }).ToList(); return(result); } }
public List <Album> GetAll() { using (var context = new AISContext <Album>()) { var result = (from a in context.DBEntities join b in context.Set <GenVariable>() on a.RecordStatus equals b.Variable into tmp from tmptest in tmp.DefaultIfEmpty() select new { a, tmptest.Keterangan }).ToList() .Select(i => new Album { RecordStatus = i.Keterangan, No_Album = i.a.No_Album, Lemari = i.a.Lemari, Rak = i.a.Rak, Blok = i.a.Blok }).ToList(); return(result); } }