public static ADLDetail GetADLDetailByID(int id) { ADLDetail aDLDetail = new ADLDetail(); SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); aDLDetail = sqlADLDetailProvider.GetADLDetailByID(id); return aDLDetail; }
public static ADLDetail GetADLDetailByID(int id) { ADLDetail aDLDetail = new ADLDetail(); SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); aDLDetail = sqlADLDetailProvider.GetADLDetailByID(id); return(aDLDetail); }
private void showADLDetailData() { ADLDetail aDLDetail = new ADLDetail(); aDLDetail = ADLDetailManager.GetADLDetailByID(Int32.Parse(Request.QueryString["aDLDetailID"])); txtADLDetailName.Text = aDLDetail.ADLDetailName; txtExtraField1.Text = aDLDetail.ExtraField1; txtExtraField2.Text = aDLDetail.ExtraField2; txtExtraField3.Text = aDLDetail.ExtraField3; txtExtraField4.Text = aDLDetail.ExtraField4; txtExtraField5.Text = aDLDetail.ExtraField5; }
protected void btnAdd_Click(object sender, EventArgs e) { ADLDetail aDLDetail = new ADLDetail(); aDLDetail.ADLDetailName = txtADLDetailName.Text; aDLDetail.ExtraField1 = txtExtraField1.Text; aDLDetail.ExtraField2 = txtExtraField2.Text; aDLDetail.ExtraField3 = txtExtraField3.Text; aDLDetail.ExtraField4 = txtExtraField4.Text; aDLDetail.ExtraField5 = txtExtraField5.Text; int resutl = ADLDetailManager.InsertADLDetail(aDLDetail); Response.Redirect("AdminADLDetailDisplay.aspx"); }
public bool UpdateADLDetail(ADLDetail aDLDetail) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateADLDetail", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetail.ADLDetailID; cmd.Parameters.Add("@ADLDetailName", SqlDbType.NVarChar).Value = aDLDetail.ADLDetailName; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLDetail.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLDetail.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLDetail.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLDetail.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLDetail.ExtraField5; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
protected void btnUpdate_Click(object sender, EventArgs e) { ADLDetail aDLDetail = new ADLDetail(); aDLDetail = ADLDetailManager.GetADLDetailByID(Int32.Parse(Request.QueryString["aDLDetailID"])); ADLDetail tempADLDetail = new ADLDetail(); tempADLDetail.ADLDetailID = aDLDetail.ADLDetailID; tempADLDetail.ADLDetailName = txtADLDetailName.Text; tempADLDetail.ExtraField1 = txtExtraField1.Text; tempADLDetail.ExtraField2 = txtExtraField2.Text; tempADLDetail.ExtraField3 = txtExtraField3.Text; tempADLDetail.ExtraField4 = txtExtraField4.Text; tempADLDetail.ExtraField5 = txtExtraField5.Text; bool result = ADLDetailManager.UpdateADLDetail(tempADLDetail); Response.Redirect("AdminADLDetailDisplay.aspx"); }
public ADLDetail GetADLDetailFromReader(IDataReader reader) { try { ADLDetail aDLDetail = new ADLDetail ( (int)reader["ADLDetailID"], reader["ADLDetailName"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString(), reader["ExtraField4"].ToString(), reader["ExtraField5"].ToString() ); return(aDLDetail); } catch (Exception ex) { return(null); } }
public ADLDetail GetADLDetailFromReader(IDataReader reader) { try { ADLDetail aDLDetail = new ADLDetail ( (int)reader["ADLDetailID"], reader["ADLDetailName"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString(), reader["ExtraField4"].ToString(), reader["ExtraField5"].ToString() ); return aDLDetail; } catch(Exception ex) { return null; } }
public static bool UpdateADLDetail(ADLDetail aDLDetail) { SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); return sqlADLDetailProvider.UpdateADLDetail(aDLDetail); }
public static int InsertADLDetail(ADLDetail aDLDetail) { SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); return sqlADLDetailProvider.InsertADLDetail(aDLDetail); }
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 bool UpdateADLDetail(ADLDetail aDLDetail) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateADLDetail", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ADLDetailID", SqlDbType.Int).Value = aDLDetail.ADLDetailID; cmd.Parameters.Add("@ADLDetailName", SqlDbType.NVarChar).Value = aDLDetail.ADLDetailName; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aDLDetail.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aDLDetail.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aDLDetail.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aDLDetail.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aDLDetail.ExtraField5; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public static bool UpdateADLDetail(ADLDetail aDLDetail) { SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); return(sqlADLDetailProvider.UpdateADLDetail(aDLDetail)); }
public static int InsertADLDetail(ADLDetail aDLDetail) { SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider(); return(sqlADLDetailProvider.InsertADLDetail(aDLDetail)); }