///<summary>
/// SeriIlan Data Delete
///</summary>
public static int Delete(SeriIlan p)
{
int rowsAffected = 0;
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, "delete from seriilan where id=?id", conneciton))
{
cmd.Parameters.Add("id", p.ID, MSqlDbType.BigInt);
rowsAffected = cmd.ExecuteNonQuery();
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// SeriIlan Data PrimaryKey
///</summary>
public static SeriIlan GetSeriIlan(Int64 pid)
{
SeriIlan rvSeriIlan = new SeriIlan();
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 seriilan where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSeriIlan = new SeriIlan(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["detay"]), MConvert.NullToString(IDR["semt"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToFloat(IDR["fiyat"]), MConvert.NullToByte(IDR["kimden"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSeriIlan);
}
///<summary>
/// SeriIlan Data Update
///</summary>
public static int Update(SeriIlan p)
{
int rowsAffected = 0;
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, "update seriilan set hesapid=?hesapid,kategoriid=?kategoriid,resimurl=?resimurl,baslik=?baslik,detay=?detay,semt=?semt,sehir=?sehir,telefon=?telefon,fiyat=?fiyat,kimden=?kimden,kayittarihi=?kayittarihi,guncellemetarihi=?guncellemetarihi,gosterimsayi=?gosterimsayi,yoneticionay=?yoneticionay,aktif=?aktif where id=?id", conneciton))
{
cmd.Parameters.Add("id", p.ID, MSqlDbType.BigInt);
cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar);
cmd.Parameters.Add("kategoriid", p.KategoriID, MSqlDbType.VarChar);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar);
cmd.Parameters.Add("detay", p.Detay, MSqlDbType.VarChar);
cmd.Parameters.Add("semt", p.Semt, MSqlDbType.VarChar);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("telefon", p.Telefon, MSqlDbType.VarChar);
cmd.Parameters.Add("fiyat", p.Fiyat, MSqlDbType.Float);
cmd.Parameters.Add("kimden", p.Kimden, MSqlDbType.SmallInt);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("guncellemetarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("gosterimsayi", p.GosterimSayi, MSqlDbType.Boolean);
cmd.Parameters.Add("yoneticionay", p.YoneticiOnay, MSqlDbType.Boolean);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = cmd.ExecuteNonQuery();
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// SeriIlan Data Insert
///</summary>
public static Int64 Insert(SeriIlan p)
{
Int64 rowsAffected = 0;
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, "insert into seriilan (hesapid,kategoriid,resimurl,baslik,detay,semt,sehir,telefon,fiyat,kimden,kayittarihi,guncellemetarihi,gosterimsayi,yoneticionay,aktif) values(?hesapid,?kategoriid,?resimurl,?baslik,?detay,?semt,?sehir,?telefon,?fiyat,?kimden,?kayittarihi,?guncellemetarihi,?gosterimsayi,?yoneticionay,?aktif); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar);
cmd.Parameters.Add("kategoriid", p.KategoriID, MSqlDbType.VarChar);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar);
cmd.Parameters.Add("detay", p.Detay, MSqlDbType.VarChar);
cmd.Parameters.Add("semt", p.Semt, MSqlDbType.VarChar);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("telefon", p.Telefon, MSqlDbType.VarChar);
cmd.Parameters.Add("fiyat", p.Fiyat, MSqlDbType.Float);
cmd.Parameters.Add("kimden", p.Kimden, MSqlDbType.SmallInt);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("guncellemetarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("gosterimsayi", p.GosterimSayi, MSqlDbType.Boolean);
cmd.Parameters.Add("yoneticionay", p.YoneticiOnay, MSqlDbType.Boolean);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
/// <summary>
/// SeriIlan Getir
/// </summary>
public static SeriIlan GetSeriIlan(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
SeriIlan rvSeriIlan = new SeriIlan();
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())
{
rvSeriIlan = new SeriIlan(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["detay"]), MConvert.NullToString(IDR["semt"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToFloat(IDR["fiyat"]), MConvert.NullToByte(IDR["kimden"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSeriIlan);
}
public void Remove(SeriIlan obj)
{
this.List.Remove(obj);
}
public int IndexOf(SeriIlan obj)
{
return(this.List.IndexOf(obj));
}
public bool Contains(SeriIlan obj)
{
return(this.List.Contains(obj));
}
public void Insert(int index, SeriIlan obj)
{
this.List.Insert(index, obj);
}
public int Add(SeriIlan obj)
{
return(this.List.Add(obj));
}