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