public List <WordPoolDetail> GetWordPoolDetailByWordPoolID(Guid wordPoolID)
{
List <WordPoolDetail> WordPoolDetailList = new List <WordPoolDetail>();
string query = "SELECT * FROM WordPoolDetail WHERE WordPoolID=@WordPoolID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@WordPoolID", Value = wordPoolID
}
});
WordPoolDetail currentWordPoolDetail;
SqlDataReader reader = h.MyExecuteReader(query);
while (reader.Read())
{
currentWordPoolDetail = new WordPoolDetail();
currentWordPoolDetail.WordPoolID = wordPoolID;
currentWordPoolDetail.WordID = (Guid)reader["WordID"];
currentWordPoolDetail.IsActive = (bool)reader["IsActive"];
currentWordPoolDetail.CreatedDate = (DateTime)reader["CreatedDate"];
WordPoolDetailList.Add(currentWordPoolDetail);
}
reader.Close();
return(WordPoolDetailList);
}
/// <summary>
/// Havuz zaten o kelimeyi içeriyorsa TRUE döner.
/// </summary>
/// <param name="wordPoolDetail"></param>
/// <returns></returns>
public bool IsPoolContainsAlready(WordPoolDetail wordPoolDetail)
{
string query = "SELECT * FROM WordPoolDetail WHERE WordPoolID=@WordPoolID AND WordID=@WordID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@WordPoolID",
Value = wordPoolDetail.WordPoolID
},
new SqlParameter()
{
ParameterName = "@WordID",
Value = wordPoolDetail.WordID
}
});
SqlDataReader reader = h.MyExecuteReader(query);
bool isContain = reader.HasRows;
reader.Close();
if (isContain)
{
return(true);
}
return(false);
}
public bool Delete(WordPoolDetail wordPoolDetail)
{
wordPoolDetail.IsActive = false;
int result = _wordPoolDetailManagement.Update(wordPoolDetail);
return(result > 0);
}
private void btnAdd_Click(object sender, EventArgs e)
{
WordPoolDetail wordPoolDetail;
if (lstDictionary.SelectedIndices[0] > -1)
{
if (_wordPoolDetailController.GetMyActiveWordsByWordPool(wordPool.WordPoolID).Count > 9 && user.RoleID == 3)
{
}
else
{
dic = (Dictionary)lstDictionary.SelectedItems[0].Tag;
wordPoolDetail = new WordPoolDetail()
{
WordID = dic.WordID,
WordPoolID = wordPool.WordPoolID
};
_wordPoolDetailController.Add(wordPoolDetail);
RefreshListVİewMyPool(wordPool);
}
}
}
public int Update(WordPoolDetail wordPoolDetail)
{
string query = "UPDATE WordPoolDetail SET IsActive=@IsActive WHERE WordPoolID=@WordPoolID AND WordID=@WordID";
List <SqlParameter> sqlParameters = GetParameters(wordPoolDetail, false);
h.AddParametersToCommand(sqlParameters);
return(h.MyExecuteNonQuery(query));
}
public int Insert(WordPoolDetail wordPoolDetail)
{
string query = "INSERT INTO WordPoolDetail(WordPoolID,WordID,IsActive,CreatedDate) VALUES(@WordPoolID,@WordID,@IsActive,@CreatedDate)";
List <SqlParameter> sqlParameters = GetParameters(wordPoolDetail, true);
h.AddParametersToCommand(sqlParameters);
return(h.MyExecuteNonQuery(query));
}
public bool Update(WordPoolDetail wordPoolDetail)
{
wordPoolDetail.IsActive = true;
wordPoolDetail.CreatedDate = DateTime.Now;
int result = _wordPoolDetailManagement.Update(wordPoolDetail);
return(result > 0);
}
List <SqlParameter> GetParameters(WordPoolDetail wordPoolDetail, bool isInsert)
{
List <SqlParameter> parameters = new List <SqlParameter>();
if (isInsert)
{
parameters.Add(new SqlParameter("@CreatedDate", wordPoolDetail.CreatedDate));
}
parameters.Add(new SqlParameter("@WordPoolID", wordPoolDetail.WordPoolID));
parameters.Add(new SqlParameter("@WordID", wordPoolDetail.WordID));
parameters.Add(new SqlParameter("@IsActive", wordPoolDetail.IsActive));
return(parameters);
}
public bool Add(WordPoolDetail wordPoolDetail)
{
if (_wordPoolDetailManagement.IsPoolContainsAlready(wordPoolDetail))
{
return(Update(wordPoolDetail));
}
else
{
wordPoolDetail.IsActive = true;
wordPoolDetail.CreatedDate = DateTime.Now;
int result = _wordPoolDetailManagement.Insert(wordPoolDetail);
return(result > 0);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
WordPoolDetail wordPoolDetail;
if (lstMyDictionary.SelectedIndices.Count > 0)
{
dic = (Dictionary)lstMyDictionary.SelectedItems[0].Tag;
wordPoolDetail = new WordPoolDetail()
{
WordID = dic.WordID,
WordPoolID = wordPool.WordPoolID
};
_wordPoolDetailController.Delete(wordPoolDetail);
RefreshListVİewMyPool(wordPool);
}
}
public List <WordPoolDetail> GetAllWordPoolDetail()
{
List <WordPoolDetail> wordPoolDetails = new List <WordPoolDetail>();
WordPoolDetail currentWordPoolDetail = null;
string query = "SELECT * FROM WordPoolDetail";
SqlDataReader reader = h.MyExecuteReader(query);
while (reader.Read())
{
currentWordPoolDetail.WordPoolID = (Guid)reader["WordPoolID"];
currentWordPoolDetail.WordID = (Guid)reader["WordID"];
currentWordPoolDetail.IsActive = (bool)reader["IsActive"];
currentWordPoolDetail.CreatedDate = (DateTime)reader["CreatedDate"];
wordPoolDetails.Add(currentWordPoolDetail);
}
reader.Close();
return(wordPoolDetails);
}
