static void AddUser(User user) { string query = "select * from User where Id='" + user.Id+"'"; if (DataProvider.LoadData(query).Rows.Count==0) { string sql = string.Format("Insert into User values('{0}','{1}','{2}')", user.Id, user.Hoten, user.Password); DataProvider.Insert(sql); } }
void AddUser(User user) { string query = "select * from User where id=" + user.Id; if (DataProvider.LoadData(query) == null) { string sql = string.Format("Insert into User values('{0}','{1}','{2}')", user.Id, user.Hoten, user.Password); DataProvider.Insert(sql); } }
User getUser(string id,string password) { string query = "select * from User where Id=" + id+",Password="******"HoTen"].ToString(); } return user; }
public static User getUser(string id) { string query = "select * from User where Id='" + id + "'"; DataTable db = DataProvider.LoadData(query); User user = new User(); user.Id = id; if (db.Rows.Count == 0) { user.Hoten = getNameFromSV(id); AddUser(user); } else { for (int i = 0; i < db.Rows.Count; i++) { user.Hoten = db.Rows[i]["HoTen"].ToString(); } } return user; }