public int sehirEkleString(string gelenSehirAd, int postaKodu)
{
dm.AddInParameters("@gelenAd", SqlDbType.NVarChar, gelenSehirAd);
dm.AddInParameters("@postaKodu", SqlDbType.Int, postaKodu);
int sonuc = dm.ExecuteNonQuery("insert into Sehir values(@gelenAd,@postaKodu)", CommandType.Text);
return(sonuc);
}
public int caddeEkleString(string gelenCaddeAd, int semtId)
{
dm.AddInParameters("@gelenCaddeAd", SqlDbType.NVarChar, gelenCaddeAd);
dm.AddInParameters("@smtId", SqlDbType.Int, semtId);
int sonuc = dm.ExecuteNonQuery("insert into Cadde values(@gelenCaddeAd,@smtId)", CommandType.Text);
return(sonuc);
}
public int ozellikEkleString(int ozellikTipId, string ozellikAd)
{
dm.AddInParameters("@ozlAd", SqlDbType.NVarChar, ozellikAd);
dm.AddInParameters("@ozlTipId", SqlDbType.Int, ozellikTipId);
int sonuc = dm.ExecuteNonQuery("insert into Ozellik values(@ozlTipId,@ozlAd)", CommandType.Text);
return(sonuc);
}
public int semtEkleString(string gelenSemtAd, int ilceId)
{
dm.AddInParameters("@gelenSemtAd", SqlDbType.NVarChar, gelenSemtAd);
dm.AddInParameters("@ilceId", SqlDbType.Int, ilceId);
int sonuc = dm.ExecuteNonQuery("insert into Semt values(@gelenSemtAd,@ilceId)", CommandType.Text);
return(sonuc);
}
public int fiyatEkleString(int emlakId, int tl, int euro, int dolar, int pound)
{
dm.AddInParameters("@emlakId", SqlDbType.Int, emlakId);
dm.AddInParameters("@tl", SqlDbType.Int, tl);
dm.AddInParameters("@euro", SqlDbType.Int, euro);
dm.AddInParameters("@dolar", SqlDbType.Int, dolar);
dm.AddInParameters("@pound", SqlDbType.Int, pound);
int sonuc = dm.ExecuteNonQuery("insert into Fiyat values(@emlakId,@tl,@euro,@dolar,@pound)", CommandType.Text);
return(sonuc);
}
public static bool emlakEkleEmlak(Emlak e)
{
dm.AddInParameters("@emlakTuru", SqlDbType.NVarChar, e.EmlakTuru);
dm.AddInParameters("@emlakTipId", SqlDbType.Int, e.EmlakTipId);
dm.AddInParameters("@emlakBoyut", SqlDbType.NVarChar, e.EmlakBoyut);
int sonuc = dm.ExecuteNonQuery("insert into Emlak values(@emlakTuru, @emlakTipId, @emlakBoyut)", CommandType.Text);
bool eklendiMi = true;
if (sonuc <= 0)
{
eklendiMi = false;
}
return(eklendiMi);
}
public int isitmaTipSilId(int gelenId)
{
dm.AddInParameters("@isTipId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from IsitmaTip where IsitmaTipId = @isTipId", CommandType.Text);
return(sonuc);
}
public int emlakTipGuncelleId(int emlakTipId, string emlakTipAd)
{
int sonuc = 0;
try
{
dm.AddInParameters("@emlakTipId", SqlDbType.Int, emlakTipId);
dm.AddInParameters("@emlakTipAd", SqlDbType.NVarChar, emlakTipAd);
sonuc = dm.ExecuteNonQuery("update EmlakTip set EmlakTipAd=@emlakTipAd where EmlakTipId=@emlakTipId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int isitmaTipEkleString(string isitmaTipAd)
{
dm.AddInParameters("@isitmaTipAd", SqlDbType.NVarChar, isitmaTipAd);
int sonuc = dm.ExecuteNonQuery("insert into IsitmaTip values(@isitmaTipAd)", CommandType.Text);
return(sonuc);
}
public int kategoriGuncelleId(int kategoriId, string KategoriAd)
{
int sonuc = 0;
try
{
dm.AddInParameters("@kategoriId", SqlDbType.Int, kategoriId);
dm.AddInParameters("@kategoriAd", SqlDbType.NVarChar, KategoriAd);
sonuc = dm.ExecuteNonQuery("update Kategori set KategoriAd=@KategoriAd where KategoriId=@KategoriId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int fiyatSilEmlakId(int gelenId)
{
dm.AddInParameters("@emlakId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from Fiyat where EmlakId = @emlakId", CommandType.Text);
return(sonuc);
}
public int kategoriSilId(int gelenId)
{
dm.AddInParameters("@kategoriId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from Kategori where KategoriId = @kategoriId", CommandType.Text);
return(sonuc);
}
public int ozellikSilId(int gelenId)
{
dm.AddInParameters("@oId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from Ozellik where OzellikId = @oId", CommandType.Text);
return(sonuc);
}
public int sehirSilId(int gelenId)
{
dm.AddInParameters("@shrId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from Sehir where SehirId = @shrId", CommandType.Text);
return(sonuc);
}
public int caddeSilId(int gelenId)
{
dm.AddInParameters("@cdId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from Cadde where CaddeId = @cdId", CommandType.Text);
return(sonuc);
}
public int semtGuncelleId(int semtId, string semtAd, int ilceId)
{
int sonuc = 0;
try
{
dm.AddInParameters("@smtId", SqlDbType.Int, semtId);
dm.AddInParameters("@smtAd", SqlDbType.NVarChar, semtAd);
dm.AddInParameters("@ilceId", SqlDbType.Int, ilceId);
sonuc = dm.ExecuteNonQuery("update Semt set SemtAd = @smtAd, IlceId = @ilceId where SemtId = @smtId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int caddeGuncelleId(int caddeId, string caddeAd, int semtId)
{
int sonuc = 0;
try
{
dm.AddInParameters("@cdId", SqlDbType.Int, caddeId);
dm.AddInParameters("@cdAd", SqlDbType.NVarChar, caddeAd);
dm.AddInParameters("@smtId", SqlDbType.Int, semtId);
sonuc = dm.ExecuteNonQuery("update Cadde set CaddeAd = @cdAd, SemtId = @smtId where CaddeId = @cdId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int ilceGuncelleId(int ilceId, string ilceAd, int sehirId)
{
int sonuc = 0;
try
{
dm.AddInParameters("@ilceId", SqlDbType.Int, ilceId);
dm.AddInParameters("@ilceAd", SqlDbType.NVarChar, ilceAd);
dm.AddInParameters("@sehirId", SqlDbType.Int, sehirId);
sonuc = dm.ExecuteNonQuery("update Ilce set IlceAd = @ilceAd, SehirId = @sehirId where IlceId = @ilceId", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}
public int sehirGuncelleId(int sehirId, string sehirAd, int postaKodu)
{
int sonuc = 0;
try
{
dm.AddInParameters("@shrId", SqlDbType.Int, sehirId);
dm.AddInParameters("@shrAd", SqlDbType.NVarChar, sehirAd);
dm.AddInParameters("@postaKodu", SqlDbType.Int, postaKodu);
sonuc = dm.ExecuteNonQuery("update Sehir set SehirAd = @shrAd, PostaKodu = @postaKodu where SehirId = @shrId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int ozellikGuncelleId(int ozellikId, int ozellikTipId, string ozellikAd)
{
int sonuc = 0;
try
{
dm.AddInParameters("@oId", SqlDbType.Int, ozellikId);
dm.AddInParameters("@oAd", SqlDbType.NVarChar, ozellikAd);
dm.AddInParameters("@oTipId", SqlDbType.Int, ozellikTipId);
sonuc = dm.ExecuteNonQuery("update Ozellik set OzellikAd=@oAd,OzellikTipId=@oTipId where OzellikId=@oId", CommandType.Text);
}
catch (Exception)
{
}
return(sonuc);
}
public int fiyatGuncelleEmlakId(int emlakId, int tl, int euro, int dolar, int pound)
{
int sonuc = 0;
try
{
dm.AddInParameters("@emlakId", SqlDbType.Int, emlakId);
dm.AddInParameters("@tl", SqlDbType.Int, tl);
dm.AddInParameters("@euro", SqlDbType.Int, euro);
dm.AddInParameters("@dolar", SqlDbType.Int, dolar);
dm.AddInParameters("@pound", SqlDbType.Int, pound);
sonuc = dm.ExecuteNonQuery("update Fiyat set TL = @tl, Euro=@euro, Dolar=@dolar, Pound=@pound where EmlakId = @emlakId", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}
public int emlakOzellikSilIdler(int gelenEmlakId, List <int> ozellikIdleri)
{
int sonuc = 0;
try
{
foreach (int ozlId in ozellikIdleri)
{
dm.AddInParameters("@emlakId", SqlDbType.Int, gelenEmlakId);
dm.AddInParameters("@ozellikId", SqlDbType.Int, ozlId);
sonuc += dm.ExecuteNonQuery("delete EmlakOzellik where EmlakId = @emlakId and OzellikId = @ozellikId", CommandType.Text);
dm.ClearParameters();
}
}
catch (Exception ex)
{
}
return(sonuc);
}
public bool emlakTipEkleString(string gelenEmlakTip)
{
bool eklendiMi = false;
dm.AddInParameters("@emlakTip", SqlDbType.NVarChar, gelenEmlakTip);
int sonuc = dm.ExecuteNonQuery("insert into EmlakTip values(@emlakTip)", CommandType.Text);
if (sonuc > 0)
{
eklendiMi = true;
}
return(eklendiMi);
}
public bool emlakTipSilId(int gelenId)
{
bool silindiMi = false;
dm.AddInParameters("@emlakTipId", SqlDbType.Int, gelenId);
int sonuc = dm.ExecuteNonQuery("delete from EmlakTip where EmlakTipId = @emlakTipId", CommandType.Text);
if (sonuc > 0)
{
silindiMi = true;
}
return(silindiMi);
}
public int emlakTipSilId(int gelenId)
{
int sonuc = 0;
try
{
dm.AddInParameters("@emlakTipId", SqlDbType.Int, gelenId);
sonuc = dm.ExecuteNonQuery("delete from EmlakTip where EmlakTipId = @emlakTipId", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}
public int ilceSilId(int gelenId)
{
int sonuc = 0;
try
{
dm.AddInParameters("@ilceId", SqlDbType.Int, gelenId);
sonuc = dm.ExecuteNonQuery("delete from Ilce where IlceId = @ilceId", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}
public int emlakOzellikEkleString(ArrayList ozellikIdLer, int emlakId)
{
int sonuc = 0;
try
{
foreach (string item in ozellikIdLer)
{
dm.AddInParameters("@ozellikId", SqlDbType.Int, Convert.ToInt32(item));
dm.AddInParameters("@emlakId", SqlDbType.Int, emlakId);
int sayi = dm.ExecuteNonQuery("prcEmlakOzellikEkle", CommandType.StoredProcedure);
if (sayi > 0)
{
sonuc += sayi;
}
dm.ClearParameters();
}
}
catch (Exception ex)
{
}
return(sonuc);
}
public int emlakTipEkleString(string gelenEmlakTip)
{
int sonuc = 0;
try
{
dm.AddInParameters("@emlakTipAd", SqlDbType.NVarChar, gelenEmlakTip);
sonuc = dm.ExecuteNonQuery("insert into EmlakTip values(@emlakTipAd)", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}
public int adresEkleString(adres a)
{
dm.AddInParameters("@emlakId", SqlDbType.Int, a.EmlakId);
dm.AddInParameters("@shrId", SqlDbType.Int, a.SehirId);
dm.AddInParameters("@ilceId", SqlDbType.Int, a.IlceId);
dm.AddInParameters("@smtId", SqlDbType.Int, a.SemtId);
dm.AddInParameters("@adresTarifi", SqlDbType.NVarChar, a.AdresTarifi);
dm.AddInParameters("@cdId", SqlDbType.Int, a.CaddeId);
int sonuc = dm.ExecuteNonQuery("insert into Adres values(@emlakId,@shrId,@ilceId,@smtId,@adresTarifi,@cdId)", CommandType.Text);
return(sonuc);
}
public int adresGuncelleId(adres gelenA)
{
int sonuc = 0;
try
{
dm.AddInParameters("@emlakId", SqlDbType.Int, gelenA.EmlakId);
dm.AddInParameters("@sehirId", SqlDbType.Int, gelenA.SehirId);
dm.AddInParameters("@ilceId", SqlDbType.Int, gelenA.IlceId);
dm.AddInParameters("@semtId", SqlDbType.Int, gelenA.SemtId);
dm.AddInParameters("@adresTarifi", SqlDbType.NVarChar, gelenA.AdresTarifi);
dm.AddInParameters("@cdId", SqlDbType.Int, gelenA.CaddeId);
sonuc = dm.ExecuteNonQuery("update Adres set SehirId = @sehirId, IlceId = @ilceId, SemtId = @semtId, AdresTarifi = @adresTarifi, CaddeId = @cdId where EmlakId = @emlakId", CommandType.Text);
}
catch (Exception ex)
{
}
return(sonuc);
}