protected void lnkResetPassword_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
CryptoGraphy objEncrypt = new CryptoGraphy();
lnkResetPassword.Enabled = false;
objLogin.intRegistartionID = Convert.ToInt32(ViewState["UserID"]);
dt = objLoginDB.GetDataTable(objLogin, DA_Login.Login_1.UserDetails);
if (dt.Rows.Count > 0)
{
string oldPass = objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]));
if (txtOldPassword.Text.Trim() == Convert.ToString(objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]))))
{
objregistration.RegistrationId = Convert.ToInt32(ViewState["UserID"]);
objregistration.Password = objEncrypt.Encrypt(txtNewPassword.Text.Trim());
objLoginDB.AddEditDel_RegistrationDetails(objregistration, DA_Login.Login_1.SelectForUser);
objLoginDB.AddAndGetLoginDetails(objLogin, DA_SKORKEL.DA_Login.Login_1.ChangePassword);
// lblMessage.Text = "Password updated successfully.";
// lblMessage.CssClass = "GreenErrormsg";
System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), "Yelert", "showSuccessPopupRstPwd('Success','Password updated successfully.')", true);
lnkResetPassword.Enabled = true;
//remember me cookie removed .
//Response.Cookies["myScrlCookie"].Expires = DateTime.Now.AddDays(-1);
//Response.Cookies["myScrlCookie"].Values.Add("Password", objregistration.Password.ToString());
if (Request.Cookies["myScrlCookie"] != null)
{
Response.Cookies["myScrlCookie"].Values.Add("UserID", Request.Cookies.Get("myScrlCookie").Values["UserID"].ToString());
Response.Cookies["myScrlCookie"].Values.Add("UserName", Request.Cookies.Get("myScrlCookie").Values["UserName"].ToString());
Response.Cookies["myScrlCookie"].Values.Add("Password", hdnEncpass.Value.Trim());
Session["hdnEncpass"] = hdnEncpass.Value.Trim();
Response.Cookies["myScrlCookie"].HttpOnly = false;
}
//myScrlCookie.Values.Add("Password", objregistration.Password.ToString());
}
else
{
lblMessage.Text = "Old password is incorrect.";
lblMessage.CssClass = "RedErrormsg";
lnkResetPassword.Enabled = true;
return;
}
}
else
{
lblMessage.Text = "Old password is incorrect.";
lblMessage.CssClass = "RedErrormsg";
lnkResetPassword.Enabled = true;
return;
}
}
static void Main(string[] args)
{
//CryptoGraphy cryptoGraphy = new CryptoGraphy();
Console.WriteLine("Enter Text...");
string text = Convert.ToString(Console.ReadLine());
Console.WriteLine("Text after Encrytion");
string encryptedText = string.Empty;
encryptedText = CryptoGraphy.Encrypt(text);
Console.WriteLine(encryptedText);
string decryptedText = CryptoGraphy.Decrypt(encryptedText);
Console.WriteLine("Text After Decryption..");
Console.WriteLine(decryptedText);
Console.Read();
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string strPasswordmd5 = "";
DataTable dt = new DataTable();
objLogin.Username = Login1.UserName;
string Password = objEncrypt.Encrypt(Login1.Password);
objLogin.Password = Password;
dt = objLoginDB.GetDataSet(objLogin, DA_SKORKEL.DA_Login.Login_1.UserLoginMD5);
if (dt.Rows.Count > 0)
{
string strPassword = objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]));
DataTable dtmd5 = new DataTable();
objLogin.Password = strPassword;
dtmd5 = objLoginDB.GetDataSet(objLogin, DA_Login.Login_1.GetMD5);
if (dtmd5.Rows.Count > 0)
{
strPasswordmd5 = Convert.ToString(dtmd5.Rows[0]["strPasswordMD5"]);
}
UserSession.UserInfo UInfo = new UserSession.UserInfo();
string LoginName = Convert.ToString(dt.Rows[0]["LoginName"]);
UInfo.UserName = Convert.ToString(dt.Rows[0]["vchrUserName"]);
UInfo.UserID = Convert.ToInt64(dt.Rows[0]["intRegistrationId"]);
int TypeId = Convert.ToInt32(dt.Rows[0]["intUserTypeID"]);
string RegistrationType = Convert.ToString(dt.Rows[0]["RegistartionType"]);
Session.Add("RegType", RegistrationType);
Session.Add("UserTypeId", TypeId);
Session.Add("UInfo", UInfo);
Session.Add("LoginName", LoginName);
Session.Add("ExternalUserId", Convert.ToString(dt.Rows[0]["intRegistrationId"]));
objLogin.intRegistartionID = Convert.ToInt32(dt.Rows[0]["intRegistrationId"]);
objLoginDB.AddAndGetLoginDetails(objLogin, DA_SKORKEL.DA_Login.Login_1.Login);
Response.Redirect("SA_JournalListing.aspx");
//Response.Redirect("SA_Testing.aspx");
}
else
{
Login1.FailureText = "Invalid user.";
divLogin.Style.Add("display", "block");
}
}
protected void SetupSecureSettingSource()
{
Configuration = Isolate.Fake.Instance <Configuration>();
Factory = new TestConfigurationFactory(Configuration);
KeyManager = Isolate.Fake.Instance <SecretKeyManager>();
Key = "key";
Isolate.WhenCalled((() => KeyManager.GetKey())).WillReturn(Key);
CryptoGraphy = Isolate.Fake.Instance <CryptoGraphy>();
Isolate.WhenCalled(() => CryptoGraphy.SetKey(Key)).IgnoreCall();
Name = "secret";
Encrypted = "[Secure]=";
Isolate.WhenCalled((() => CryptoGraphy.Encrypt(Name))).WillReturn(Encrypted);
Isolate.WhenCalled((() => CryptoGraphy.Decrypt(Encrypted))).WillReturn(Name);
SecureSettingSource = new ConfigurationSettingSource(Factory);
}
protected void lnkResetPassword_Click(object sender, EventArgs e)
{
CryptoGraphy objEncrypt = new CryptoGraphy();
lnkResetPassword.Enabled = false;
objLogin.intRegistartionID = Convert.ToInt32(ViewState["UserID"]);
dt = objLoginDB.GetDataTable(objLogin, DA_Login.Login_1.UserDetails);
if (dt.Rows.Count > 0)
{
string oldPass = objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]));
if (txtOldPassword.Text.Trim() == Convert.ToString(objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]))))
{
objregistration.RegistrationId = Convert.ToInt32(ViewState["UserID"]);
objregistration.Password = objEncrypt.Encrypt(txtNewPassword.Text.Trim());
objLoginDB.AddEditDel_RegistrationDetails(objregistration, DA_Login.Login_1.SelectForUser);
objLoginDB.AddAndGetLoginDetails(objLogin, DA_SKORKEL.DA_Login.Login_1.ChangePassword);
lblMessage.Text = "Password updated successfully.";
lblMessage.CssClass = "GreenErrormsg";
lnkResetPassword.Enabled = true;
}
else
{
lblMessage.Text = "Old password is incorrect.";
lblMessage.CssClass = "RedErrormsg";
lnkResetPassword.Enabled = true;
return;
}
}
else
{
lblMessage.Text = "Old password is incorrect.";
lblMessage.CssClass = "RedErrormsg";
lnkResetPassword.Enabled = true;
return;
}
}
//Function to Insert Records
private void InsertCSVRecords(DataTable csvdt)
{
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
//bool IsSuccessSave = false;
//SqlTransaction transaction = null;
DataTable dtInsrt = new DataTable();
dtInsrt = csvdt.Clone();
DataColumn myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.Int32");
myColumn.AllowDBNull = false;
myColumn.Caption = "intUserTypeID";
myColumn.ColumnName = "intUserTypeID";
myColumn.DefaultValue = 1;
DataColumn myColumndtAddedOn = new DataColumn();
myColumndtAddedOn.DataType = System.Type.GetType("System.DateTime");
myColumndtAddedOn.AllowDBNull = false;
myColumndtAddedOn.Caption = "dtAddedOn";
myColumndtAddedOn.ColumnName = "dtAddedOn";
myColumndtAddedOn.DefaultValue = DateTime.Now;
dtInsrt.Columns.Add(myColumn);
dtInsrt.Columns.Add(myColumndtAddedOn);
for (int i = 0; i < csvdt.Rows.Count; i++)
{
CryptoGraphy objEncrypt = new CryptoGraphy();
dtInsrt.ImportRow(csvdt.Rows[i]);
dtInsrt.Rows[i]["Email"] = Convert.ToString(dtInsrt.Rows[i]["Email"]).Replace("\r", null);
dtInsrt.Rows[i]["vchrPassword"] = objEncrypt.Encrypt(Convert.ToString(csvdt.Rows[i]["vchrPassword"]));
}
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
using (SqlBulkCopy objbulk = new SqlBulkCopy(conn))
{
//assigning Destination table name
objbulk.DestinationTableName = "Scrl_RegistrationTbl";
//Mapping Table column
objbulk.ColumnMappings.Add("FirstName", "vchrFirstName");
objbulk.ColumnMappings.Add("LastName", "vchrLastName");
objbulk.ColumnMappings.Add("Email", "vchrUserName");
objbulk.ColumnMappings.Add("vchrActive", "vchrActive");
objbulk.ColumnMappings.Add("vchrPassword", "vchrPassword");
objbulk.ColumnMappings.Add("intUserTypeID", "intUserTypeID");
objbulk.ColumnMappings.Add("dtAddedOn", "dtAddedOn");
//dtAddedOn
//Inserting Datatable Records to DataBase
conn.Open();
//transaction.Commit();
//IsSuccessSave = true;
objbulk.WriteToServer(dtInsrt);
conn.Close();
for (int i = 0; i < csvdt.Rows.Count; i++)
{
SendMail(csvdt.Rows[i]["Email"].ToString().Replace("\r", null), csvdt.Rows[i]["vchrPassword"].ToString(), csvdt.Rows[i]["FirstName"].ToString() + " " + csvdt.Rows[i]["LastName"].ToString());
DataTable dtRecord = new DataTable();
dtRecord.Clear();
objdoreg.UserName = csvdt.Rows[i]["Email"].ToString().Replace("\r", null);
dtRecord = objdareg.GetDataTableRecord(objdoreg, DA_Registrationdetails.RegistrationDetails.UserRecordByMail);
//string id = "id=" + dtRecord.Rows[0]["intRegistrationId"].ToString();
//dt = objLoginDB.GetDataTable(objLogin, DA_SKORKEL.DA_Login.Login_1.UserDetails);
if (ISAPIURLACCESSED == "1")
{
StringBuilder UserURL = new StringBuilder();
UserURL.Append(APIURL);
UserURL.Append("registerUser.action?");
UserURL.Append("uid=");
UserURL.Append(Convert.ToString(dtRecord.Rows[0]["intRegistrationId"]));
UserURL.Append("&userId=");
UserURL.Append(Convert.ToString(dtRecord.Rows[0]["vchrUserName"]));
UserURL.Append("&password="******"vchrPassword"]));
UserURL.Append("&firstName=");
UserURL.Append(Convert.ToString(dtRecord.Rows[0]["vchrFirstName"]));
UserURL.Append("&lastName=");
UserURL.Append(Convert.ToString(dtRecord.Rows[0]["vchrLastName"]));
UserURL.Append("&userType=STUDENT");
UserURL.Append("&userContextIds=" + null);
UserURL.Append("&friendUserIds=" + null);
UserURL.Append("&lawRelated=" + null);
try
{
HttpWebRequest myRequest1 = (HttpWebRequest)WebRequest.Create(UserURL.ToString());
myRequest1.Method = "GET";
WebResponse myResponse1 = myRequest1.GetResponse();
StreamReader sr = new StreamReader(myResponse1.GetResponseStream(), System.Text.Encoding.UTF8);
String result = sr.ReadToEnd();
objAPILogDO.strURL = UserURL.ToString();
objAPILogDO.strAPIType = "Student";
objAPILogDO.strResponse = result;
if (ip == null)
{
objAPILogDO.strIPAddress = Request.ServerVariables["REMOTE_ADDR"];
}
objAPILogDA.AddEditDel_Scrl_APILogDetailsTbl(objAPILogDO, DA_Scrl_APILogDetailsTbl.Scrl_APILogDetailsTbl.Insert);
}
catch (Exception ex)
{ ex.Message.ToString(); }
}
}
lblError.Visible = true;
lblError.Text = "User's list uploaded successfully.";
ScriptManager.RegisterStartupScript(this, this.GetType(), "starScripts1", "hideLoader1();", true);
}
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string strPasswordmd5 = "";
DataTable dt = new DataTable();
objLogin.Username = Login1.UserName;
string Password = objEncrypt.Encrypt(Login1.Password);
objLogin.Password = Password;
dt = objLoginDB.GetDataSet(objLogin, DA_SKORKEL.DA_Login.Login_1.UserLoginMD5);//UserLogin);
if (dt.Rows.Count > 0)
{
string strPassword = objEncrypt.Decrypt(Convert.ToString(dt.Rows[0]["vchrPassword"]));
DataTable dtmd5 = new DataTable();
objLogin.Password = strPassword;
dtmd5 = objLoginDB.GetDataSet(objLogin, DA_Login.Login_1.GetMD5);
if (dtmd5.Rows.Count > 0)
{
strPasswordmd5 = Convert.ToString(dtmd5.Rows[0]["strPasswordMD5"]);
}
if (Login1.RememberMeSet == true)
{
HttpCookie myScrlCookie = new HttpCookie("myScrlCookie");
Response.Cookies.Remove("myScrlCookie");
//Add UserID Cookie
myScrlCookie.Values.Add("UserID", Convert.ToString(dt.Rows[0]["intRegistrationId"]));
myScrlCookie.Values.Add("UserName", Login1.UserName.ToString());
myScrlCookie.Values.Add("Password", Login1.Password.ToString());
DateTime dtxpiry = DateTime.Now.AddDays(15);
myScrlCookie.Expires = dtxpiry;
myScrlCookie.HttpOnly = false;
Response.Cookies.Add(myScrlCookie);
}
UserSession.UserInfo UInfo = new UserSession.UserInfo();
string LoginName = Convert.ToString(dt.Rows[0]["LoginName"]);
UInfo.UserName = Convert.ToString(dt.Rows[0]["vchrUserName"]);
UInfo.UserID = Convert.ToInt64(dt.Rows[0]["intRegistrationId"]);
int TypeId = Convert.ToInt32(dt.Rows[0]["intUserTypeID"]);
Session.Add("UserTypeId", TypeId);
Session.Add("UInfo", UInfo);
Session.Add("LoginName", LoginName);
Session.Add("ExternalUserId", Convert.ToString(dt.Rows[0]["intRegistrationId"]));
objLogin.intRegistartionID = Convert.ToInt32(dt.Rows[0]["intRegistrationId"]);
objLoginDB.AddAndGetLoginDetails(objLogin, DA_SKORKEL.DA_Login.Login_1.Login);
if (ISAPIURLACCESSED != "0")
{
try
{
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ip == null)
{
ip = Request.ServerVariables["REMOTE_ADDR"];
}
String url = APIURL + "userLogin.action?" +
"loginUid=" + dt.Rows[0]["intUserTypeID"] + dt.Rows[0]["intRegistrationId"] +
"&loginId=" + dt.Rows[0]["intRegistrationId"] +
"&password="******"&loginTime=" + DateTime.Now +
"&sessionId=" + HttpContext.Current.Session.SessionID;
HttpWebRequest myRequest1 = (HttpWebRequest)WebRequest.Create(url);
myRequest1.Method = "GET";
if (ISAPIResponse != "0")
{
WebResponse myResponse1 = myRequest1.GetResponse();
StreamReader sr = new StreamReader(myResponse1.GetResponseStream(), System.Text.Encoding.UTF8);
String result = sr.ReadToEnd();
objAPILogDO.strURL = url;
objAPILogDO.strAPIType = "User Login";
objAPILogDO.strResponse = result;
objAPILogDO.strIPAddress = ip;
objAPILogDO.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
objAPILogDA.AddEditDel_Scrl_APILogDetailsTbl(objAPILogDO, DA_Scrl_APILogDetailsTbl.Scrl_APILogDetailsTbl.Insert);
}
}
catch { }
}
Response.Redirect("Home.aspx?ActiveStatus=P");
//Response.Redirect("Signup3.aspx");
}
else
{
divLogin.Style.Add("display", "block");
Login1.FailureText = "Invalid email or password.";
openLoginPopup();
}
}
protected void lnlNext_Click(object sender, EventArgs e)
{
CompareValidator1.Validate();
lblMsgs.Text = "";
dt = new DataTable();
dt = (DataTable)ViewState["UserDetails"];
if (txtUname.Text.Trim().Replace("'", "''") == "")
{
return;
}
if (txtFirstName.Text.Trim().Replace("'", "''") == "" || txtFirstName.Text.Trim().Replace("'", "''") == "First Name")
{
lblMsgs.Text = "First name is required.";
return;
}
if (txtLastName.Text.Trim().Replace("'", "''") == "" || txtLastName.Text.Trim().Replace("'", "''") == "Last Name")
{
lblMsgs.Text = "Last name is required.";
return;
}
if (txtPassword.Text.Trim() == "")
{
return;
}
if (txtConPassword.Text.Trim() == "")
{
lblMsgs.Text = "Confirm password is required.";
return;
}
if (chkIAgree.Checked == false)
{
lblMsgs.Text = "Please check Terms & Conditions.";
return;
}
if (txtConPassword.Text.Trim() != txtPassword.Text.Trim())
{
lblMsgs.Text = "Passwords do not match.";
return;
}
objLogin.Username = txtUname.Text.Trim().Replace("'", "''");
dt = objLoginDB.GetDataSet(objLogin, DA_SKORKEL.DA_Login.Login_1.GmailFBLogin);
if (dt.Rows.Count > 0)
{
lblMsgs.Text = "Email id already exist.";
txtUname.Text = "";
return;
}
CryptoGraphy objEncrypt = new CryptoGraphy();
string Password = objEncrypt.Encrypt(txtPassword.Text.Trim());
string middleName = "";
BindDataTable();
row = dt.NewRow();
//Defect #9 Validate HTML Input
row["FirstName"] = Validations.validateHtmlInput(txtFirstName.Text.Trim());
row["MiddleName"] = middleName;
row["LastName"] = Validations.validateHtmlInput(txtLastName.Text.Trim());
row["UserName"] = txtUname.Text.Trim();
row["Password"] = Password;
row["ConPassword"] = txtConPassword.Text.Trim();
row["UserTypeId"] = 1; // For students
dt.Rows.Add(row);
Session.Add("UserDetails", dt);
Response.Redirect("~/SignUp2.aspx");
}
