public void AddKorban(Korban korban)
{
foreach (var item in Terlapor)
{
item.Hubungan.Add(new HubunganDenganKorban(item.Id, korban));
}
this.Korban.Add(korban);
}
private Task <int> GetIdIdentitas(Korban item, DbContext db)
{
if (!string.IsNullOrEmpty(item.Error))
{
throw new SystemException("Data Korban tidak Valid");
}
Gender gender = item.Gender;
var data = db.DataKorban.Select().Where(O => O.Nama == item.Nama && O.Gender == gender).FirstOrDefault();
if (data != null)
{
return(Task.FromResult(data.Id.Value));
}
var id = db.DataKorban.InsertAndGetLastID(item);
return(Task.FromResult(id));
}
public AddKorbanViewModel(Korban korban)
{
SaveCommand = new CommandHandler {
CanExecuteAction = ValidateSave, ExecuteAction = SaveAction
};
CancelCommand = new CommandHandler {
CanExecuteAction = x => true, ExecuteAction = CancelAction
};
this.Nama = korban.Nama;
this.Alamat = korban.Alamat;
this.Agama = korban.Agama;
this.Gender = korban.Gender;
this.Id = korban.Id;
this.NamaPanggilan = korban.NamaPanggilan;
this.NIK = korban.NIK;
this.NoReq = korban.NoReq;
this.Pekerjaan = korban.Pekerjaan;
this.Pendidikan = korban.Pendidikan;
this.PengaduanId = korban.PengaduanId;
this.Pernikahan = korban.Pernikahan;
this.Suku = korban.Suku;
this.TanggalLahir = korban.TanggalLahir;
this.TempatLahir = korban.TempatLahir;
}
private Task <List <Korban> > ProccessKorban()
{
var rngPengaduan = excel.GetRange("Korban", "A1:M500");
List <Korban> listKorban = new List <Korban>();
for (var row = 4; row <= rngPengaduan.Count; row++)
{
Korban data = new Korban();
var nomor = rngPengaduan.Cell(row, "A");
if (string.IsNullOrEmpty(nomor))
{
break;
}
data.NoReq = nomor;
data.Nama = rngPengaduan.Cell(row, "B");
data.NamaPanggilan = rngPengaduan.Cell(row, "C");
Gender gender;
var success = Enum.TryParse <Gender>(rngPengaduan.Cell(row, "D"), out gender);
if (!success)
{
break;
}
data.Gender = ConvertEnum <Gender>(rngPengaduan.Cell(row, "D"));
data.TempatLahir = rngPengaduan.Cell(row, "E");
data.TanggalLahir = DateTime.FromOADate(Double.Parse(rngPengaduan.Cell(row, "F"), NumberStyles.Any, CultureInfo.InvariantCulture));
data.Alamat = rngPengaduan.Cell(row, "G");
data.NIK = rngPengaduan.Cell(row, "H");
data.Pekerjaan = rngPengaduan.Cell(row, "I");
data.Pendidikan = rngPengaduan.Cell(row, "J");
data.Agama = rngPengaduan.Cell(row, "K");
data.Suku = rngPengaduan.Cell(row, "L");
data.Pernikahan = rngPengaduan.Cell(row, "M");
StringBuilder sb = new StringBuilder();
if (rngPengaduan.Cell(row, "N").ToLower() == "1")
{
sb.Append($"Fisik#");
}
if (rngPengaduan.Cell(row, "O").ToLower() == "1")
{
sb.Append($"Psikis#");
}
if (rngPengaduan.Cell(row, "P").ToLower() == "1")
{
sb.Append($"Seksual#");
}
if (rngPengaduan.Cell(row, "Q").ToLower() == "1")
{
sb.Append($"Eksploitasi#");
}
if (rngPengaduan.Cell(row, "R").ToLower() == "1")
{
sb.Append($"Trafficking#");
}
if (rngPengaduan.Cell(row, "S").ToLower() == "1")
{
sb.Append($"Penelantaran#");
}
if (rngPengaduan.Cell(row, "T").ToLower() == "1")
{
sb.Append($"Lainnya#");
}
data.KekerasanDialami = sb.ToString().Substring(0, sb.Length - 1);
listKorban.Add(data);
}
var pengangans = excel.GetRange("Penanganan", "A4:G500");
for (var row = 4; row <= pengangans.Count; row++)
{
Penanganan data = new Penanganan();
var nama = pengangans.Cell(row, "B");
if (string.IsNullOrEmpty(nama))
{
break;
}
data.Nama = nama;
data.Tanggal = DateTime.FromOADate(Double.Parse(pengangans.Cell(row, "C"), NumberStyles.Any, CultureInfo.InvariantCulture));
string instansiName = pengangans.Cell(row, "D");
data.Instansi = new Instansi {
Name = instansiName
};
data.Layanan = pengangans.Cell(row, "E");
data.DetailLayanan = pengangans.Cell(row, "F");
data.Deskripsi = pengangans.Cell(row, "G");
var dataKorban = listKorban.Where(x => x.Nama == nama).FirstOrDefault();
if (dataKorban != null)
{
var instansi = DataAccess.DataBasic.DataInstansi.Where(x => x.Name.ToLower() == instansiName.ToLower()).FirstOrDefault();
if (instansi != null)
{
data.DataIdentias = dataKorban;
data.InstansiId = instansi.Id;
data.Instansi = instansi;
data.IdentitasType = "Korban";
}
dataKorban.DataPenanganan.Add(data);
}
}
return(Task.FromResult(listKorban));
}
