public static AssessmentnCareChildnDate GetAssessmentnCareChildnDateByID(int id) { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate(); SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); assessmentnCareChildnDate = sqlAssessmentnCareChildnDateProvider.GetAssessmentnCareChildnDateByID(id); return assessmentnCareChildnDate; }
public static AssessmentnCareChildnDate GetAssessmentnCareChildnDateByID(int id) { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate(); SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); assessmentnCareChildnDate = sqlAssessmentnCareChildnDateProvider.GetAssessmentnCareChildnDateByID(id); return(assessmentnCareChildnDate); }
private void showAssessmentnCareChildnDateData() { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate(); assessmentnCareChildnDate = AssessmentnCareChildnDateManager.GetAssessmentnCareChildnDateByID(Int32.Parse(Request.QueryString["assessmentnCareChildnDateID"])); ddlAssessmentnCareChild.SelectedValue = assessmentnCareChildnDate.AssessmentnCareChildID.ToString(); ddlAssessmentnCareDate.SelectedValue = assessmentnCareChildnDate.AssessmentnCareDateID.ToString(); }
protected void btnAdd_Click(object sender, EventArgs e) { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate(); assessmentnCareChildnDate.AssessmentnCareChildID = Int32.Parse(ddlAssessmentnCareChild.SelectedValue); assessmentnCareChildnDate.AssessmentnCareDateID = Int32.Parse(ddlAssessmentnCareDate.SelectedValue); int resutl = AssessmentnCareChildnDateManager.InsertAssessmentnCareChildnDate(assessmentnCareChildnDate); Response.Redirect("AdminAssessmentnCareChildnDateDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate(); assessmentnCareChildnDate = AssessmentnCareChildnDateManager.GetAssessmentnCareChildnDateByID(Int32.Parse(Request.QueryString["assessmentnCareChildnDateID"])); AssessmentnCareChildnDate tempAssessmentnCareChildnDate = new AssessmentnCareChildnDate(); tempAssessmentnCareChildnDate.AssessmentnCareChildnDateID = assessmentnCareChildnDate.AssessmentnCareChildnDateID; tempAssessmentnCareChildnDate.AssessmentnCareChildID = Int32.Parse(ddlAssessmentnCareChild.SelectedValue); tempAssessmentnCareChildnDate.AssessmentnCareDateID = Int32.Parse(ddlAssessmentnCareDate.SelectedValue); bool result = AssessmentnCareChildnDateManager.UpdateAssessmentnCareChildnDate(tempAssessmentnCareChildnDate); Response.Redirect("AdminAssessmentnCareChildnDateDisplay.aspx"); }
public bool UpdateAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChildnDate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildnDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildnDateID; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareDateID; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public int InsertAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareChildnDate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildnDateID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareDateID; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@AssessmentnCareChildnDateID"].Value); } }
public AssessmentnCareChildnDate GetAssessmentnCareChildnDateFromReader(IDataReader reader) { try { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate ( (int)reader["AssessmentnCareChildnDateID"], (int)reader["AssessmentnCareChildID"], (int)reader["AssessmentnCareDateID"] ); return(assessmentnCareChildnDate); } catch (Exception ex) { return(null); } }
public AssessmentnCareChildnDate GetAssessmentnCareChildnDateFromReader(IDataReader reader) { try { AssessmentnCareChildnDate assessmentnCareChildnDate = new AssessmentnCareChildnDate ( (int)reader["AssessmentnCareChildnDateID"], (int)reader["AssessmentnCareChildID"], (int)reader["AssessmentnCareDateID"] ); return assessmentnCareChildnDate; } catch(Exception ex) { return null; } }
public bool UpdateAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChildnDate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildnDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildnDateID; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareDateID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareChildnDate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AssessmentnCareChildnDateID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareChildID; cmd.Parameters.Add("@AssessmentnCareDateID", SqlDbType.Int).Value = assessmentnCareChildnDate.AssessmentnCareDateID; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@AssessmentnCareChildnDateID"].Value; } }
public static bool UpdateAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); return sqlAssessmentnCareChildnDateProvider.UpdateAssessmentnCareChildnDate(assessmentnCareChildnDate); }
public static int InsertAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); return sqlAssessmentnCareChildnDateProvider.InsertAssessmentnCareChildnDate(assessmentnCareChildnDate); }
public static bool UpdateAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); return(sqlAssessmentnCareChildnDateProvider.UpdateAssessmentnCareChildnDate(assessmentnCareChildnDate)); }
public static int InsertAssessmentnCareChildnDate(AssessmentnCareChildnDate assessmentnCareChildnDate) { SqlAssessmentnCareChildnDateProvider sqlAssessmentnCareChildnDateProvider = new SqlAssessmentnCareChildnDateProvider(); return(sqlAssessmentnCareChildnDateProvider.InsertAssessmentnCareChildnDate(assessmentnCareChildnDate)); }