public bool Delete(HomeworkPlan homeworkPlan)
{
try
{
if (homeworkPlan != null)
{
using (var connection = new SqlConnection(Database.ConnectionString))
{
using (SqlCommand sqlCommand = new SqlCommand(Database.DELETEHOMEWORKPLAN, connection))
{
//setting command type to stored procedure
sqlCommand.CommandType = CommandType.StoredProcedure;
//Defining parameters for StoredProcedure
SqlParameter studentID = new SqlParameter("@StudentID", homeworkPlan.StudentID);
SqlParameter homeworkID = new SqlParameter("@HomeworkID", homeworkPlan.HomeworkID);
sqlCommand.Parameters.Add(studentID);
sqlCommand.Parameters.Add(homeworkID);
connection.Open();
int affectedRows = sqlCommand.ExecuteNonQuery();
if (affectedRows > 0)
{
return(true);
}
}
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
public HomeworkPlan GetHomeworkPlanByKey(int studentId, int homeworkId)
{
HomeworkPlan homeworkPlan;
try
{
DataSet dataSet = new DataSet();
//SqlConnection connection;
using (var connection = new SqlConnection(Database.ConnectionString))
{
using (SqlCommand sqlCommand = new SqlCommand(Database.GETENROLLMENTBYID, connection))
{
//setting command type to stored procedure
sqlCommand.CommandType = CommandType.StoredProcedure;
//Defining parameters for StoredProcedure
//Defining parameters for StoredProcedure
SqlParameter studentID = new SqlParameter("@StudentID", studentId);
SqlParameter homeworkID = new SqlParameter("@HomeworkID", homeworkId);
sqlCommand.Parameters.Add(studentID);
sqlCommand.Parameters.Add(homeworkID);
connection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
sqlDataAdapter.Fill(dataSet);
}
}
DataRow dataRowOfPlan = dataSet.Tables["Table"].AsEnumerable()
.Single(dataRow =>
dataRow.Field <int>("StudentID") == studentId && dataRow.Field <int>("HomeworkID") == homeworkId);
homeworkPlan = new HomeworkPlan
{
StudentID = dataRowOfPlan.Field <int>("StudentID"),
HomeworkID = dataRowOfPlan.Field <int>("HomeworkID"),
PriorityLevel = dataRowOfPlan.Field <int>("PriorityLevel"),
isCompleted = dataRowOfPlan.Field <bool>("isCompleted")
};
}
catch (Exception)
{
throw;
}
return(homeworkPlan);
}
public bool UpdateHomeworkPlan(HomeworkPlan plan)
{
try
{
if (plan != null)
{
HomeworkPlanRepo homeworkPlanRepo = new HomeworkPlanRepo();
if (homeworkPlanRepo.Update(plan))
{
return(true);
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
