/// <summary> /// Depo adreslerini getirir. carikart_tipi_id in(2,3) (Depo), carikart_turu_id = 3 (Lokasyon) /// </summary> /// <param name="carikart_id"></param> /// <returns></returns> public carikart_genel_adres DepokartAdresleriniGetir(long carikart_id) { //List<carikart_genel_adres> adresler = null; #region Query string query = @" SELECT GA.carikart_id, GA.carikart_adres_id,GA.adres_tipi_id, GA.adres,PUL.ulke_adi,PUS.sehir_adi, PIL.ilce_adi,PSM.semt_adi,GA.postakodu,GA.yetkili_ad_soyad, GA.Tel1,GA.Tel2,GA.fax,GA.yetkili_tel,GA.email,GA.websitesi, GA.adresunvan,GA.ulke_id,GA.sehir_id,GA.ilce_id,GA.semt_id,GA.postakodu from carikart_genel_adres GA inner join carikart C on C.carikart_id = GA.carikart_id and carikart_turu_id = 3 -- and carikart_tipi_id in(2,3) depolar. left join parametre_ulke PUL on PUL.ulke_id = GA.ulke_id left join parametre_ulke_sehir PUS on PUS.sehir_id = GA.sehir_id left join parametre_ulke_sehir_ilce PIL on PIL.ilce_id = GA.ilce_id left join parametre_ulke_sehir_ilce_semt PSM on PSM.semt_id = GA.semt_id where GA.adres_tipi_id='DI' AND GA.carikart_id = @carikart_id and isnull(C.kayit_silindi,0) = 0 and isnull(GA.kayit_silindi,0) = 0 --DI -> Depo İletişim demek. "; #endregion #region Parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@carikart_id", carikart_id) }; #endregion dt = SqlHelper.ExecuteDataset(ConnectionStrings.SqlConn, CommandType.Text, query, parameters).Tables[0]; carikart_genel_adres adres = new carikart_genel_adres(); if (dt != null && dt.Rows.Count > 0) { adres.carikart_id = dt.Rows[0]["carikart_id"].acekaToLong(); adres.carikart_adres_id = dt.Rows[0]["carikart_adres_id"].acekaToLong(); adres.adresunvan = dt.Rows[0]["adresunvan"].ToString(); //Resmi Ünvan adres.adres = dt.Rows[0]["adres"].ToString(); adres.ulke_id = dt.Rows[0]["ulke_id"].acekaToShort(); adres.sehir_id = dt.Rows[0]["sehir_id"].acekaToShort(); adres.ilce_id = dt.Rows[0]["ilce_id"].acekaToShort(); adres.semt_id = dt.Rows[0]["semt_id"].acekaToShort(); adres.tel1 = dt.Rows[0]["tel1"].ToString(); adres.tel2 = dt.Rows[0]["tel2"].ToString(); adres.fax = dt.Rows[0]["fax"].ToString(); adres.email = dt.Rows[0]["email"].ToString(); adres.websitesi = dt.Rows[0]["websitesi"].ToString(); adres.postakodu = dt.Rows[0]["postakodu"].ToString(); adres.yetkili_ad_soyad = dt.Rows[0]["yetkili_ad_soyad"].ToString(); adres.yetkili_tel = dt.Rows[0]["yetkili_tel"].ToString(); //Cep telefonu adres.adres_tipi_id = dt.Rows[0]["adres_tipi_id"].ToString(); } return(adres); }
public carikart_genel_adres PersonelAdresBul(long carikart_id) { carikart_genel_adres adres = null; #region Query string query = @" SELECT CKA.carikart_adres_id, CKA.degistiren_carikart_id, CKA.degistiren_tarih, CKA.kayit_silindi, CKA.statu, CKA.adres_tipi_id, CKA.carikart_id, CKA.adrestanim, CKA.adresunvan, CKA.adres, CKA.postakodu, CKA.ulke_id, U.ulke_adi, CKA.sehir_id, US.sehir_adi, CKA.ilce_id, USI.ilce_adi, CKA.semt_id, USIS.semt_adi, CKA.vergidairesi, CKA.vergino, CKA.tel1, CKA.tel2, CKA.fax, CKA.email, CKA.websitesi, CKA.yetkili_ad_soyad, CKA.yetkili_tel, CKA.faturaadresi FROM carikart_genel_adres AS CKA INNER JOIN carikart CK on CK.carikart_id = CKA.carikart_id LEFT JOIN parametre_ulke U ON U.ulke_id=CKA.ulke_id LEFT JOIN parametre_ulke_sehir US ON US.sehir_id=CKA.sehir_id LEFT JOIN parametre_ulke_sehir_ilce USI ON USI.ilce_id=CKA.ilce_id LEFT JOIN parametre_ulke_sehir_ilce_semt USIS ON USIS.semt_id=CKA.semt_id WHERE CKA.kayit_silindi = 0 AND CK.carikart_turu_id = 2 AND CKA.carikart_id = @carikart_id "; #endregion #region Parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@carikart_id", carikart_id) }; #endregion dt = SqlHelper.ExecuteDataset(ConnectionStrings.SqlConn, CommandType.Text, query, parameters).Tables[0]; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { adres = new carikart_genel_adres(); adres.carikart_adres_id = dt.Rows[i]["carikart_adres_id"].acekaToLong(); adres.degistiren_carikart_id = dt.Rows[i]["degistiren_carikart_id"].acekaToLong(); adres.degistiren_tarih = dt.Rows[i]["degistiren_tarih"].acekaToDateTime(); adres.statu = dt.Rows[i]["statu"].acekaToBool(); adres.adres_tipi_id = dt.Rows[i]["adres_tipi_id"].ToString(); adres.carikart_id = dt.Rows[i]["carikart_id"].acekaToLong(); adres.adrestanim = dt.Rows[i]["adrestanim"].ToString(); adres.adresunvan = dt.Rows[i]["adresunvan"].ToString(); adres.adres = dt.Rows[i]["adres"].ToString(); adres.postakodu = dt.Rows[i]["postakodu"].ToString(); //Ülke Model adres.ulke_id = dt.Rows[i]["ulke_id"].acekaToShort(); adres.ulke = new parametre_ulke(); adres.ulke.ulke_id = dt.Rows[i]["ulke_id"].acekaToShort(); adres.ulke.ulke_adi = dt.Rows[i]["ulke_adi"].ToString(); //Şehir Model adres.sehir_id = dt.Rows[i]["sehir_id"].acekaToShort(); adres.ulke_sehir = new parametre_ulke_sehir(); adres.ulke_sehir.sehir_id = dt.Rows[i]["sehir_id"].acekaToShort(); adres.ulke_sehir.sehir_adi = dt.Rows[i]["sehir_adi"].ToString(); //İlçe Model adres.ilce_id = dt.Rows[i]["ilce_id"].acekaToShort(); adres.ulke_sehir_ilce = new parametre_ulke_sehir_ilce(); adres.ulke_sehir_ilce.ilce_id = dt.Rows[i]["ilce_id"].acekaToShort(); adres.ulke_sehir_ilce.ilce_adi = dt.Rows[i]["ilce_adi"].ToString(); //Semt Model adres.semt_id = dt.Rows[i]["semt_id"].acekaToShort(); adres.ulke_sehir_ilce_semt = new parametre_ulke_sehir_ilce_semt(); adres.ulke_sehir_ilce_semt.semt_id = dt.Rows[i]["semt_id"].acekaToShort(); adres.ulke_sehir_ilce_semt.semt_adi = dt.Rows[i]["semt_adi"].ToString(); adres.vergidairesi = dt.Rows[i]["vergidairesi"].ToString(); adres.vergino = dt.Rows[i]["vergino"].ToString(); adres.tel1 = dt.Rows[i]["tel1"].ToString(); adres.tel2 = dt.Rows[i]["tel2"].ToString(); adres.fax = dt.Rows[i]["fax"].ToString(); adres.email = dt.Rows[i]["email"].ToString(); adres.websitesi = dt.Rows[i]["websitesi"].ToString(); adres.yetkili_ad_soyad = dt.Rows[i]["yetkili_ad_soyad"].ToString(); adres.yetkili_tel = dt.Rows[i]["yetkili_tel"].ToString(); adres.faturaadresi = dt.Rows[i]["faturaadresi"].acekaToBool(); } } return(adres); }