public bool Insert(Member member)
{
try
{
using (var stt = SQLiteUtil.GetIntances().Connection.Prepare("INSERT INTO Members (FirstName, LastName, Avatar, Phone, " +
"Address, Introduction, Gender, Birthday, Email, Password) VALUES (?,?,?,?,?,?,?,?,?,?)"))
{
stt.Bind(1, member.FirstName);
stt.Bind(2, member.LastName);
stt.Bind(3, member.Avatar);
stt.Bind(4, member.Phone);
stt.Bind(5, member.Address);
stt.Bind(6, member.Introduction);
stt.Bind(7, member.Gender);
stt.Bind(8, member.Birthday);
stt.Bind(9, member.Email);
stt.Bind(10, member.Password);
stt.Step();
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
public bool Insert(Student student)
{
try
{
using (var stt = SQLiteUtil.GetIntances().Connection.Prepare("INSERT INTO Student (Name) VALUES (?)"))
{
stt.Bind(1, student.Name);
stt.Step();
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}