public static STD_QuestionAnswer GetSTD_QuestionByQuestionID(int QuestionID) { STD_QuestionAnswer sTD_QuestionAnswer = new STD_QuestionAnswer(); SqlSTD_QuestionAnswerProvider sqlSTD_QuestionAnswerProvider = new SqlSTD_QuestionAnswerProvider(); sTD_QuestionAnswer = sqlSTD_QuestionAnswerProvider.GetSTD_QuestionAnswerByQuestionID(QuestionID); return sTD_QuestionAnswer; }
protected void btnUpdate_Click(object sender, EventArgs e) { try { STD_QuestionAnswer sTD_QuestionAnswer = new STD_QuestionAnswer (); sTD_QuestionAnswer.QuestionAnswerID= int.Parse(Request.QueryString["ID"].ToString()); sTD_QuestionAnswer.QuestionID= int.Parse(ddlQuestionID.SelectedValue); sTD_QuestionAnswer.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_QuestionAnswer.AddedDate= DateTime.Now; sTD_QuestionAnswer.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_QuestionAnswer.UpdateDate = DateTime.Now; sTD_QuestionAnswer.IsCorrectQuestionAnswer= bool.Parse( radIsCorrectQuestionAnswer.SelectedValue); sTD_QuestionAnswer.Description= txtDescription.Text; bool resutl =STD_QuestionAnswerManager.UpdateSTD_QuestionAnswer(sTD_QuestionAnswer); }catch(Exception ex){}Response.Redirect("AdminDisplaySTD_QuestionAnswer.aspx"); }
public bool UpdateSTD_QuestionAnswer(STD_QuestionAnswer sTD_QuestionAnswer) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_QuestionAnswer", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@QuestionAnswerID", SqlDbType.Int).Value = sTD_QuestionAnswer.QuestionAnswerID; cmd.Parameters.Add("@QuestionID", SqlDbType.Int).Value = sTD_QuestionAnswer.QuestionID; //cmd.Parameters.Add("@QuestionID", SqlDbType.Int).Value = sTD_QuestionAnswer.QuestionID; //cmd.Parameters.Add("@QuestionID", SqlDbType.Int).Value = sTD_QuestionAnswer.QuestionID; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_QuestionAnswer.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_QuestionAnswer.UpdateDate; cmd.Parameters.Add("@IsCorrectQuestionAnswer", SqlDbType.Bit).Value = sTD_QuestionAnswer.IsCorrectQuestionAnswer; cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_QuestionAnswer.Description; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_QuestionAnswer GetSTD_QuestionAnswerFromReader(IDataReader reader) { try { STD_QuestionAnswer sTD_QuestionAnswer = new STD_QuestionAnswer ( DataAccessObject.IsNULL<int>(reader["QuestionAnswerID"]), DataAccessObject.IsNULL<int>(reader["QuestionID"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]), DataAccessObject.IsNULL<bool>(reader["IsCorrectQuestionAnswer"]), DataAccessObject.IsNULL<string>(reader["Description"]) ); return sTD_QuestionAnswer; } catch(Exception ex) { return null; } }
private void showSTD_QuestionAnswerData() { STD_QuestionAnswer sTD_QuestionAnswer = new STD_QuestionAnswer (); sTD_QuestionAnswer = STD_QuestionAnswerManager.GetSTD_QuestionAnswerByQuestionAnswerID(Int32.Parse(Request.QueryString["ID"])); ddlQuestionID.SelectedValue =sTD_QuestionAnswer.QuestionID.ToString(); string txtUpdatedBy_Text =sTD_QuestionAnswer.UpdatedBy.ToString(); string txtUpdateDate_Text =sTD_QuestionAnswer.UpdateDate.ToString(); radIsCorrectQuestionAnswer.SelectedValue =sTD_QuestionAnswer.IsCorrectQuestionAnswer.ToString(); txtDescription.Text =sTD_QuestionAnswer.Description.ToString(); }
public static int InsertSTD_QuestionAnswer(STD_QuestionAnswer sTD_QuestionAnswer) { SqlSTD_QuestionAnswerProvider sqlSTD_QuestionAnswerProvider = new SqlSTD_QuestionAnswerProvider(); return sqlSTD_QuestionAnswerProvider.InsertSTD_QuestionAnswer(sTD_QuestionAnswer); }
public static bool UpdateSTD_QuestionAnswer(STD_QuestionAnswer sTD_QuestionAnswer) { SqlSTD_QuestionAnswerProvider sqlSTD_QuestionAnswerProvider = new SqlSTD_QuestionAnswerProvider(); return sqlSTD_QuestionAnswerProvider.UpdateSTD_QuestionAnswer(sTD_QuestionAnswer); }