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