:: Md5 Encryption C#.net ::

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

/// <summary>

/// Summary description for db

/// </summary>

public class db

{

public static string connectionstring = @”Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True”;

public db()

{

//

// TODO: Add constructor logic here

//

}

//function login for string

public bool login(string user, string pass)

{

//connection to the database

SqlConnection con = new SqlConnection(connectionstring);

//sql query to retreive data

string sql = “select password from student where student_id =  @user”;

//sql paramterize to secure the sql injection attack

SqlParameter pl = new SqlParameter(“@user”, user);

//sql command

SqlCommand cmd = new SqlCommand(sql, con);

cmd.Parameters.Add(pl);

//open the connection

con.Open();

//reader to excute the sql query of sql command

SqlDataReader rdr = cmd.ExecuteReader();

bool log = false;

//check if the reader can read

if (rdr.Read())

{

//conver the password to md5 hash encryption

string password = GetMD5Hash(pass);

//check if the password equal the pass in database

if (rdr[0].ToString() == password)

{

log = true;

}

}

//close the reader

rdr.Close();

//close the connection

con.Close();

return log;

}

//md5 function ecryption

public string GetMD5Hash(string input)

{

System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();

byte[] bs = System.Text.Encoding.UTF8.GetBytes(input);

bs = x.ComputeHash(bs);

System.Text.StringBuilder s = new System.Text.StringBuilder();

foreach (byte b in bs)

{

s.Append(b.ToString(“x2″).ToLower());

}

string password = s.ToString();

return password;

}

//admin login function

public bool login_admin(string user, string pass)

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select password from Admin where username = @user”;

SqlParameter pl = new SqlParameter(“@user”, user);

SqlCommand cmd = new SqlCommand(sql, con);

cmd.Parameters.Add(pl);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

bool log = false;

if (rdr.Read())

{

string password = GetMD5Hash(pass);

if (rdr[0].ToString() == password)

{

log = true;

}

}

rdr.Close();

con.Close();

return log;

}

//get the vote of each nomine to view it in result

public string get_voting(string id)

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select vote from nomeni where Student_ID= ‘”+ id + “‘ “;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

string vote = “”;

if (rdr.Read())

{

vote = rdr[0].ToString();

}

rdr.Close();

con.Close();

return vote;

}

//get the statiscits data

public string [] set_election_year()

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select count(*) , sum(vote) from student”;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

string vote = “”;

string unvote = “”;

if (rdr.Read())

{

unvote = rdr[0].ToString();

vote = rdr[1].ToString();

}

rdr.Close();

con.Close();

string[] x = new string[2];

x[0] = unvote;

x[1] = vote;

return x;

}

//check if student id already exist in adduser page

public bool check_user_exist(string user)

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select student_id from student where student_id = ‘” + user + “‘”;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

bool log = false;

if (rdr.Read())

{

if (rdr[0].ToString() == user)

{

log = true;

}

}

rdr.Close();

con.Close();

return log;

}

//get nomine data to view it on vote page

public SqlDataReader  get_nomine(string user)

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select * from nomeni where student_id = ‘” + user + “‘”;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

bool log = false;

rdr.Read();

return rdr;

}

//get date time data

public SqlDataReader get_year()

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select * from timedate”;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

rdr.Read();

return rdr;

}

//check if student already vote

public string checkvoting(string user)

{

SqlConnection con = new SqlConnection(connectionstring);

string sql = “select vote from student where student_id = ‘” + user + “‘”;

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

string vote = “”;

if (rdr.Read())

{

vote = rdr[0].ToString();

}

rdr.Close();

con.Close();

return vote;

}

public void voting(string std_id)

{

}

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

/// <summary>

/// Summary description for db

/// </summary>

public class db

{

public static string connectionstring = @”Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True”;

public db()

{

//

:: Imagine Cup Interoperability Award Winner ::

Interoperability Award:

Country/Region	Finalist Team Name
Jordan	ECRAM
Poland	fteams
Brazil	Proativa Team

my Ecram Team had won in the Interoperability Award World Wide Competition on Microsofot Imagine Cup

Can’t Wait to go To Egypt