public string RegisterUser(RegisterUserObject user)
{
Console.WriteLine("Registering user : "******"Ne mozete registrovati 2 korisnika sa istim JMBG");
}
long userID = WCFServer.Database.RegisterUser(user);
Random rand = new Random(DateTime.UtcNow.Millisecond);
int randomCode = rand.Next(100000, 999999);
SmsHandler.Instance.SendRegistryConfirmation(randomCode.ToString(), user.Mobile, userID);
return("true. ID [" + userID + "]");
}
public long RegisterUser(RegisterUserObject user)
{
using (var conn = GetConnection())
{
conn.Open();
using (var com = new MySqlCommand("INSERT INTO users (name,surname,address,jmbg,mobile,email,gender,picture_url,id_country_code,phone_extension) VALUES (@name,@surname,@address,@jmbg,@mobile,@email,@gender,@pic,@idcc,@ext)", conn))
{
com.Parameters.Add("@name", MySqlDbType.VarChar).Value = user.Name;
com.Parameters.Add("@pic", MySqlDbType.VarChar).Value = "NOT SET";
com.Parameters.Add("@surname", MySqlDbType.VarChar).Value = user.Surname;
com.Parameters.Add("@address", MySqlDbType.VarChar).Value = user.Address;
com.Parameters.Add("@jmbg", MySqlDbType.VarChar).Value = user.JMBG;
com.Parameters.Add("@mobile", MySqlDbType.VarChar).Value = user.Mobile;
com.Parameters.Add("@email", MySqlDbType.VarChar).Value = user.Email;
com.Parameters.Add("@gender", MySqlDbType.Byte).Value = user.Gender;
com.Parameters.Add("@idcc", MySqlDbType.VarChar).Value = user.CountryCode;
com.Parameters.Add("@ext", MySqlDbType.VarChar).Value = user.PhoneExtension;
com.ExecuteNonQuery();
return(com.LastInsertedId);
}
}
}
