public AL_Help GetAL_HelpFromReader(IDataReader reader) { try { AL_Help aL_Help = new AL_Help ( (int)reader["AL_HelpID"], (int)reader["HelpTypeID"], reader["Question"].ToString(), reader["Answer"].ToString() ); try { aL_Help.HelpTypeName = reader["HelpTypeName"].ToString(); } catch (Exception ex) { } return(aL_Help); } catch (Exception ex) { return(null); } }
public static AL_Help GetAL_HelpByID(int id) { AL_Help aL_Help = new AL_Help(); SqlAL_HelpProvider sqlAL_HelpProvider = new SqlAL_HelpProvider(); aL_Help = sqlAL_HelpProvider.GetAL_HelpByID(id); return(aL_Help); }
private void showAL_HelpData() { AL_Help aL_Help = new AL_Help(); aL_Help = AL_HelpManager.GetAL_HelpByID(Int32.Parse(Request.QueryString["aL_HelpID"])); ddlHelpType.SelectedValue = aL_Help.HelpTypeID.ToString(); txtQuestion.Text = aL_Help.Question; txtAnswer.Text = aL_Help.Answer; }
protected void btnAdd_Click(object sender, EventArgs e) { AL_Help aL_Help = new AL_Help(); aL_Help.HelpTypeID = Int32.Parse(ddlHelpType.SelectedValue); aL_Help.Question = txtQuestion.Text; aL_Help.Answer = txtAnswer.Text; int resutl = AL_HelpManager.InsertAL_Help(aL_Help); Response.Redirect("AdminAL_HelpDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { AL_Help aL_Help = new AL_Help(); aL_Help = AL_HelpManager.GetAL_HelpByID(Int32.Parse(Request.QueryString["aL_HelpID"])); AL_Help tempAL_Help = new AL_Help(); tempAL_Help.AL_HelpID = aL_Help.AL_HelpID; tempAL_Help.HelpTypeID = Int32.Parse(ddlHelpType.SelectedValue); tempAL_Help.Question = txtQuestion.Text; tempAL_Help.Answer = txtAnswer.Text; bool result = AL_HelpManager.UpdateAL_Help(tempAL_Help); Response.Redirect("AdminAL_HelpDisplay.aspx"); }
public bool UpdateAL_Help(AL_Help aL_Help) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateAL_Help", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AL_HelpID", SqlDbType.Int).Value = aL_Help.AL_HelpID; cmd.Parameters.Add("@HelpTypeID", SqlDbType.Int).Value = aL_Help.HelpTypeID; cmd.Parameters.Add("@Question", SqlDbType.NText).Value = aL_Help.Question; cmd.Parameters.Add("@Answer", SqlDbType.NText).Value = aL_Help.Answer; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public int InsertAL_Help(AL_Help aL_Help) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertAL_Help", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AL_HelpID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@HelpTypeID", SqlDbType.Int).Value = aL_Help.HelpTypeID; cmd.Parameters.Add("@Question", SqlDbType.NText).Value = aL_Help.Question; cmd.Parameters.Add("@Answer", SqlDbType.NText).Value = aL_Help.Answer; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@AL_HelpID"].Value); } }
public static bool UpdateAL_Help(AL_Help aL_Help) { SqlAL_HelpProvider sqlAL_HelpProvider = new SqlAL_HelpProvider(); return(sqlAL_HelpProvider.UpdateAL_Help(aL_Help)); }
public static int InsertAL_Help(AL_Help aL_Help) { SqlAL_HelpProvider sqlAL_HelpProvider = new SqlAL_HelpProvider(); return(sqlAL_HelpProvider.InsertAL_Help(aL_Help)); }