Notes

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace yemek.com_1072.App_Code
{
public class vtIslemleri
{
string server = "WEB1-SERVER2\SQLEXPRESS";
string db = "1072_yemek";
string serverKadi = "sa";
string serverSifre = "12345678";
public SqlConnection baglan()
{
SqlConnection baglanti = new SqlConnection();
baglanti.ConnectionString = "server=" + server + "; database=" + db + "; user id=" + serverKadi + "; password=" + serverSifre+"";
if (baglanti.State==ConnectionState.Closed)
{
baglanti.Open();
}
return baglanti;
}
public int UyeEkle(string email, string kadi,string sifre)
{
SqlConnection baglanti = baglan();
SqlCommand ekle = new SqlCommand("insert into tblUye values(@kadi,@email,@sifre)",baglanti);
ekle.Parameters.AddWithValue("@kadi", kadi);
ekle.Parameters.AddWithValue("@email", email);
ekle.Parameters.AddWithValue("@sifre", sifre);
int sonuc = ekle.ExecuteNonQuery();
baglanti.Close();
return sonuc;
}
public int uyeKaydet(string email,string kadi,string sifre)
{
SqlConnection baglanti = baglan();
SqlCommand uyeEkle = new SqlCommand("insert into tblUye values (@email,@kadi,@sifre)", baglanti);
uyeEkle.Parameters.AddWithValue("@email", email);
uyeEkle.Parameters.AddWithValue("@kadi", kadi);
uyeEkle.Parameters.AddWithValue("@sifre", sifre);
int sonuc = uyeEkle.ExecuteNonQuery();
baglanti.Close();
return sonuc;
}
public bool uyeKontrol(string kadi,string sifre)
{
SqlConnection baglanti = baglan();
SqlDataAdapter dapt = new SqlDataAdapter("select * from tblUye where kadi='" + kadi + "' and sifre='" + sifre +"'",baglanti);
DataTable dt = new DataTable();
dapt.Fill(dt);
if (dt.Rows.Count>0)
{
return true;

}
else
{
return false;
}
}
}
}