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));
}
