/// <summary> /// Load Villages /// </summary> private void LoadVillages() { LiveRestBudVillagesBLL oLiveRestBudVillagesBLL = new LiveRestBudVillagesBLL(); LiveRestBudVillagesList oLiveRestBudVillagesList = new LiveRestBudVillagesList(); if (ViewStateLivRestBudgetID > 0) { oLiveRestBudVillagesList = oLiveRestBudVillagesBLL.GetLiveRestBudVillagesById(ViewStateLivRestBudgetID); foreach (LiveRestBudVillagesBO oLiveRestBudVillagesBO in oLiveRestBudVillagesList) { lstbVillages.Items.Add(oLiveRestBudVillagesBO.Village); } } }
/// <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(); } }
/// <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); }