public int DeleteRubric(RubricObject rubric)
{
try
{
string delQuery = "DELETE FROM [dbo].[rubric_tbl] WHERE rubricId = (@RubricId);";
sqlParameters = new List <SqlParameter>();
SqlParameter param1 = new SqlParameter("@RubricId", SqlDbType.Int, int.MaxValue, "rubricId");
param1.Value = rubric.RubricId;
sqlParameters.Add(param1);
if (param1.Value == null)
{
throw new MyException();
}
else
{
adminDataAccess = new DataAccess();
Task <int> task = Task.Run(() => adminDataAccess.ExecuteCommandAsync(delQuery, CommandType.Text, sqlParameters));
return(task.Result);
}
}
catch (Exception ex)
{
throw;
}
}
public int UpdateRubric(RubricObject rubric)
{
try
{
string updQuery = "$UPDATE [dbo].[rubric_tbl] SET rubricName = @RubricName, minGrade = @MinGrade, maxCriteria = @MaxGrade, averageGrade = @AverageGrade, maxCriteria = @MaxCriteria, classId = @Class where rubricId = @RubricId";
SqlParameter param1, param2, param3, param4, param5, param6;
param1 = new SqlParameter("@RubricName", SqlDbType.NVarChar, 50, "rubricName");
param1.Value = rubric.RubricName;
param2 = new SqlParameter("@MinGrade", SqlDbType.Int, int.MaxValue, "maxCriteria");
param2.Value = rubric.MinGrade;
param3 = new SqlParameter("@MaxGrade", SqlDbType.Int, int.MaxValue, "maxCriteria");
param3.Value = rubric.MaxGrade;
param4 = new SqlParameter("@MaxCriteria", SqlDbType.Int, int.MaxValue, "maxCriteria");
param4.Value = rubric.MaxCriteria;
param5 = new SqlParameter("@Class", SqlDbType.Int, int.MaxValue, "classId");
param5.Value = rubric.Class.ClassId;
param6 = new SqlParameter("@RubricId", SqlDbType.Int, int.MaxValue, "rubricId");
param6.Value = rubric.RubricId;
if (param6.Value == null)
{
throw new NullReferenceException();
}
else
{
sqlParameters = new List <SqlParameter>();
sqlParameters.Add(param1);
sqlParameters.Add(param2);
sqlParameters.Add(param3);
sqlParameters.Add(param4);
sqlParameters.Add(param5);
sqlParameters.Add(param6);
adminDataAccess = new DataAccess();
Task <int> task = Task.Run(() => adminDataAccess.ExecuteCommandAsync(updQuery, CommandType.Text, sqlParameters));
return(task.Result);
}
}
catch (Exception ex)
{
throw;
}
}
public int AddRubric(RubricObject rubric)
{
try
{
string insQuery = $"INSERT INTO [dbo].[rubric_tbl] (rubricName, minGrade, maxGrade, averageGrade, maxCriteria, classId) VALUES(@RubricName, @MinGrade, @MaxGrade, @AverageGrade,@MaxCriteria, @ClassId)";
SqlParameter param1, param2, param3, param4, param5, param6;
param1 = new SqlParameter("@RubricName", SqlDbType.NVarChar, 50, "rubricName");
param1.Value = rubric.RubricName;
param2 = new SqlParameter("@MinGrade", SqlDbType.Int, 50, "minGrade");
param2.Value = rubric.MinGrade;
param3 = new SqlParameter("@MaxGrade", SqlDbType.Int, 50, "maxGrade");
param3.Value = rubric.MaxGrade;
param4 = new SqlParameter("@AverageGrade", SqlDbType.Int, 50, "averageGrade");
param4.Value = rubric.AverageGrade;
param5 = new SqlParameter("@MaxCriteria", SqlDbType.Int, 50, "maxCriteria");
param5.Value = rubric.MaxCriteria;
param6 = new SqlParameter("@ClassId", SqlDbType.Int, int.MaxValue, "classId");
param6.Value = rubric.Class.ClassId;
sqlParameters = new List <SqlParameter>();
sqlParameters.Add(param1);
sqlParameters.Add(param2);
sqlParameters.Add(param3);
sqlParameters.Add(param4);
sqlParameters.Add(param5);
sqlParameters.Add(param6);
adminDataAccess = new DataAccess();
Task <int> task = Task.Run(() => adminDataAccess.ExecuteCommandAsync(insQuery, CommandType.Text, sqlParameters));
return(task.Result);
}
catch (Exception ex)
{
throw;
}
}
public RubricObject ViewRubric(int rubricId)
{
try
{
string sqlSelect = $"SELECT [rubricId] ,[rubricName] ,[minGrade] ,[maxGrade] ,[averageGrade] ,[maxCriteria] , r.[classId], cl.className FROM[dbo].[rubric_tbl] r join class_tbl cl on r.classId = cl.classId where rubricId = @RubricId;";
parameters = new List <ParameterList>();
parameters.Add(new ParameterList()
{
Key = "@RubricId", Value = rubricId
});
RubricObject rubricObj = new RubricObject();
adminDataAccess = new DataAccess();
Task <DataTable> task = Task.Run(() => adminDataAccess.GetDataAsync(sqlSelect, parameters));
rubricObj.RubricId = Convert.ToInt32(task.Result.Columns["rubricId"]);
rubricObj.RubricName = task.Result.Columns["rubricName"].ToString();
rubricObj.MinGrade = Convert.ToInt32(task.Result.Columns["minGrade"]);
rubricObj.MaxGrade = Convert.ToInt32(task.Result.Columns["maxGrade"]);
rubricObj.MaxCriteria = Convert.ToInt32(task.Result.Columns["maxCriteria"]);
rubricObj.Class.ClassId = Convert.ToInt32(task.Result.Columns["classId"]);
rubricObj.Class.ClassName = task.Result.Columns["className"].ToString();
if (rubricObj == null)
{
throw new NullReferenceException();
}
else
{
return(rubricObj);
}
}
catch (Exception ex)
{
throw;
}
}