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; } }