Yayýnladýðým tüm makaleler

function kontrol() {
////////////////////////////////////////////////////////
// Kodlama          : Bilal SERT
// Amaç             : Yeni kayit icin form alanlarinin 
//                    bos birakilmasini engellemek
// Tarih|Saat       : 30.05.2020 | 15:00
// G|Ç              : yok | yok
////////////////////////////////////////////////////////
var bilgi = "< span >";
 
if (document.getElementById("txtAdi").value == "") {
	bilgi  + =  "Kullanýcý adý boþ býrakýlamaz";
	bilgi  + =  "< / span >";
	document.getElementById("uyari").innerHTML = bilgi;
	return (false);
} else if (document.getElementById("txtSifre").value == "") {
	bilgi  + =  "Þifre alaný boþ býrakýlamaz";
	bilgi  + =  "< / span >";
	document.getElementById("uyari").innerHTML = bilgi;
	return (false);
}
return (true);
} //end of kontrol
 
function islemYap(islemID) {
////////////////////////////////////////////////////////
// Kodlama          : Bilal SERT
// Amaç             : Formu sunucuya gondermek
// Tarih|Saat       : 30.05.2020 | 14:42
// G|Ç              : dugmeler (giris ve iptal)| yok
////////////////////////////////////////////////////////
if (islemID == 1) {
	//giris
	if (kontrol() == true) document.getElementById("form1").submit();
} else if (islemID == 2) {
	//iptal
	document.getElementById("txtAdi").value = "";
	document.getElementById("txtSifre").value = "";
}
} //end of islemYap

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
 
public partial class sinavGiris : System.Web.UI.Page
{
OleDbConnection conn = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
OleDbDataReader dr;
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
string adi = "", sifre = "";
protected void Page_Load(object sender, EventArgs e)
{
//sayfa sunucuya geri gonderildiginde
if (Page.IsPostBack)
{
	adi = Request.Form["txtAdi"];
	sifre = Request.Form["txtSifre"];
	//uyari.InnerHtml = "Adi: " + adi + "
" + "Sifre: " + sifre;
	//kullanici var mi? Kontrol edelim
	if (kullaniciVarmi()) {
		//kullanici ilk defa sinava giris yapiyorsa sinav tablosunda 
		//kullanici icin bir bos bir kayit olusturuyoruz.
		if (!dahaOnceSinaviAlmismi()) sinavKayitBilgisiOlustur();
		//sonrasinda kullaniciyi sinav sayfasina yonlendiriyoruz.
		Response.Redirect("~/sinav.aspx");
	}
}
}//end of page_load
 
 
bool kullaniciVarmi()
{
///////////////////////////////////////////////////////////////
//Created By         : Bilal SERT
//Date /Time         : .../.../2020 /00:00
//Aim                : kullanici kayitli kullanici mi degil mi?
//I/O                : none
//Calls              : 
//Called by          : Page_Load()
///////////////////////////////////////////////////////////////
bool sonuc = false;
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("~/data.mdb");
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP  1 * FROM kullanicilar  WHERE kullanici='" + adi + "' AND sifre='" + sifre + "'"; 
try
{
	conn.Open();
	da.SelectCommand = cmd;
	da.Fill(ds, "kullanicilar");
	if (ds.Tables["kullanicilar"].Rows.Count != 0)
	{
		//kullanici bilgileri oturum bilgileri olarak okunuyor
		Session["kullanici"] = ds.Tables["kullanicilar"].Rows[0][1].ToString(); ;
		Session["kid"] = ds.Tables["kullanicilar"].Rows[0][0].ToString();
		//Response.Redirect("~/sinav.aspx");
		sonuc = true;
	}
	else uyari.InnerHtml = "Yanlýþ kullanýcý adý ya da þifre";
}
catch (Exception ex)
{
	uyari.InnerHtml = "Dikkat! Hata oluþtu< / span > (Modul-1: Veri getirme)
" + ex.Message.ToString();
}
finally
{
	if (conn.State == ConnectionState.Open)
	{
		conn.Close();
		conn.Dispose();
		ds.Clear();
		ds.Dispose();
		da.Dispose();
	}
}
return(sonuc);
}//end of kullaniciVarmi
 
bool dahaOnceSinaviAlmismi()
{
/////////////////////////////////////////////////////////////
//Created By         : Bilal SERT
//Date /Time         : .../.../2020 /00:00
//Aim                : kullanici testi ilk defa mý alýyor
//                     yoksa testi bir sebeple tamamlayamamis
//					   devam mi ediyor
//I/O                : none
//Calls              : 
//Called by          : Page_Load
/////////////////////////////////////////////////////////////
bool sonuc = false;
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("~/data.mdb");
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP  1 * FROM sinav  WHERE kuID=" + Session["kid"];
try
{
	conn.Open();
	da.SelectCommand = cmd;
	da.Fill(ds, "sinav");
	//daha once sinavi almis ama tamamlamamis
	if (ds.Tables["sinav"].Rows.Count != 0) sonuc = true;
}
catch (Exception ex)
{
	uyari.InnerHtml = "Dikkat! Hata oluþtu< / span > (Modul-2: Sinav kontrol modulu)
" + ex.Message.ToString();
}
finally
{
	if (conn.State == ConnectionState.Open)
	{
		conn.Close();
		conn.Dispose();
		ds.Clear();
		ds.Dispose();
		da.Dispose();
	}
}
return (sonuc);
}//end of dahaOnceSinaviAlmismi
 
void sinavKayitBilgisiOlustur()
{
///////////////////////////////////////////////////////////////////////////////
//Created By         : Bilal SERT
//Date /Time         : .../.../2020 /00:00
//Aim                : kullanici ilk defa testi aliyorsa
//                     sinav tablosunda kullaiciya ait yeni kayit olusturuluyor
//I/O                : none
//Calls              : 
//Called by          : Page_Load()
/////////////////////////////////////////////////////////////////////////////////
int result = 0;
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("~/data.mdb");
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@p1", Session["kid"]);
cmd.CommandText = "INSERT INTO sinav(kuID)VALUES(@p1)";
 
try
{
	conn.Open();
	result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
	uyari.InnerHtml = "Dikkat! Hata oluþtu< / span > (Modul-3: Kayit olusturma)
" + ex.Message.ToString();
}
finally
{
	if (conn.State == ConnectionState.Open)
	{
		conn.Close();
		conn.Dispose();
	}
}
}//end of sinavKayitBilgisiOlustur
 
}//end of class