public static ADLHeaderDetailStatus GetADLHeaderDetailStatusByID(int id)
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus();
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
aDLHeaderDetailStatus = sqlADLHeaderDetailStatusProvider.GetADLHeaderDetailStatusByID(id);
return aDLHeaderDetailStatus;
}
private void showADLHeaderDetailStatusData()
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus();
aDLHeaderDetailStatus = ADLHeaderDetailStatusManager.GetADLHeaderDetailStatusByID(Int32.Parse(Request.QueryString["aDLHeaderDetailStatusID"]));
txtADLHeaderDetailStatusName.Text = aDLHeaderDetailStatus.ADLHeaderDetailStatusName;
}
public static ADLHeaderDetailStatus GetADLHeaderDetailStatusByID(int id)
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus();
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
aDLHeaderDetailStatus = sqlADLHeaderDetailStatusProvider.GetADLHeaderDetailStatusByID(id);
return(aDLHeaderDetailStatus);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus();
aDLHeaderDetailStatus.ADLHeaderDetailStatusName = txtADLHeaderDetailStatusName.Text;
int resutl = ADLHeaderDetailStatusManager.InsertADLHeaderDetailStatus(aDLHeaderDetailStatus);
Response.Redirect("AdminADLHeaderDetailStatusDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus();
aDLHeaderDetailStatus = ADLHeaderDetailStatusManager.GetADLHeaderDetailStatusByID(Int32.Parse(Request.QueryString["aDLHeaderDetailStatusID"]));
ADLHeaderDetailStatus tempADLHeaderDetailStatus = new ADLHeaderDetailStatus();
tempADLHeaderDetailStatus.ADLHeaderDetailStatusID = aDLHeaderDetailStatus.ADLHeaderDetailStatusID;
tempADLHeaderDetailStatus.ADLHeaderDetailStatusName = txtADLHeaderDetailStatusName.Text;
bool result = ADLHeaderDetailStatusManager.UpdateADLHeaderDetailStatus(tempADLHeaderDetailStatus);
Response.Redirect("AdminADLHeaderDetailStatusDisplay.aspx");
}
public int InsertADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLHeaderDetailStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLHeaderDetailStatusName", SqlDbType.NVarChar).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@ADLHeaderDetailStatusID"].Value);
}
}
public bool UpdateADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeaderDetailStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailStatusID", SqlDbType.Int).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusID;
cmd.Parameters.Add("@ADLHeaderDetailStatusName", SqlDbType.NVarChar).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public ADLHeaderDetailStatus GetADLHeaderDetailStatusFromReader(IDataReader reader)
{
try
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus
(
(int)reader["ADLHeaderDetailStatusID"],
reader["ADLHeaderDetailStatusName"].ToString()
);
return(aDLHeaderDetailStatus);
}
catch (Exception ex)
{
return(null);
}
}
public ADLHeaderDetailStatus GetADLHeaderDetailStatusFromReader(IDataReader reader)
{
try
{
ADLHeaderDetailStatus aDLHeaderDetailStatus = new ADLHeaderDetailStatus
(
(int)reader["ADLHeaderDetailStatusID"],
reader["ADLHeaderDetailStatusName"].ToString()
);
return aDLHeaderDetailStatus;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
return(sqlADLHeaderDetailStatusProvider.UpdateADLHeaderDetailStatus(aDLHeaderDetailStatus));
}
public static int InsertADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
return(sqlADLHeaderDetailStatusProvider.InsertADLHeaderDetailStatus(aDLHeaderDetailStatus));
}
public static bool UpdateADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
return sqlADLHeaderDetailStatusProvider.UpdateADLHeaderDetailStatus(aDLHeaderDetailStatus);
}
public static int InsertADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
SqlADLHeaderDetailStatusProvider sqlADLHeaderDetailStatusProvider = new SqlADLHeaderDetailStatusProvider();
return sqlADLHeaderDetailStatusProvider.InsertADLHeaderDetailStatus(aDLHeaderDetailStatus);
}
public bool UpdateADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeaderDetailStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailStatusID", SqlDbType.Int).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusID;
cmd.Parameters.Add("@ADLHeaderDetailStatusName", SqlDbType.NVarChar).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertADLHeaderDetailStatus(ADLHeaderDetailStatus aDLHeaderDetailStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLHeaderDetailStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLHeaderDetailStatusName", SqlDbType.NVarChar).Value = aDLHeaderDetailStatus.ADLHeaderDetailStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ADLHeaderDetailStatusID"].Value;
}
}
