public static ADLHeader GetADLHeaderByID(int id)
{
ADLHeader aDLHeader = new ADLHeader();
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
aDLHeader = sqlADLHeaderProvider.GetADLHeaderByID(id);
return aDLHeader;
}
public static ADLHeader GetADLHeaderByID(int id)
{
ADLHeader aDLHeader = new ADLHeader();
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
aDLHeader = sqlADLHeaderProvider.GetADLHeaderByID(id);
return(aDLHeader);
}
private void showADLHeaderData()
{
ADLHeader aDLHeader = new ADLHeader();
aDLHeader = ADLHeaderManager.GetADLHeaderByID(Int32.Parse(Request.QueryString["aDLHeaderID"]));
txtADLHeaderName.Text = aDLHeader.ADLHeaderName;
txtExtraField1.Text = aDLHeader.ExtraField1;
txtExtraField2.Text = aDLHeader.ExtraField2;
txtExtraField3.Text = aDLHeader.ExtraField3;
txtExtraField4.Text = aDLHeader.ExtraField4;
txtExtraField5.Text = aDLHeader.ExtraField5;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLHeader aDLHeader = new ADLHeader();
aDLHeader.ADLHeaderName = txtADLHeaderName.Text;
aDLHeader.ExtraField1 = txtExtraField1.Text;
aDLHeader.ExtraField2 = txtExtraField2.Text;
aDLHeader.ExtraField3 = txtExtraField3.Text;
aDLHeader.ExtraField4 = txtExtraField4.Text;
aDLHeader.ExtraField5 = txtExtraField5.Text;
int resutl = ADLHeaderManager.InsertADLHeader(aDLHeader);
Response.Redirect("AdminADLHeaderDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLHeader aDLHeader = new ADLHeader();
aDLHeader = ADLHeaderManager.GetADLHeaderByID(Int32.Parse(Request.QueryString["aDLHeaderID"]));
ADLHeader tempADLHeader = new ADLHeader();
tempADLHeader.ADLHeaderID = aDLHeader.ADLHeaderID;
tempADLHeader.ADLHeaderName = txtADLHeaderName.Text;
tempADLHeader.ExtraField1 = txtExtraField1.Text;
tempADLHeader.ExtraField2 = txtExtraField2.Text;
tempADLHeader.ExtraField3 = txtExtraField3.Text;
tempADLHeader.ExtraField4 = txtExtraField4.Text;
tempADLHeader.ExtraField5 = txtExtraField5.Text;
bool result = ADLHeaderManager.UpdateADLHeader(tempADLHeader);
Response.Redirect("AdminADLHeaderDisplay.aspx");
}
public bool UpdateADLHeader(ADLHeader aDLHeader)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeader", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderID", SqlDbType.Int).Value = aDLHeader.ADLHeaderID;
cmd.Parameters.Add("@ADLHeaderName", SqlDbType.NVarChar).Value = aDLHeader.ADLHeaderName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLHeader.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLHeader.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLHeader.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLHeader.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLHeader.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public ADLHeader GetADLHeaderFromReader(IDataReader reader)
{
try
{
ADLHeader aDLHeader = new ADLHeader
(
(int)reader["ADLHeaderID"],
reader["ADLHeaderName"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
return(aDLHeader);
}
catch (Exception ex)
{
return(null);
}
}
public ADLHeader GetADLHeaderFromReader(IDataReader reader)
{
try
{
ADLHeader aDLHeader = new ADLHeader
(
(int)reader["ADLHeaderID"],
reader["ADLHeaderName"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
return aDLHeader;
}
catch(Exception ex)
{
return null;
}
}
private void showHeaderDetailByResidentID()
{
List <ADLHeaderDetail> aDLHeaderDetailByResident = ADLHeaderDetailManager.GetAllADLHeaderDetailsByResidentID(int.Parse(Request.QueryString["ResidentID"]));
if (aDLHeaderDetailByResident.Count == 0)
{
aDLHeaderDetailByResident = ADLHeaderDetailManager.GetDefaultAfterInsertADLHeaderDetails(int.Parse(Request.QueryString["ResidentID"]));
}
List <ADLHeader> aDLHeaderbyResident = new List <ADLHeader>();
foreach (ADLHeaderDetail item in aDLHeaderDetailByResident)
{
bool needToAdd = true;
if (aDLHeaderbyResident.Count != 0)
{
foreach (ADLHeader itm in aDLHeaderbyResident)
{
if (itm.ADLHeaderID == item.ADLHeaderID)
{
needToAdd = false;
break;
}
}
}
if (needToAdd)
{
ADLHeader newADLHeader = new ADLHeader();
newADLHeader.ADLHeaderID = item.ADLHeaderID;
newADLHeader.ADLHeaderName = item.ExtraField1;
aDLHeaderbyResident.Add(newADLHeader);
}
}
gvHeader.DataSource = aDLHeaderbyResident;
gvHeader.DataBind();
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
List <ADLDetail> aDLDetailbyResident = new List <ADLDetail>();
foreach (ADLHeaderDetail item in aDLHeaderDetailByResident)
{
if (item.ADLHeaderID.ToString() == hfADLHeaderID.Value)
{
bool needToAdd = true;
if (aDLDetailbyResident.Count != 0)
{
foreach (ADLDetail itm in aDLDetailbyResident)
{
if (itm.ADLDetailID == item.ADLDetailID)
{
needToAdd = false;
break;
}
}
}
if (needToAdd)
{
ADLDetail newADLDetail = new ADLDetail();
newADLDetail.ADLDetailID = item.ADLDetailID;
newADLDetail.ADLDetailName = item.ExtraField2;
newADLDetail.ExtraField1 = item.ADLHeaderDetailID.ToString();
aDLDetailbyResident.Add(newADLDetail);
}
}
}
gvDetail.DataSource = aDLDetailbyResident;
gvDetail.DataBind();
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
HiddenField hfADLDetailID = (HiddenField)gvrDetail.FindControl("hfADLDetailID");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
ddlADLStatusInGrid.Items.Clear();
ListItem li = new ListItem("Select >>", "-1");
ddlADLStatusInGrid.Items.Add(li);
foreach (ListItem item in ddlADLStatus.Items)
{
if (item.Value == hfADLDetailID.Value)
{
ddlADLStatusInGrid.Items.Add(new ListItem(item.Text, item.Text));
rbtnlADLStatusInGrid.Items.Add(new ListItem(item.Text, item.Text));
}
}
//li = new ListItem("Other", "0");
//ddlADLStatusInGrid.Items.Add(li);
//rbtnlADLStatusInGrid.Items.Add(li);
//rbtnlADLStatusInGrid.SelectedIndex = 0;
}
}
}
public static bool UpdateADLHeader(ADLHeader aDLHeader)
{
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
return sqlADLHeaderProvider.UpdateADLHeader(aDLHeader);
}
public static int InsertADLHeader(ADLHeader aDLHeader)
{
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
return sqlADLHeaderProvider.InsertADLHeader(aDLHeader);
}
public static bool UpdateADLHeader(ADLHeader aDLHeader)
{
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
return(sqlADLHeaderProvider.UpdateADLHeader(aDLHeader));
}
public static int InsertADLHeader(ADLHeader aDLHeader)
{
SqlADLHeaderProvider sqlADLHeaderProvider = new SqlADLHeaderProvider();
return(sqlADLHeaderProvider.InsertADLHeader(aDLHeader));
}
public bool UpdateADLHeader(ADLHeader aDLHeader)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLHeader", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLHeaderID", SqlDbType.Int).Value = aDLHeader.ADLHeaderID;
cmd.Parameters.Add("@ADLHeaderName", SqlDbType.NVarChar).Value = aDLHeader.ADLHeaderName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLHeader.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLHeader.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLHeader.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLHeader.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLHeader.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
