public static string HapusData(long IdNasabah)
{
try
{
using (Model1 db = new Model1())
{
TB_NASABAH datalama = db.TB_NASABAH.Where(a => a.ID_NASABAH == IdNasabah).FirstOrDefault();
datalama.IS_DELETE = true;
TB_REKENING dataRek = db.TB_REKENING.Where(x => x.ID_NASABAH == IdNasabah).FirstOrDefault();
dataRek.IS_DELETE = true;
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
return(e.Message.ToString());
throw;
}
}
public static string savedata(VMNasabah Nasabah)
{
try
{
using (Model1 db = new Model1())
{
TB_NASABAH data = new TB_NASABAH();
db.TB_NASABAH.Add(new TB_NASABAH
{
AGAMA = Nasabah.AGAMA,
ALAMAT = Nasabah.ALAMAT,
EMAIL = Nasabah.EMAIL,
NAMA_IBU_KANDUNG = Nasabah.NAMA_IBU_KANDUNG,
PEKERJAAN = Nasabah.PEKERJAAN,
TELEPON = Nasabah.TELEPON,
IS_DELETE = false,
JENIS_KELAMIN = Nasabah.JENIS_KELAMIN,
NAMA = Nasabah.NAMA,
NIK = Nasabah.NIK,
STATUS = Nasabah.STATUS,
TANGGAL_LAHIR = Nasabah.TANGGAL_LAHIR,
UPDATE_BY = "System",
UPDATE_DATE = DateTime.Now,
});
db.SaveChanges();
TB_REKENING data2 = new TB_REKENING();
data2.ID_NASABAH = db.TB_NASABAH.OrderByDescending(x => x.ID_NASABAH).Select(x => x.ID_NASABAH).FirstOrDefault();
string newRek = "000 - " + data2.ID_NASABAH.ToString("D3");
data2.NO_REKENING = newRek;
data2.SALDO = Nasabah.SALDO;
data2.CREATED_BY = "System";
data2.CREATED_DATE = DateTime.Now;
data2.IS_DELETE = false;
db.TB_REKENING.Add(data2);
db.SaveChanges();
}
return("ok");
}
catch (Exception e)
{
return(e.Message.ToString());
throw;
}
}
public static string editdata(VMNasabah Nasabah)
{
try
{
using (Model1 db = new Model1())
{
TB_NASABAH datalama = db.TB_NASABAH.Where(a => a.ID_NASABAH == Nasabah.ID_NASABAH).FirstOrDefault();
datalama.NAMA = Nasabah.NAMA;
datalama.NIK = Nasabah.NIK;
datalama.EMAIL = Nasabah.EMAIL;
datalama.TELEPON = Nasabah.TELEPON;
datalama.JENIS_KELAMIN = Nasabah.JENIS_KELAMIN;
datalama.STATUS = Nasabah.STATUS;
datalama.TANGGAL_LAHIR = Nasabah.TANGGAL_LAHIR;
datalama.NAMA_IBU_KANDUNG = Nasabah.NAMA_IBU_KANDUNG;
datalama.PEKERJAAN = Nasabah.PEKERJAAN;
datalama.AGAMA = Nasabah.AGAMA;
datalama.ALAMAT = Nasabah.ALAMAT;
datalama.UPDATE_BY = "System";
datalama.UPDATE_DATE = DateTime.Now;
TB_REKENING dataRekPrev = db.TB_REKENING.Where(x => x.ID_NASABAH == Nasabah.ID_NASABAH).FirstOrDefault();
dataRekPrev.SALDO = Nasabah.SALDO;
dataRekPrev.UPDATE_BY = "System";
dataRekPrev.UPDATE_DATE = DateTime.Now;
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
return(e.Message.ToString());
throw;
}
}
