Example #1
0
 public static ADLDetail GetADLDetailByID(int id)
 {
     ADLDetail aDLDetail = new ADLDetail();
     SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();
     aDLDetail = sqlADLDetailProvider.GetADLDetailByID(id);
     return aDLDetail;
 }
Example #2
0
    public static ADLDetail GetADLDetailByID(int id)
    {
        ADLDetail            aDLDetail            = new ADLDetail();
        SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();

        aDLDetail = sqlADLDetailProvider.GetADLDetailByID(id);
        return(aDLDetail);
    }
Example #3
0
    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;
    }
Example #4
0
    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");
    }
Example #5
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);
        }
    }
Example #6
0
    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");
    }
Example #7
0
 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);
     }
 }
Example #8
0
 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;
     }
 }
Example #9
0
 public static bool UpdateADLDetail(ADLDetail aDLDetail)
 {
     SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();
     return sqlADLDetailProvider.UpdateADLDetail(aDLDetail);
 }
Example #10
0
 public static int InsertADLDetail(ADLDetail aDLDetail)
 {
     SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();
     return sqlADLDetailProvider.InsertADLDetail(aDLDetail);
 }
Example #11
0
    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;
            }
        }
    }
Example #12
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;
        }
    }
Example #13
0
    public static bool UpdateADLDetail(ADLDetail aDLDetail)
    {
        SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();

        return(sqlADLDetailProvider.UpdateADLDetail(aDLDetail));
    }
Example #14
0
    public static int InsertADLDetail(ADLDetail aDLDetail)
    {
        SqlADLDetailProvider sqlADLDetailProvider = new SqlADLDetailProvider();

        return(sqlADLDetailProvider.InsertADLDetail(aDLDetail));
    }