public string CreateUseer(string name, string email, string mobile) { string password = SampleHelper.GetRandomPassword(); string hashPassword = string.Empty; using (MD5 md5Hash = MD5.Create()) { hashPassword = SampleHelper.GetMd5Hash(md5Hash, password); } using (SqlConnection con = new SqlConnection(SampleHelper.GetConnectionString())) { string query = "INSERT INTO [OTCUsers] (UserName,Password,Name,Mobile,CreatedBy) values(@email,@password,@name,@mobile,101)"; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; con.Open(); cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@password", hashPassword); cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@mobile", mobile); cmd.ExecuteNonQuery(); con.Close(); } } SampleHelper.SendO365Mail(email, name, "myTest Account", string.Format("User Name :{0} password : {1}", email, password)); return(string.Format("User created for {0}.", name)); }
public string GenerateMD5Data(FormCollection formData) { string userName = string.Empty; string password = String.Empty; string hashPassword = string.Empty; userName = Convert.ToString(formData["UserName"]); password = Convert.ToString(formData["Password"]); using (MD5 md5Hash = MD5.Create()) { hashPassword = SampleHelper.GetMd5Hash(md5Hash, userName); } return(hashPassword); }
public string ValidateUser(string username, string password) { string userInfo = string.Empty; using (MD5 md5Hash = MD5.Create()) { password = SampleHelper.GetMd5Hash(md5Hash, password); } using (SqlConnection con = new SqlConnection(SampleHelper.GetConnectionString())) { string query = "Select * From OTCUsers where UserName=@email and password=@password"; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; con.Open(); cmd.Parameters.AddWithValue("@email", username); cmd.Parameters.AddWithValue("@password", password); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (Convert.ToBoolean(dr["IsLockedOut"])) { userInfo = "X"; } else { userInfo = Convert.ToString(dr["UserID"]) + "|" + Convert.ToString(dr["Name"]) + "|" + Convert.ToString(dr["UserName"]) + "|" + (Convert.ToInt32(dr["mtType"]) == 1 ? "User" : "Admin"); } } else { userInfo = "O"; } con.Close(); } } return(userInfo); }