private void send_activation_mail()
{
//try
//{
// string activationlink = "http://*****:*****@gmail.com", "TIFFIN DABBA");//TIFFIN DABBA represent title in sent email.
// mm.To.Add(TextBox4.Text);
// mm.Subject = "Account Activation";
// mm.Body = "Hello: " + TextBox1.Text + "<br /><br />To activate your TIFFIN DABBA account <a href='" + activationlink + "'>Click here</a>";
// mm.IsBodyHtml = true;
// SmtpClient smtp = new SmtpClient();
// smtp.Host = "smtp.gmail.com";
// smtp.EnableSsl = true;
// smtp.Port = 587;
// smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "102515209");
// smtp.Send(mm);
string kz = "insert into user_accounts values('" + TextBox4.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','Allowed')";
dc.setdata(kz);
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox1.Focus();
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Now You Can Login');", true);
Email_login_tb.Focus();
//Session["msg"] = "Now You Can Log In";
//Response.Redirect("~/Log_in.aspx");
//ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('activation link is send to your email id please activate your account');window.location='Log_in.aspx';", true);
//}
//catch (Exception ex)
//{
// string Mail_msg = "Registration fail please try again.";
// ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + Mail_msg + "');", true);
//}
}
protected void Login_btn_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
string jk = "select status from user_accounts where id='" + Email_login_tb.Text + "' and pass='******'";
ds = dc.getdata(jk);
string kj = "select * from providers where pid='" + Email_login_tb.Text + "' and pass='******'";
ds1 = dc.getdata(kj);
string j = "select * from admin_login where id='" + Email_login_tb.Text + "' and pass='******'";
ds2 = dc.getdata(j);
if (ds.Tables[0].Rows.Count != 0)
{
//if (ds.Tables[0].Rows[0][0].ToString() == "Not Allowed")
//{
// ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Please activate your account.');", true);
//}
if (ds.Tables[0].Rows[0][0].ToString() == "Blocked")
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Your account is blocked please contant the admin.');", true);
}
else if (ds.Tables[0].Rows[0][0].ToString() == "Allowed")
{
if (Convert.ToString(Session["tiffin_type"]) == "")
{
Session["uid"] = Email_login_tb.Text;
Label1.Text = "";
Response.Redirect("~/user/Home.aspx");
}
else
{
if (Convert.ToString(Session["tiffin_type"]) == "tws")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/Tiffin_with_sweet_order.aspx");
}
else if (Convert.ToString(Session["tiffin_type"]) == "st")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/Simple_tiffin_order.aspx");
}
else if (Convert.ToString(Session["tiffin_type"]) == "monthly tiffin")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/Book_monthly_order.aspx");
}
else if (Convert.ToString(Session["tiffin_type"]) == "trial tiffin")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/Book_trial_tiffin.aspx");
}
else if (Convert.ToString(Session["tiffin_type"]) == "ff")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/Cart.aspx");
}
else if (Convert.ToString(Session["tiffin_type"]) == "spt")
{
Session["uid"] = Email_login_tb.Text;
Response.Redirect("~/user/SpecialTiffinOrder.aspx");
}
}
}
}
else if (ds1.Tables[0].Rows.Count != 0)
{
Session["pid"] = Email_login_tb.Text;
Label1.Text = "";
Response.Redirect("~/provider/Home.aspx");
}
else if (ds2.Tables[0].Rows.Count != 0)
{
Session["aid"] = Email_login_tb.Text;
Label1.Text = "";
Response.Redirect("~/admin/Add_Remove_city.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Invalid Id Or Password');", true);
//Response.Write("<script>alert('Invalid User Id Or Password')</script>");
Email_login_tb.Text = "";
Password_login_tb.Text = "";
Email_login_tb.Focus();
}
}
