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));
}
