public static ADLItemDescription GetADLItemDescriptionByID(int id) { ADLItemDescription aDLItemDescription = new ADLItemDescription(); SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider(); aDLItemDescription = sqlADLItemDescriptionProvider.GetADLItemDescriptionByID(id); return(aDLItemDescription); }
private void showADLItemDescriptionData() { ADLItemDescription aDLItemDescription = new ADLItemDescription(); aDLItemDescription = ADLItemDescriptionManager.GetADLItemDescriptionByID(Int32.Parse(Request.QueryString["aDLItemDescriptionID"])); txtADLItemDescriptionName.Text = aDLItemDescription.ADLItemDescriptionName; }
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"); }
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; } }
public static bool UpdateADLItemDescription(ADLItemDescription aDLItemDescription) { SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider(); return(sqlADLItemDescriptionProvider.UpdateADLItemDescription(aDLItemDescription)); }
public static int InsertADLItemDescription(ADLItemDescription aDLItemDescription) { SqlADLItemDescriptionProvider sqlADLItemDescriptionProvider = new SqlADLItemDescriptionProvider(); return(sqlADLItemDescriptionProvider.InsertADLItemDescription(aDLItemDescription)); }