public static List <Urun> GetSelect() { List <Urun> rvUrun = new List <Urun>(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select * from Urun", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvUrun.Add(new Urun(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToFloat(IDR["Miktar"]), MConvert.NullToString(IDR["Birim"]), MConvert.NullToFloat(IDR["Kdv"]), MConvert.NullToDateTime(IDR["Tarih"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvUrun); }
public static int Delete(string modulID, string icerikID) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "DELETE FROM Yorum WHERE ModulID=@ModulID AND IcerikID=@IcerikID", conneciton)) { cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", icerikID, MSqlDbType.VarChar); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static Kategori GetKategori(int pID) { Kategori rvKategori = new Kategori(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select top 1 * from Kategori where ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori = new Kategori(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToString(IDR["Adi"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
///<summary> /// Video Data Update ///</summary> public static int Update(Video p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Video SET HesapID=@HesapID,KategoriID=@KategoriID,ResimUrl=@ResimUrl,Baslik=@Baslik,Embed=@Embed,Etiket=@Etiket,KayitTarihi=@KayitTarihi,Yorum=@Yorum,Aktif=@Aktif WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.BigInt); cmd.Parameters.Add("HesapID", p.HesapID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("KategoriID", p.KategoriID, MSqlDbType.VarChar); cmd.Parameters.Add("ResimUrl", p.ResimUrl, MSqlDbType.VarChar); cmd.Parameters.Add("Baslik", p.Baslik, MSqlDbType.NVarChar); cmd.Parameters.Add("Embed", p.Embed, MSqlDbType.VarChar); cmd.Parameters.Add("Etiket", p.Etiket, MSqlDbType.NVarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("Yorum", p.Yorum, MSqlDbType.Bit); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Yorum Data Update ///</summary> public static int Update(Yorum p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Yorum SET IP=@IP,ModulID=@ModulID,IcerikID=@IcerikID,Adi=@Adi,Mail=@Mail,Icerik=@Icerik,KayitTarihi=@KayitTarihi,YoneticiOnay=@YoneticiOnay,Aktif=@Aktif WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("IP", p.IP, MSqlDbType.VarChar); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("Adi", p.Adi, MSqlDbType.NVarChar); cmd.Parameters.Add("Mail", p.Mail, MSqlDbType.VarChar); cmd.Parameters.Add("Icerik", p.Icerik, MSqlDbType.NVarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("YoneticiOnay", p.YoneticiOnay, MSqlDbType.Bit); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static DovizCollection GetSelect() { DovizCollection rvDoviz = new DovizCollection(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select * from Doviz", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvDoviz.Add(new Doviz(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Cinsi"]), MConvert.NullToFloat(IDR["Kuru"]), MConvert.NullToDateTime(IDR["Tarih"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvDoviz); }
///<summary> /// Begen Data Update ///</summary> public static int Update(Begen p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Begen SET HesapID=@HesapID,IP=@IP,ModulID=@ModulID,IcerikID=@IcerikID,Durum=@Durum,KayitTarihi=@KayitTarihi WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("HesapID", p.HesapID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("IP", p.IP, MSqlDbType.VarChar); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("Durum", p.Durum, MSqlDbType.Bit); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Gosterim Data Insert ///</summary> public static int Insert(Gosterim p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "INSERT INTO Gosterim (HesapID,IP,ModulID,IcerikID,KayitTarihi) VALUES(@HesapID,@IP,@ModulID,@IcerikID,@KayitTarihi)", conneciton)) { cmd.Parameters.Add("HesapID", p.HesapID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("IP", p.IP, MSqlDbType.VarChar); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static int Count(string picerikid) { int rvCount = 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, "select count(y.id) AS totalcount from yorum y where y.yoneticionay=1 and y.aktif=1 and y.icerikid=?icerikid", conneciton)) { cmd.Parameters.Add("icerikid", picerikid, BAYMYO.MultiSQLClient.MSqlDbType.VarChar); rvCount = MConvert.NullToInt(cmd.ExecuteScalar()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvCount); }
///<summary> /// Reklam Data PrimaryKey ///</summary> public static Reklam GetReklam(int pid) { Reklam rvReklam = new Reklam(); 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 reklam where id=?id", conneciton)) { cmd.Parameters.Add("id", pid, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvReklam = new Reklam(MConvert.NullToInt(IDR["id"]), MConvert.NullToString(IDR["bannername"]), MConvert.NullToString(IDR["imageurl"]), MConvert.NullToString(IDR["navigateurl"]), MConvert.NullToString(IDR["alternatetext"]), MConvert.NullToString(IDR["keyword"]), MConvert.NullToString(IDR["adsenseclient"]), MConvert.NullToString(IDR["adsenseslot"]), MConvert.NullToInt(IDR["impressions"]), MConvert.NullToInt(IDR["width"]), MConvert.NullToInt(IDR["height"]), IDR.GetByte(11), MConvert.NullToBool(IDR["isactive"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvReklam); }
public static ReklamCollection GetSelect(int width, int height, byte orders) { ReklamCollection rvReklam = new ReklamCollection(); 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 reklam r where r.width=?width and r.height=?height and r.orders=?orders and r.isactive=1 limit 99", conneciton)) { cmd.Parameters.Add("width", width, MSqlDbType.Int); cmd.Parameters.Add("height", height, MSqlDbType.Int); cmd.Parameters.Add("orders", orders, MSqlDbType.TinyInt); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvReklam.Add(new Reklam(MConvert.NullToInt(IDR["id"]), MConvert.NullToString(IDR["bannername"]), MConvert.NullToString(IDR["imageurl"]), MConvert.NullToString(IDR["navigateurl"]), MConvert.NullToString(IDR["alternatetext"]), MConvert.NullToString(IDR["keyword"]), MConvert.NullToString(IDR["adsenseclient"]), MConvert.NullToString(IDR["adsenseslot"]), MConvert.NullToInt(IDR["impressions"]), MConvert.NullToInt(IDR["width"]), MConvert.NullToInt(IDR["height"]), IDR.GetByte(11), MConvert.NullToBool(IDR["isactive"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvReklam); }
///<summary> /// Manset Data Update ///</summary> public static int Update(Manset p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Manset SET ModulID=@ModulID,IcerikID=@IcerikID,ResimKucuk=@ResimKucuk,ResimUrl=@ResimUrl,Baslik=@Baslik,Aciklama=@Aciklama,KayitTarihi=@KayitTarihi,Aktif=@Aktif WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("ResimKucuk", p.ResimKucuk, MSqlDbType.VarChar); cmd.Parameters.Add("ResimUrl", p.ResimUrl, MSqlDbType.VarChar); cmd.Parameters.Add("Baslik", p.Baslik, MSqlDbType.NVarChar); cmd.Parameters.Add("Aciklama", p.Aciklama, MSqlDbType.NVarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Manset Data Insert ///</summary> public static int Insert(Manset p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "INSERT INTO Manset (ModulID,IcerikID,ResimKucuk,ResimUrl,Baslik,Aciklama,KayitTarihi,Aktif) VALUES(@ModulID,@IcerikID,@ResimKucuk,@ResimUrl,@Baslik,@Aciklama,@KayitTarihi,@Aktif)", conneciton)) { cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("ResimKucuk", p.ResimKucuk, MSqlDbType.VarChar); cmd.Parameters.Add("ResimUrl", p.ResimUrl, MSqlDbType.VarChar); cmd.Parameters.Add("Baslik", p.Baslik, MSqlDbType.NVarChar); cmd.Parameters.Add("Aciklama", p.Aciklama, MSqlDbType.NVarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static Urun GetUrun(int pID) { Urun rvUrun = new Urun(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select top 1 * from Urun where ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvUrun = new Urun(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToFloat(IDR["Miktar"]), MConvert.NullToString(IDR["Birim"]), MConvert.NullToFloat(IDR["Kdv"]), MConvert.NullToDateTime(IDR["Tarih"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvUrun); }
public static int Count(byte pdurum, string pmail, bool paktif) { int rvCount = 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, "select count(id) as totalcount from mesaj where mail=?mail and durum=?durum and aktif=?aktif", conneciton)) { cmd.Parameters.Add("mail", pmail, MSqlDbType.VarChar); cmd.Parameters.Add("durum", pdurum, MSqlDbType.Byte); cmd.Parameters.Add("aktif", paktif, MSqlDbType.Boolean); rvCount = MConvert.NullToInt(cmd.ExecuteScalar()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvCount); }
public static int Count(string phesapid, string purl, bool pyoneticionay, bool paktif) { int rvCount = 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, "select count(y.id) AS totalcount from yorum y where (y.yoneticionay=?yoneticionay and y.aktif=?aktif) and (exists(select id from makale where makale.hesapid=?hesapid) or exists(select id from mesaj where mesaj.hesapid=?hesapid) or exists(select id from video where video.hesapid=?hesapid) or y.icerikid=?url)", conneciton)) { cmd.Parameters.Add("hesapid", phesapid, BAYMYO.MultiSQLClient.MSqlDbType.VarChar); cmd.Parameters.Add("url", purl, BAYMYO.MultiSQLClient.MSqlDbType.VarChar); cmd.Parameters.Add("yoneticionay", pyoneticionay, MSqlDbType.Boolean); cmd.Parameters.Add("aktif", paktif, MSqlDbType.Boolean); rvCount = MConvert.NullToInt(cmd.ExecuteScalar()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvCount); }
public static Doviz GetDoviz(int pID) { Doviz rvDoviz = new Doviz(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select top 1 * from Doviz where ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvDoviz = new Doviz(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Cinsi"]), MConvert.NullToFloat(IDR["Kuru"]), MConvert.NullToDateTime(IDR["Tarih"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvDoviz); }
///<summary> /// Reklam Data PrimaryKey ///</summary> public static Reklam GetReklam(int pID) { Reklam rvReklam = new Reklam(); using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Reklam WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvReklam = new Reklam(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["BannerName"]), MConvert.NullToString(IDR["ImageUrl"]), MConvert.NullToString(IDR["NavigateUrl"]), MConvert.NullToString(IDR["AlternateText"]), MConvert.NullToString(IDR["Keyword"]), MConvert.NullToInt(IDR["Impressions"]), MConvert.NullToInt(IDR["Width"]), MConvert.NullToInt(IDR["Height"]), MConvert.NullToBool(IDR["IsActive"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvReklam); }
public static Stok GetStok(int pID) { Stok rvStok = new Stok(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select top 1 * from Stok where ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvStok = new Stok(MConvert.NullToInt(IDR["ID"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToInt(IDR["UrunID"]), MConvert.NullToInt(IDR["FirmaID"]), MConvert.NullToFloat(IDR["Fiyat"]), MConvert.NullToFloat(IDR["KarOran"]), MConvert.NullToDateTime(IDR["EklenmeTarihi"]), MConvert.NullToDateTime(IDR["GuncellemeTarihi"]), FirmaMethods.GetFirma(MConvert.NullToInt(IDR["FirmaID"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvStok); }
public static ReklamCollection GetSelect(int width, int height) { ReklamCollection rvReklam = new ReklamCollection(); using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "SELECT TOP(10) * FROM Reklam WHERE Width=@Width AND Height=@Height AND IsActive=1", conneciton)) { cmd.Parameters.Add("Width", width, MSqlDbType.Int); cmd.Parameters.Add("Height", height, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvReklam.Add(new Reklam(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["BannerName"]), MConvert.NullToString(IDR["ImageUrl"]), MConvert.NullToString(IDR["NavigateUrl"]), MConvert.NullToString(IDR["AlternateText"]), MConvert.NullToString(IDR["Keyword"]), MConvert.NullToInt(IDR["Impressions"]), MConvert.NullToInt(IDR["Width"]), MConvert.NullToInt(IDR["Height"]), MConvert.NullToBool(IDR["IsActive"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvReklam); }
///<summary> /// CalismaAlani Data Insert ///</summary> public static int Insert(CalismaAlani p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "if (@Varsayilan=1) begin UPDATE CalismaAlani SET Varsayilan=0 WHERE HesapID=@HesapID AND Varsayilan=1 end INSERT INTO CalismaAlani (HesapID,Kurum,Telefon,Adres,Semt,Sehir,WebSitesi,Randevu,Varsayilan,Aktif) VALUES(@HesapID,@Kurum,@Telefon,@Adres,@Semt,@Sehir,@WebSitesi,@Randevu,@Varsayilan,@Aktif)", conneciton)) { cmd.Parameters.Add("HesapID", p.HesapID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("Kurum", System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(p.Kurum.ToLower().Trim()), MSqlDbType.NVarChar); cmd.Parameters.Add("Telefon", p.Telefon, MSqlDbType.VarChar); cmd.Parameters.Add("Adres", p.Adres, MSqlDbType.NVarChar); cmd.Parameters.Add("Semt", System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(p.Semt.ToLower().Trim()), MSqlDbType.NVarChar); cmd.Parameters.Add("Sehir", p.Sehir.ToUpper().Trim(), MSqlDbType.NVarChar); cmd.Parameters.Add("WebSitesi", p.WebSitesi.Trim(), MSqlDbType.VarChar); cmd.Parameters.Add("Randevu", p.Randevu, MSqlDbType.Bit); cmd.Parameters.Add("Varsayilan", p.Varsayilan, MSqlDbType.Bit); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Reklam Data Insert ///</summary> public static int Insert(string pBannerName, string pImageUrl, string pNavigateUrl, string pAlternateText, string pKeyword, int pImpressions, int pWidth, int pHeight, bool pIsActive) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "INSERT INTO Reklam (BannerName,ImageUrl,NavigateUrl,AlternateText,Keyword,Impressions,Width,Height,IsActive) VALUES(@BannerName,@ImageUrl,@NavigateUrl,@AlternateText,@Keyword,@Impressions,@Width,@Height,@IsActive)", conneciton)) { cmd.Parameters.Add("BannerName", pBannerName, MSqlDbType.NVarChar); cmd.Parameters.Add("ImageUrl", pImageUrl, MSqlDbType.VarChar); cmd.Parameters.Add("NavigateUrl", pNavigateUrl, MSqlDbType.VarChar); cmd.Parameters.Add("AlternateText", pAlternateText, MSqlDbType.NVarChar); cmd.Parameters.Add("Keyword", pKeyword, MSqlDbType.NVarChar); cmd.Parameters.Add("Impressions", pImpressions, MSqlDbType.Int); cmd.Parameters.Add("Width", pWidth, MSqlDbType.Int); cmd.Parameters.Add("Height", pHeight, MSqlDbType.Int); cmd.Parameters.Add("IsActive", pIsActive, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Yorum Data Insert ///</summary> public static int Insert(Yorum p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "INSERT INTO Yorum (IP,ModulID,IcerikID,Adi,Mail,Icerik,KayitTarihi,YoneticiOnay,Aktif) VALUES(@IP,@ModulID,@IcerikID,@Adi,@Mail,@Icerik,@KayitTarihi,@YoneticiOnay,@Aktif)", conneciton)) { cmd.Parameters.Add("IP", p.IP, MSqlDbType.VarChar); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", p.IcerikID, MSqlDbType.VarChar); cmd.Parameters.Add("Adi", p.Adi, MSqlDbType.NVarChar); cmd.Parameters.Add("Mail", p.Mail, MSqlDbType.VarChar); cmd.Parameters.Add("Icerik", p.Icerik, MSqlDbType.NVarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("YoneticiOnay", p.YoneticiOnay, MSqlDbType.Bit); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Reklam Data Update ///</summary> public static int Update(Reklam p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "UPDATE Reklam SET BannerName=@BannerName,ImageUrl=@ImageUrl,NavigateUrl=@NavigateUrl,AlternateText=@AlternateText,Keyword=@Keyword,Impressions=@Impressions,Width=@Width,Height=@Height,IsActive=@IsActive WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.Int); cmd.Parameters.Add("BannerName", p.BannerName, MSqlDbType.NVarChar); cmd.Parameters.Add("ImageUrl", p.ImageUrl, MSqlDbType.VarChar); cmd.Parameters.Add("NavigateUrl", p.NavigateUrl, MSqlDbType.VarChar); cmd.Parameters.Add("AlternateText", p.AlternateText, MSqlDbType.NVarChar); cmd.Parameters.Add("Keyword", p.Keyword, MSqlDbType.NVarChar); cmd.Parameters.Add("Impressions", p.Impressions, MSqlDbType.Int); cmd.Parameters.Add("Width", p.Width, MSqlDbType.Int); cmd.Parameters.Add("Height", p.Height, MSqlDbType.Int); cmd.Parameters.Add("IsActive", p.IsActive, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Yorum Data Delete ///</summary> public static int Delete(Yorum p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "DELETE FROM Yorum WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.UniqueIdentifier); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static int Update(Kategori p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.StoredProcedure, "Kategori_Update", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.VarChar); cmd.Parameters.Add("ParentID", p.ParentID, MSqlDbType.VarChar); cmd.Parameters.Add("ModulID", p.ModulID, MSqlDbType.VarChar); cmd.Parameters.Add("Adi", p.Adi, MSqlDbType.NVarChar); cmd.Parameters.Add("Dil", p.Dil, MSqlDbType.VarChar); cmd.Parameters.Add("Sira", p.Sira, MSqlDbType.TinyInt); cmd.Parameters.Add("Tab", p.Tab, MSqlDbType.Bit); cmd.Parameters.Add("Menu", p.Menu, MSqlDbType.Bit); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static KategoriCollection GetSelect() { KategoriCollection rvKategori = new KategoriCollection(); using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select * from Kategori order by Adi asc", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori.Add(new Kategori(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToString(IDR["Adi"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
///<summary> /// Mesaj Data Count ///</summary> public static int Count(byte pdurum, bool pyoneticionay) { int rvCount = 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, "select count(id) as totalcount from mesaj where durum=?durum and yoneticionay=?yoneticionay", conneciton)) { cmd.Parameters.Add("durum", pdurum, MSqlDbType.Byte); cmd.Parameters.Add("yoneticionay", pyoneticionay, MSqlDbType.Boolean); rvCount = MConvert.NullToInt(cmd.ExecuteScalar()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvCount); }
///<summary> /// Makale Data Count ///</summary> public static int Count(bool pyoneticionay) { 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, "select count(*) as totalcount from makale where yoneticionay=?yoneticionay", conneciton)) { cmd.Parameters.Add("yoneticionay", pyoneticionay, MSqlDbType.Boolean); rowsAffected = MConvert.NullToInt(cmd.ExecuteScalar()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<summary> /// Sayfa Data Update ///</summary> public static int Update(Sayfa p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { 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,Tipi=@Tipi,Aktif=@Aktif WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", p.ID, MSqlDbType.SmallInt); cmd.Parameters.Add("HesapID", p.HesapID, MSqlDbType.UniqueIdentifier); cmd.Parameters.Add("Baslik", p.Baslik, MSqlDbType.NVarChar); cmd.Parameters.Add("Icerik", p.Icerik, MSqlDbType.NVarChar); cmd.Parameters.Add("Dil", p.Dil, MSqlDbType.VarChar); cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime); cmd.Parameters.Add("Tipi", p.Tipi, MSqlDbType.TinyInt); cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit); rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery()); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }