public bool UsernameIsExists(string usrname, int currentUserId) { using (var conn = Database.Open()) { return(conn.ExecuteScalar <int>(UserSql.UsernameIsExists(currentUserId, usrname)) > 0); } }
public Model.User.User FindBy(int key) { using (var con = Database.Open()) { return(con.Query <Model.User.User>(UserSql.FindById(key)).FirstOrDefault()); } }
public IList <Model.User.User> FindAll() { using (var conn = Database.Open()) { return(conn.Query <Model.User.User>(UserSql.FindAll()).ToArray()); } }
public void Update(Model.User.User item) { using (var conn = Database.Open()) { var tuple = UserSql.Update(item); conn.Execute(tuple.Item1, (object)tuple.Item2); } }
public Model.User.User FindBy(string username) { using (var conn = Database.Open()) { var tuple = UserSql.FindByName(username); return(conn.Query <Model.User.User>(tuple.Item1, (object)tuple.Item2).FirstOrDefault()); } }
public void Add(Model.User.User item) { using (var conn = Database.Open()) { var tuple = UserSql.Add(item); int id = conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2); helper.SetValue(m => m.Id, item, id); } }