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