Esempio n. 1
0
        /// <summary>
        /// get all data by ID
        /// </summary>
        /// <param name="LivRestBudgID"></param>
        /// <returns></returns>
        public LivelihoodRestBudgetBO GetLiveRestBudgetById(int LivRestBudgID)
        {
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_LIV_RES_BUDG_BYID";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("liv_res_budgid_", LivRestBudgID);
            cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();

            OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            LivelihoodRestBudgetBO   objLivelihoodRestBudgetBO = null;
            LivelihoodRestBudgetList oLivelihoodRestBudgetList = new LivelihoodRestBudgetList();

            objLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();

            while (dr.Read())
            {
                objLivelihoodRestBudgetBO = MapData(dr);
            }
            dr.Close();

            return(objLivelihoodRestBudgetBO);
        }
Esempio n. 2
0
        /// <summary>
        /// get all data
        /// </summary>
        /// <param name="projectID"></param>
        /// <returns></returns>
        public LivelihoodRestBudgetList GetLiveRestBudget(int projectID)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_LIV_RES_BUDG";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("projectid_", projectID);
            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            LivelihoodRestBudgetBO   objLivelihoodRestBudgetBO = null;
            LivelihoodRestBudgetList oLivelihoodRestBudgetList = new LivelihoodRestBudgetList();

            while (dr.Read())
            {
                objLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();

                objLivelihoodRestBudgetBO = MapData(dr);

                oLivelihoodRestBudgetList.Add(objLivelihoodRestBudgetBO);
            }

            dr.Close();

            return(oLivelihoodRestBudgetList);
        }
Esempio n. 3
0
        /// <summary>
        /// To Delete
        /// </summary>
        private void DeleteLivRestBudget()
        {
            LivelihoodRestBudgetBO  oLiveRestBudgetBO  = new LivelihoodRestBudgetBO();
            LivelihoodRestBudgetBLL oLiveRestBudgetBLL = new LivelihoodRestBudgetBLL();

            if (ViewStateLivRestBudgetID > 0)
            {
                oLiveRestBudgetBLL.DeleteLiveRestBudget(ViewStateLivRestBudgetID);
            }
        }
Esempio n. 4
0
        /// <summary>
        /// To Update Live Rest Budget
        /// </summary>
        /// <param name="oLivelihoodRestBudgetBO"></param>
        /// <returns></returns>
        public string UpdateLiveRestBudget(LivelihoodRestBudgetBO oLivelihoodRestBudgetBO)
        {
            oLiveRestBudgetDAL = new LivelihoodRestBudgetDAL();

            return(oLiveRestBudgetDAL.UpdateLiveRestBudget(oLivelihoodRestBudgetBO));
        }
Esempio n. 5
0
        /// <summary>
        /// TO Add Live Rest Budget
        /// </summary>
        /// <param name="oLivelihoodRestBudgetBO"></param>
        /// <returns></returns>
        public string[] AddLiveRestBudget(LivelihoodRestBudgetBO oLivelihoodRestBudgetBO)
        {
            oLiveRestBudgetDAL = new LivelihoodRestBudgetDAL();

            return(oLiveRestBudgetDAL.AddLiveRestBudget(oLivelihoodRestBudgetBO));
        }
