/*///insert code/////*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class registration : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
    SqlConnection con=new SqlConnection (ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
       try{
           con.Open();
           String command="Insert into Userdatabase(First_name,Second_name,email,username,password,type) Values(@fname,@sname,@ename,@uname,@pname,@utype)";
           SqlCommand cmd =new SqlCommand(command,con);
           cmd.Parameters.AddWithValue("@fname",frstnm.Value);
           cmd.Parameters.AddWithValue("@sname",scndnm.Value);
           cmd.Parameters.AddWithValue("@ename",mail.Value);
           cmd.Parameters.AddWithValue("@uname",usrnm.Value);
           cmd.Parameters.AddWithValue("pname",pswrd.Value);
           cmd.Parameters.AddWithValue("@utype", utype.SelectedIndex);
           cmd.ExecuteNonQuery();
           Label1.Visible =true;

       }
        catch(Exception){

            Label1.Text ="This Username  Email already exists";
            Label1.Visible = true;
        }
        finally{
       con.Close();
       }
    }
}
/* login code*/


 protected void signin(object sender, EventArgs e) {
        String user;
        String pass;
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        try
        {

            con.Open();
            user = username.Value;
            pass = password.Value;
            String command1 = "Select password from UserDatabase where username='" + user + "'";
            SqlCommand cmd = new SqlCommand(command1, con);
            String par = Convert.ToString(cmd.ExecuteScalar());
            if (string.IsNullOrEmpty(par) == true)
            {
                Label1.Text = "This Username does not exists";
                Label1.Visible = true;
            }
            else
            {
                if (par == pass)
                {

                    Session["username"] = user;
                    before.Visible = false;
                    after.Visible = true;

                }
                else
                {
                    Label1.Text = "This Username and password doesn't match"; Label1.Visible = true;
                }
            }

        }
        catch (Exception E)
        {
            Label1.Text = "Something wrong please retype the values";
            Label1.Visible = true;
        }
        finally
        {
            con.Close();
        }
    }