private void OnLeftMouseClick()
{
Ray ray = Camera.main.ScreenPointToRay(Input.mousePosition);
RaycastHit hit;
if (Physics.Raycast(ray, out hit, Mathf.Infinity))
{
if (hit.transform.CompareTag("tower"))
{
if (Input.GetKey(KeyCode.G))
{
Time.timeScale = 0;
currentGradeInfo = hit.transform.GetComponent <GradeInfo>();
currentGradeItem = currentGradeInfo.GetCurrentGrade();
currentTower = hit.transform.GetComponent <ITower>();
if (currentGradeItem != null)
{
LoadAllInfo();
}
else
{
ShowOffDialog();
}
}
}
}
}
public ActionResult Uploaded()
{
if (TempData["fileName"] != null && TempData["GradeDistributionID"] != null)
{
string fileName = (string)TempData["fileName"];
int GradeDistID = (int)TempData["GradeDistributionID"];
var engine = new FileHelperEngine <GradeItemVM>();
var records = engine.ReadFile(fileName);
//List<GradeItem> enrols = new List<GradeItem>();
int assessTypeId;
foreach (var rec in records)
{
assessTypeId = db.AssessmentTypes.Where(x => x.Type == rec.AssessType).FirstOrDefault().AssessmentTypeID;
var GrItem = new GradeItem()
{
AssessmentTypeID = assessTypeId, AssessmentTNo = rec.Number, CrNo = rec.Criterion, GradeDistributionID = GradeDistID, Weight = rec.Weight, Name = rec.Code
};
db.GradeItems.Add(GrItem);
db.SaveChanges();
//enrols.Add(enrol);
}
//db.Enrollments.AddRange(enrols);
//db.SaveChanges();
return(View(records));
}
return(View());
}
public void TestGradeItemConstructor()
{
Student student = new Student("student", "*****@*****.**");
string name = "Homework 1";
double gradeEarned = 30;
string feedback = "You failed.";
double gradePossible = 100;
string gradeType = "homework";
string description = "The first homework";
int gradeID = 1;
DateTime timeGraded = DateTime.Now;
bool isPublic = true;
GradeItem grade = new GradeItem(name, student, gradeEarned, feedback, gradePossible, gradeType, description, gradeID, isPublic, timeGraded);
Assert.AreEqual(grade.Name, name);
Assert.AreEqual(grade.Student, student);
Assert.AreEqual(grade.Grade, gradeEarned);
Assert.AreEqual(grade.Feedback, feedback);
Assert.AreEqual(grade.PossiblePoints, gradePossible);
Assert.AreEqual(grade.GradeType, gradeType);
Assert.AreEqual(grade.Description, description);
Assert.AreEqual(grade.GradeId, gradeID);
Assert.AreEqual(grade.TimeGraded, timeGraded);
}
/// <summary>
/// Grades the graded item by CRN and student uid.
/// </summary>
/// <param name="newItem">The new item.</param>
/// <param name="CRN">The CRN.</param>
/// <param name="studentUID">The student uid.</param>
public void gradeGradedItemByCRNAndStudentUID(GradeItem newItem, int CRN, string studentUID)
{
StudentDAL studentGetter = new StudentDAL();
Student currStudent = studentGetter.GetStudentByStudentID(studentUID);
MySqlConnection dbConnection = DbConnection.GetConnection();
using (dbConnection)
{
dbConnection.Open();
GradeItem grade = new GradeItem(newItem.Name, currStudent, newItem.Grade, newItem.Feedback, newItem.PossiblePoints, newItem.GradeType, newItem.Description, 0, newItem.IsPublic, newItem.TimeGraded);
var selectQuery =
"UPDATE student_grade_items SET grade_earned_points=@grade_earned_points, grade_feedback=@grade_feedback, time_graded=@time_graded WHERE student_uid = @studentUID AND student_grade_items.grade_def_id = (SELECT grade_defs.grade_def_id FROM grade_defs WHERE grade_defs.grade_name = @grade_name AND grade_defs.course_CRN = @CRNCheck)";
using (MySqlCommand cmd = new MySqlCommand(selectQuery, dbConnection))
{
cmd.Parameters.AddWithValue("@studentUID", studentUID);
cmd.Parameters.AddWithValue("@grade_earned_points", grade.Grade);
cmd.Parameters.AddWithValue("@grade_name", grade.Name);
cmd.Parameters.AddWithValue("@grade_feedback", grade.Feedback);
cmd.Parameters.AddWithValue("@time_graded", DateTime.Now);
cmd.Parameters.AddWithValue("@CRNCheck", CRN);
cmd.ExecuteNonQuery();
}
}
dbConnection.Close();
}
public async Task <IActionResult> PutGradeItem([FromRoute] int id, [FromBody] GradeItem gradeItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != gradeItem.Id)
{
return(BadRequest());
}
_context.Entry(gradeItem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GradeItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
GradeItem gradeItem = db.GradeItems.Find(id);
db.GradeItems.Remove(gradeItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void handleWhenGradeITemNotExists()
{
var assignmentName = this.tbxAssignmentName.Text;
var possiblePoints = Convert.ToInt32(this.tbxPossiblePoints.Text);
var gradeType = this.ddlAssignmentType.SelectedValue;
GradeItem item = new GradeItem(assignmentName, null, 0, string.Empty, possiblePoints, gradeType, String.Empty, 0, this.cbxIsVisible.Checked, null);
this.GradeDAL.InsertNewGradedItemByCRNForAllStudents(item, int.Parse(this.ddlCourses.SelectedValue));
}
/// <summary>
/// Initializes a new instance of the <see cref="GradeItemGradeDisplay"/> class.
/// </summary>
/// <param name="gradeItem">The grade item.</param>
/// <param name="ungradedItems">The ungraded items.</param>
/// <param name="gradedItems">The graded items.</param>
public GradeItemGradeDisplay(GradeItem gradeItem, List <GradeItemGrade> ungradedItems, List <GradeItemGrade> gradedItems)
{
this.GradeItem = gradeItem;
this.Name = gradeItem.Name;
this.UngradedItems = ungradedItems;
this.GradedItems = gradedItems;
this.UngradedCount = ungradedItems.Count;
this.GradedCount = gradedItems.Count;
}
/// <summary>
/// Gets the graded item by CRN and grade name.
/// </summary>
/// <param name="CRNCheck">The CRN check.</param>
/// <param name="gradeName">Name of the grade.</param>
/// <returns>A graded Item by crn and name of the grade</returns>
public GradeItem GetGradedItemByCRNAndGradeName(int CRNCheck, string gradeName)
{
MySqlConnection dbConnection = DbConnection.GetConnection();
GradeItem grade = null;
using (dbConnection)
{
dbConnection.Open();
var selectQuery =
"SELECT * FROM grade_defs WHERE grade_defs.course_CRN = @CRNCheck AND grade_name = @grade_name";
using (MySqlCommand cmd = new MySqlCommand(selectQuery, dbConnection))
{
cmd.Parameters.AddWithValue("@CRNCheck", CRNCheck);
cmd.Parameters.AddWithValue("@grade_name", gradeName);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int gradeDescriptionOrdinal = reader.GetOrdinal("grade_description");
int totalPointsOrdinal = reader.GetOrdinal("grade_total_points");
int gradeTypeOrdinal = reader.GetOrdinal("grade_type");
int gradeItemIdOrdinal = reader.GetOrdinal("grade_def_id");
int isPublicOrdinal = reader.GetOrdinal("is_public");
while (reader.Read())
{
var gradeDescription = reader[gradeDescriptionOrdinal] == DBNull.Value
? default(string)
: reader.GetString(gradeDescriptionOrdinal);
var totalPoints = reader[totalPointsOrdinal] == DBNull.Value
? default(int)
: reader.GetInt32(totalPointsOrdinal);
var gradeType = reader[gradeTypeOrdinal] == DBNull.Value
? default(string)
: reader.GetString(gradeTypeOrdinal);
var gradeItemId = reader[gradeItemIdOrdinal] == DBNull.Value
? default(int)
: reader.GetInt32(gradeItemIdOrdinal);
var isPublic = reader[isPublicOrdinal] != DBNull.Value && reader.GetBoolean(isPublicOrdinal);
var currGradedItem = new GradeItem(gradeName, null, -1, null, totalPoints,
gradeType, gradeDescription, gradeItemId, isPublic, null);
grade = currGradedItem;
}
return(grade);
}
}
}
}
/// <summary>
/// Writes the new grade item to local database.
/// </summary>
/// <param name="gradeItem">The grade item.</param>
public async void WriteNewGradeItemsToLocalDb(GradeItem gradeItem)
{
CourseRepository courseRepo = new CourseRepository();
var sqlInsert = "INSERT INTO `Course_grade_item`(`cid`, `name`, `description`, `grade_type`, `max_grade`)"
+ " VALUES (@cid, @name, @description, @grade_type, @max_grade);";
int rowId = 0;
using (SqliteConnection db = DataAccess.LocalConnection)
{
db.Open();
var transaction = db.BeginTransaction();
var createGradeItemCommand = db.CreateCommand();
createGradeItemCommand.Connection = db;
createGradeItemCommand.Transaction = transaction;
try
{
createGradeItemCommand.CommandText = sqlInsert;
createGradeItemCommand.Parameters.Add("@cid", SqliteType.Integer, 11);
createGradeItemCommand.Parameters["@cid"].Value = gradeItem.CourseId;
createGradeItemCommand.Parameters.Add("@name", SqliteType.Text, 60);
createGradeItemCommand.Parameters["@name"].Value = gradeItem.Name;
createGradeItemCommand.Parameters.Add("@description", SqliteType.Text, 600);
createGradeItemCommand.Parameters["@description"].Value = gradeItem.Description;
createGradeItemCommand.Parameters.Add("@grade_type", SqliteType.Text, 60);
createGradeItemCommand.Parameters["@grade_type"].Value = gradeItem.Type;
createGradeItemCommand.Parameters.Add("@max_grade", SqliteType.Integer, 11);
createGradeItemCommand.Parameters["@max_grade"].Value = gradeItem.MaxGrade;
createGradeItemCommand.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
var cmd = db.CreateCommand();
cmd.CommandText = "SELECT last_insert_rowid()";
object i = cmd.ExecuteScalar();
cmd.CommandText = "SELECT `aid` FROM `Course_grade_item` WHERE rowid=" + i.ToString();
i = cmd.ExecuteScalar();
rowId = (int)(long)i;
}
var sqlchange = "INSERT INTO `Course_grade_item`(`cid`, `name`, `description`, `grade_type`, `max_grade`)"
+ " VALUES (" + gradeItem.CourseId + ",'" + gradeItem.Name + "','" + gradeItem.Description
+ "','" + gradeItem.Type + "'," + gradeItem.MaxGrade + ");";
await ChangelogModifier.AppendChangeLog(sqlchange);
var students = courseRepo.GetAllStudentsByCourseLocalDb(gradeItem.CourseId);
foreach (var student in students)
{
await this.AddGradeItemGrade(rowId, student.Id);
}
}
/// <summary>
/// Build content footer in report.
/// </summary>
/// <param name="content4">The content footer first line.</param>
/// <param name="content5">The content footer second line</param>
/// <returns></returns>
private string BuildContentFooter(string content4, string content5, GradeItem gradePoint)
{
content4 = content4.Replace("%GRADENAMEENG%", gradePoint.GradeNameEn);
content4 = content4.Replace("%GRADENAMETH%", gradePoint.GradeNameTh);
StringBuilder contentFooter = new StringBuilder();
contentFooter.AppendLine(content4);
contentFooter.AppendLine($"{leftSpace}{content5}");
return(contentFooter.ToString());
}
private void handleExistingGradeItemOnLoad()
{
if (HttpContext.Current.Session["CurrentGradedItem"] != null && HttpContext.Current.Session["editing"] != null)
{
this.currentGradedItem = HttpContext.Current.Session["CurrentGradedItem"] as GradeItem;
this.tbxAssignmentName.Text = this.currentGradedItem.Name;
this.tbxPossiblePoints.Text = this.currentGradedItem.PossiblePoints.ToString();
this.btnCreate.Text = "Update";
this.cbxIsVisible.Checked = this.currentGradedItem.IsPublic;
}
}
private void displayExistingGradeItem()
{
if (HttpContext.Current.Session["CurrentGradedItem"] != null && HttpContext.Current.Session["editing"] != null)
{
bool isEditing = (bool)HttpContext.Current.Session["editing"];
if (isEditing)
{
this.currentGradedItem = HttpContext.Current.Session["CurrentGradedItem"] as GradeItem;
}
}
}
public ActionResult CreateGradeItem(int courseID)
{
ViewBag.weightTypes = new SelectList(this.weightTypeDAL.getWeightTypesInCourse(courseID), "Key", "Value");
var newItem = new GradeItem()
{
CourseID = courseID
};
return(View("CreateGradeItem", newItem));
}
public IActionResult Update(string id, GradeItem item)
{
if (id != item.Id)
{
return(BadRequest());
}
_gradeService.Update(id, item);
return(NoContent());
}
private void AssignmentCombo_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
GradeItemDAL dal = new GradeItemDAL();
var crn = CourseManagementTools.findCrn(this.courseComboBox.Text, this.semesterComboBox.Text);
item = dal.GetGradedItemByCRNAndGradeName(crn, this.AssignmentCombo.Text);
if (item != null)
{
this.assignmentNameBox.Text = item.Name;
this.pointsBox.Text = item.PossiblePoints.ToString();
}
}
public ActionResult Edit([Bind(Include = "GradeItemID,Name,AssessmentTypeID,AssessmentTNo,CrNo,Weight,GradeDistributionID")] GradeItem gradeItem)
{
if (ModelState.IsValid)
{
db.Entry(gradeItem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AssessmentTypeID = new SelectList(db.AssessmentTypes, "AssessmentTypeID", "Type", gradeItem.AssessmentTypeID);
ViewBag.GradeDistributionID = new SelectList(db.GradeDistributions, "GradeDistributionID", "Name", gradeItem.GradeDistributionID);
return(View(gradeItem));
}
private void handleWhenGradeItemDoesNotExists()
{
var crn = CourseManagementTools.findCrn(this.assignmentPage.courseComboBox.SelectedItem as string,
this.assignmentPage.semesterComboBox.SelectedItem as string);
var assignmentName = this.assignmentPage.assignmentNameBox.Text;
var possiblePoints = Convert.ToInt32(this.assignmentPage.pointsBox.Text);
var gradeType = this.assignmentPage.assignmentTypeComboBox.Text;
var isChecked = this.assignmentPage.visibilityCheckBox.IsChecked;
var item = new GradeItem(assignmentName, null, 0, string.Empty, possiblePoints, gradeType, string.Empty, 0,
isChecked != null && isChecked.Value, null);
this.gradeItemDal.InsertNewGradedItemByCRNForAllStudents(item, crn);
}
public ActionResult Edit(GradeItem gradeItem)
{
try
{
var result = this.DAL.UpdateGradeItem(gradeItem);
return(RedirectToAction("Index"));
}
catch
{
return(View("Edit"));
}
}
public ActionResult Create(GradeItem gradeItem)
{
try
{
var result = this.DAL.insertGradeItem(gradeItem);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View("Create"));
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
var assignmentName = this.tbxAssignmentName.Text;
var possiblePoints = Convert.ToInt32(this.tbxPossiblePoints.Text);
var gradeType = this.ddlAssignmentType.SelectedValue;
GradeItem item = new GradeItem(assignmentName, null, 0, string.Empty, possiblePoints, gradeType, String.Empty, 0, false, null);
this.GradeDAL.deleteGradedItemByCRNForAllStudents(item, this.currentCourse.CRN);
HttpContext.Current.Session["CurrentGradedItem"] = null;
HttpContext.Current.Session["editing"] = null;
this.deleteModal.Show();
}
public async Task AddGrade(string id, DateTime date, string grade, int score)
{
var gradeItem = new GradeItem()
{
Date = date,
Grade = grade,
Score = score
};
var filter = Builders <Restaurant> .Filter.Eq("_id", ObjectId.Parse(id));
var update = Builders <Restaurant> .Update.AddToSet(_ => _.Grades, gradeItem);
await _restauraunts.UpdateOneAsync(filter, update);
}
public void TestGradeItemDefaultConstructor()
{
GradeItem grade = new GradeItem();
Assert.AreEqual(grade.Name, null);
Assert.AreEqual(grade.Student, null);
Assert.AreEqual(grade.Grade, 0);
Assert.AreEqual(grade.Feedback, null);
Assert.AreEqual(grade.PossiblePoints, 0);
Assert.AreEqual(grade.GradeType, null);
Assert.AreEqual(grade.GradeId, 0);
Assert.AreEqual(grade.Description, null);
Assert.AreEqual(grade.TimeGraded, null);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
List <GradeItem> items = (List <GradeItem>) this.odsStudents.Select();
GradeItem current = items[0];
HttpContext.Current.Session["CurrentGradedItem"] = current;
HttpContext.Current.Session["editing"] = true;
CourseDAL courseDal = new CourseDAL();
int crn = int.Parse(this.ddlCourses.SelectedValue);
Course currentCourse = courseDal.GetCourseByCRN(crn);
HttpContext.Current.Session["CurrentCourse"] = currentCourse;
HttpContext.Current.Response.Redirect("ManageCreateGradeItem.aspx");
}
// GET: GradeItems/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GradeItem gradeItem = db.GradeItems.Find(id);
if (gradeItem == null)
{
return(HttpNotFound());
}
return(View(gradeItem));
}
// GET: GradeItems/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GradeItem gradeItem = db.GradeItems.Find(id);
if (gradeItem == null)
{
return(HttpNotFound());
}
ViewBag.AssessmentTypeID = new SelectList(db.AssessmentTypes, "AssessmentTypeID", "Type", gradeItem.AssessmentTypeID);
ViewBag.GradeDistributionID = new SelectList(db.GradeDistributions, "GradeDistributionID", "Name", gradeItem.GradeDistributionID);
return(View(gradeItem));
}
/// <summary>
/// Displays the grade item details.
/// </summary>
public void DisplayGradeItemDetails()
{
var crn = CourseManagementTools.findCrn(this.assignmentPage.courseComboBox.SelectedItem as string,
this.assignmentPage.semesterComboBox.SelectedItem as string);
this.selectedGradeItem =
this.gradeItemDal.GetGradedItemByCRNAndGradeName(crn,
this.assignmentPage.AssignmentCombo.SelectedItem as string);
if (this.selectedGradeItem != null)
{
this.assignmentPage.assignmentNameBox.Text = this.selectedGradeItem.Name;
this.assignmentPage.pointsBox.Text =
this.selectedGradeItem.PossiblePoints.ToString(CultureInfo.CurrentCulture);
this.assignmentPage.visibilityCheckBox.IsChecked = this.selectedGradeItem.IsPublic;
}
}
private void gradeStudent()
{
var window = new confirmationWindow();
window.ShowDialog();
var currentGrade = this.assignments[this.gradePage.assignmentBox.SelectedIndex];
var studentId = this.studentIds[this.gradePage.studentCombo.SelectedIndex];
var updatedGrade = new GradeItem
{
Feedback = this.gradePage.feedBackBox.Text,
Grade = int.Parse(this.gradePage.earnedPointsBox.Text),
GradeId = currentGrade.GradeId,
Name = currentGrade.Name
};
this.gradeItemDal.gradeGradedItemByCRNAndStudentUID(updatedGrade,
this.gradePage.homePageController.currentCrn, studentId);
}
/// <summary>
/// Inserts the new graded item by CRN for all students.
/// </summary>
/// <param name="newItem">The new item.</param>
/// <param name="CRN">The CRN.</param>
public void InsertNewGradedItemByCRNForAllStudents(GradeItem newItem, int CRN)
{
StudentDAL studentGetter = new StudentDAL();
List <Student> students = studentGetter.GetStudentsByCRN(CRN);
MySqlConnection dbConnection = DbConnection.GetConnection();
using (dbConnection)
{
dbConnection.Open();
//GradeItem grade = new GradeItem(newItem.Name, t, 0.0, null, newItem.PossiblePoints, newItem.GradeType, 0, newItem.IsPublic, newItem.TimeGraded);
var selectQuery =
"INSERT INTO grade_defs(grade_total_points, grade_description, grade_type, grade_name, is_public, course_CRN) VALUES (@grade_total_points,@grade_description,@grade_type,@grade_name,@is_public,@course_CRN)";
using (MySqlCommand cmd = new MySqlCommand(selectQuery, dbConnection))
{
cmd.Parameters.AddWithValue("@grade_total_points", newItem.PossiblePoints);
cmd.Parameters.AddWithValue("@grade_description", newItem.Description);
cmd.Parameters.AddWithValue("@grade_type", newItem.GradeType);
cmd.Parameters.AddWithValue("@grade_name", newItem.Name);
cmd.Parameters.AddWithValue("@grade_feedback", newItem.Feedback);
cmd.Parameters.AddWithValue("@is_public", newItem.IsPublic);
cmd.Parameters.AddWithValue("@course_CRN", CRN);
cmd.ExecuteNonQuery();
}
foreach (var t in students)
{
GradeItem grade = new GradeItem(newItem.Name, t, 0.0, null, newItem.PossiblePoints, newItem.GradeType, null, 0, newItem.IsPublic, newItem.TimeGraded);
var query =
"INSERT INTO student_grade_items (grade_def_id, student_uid, grade_earned_points,grade_feedback,time_graded) VALUES ((SELECT grade_defs.grade_def_id FROM grade_defs WHERE grade_defs.grade_name = @grade_name AND grade_defs.course_CRN = @CRNCheck),@studentUID,@grade_earned_points,@grade_feedback,@time_graded)";
using (MySqlCommand cmd = new MySqlCommand(query, dbConnection))
{
cmd.Parameters.AddWithValue("@studentUID", grade.Student.StudentUID);
cmd.Parameters.AddWithValue("@grade_name", grade.Name);
cmd.Parameters.AddWithValue("@CRNCheck", CRN);
cmd.Parameters.AddWithValue("@grade_earned_points", 0);
cmd.Parameters.AddWithValue("@grade_feedback", null);
cmd.Parameters.AddWithValue("@time_graded", null);
cmd.ExecuteNonQuery();
}
}
dbConnection.Close();
}
}
public GradeItem GetGradeItemByID(int id)
{
GradeItem gradeItem = null;
using (var dbConnection = DbConnection.DatabaseConnection())
{
dbConnection.Open();
var query = "SELECT * " +
"FROM grade_item " +
"WHERE id = @id";
using (var cmd = new MySqlCommand(query, dbConnection))
{
cmd.Parameters.AddWithValue("id", id);
using (var reader = cmd.ExecuteReader())
{
var idOrdinal = reader.GetOrdinal("id");
var nameOrdinal = reader.GetOrdinal("name");
var descriptionOrdinal = reader.GetOrdinal("description");
var maxGradeOrdinal = reader.GetOrdinal("max_grade");
var weightOrdinal = reader.GetOrdinal("weight_type");
var dueDateOrdinal = reader.GetOrdinal("due_date");
var cidOrdinal = reader.GetOrdinal("course_id");
while (reader.Read())
{
gradeItem = new GradeItem
{
ID = reader[idOrdinal] == DBNull.Value ? throw new Exception("Failed to get the grade items id.") : reader.GetInt32(idOrdinal),
Name = reader[nameOrdinal] == DBNull.Value ? throw new Exception("Failed to get the grade items name.") : reader.GetString(nameOrdinal),
Description = reader[descriptionOrdinal] == DBNull.Value ? string.Empty : reader.GetString(descriptionOrdinal),
MaxGrade = reader[maxGradeOrdinal] == DBNull.Value ? throw new Exception("Failed to get the grade items max grade.") : reader.GetInt32(maxGradeOrdinal),
WeightType = reader[weightOrdinal] == DBNull.Value ? throw new Exception("Failed to find weight type.") : reader.GetInt32(weightOrdinal),
DueDate = reader[dueDateOrdinal] == DBNull.Value ? throw new Exception("Failed to get the grade items due date.") : reader.GetDateTime(dueDateOrdinal),
CourseID = reader[cidOrdinal] == DBNull.Value ? throw new Exception("Failed to get the grade items course id.") : reader.GetInt32(cidOrdinal)
};
}
}
}
}
return(gradeItem);
}
public void Carregar()
{
// A consulta abaixo retorna a grade de todos os itens do pedido informado
// Parece que o resto do sistema se comporta como se fosse a grade apenas do item ou produto.
string sqlPedidoGrade = @"
select
*
from
item_pedido_grade
where
id_pedido ='" + Produto.Pedido.Id + "'" +
@" and id_produto=" + Produto.Id;
DataTable dtPedidoGrade = D.Bd.DataTablePreenche(sqlPedidoGrade);
for (int y = 0; y < dtPedidoGrade.Rows.Count; ++y)
{
GradeItem gi = new GradeItem(this);
gi.Id = Convert.ToInt32(dtPedidoGrade.Rows[y]["id_item_pedido_grade"]);
GuardaLista(Convert.ToInt32(dtPedidoGrade.Rows[y]["id_item_atributo"]),
Convert.ToInt32(dtPedidoGrade.Rows[y]["id_item_grade"]),
Convert.ToInt32(dtPedidoGrade.Rows[y]["id_atributo"]),
Convert.ToInt32(dtPedidoGrade.Rows[y]["id_grade"]),
Convert.ToInt32(dtPedidoGrade.Rows[y]["quantidade"]));
}
}
public void GuardaLista(int idItemAtributo, int idItemGrade, int idAtributo, int idGrade, int quantidade)
{
GradeItem gi = new GradeItem(this);
gi.IdItemAtributo = idItemAtributo;
gi.IdItemGrade = idItemGrade;
gi.IdAtributo = idAtributo;
gi.IdGrade = idGrade;
gi.Quantidade = quantidade;
LstGradeItem.Add(gi);
}
