public void AddTerlapor(Terlapor terlapor)
{
foreach (var item in Korban)
{
terlapor.Hubungan.Add(new HubunganDenganKorban(terlapor.Id, item));
}
this.Terlapor.Add(terlapor);
}
private Task <int> GetIdIdentitas(Terlapor item, DbContext db)
{
if (!string.IsNullOrEmpty(item.Error))
{
throw new SystemException("Data Terlapor tidak Valid");
}
Gender gender = item.Gender;
var data = db.DataTerlapor.Select().Where(O => O.Nama == item.Nama && O.Gender == gender).FirstOrDefault();
if (data != null)
{
return(Task.FromResult(data.Id.Value));
}
var id = db.DataTerlapor.InsertAndGetLastID(item);
return(Task.FromResult(id));
}
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));
}
