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