///<summary> /// Sayfa Data Update ///</summary> public static int Update(Sayfa 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 sayfa set hesapid=?hesapid,baslik=?baslik,icerik=?icerik,dil=?dil,kayittarihi=?kayittarihi,yerlesim=?yerlesim,aktif=?aktif where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.SmallInt); cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar); cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar); cmd.Parameters.Add("icerik", p.Icerik, MSqlDbType.LongText); cmd.Parameters.Add("dil", p.Dil, MSqlDbType.VarChar); cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("yerlesim", p.Yerlesim, MSqlDbType.SmallInt); 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> /// Sayfa Data Delete ///</summary> public static int Delete(Sayfa 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 sayfa where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.SmallInt); rowsAffected = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Sayfa Data PrimaryKey ///</summary> public static Sayfa GetSayfa(Int16 pid) { Sayfa rvSayfa = new Sayfa(); 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 sayfa where id=?id limit 1", conneciton)) { cmd.Parameters.Add("id", pid, MSqlDbType.SmallInt); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvSayfa = new Sayfa(MConvert.NullToInt16(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvSayfa); }
/// <summary> /// Sayfa Getir /// </summary> public static Sayfa GetSayfa(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { Sayfa rvSayfa = new Sayfa(); 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()) { rvSayfa = new Sayfa(MConvert.NullToInt16(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvSayfa); }
public void Remove(Sayfa obj) { this.List.Remove(obj); }
public int IndexOf(Sayfa obj) { return(this.List.IndexOf(obj)); }
public bool Contains(Sayfa obj) { return(this.List.Contains(obj)); }
public void Insert(int index, Sayfa obj) { this.List.Insert(index, obj); }
public int Add(Sayfa obj) { return(this.List.Add(obj)); }