Web.config:
<connectionStrings>
<add name="GroceryDB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\lathi\OneDrive\Documents\Grocery Shop\Grocery Shop\Online Grocery Shop\App_Data\GroceryDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"/>
</connectionStrings>
Admin Login:
public partial class Admin_AdminLogin : System.Web.UI.Page
{
string str = ConfigurationManager.ConnectionStrings["cnStr"].ConnectionString;
SqlConnection cn;
protected void Page_Load(object sender, EventArgs e)
{
cn = new SqlConnection(str);
cn.Open();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string str;
str = "select AUserName, APassword from tblAdmin where AUserName = '" + txtUser.Text + "' and APassword = '" + txtPassword.Text + "'";
SqlCommand cmd = new SqlCommand(str, cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count > 0)
{
Session["Admin"] = txtUser.Text;
Response.Redirect("Dashboard.aspx");
}
}
}
Logout:
protected void Page_Load(object sender, EventArgs e)
{
Session.Remove("Admin");
Session.Abandon();
Response.Redirect("AdminLogin.aspx");
}
Rgistration:
public partial class Registration : System.Web.UI.Page
{
public static string exi = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (exi == "Exists")
{
lblMsg.Text = "UserEmail Already Exists, Please register with Other Email !!";
exi = string.Empty;
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GroceryDB"].ConnectionString);
SqlCommand cmd0 = new SqlCommand(@"select case when (select 1 from Registration where Email='"+txtemail.Text.Trim()+"')=1 then 1 else 0 end", cn);
SqlCommand cmd = new SqlCommand(@"Insert into Registration values ('" + txtname.Text.Trim() + "','" + txtemail.Text.Trim() + "','" + txtpass.Text.Trim() + "','" + rblGender.SelectedValue + "'," + txtphone.Text.Trim() + ",'"+ txtclendar.Text +"','"
+txtstreet.Text.Trim()+"','"+ddlcountry.SelectedValue+"','"+txtcity.Text.Trim()+"','"+country.SelectedValue+"','"+txtPostal.Text.Trim()+"',1)", cn);
SqlCommand cmd1 = new SqlCommand(@"insert into Login Values('" + txtemail.Text.Trim() + "','" + txtpass.Text.Trim() + "',getdate())", cn);
cn.Open();
int exists = (int)cmd0.ExecuteScalar();
if (exists == 1)
{
exi = "Exists";
Response.Redirect(Request.RawUrl);
}
else
{
Session["UserEmail"] = txtemail.Text.Trim();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
Response.Redirect("RegistrationSuccessfull.aspx");
}
cn.Close();
}
private void SendMail()
{
MailMessage Msg = new MailMessage();
// Sender e-mail address.
Msg.From = new MailAddress("amrinder0751@gmail.com");
// Recipient e-mail address.
Msg.To.Add(txtemail.Text);
Msg.Subject = "Confirmation";
string body = "Successfully registered with Fresho Fruit Mart";
Msg.Body = body;
Msg.IsBodyHtml = true;
// your remote SMTP server IP.
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("amrinder0751@gmail.com", "enfield1537");
smtp.EnableSsl = true;
smtp.Send(Msg);
}
protected void btncancel_Click(object sender, EventArgs e)
{
Response.Redirect(Request.RawUrl);
}
}
0 Comments
Post a Comment