protected void ddlImportFrom_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ConservationSourcesUsesData.ImportBudgetPeriodData(DataUtils.GetInt(hfProjectId.Value), DataUtils.GetInt(ddlImportFrom.SelectedValue.ToString()),
DataUtils.GetInt(ddlBudgetPeriod.SelectedValue.ToString()));
//Sources
ClearAddSourceForm();
dvNewSource.Visible = true;
BindSourcegrid();
cbAddSource.Checked = false;
//Uses
dvNewUse.Visible = true;
BindUsesgrid();
cbAddUse.Checked = false;
dvImport.Visible = false;
LogMessage("Successfully Imported Budget Period");
}
catch (Exception ex)
{
if (ex.Message.Contains("Invalid Import"))
{
LogMessage("Invalid Import, No Data Exist for this Budget Period");
}
else
{
LogError(Pagename, "ddlImportFrom_SelectedIndexChanged", "", ex.Message);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
dvMessage.Visible = false;
lblErrorMsg.Text = "";
hfProjectId.Value = "0";
if (Request.QueryString["ProjectId"] != null)
{
hfProjectId.Value = Request.QueryString["ProjectId"];
}
GenerateTabs();
if (!IsPostBack)
{
PopulateProjectDetails();
dvImport.Visible = false;
BindControls();
dvNewSource.Visible = false;
dvConsevationSourcesGrid.Visible = false;
dvNewUse.Visible = false;
dvConsevationUsesGrid.Visible = false;
ddlBudgetPeriod.SelectedValue = ConservationSourcesUsesData.GetLatestBudgetPeriod(DataUtils.GetInt(hfProjectId.Value)).ToString();
BudgetPeriodSelectionChanged();
}
}
protected void btnAddSources_Click(object sender, EventArgs e)
{
try
{
//if (ddlProject.SelectedIndex == 0)
//{
// LogMessage("Select Project");
// ddlProject.Focus();
// return;
//}
if (ddlSource.SelectedIndex == 0)
{
LogMessage("Select Source");
ddlSource.Focus();
return;
}
if (string.IsNullOrWhiteSpace(txtSourceTotal.Text.ToString()) == true)
{
LogMessage("Enter source total");
txtSourceTotal.Focus();
return;
}
if (DataUtils.GetDecimal(txtSourceTotal.Text) <= 0)
{
LogMessage("Enter valid source total");
txtSourceTotal.Focus();
return;
}
ConservationSourcesUsesData.AddConSource objAddConSource = ConservationSourcesUsesData.AddConservationSource(DataUtils.GetInt(hfProjectId.Value),
DataUtils.GetInt(ddlBudgetPeriod.SelectedValue.ToString()),
DataUtils.GetInt(ddlSource.SelectedValue.ToString()), DataUtils.GetDecimal(txtSourceTotal.Text));
ClearAddSourceForm();
BindSourcegrid();
if (objAddConSource.IsDuplicate && !objAddConSource.IsActive)
{
LogMessage("New Conservation Source already exist as in-active");
}
else if (objAddConSource.IsDuplicate)
{
LogMessage("New Conservation Source already exist");
}
else
{
LogMessage("New Conservation Source added successfully");
}
}
catch (Exception ex)
{
LogError(Pagename, "btnAddSources_Click", "", ex.Message);
}
}
private void BindUsesLookUP(DropDownList ddList, string UseType)
{
try
{
ddList.Items.Clear();
ddList.DataSource = ConservationSourcesUsesData.GetConserveUsesTypes(UseType);
ddList.DataValueField = "typeid";
ddList.DataTextField = "description";
ddList.DataBind();
ddList.Items.Insert(0, new ListItem("Select", "NA"));
}
catch (Exception ex)
{
LogError(Pagename, "BindUsesLookUP", "Control ID:" + ddList.ID, ex.Message);
}
}
private void BindUsesgrid()
{
try
{
DataTable dtSources = ConservationSourcesUsesData.GetConserveUsesList(DataUtils.GetInt(hfProjectId.Value),
DataUtils.GetInt(ddlBudgetPeriod.SelectedValue.ToString()), cbActiveOnly.Checked);
if (dtSources.Rows.Count > 0)
{
dvConsevationUsesGrid.Visible = true;
gvConservationUsesGrid.DataSource = dtSources;
gvConservationUsesGrid.DataBind();
Label lblFooterVHCBTotalAmt = (Label)gvConservationUsesGrid.FooterRow.FindControl("lblFooterVHCBTotalAmount");
Label lblFooterOtherTotalAmt = (Label)gvConservationUsesGrid.FooterRow.FindControl("lblFooterOtherTotalAmount");
Label lblFooterGrandTotalAmt = (Label)gvConservationUsesGrid.FooterRow.FindControl("lblFooterGrandTotalAmount");
decimal totVHCBAmt = 0;
decimal totOtherAmt = 0;
decimal totGrantAmt = 0;
for (int i = 0; i < dtSources.Rows.Count; i++)
{
if (DataUtils.GetBool(dtSources.Rows[i]["RowIsActive"].ToString()))
{
totVHCBAmt += Convert.ToDecimal(dtSources.Rows[i]["VHCBTotal"].ToString());
totOtherAmt += Convert.ToDecimal(dtSources.Rows[i]["OtherTotal"].ToString());
totGrantAmt += Convert.ToDecimal(dtSources.Rows[i]["Total"].ToString());
}
}
lblFooterVHCBTotalAmt.Text = CommonHelper.myDollarFormat(totVHCBAmt);
lblFooterOtherTotalAmt.Text = CommonHelper.myDollarFormat(totOtherAmt);
lblFooterGrandTotalAmt.Text = CommonHelper.myDollarFormat(totGrantAmt);
}
else
{
dvConsevationUsesGrid.Visible = false;
gvConservationUsesGrid.DataSource = null;
gvConservationUsesGrid.DataBind();
}
}
catch (Exception ex)
{
LogError(Pagename, "BindSourcegrid", "", ex.Message);
}
}
protected void gvConsevationSources_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int rowIndex = e.RowIndex;
int ConserveSourcesID = DataUtils.GetInt(((Label)gvConsevationSources.Rows[rowIndex].FindControl("lblConserveSourcesID")).Text);
//int LkConSource = DataUtils.GetInt(((DropDownList)gvConsevationSources.Rows[rowIndex].FindControl("ddlSource")).SelectedValue.ToString());
decimal Total = DataUtils.GetDecimal(((TextBox)gvConsevationSources.Rows[rowIndex].FindControl("txtTotal")).Text);
bool isActive = Convert.ToBoolean(((CheckBox)gvConsevationSources.Rows[rowIndex].FindControl("chkActiveEdit")).Checked);
ConservationSourcesUsesData.UpdateConservationSource(ConserveSourcesID, Total, isActive);
gvConsevationSources.EditIndex = -1;
BindSourcegrid();
LogMessage("Conservation Source updated successfully");
}
catch (Exception ex)
{
LogError(Pagename, "gvConsevationSources_RowUpdating", "", ex.Message);
}
}
private void BudgetPeriodSelectionChanged()
{
if (ddlBudgetPeriod.SelectedIndex != 0)
{
//Sources
ClearAddSourceForm();
dvNewSource.Visible = true;
BindSourcegrid();
cbAddSource.Checked = false;
//Uses
dvNewUse.Visible = true;
BindUsesgrid();
cbAddUse.Checked = false;
dvImport.Visible = false;
DataTable dtImportBudgetPeriods = ConservationSourcesUsesData.PopulateImportBudgetPeriodDropDown(DataUtils.GetInt(hfProjectId.Value),
DataUtils.GetInt(ddlBudgetPeriod.SelectedValue.ToString()));
if (dtImportBudgetPeriods.Rows.Count > 0)
{
dvImport.Visible = true;
ddlImportFrom.Items.Clear();
ddlImportFrom.DataSource = dtImportBudgetPeriods;
ddlImportFrom.DataValueField = "typeid";
ddlImportFrom.DataTextField = "description";
ddlImportFrom.DataBind();
ddlImportFrom.Items.Insert(0, new ListItem("Select", "NA"));
}
//if (ddlBudgetPeriod.SelectedIndex == 1
// || (gvConsevationSources.Rows.Count > 0 || gvConservationUsesGrid.Rows.Count > 0))
// dvImport.Visible = false;
//else if (ddlBudgetPeriod.SelectedIndex == 2)
//{
// dvImport.Visible = true;
// ddlImportFrom.Items.Clear();
// ddlImportFrom.Items.Insert(0, new ListItem("Select", "NA"));
// ddlImportFrom.Items.Insert(1, new ListItem("Budget Period 1", "26083"));
//}
//else if (ddlBudgetPeriod.SelectedIndex == 3)
//{
// dvImport.Visible = true;
// ddlImportFrom.Items.Clear();
// ddlImportFrom.Items.Insert(0, new ListItem("Select", "NA"));
// ddlImportFrom.Items.Insert(1, new ListItem("Budget Period 1", "26083"));
// ddlImportFrom.Items.Insert(2, new ListItem("Budget Period 2", "26084"));
//}
}
else
{
//Sources
dvNewSource.Visible = false;
dvConsevationSourcesGrid.Visible = false;
//Uses
dvNewUse.Visible = false;
dvConsevationUsesGrid.Visible = false;
//Import From
dvImport.Visible = false;
}
}
