public IActionResult UpdateSozlesme(int Id) { SPDatabaseModel data = LoadSozlesmeWithId(Id); SozlesmePersonelModel Sozlesmeler = new SozlesmePersonelModel(); SozlesmeModel sozlesme = new SozlesmeModel(); sozlesme.Firma = data.Sozlesme.Firma; sozlesme.Baslik = data.Sozlesme.Baslik; sozlesme.Arti_Eksilis = data.Sozlesme.Arti_Eksilis; sozlesme.Tarih = data.Sozlesme.Tarih; sozlesme.Talep_Tarihi = data.Sozlesme.Talep_Tarihi; sozlesme.Tamamlanma_Tarihi = data.Sozlesme.Tamamlanma_Tarihi; sozlesme.Id = data.Sozlesme.Sozlesme_Id; Sozlesmeler.Sozlesme = sozlesme; foreach (PersonelDatabaseModel person in data.Personels) { Sozlesmeler.Personels.Add(new PersonelModel { Personel_Id = person.Personel_Id, AdamSaat = person.AdamSaat, SorumluYonetici = person.SorumluYonetici, Rate = person.Rate, Isim = person.Isim, Uzmanlik = person.Uzmanlik, Sozlesme_Id = person.Sozlesme_Id }); } return(View(Sozlesmeler)); }
public static SPDatabaseModel LoadDataWithId(string sql, string sqlP, int Id) { using (IDbConnection cnn = new OracleConnection(GetConnectionString())) { SPDatabaseModel model = new SPDatabaseModel(); model.Sozlesme = cnn.Query <SozlesmeDatabaseModel>(sql, new { ID = Id }).First(); model.Personels = cnn.Query <PersonelDatabaseModel>(sqlP, new { ID = Id }).ToList(); return(model); } }