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 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 KategoriCollection GetSelect() { KategoriCollection rvKategori = new KategoriCollection(); 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 kategori", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori.Add(new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
public static List <Kategori> GetMenu(string modulid) { List <Kategori> rvKategori = new List <Kategori>(); 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 kategori where modulid=?modulid and aktif=1 order by sira asc, adi asc", conneciton)) { cmd.Parameters.Add("modulid", modulid, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori.Add(new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
public static Dictionary <string, object> GetCustomList() { Dictionary <string, object> rvKategori = new Dictionary <string, object>(); 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 id,modulid,adi from kategori", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori.Add( MConvert.NullToString(IDR["modulid"]) + "-" + BAYMYO.UI.Commons.ClearInvalidCharacter(Core.ReplaceToLover(BAYMYO.UI.Converts.NullToString(IDR["adi"]))).Replace("---", "-").Replace("--", "-"), MConvert.NullToString(IDR["id"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
///<summary> /// Hesap Data PrimaryKey ///</summary> public static Hesap GetHesap(System.Guid pID) { Hesap rvHesap = new Hesap(); 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 Hesap WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.UniqueIdentifier); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvHesap = new Hesap(MConvert.NullToGuid(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 = ProfilMethods.GetProfil(rvHesap.ID); return(rvHesap); }
///<summary> /// Hesap Data Select ///</summary> public static HesapCollection GetSelect() { HesapCollection rvHesap = new HesapCollection(); 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 id,concat(adi,' ',soyadi) adi from hesap where aktivasyon=1 and aktif=1 and tipi in(1,2,3,5)", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvHesap.Add(new Hesap { ID = MConvert.NullToGuidString(IDR["id"]), Adi = MConvert.NullToString(IDR["adi"]) }); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvHesap); }
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> /// Manset Data Select ///</summary> public static List <MansetJSON> GetJSON(int top) { List <MansetJSON> rvManset = new List <MansetJSON>(); 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(" + top + ") * FROM Manset WHERE Aktif=1 ORDER BY KayitTarihi DESC", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvManset.Add(new MansetJSON(MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["IcerikID"]), MConvert.NullToString(IDR["ResimKucuk"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["Baslik"]), MConvert.NullToString(IDR["Aciklama"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvManset); }
public static Manset GetManset(string pModulID, string pIcerikID) { Manset rvManset = new Manset(); 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(1) * FROM Manset WHERE ModulID=@ModulID AND IcerikID=@IcerikID", conneciton)) { cmd.Parameters.Add("ModulID", pModulID, MSqlDbType.VarChar); cmd.Parameters.Add("IcerikID", pIcerikID, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvManset = new Manset(MConvert.NullToGuid(IDR["ID"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["IcerikID"]), MConvert.NullToString(IDR["ResimKucuk"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["Baslik"]), MConvert.NullToString(IDR["Aciklama"]), MConvert.NullToDateTime(IDR["KayitTarihi"]), MConvert.NullToBool(IDR["Aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvManset); }
public static TeklifCollection GetSelect() { TeklifCollection rvTeklif = new TeklifCollection(); 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 Teklif", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvTeklif.Add(new Teklif(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToString(IDR["GemiAdi"]), MConvert.NullToString(IDR["BaglamaLimani"]), MConvert.NullToString(IDR["Acenta"]), MConvert.NullToString(IDR["Manager"]), MConvert.NullToDateTime(IDR["Tarih"]), MConvert.NullToFloat(IDR["Kur1"]), MConvert.NullToFloat(IDR["Kur2"]), MConvert.NullToString(IDR["ParaBirimi"]), MConvert.NullToByte(IDR["Kdv"]), MConvert.NullToFloat(IDR["TasimaUcreti"]), MConvert.NullToFloat(IDR["Iskonto"]), MConvert.NullToString(IDR["Hazirlayan"]), MConvert.NullToString(IDR["OdemeSekli"]), MConvert.NullToString(IDR["TeslimSuresi"]), MConvert.NullToString(IDR["Aciklama"]), MConvert.NullToDateTime(IDR["GuncellemeTarihi"]), MConvert.NullToByte(IDR["Durum"]), MConvert.NullToString(IDR["DurumNotu"]), MConvert.NullToString(IDR["TasimaUcretiNotu"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvTeklif); }
public static List <Firma> GetSelect() { List <Firma> rvFirma = new List <Firma>(); 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 Firma", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvFirma.Add(new Firma(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Yetkili"]), MConvert.NullToString(IDR["Telefon"]), MConvert.NullToString(IDR["Mail"]), MConvert.NullToString(IDR["Adres"]), MConvert.NullToByte(IDR["Period"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvFirma); }
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); }
public static Profil GetProfil(string pUrl) { Profil rvProfil = new Profil(); 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(1) * FROM Profil WHERE Url=@Url", conneciton)) { cmd.Parameters.Add("Url", pUrl, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvProfil = new Profil(MConvert.NullToGuid(IDR["ID"]), MConvert.NullToString(IDR["Url"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["Unvan"]), MConvert.NullToString(IDR["UzmanlikAlaniID"]), MConvert.NullToString(IDR["TCKimlikNo"]), MConvert.NullToString(IDR["DiplomaNo"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Mail"]), MConvert.NullToString(IDR["Hakkimda"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvProfil); }
///<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); }
///<summary> /// Sehir Data PrimaryKey ///</summary> public static Sehir GetSehir(byte pid) { Sehir rvSehir = new Sehir(); 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 sehir where id=?id limit 1", conneciton)) { cmd.Parameters.Add("id", pid, MSqlDbType.SmallInt); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvSehir = new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvSehir); }
///<summary> /// Yorum Data PrimaryKey ///</summary> public static Yorum GetYorum(System.Guid pID) { Yorum rvYorum = new Yorum(); 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 Yorum WHERE ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.UniqueIdentifier); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvYorum = new Yorum(MConvert.NullToGuid(IDR["ID"]), MConvert.NullToString(IDR["IP"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["IcerikID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Mail"]), MConvert.NullToString(IDR["Icerik"]), MConvert.NullToDateTime(IDR["KayitTarihi"]), MConvert.NullToBool(IDR["YoneticiOnay"]), MConvert.NullToBool(IDR["Aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvYorum); }
public static Kategori GetKategori(string modulID, string id) { Kategori rvKategori = new Kategori(); 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(1) * FROM Kategori WHERE ModulID=@ModulID AND ID=@ID", conneciton)) { cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar); cmd.Parameters.Add("ID", id, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvKategori = new Kategori(MConvert.NullToString(IDR["ID"]), MConvert.NullToString(IDR["ParentID"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Dil"]), MConvert.NullToByte(IDR["Sira"]), MConvert.NullToBool(IDR["Tab"]), MConvert.NullToBool(IDR["Menu"]), MConvert.NullToBool(IDR["Aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvKategori); }
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> /// 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 Firma GetFirma(int pID) { Firma rvFirma = new Firma(); 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 Firma where ID=@ID", conneciton)) { cmd.Parameters.Add("ID", pID, MSqlDbType.Int); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvFirma = new Firma(MConvert.NullToInt(IDR["ID"]), MConvert.NullToString(IDR["Kod"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Yetkili"]), MConvert.NullToString(IDR["Telefon"]), MConvert.NullToString(IDR["Mail"]), MConvert.NullToString(IDR["Adres"]), MConvert.NullToByte(IDR["Period"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvFirma); }
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> /// Sehir Data Select ///</summary> public static SehirCollection GetSelect() { SehirCollection rvSehir = new SehirCollection(); 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 sehir order by adi asc", conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvSehir.Add(new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvSehir); }
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); }
public static List <HesapJSON> GetJSON(QueryType sorguTipi, int top) { List <HesapJSON> rvHesap = new List <HesapJSON>(); using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } string query = ""; switch (sorguTipi) { case QueryType.Date: query = "SELECT TOP(" + top + ") Profil.Url, Profil.ResimUrl, dbo.GetKategoriAdi('uzmanlik',Profil.UzmanlikAlaniID) AS UzmanlikAlani, (dbo.GetKategoriAdi('unvan',Profil.Unvan) +' '+ Hesap.Adi +' '+ Hesap.Soyadi) AS AdiSoyadi, Hesap.KayitTarihi FROM Hesap INNER JOIN Profil ON Hesap.ID = Profil.ID WHERE (Hesap.Aktivasyon = 1) AND (Hesap.Aktif = 1) AND (Hesap.Tipi = 3) AND (Profil.Unvan IS NOT NULL) ORDER BY Hesap.KayitTarihi DESC"; break; case QueryType.Populer: query = "SELECT * FROM (SELECT TOP(" + top + ") Profil.Url, Profil.ResimUrl, dbo.GetKategoriAdi('uzmanlik',Profil.UzmanlikAlaniID) AS UzmanlikAlani, (dbo.GetKategoriAdi('unvan',Profil.Unvan) +' '+ Hesap.Adi +' '+ Hesap.Soyadi) AS AdiSoyadi, Hesap.KayitTarihi, dbo.GetGosterimOran('profil',Hesap.ID) AS Oran FROM Hesap INNER JOIN Profil ON Hesap.ID = Profil.ID WHERE (Hesap.Aktivasyon = 1) AND (Hesap.Aktif = 1) AND (Hesap.Tipi = 3) AND (Profil.Unvan IS NOT NULL)) HesapListe ORDER BY Oran DESC"; break; } using (MCommand cmd = new MCommand(CommandType.Text, query, conneciton)) { using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvHesap.Add(new HesapJSON(MConvert.NullToString(IDR["Url"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["UzmanlikAlani"]), MConvert.NullToString(IDR["AdiSoyadi"]), MConvert.NullToDateTime(IDR["KayitTarihi"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvHesap); }
public static int Update(TeklifDetay p) { int rowsAffected = 0; 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, "Update TeklifDetay SET FirmaAdi=@FirmaAdi,UrunAdi=@UrunAdi,BirimFiyati=@BirimFiyati,KarOrani=@KarOrani,Miktar=@Miktar,Birim=@Birim,Adet=@Adet,Kdv=@Kdv WHERE ID=@ID", conneciton)) { if (p.FirmaID > 0) { cmd.Parameters.Add("FirmaAdi", DBNull.Value, MSqlDbType.NVarChar); } else { cmd.Parameters.Add("FirmaAdi", MConvert.NullToString(p.FirmaAdi).ToUpper(), MSqlDbType.NVarChar); } cmd.Parameters.Add("UrunAdi", p.UrunAdi.Trim(), MSqlDbType.NVarChar); cmd.Parameters.Add("BirimFiyati", p.BirimFiyati, MSqlDbType.Float); cmd.Parameters.Add("KarOrani", p.KarOrani, MSqlDbType.Float); cmd.Parameters.Add("Miktar", p.Miktar, MSqlDbType.Float); cmd.Parameters.Add("Birim", p.Birim, MSqlDbType.VarChar); cmd.Parameters.Add("Adet", p.Adet, MSqlDbType.Float); cmd.Parameters.Add("Kdv", p.Kdv, MSqlDbType.Float); cmd.Parameters.Add("ID", p.ID, MSqlDbType.Int); rowsAffected = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
/// <summary> /// Hesap Getir /// </summary> public static Hesap GetHesap(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { Hesap rvHesap = new Hesap(); using (MConnection conneciton = new MConnection(MClientProvider.MSSQL)) { 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()) { rvHesap = new Hesap(MConvert.NullToGuid(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 = ProfilMethods.GetProfil(rvHesap.ID); return(rvHesap); }
public static Doviz GetDoviz(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { 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(cmdType, sqlQuery, conneciton)) { if (parameters != null) { foreach (MParameter item in parameters) { cmd.Parameters.Add(item); } } 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 Liste Getir /// </summary> public static ReklamCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { 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(cmdType, sqlQuery, conneciton)) { if (parameters != null) { foreach (MParameter item in parameters) { cmd.Parameters.Add(item); } } 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> /// Sehir Liste Getir /// </summary> public static SehirCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { SehirCollection rvSehir = new SehirCollection(); 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()) { rvSehir.Add(new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"]))); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvSehir); }