Esempio n. 6
0
        /// <summary>
        /// Get Data by ID
        /// </summary>
        private void getLiveRestBudgetById()
        {
            LivelihoodRestBudgetBO  oLiveRestBudgetBO  = new LivelihoodRestBudgetBO();
            LivelihoodRestBudgetBLL oLiveRestBudgetBLL = new LivelihoodRestBudgetBLL();

            if (ViewStateLivRestBudgetID > 0)
            {
                oLiveRestBudgetBO         = oLiveRestBudgetBLL.GetLiveRestBudgetByID(ViewStateLivRestBudgetID);
                ddlCategory.SelectedValue = oLiveRestBudgetBO.Liv_Bud_CategID.ToString();
                LoadRestoreItems();

                ddlItem.ClearSelection();
                if (ddlItem.Items.FindByValue(oLiveRestBudgetBO.Liv_Bud_ItemID.ToString()) != null)
                {
                    ddlItem.Items.FindByValue(oLiveRestBudgetBO.Liv_Bud_ItemID.ToString()).Selected = true;
                }
                // ddlItem.SelectedValue = oLiveRestBudgetBO.Liv_Bud_ItemID.ToString();

                //Item Change Event
                #region
                LivelihoodBudgetItemsList lstLiveBudgItems  = new LivelihoodBudgetItemsList();
                LivelihoodBudgetItemsBLL  oLiveBudgItemsBLL = new LivelihoodBudgetItemsBLL();
                LivelihoodBudgetItemsBO   oLiveBudgItemsBO  = new LivelihoodBudgetItemsBO();
                oLiveBudgItemsBO.Liv_Bud_CategID = Convert.ToInt32(ddlCategory.SelectedValue.ToString());

                if (ddlItem.SelectedIndex > 0)
                {
                    oLiveBudgItemsBO.Liv_Bud_ItemID = Convert.ToInt32(ddlItem.SelectedValue.ToString());

                    lstLiveBudgItems = oLiveBudgItemsBLL.GetLivBudgetItems(oLiveBudgItemsBO);

                    if (lstLiveBudgItems.Count > 0)
                    {
                        if (lstLiveBudgItems[0].Liv_Bud_ItemDesc != null)
                        {
                            txtItemDescription.Text = lstLiveBudgItems[0].Liv_Bud_ItemDesc.ToString();
                        }
                        else
                        {
                            txtItemDescription.Text = string.Empty;
                        }
                    }
                }
                #endregion

                #region CheckBox Section
                if (oLiveRestBudgetBO.ImplCost == "Yes")
                {
                    chklst.Items[0].Selected = true;
                }
                else
                {
                    chklst.Items[0].Selected = false;
                }

                if (oLiveRestBudgetBO.OperCost == "Yes")
                {
                    chklst.Items[1].Selected = true;
                }
                else
                {
                    chklst.Items[1].Selected = false;
                }

                if (oLiveRestBudgetBO.ExternalMonitory == "Yes")
                {
                    chklst.Items[2].Selected = true;
                }
                else
                {
                    chklst.Items[2].Selected = false;
                }
                #endregion

                txtNoOfBeneficial.Text = oLiveRestBudgetBO.NoOfBeneficial.ToString();
                txtItemQuantity.Text   = oLiveRestBudgetBO.ItemQuantity.ToString();
                txtCostPerUnit.Text    = UtilBO.CurrencyFormat(oLiveRestBudgetBO.CostPerUnit);
                txtTotal.Text          = UtilBO.CurrencyFormat(oLiveRestBudgetBO.TotalAmount);
                txtComments.Text       = oLiveRestBudgetBO.Comments;

                ddlDistrict.ClearSelection();
                if (ddlDistrict.Items.FindByText(oLiveRestBudgetBO.District) != null)
                {
                    ddlDistrict.Items.FindByText(oLiveRestBudgetBO.District).Selected = true;
                }

                BindCounties();
                ddlCounty.ClearSelection();
                if (ddlCounty.Items.FindByText(oLiveRestBudgetBO.County) != null)
                {
                    ddlCounty.Items.FindByText(oLiveRestBudgetBO.County).Selected = true;
                }
                //ddlCounty.SelectedItem.Text = oLiveRestBudgetBO.County;

                BindSubCounties();
                ddlSubCounty.ClearSelection();
                if (ddlSubCounty.Items.FindByText(oLiveRestBudgetBO.SubCounty) != null)
                {
                    ddlSubCounty.Items.FindByText(oLiveRestBudgetBO.SubCounty).Selected = true;
                }
                //                ddlSubCounty.SelectedItem.Text = oLiveRestBudgetBO.SubCounty;

                BindParish();
                ddlParish.ClearSelection();
                if (ddlParish.Items.FindByText(oLiveRestBudgetBO.Parish) != null)
                {
                    ddlParish.Items.FindByText(oLiveRestBudgetBO.Parish).Selected = true;
                }
                //ddlParish.SelectedItem.Text = oLiveRestBudgetBO.Parish;

                BindVillages();
                lstbVillages.ClearSelection();
                LiveRestBudVillagesBLL  oLiveRestBudVillagesBLL  = new LiveRestBudVillagesBLL();
                LiveRestBudVillagesList oLiveRestBudVillagesList = new LiveRestBudVillagesList();
                if (ViewStateLivRestBudgetID > 0)
                {
                    oLiveRestBudVillagesList = oLiveRestBudVillagesBLL.GetLiveRestBudVillagesById(ViewStateLivRestBudgetID);
                    foreach (LiveRestBudVillagesBO objLiveRestBudVillagesBO in oLiveRestBudVillagesList)
                    {
                        if (lstbVillages.Items.FindByText(objLiveRestBudVillagesBO.Village) != null)
                        {
                            lstbVillages.Items.FindByText(objLiveRestBudVillagesBO.Village).Selected = true;
                        }
                        // lstbVillages.Items.Add(objLiveRestBudVillagesBO.Village);
                    }
                }

                // LoadVillages();
            }
        }
