public int addUser(User user)
{
SSGetService getService = new SSGetService();
User numberCheck = getService.getUserByMobileNumber(user.mobile_number);
User usernameCheck = getService.getUserByUsername(user.username);
if (usernameCheck.username == null)
{
if (numberCheck.mobile_number == null)
{
using (SqlCommand command = new SqlCommand("INSERT INTO ss_users(bid,name, username, password, mobile_number,picture)VALUES(@bid,@name,@username,@password, @mobile_number,@picture)"))
{
command.Parameters.AddWithValue("@bid", user.bid);
command.Parameters.AddWithValue("@name", user.name);
command.Parameters.AddWithValue("@username", user.username);
command.Parameters.AddWithValue("@password", user.password);
command.Parameters.AddWithValue("@mobile_number", user.mobile_number);
if (user.picture != null)
{
command.Parameters.Add("@picture", SqlDbType.Image, user.picture.Length).Value = user.picture;
}
int response = service.execute(command);
if (response > 0)
{
this.addLog(new Log()
{
type = "Add User",
statement = command.CommandText,
description = "Created user " + user.name,
});
}
return(response);
}
}
else
{
return(-3);
}
}
else
{
return(-2);
}
}
