public bool UpdateUserById(int userId, SQLiteUser update, SQLiteConnecter connecter)
{
string updateCommand = string.Format("UPDATE User set Username='******', Password='******', Age='{2}', Gender='{3}' where id='{5}'",
update.Username, update.Password, update.Age, update.Gender, userId);
return(ExecuteCommand(updateCommand, connecter.connection));
}
public RegistrationPage(UserViewModel viewModel, string mode = "")
{
_mode = mode;
Globals.myAdID = "ca-app-pub-6838059012127071/4882317165";
var sqliteUser = new SQLiteUser(DependencyService.Get <ISQLiteDb>());
var pageService = new PageService();
Title = mode == "setting" ? "User Setting" : "New User";
RegModel = new RegistrationViewModel(viewModel ?? new UserViewModel(), sqliteUser, pageService, mode);
InitializeComponent();
}
public Result Login(string username, string password, SQLiteConnecter connecter)
{
DataSet data = new DataSet();
SQLiteDataAdapter adapter = new SQLiteDataAdapter(
string.Format("select id, Username, Password, Age, Gender from User where Username='******' AND Password='******'", username, password),
connecter.connection);
adapter.Fill(data);
DataRow entity = data.Tables[0].Rows[0];
SQLiteUser user = Utilities.ToObject <SQLiteUser>(entity);
return(new Result
{
status = Status.OK,
data = user
});
}
public ObjectResult CreateNewUser([FromBody] SQLiteUser user)
{
try
{
Result result = userSQLiteService.InsertUser(user, APIConnecter.SQLite);
if (result.status == Status.Created)
{
return(Ok(Responder.Success(result.data)));
}
else
{
return(StatusCode(result.status, Responder.Fail(result.data)));
}
}
catch (Exception error)
{
return(BadRequest(Responder.Fail(error.Message)));
}
}
public Result InsertUser(SQLiteUser user, SQLiteConnecter connecter)
{
string insertCommand = string.Format("INSERT INTO User(Username,Password,Age,Gender) VALUES('{0}', '{1}', '{2}', '{3}')",
user.Username, user.Password, user.Age, user.Gender);
if (ExecuteCommand(insertCommand, connecter.connection))
{
string getIdCoommand = "SELECT last_insert_rowid()";
int _id = Convert.ToInt32(ExecuteScalar(getIdCoommand, connecter.connection));
return(new Result
{
status = Status.Created,
data = _id
});
}
else
{
return new Result
{
status = Status.BadRequest,
data = Messages.BadRequest
}
};
}
public bool AddUserDetails(UserDetails userDetails)
{
return(SQLiteUser.AddUserDetails(userDetails));
}