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