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);
    }
Example #3
0
    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();
    }
Example #4
0
    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");
    }
Example #5
0
    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");
    }
Example #6
0
    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);
        }
    }
Example #7
0
    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);
        }
    }
Example #8
0
 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));
    }