/// <summary>
/// Hesap Nesnesi Oluþtur
/// </summary>
public Hesap(System.String pid, string pip, string padi, string psoyadi, string pmail, string psifre, string proller, string ponaykodu, DateTime pdogumtarihi, DateTime pkayittarihi, byte pcinsiyet, byte ptipi, bool pyorum, bool pabonelik, bool paktivasyon, bool paktif)
{
this.m_ID = pid;
this.m_IP = pip;
this.m_Adi = padi;
this.m_Soyadi = psoyadi;
this.m_Mail = pmail;
this.m_Sifre = psifre;
this.m_Roller = proller;
this.m_OnayKodu = ponaykodu;
this.m_DogumTarihi = pdogumtarihi;
this.m_KayitTarihi = pkayittarihi;
this.m_Cinsiyet = Core.GetSexType(pcinsiyet);
this.m_Tipi = Core.GetAccountType(ptipi);
this.m_Yorum = pyorum;
this.m_Abonelik = pabonelik;
this.m_Aktivasyon = paktivasyon;
this.m_Aktif = paktif;
this.m_ProfilObject = new Profil();
}
/// <summary>
/// Profil Getir
/// </summary>
public static Profil GetProfil(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Profil rvProfil = new Profil();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvProfil = new Profil(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["url"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["meslek"]), MConvert.NullToString(IDR["egitim"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["hakkimda"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvProfil);
}
///<summary>
/// Hesap Data URL
///</summary>
public static Hesap GetHesapUrl(string purl)
{
Hesap rvHesap = new Hesap();
Profil tempProfil = ProfilMethods.GetProfilUrl(purl);
if (tempProfil != null)
{
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from hesap where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", tempProfil.ID, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap = new Hesap(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["soyadi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["sifre"]), MConvert.NullToString(IDR["roller"]), MConvert.NullToString(IDR["onaykodu"]), MConvert.NullToDateTime(IDR["dogumtarihi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["cinsiyet"]), MConvert.NullToByte(IDR["tipi"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["abonelik"]), MConvert.NullToBool(IDR["aktivasyon"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
}
rvHesap.ProfilObject = tempProfil;
return(rvHesap);
}
public Hesap()
{
this.m_ID = this.m_IP = this.m_Adi = this.m_Soyadi = this.m_Mail = this.m_Sifre = this.m_Roller = string.Empty;
this.m_ProfilObject = new Profil();
}
public void Remove(Profil obj)
{
this.List.Remove(obj);
}
public int IndexOf(Profil obj)
{
return(this.List.IndexOf(obj));
}
public bool Contains(Profil obj)
{
return(this.List.Contains(obj));
}
public void Insert(int index, Profil obj)
{
this.List.Insert(index, obj);
}
public int Add(Profil obj)
{
return(this.List.Add(obj));
}
