protected int Insert(BaseTable nesne, DbCommand dbComm, DbTransaction dbTransaction, Database db) { //YetkiKullanici ui = (YetkiKullanici)HttpContext.Current.Session["YetkiKullanici"]; //if (ui == null) //{ // ui = new YetkiKullanici(); // ui.Tckimlikno = "Everyone"; // ui.Ip = HttpContext.Current.Request.UserHostAddress; //} int sonuc = 0; string geriDeger = ""; if (dbTransaction == null) geriDeger = db.ExecuteScalar(dbComm).ToString(); else geriDeger = db.ExecuteScalar(dbComm, dbTransaction).ToString(); //if (ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") != null && // ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") == "E") //{ // try // { // int.TryParse(geriDeger, out sonuc); // GenDbLog log = new GenDbLog(); // log.Tckimlikno = ui.Tckimlikno; // log.KullaniciIp = ui.Ip; // log.Tablo = nesne.GetName(); // log.KayitId = sonuc; // log.Kayit = nesne.ToString(); // log.Tarih = DateTime.Now; // log.YapilanIslem = "I"; // InsertLog(log, dbTransaction, db); // } // catch (Exception ex) { } //} bool snc = int.TryParse(geriDeger, out sonuc); return sonuc; }
protected int Delete(BaseTable nesne, DbCommand dbComm, DbTransaction dbTransaction, Database db) { //YetkiKullanici ui = (YetkiKullanici)HttpContext.Current.Session["YetkiKullanici"]; //if (ui == null) //{ // ui = new YetkiKullanici(); // ui.Tckimlikno = "Everyone"; // ui.Ip = HttpContext.Current.Request.UserHostAddress; //} int sonuc = -1; //if (dbTransaction == null) sonuc = int.Parse(db.ExecuteNonQuery(dbComm).ToString()); //else sonuc = int.Parse(db.ExecuteNonQuery(dbComm, dbTransaction).ToString()); //if (ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") != null && // ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") == "E" && sonuc > -1) //{ // try // { // GenDbLog log = new GenDbLog(); // log.Tckimlikno = ui.Tckimlikno; // log.KullaniciIp = ui.Ip; // log.Tablo = nesne.GetName(); // log.KayitId = (int)nesne.PrimaryKey; // log.Kayit = "SİLİNDİ"; // log.Tarih = DateTime.Now; // log.YapilanIslem = "D"; // InsertLog(log, dbTransaction, db); // } // catch (Exception ex) { } //} return sonuc; }