public NwmAyarlar GetNwmAyarlar(int id)
{
var resultEntity = new NwmAyarlar();
String commandText = @"SELECT * FROM db_kodyazan.ayarlar WHERE id=@id";
var parameterList = new List <MySqlParameter>();
parameterList.Add(new MySqlParameter("@id", id));
DataSet dataSet = MySqlHelper.ExecuteDataset(ConnectionString, commandText, parameterList.ToArray());
resultEntity = dataSet.Tables[0].ToList <NwmAyarlar>().FirstOrDefault();
return(resultEntity);
}
public int SaveOrUpdateNwmAyarlar(NwmAyarlar item)
{
String commandText = @"CALL SaveOrUpdateNwmAyarlar(@id,
@siteBasligi,
@anahtarKelimeler,
@google,
@siteAciklamasi,
@firmaAdi,@telefon,@telefon2,
@faks,@eposta,@adres,@yetkili,
@username,@password,@logKayit,
@durum,@siteUrl,@panelUrl,@smtpSunucu,
@smtpPort,@smtpKullanici,@smtpSifre,
@smtpAd,@smtpMetod,@smtpDurum,
@facebook,@twitter,@gplus,@foursquare,@map)";
var parameterList = new List <MySqlParameter>();
parameterList.Add(new MySqlParameter("@id", item.id));
parameterList.Add(new MySqlParameter("@siteBasligi", item.siteBasligi.ToStr()));
parameterList.Add(new MySqlParameter("@anahtarKelimeler", item.anahtarKelimeler.ToStr()));
parameterList.Add(new MySqlParameter("@google", item.google.ToStr()));
parameterList.Add(new MySqlParameter("@siteAciklamasi", item.siteAciklamasi.ToStr()));
parameterList.Add(new MySqlParameter("@firmaAdi", item.firmaAdi.ToStr()));
parameterList.Add(new MySqlParameter("@telefon", item.telefon.ToStr()));
parameterList.Add(new MySqlParameter("@telefon2", item.telefon2.ToStr()));
parameterList.Add(new MySqlParameter("@faks", item.faks.ToStr()));
parameterList.Add(new MySqlParameter("@eposta", item.eposta.ToStr()));
parameterList.Add(new MySqlParameter("@adres", item.adres.ToStr()));
parameterList.Add(new MySqlParameter("@yetkili", item.yetkili.ToStr()));
parameterList.Add(new MySqlParameter("@username", item.username.ToStr()));
parameterList.Add(new MySqlParameter("@password", item.password.ToStr()));
parameterList.Add(new MySqlParameter("@logKayit", item.logKayit));
parameterList.Add(new MySqlParameter("@durum", item.durum));
parameterList.Add(new MySqlParameter("@siteUrl", item.siteUrl.ToStr()));
parameterList.Add(new MySqlParameter("@panelUrl", item.panelUrl.ToStr()));
parameterList.Add(new MySqlParameter("@smtpSunucu", item.smtpSunucu.ToStr()));
parameterList.Add(new MySqlParameter("@smtpPort", item.smtpPort.ToStr()));
parameterList.Add(new MySqlParameter("@smtpKullanici", item.smtpKullanici.ToStr()));
parameterList.Add(new MySqlParameter("@smtpSifre", item.smtpSifre.ToStr()));
parameterList.Add(new MySqlParameter("@smtpAd", item.smtpAd.ToStr()));
parameterList.Add(new MySqlParameter("@smtpMetod", item.smtpMetod.ToStr()));
parameterList.Add(new MySqlParameter("@smtpDurum", item.smtpDurum.ToStr()));
parameterList.Add(new MySqlParameter("@facebook", item.facebook.ToStr()));
parameterList.Add(new MySqlParameter("@twitter", item.twitter.ToStr()));
parameterList.Add(new MySqlParameter("@gplus", item.gplus.ToStr()));
parameterList.Add(new MySqlParameter("@foursquare", item.foursquare.ToStr()));
parameterList.Add(new MySqlParameter("@map", item.map.ToStr()));
int id = MySqlHelper.ExecuteScalar(ConnectionString, commandText, parameterList.ToArray()).ToInt();
return(id);
}
public void Index222()
{
var pp = new TestRepository();
for (int i = 0; i < 10000; i++)
{
pp.SaveOrUpdateNwmTest(new NwmTest()
{
Name = (i + 100) + Guid.NewGuid().ToStr()
});
}
var item = new NwmAyarlar();
item.id = 1;
item.siteBasligi = "siteBasligi";
item.anahtarKelimeler = "anahtarKelimeler";
item.google = "google 22";
item.siteAciklamasi = "siteAciklamasi";
item.firmaAdi = "firmaAdi";
item.telefon = "telefon";
item.telefon2 = "";
item.faks = "";
item.eposta = "";
item.adres = "";
item.yetkili = "";
item.username = "";
item.password = "";
item.logKayit = 1;
item.durum = 10;
item.siteUrl = "";
item.panelUrl = "";
item.smtpSunucu = "";
item.smtpPort = "";
item.smtpKullanici = "";
item.smtpSifre = "";
item.smtpAd = "";
item.smtpMetod = "";
item.smtpDurum = "";
item.facebook = "";
item.twitter = "";
item.gplus = "";
item.foursquare = "";
item.map = "";
// var result1= pp.SaveOrUpdateNwmAyarlar(item);
// var ayarlarItem = pp.GetNwmAyarlar(result1);
// Console.WriteLine(ayarlarItem.google);
}
