public static ADLStatus GetADLStatusByID(int id) { ADLStatus aDLStatus = new ADLStatus(); SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); aDLStatus = sqlADLStatusProvider.GetADLStatusByID(id); return aDLStatus; }
private void showADLStatusData() { ADLStatus aDLStatus = new ADLStatus(); aDLStatus = ADLStatusManager.GetADLStatusByID(Int32.Parse(Request.QueryString["aDLStatusID"])); txtADLStatusName.Text = aDLStatus.ADLStatusName; }
public static ADLStatus GetADLStatusByID(int id) { ADLStatus aDLStatus = new ADLStatus(); SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); aDLStatus = sqlADLStatusProvider.GetADLStatusByID(id); return(aDLStatus); }
protected void btnAdd_Click(object sender, EventArgs e) { ADLStatus aDLStatus = new ADLStatus(); aDLStatus.ADLStatusName = txtADLStatusName.Text; int resutl = ADLStatusManager.InsertADLStatus(aDLStatus); Response.Redirect("AdminADLStatusDisplay.aspx"); }
public int InsertADLStatus(ADLStatus aDLStatus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertADLStatus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@ADLStatusName", SqlDbType.NVarChar).Value = aDLStatus.ADLStatusName; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@ADLStatusID"].Value); } }
public bool UpdateADLStatus(ADLStatus aDLStatus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateADLStatus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLStatus.ADLStatusID; cmd.Parameters.Add("@ADLStatusName", SqlDbType.NVarChar).Value = aDLStatus.ADLStatusName; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
protected void btnUpdate_Click(object sender, EventArgs e) { ADLStatus aDLStatus = new ADLStatus(); aDLStatus = ADLStatusManager.GetADLStatusByID(Int32.Parse(Request.QueryString["aDLStatusID"])); ADLStatus tempADLStatus = new ADLStatus(); tempADLStatus.ADLStatusID = aDLStatus.ADLStatusID; tempADLStatus.ADLStatusName = txtADLStatusName.Text; bool result = ADLStatusManager.UpdateADLStatus(tempADLStatus); Response.Redirect("AdminADLStatusDisplay.aspx"); }
public ADLStatus GetADLStatusFromReader(IDataReader reader) { try { ADLStatus aDLStatus = new ADLStatus ( (int)reader["ADLStatusID"], reader["ADLStatusName"].ToString() ); return(aDLStatus); } catch (Exception ex) { return(null); } }
public ADLStatus GetADLStatusFromReader(IDataReader reader) { try { ADLStatus aDLStatus = new ADLStatus ( (int)reader["ADLStatusID"], reader["ADLStatusName"].ToString() ); return aDLStatus; } catch(Exception ex) { return null; } }
public static bool UpdateADLStatus(ADLStatus aDLStatus) { SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); return sqlADLStatusProvider.UpdateADLStatus(aDLStatus); }
public static int InsertADLStatus(ADLStatus aDLStatus) { SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); return sqlADLStatusProvider.InsertADLStatus(aDLStatus); }
public bool UpdateADLStatus(ADLStatus aDLStatus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateADLStatus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLStatus.ADLStatusID; cmd.Parameters.Add("@ADLStatusName", SqlDbType.NVarChar).Value = aDLStatus.ADLStatusName; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertADLStatus(ADLStatus aDLStatus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertADLStatus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@ADLStatusName", SqlDbType.NVarChar).Value = aDLStatus.ADLStatusName; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@ADLStatusID"].Value; } }
public static bool UpdateADLStatus(ADLStatus aDLStatus) { SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); return(sqlADLStatusProvider.UpdateADLStatus(aDLStatus)); }
public static int InsertADLStatus(ADLStatus aDLStatus) { SqlADLStatusProvider sqlADLStatusProvider = new SqlADLStatusProvider(); return(sqlADLStatusProvider.InsertADLStatus(aDLStatus)); }