private void btnConfirm_Click(object sender, EventArgs e)
{
txtAnswer.Text = txtAnswer.Text.ToLower();
userChoices[currentQuiz].CorrectAns = questions[currentQuiz].GetFlashCard().Eng;
userChoices[currentQuiz].Correct = 0;
if (txtAnswer.Text != null && txtAnswer.Text.Length != 0)
{
bool isCorrect = true;
if (txtAnswer.Text != questions[currentQuiz].GetFlashCard().Eng)
{
lbWrong.Visible = true;
isCorrect = false;
userChoices[currentQuiz].Selected = -1;
}
lbCorrectAnswer.Text = questions[currentQuiz].GetFlashCard().Eng;
lbCorrectAnswer.Visible = true;
userChoices[currentQuiz].IsDone = true;
btnNext.Enabled = true;
userChoices[currentQuiz].Answer = txtAnswer.Text;
userChoices[currentQuiz].IsDone = true;
txtAnswer.Enabled = false;
if (isCorrect == true)
{
FlashCard fl = questions[currentQuiz].GetFlashCard();
if (!ManageUserAction.IsFlashCardExist(0, fl.IdCard))
{
AddFlashCard(fl);
}
wrongAns--;
userChoices[currentQuiz].Selected = 0;
}
}
}
public static List <FlashCard> UpdateFlashCardOfCollection(int idCollection)
{
List <FlashCard> flashCards = new List <FlashCard>();
SqlConnection connection = new SqlConnection(constr);
try
{
connection.Open();
//Chuan bi cau lenh query viet bang SQL
String sqlQuery = "select id_card, eng, vie, pronunciation, field from USER_FLASHCARD, flashcard where USER_FLASHCARD.ID_CARD = FLASHCARD.ID and ID_USER = "******" and id_collection = " + idCollection.ToString();
//Tao mot Sqlcommand de thuc hien cau lenh truy van da chuan bi voi ket noi hien tai
SqlCommand command = new SqlCommand(sqlQuery, connection);
//Thuc hien cau truy van va nhan ve mot doi tuong reader ho tro do du lieu
SqlDataReader reader = command.ExecuteReader();
//Su dung reader de doc tung dong du lieu va cho vao list allFlashCards
while (reader.HasRows)
{
if (reader.Read() == false)
{
break;
}
FlashCard f = new FlashCard(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4));
flashCards.Add(f);
}
return(flashCards);
}
finally
{
connection.Close();
}
}
public CollectionLib(CollectionForm collectionTab, int idCollection)
{
InitializeComponent();
darkMode = ManageUserAction.GetDarkMode();
//
if (darkMode)
{
UpdateTheme();
}
//
this.collectionTab = collectionTab;
this.KeyPreview = true;
//
index = 0;
this.curCollection = ManageUserAction.GetItemOfAllCollection(idCollection);
if (idCollection == 0)
{
btnRemoveFromCollection.Visible = false;
}
else
{
btnRemoveFromCollection.Visible = true;
}
lbCollectionName.Text = curCollection.NameCollection;
curFlashCard = curCollection.ListFL[index];
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
InitAutoCompleteTextBox();
}
private void ReloadButton()
{
btnA.FillColor = primary;
btnB.FillColor = primary;
btnC.FillColor = primary;
btnD.FillColor = primary;
bool isCorrect = true;
if (userChoices[currentQuiz].Selected != userChoices[currentQuiz].Correct)
{
isCorrect = false;
switch (userChoices[currentQuiz].Selected)
{
case 1:
btnA.FillColor = Color.FromArgb(224, 92, 92);
break;
case 2:
btnB.FillColor = Color.FromArgb(224, 92, 92);
break;
case 3:
btnC.FillColor = Color.FromArgb(224, 92, 92);
break;
case 4:
btnD.FillColor = Color.FromArgb(224, 92, 92);
break;
}
}
switch (userChoices[currentQuiz].Correct)
{
case 1:
btnA.FillColor = Color.FromArgb(108, 255, 125);
break;
case 2:
btnB.FillColor = Color.FromArgb(108, 255, 125);
break;
case 3:
btnC.FillColor = Color.FromArgb(108, 255, 125);
break;
case 4:
btnD.FillColor = Color.FromArgb(108, 255, 125);
break;
}
if (isCorrect == true)
{
FlashCard fl = questions[currentQuiz].GetFlashCard();
if (!ManageUserAction.IsFlashCardExist(0, fl.IdCard))
{
AddFlashCard(fl);
}
wrongAns--;
}
}
private void lvWrongWord_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
curFlashCard = ManageSystem.SearchFlashCardEng(e.Item.SubItems[1].Text);
if (curFlashCard != null)
{
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
}
private void ToTheLeft()
{
if (index > 0)
{
index--;
}
else
{
index = curCollection.ListFL.Count - 1;
}
curFlashCard = curCollection.ListFL[index];
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
private void btnRight_Click(object sender, EventArgs e)
{
if (index < ManageSystem.CountAllFlashCards() - 1)
{
index++;
}
else
{
index = 0;
}
curFlashCard = ManageSystem.GetFlashCard(index);
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
private void ToTheRight()
{
if (index < curCollection.ListFL.Count - 1)
{
index++;
}
else
{
index = 0;
}
curFlashCard = curCollection.ListFL[index];
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
private void btnLeft_Click(object sender, EventArgs e)
{
if (index > 0)
{
index--;
}
else
{
index = ManageSystem.CountAllFlashCards() - 1;
}
curFlashCard = ManageSystem.GetFlashCard(index);
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
public LibraryForm()
{
InitializeComponent();
darkMode = ManageUserAction.GetDarkMode();
if (darkMode)
{
UpdateTheme();
}
this.KeyPreview = true;
ManageSystem.InitLibrary();
curFlashCard = ManageSystem.GetFlashCard(index);
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
InitAutoCompleteTextBox();
}
private void btnSearch_Click(object sender, EventArgs e)
{
int iTemp = SearchFlashCardEng(txtSearching.Text);
if (iTemp >= 0)
{
index = iTemp;
}
else
{
iTemp = SearchFlashCardVie(txtSearching.Text);
if (iTemp >= 0)
{
index = iTemp;
}
}
curFlashCard = curCollection.ListFL[index];
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
// KHỞI TẠO THƯ VIỆN CÁC FLASHCARDS
public static void InitLibrary()
{
if (CheckForInternetConnection())
{
allFlashCards.Clear();
SqlConnection connection = new SqlConnection(connString);
try
{
connection.Open();
//Chuan bi cau lenh query viet bang SQL
String sqlQuery = "select * from FLASHCARD";
//Tao mot Sqlcommand de thuc hien cau lenh truy van da chuan bi voi ket noi hien tai
SqlCommand command = new SqlCommand(sqlQuery, connection);
//Thuc hien cau truy van va nhan ve mot doi tuong reader ho tro do du lieu
SqlDataReader reader = command.ExecuteReader();
//Su dung reader de doc tung dong du lieu va cho vao list allFlashCards
while (reader.HasRows)
{
if (reader.Read() == false)
{
break;
}
FlashCard f = new FlashCard(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4));
allFlashCards.Add(f);
}
}
finally
{
connection.Close();
}
}
else
{
MessageBox.Show("Kết nối có vấn đề!");
}
}
// CONNECT ĐẾN DATABASE ĐỂ LOAD REVISE FLASHCARD
public static void UpdateReFlashCard(int idUser)
{
SqlConnection connection = new SqlConnection(constr);
try
{
//Mo ket noi
connection.Open();
//Chuan bi cau lenh query viet bang SQL
String sqlQuery = "select fl.ID, fl.ENG, fl.VIE, fl.PRONUNCIATION, fl.FIELD from FLASHCARD fl, USER_FLASHCARD u_fl where u_fl.ID_CARD = fl.ID and u_fl.ID_USER = "******"Ket noi xay ra loi hoac doc du lieu bi loi");
}
finally
{
//Dong ket noi sau khi thao tac ket thuc
connection.Close();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
FlashCard fl = ManageSystem.SearchFlashCardEng(txtSearching.Text);
if (fl != null)
{
index = fl.IdCard;
}
else
{
fl = ManageSystem.SearchFlashCardVie(txtSearching.Text);
if (fl != null)
{
index = fl.IdCard;
}
else
{
return;
}
}
curFlashCard = ManageSystem.GetFlashCard(index);
ChangeFlashCard(curFlashCard.Eng, curFlashCard.IdCard);
}
public static void DeleteFlashCardFromDatabase(int idCollection, FlashCard fl)
{
SqlConnection connection = new SqlConnection(constr);
try
{
//Mo ket noi
connection.Open();
//Chuan bi cau lenh query viet bang SQL
String sqlQuery = "delete from USER_FLASHCARD where ID_CARD = @ID_CARD and ID_USER = @ID_USER and ID_COLLECTION = @ID_COLLECTION";
//Tao mot Sqlcommand de thuc hien cau lenh truy van da chuan bi voi ket noi hien tai
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.AddWithValue("@ID_CARD", fl.IdCard);
command.Parameters.AddWithValue("@ID_USER", currentUser.IdUser);
command.Parameters.AddWithValue("@ID_COLLECTION", idCollection);
//Thuc hien cau truy van va nhan ve mot doi tuong reader ho tro do du lieu
int rs = command.ExecuteNonQuery();
//Su dung reader de doc tung dong du lieu
//va thuc hien thao tac xu ly mong muon voi du lieu doc len
if (rs != 1)
{
throw new Exception("Failed Query");
}
}
catch (InvalidCastException)
{
//xu ly khi ket noi co van de
MessageBox.Show("Ket noi xay ra loi hoac doc du lieu bi loi");
}
finally
{
//Dong ket noi sau khi thao tac ket thuc
connection.Close();
}
}
// CONNECT ĐẾN DATABASE ĐỂ LOAD MAIN FLASHCARD
public static int UpdateMainFlashCard(int currentTopic)
{
mainFlashCard.Clear();
string nameTopic = null;
switch (currentTopic)
{
case 1:
nameTopic = "Animals"; //
break;
case 2:
nameTopic = "Plants";
break;
case 3:
nameTopic = "Fruits";
break;
case 4:
nameTopic = "Job";
break;
case 5:
nameTopic = "Food and Drinks"; // khac
break;
case 6:
nameTopic = "Sport"; // khac
break;
case 7:
nameTopic = "Clothing"; //
break;
case 8:
nameTopic = "Technology"; //
break;
}
SqlConnection connection = new SqlConnection(constr);
try
{
//Mo ket noi
connection.Open();
//Chuan bi cau lenh query viet bang SQL
String sqlQuery = "select top 10 * from FLASHCARD fl_m where not exists(select fl.ID from FLASHCARD fl, USER_FLASHCARD u_fl where u_fl.ID_CARD = fl.ID and fl.ID = fl_m.ID and u_fl.ID_USER = "******" and u_fl.ID_COLLECTION = 0) and fl_m.FIELD = '" + nameTopic + "' order by NEWID()";
//Tao mot Sqlcommand de thuc hien cau lenh truy van da chuan bi voi ket noi hien tai
SqlCommand command = new SqlCommand(sqlQuery, connection);
//Thuc hien cau truy van va nhan ve mot doi tuong reader ho tro do du lieu
SqlDataReader reader = command.ExecuteReader();
//Su dung reader de doc tung dong du lieu //va thuc hien thao tac xu ly mong muon voi du lieu doc len
while (reader.HasRows)
{
if (reader.Read() == false)
{
break;
}
FlashCard fl = new FlashCard(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4));
mainFlashCard.Add(fl);
}
}
catch (InvalidCastException)
{
//xu ly khi ket noi co van de
MessageBox.Show("Ket noi xay ra loi hoac doc du lieu bi loi");
}
finally
{
//Dong ket noi sau khi thao tac ket thuc
connection.Close();
}
if (mainFlashCard.Count == 0)
{
return(0);
}
return(1);
}
public Quiz(FlashCard fl)
{
this.fl = fl;
}
private void AddFlashCard(FlashCard fl)
{
ManageUserAction.AddFlashCardToCollection(0, fl);
ManageUserAction.AddFlashCardToDatabase(0, ManageUserAction.GetItemOfAllCollection(0).NameCollection, fl);
}
public static void AddFlashCardToCollection(int idCollection, FlashCard fl)
{
allCollections[idCollection].ListFL.Add(fl);
}
public static void RemoveFlashCardFromCollection(int idCollection, FlashCard fl)
{
allCollections[idCollection].ListFL.Remove(fl);
}
