Example #1
0
    public static ADLItemDescription GetADLItemDescriptionByID(int id)
    {
        ADLItemDescription            aDLItemDescription            = new ADLItemDescription();
        SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider();

        aDLItemDescription = sqlADLItemDescriptionProvider.GetADLItemDescriptionByID(id);
        return(aDLItemDescription);
    }
Example #2
0
    private void showADLItemDescriptionData()
    {
        ADLItemDescription aDLItemDescription = new ADLItemDescription();

        aDLItemDescription = ADLItemDescriptionManager.GetADLItemDescriptionByID(Int32.Parse(Request.QueryString["aDLItemDescriptionID"]));

        txtADLItemDescriptionName.Text = aDLItemDescription.ADLItemDescriptionName;
    }
Example #3
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        ADLItemDescription aDLItemDescription = new ADLItemDescription();

        aDLItemDescription.ADLItemDescriptionName = txtADLItemDescriptionName.Text;
        int resutl = ADLItemDescriptionManager.InsertADLItemDescription(aDLItemDescription);

        Response.Redirect("AdminADLItemDescriptionDisplay.aspx");
    }
Example #4
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        ADLItemDescription aDLItemDescription = new ADLItemDescription();

        aDLItemDescription = ADLItemDescriptionManager.GetADLItemDescriptionByID(Int32.Parse(Request.QueryString["aDLItemDescriptionID"]));
        ADLItemDescription tempADLItemDescription = new ADLItemDescription();

        tempADLItemDescription.ADLItemDescriptionID = aDLItemDescription.ADLItemDescriptionID;

        tempADLItemDescription.ADLItemDescriptionName = txtADLItemDescriptionName.Text;
        bool result = ADLItemDescriptionManager.UpdateADLItemDescription(tempADLItemDescription);

        Response.Redirect("AdminADLItemDescriptionDisplay.aspx");
    }
    public int InsertADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_InsertADLItemDescription", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ADLItemDescriptionID", SqlDbType.Int).Direction    = ParameterDirection.Output;
            cmd.Parameters.Add("@ADLItemDescriptionName", SqlDbType.NVarChar).Value = aDLItemDescription.ADLItemDescriptionName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return((int)cmd.Parameters["@ADLItemDescriptionID"].Value);
        }
    }
    public bool UpdateADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateADLItemDescription", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ADLItemDescriptionID", SqlDbType.Int).Value        = aDLItemDescription.ADLItemDescriptionID;
            cmd.Parameters.Add("@ADLItemDescriptionName", SqlDbType.NVarChar).Value = aDLItemDescription.ADLItemDescriptionName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return(result == 1);
        }
    }
 public ADLItemDescription GetADLItemDescriptionFromReader(IDataReader reader)
 {
     try
     {
         ADLItemDescription aDLItemDescription = new ADLItemDescription
             (
                 (int)reader["ADLItemDescriptionID"],
                 reader["ADLItemDescriptionName"].ToString()
             );
          return aDLItemDescription;
     }
     catch(Exception ex)
     {
         return null;
     }
 }
 public ADLItemDescription GetADLItemDescriptionFromReader(IDataReader reader)
 {
     try
     {
         ADLItemDescription aDLItemDescription = new ADLItemDescription
                                                 (
             (int)reader["ADLItemDescriptionID"],
             reader["ADLItemDescriptionName"].ToString()
                                                 );
         return(aDLItemDescription);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
    public bool UpdateADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateADLItemDescription", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ADLItemDescriptionID", SqlDbType.Int).Value = aDLItemDescription.ADLItemDescriptionID;
            cmd.Parameters.Add("@ADLItemDescriptionName", SqlDbType.NVarChar).Value = aDLItemDescription.ADLItemDescriptionName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
    public int InsertADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_InsertADLItemDescription", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ADLItemDescriptionID", SqlDbType.Int).Direction = ParameterDirection.Output;
            cmd.Parameters.Add("@ADLItemDescriptionName", SqlDbType.NVarChar).Value = aDLItemDescription.ADLItemDescriptionName;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return (int)cmd.Parameters["@ADLItemDescriptionID"].Value;
        }
    }
Example #11
0
    public static bool UpdateADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider();

        return(sqlADLItemDescriptionProvider.UpdateADLItemDescription(aDLItemDescription));
    }
Example #12
0
    public static int InsertADLItemDescription(ADLItemDescription aDLItemDescription)
    {
        SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider();

        return(sqlADLItemDescriptionProvider.InsertADLItemDescription(aDLItemDescription));
    }