protected void BindProjects()
{
try
{
DataTable dtProjects = new DataTable();
dtProjects = ProjectCheckRequestData.GetData("getCommittedProjectslist");
ddlRFromProj.Items.Clear();
ddlRToFund.Items.Clear();
ddlRFromProj.DataSource = dtProjects;
ddlRFromProj.DataValueField = "projectId";
ddlRFromProj.DataTextField = "Proj_num";
ddlRFromProj.DataBind();
ddlRFromProj.Items.Insert(0, new ListItem("Select", "NA"));
ddlRToProj.DataSource = dtProjects;
ddlRToProj.DataValueField = "projectId";
ddlRToProj.DataTextField = "Proj_num";
ddlRToProj.DataBind();
ddlRToProj.Items.Insert(0, new ListItem("Select", "NA"));
}
catch (Exception ex)
{
lblRErrorMsg.Text = ex.Message;
}
}
protected int GetUserId()
{
try
{
DataTable dtUser = ProjectCheckRequestData.GetUserByUserName(Context.User.Identity.GetUserName());
return(dtUser != null?Convert.ToInt32(dtUser.Rows[0][0].ToString()) : 0);
}
catch (Exception)
{
return(0);
}
}
protected void BindProjects(DropDownList ddList)
{
try
{
ddList.Items.Clear();
ddList.DataSource = ProjectCheckRequestData.GetData("getprojectslist");;
ddList.DataValueField = "projectid";
ddList.DataTextField = "Proj_num";
ddList.DataBind();
ddList.Items.Insert(0, new ListItem("Select", "NA"));
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
protected void BindProjects(DropDownList ddList)
{
try
{
DataTable dt = ProjectCheckRequestData.GetData("getprojectslist");
//DataView dv = dt.DefaultView;
//dv.Sort = "description asc";
//DataTable sortedDT = dv.ToTable();
ddList.Items.Clear();
ddList.DataSource = dt; // sortedDT;
ddList.DataValueField = "projectid";
ddList.DataTextField = "project_num_name";
ddList.DataBind();
ddList.Items.Insert(0, new ListItem("Select", "NA"));
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
private void getDetails(DataTable dt)
{
try
{
lblAvailFund.Text = "";
lblAvailVisibleFund.Text = "";
if (dt.Rows.Count != 0)
{
hfProjId.Value = dt.Rows[0][0].ToString();
DataRow dr = ProjectCheckRequestData.GetAvailableFundsByProject(int.Parse(hfProjId.Value));
if (dr != null)
{
if (Convert.ToDecimal(dr["availFund"].ToString()) > 0)
{
lblAvailFund.Text = Convert.ToDecimal(dr["availFund"].ToString()).ToString("#.##");
lblAvailVisibleFund.Text = CommonHelper.myDollarFormat(Convert.ToDecimal(dr["availFund"].ToString()));
//.ToString("#.##");
}
else
{
lblAvailFund.Text = "0.00";
lblAvailVisibleFund.Text = "0.00";
}
}
pnlTranDetails.Visible = false;
lblErrorMsg.Text = "";
gvPTrans.DataSource = null;
gvPTrans.DataBind();
ClearTransactionDetailForm();
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(hfProjId.Value));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
dt = new DataTable();
dt = FinancialTransactions.GetGranteeByProject(Convert.ToInt32(hfProjId.Value));
if (dt.Rows.Count > 0)
{
lblGrantee.Text = dt.Rows[0]["Applicantname"].ToString();
hfGrantee.Value = dt.Rows[0]["applicantid"].ToString();
}
else
{
lblGrantee.Text = "";
hfGrantee.Value = "";
}
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
BindFundAccounts();
ifProjectNotes.Src = "ProjectNotes.aspx?ProjectId=" + hfProjId.Value;
if (rdBtnSelection.SelectedIndex == 1)
{
DataTable dtTrans = FinancialTransactions.GetFinancialTransByProjId(Convert.ToInt32(hfProjId.Value), ActiveOnly, BOARD_REFUND);
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
CommonHelper.DisableButton(btnTransactionSubmit);
}
else if (rdBtnSelection.SelectedIndex == 0)
{
CommonHelper.EnableButton(btnTransactionSubmit);
}
}
else
{
lblProjName.Text = "";
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
