protected void Page_Load(object sender, EventArgs e)
{
if (Session["name"] == null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "testScript", " $(document).ready(function() { $('#prof').show();});", true);
prof.Style.Add("display", "none");
}
else
{
prof.Style.Add("display", "block");
}
Databs db = new Databs();
DataTable dt = new DataTable();
string qu = "select count(id) from register17";
dt = db.verifys(qu);
int p = Convert.ToInt32(dt.Rows[0][0]);
p = p + 250;
part.InnerText = p.ToString();
}
protected void Log_in_btn_Click(object sender, EventArgs e)
{
Databs db = new Databs();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
string query = "Select Id,Name from register17 where Id='" + TextBox7.Text + "' AND passwords='" + TextBox8.Text + "'";
if (TextBox7.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter user id');", true);
}
else if (!(new Regex(@"^([a-zA-Z0-9]*)$").IsMatch(TextBox7.Text)))
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid user id');", true);
}
else if (TextBox8.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter password');", true);
}
else if (!(new Regex(@"^([a-zA-Z0-9]*)$").IsMatch(TextBox8.Text)))
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid password');", true);
}
else
{
dt1 = db.verifys(query);
dt2 = db.verifys("Select count(Name) from register17 where Id='" + TextBox7.Text + "' AND passwords='" + TextBox8.Text + "'");
try
{
if (dt2.Rows[0][0].ToString() != "0")
{
Session["cord"] = "cs";
char[] c = TextBox7.Text.ToString().ToCharArray();
if (c[0] == 'C' && c[1] == 'O')
{
Session["cord1"] = dt1.Rows[0][0].ToString();
if (c[5] == 'C' && c[6] == 'S')
{
Session["cord"] = "cs";
Response.Redirect("Coordinator.aspx");
}
else if (c[5] == 'E' && c[6] == 'C')
{
Session["cord"] = "ec";
Response.Redirect("Coordinator.aspx");
}
else if (c[5] == 'M' && c[6] == 'E')
{
Session["cord"] = "me";
Response.Redirect("Coordinator.aspx");
}
}
else
{
Session["name"] = dt1.Rows[0][0].ToString();
Response.Redirect("Usr_lgn.aspx");
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Logged in as');", true);
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "alert", "alert('Logged in as');", true);
}
}
else
{
// ClientScript.RegisterStartupScript(GetType(), "alert", "alert('User is not logged.. Check your id or password');", true);
// ShowMessage("User is not logged in", MessageType.Warning);
Session["name"] = null;
}
}
catch { }
}
}
protected void register_btn_Click(object sender, EventArgs e)
{
Databs db = new Databs();
String id = TextBox2.Text;
var id1 = id.ToCharArray();
StringBuilder s = new StringBuilder("YG");
string q = "select COUNT(Name) from register17";
DataTable dt = new DataTable();
dt = db.verifys(q);
for (int i = 0; i < id.Length; i++)
{
if (i == 0)
{
s.Append(id1[i]);
}
else
{
if (id1[i] == ' ' && id1[i + 1] != ' ')
{
s.Append(id1[i + 1]);
}
}
}
int a = 100;
a = a + Convert.ToInt32(dt.Rows[0][0]) + 1;
string app = a.ToString();
s.Append(app);
s.Append(DateTime.Now.Second.ToString());
string query = "insert into register17(Id,Name,College,Email,Phone,Passwords) values('" + s + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')";
try
{
Session["id"] = s;
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "testScript", " $(document).ready(function() { $('#cg').show();});", true);
if (TextBox1.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter name');", true);
}
else if (!(new Regex(@"^([a-zA-Z]*)$").IsMatch(TextBox1.Text)))
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid character in name');", true);
}
else if (TextBox2.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter college');", true);
}
else if (!(new Regex(@"^([a-zA-Z\s]*)$").IsMatch(TextBox2.Text)))
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid characters in college name');", true);
}
else if (!(new Regex(@"^([a-zA-Z0-9_\.\-])+\@(([gmailyhoutk\-])+\.)+([com]{2,4})+$").IsMatch(TextBox3.Text)))
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid Email address');", true);
}
else if (TextBox4.Text.Length < 10)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter valid Mobile no');", true);
}
else if (TextBox5.Text.Length < 6 || TextBox5.Text.Length > 12)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Enter password length between 6-12');", true);
}
else if (TextBox5.Text != TextBox6.Text)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Password not matched');", true);
}
else
{
db.InsertData(query);
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Data Submitted Successfully Check your mail for your user id');", true);
}
}
catch
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Unable to register. Please verify the e mail.');", true);
}
}
