private void AddPenangananAction(object obj)
{
var typeName = obj.GetType().Name;
if (typeName.Contains("Terlapor"))
{
var terlapor = obj as TerlaporViewModel;
var form = new PenangananView();
var penanganan = new Penanganan(terlapor, "Terlapor")
{
IdentiasId = terlapor.Id, WindowClose = form.Close
};
form.DataContext = penanganan;
form.ShowDialog();
if (!string.IsNullOrEmpty(penanganan.Layanan))
{
terlapor.DataPenanganan.Add(penanganan);
Terlapors.Refresh();
}
else
{
MessageBox.Show("Data Tidak Valid", "Erro", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else if (typeName.Contains("Korban"))
{
var korban = obj as Korban;
var form = new PenangananView();
var penanganan = new Penanganan(korban, "Korban")
{
IdentiasId = korban.Id, WindowClose = form.Close
};
form.DataContext = penanganan;
form.ShowDialog();
if (!string.IsNullOrEmpty(penanganan.Layanan))
{
korban.DataPenanganan.Add(penanganan);
Korbans.Refresh();
}
else
{
MessageBox.Show("Data Tidak Valid", "Erro", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private Task <List <Terlapor> > ProccessTerlapor()
{
var rngPengaduan = excel.GetRange("Terlapor", "A1:T500");
List <Terlapor> listTerlapor = new List <Terlapor>();
for (var row = 4; row <= rngPengaduan.Count; row++)
{
Terlapor data = new Terlapor();
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);
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");
var hub1Name = rngPengaduan.Cell(row, "M");
var hub1 = rngPengaduan.Cell(row, "N");
if (!string.IsNullOrEmpty(hub1) && !string.IsNullOrEmpty(hub1Name))
{
data.Hubungan.Add(new HubunganDenganKorban(0, new Korban()
{
Nama = hub1Name
})
{
JenisHubungan = hub1
});
}
var hub2Name = rngPengaduan.Cell(row, "O");
var hub2 = rngPengaduan.Cell(row, "P");
if (!string.IsNullOrEmpty(hub2) && !string.IsNullOrEmpty(hub2Name))
{
data.Hubungan.Add(new HubunganDenganKorban(0, new Korban()
{
Nama = hub2Name
})
{
JenisHubungan = hub2
});
}
var hub3Name = rngPengaduan.Cell(row, "Q");
var hub3 = rngPengaduan.Cell(row, "R");
if (!string.IsNullOrEmpty(hub3) && !string.IsNullOrEmpty(hub3Name))
{
data.Hubungan.Add(new HubunganDenganKorban(0, new Korban()
{
Nama = hub3Name
})
{
JenisHubungan = hub3
});
}
var hub4Name = rngPengaduan.Cell(row, "S");
var hub4 = rngPengaduan.Cell(row, "T");
if (!string.IsNullOrEmpty(hub4) && !string.IsNullOrEmpty(hub4Name))
{
data.Hubungan.Add(new HubunganDenganKorban(0, new Korban()
{
Nama = hub4Name
})
{
JenisHubungan = hub4
});
}
listTerlapor.Add(data);
}
var pengangans = excel.GetRange("Penanganan", "H4:M500");
for (var row = 4; row <= pengangans.Count; row++)
{
Penanganan data = new Penanganan();
var nama = pengangans.Cell(row, "I");
if (string.IsNullOrEmpty(nama))
{
break;
}
data.Nama = nama;
data.Tanggal = DateTime.FromOADate(Double.Parse(pengangans.Cell(row, "J"), NumberStyles.Any, CultureInfo.InvariantCulture));
string instansiName = pengangans.Cell(row, "K");
data.Instansi = new Instansi {
Name = instansiName
};
data.Layanan = pengangans.Cell(row, "L");
data.Deskripsi = pengangans.Cell(row, "M");
var dataTerlapor = listTerlapor.Where(x => x.Nama == nama).FirstOrDefault();
if (dataTerlapor != null)
{
var instansi = DataAccess.DataBasic.DataInstansi.Where(x => x.Name.ToLower() == instansiName.ToLower()).FirstOrDefault();
if (instansi != null)
{
data.DataIdentias = dataTerlapor;
data.InstansiId = instansi.Id;
data.Instansi = instansi;
data.IdentitasType = "Terlapor";
}
dataTerlapor.DataPenanganan.Add(data);
}
}
return(Task.FromResult(listTerlapor));
}
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));
}
