public static ADLDetailnStatus GetADLDetailnStatusByID(int id)
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
aDLDetailnStatus = sqlADLDetailnStatusProvider.GetADLDetailnStatusByID(id);
return aDLDetailnStatus;
}
public ADLDetailnStatus GetADLDetailnStatusFromReader(IDataReader reader)
{
try
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus
(
(int)reader["ADLDetailnStatusID"],
(int)reader["ADLDetailID"],
(int)reader["ADLStatusID"]
);
try
{
aDLDetailnStatus.ADLStatusName = reader["ADLStatusName"].ToString();
}
catch(Exception ex)
{
}
return aDLDetailnStatus;
}
catch(Exception ex)
{
return null;
}
}
public static ADLDetailnStatus GetADLDetailnStatusByID(int id)
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
aDLDetailnStatus = sqlADLDetailnStatusProvider.GetADLDetailnStatusByID(id);
return(aDLDetailnStatus);
}
private void showADLDetailnStatusData()
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
aDLDetailnStatus = ADLDetailnStatusManager.GetADLDetailnStatusByID(Int32.Parse(Request.QueryString["aDLDetailnStatusID"]));
ddlADLDetail.SelectedValue = aDLDetailnStatus.ADLDetailID.ToString();
ddlADLStatus.SelectedValue = aDLDetailnStatus.ADLStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
aDLDetailnStatus.ADLDetailID = Int32.Parse(ddlADLDetail.SelectedValue);
aDLDetailnStatus.ADLStatusID = Int32.Parse(ddlADLStatus.SelectedValue);
int resutl = ADLDetailnStatusManager.InsertADLDetailnStatus(aDLDetailnStatus);
Response.Redirect("AdminADLDetailnStatusDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
aDLDetailnStatus = ADLDetailnStatusManager.GetADLDetailnStatusByID(Int32.Parse(Request.QueryString["aDLDetailnStatusID"]));
ADLDetailnStatus tempADLDetailnStatus = new ADLDetailnStatus();
tempADLDetailnStatus.ADLDetailnStatusID = aDLDetailnStatus.ADLDetailnStatusID;
tempADLDetailnStatus.ADLDetailID = Int32.Parse(ddlADLDetail.SelectedValue);
tempADLDetailnStatus.ADLStatusID = Int32.Parse(ddlADLStatus.SelectedValue);
bool result = ADLDetailnStatusManager.UpdateADLDetailnStatus(tempADLDetailnStatus);
Response.Redirect("AdminADLDetailnStatusDisplay.aspx");
}
public bool UpdateADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLDetailnStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDetailnStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailnStatusID;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailID;
cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public int InsertADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLDetailnStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDetailnStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailID;
cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@ADLDetailnStatusID"].Value);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (DataListItem item in dlStatus.Items)
{
CheckBox chkSelect = (CheckBox)item.FindControl("chkSelect");
if (chkSelect.Checked && chkSelect.ToolTip == "0") //newly selected
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus();
aDLDetailnStatus.ADLDetailID = Int32.Parse(ddlADLDetail.SelectedValue);
aDLDetailnStatus.ADLStatusID = Int32.Parse(chkSelect.ValidationGroup);
int resutl = ADLDetailnStatusManager.InsertADLDetailnStatus(aDLDetailnStatus);
}
else
if (!chkSelect.Checked && chkSelect.ToolTip != "0") //Need to delete
{
ADLDetailnStatusManager.DeleteADLDetailnStatus(int.Parse(chkSelect.ToolTip));
}
}
}
public ADLDetailnStatus GetADLDetailnStatusFromReader(IDataReader reader)
{
try
{
ADLDetailnStatus aDLDetailnStatus = new ADLDetailnStatus
(
(int)reader["ADLDetailnStatusID"],
(int)reader["ADLDetailID"],
(int)reader["ADLStatusID"]
);
try
{
aDLDetailnStatus.ADLStatusName = reader["ADLStatusName"].ToString();
}
catch (Exception ex)
{
}
return(aDLDetailnStatus);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
return(sqlADLDetailnStatusProvider.UpdateADLDetailnStatus(aDLDetailnStatus));
}
public static int InsertADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
return(sqlADLDetailnStatusProvider.InsertADLDetailnStatus(aDLDetailnStatus));
}
public static bool UpdateADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
return sqlADLDetailnStatusProvider.UpdateADLDetailnStatus(aDLDetailnStatus);
}
public static int InsertADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
SqlADLDetailnStatusProvider sqlADLDetailnStatusProvider = new SqlADLDetailnStatusProvider();
return sqlADLDetailnStatusProvider.InsertADLDetailnStatus(aDLDetailnStatus);
}
public bool UpdateADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLDetailnStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDetailnStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailnStatusID;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailID;
cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertADLDetailnStatus(ADLDetailnStatus aDLDetailnStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLDetailnStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDetailnStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetailnStatus.ADLDetailID;
cmd.Parameters.Add("@ADLStatusID", SqlDbType.Int).Value = aDLDetailnStatus.ADLStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ADLDetailnStatusID"].Value;
}
}
