public static ADLHeaderDetail GetADLHeaderDetailByID(int id)
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
aDLHeaderDetail = sqlADLHeaderDetailProvider.GetADLHeaderDetailByID(id);
return aDLHeaderDetail;
}
public ADLHeaderDetail GetADLHeaderDetailFromReader(IDataReader reader)
{
try
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail
(
(int)reader["ADLHeaderDetailID"],
(int)reader["ADLDetailID"],
(int)reader["ADLHeaderID"],
(int)reader["ResidentID"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
try
{
aDLHeaderDetail.ExtraField1 = reader["ADLHeaderName"].ToString();
aDLHeaderDetail.ExtraField2 = reader["ADLDetailName"].ToString();
}
catch (Exception ex)
{ }
return aDLHeaderDetail;
}
catch(Exception ex)
{
return null;
}
}
protected void btnSaveNewADL_Click(object sender, EventArgs e)
{
foreach (DataListItem item in dlADLDetail.Items)
{
CheckBox chkSelect = (CheckBox)item.FindControl("chkSelect");
if (chkSelect.Checked && chkSelect.ToolTip == "0") //newly selected
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
aDLHeaderDetail.ADLDetailID = Int32.Parse(chkSelect.ValidationGroup);
aDLHeaderDetail.ADLHeaderID = Int32.Parse(ddlADLHeader.SelectedValue);
aDLHeaderDetail.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
aDLHeaderDetail.ExtraField1 = "";
aDLHeaderDetail.ExtraField2 = "";
aDLHeaderDetail.ExtraField3 = "";
aDLHeaderDetail.ExtraField4 = "";
aDLHeaderDetail.ExtraField5 = "";
int resutl = ADLHeaderDetailManager.InsertADLHeaderDetail(aDLHeaderDetail);
}
else
if (!chkSelect.Checked && chkSelect.ToolTip != "0") //Need to delete
{
ADLHeaderDetailManager.DeleteADLHeaderDetail(int.Parse(chkSelect.ToolTip));
}
}
lblNewADLSaveMessage.Visible = true;
lblNewADLSaveMessage.ForeColor = System.Drawing.Color.Green;
loadADLDetailStatus();
loadGrid();
ddlADLHeader_SelectedIndexChanged(this, new EventArgs());
}
public ADLHeaderDetail GetADLHeaderDetailFromReader(IDataReader reader)
{
try
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail
(
(int)reader["ADLHeaderDetailID"],
(int)reader["ADLDetailID"],
(int)reader["ADLHeaderID"],
(int)reader["ResidentID"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
try
{
aDLHeaderDetail.ExtraField1 = reader["ADLHeaderName"].ToString();
aDLHeaderDetail.ExtraField2 = reader["ADLDetailName"].ToString();
}
catch (Exception ex)
{ }
return(aDLHeaderDetail);
}
catch (Exception ex)
{
return(null);
}
}
public static ADLHeaderDetail GetADLHeaderDetailByID(int id)
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
aDLHeaderDetail = sqlADLHeaderDetailProvider.GetADLHeaderDetailByID(id);
return(aDLHeaderDetail);
}
private void showADLHeaderDetailData()
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
aDLHeaderDetail = ADLHeaderDetailManager.GetADLHeaderDetailByID(Int32.Parse(Request.QueryString["aDLHeaderDetailID"]));
ddlADLDetail.SelectedValue = aDLHeaderDetail.ADLDetailID.ToString();
ddlADLHeader.SelectedValue = aDLHeaderDetail.ADLHeaderID.ToString();
ddlResident.SelectedValue = aDLHeaderDetail.ResidentID.ToString();
txtExtraField1.Text = aDLHeaderDetail.ExtraField1;
txtExtraField2.Text = aDLHeaderDetail.ExtraField2;
txtExtraField3.Text = aDLHeaderDetail.ExtraField3;
txtExtraField4.Text = aDLHeaderDetail.ExtraField4;
txtExtraField5.Text = aDLHeaderDetail.ExtraField5;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
aDLHeaderDetail.ADLDetailID = Int32.Parse(ddlADLDetail.SelectedValue);
aDLHeaderDetail.ADLHeaderID = Int32.Parse(ddlADLHeader.SelectedValue);
aDLHeaderDetail.ResidentID = Int32.Parse(ddlResident.SelectedValue);
aDLHeaderDetail.ExtraField1 = txtExtraField1.Text;
aDLHeaderDetail.ExtraField2 = txtExtraField2.Text;
aDLHeaderDetail.ExtraField3 = txtExtraField3.Text;
aDLHeaderDetail.ExtraField4 = txtExtraField4.Text;
aDLHeaderDetail.ExtraField5 = txtExtraField5.Text;
int resutl = ADLHeaderDetailManager.InsertADLHeaderDetail(aDLHeaderDetail);
Response.Redirect("AdminADLHeaderDetailDisplay.aspx");
}
public bool UpdateADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeaderDetail", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailID", SqlDbType.Int).Value = aDLHeaderDetail.ADLHeaderDetailID;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLHeaderDetail.ADLDetailID;
cmd.Parameters.Add("@ADLHeaderID", SqlDbType.Int).Value = aDLHeaderDetail.ADLHeaderID;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = aDLHeaderDetail.ResidentID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLHeaderDetail aDLHeaderDetail = new ADLHeaderDetail();
aDLHeaderDetail = ADLHeaderDetailManager.GetADLHeaderDetailByID(Int32.Parse(Request.QueryString["aDLHeaderDetailID"]));
ADLHeaderDetail tempADLHeaderDetail = new ADLHeaderDetail();
tempADLHeaderDetail.ADLHeaderDetailID = aDLHeaderDetail.ADLHeaderDetailID;
tempADLHeaderDetail.ADLDetailID = Int32.Parse(ddlADLDetail.SelectedValue);
tempADLHeaderDetail.ADLHeaderID = Int32.Parse(ddlADLHeader.SelectedValue);
tempADLHeaderDetail.ResidentID = Int32.Parse(ddlResident.SelectedValue);
tempADLHeaderDetail.ExtraField1 = txtExtraField1.Text;
tempADLHeaderDetail.ExtraField2 = txtExtraField2.Text;
tempADLHeaderDetail.ExtraField3 = txtExtraField3.Text;
tempADLHeaderDetail.ExtraField4 = txtExtraField4.Text;
tempADLHeaderDetail.ExtraField5 = txtExtraField5.Text;
bool result = ADLHeaderDetailManager.UpdateADLHeaderDetail(tempADLHeaderDetail);
Response.Redirect("AdminADLHeaderDetailDisplay.aspx");
}
public static bool UpdateADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
return sqlADLHeaderDetailProvider.UpdateADLHeaderDetail(aDLHeaderDetail);
}
public static int InsertADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
return sqlADLHeaderDetailProvider.InsertADLHeaderDetail(aDLHeaderDetail);
}
public bool UpdateADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeaderDetail", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderDetailID", SqlDbType.Int).Value = aDLHeaderDetail.ADLHeaderDetailID;
cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLHeaderDetail.ADLDetailID;
cmd.Parameters.Add("@ADLHeaderID", SqlDbType.Int).Value = aDLHeaderDetail.ADLHeaderID;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = aDLHeaderDetail.ResidentID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLHeaderDetail.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static bool UpdateADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
return(sqlADLHeaderDetailProvider.UpdateADLHeaderDetail(aDLHeaderDetail));
}
public static int InsertADLHeaderDetail(ADLHeaderDetail aDLHeaderDetail)
{
SqlADLHeaderDetailProvider sqlADLHeaderDetailProvider = new SqlADLHeaderDetailProvider();
return(sqlADLHeaderDetailProvider.InsertADLHeaderDetail(aDLHeaderDetail));
}
