//Yönetici Girişi
public int sistemkontrol(EntitiesKull K)
{
try
{
cmd = new SqlCommand("select count(*)from Kullanicilar where kullaniciadi=(select kullaniciadi from yetkiler where kullaniciadi=@kullaniciadi and kullaniciyetki='yonetici')and kullaniciadi=@kullaniciadi and sifre=@sifre", conn);
cmd.Parameters.Add("@kullaniciadi", SqlDbType.NVarChar).Value = K.kullaniciadi;
cmd.Parameters.Add("@sifre", SqlDbType.NVarChar).Value = K.sifre;
baglantiayari();
returnvalues = (int)cmd.ExecuteScalar();
Guid gelen = K.ID;
}
catch (Exception ex)
{
}
finally
{
baglantiayari();
}
return(returnvalues);
}
public int sifredegistir(EntitiesKull K)
{
try
{
cmd = new SqlCommand(@"update Kullanicilar set sifre=@sifre where ID=@ID", conn);
cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = K.ID;
cmd.Parameters.Add("@sifre", SqlDbType.NVarChar).Value = K.sifre;
baglantiayari();
returnvalues = cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
baglantiayari();
}
return(returnvalues);
}
public int kytduzenle(EntitiesKull K)
{
try
{
cmd = new SqlCommand(@"update Kullanicilar set kullaniciadi=@kullaniciadi,sifre=@sifre,adi=@adi,soyadi=@soyadi,eposta=@eposta where ID=@ID", conn);
cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = K.ID;
cmd.Parameters.Add("@kullaniciadi", SqlDbType.NVarChar).Value = K.kullaniciadi;
cmd.Parameters.Add("@sifre", SqlDbType.NVarChar).Value = K.sifre;
cmd.Parameters.Add("@adi", SqlDbType.NVarChar).Value = K.adi;
cmd.Parameters.Add("@soyadi", SqlDbType.NVarChar).Value = K.soyadi;
cmd.Parameters.Add("@eposta", SqlDbType.NVarChar).Value = K.eposta;
baglantiayari();
returnvalues = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
baglantiayari();
}
return(returnvalues);
}
