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