public List <WordPool> GetAllWordPoolsByUserID(Guid userID)//user için { List <WordPool> wordPools = new List <WordPool>(); WordPool currentWordPool = null; string query = "SELECT * FROM WordPool WHERE UserID=@UserID"; h.AddParametersToCommand(new List <SqlParameter> { new SqlParameter() { ParameterName = "@UserID", Value = userID } }); SqlDataReader reader = h.MyExecuteReader(query); while (reader.Read()) { currentWordPool = new WordPool(); currentWordPool.WordPoolID = (Guid)reader["WordPoolID"]; currentWordPool.UserID = (Guid)reader["UserID"]; currentWordPool.Name = reader["Name"].ToString(); currentWordPool.CreatedDate = (DateTime)reader["CreatedDate"]; currentWordPool.IsActive = (bool)reader["IsActive"]; wordPools.Add(currentWordPool); } reader.Close(); return(wordPools); }
private void button2_Click(object sender, EventArgs e) { if (lstBoxAllPools.SelectedIndex > -1) { DialogResult dialogResult = MessageBox.Show("DELETE SELECTED POOL", "Attention", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { wordPool = (WordPool)lstBoxAllPools.SelectedItem; lblPoolName.Text = wordPool.Name; try { if (_wordPoolController.DeletePool(wordPool)) { MessageBox.Show($"{wordPool.Name} Pool has deleted succesfuly"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } RefreshAllPoolListBox(); } else if (dialogResult == DialogResult.No) { //do something else } } lstViewMyPool.Items.Clear(); }
public List <WordPool> GetAllMyActiveWordPools(Guid UserID) //user için { List <WordPool> wordPools = new List <WordPool>(); WordPool currentWordPool = null; string query = @"SELECT * FROM WordPool WHERE IsActive=@isActive AND UserID = @userID"; h.AddParametersToCommand(new List <SqlParameter>() { new SqlParameter() { ParameterName = "@isActive", Value = true }, new SqlParameter() { ParameterName = "@userID", Value = UserID } }); SqlDataReader reader = h.MyExecuteReader(query); while (reader.Read()) { currentWordPool = new WordPool(); currentWordPool.WordPoolID = (Guid)reader["WordPoolID"]; currentWordPool.UserID = (Guid)reader["UserID"]; currentWordPool.Name = reader["Name"].ToString(); currentWordPool.CreatedDate = (DateTime)reader["CreatedDate"]; currentWordPool.IsActive = Convert.ToBoolean(reader["IsActive"]); wordPools.Add(currentWordPool); } reader.Close(); return(wordPools); }
public int Update(WordPool wordPool) { string query = "UPDATE WordPool SET Name=@Name,IsActive=@IsActive WHERE WordPoolID=@WordPoolID"; List <SqlParameter> parameters = GetParameters(wordPool, false); h.AddParametersToCommand(parameters); return(h.MyExecuteNonQuery(query)); }
public int Insert(WordPool wordPool) { string query = "INSERT INTO WordPool(WordPoolID,UserID,Name,CreatedDate,IsActive) VALUES (@WordPoolID,@UserID,@Name,@CreatedDate,@IsActive)"; List <SqlParameter> parameters = GetParameters(wordPool, true); h.AddParametersToCommand(parameters); return(h.MyExecuteNonQuery(query)); }
public frmAddWordToPool(User currentUser, WordPool currentPool) { InitializeComponent(); _dictionaryController = new DictionaryController(); _wordPoolController = new WordPoolController(); _wordPoolDetailController = new WordPoolDetailController(); user = currentUser; wordPool = currentPool; }
private void Guess() { if (!string.IsNullOrWhiteSpace(CurrentWord)) { var candidates = WordPool.Where(word => word.StartsWith(CurrentWord.Trim().ToLower())); CanGuess = candidates.Any(); BestGuess = CanGuess ? candidates.First() : string.Empty; } }
private void lstBoxAllPools_SelectedValueChanged(object sender, EventArgs e) { lstViewMyPool.Items.Clear(); if (lstBoxAllPools.SelectedIndex > -1) { wordPool = (WordPool)lstBoxAllPools.SelectedItem; lblPoolName.Text = wordPool.Name; RefreshListVİewMyPool(wordPool); } }
private void btnSave_Click(object sender, EventArgs e) { if (m_selRow == -1) { MessageBox.Show("Выберите чугун из имеющихся миксеров"); return; } WordPool<double> wpIron = new WordPool<double>(0.0); WordPool<double> wpProps = new WordPool<double>(0.0); int cntMix = 0; for (var i = 2; i < dgw.Rows[m_selRow].Cells.Count; i++) { string key = dgw.Columns[i].HeaderText; wpIron.SetWord(key, (double)dgw.Rows[m_selRow].Cells[i].Value); } for (int i = Program.face.ch_Iron.m_propsStart; i < Program.face.ch_Iron.gridChem.RowCount; i++) { wpProps.SetWord((string)Program.face.ch_Iron.gridChem.Rows[i].Cells[0].Value, (double)Program.face.ch_Iron.gridChem.Rows[i].Cells[1].Value); } Program.face.ch_Iron.m_inFP.Clear(); Program.face.ch_Iron.gridChem.Rows.Clear(); Program.face.ch_Iron.gridChem.RowCount = wpIron.Count; for (var rowCnt = 0; rowCnt < Program.face.ch_Iron.gridChem.RowCount; rowCnt++) { Program.face.ch_Iron.gridChem.Rows[rowCnt].Cells[0].Value = wpIron.ElementAt(rowCnt).Key; Program.face.ch_Iron.gridChem.Rows[rowCnt].Cells[1].Value = wpIron.ElementAt(rowCnt).Value; Program.face.ch_Iron.m_inFP.SetWord(wpIron.ElementAt(rowCnt).Key, wpIron.ElementAt(rowCnt).Value); } Program.face.ch_Iron.m_propsStart = Program.face.ch_Iron.gridChem.RowCount; if (wpProps.Count > 0) { Program.face.ch_Iron.gridChem.Rows.Add(wpProps.Count); for (var rowCnt = Program.face.ch_Iron.m_propsStart; rowCnt < Program.face.ch_Iron.gridChem.RowCount; rowCnt++) { Program.face.ch_Iron.gridChem.Rows[rowCnt].Cells[0].Value = wpProps.ElementAt(rowCnt - Program.face.ch_Iron.m_propsStart).Key; Program.face.ch_Iron.gridChem.Rows[rowCnt].Cells[1].Value = wpProps.ElementAt(rowCnt - Program.face.ch_Iron.m_propsStart).Value; Program.face.ch_Iron.m_inFP.SetWord(wpProps.ElementAt(rowCnt - Program.face.ch_Iron.m_propsStart).Key, wpProps.ElementAt(rowCnt - Program.face.ch_Iron.m_propsStart).Value); } } Program.face.ch_Iron.m_readOnLoad = false; Close(); }
public frmUserPractice(User currentUser, WordPool CurrentWordPool, Practice currentPractice) { InitializeComponent(); this.ControlBox = false; _wordPoolDetailController = new WordPoolDetailController(); _practiceDetailController = new PracticeDetailController(); _practiceController = new PracticeController(); user = currentUser; practice = currentPractice; wordPool = CurrentWordPool; alreadyIndexed = new List <int>(); }
List <SqlParameter> GetParameters(WordPool wordPool, bool isInsert) { List <SqlParameter> parameters = new List <SqlParameter>(); if (isInsert) { parameters.Add(new SqlParameter("@UserID", wordPool.UserID)); parameters.Add(new SqlParameter("@CreatedDate", wordPool.CreatedDate)); } parameters.Add(new SqlParameter("@WordPoolID", wordPool.WordPoolID)); parameters.Add(new SqlParameter("@Name", wordPool.Name)); parameters.Add(new SqlParameter("@IsActive", wordPool.IsActive)); return(parameters); }
private void RefreshListVİewMyPool(WordPool wordPool) { lstMyDictionary.Items.Clear(); ListViewItem lvi; List <Dictionary> myActiveWords = _wordPoolDetailController.GetMyActiveWordsByWordPool(wordPool.WordPoolID); foreach (Dictionary item in myActiveWords) { lvi = new ListViewItem(item.English); lvi.SubItems.Add(item.Turkish); lvi.Tag = item; lstMyDictionary.Items.Add(lvi); } }
public bool Add(WordPool wordPool) { try { ControlPoolName(wordPool.Name); } catch (Exception ex) { throw ex; } wordPool.WordPoolID = Guid.NewGuid(); wordPool.IsActive = true; wordPool.CreatedDate = DateTime.Now; return(_wordPoolManagement.Insert(wordPool) > 0); }
private void btnCreateNewPool_Click(object sender, EventArgs e) { WordPool wordPool = new WordPool() { Name = txtPoolName.Text, UserID = user.UserID }; try { _wordPoolController.Add(wordPool); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Pool has succesfully created."); this.Close(); }
void RefreshMyWords() { lstInWords.Items.Clear(); if (lstMyPools.SelectedIndex > -1) { ListViewItem lvi; wordPool = (WordPool)lstMyPools.SelectedItem; List <Dictionary> activeWords = _wordPoolDetailController.GetMyActiveWordsByWordPool(wordPool.WordPoolID); foreach (Dictionary item in activeWords) { lvi = new ListViewItem(item.English); lvi.SubItems.Add(item.Turkish); lvi.Tag = item; lstInWords.Items.Add(lvi); } } }
//public WordPool GetWordPoolByUserID() //kullanıcı için //{ // WordPool currentWordPool = new WordPool(); // string query = "SELECT * FROM WordPool WHERE UserID=@UserID"; // h.AddParametersToCommand(new List<SqlParameter> // { // new SqlParameter() // { // ParameterName="@UserID",Value=UserID // } // }); // SqlDataReader reader = h.MyExecuteReader(query); // reader.Read(); // currentWordPool.WordPoolID = (Guid)reader["WordPoolID"]; // currentWordPool.UserID = UserID; // currentWordPool.Name = reader["Name"].ToString(); // currentWordPool.CreatedDate = (DateTime)reader["CreatedDate"]; // currentWordPool.IsActive = (bool)reader["IsActive"]; // reader.Close(); // return currentWordPool; //} public List <WordPool> GetAllWordPools()//admin için { List <WordPool> wordPools = new List <WordPool>(); WordPool currentWordPool = null; string query = "SELECT * FROM WordPool"; SqlDataReader reader = h.MyExecuteReader(query); while (reader.Read()) { currentWordPool = new WordPool(); currentWordPool.WordPoolID = (Guid)reader["WordPoolID"]; currentWordPool.UserID = (Guid)reader["UserID"]; currentWordPool.Name = reader["Name"].ToString(); currentWordPool.CreatedDate = (DateTime)reader["CreatedDate"]; currentWordPool.IsActive = Convert.ToBoolean(reader["IsActive"]); wordPools.Add(currentWordPool); } reader.Close(); return(wordPools); }
public WordPool GetWordPoolByWordPoolID(Guid wordPoolID) { WordPool currentWordPool = new WordPool(); string query = "SELECT * FROM WordPool WHERE WordPoolID=@WordPoolID"; h.AddParametersToCommand(new List <SqlParameter> { new SqlParameter() { ParameterName = "@WordPoolID", Value = wordPoolID } }); SqlDataReader reader = h.MyExecuteReader(query); reader.Read(); currentWordPool.WordPoolID = wordPoolID; currentWordPool.UserID = (Guid)reader["UserID"]; currentWordPool.Name = reader["Name"].ToString(); currentWordPool.CreatedDate = (DateTime)reader["CreatedDate"]; currentWordPool.IsActive = (bool)reader["IsActive"]; reader.Close(); return(currentWordPool); }
public bool DeletePool(WordPool wordPool) { wordPool.IsActive = false; return(_wordPoolManagement.Update(wordPool) > 0); }
public bool UpdateName(WordPool wordPool) { return(_wordPoolManagement.Update(wordPool) > 0); }
private void btnSave_Click(object sender, EventArgs e) { //MessageBox.Show(string.Format("Sum {0}", countScrapShares())); #if DB_IS_ORACLE Program.OraCmd.CommandText = "SELECT " + "ELEMENT.NAME, ELEMENT.\"VALUE\" " + "FROM ELEMENT, SCRAP " + "WHERE ELEMENT.SID = SCRAP.ID AND (SCRAP.CODE = :C)"; Program.OraCmd.Parameters.Clear(); Program.OraCmd.Parameters.Add(new OracleParameter("C", OracleDbType.Int16, System.Data.ParameterDirection.Input)); #else ScrapDataSetTableAdapters.ScrapMixerTableAdapter ada = new ScrapMixerTableAdapter(); ScrapDataSet.ScrapMixerDataTable tbl = new ScrapDataSet.ScrapMixerDataTable(); #endif WordPool<double> wpProps = new WordPool<double>(0.0); WordPool<double> wpTotal = new WordPool<double>(0.0); for (int i = 0; i < gridScrap.RowCount; i++) { if (gridScrap.Rows[i].Cells[1].Value == null) break; short code = Convert.ToInt16(gridScrap.Rows[i].Cells[1].Value); short shares = Convert.ToInt16(gridScrap.Rows[i].Cells[0].Value); #if DB_IS_ORACLE Program.OraCmd.Parameters["C"].Value = code; if (Program.OraCmd.Connection.State != System.Data.ConnectionState.Closed) { Program.OraCmd.Connection.Close(); } Program.OraCmd.Connection.Open(); Program.OraReader = Program.OraCmd.ExecuteReader(); if (Program.OraReader.HasRows) { while (Program.OraReader.Read()) { string key = Convert.ToString(Program.OraReader[0]); double val = Convert.ToDouble(Program.OraReader[1]); wpTotal.SetWord(key, wpTotal.GetWord(key) + shares * val); } } #else try { ada.Connection.ConnectionString = "Data Source=Chemistry.sdf"; ada.FillByCode(tbl, code); } catch (Exception) { } ; for (int j = 0; j < tbl.Count; j++) { string key = tbl[j].Name; wpTotal.SetWord(key, wpTotal.GetWord(key) + shares * tbl[j].Value); } #endif } double scaleFactor = 1.0 / countScrapShares(); for (int k = 0; k < wpTotal.Count; k++) { wpTotal.SetWord(wpTotal.ElementAt(k).Key, scaleFactor * wpTotal.ElementAt(k).Value); } for (int i = Program.face.ch_Scrap.m_propsStart; i < Program.face.ch_Scrap.gridChem.RowCount; i++) { wpProps.SetWord((string)Program.face.ch_Scrap.gridChem.Rows[i].Cells[0].Value, (double)Program.face.ch_Scrap.gridChem.Rows[i].Cells[1].Value); } Program.face.ch_Scrap.m_inFP.Clear(); Program.face.ch_Scrap.gridChem.Rows.Clear(); Program.face.ch_Scrap.gridChem.RowCount = wpTotal.Count; for (var rowCnt = 0; rowCnt < Program.face.ch_Scrap.gridChem.RowCount; rowCnt++) { Program.face.ch_Scrap.gridChem.Rows[rowCnt].Cells[0].Value = wpTotal.ElementAt(rowCnt).Key; Program.face.ch_Scrap.gridChem.Rows[rowCnt].Cells[1].Value = wpTotal.ElementAt(rowCnt).Value; Program.face.ch_Scrap.m_inFP.SetWord(wpTotal.ElementAt(rowCnt).Key, wpTotal.ElementAt(rowCnt).Value); } Program.face.ch_Scrap.m_propsStart = Program.face.ch_Scrap.gridChem.RowCount; if (wpProps.Count > 0) { Program.face.ch_Scrap.gridChem.Rows.Add(wpProps.Count); for (var rowCnt = Program.face.ch_Scrap.m_propsStart; rowCnt < Program.face.ch_Scrap.gridChem.RowCount; rowCnt++) { Program.face.ch_Scrap.gridChem.Rows[rowCnt].Cells[0].Value = wpProps.ElementAt(rowCnt - Program.face.ch_Scrap.m_propsStart).Key; Program.face.ch_Scrap.gridChem.Rows[rowCnt].Cells[1].Value = wpProps.ElementAt(rowCnt - Program.face.ch_Scrap.m_propsStart).Value; Program.face.ch_Scrap.m_inFP.SetWord(wpProps.ElementAt(rowCnt - Program.face.ch_Scrap.m_propsStart).Key, wpProps.ElementAt(rowCnt - Program.face.ch_Scrap.m_propsStart).Value); } } Program.face.ch_Scrap.m_readOnLoad = false; Close(); }