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