public Warkah GetDataById(string nwBarcode)
{
using (AISContext <Warkah> context = new AISContext <Warkah>())
{
return(context.DBEntities.Where(i => i.NW_Barcode == nwBarcode).FirstOrDefault());
}
}
public Staff GetDataById(string nip)
{
using (AISContext <Staff> context = new AISContext <Staff>())
{
return(context.DBEntities.Where(i => i.NIP == nip).FirstOrDefault());
}
}
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 <Gender> GetAll()
{
using (var context = new AISContext <Gender>())
{
return(context.DBEntities.ToList());
}
}
public Album GetDataById(string noAlbum)
{
using (AISContext <Album> context = new AISContext <Album>())
{
return(context.DBEntities.Where(i => i.No_Album == noAlbum).FirstOrDefault());
}
}
public Desa GetDataById(string idDesa)
{
using (AISContext <Desa> context = new AISContext <Desa>())
{
return(context.DBEntities.Where(i => i.IDDesa == idDesa).FirstOrDefault());
}
}
public JenisHak GetDataById(string idHak)
{
using (AISContext <JenisHak> context = new AISContext <JenisHak>())
{
return(context.DBEntities.Where(i => i.IDHak == idHak).FirstOrDefault());
}
}
public void Update(BukuTanah entity)
{
using (var context = new AISContext <BukuTanah>())
{
BukuTanah data = context.DBEntities.Where(i => i.NB_Barcode == entity.NB_Barcode).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.IDHak = entity.IDHak;
data.NomorHak = entity.NomorHak;
data.No_Album = entity.No_Album;
data.IDDesa = entity.IDDesa;
data.IDKecamatan = entity.IDKecamatan;
data.Luas = entity.Luas;
data.PemegangHak = entity.PemegangHak;
data.Status = entity.Status;
context.SaveChanges();
}
}
}
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 <JenisHak> GetAll()
{
using (var context = new AISContext <JenisHak>())
{
return(context.DBEntities.ToList());
}
}
public Jabatan GetDataById(string idJabatan)
{
using (AISContext <Jabatan> context = new AISContext <Jabatan>())
{
return(context.DBEntities.Where(i => i.IDJabatan == idJabatan).FirstOrDefault());
}
}
public BukuTanah GetDataById(string nbBarcode)
{
using (AISContext <BukuTanah> context = new AISContext <BukuTanah>())
{
return(context.DBEntities.Where(i => i.NB_Barcode == nbBarcode).FirstOrDefault());
}
}
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 <Kecamatan> GetAll()
{
using (var context = new AISContext <Kecamatan>())
{
return(context.DBEntities.ToList());
}
}
public void Add(ComSetting entity)
{
using (var context = new AISContext <ComSetting>())
{
context.DBEntities.Add(entity);
context.SaveChanges();
}
}
public void Add(JenisHak entity)
{
entity.RecordStatus = "A";
using (var context = new AISContext <JenisHak>())
{
context.DBEntities.Add(entity);
context.SaveChanges();
}
}
public void Add(BukuTanah entity)
{
entity.RecordStatus = "A";
using (var context = new AISContext <BukuTanah>())
{
context.DBEntities.Add(entity);
context.SaveChanges();
}
}
public void Add(Kecamatan entity)
{
entity.RecordStatus = "A";
using (var context = new AISContext <Kecamatan>())
{
context.DBEntities.Add(entity);
context.SaveChanges();
}
}
public void Update(JenisHak entity)
{
using (var context = new AISContext <JenisHak>())
{
JenisHak data = context.DBEntities.Where(i => i.IDHak == entity.IDHak).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.NamaHak = entity.NamaHak;
context.SaveChanges();
}
}
}
public void Update(Desa entity)
{
using (var context = new AISContext <Desa>())
{
Desa data = context.DBEntities.Where(i => i.IDDesa == entity.IDDesa).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.IDKecamatan = entity.IDKecamatan;
data.NamaDesa = entity.NamaDesa;
context.SaveChanges();
}
}
}
public void Update(ComSetting entity)
{
using (var context = new AISContext <ComSetting>())
{
ComSetting data = context.DBEntities.Where(i => i.CompanyID == entity.CompanyID).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.CompanyName = entity.CompanyName;
data.CompanyAddress = entity.CompanyAddress;
data.TokenServiceID = entity.TokenServiceID;
context.SaveChanges();
}
}
}
public void Update(Album entity)
{
using (var context = new AISContext <Album>())
{
Album data = context.DBEntities.Where(i => i.No_Album == entity.No_Album).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.Lemari = entity.Lemari;
data.Rak = entity.Rak;
data.Blok = entity.Blok;
context.SaveChanges();
}
}
}
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 void Update(Staff entity)
{
using (var context = new AISContext <Staff>())
{
Staff data = context.DBEntities.Where(i => i.NIP == entity.NIP).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.NamaLengkap = entity.NamaLengkap;
data.IDJabatan = entity.IDJabatan;
data.IDJekel = entity.IDJekel;
data.Alamat = entity.Alamat;
context.SaveChanges();
}
}
}
public void Update(Warkah entity)
{
using (var context = new AISContext <Warkah>())
{
Warkah data = context.DBEntities.Where(i => i.NW_Barcode == entity.NW_Barcode).FirstOrDefault();
if (data == null)
{
//TBD for error exception data not exist
throw new Exception("Data Not Exist");
}
else
{
data.RecordStatus = entity.RecordStatus.Substring(0, 1);
data.Jenis = entity.Jenis;
data.NomorWarkah = entity.NomorWarkah;
data.Tahun = entity.Tahun;
data.No_Album = entity.No_Album;
data.Status = entity.Status;
context.SaveChanges();
}
}
}
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);
}
}
public EventTypesController(AISContext context)
{
_context = context;
}
public FilesController(AISContext context)
{
_context = context;
}
public HomeController(ILogger <HomeController> logger, AISContext context)
{
_logger = logger;
_context = context;
}
