// //Function call to getPictureID(), gets Question_ID, adds question and picture // public String addPictureQuestion(Questions q, Picture p) { p.picture_ID = this.getPictureID(); q.question_ID = this.getNext(); try { conn.Open(); cmd = new SqlCommand("Insert into Questions(Question_ID, Exam_Type, Format, Question, Option1, Option2, Option3, Option4, Solution, Marks, Section,Picture_ID) values('" + q.question_ID + "','" + q.exam_Type + "','" + q.format + "','" + q.question + "','" + q.option1 + "','" + q.option2 + "','" + q.option3 + "','" + q.option4 + "','" + q.solution + "'," + q.marks + ",'" + q.section + "','" + p.picture_ID + "')", conn); int result1 = cmd.ExecuteNonQuery(); cmd = new SqlCommand(); cmd.CommandText = "Insert into Pictures(Picture_ID,Picture)" + " values(@Picture_ID, @Picture)"; cmd.Parameters.Add("@Picture_ID", System.Data.SqlDbType.VarChar, 50); cmd.Parameters.Add("@Picture", System.Data.SqlDbType.Image); cmd.Parameters["@Picture_ID"].Value = p.picture_ID; cmd.Parameters["@Picture"].Value = p.image; cmd.Connection = conn; int result = cmd.ExecuteNonQuery(); conn.Close(); if (result == 1 && result1 == 1) return "Question was successfully added & assigned Question ID " + q.question_ID + "."; else return "Sorry. There was some error."; } catch (Exception ex) { conn.Close(); return ex.Message; } }
// //Function call to getPictureID(), Updates fields of Question, returns Success or Error Message // public string updatePictureQuestion(Questions q, Picture p) { try { p.picture_ID = this.getPictureID(); conn.Open(); cmd = new SqlCommand("Update Questions SET Question_ID='" + q.question_ID + "', Exam_Type='" + q.exam_Type + "', Format ='" + q.format + "', Question = '" + q.question + "', Option1 = '" + q.option1 + "', Option2 = '" + q.option2 + "', Option3 = '" + q.option3 + "', Option4 = '" + q.option4 + "', Solution = '" + q.solution + "', Marks = " + q.marks + ", Section = '" + q.section + "', Picture_ID = '"+ p.picture_ID +"' Where Question_ID='" + q.question_ID + "'", conn); int i = cmd.ExecuteNonQuery(); cmd = new SqlCommand(); cmd.CommandText = "Insert into Pictures(Picture_ID,Picture)" + " values(@Picture_ID, @Picture)"; cmd.Parameters.Add("@Picture_ID", System.Data.SqlDbType.VarChar, 50); cmd.Parameters.Add("@Picture", System.Data.SqlDbType.Image); cmd.Parameters["@Picture_ID"].Value = p.picture_ID; cmd.Parameters["@Picture"].Value = p.image; cmd.Connection = conn; int j = cmd.ExecuteNonQuery(); conn.Close(); if (i == 1 && j==1) return "Question was successfully updated."; else return"Some error occured. Sorry for the inconvenience."; } catch (Exception ex) { conn.Close(); return "Some error occured. Sorry for the inconvenience."; } }
// //Validates fields before updating Picture Question // public String updatePictureQuestion(Questions e, Picture p) { string feedback = ""; bool feed = false; int i = 0; if (e.exam_Type == "") { feedback += (++i) + ". Exam Type "; feed = true; } if (e.question == "") { feedback += (++i) + ". Question "; feed = true; } if (e.solution == "") { feedback += (++i) + ". Solution "; feed = true; } if (e.marks <= 0) { feedback += (++i) + ". Marks "; feed = true; } if (e.section == "") { feedback += (++i) + ". Section "; feed = true; } if (e.option1 == "") { feedback += (++i) + ". Option1 "; feed = true; } if (e.option2 == "") { feedback += (++i) + ". Option2 "; feed = true; } if (e.option3 == "") { feedback += (++i) + ". Option3 "; feed = true; } if (e.option4 == "") { feedback += (++i) + ". Option4 "; feed = true; } if (p.image == null) { feedback += (++i) + ". Image "; feed = true; } if (feed) { //Not valid: Returns erroneous fields return ("Please enter valid entries for: " + feedback); } else { //Valid: Updates Question and returns Success or Error Message string feedDAL = cs.updatePictureQuestion(e, p); return feedDAL; } }