public PracticeDetail GetPracticeDetailsByPracticeDetailID(int practiceDetailID)
{
PracticeDetail currentPracticeDetail;
string query = "SELECT * FROM PracticeDetail WHERE PracticeDetailID = @practiceDetailID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@practiceDetailID",
Value = practiceDetailID
}
});
SqlDataReader reader = h.MyExecuteReader(query);
reader.Read();
currentPracticeDetail = new PracticeDetail()
{
PracticeDetailID = (int)reader["PracticeDetailID"],
PracticeID = (Guid)reader["PracticeID"],
WordPoolID = (Guid)reader["WordPoolID"],
WordID = (Guid)reader["WordID"],
IsSuccess = (bool)reader["IsSuccess"]
};
reader.Close();
return(currentPracticeDetail);
}
public List <PracticeDetail> GetAllPracticeDetails()
{
List <PracticeDetail> allPracticeDetails = new List <PracticeDetail>();
string query = "SELECT * FROM PracticeDetail";
SqlDataReader reader = h.MyExecuteReader(query);
PracticeDetail currentPracticeDetail;
while (reader.Read())
{
currentPracticeDetail = new PracticeDetail()
{
PracticeDetailID = (int)reader["PracticeDetailID"],
PracticeID = (Guid)reader["PracticeID"],
WordPoolID = (Guid)reader["WordPoolID"],
WordID = (Guid)reader["WordID"],
IsSuccess = (bool)reader["IsSuccess"]
};
allPracticeDetails.Add(currentPracticeDetail);
}
reader.Close();
return(allPracticeDetails);
}
public int Insert(PracticeDetail practiceDetail)
{
string query = "INSERT [PracticeDetail] VALUES (@practiceID,@wordPoolID,@wordID,@isSuccess)";
List <SqlParameter> parameters = GetParameters(practiceDetail);
h.AddParametersToCommand(parameters);
return(h.MyExecuteNonQuery(query));
}
private void InsertToPracticeDetail(bool isSucces, Dictionary word)
{
practiceDetail = new PracticeDetail()
{
IsSuccess = isSucces,
WordID = word.WordID,
WordPoolID = wordPool.WordPoolID,
PracticeID = practice.PracticeID
};
_practiceDetailController.Add(practiceDetail);
}
private List <SqlParameter> GetParameters(PracticeDetail practiceDetail)
{
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@practiceID", practiceDetail.PracticeID),
new SqlParameter("@wordPoolID", practiceDetail.WordPoolID),
new SqlParameter("@wordID", practiceDetail.WordID),
new SqlParameter("@isSuccess", practiceDetail.IsSuccess)
};
return(parameters);
}
public List <PracticeDetail> GetPracticeDetailsByWordPoolID(Guid wordPoolID)
{
List <PracticeDetail> allPracticeDetails = new List <PracticeDetail>();
string query = "SELECT * FROM PracticeDetail WHERE WordPoolID = @wordPoolID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@wordPoolID",
Value = wordPoolID
}
});
SqlDataReader reader = h.MyExecuteReader(query);
PracticeDetail currentPracticeDetail;
while (reader.Read())
{
currentPracticeDetail = new PracticeDetail()
{
PracticeDetailID = (int)reader["PracticeDetailID"],
PracticeID = (Guid)reader["PracticeID"],
WordPoolID = (Guid)reader["WordPoolID"],
WordID = (Guid)reader["WordID"],
IsSuccess = (bool)reader["IsSuccess"]
};
allPracticeDetails.Add(currentPracticeDetail);
}
reader.Close();
return(allPracticeDetails);
}
//public bool Add(PracticeDetail practiceDetail, PracticeDetailDTO practiceDetailDto)
//{
// List<PracticeDetail> practicedetail = _practiceDetailManagement.GetAllPracticeDetails();
// practiceDetail.PracticeID = practiceDetailDto.PracticeID;
// practiceDetail.WordPoolID = practiceDetailDto.WordPoolID;
// practiceDetail.WordID = practiceDetailDto.WordID;
// return _practiceDetailManagement.Insert(practiceDetail) > 0;
//}
public bool Add(PracticeDetail practiceDetail)
{
return(_practiceDetailManagement.Insert(practiceDetail) > 0);
}