Esempio n. 7
0
        /// <summary>
        /// To Save And update Data
        /// </summary>
        private void AddLiveRestBudget()
        {
            LivelihoodRestBudgetBO  oLiveRestBudgetBO  = new LivelihoodRestBudgetBO();
            LivelihoodRestBudgetBLL oLiveRestBudgetBLL = new LivelihoodRestBudgetBLL();

            oLiveRestBudgetBO.IsDeleted = "False";
            oLiveRestBudgetBO.CreatedBy = SessionUserId;

            oLiveRestBudgetBO.Liv_Bud_ItemID  = Convert.ToInt32(ddlItem.SelectedValue.ToString());
            oLiveRestBudgetBO.Liv_Bud_CategID = Convert.ToInt32(ddlCategory.SelectedValue.ToString());

            //foreach(
            if (chklst.Items[0].Selected == true)
            {
                oLiveRestBudgetBO.ImplCost = "Yes";
            }
            else
            {
                oLiveRestBudgetBO.ImplCost = "No";
            }

            if (chklst.Items[1].Selected == true)
            {
                oLiveRestBudgetBO.OperCost = "Yes";
            }
            else
            {
                oLiveRestBudgetBO.OperCost = "No";
            }

            if (chklst.Items[2].Selected == true)
            {
                oLiveRestBudgetBO.ExternalMonitory = "Yes";
            }
            else
            {
                oLiveRestBudgetBO.ExternalMonitory = "No";
            }

            oLiveRestBudgetBO.NoOfBeneficial = Convert.ToDecimal(txtNoOfBeneficial.Text);
            oLiveRestBudgetBO.ItemQuantity   = Convert.ToDecimal(txtItemQuantity.Text);
            oLiveRestBudgetBO.CostPerUnit    = Convert.ToDecimal(txtCostPerUnit.Text);
            oLiveRestBudgetBO.TotalAmount    = Convert.ToDecimal(txtTotal.Text);

            oLiveRestBudgetBO.Comments = txtComments.Text;

            oLiveRestBudgetBO.District  = ddlDistrict.SelectedItem.Text;
            oLiveRestBudgetBO.County    = ddlCounty.SelectedItem.Text;
            oLiveRestBudgetBO.SubCounty = ddlSubCounty.SelectedItem.Text;
            oLiveRestBudgetBO.Parish    = ddlParish.SelectedItem.Text;
            oLiveRestBudgetBO.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
            string AlertMessage = string.Empty;
            string retMessage   = string.Empty;

            if (ViewStateLivRestBudgetID == 0)
            {
                //ADD SECTION
                string[] message = oLiveRestBudgetBLL.AddLiveRestBudget(oLiveRestBudgetBO);

                if (string.IsNullOrEmpty(message[0]) || message[0] == "" || message[0] == "null")
                {
                    // message[0] = "Insertion Successfull";
                    if (!string.IsNullOrEmpty(message[1]))
                    {
                        LiveRestBudVillagesBLL oLiveRestBudVillagesBLL = new LiveRestBudVillagesBLL();
                        LiveRestBudVillagesBO  oLiveRestBudVillagesBO  = new LiveRestBudVillagesBO();
                        oLiveRestBudVillagesBO.IsDeleted      = "False";
                        oLiveRestBudVillagesBO.CreatedBy      = SessionUserId;
                        oLiveRestBudVillagesBO.Liv_Res_BudgId = Convert.ToInt32(message[1]);

                        for (int i = 0; i < lstbVillages.Items.Count; i++)
                        {
                            if (lstbVillages.Items[i].Selected)
                            {
                                oLiveRestBudVillagesBO.Village = lstbVillages.Items[i].Text;
                                retMessage = oLiveRestBudVillagesBLL.AddLiveRestBudVillages(oLiveRestBudVillagesBO);
                            }
                        }
                        if (string.IsNullOrEmpty(retMessage) || retMessage == "" || retMessage == "null")
                        {
                            retMessage = "Data saved successfully";
                            message[0] = "Data saved successfully";
                        }
                    }
                }
            }
            else
            {
                //UPDATE SECTION
                if (ViewStateLivRestBudgetID > 0)
                {
                    oLiveRestBudgetBO.Liv_Res_BudgID = ViewStateLivRestBudgetID;
                    oLiveRestBudgetBO.UpdatedBy      = SessionUserId;
                    oLiveRestBudgetBO.CreatedBy      = SessionUserId;
                    retMessage = oLiveRestBudgetBLL.UpdateLiveRestBudget(oLiveRestBudgetBO);

                    if (string.IsNullOrEmpty(retMessage) || retMessage == "" || retMessage == "null")
                    {
                        LiveRestBudVillagesBLL oLiveRestBudVillagesBLL = new LiveRestBudVillagesBLL();
                        LiveRestBudVillagesBO  oLiveRestBudVillagesBO  = new LiveRestBudVillagesBO();
                        oLiveRestBudVillagesBO.IsDeleted      = "False";
                        oLiveRestBudVillagesBO.CreatedBy      = SessionUserId;
                        oLiveRestBudVillagesBO.Liv_Res_BudgId = ViewStateLivRestBudgetID;
                        //DELETE & INSERT CONCEPT
                        oLiveRestBudVillagesBLL.DeleteLiveRestBudVillages(ViewStateLivRestBudgetID); //DELETE
                        for (int i = 0; i < lstbVillages.Items.Count; i++)
                        {
                            if (lstbVillages.Items[i].Selected)
                            {
                                oLiveRestBudVillagesBO.Village = lstbVillages.Items[i].Text;
                                retMessage = oLiveRestBudVillagesBLL.UpdateLiveRestBudVillages(oLiveRestBudVillagesBO); //INSERT
                            }
                        }
                        retMessage = "Data updated successfully";
                    }
                }
            }
            ClearFields();
            BindGrid();
            AlertMessage = "alert('" + retMessage + "');";
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
        }
