public AssessmentnCareChild GetAssessmentnCareChildFromReader(IDataReader reader) { try { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild ( (int)reader["AssessmentnCareChildID"], (int)reader["AssessmentnCareParentID"], reader["AssessmentnCareChildName"].ToString() ); try { assessmentnCareChild.AssessmentnCareParentName = reader["AssessmentnCareParentName"].ToString(); } catch (Exception ex) { } return(assessmentnCareChild); } catch (Exception ex) { return(null); } }
public static AssessmentnCareChild GetAssessmentnCareChildByID(int id) { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild(); SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); assessmentnCareChild = sqlAssessmentnCareChildProvider.GetAssessmentnCareChildByID(id); return assessmentnCareChild; }
public static AssessmentnCareChild GetAssessmentnCareChildByID(int id) { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild(); SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); assessmentnCareChild = sqlAssessmentnCareChildProvider.GetAssessmentnCareChildByID(id); return(assessmentnCareChild); }
private void showAssessmentnCareChildData() { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild(); assessmentnCareChild = AssessmentnCareChildManager.GetAssessmentnCareChildByID(Int32.Parse(Request.QueryString["assessmentnCareChildID"])); ddlAssessmentnCareParent.SelectedValue = assessmentnCareChild.AssessmentnCareParentID.ToString(); txtAssessmentnCareChildName.Text = assessmentnCareChild.AssessmentnCareChildName; }
protected void btnAdd_Click(object sender, EventArgs e) { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild(); assessmentnCareChild.AssessmentnCareParentID = Int32.Parse(ddlAssessmentnCareParent.SelectedValue); assessmentnCareChild.AssessmentnCareChildName = txtAssessmentnCareChildName.Text; int resutl = AssessmentnCareChildManager.InsertAssessmentnCareChild(assessmentnCareChild); txtAssessmentnCareChildName.Text = ""; //Response.Redirect("AdminAssessmentnCareChildDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild(); assessmentnCareChild = AssessmentnCareChildManager.GetAssessmentnCareChildByID(Int32.Parse(Request.QueryString["assessmentnCareChildID"])); AssessmentnCareChild tempAssessmentnCareChild = new AssessmentnCareChild(); tempAssessmentnCareChild.AssessmentnCareChildID = assessmentnCareChild.AssessmentnCareChildID; tempAssessmentnCareChild.AssessmentnCareParentID = Int32.Parse(ddlAssessmentnCareParent.SelectedValue); tempAssessmentnCareChild.AssessmentnCareChildName = txtAssessmentnCareChildName.Text; bool result = AssessmentnCareChildManager.UpdateAssessmentnCareChild(tempAssessmentnCareChild); Response.Redirect("AssessmentnCare.aspx"); }
public bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChild", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID; cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public static bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); return sqlAssessmentnCareChildProvider.UpdateAssessmentnCareChild(assessmentnCareChild); }
public static int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); return sqlAssessmentnCareChildProvider.InsertAssessmentnCareChild(assessmentnCareChild); }
public AssessmentnCareChild GetAssessmentnCareChildFromReader(IDataReader reader) { try { AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild ( (int)reader["AssessmentnCareChildID"], (int)reader["AssessmentnCareParentID"], reader["AssessmentnCareChildName"].ToString() ); try { assessmentnCareChild.AssessmentnCareParentName = reader["AssessmentnCareParentName"].ToString(); } catch (Exception ex) { } return assessmentnCareChild; } catch(Exception ex) { return null; } }
public bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChild", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID; cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareChild", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID; cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@AssessmentnCareChildID"].Value; } }
public static bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); return(sqlAssessmentnCareChildProvider.UpdateAssessmentnCareChild(assessmentnCareChild)); }
public static int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild) { SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider(); return(sqlAssessmentnCareChildProvider.InsertAssessmentnCareChild(assessmentnCareChild)); }