public static int AdresEkle(List <Adres> adres, string kisi) { DBHelper dBHelper = new DBHelper(); string cmdtext = $"select top 1 MankenID from Manken order by MankenID desc"; int id = Convert.ToInt32(dBHelper.ExecuteScalar(cmdtext, new Dictionary <string, object>())); cmdtext = "insert into Adres (Adres,Sehir,Ulke) values(@adres,@sehir,@ulke)"; Dictionary <string, object> adresler = new Dictionary <string, object>(); foreach (Adres item in adres) { adresler.Clear(); adresler.Add("@adres", item.AcikAdres); adresler.Add("@sehir", item.Sehir); adresler.Add("@ulke", item.Ulke); dBHelper.ExecuteNonQuery(cmdtext, adresler); } cmdtext = "select top 1 AdresID from Adres order by AdresID desc"; int id1 = Convert.ToInt32(dBHelper.ExecuteScalar(cmdtext, new Dictionary <string, object>())); AdresDTO adresDTO = new AdresDTO(); adresDTO.AdresID1 = adres.Count > 0 ? id1 : 0; adresDTO.AdresID2 = adres.Count > 1 ? id1 - 1 : 0; adresDTO.KisiID = id; AraTabloyaAdresEkle(adresDTO, kisi); return(id1); }
public static void AraTabloyaAdresEkle(AdresDTO adres, string kisi) { DBHelper dBHelper = new DBHelper(); string cmdText = $"insert into {kisi}Adres(AdresID,{kisi}ID) values(@adresid,@id)"; Dictionary <string, object> mankenAraTablo = new Dictionary <string, object>(); if (adres.AdresID1 != 0) { mankenAraTablo.Add("@adresid", adres.AdresID1); mankenAraTablo.Add("@id", adres.KisiID); dBHelper.ExecuteNonQuery(cmdText, mankenAraTablo); } if (adres.AdresID2 != 0) { mankenAraTablo.Add("@adresid", adres.AdresID2); mankenAraTablo.Add("@id", adres.KisiID); dBHelper.ExecuteNonQuery(cmdText, mankenAraTablo); } }