Esempio n. 8
0
        /// <summary>
        /// to update data
        /// </summary>
        /// <param name="oLivelihoodRestBudgetBO"></param>
        /// <returns></returns>
        public string UpdateLiveRestBudget(LivelihoodRestBudgetBO oLivelihoodRestBudgetBO)
        {
            //string returnResult = string.Empty;
            string[] resultArray = new string[2];
            cnn = new OracleConnection(con);

            proc = "USP_TRN_UPD_LIV_RES_BUDG";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection.Open();
            cmd.Parameters.Add("Liv_Res_BudgID_", oLivelihoodRestBudgetBO.Liv_Res_BudgID);
            cmd.Parameters.Add("Liv_Bud_CategID_", oLivelihoodRestBudgetBO.Liv_Bud_CategID);
            cmd.Parameters.Add("Liv_Bud_ItemID_", oLivelihoodRestBudgetBO.Liv_Bud_ItemID);

            cmd.Parameters.Add("ImplCost_", oLivelihoodRestBudgetBO.ImplCost);
            cmd.Parameters.Add("OperCost_", oLivelihoodRestBudgetBO.OperCost);
            cmd.Parameters.Add("ExternalMonitory_", oLivelihoodRestBudgetBO.ExternalMonitory);

            cmd.Parameters.Add("NoOfBeneficial_", oLivelihoodRestBudgetBO.NoOfBeneficial);
            cmd.Parameters.Add("ItemQuantity_", oLivelihoodRestBudgetBO.ItemQuantity);
            cmd.Parameters.Add("CostPerUnit_", oLivelihoodRestBudgetBO.CostPerUnit);
            cmd.Parameters.Add("TotalAmount_", oLivelihoodRestBudgetBO.TotalAmount);
            cmd.Parameters.Add("Comments_", oLivelihoodRestBudgetBO.Comments);

            cmd.Parameters.Add("District_", oLivelihoodRestBudgetBO.District);
            cmd.Parameters.Add("County_", oLivelihoodRestBudgetBO.County);
            cmd.Parameters.Add("SubCounty_", oLivelihoodRestBudgetBO.SubCounty);
            cmd.Parameters.Add("Parish_", oLivelihoodRestBudgetBO.Parish);

            cmd.Parameters.Add("IsDeleted_", oLivelihoodRestBudgetBO.IsDeleted);
            cmd.Parameters.Add("UpdatedBy_", oLivelihoodRestBudgetBO.UpdatedBy);

            cmd.Parameters.Add("liv_res_budgIDD_", OracleDbType.Long, 50).Direction   = ParameterDirection.Output;
            cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
            // cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            //cmd.ExecuteNonQuery();
            ////OracleDataReader oDataReader = cmd.ExecuteReader();

            //if (cmd.Parameters["liv_res_budgIDD_"].Value != null)
            //    resultArray[0] = cmd.Parameters["liv_res_budgIDD_"].Value.ToString();
            //else
            //    resultArray[0] = string.Empty;

            //if (cmd.Parameters["errorMessage_"].Value != null)
            //    resultArray[1] = cmd.Parameters["errorMessage_"].Value.ToString();
            //else
            //    resultArray[1] = string.Empty;

            //cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 100).Direction = ParameterDirection.Output;
            try
            {
                cmd.ExecuteNonQuery();

                if (cmd.Parameters["liv_res_budgIDD_"].Value != null)
                {
                    resultArray[0] = cmd.Parameters["liv_res_budgIDD_"].Value.ToString();
                }
                else
                {
                    resultArray[0] = string.Empty;
                }

                if (cmd.Parameters["errorMessage_"].Value != null)
                {
                    resultArray[1] = cmd.Parameters["errorMessage_"].Value.ToString();
                }
                else
                {
                    resultArray[1] = string.Empty;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(resultArray[1]);
        }
Esempio n. 9
0
        /// <summary>
        /// to save data
        /// </summary>
        /// <param name="oLivelihoodRestBudgetBO"></param>
        /// <returns></returns>
        public string[] AddLiveRestBudget(LivelihoodRestBudgetBO oLivelihoodRestBudgetBO)
        {
            //string returnResult = string.Empty;
            string[] resultArray = new string[2];
            LivelihoodRestBudgetBO ooLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();//For Storing & Returning Result as Object

            OracleConnection OCon = new OracleConnection(con);

            OCon.Open();
            OracleCommand oCmd = new OracleCommand("USP_TRN_INS_LIV_RES_BUDG", OCon);

            oCmd.CommandType = CommandType.StoredProcedure;
            int count = Convert.ToInt32(oCmd.CommandType);

            try
            {
                oCmd.Parameters.Add("Liv_Bud_CategID_", oLivelihoodRestBudgetBO.Liv_Bud_CategID);
                oCmd.Parameters.Add("Liv_Bud_ItemID_", oLivelihoodRestBudgetBO.Liv_Bud_ItemID);

                oCmd.Parameters.Add("ImplCost_", oLivelihoodRestBudgetBO.ImplCost);
                oCmd.Parameters.Add("OperCost_", oLivelihoodRestBudgetBO.OperCost);
                oCmd.Parameters.Add("ExternalMonitory_", oLivelihoodRestBudgetBO.ExternalMonitory);

                oCmd.Parameters.Add("NoOfBeneficial_", oLivelihoodRestBudgetBO.NoOfBeneficial);
                oCmd.Parameters.Add("ItemQuantity_", oLivelihoodRestBudgetBO.ItemQuantity);
                oCmd.Parameters.Add("CostPerUnit_", oLivelihoodRestBudgetBO.CostPerUnit);
                oCmd.Parameters.Add("TotalAmount_", oLivelihoodRestBudgetBO.TotalAmount);
                oCmd.Parameters.Add("Comments_", oLivelihoodRestBudgetBO.Comments);

                oCmd.Parameters.Add("District_", oLivelihoodRestBudgetBO.District);
                oCmd.Parameters.Add("County_", oLivelihoodRestBudgetBO.County);
                oCmd.Parameters.Add("SubCounty_", oLivelihoodRestBudgetBO.SubCounty);
                oCmd.Parameters.Add("Parish_", oLivelihoodRestBudgetBO.Parish);
                oCmd.Parameters.Add("projectid_", oLivelihoodRestBudgetBO.ProjectID);
                oCmd.Parameters.Add("isdeleted_", oLivelihoodRestBudgetBO.IsDeleted);
                oCmd.Parameters.Add("createdby_", oLivelihoodRestBudgetBO.CreatedBy);

                oCmd.Parameters.Add("liv_res_budgIDD_", OracleDbType.Long, 50).Direction   = ParameterDirection.Output;
                oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
                //oCmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

                oCmd.ExecuteNonQuery();
                //OracleDataReader oDataReader = oCmd.ExecuteReader();

                if (oCmd.Parameters["liv_res_budgIDD_"].Value != null)
                {
                    resultArray[0] = oCmd.Parameters["liv_res_budgIDD_"].Value.ToString();
                }
                else
                {
                    resultArray[0] = string.Empty;
                }

                if (oCmd.Parameters["errorMessage_"].Value != null)
                {
                    resultArray[1] = oCmd.Parameters["errorMessage_"].Value.ToString();
                }
                else
                {
                    resultArray[1] = string.Empty;
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                oCmd.Dispose();
                OCon.Close();
                OCon.Dispose();
            }
            return(resultArray);
        }
Esempio n. 10
0
        /// <summary>
        /// MapData
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        private LivelihoodRestBudgetBO MapData(IDataReader reader)
        {
            LivelihoodRestBudgetBO oLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();

            if (ColumnExists(reader, "Liv_Res_BudgID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Res_BudgID")))
            {
                oLivelihoodRestBudgetBO.Liv_Res_BudgID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Res_BudgID")));
            }

            if (ColumnExists(reader, "Liv_Bud_CategID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_CategID")))
            {
                oLivelihoodRestBudgetBO.Liv_Bud_CategID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Bud_CategID")));
            }

            if (ColumnExists(reader, "Liv_Bud_ItemID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_ItemID")))
            {
                oLivelihoodRestBudgetBO.Liv_Bud_ItemID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Bud_ItemID")));
            }

            if (ColumnExists(reader, "Liv_Bud_CategoryName") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_CategoryName")))
            {
                oLivelihoodRestBudgetBO.Liv_Bud_CategoryName = reader.GetString(reader.GetOrdinal("Liv_Bud_CategoryName"));
            }

            if (ColumnExists(reader, "Liv_Bud_ItemName") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_ItemName")))
            {
                oLivelihoodRestBudgetBO.Liv_Bud_ItemName = reader.GetString(reader.GetOrdinal("Liv_Bud_ItemName"));
            }


            if (ColumnExists(reader, "NoOfBeneficial") && !reader.IsDBNull(reader.GetOrdinal("NoOfBeneficial")))
            {
                oLivelihoodRestBudgetBO.NoOfBeneficial = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("NoOfBeneficial")));
            }

            if (ColumnExists(reader, "Comments") && !reader.IsDBNull(reader.GetOrdinal("Comments")))
            {
                oLivelihoodRestBudgetBO.Comments = reader.GetString(reader.GetOrdinal("Comments"));
            }

            if (ColumnExists(reader, "ItemQuantity") && !reader.IsDBNull(reader.GetOrdinal("ItemQuantity")))
            {
                oLivelihoodRestBudgetBO.ItemQuantity = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ItemQuantity")));
            }

            if (ColumnExists(reader, "TotalAmount") && !reader.IsDBNull(reader.GetOrdinal("TotalAmount")))
            {
                oLivelihoodRestBudgetBO.TotalAmount = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("TotalAmount")));
            }

            if (ColumnExists(reader, "CostPerUnit") && !reader.IsDBNull(reader.GetOrdinal("CostPerUnit")))
            {
                oLivelihoodRestBudgetBO.CostPerUnit = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CostPerUnit")));
            }


            if (ColumnExists(reader, "ImplCost") && !reader.IsDBNull(reader.GetOrdinal("ImplCost")))
            {
                oLivelihoodRestBudgetBO.ImplCost = reader.GetString(reader.GetOrdinal("ImplCost"));
            }

            if (ColumnExists(reader, "OperCost") && !reader.IsDBNull(reader.GetOrdinal("OperCost")))
            {
                oLivelihoodRestBudgetBO.OperCost = reader.GetString(reader.GetOrdinal("OperCost"));
            }

            if (ColumnExists(reader, "ExternalMonitory") && !reader.IsDBNull(reader.GetOrdinal("ExternalMonitory")))
            {
                oLivelihoodRestBudgetBO.ExternalMonitory = reader.GetString(reader.GetOrdinal("ExternalMonitory"));
            }


            if (ColumnExists(reader, "County") && !reader.IsDBNull(reader.GetOrdinal("County")))
            {
                oLivelihoodRestBudgetBO.County = reader.GetString(reader.GetOrdinal("County"));
            }

            if (ColumnExists(reader, "SubCounty") && !reader.IsDBNull(reader.GetOrdinal("SubCounty")))
            {
                oLivelihoodRestBudgetBO.SubCounty = reader.GetString(reader.GetOrdinal("SubCounty"));
            }

            if (ColumnExists(reader, "District") && !reader.IsDBNull(reader.GetOrdinal("District")))
            {
                oLivelihoodRestBudgetBO.District = reader.GetString(reader.GetOrdinal("District"));
            }

            if (ColumnExists(reader, "Parish") && !reader.IsDBNull(reader.GetOrdinal("Parish")))
            {
                oLivelihoodRestBudgetBO.Parish = reader.GetString(reader.GetOrdinal("Parish"));
            }

            return(oLivelihoodRestBudgetBO);
        }