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));
}
