private void Listele() { cmbIletisimID.DataSource = Operations <Iletisimler> .SelectAll(); cmbIletisimID.DisplayMember = "Adresi"; cmbIletisimID.ValueMember = AditionTools <Iletisimler> .PKGetir(); dataGridView1.DataSource = Operations <Okuyucular> .SelectAll(); PropertyInfo[] props = typeof(Okuyucular).GetProperties(); if (cmbArama.Items.Count == 0) { foreach (PropertyInfo pi in props) { if (pi.Name.Contains("ID") == false && pi.Name.Contains("Cinsiyyet") == false && pi.Name.Contains("Tar") == false) { cmbArama.Items.Add(pi.Name); } } } foreach (DataGridViewColumn dgc in dataGridView1.Columns) { if (dgc.DataPropertyName.Contains("ID") || dgc.DataPropertyName.Contains("Sonlandi")) { dgc.Visible = false; } } string id = IstifadeciGirisi.Id; string rol = IstifadeciGirisi.Rol.Trim().ToUpper(); lblIsci.Text = "Islem Yapiyorsunuz " + User.AdGetir(id); }
public bool Ekle(ET entity) { string kolonismi = "insert " + typeof(ET).Name + "("; string deger = ""; string pk = AditionTools <ET> .PKGetir(); SqlCommand cmd = new SqlCommand(); PropertyInfo[] props = typeof(ET).GetProperties(); foreach (PropertyInfo pi in props) { if (pi.Name == pk) { continue; } if (pi.GetValue(entity) != null) { kolonismi += pi.Name + ","; deger += "@" + pi.Name + ","; cmd.Parameters.AddWithValue(string.Format("@{0}", pi.Name), pi.GetValue(entity)); } } string kolonlar = kolonismi.Remove(kolonismi.Length - 1, 1); string degerler = deger.Remove(deger.Length - 1, 1); string sorgu = kolonlar + ")" + " values(" + degerler + ")"; cmd.CommandText = sorgu; cmd.Connection = Tools.Connection.Baglanti; return(Execute.ExecuteNonQuery(cmd)); }
public bool Guncelle(ET entity, int id) { string sorgu = "update " + typeof(ET).Name + " set "; SqlCommand cmd = new SqlCommand(); string pk = AditionTools <ET> .PKGetir(); PropertyInfo[] props = typeof(ET).GetProperties(); foreach (PropertyInfo pi in props) { if (pi.Name == pk || pi.Name.Contains("Tarih") == true) { continue; } if (pi.GetValue(entity) != null) { sorgu += pi.Name + "=" + string.Format("@{0}", pi.Name) + ","; cmd.Parameters.AddWithValue(string.Format("@{0}", pi.Name), pi.GetValue(entity)); } } string upsorgu = sorgu.Remove(sorgu.Length - 1, 1); upsorgu += " where " + pk + "=" + id; cmd.CommandText = upsorgu; cmd.Connection = Connection.Baglanti; return(Execute.ExecuteNonQuery(cmd)); }
public bool Sil(int id) { string pk = AditionTools <ET> .PKGetir(); string sorgu = "delete from " + typeof(ET).Name + " where " + pk + "=" + id; SqlCommand cmd = new SqlCommand(sorgu, Connection.Baglanti); return(Execute.ExecuteNonQuery(cmd)); }
public static ET EntityDoldur(ET entity, params object[] obj) { PropertyInfo[] props = typeof(ET).GetProperties(); int i = 0; foreach (PropertyInfo pi in props) { if (i < obj.Length) { if (pi.Name == AditionTools <ET> .PKGetir()) { continue; } string tip = pi.PropertyType.Name; switch (tip) { case "String": pi.SetValue(entity, obj[i].ToString()); break; case "Int32": pi.SetValue(entity, Convert.ToInt32(obj[i])); break; case "Decimal": pi.SetValue(entity, Convert.ToDecimal(obj[i])); break; case "Int16": pi.SetValue(entity, Convert.ToInt16(obj[i])); break; case "Double": pi.SetValue(entity, Convert.ToDouble(obj[i])); break; case "DateTime": pi.SetValue(entity, Convert.ToDateTime(obj[i])); break; case "Boolean": pi.SetValue(entity, Convert.ToBoolean(obj[i])); break; } i++; } } return(entity); }
private void Listele() { cmbKategoriID.DataSource = Operations <Kategoriler> .SelectAll(); cmbKategoriID.DisplayMember = "KategoriAdi"; cmbKategoriID.ValueMember = AditionTools <Kategoriler> .PKGetir(); cmbYazarID.DataSource = Operations <Yazarlar> .SelectAll(); cmbYazarID.DisplayMember = "YazarAdi"; cmbYazarID.ValueMember = AditionTools <Yazarlar> .PKGetir(); cmbFerdiAdTedarikciID.DataSource = Operations <FerdiTedarikci> .SelectAll(); cmbFerdiAdTedarikciID.DisplayMember = "Adi"; cmbFerdiAdTedarikciID.ValueMember = "TedarikciID"; cmbSirketTedarikciID.DataSource = Operations <SirketTedarikci> .SelectAll(); cmbSirketTedarikciID.DisplayMember = "SirketAdi"; cmbSirketTedarikciID.ValueMember = "TedarikciID"; lblIsci.Text = "Islem Yapiyorsunuz " + User.AdGetir(IstifadeciGirisi.Id) + " Gozlemleniyorsunuz..."; dataGridView1.DataSource = Operations <Kitablar> .SelectAll(); PropertyInfo[] props = typeof(Kitablar).GetProperties(); foreach (PropertyInfo pi in props) { string tipname = pi.Name; if ((tipname.Contains("ID") == false) && (tipname.Contains("Tarih") == false) && (tipname.Contains("Resim") == false) && (tipname.Contains("Sonlandi") == false)) { cmbArama.Items.Add(tipname); } } cmbArama.SelectedIndex = 1; string id = IstifadeciGirisi.Id; string rol = IstifadeciGirisi.Rol.Trim().ToUpper(); lblIsci.Text = "Islem Yapiyorsunuz " + User.AdGetir(id); }