private void showAL_HelpTypeData()
{
AL_HelpType aL_HelpType = new AL_HelpType();
aL_HelpType = AL_HelpTypeManager.GetAL_HelpTypeByID(Int32.Parse(Request.QueryString["aL_HelpTypeID"]));
txtHelpTypeName.Text = aL_HelpType.HelpTypeName;
}
public static AL_HelpType GetAL_HelpTypeByID(int id)
{
AL_HelpType aL_HelpType = new AL_HelpType();
SqlAL_HelpTypeProvider sqlAL_HelpTypeProvider = new SqlAL_HelpTypeProvider();
aL_HelpType = sqlAL_HelpTypeProvider.GetAL_HelpTypeByID(id);
return(aL_HelpType);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
AL_HelpType aL_HelpType = new AL_HelpType();
aL_HelpType.HelpTypeName = txtHelpTypeName.Text;
int resutl = AL_HelpTypeManager.InsertAL_HelpType(aL_HelpType);
Response.Redirect("AdminAL_HelpTypeDisplay.aspx");
}
public int InsertAL_HelpType(AL_HelpType aL_HelpType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertAL_HelpType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AL_HelpTypeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@HelpTypeName", SqlDbType.NVarChar).Value = aL_HelpType.HelpTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@AL_HelpTypeID"].Value);
}
}
public bool UpdateAL_HelpType(AL_HelpType aL_HelpType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateAL_HelpType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AL_HelpTypeID", SqlDbType.Int).Value = aL_HelpType.AL_HelpTypeID;
cmd.Parameters.Add("@HelpTypeName", SqlDbType.NVarChar).Value = aL_HelpType.HelpTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
AL_HelpType aL_HelpType = new AL_HelpType();
aL_HelpType = AL_HelpTypeManager.GetAL_HelpTypeByID(Int32.Parse(Request.QueryString["aL_HelpTypeID"]));
AL_HelpType tempAL_HelpType = new AL_HelpType();
tempAL_HelpType.AL_HelpTypeID = aL_HelpType.AL_HelpTypeID;
tempAL_HelpType.HelpTypeName = txtHelpTypeName.Text;
bool result = AL_HelpTypeManager.UpdateAL_HelpType(tempAL_HelpType);
Response.Redirect("AdminAL_HelpTypeDisplay.aspx");
}
public AL_HelpType GetAL_HelpTypeFromReader(IDataReader reader)
{
try
{
AL_HelpType aL_HelpType = new AL_HelpType
(
(int)reader["AL_HelpTypeID"],
reader["HelpTypeName"].ToString()
);
return(aL_HelpType);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateAL_HelpType(AL_HelpType aL_HelpType)
{
SqlAL_HelpTypeProvider sqlAL_HelpTypeProvider = new SqlAL_HelpTypeProvider();
return(sqlAL_HelpTypeProvider.UpdateAL_HelpType(aL_HelpType));
}
public static int InsertAL_HelpType(AL_HelpType aL_HelpType)
{
SqlAL_HelpTypeProvider sqlAL_HelpTypeProvider = new SqlAL_HelpTypeProvider();
return(sqlAL_HelpTypeProvider.InsertAL_HelpType(aL_HelpType));
}