protected void btnAddYearIncome_Click(object sender, EventArgs e)
{
this.MVContainer.ActiveViewIndex = 1;
YearGridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString();
YearGridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode;
MonthGridView.DataBind();
}
protected void AddYearPlan_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvRow in YearGridView.Rows)
{
IncomeBugetFacade facade = new IncomeBugetFacade();
IncomeBugetModel model = null;
TextBox tbcMoney = (TextBox)(gvRow.FindControl("tbxMoney"));
Label lblMonth = (Label)(gvRow.FindControl("lblMonth"));
if (!string.IsNullOrEmpty(tbcMoney.Text))
{
if (int.Parse(tbcMoney.Text) > 0)
{
model = new IncomeBugetModel();
model.Year = Year;
model.Month = int.Parse(lblMonth.Text);
model.ProjectCode = ProjectCode;
model.Money = decimal.Parse(tbcMoney.Text);
facade.Insert(model);
}
}
}
GridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString();
GridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode;
MonthGridView.DataBind();
this.MVContainer.ActiveViewIndex = 0;
}
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
{
Year = int.Parse(ddlYear.SelectedValue);
GridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString();
GridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode;
MonthGridView.DataBind();
btnAddYearIncome.Enabled = CanEdit;
}
public void Select(int year, string projectCode)
{
string sql = "SELECT * FROM RPTFININ WHERE IYEAR={0} AND PROJECTCODE='{1}' ORDER BY IMONTH ASC ";
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("RptFinIn", string.Format(sql, year, projectCode));
qa.Dispose();
this.MonthGridView.DataSource = entity.CurrentTable;
MonthGridView.DataBind();
}