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