protected void updateLogin() { string sql = "SELECT RELATIONSHIPID FROM USERTABLE UT WHERE UT.USERID='" + ID + "' AND PASSWORD='******' AND STATUS=2"; Handler hdn = new Handler(); DataTable dt = hdn.GetTable(sql); if (dt.Rows.Count > 0) { usertable obj1 = new usertable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj1.usertable_SRNO = -1; obj1.usertable_RELATIONSHIPID = -1; obj1.usertable_STATUS = 0; string condition = "USERID = '" + ID + "' AND PASSWORD = '******'"; if (obj1.Insert(false, "usertable", condition)) { } registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_SPONSORID = -1; obj.registrationtable_STATUS = 0; string condition1 = "SRNO =" + dt.Rows[0][0].ToString(); ; if (obj.Insert(false, "registrationtable", condition1)) { } } }
protected void btnaccount_Click(object sender, EventArgs e) { string sponsorid = string.Empty; Handler hdn = new Handler(); DataTable dt = hdn.GetTable("SELECT SRNO,NAME FROM REGISTRATIONTABLE RT WHERE SPONSORSEMICODE='" + txtsponsorid.Text.Trim() + "'"); if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty) { registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_NAME = txtname.Text.Trim(); obj.registrationtable_SEMICODE = txtsemid.Text.Trim(); obj.registrationtable_PHONENO = txtmobileno.Text.Trim(); obj.registrationtable_EMAILID = txtemail.Text.Trim(); if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty) { obj.registrationtable_SPONSORID = General.Parse<int>(dt.Rows[0]["SRNO"].ToString()); obj.registrationtable_SPONSORNAME = dt.Rows[0]["NAME"].ToString(); obj.registrationtable_SPONSORSEMICODE = txtsponsorid.Text.Trim(); } else { obj.registrationtable_SPONSORID = -1; } obj.registrationtable_STATUS = -1; string condition = "SRNO=" + Session["userid"].ToString(); if (obj.Insert(false, "registrationtable", condition)) { MessageBox("Profile Updated Successfully"); } } }
protected void btnsubmit_Click(object sender, EventArgs e) { if (txtpassword.Text.Trim() != string.Empty) { registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_SPONSORID = -1; obj.registrationtable_STATUS = 2; string condition = "SRNO=" + ViewState["registrationid"].ToString(); if (obj.Insert(false, "registrationtable", condition)) { usertable obj1 = new usertable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj1.usertable_SRNO = -1; obj1.usertable_STATUS = 2; obj1.usertable_NAME = txtmemname.Text; obj1.usertable_USERID = txtmememail.Text; obj1.usertable_PASSWORD = txtpassword.Text; obj1.usertable_ROLE = "USER"; obj1.usertable_RELATIONSHIPID = General.Parse<int>(ViewState["registrationid"].ToString()); if (obj1.Insert(true, "usertable")) { string encryptedid = EncryptionMethod(txtmememail.Text); string encryptedpassword = EncryptionMethod(txtpassword.Text); string x = HttpContext.Current.Request.Url.ToString(); string[] s = { "superadminmemberlist.aspx" }; string[] spath = x.Split(s, StringSplitOptions.None); string link = "http://crmproject.aishinfotech.net/activatelink.aspx?id=" + txtmememail.Text.Trim().ToLower() + "&psd=" + txtpassword.Text.Trim(); MessageBox("Mail Sent To User For Activation"); string body = "<html xmlns='http://www.w3.org/1999/xhtml'> <head runat='server'> <title>Registration</title> </head> " + " <body> <form id='form1' runat='server'> <div style=' border: 4px solid #537DA3; height:544px; width:600px; background-color:#fff; left:42%; top:0; margin-left:-200px; z-index:99999; border-radius:10px; position:fixed;'>" + " <img src='Images/logo.png' alt='' style='margin-left:3%; padding-top:5px;' /> <div style='font-size:18px; font-family:Arial Balck; font-weight:bold; margin-left:22px; color:#93c220;'>Welcome To Marketing Project</div><br />" + " <p style='margin-left:24px; line-height:22px;'>Hi " + txtmemname.Text + " <br /> Welcome to<a href=''>Marketing Project</a><strong>Get Started!</strong> </p>" + " <strong style='margin-left:24px;'>Your Login Details are :</strong> <p style='margin-left:24px;'><strong>UserName : </strong> " + txtmememail.Text.ToLower() + "<br />" + " <strong>Password :</strong> " + txtpassword.Text + " </p> <p style='color:#b9b7b7; font-size:13px;margin-left:24px;'> If you forget your username/password in future, you can use the <a href='http://crmproject.aishinfotech.net/register.aspx'>forgot your password</a> link on<br /> <a href='http://crmproject.aishinfotech.net'> Marketing Project </a></p>" + " <p style='margin-left:24px;'><strong>Activate Account</strong></p> <p style='color:#b9b7b7; font-size:13px;margin-left:24px; line-height:0px;'> Please visit below url </p><p style='margin-left:24px;line-height:17px;'><br/><a href='" + link + "'>" + link + "</a><br/></p>" + " </form></body> </html>"; try { General.SendMail("", "*****@*****.**", "9850386144k", "smtp.gmail.com", 587, "Registration", body, txtmememail.Text, "", ""); //General.SendMail("", "*****@*****.**", "aish@123", "smtp.gmail.com", 587, "registration", body, txtmememail.Text, "", ""); } catch (Exception ex) { } } } } else { MessageBox("Please Generate Password"); } }
protected void btnaccount_Click(object sender, EventArgs e) { string sponsorid = string.Empty; Handler hdn = new Handler(); DataTable dt = hdn.GetTable("SELECT SRNO,NAME FROM REGISTRATIONTABLE RT WHERE STATUS=0 AND SEMICODE='" + txtsponsorid.Text.Trim() + "'"); if (dt.Rows.Count == 1 && dt.Rows[0]["SRNO"].ToString() != string.Empty) { registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_NAME = txtname.Text.Trim(); obj.registrationtable_SEMICODE = txtsemid.Text.Trim(); obj.registrationtable_PHONENO = txtmobileno.Text.Trim(); obj.registrationtable_EMAILID = txtemail.Text.Trim(); if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty) { obj.registrationtable_SPONSORID = General.Parse<int>(dt.Rows[0]["SRNO"].ToString()); } else { obj.registrationtable_SPONSORID = -1; } obj.registrationtable_SPONSORNAME = txtsponsorname.Text.Trim(); obj.registrationtable_SPONSORSEMICODE = txtsponsorid.Text.Trim(); obj.registrationtable_STATUS = 1; if (obj.Insert(true, "registrationtable")) { txtname.Text = string.Empty; txtsemid.Text = string.Empty; txtmobileno.Text = string.Empty; txtemail.Text = string.Empty; txtsponsorid.Text = string.Empty; txtsponsorname.Text = string.Empty; MessageBox("You will recieve an E-mail shortly after Admin Approval. Thank You"); } else { MessageBox("Please provide proper details"); } } else { MessageBox("Please Enter Proper SAMI Id"); } }
protected void lnkdetails_Click(object sender, EventArgs e) { LinkButton lnk = (LinkButton)sender; if (lnk.CommandName == "0") { registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_SPONSORID = -1; obj.registrationtable_STATUS = 1; string condition = "SRNO=" + lnk.CommandArgument.ToString(); if (obj.Insert(false, "registrationtable", condition)) { } } else if (lnk.CommandName == "1") { registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); obj.registrationtable_SRNO = -1; obj.registrationtable_SPONSORID = -1; obj.registrationtable_STATUS = 0; string condition = "SRNO=" + lnk.CommandArgument.ToString(); if (obj.Insert(false, "registrationtable", condition)) { } } DataTable dtcontract = FillMemberList(); ViewState["list"] = dtcontract; if (dtcontract.Rows.Count > 0) { gvmemberlist.DataSource = (DataTable)ViewState["list"]; gvmemberlist.DataBind(); } else { gvmemberlist.DataSource = null; gvmemberlist.DataBind(); } }