private void PopulateHomeOwnerDropDown(DropDownList ddList, string Role) { try { DataTable dtProjectEntity = ProjectMaintenanceData.GetProjectApplicantList(DataUtils.GetInt(hfProjectId.Value), true); ddList.Items.Clear(); ddList.DataSource = dtProjectEntity; ddList.DataValueField = "ApplicantId"; ddList.DataTextField = "applicantname"; ddList.DataBind(); ddList.Items.Insert(0, new ListItem("Select", "NA")); foreach (DataRow dr in dtProjectEntity.Rows) { if (dr["ApplicantRoleDescription"].ToString().ToLower() == Role.ToLower()) { ListItem selectedListItem = ddList.Items.FindByValue(dr["ApplicantId"].ToString()); if (selectedListItem != null) { selectedListItem.Selected = true; break; } } } } catch (Exception ex) { LogError(Pagename, "PopulateOwnerDropDown", "", ex.Message); } }
private void PopulateProjectDetails() { DataRow dr = ProjectMaintenanceData.GetProjectNameById(DataUtils.GetInt(hfProjectId.Value)); ProjectNum.InnerText = dr["ProjNumber"].ToString(); ProjName.InnerText = dr["ProjectName"].ToString(); }
private void BindPrjectEventGrid() { try { DataTable dtProjectEvents = ProjectMaintenanceData.GetProjectEventList(DataUtils.GetInt(hfProjectId.Value), cbActiveOnly.Checked); Session["dtProjectEvents"] = dtProjectEvents; if (dtProjectEvents.Rows.Count > 0) { dvProjectEventGrid.Visible = true; gvProjectEvent.DataSource = dtProjectEvents; gvProjectEvent.DataBind(); } else { dvProjectEventGrid.Visible = false; gvProjectEvent.DataSource = null; gvProjectEvent.DataBind(); } } catch (Exception ex) { LogError(Pagename, "BindPrjectEventGrid", "", ex.Message); } }
private void BindApplicantsForCurrentProject(DropDownList ddlEventEntity) { try { ddlEventEntity.Items.Clear(); if ((DataUtils.GetInt(hfProjectId.Value) == 0)) { ddlEventEntity.DataSource = ApplicantData.GetApplicants(); } else { ddlEventEntity.DataSource = ProjectMaintenanceData.GetCurrentProjectApplicants(DataUtils.GetInt(hfProjectId.Value)); } ddlEventEntity.DataValueField = "appnameid"; ddlEventEntity.DataTextField = "applicantname"; ddlEventEntity.DataBind(); ddlEventEntity.Items.Insert(0, new ListItem("Select", "NA")); } catch (Exception ex) { LogError(Pagename, "BindApplicantsForCurrentProject", "", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { dvMessage.Visible = false; lblErrorMsg1.Text = ""; String ProjectId = Request.QueryString["ProjectId"]; string pcr = Request.QueryString["pcrid"]; string strPageId = Request.QueryString["PageId"]; if (strPageId != null) { PageId = DataUtils.GetInt(strPageId); } chkPCR.Visible = false; spnPCR.Visible = false; if (pcr != null) { chkPCR.Checked = true; chkPCR.Visible = true; spnPCR.Visible = true; } else { chkPCR.Checked = false; chkPCR.Visible = false; spnPCR.Visible = false; } txtProjectDDL.Enabled = true; //ddlProject.Enabled = true; txtProjectName.Enabled = true; txtProjectNotesDate.Enabled = true; if (!IsPostBack) { BindControls(); txtProjectNotesDate.Text = DateTime.Now.ToShortDateString(); dvProjectNotesGrid.Visible = false; if (!string.IsNullOrWhiteSpace(ProjectId)) { txtProjectDDL.Text = ProjectMaintenanceData.GetProjectNum(DataUtils.GetInt(ProjectId)); //ddlProject.SelectedValue = ProjectId; DataRow dr = ProjectMaintenanceData.GetProjectNameById(DataUtils.GetInt(ProjectId)); txtProjectName.Text = dr["ProjectName"].ToString(); BindProjectNotesGrid(); } } }
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e) { ddlCategory.SelectedIndex = -1; txtProjectNotesDate.Text = DateTime.Now.ToShortDateString(); txtNotes.Text = ""; txtProjectName.Text = ""; //if (ddlProject.SelectedIndex != 0) if (txtProjectDDL.Text != "") { DataRow dr = ProjectMaintenanceData.GetProjectNameById(GetProjectID(txtProjectDDL.Text)); txtProjectName.Text = dr["ProjectName"].ToString(); } BindProjectNotesGrid(); }
protected void btnAddEvent_Click(object sender, EventArgs e) { if (IsProjectEventFormValid()) { if (btnAddEvent.Text == "Add") { ProjectMaintResult obProjectMaintResult = ProjectMaintenanceData.AddProjectEvent(DataUtils.GetInt(ddlEventProject.SelectedValue.ToString()), DataUtils.GetInt(ddlEventProgram.SelectedValue.ToString()), DataUtils.GetInt(ddlEventEntity.SelectedValue.ToString()), DataUtils.GetInt(ddlEvent.SelectedValue.ToString()), DataUtils.GetInt(ddlEventSubCategory.SelectedValue.ToString()), DataUtils.GetDate(txtEventDate.Text), txtNotes.Text, GetUserId()); ClearProjectEventForm(); cbAddProjectEvent.Checked = false; BindPrjectEventGrid(); if (obProjectMaintResult.IsDuplicate && !obProjectMaintResult.IsActive) { LogMessage("Project Event already exist as in-active"); } else if (obProjectMaintResult.IsDuplicate) { LogMessage("Project Event already exist"); } else { LogMessage("New Project Event added successfully"); } } else { ProjectMaintenanceData.UpdateProjectEvent(DataUtils.GetInt(hfProjectEventID.Value), DataUtils.GetInt(ddlEventProject.SelectedValue.ToString()), DataUtils.GetInt(ddlEventProgram.SelectedValue.ToString()), DataUtils.GetInt(ddlEventEntity.SelectedValue.ToString()), DataUtils.GetInt(ddlEvent.SelectedValue.ToString()), DataUtils.GetInt(ddlEventSubCategory.SelectedValue.ToString()), DataUtils.GetDate(txtEventDate.Text), txtNotes.Text, GetUserId(), chkProjectEventActive.Checked); gvProjectEvent.EditIndex = -1; BindPrjectEventGrid(); ClearProjectEventForm(); btnAddEvent.Text = "Add"; LogMessage("Project Event Updated Successfully"); } } }
protected void gvProjectEvent_RowDataBound(object sender, GridViewRowEventArgs e) { try { if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit) { CommonHelper.GridViewSetFocus(e.Row); btnAddEvent.Text = "Update"; cbAddProjectEvent.Checked = true; //Checking whether the Row is Data Row if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[7].Controls[0].Visible = false; Label lblProjectEventID = e.Row.FindControl("lblProjectEventID") as Label; DataRow dr = ProjectMaintenanceData.GetProjectEventById(DataUtils.GetInt(lblProjectEventID.Text)); hfProjectEventID.Value = lblProjectEventID.Text; PopulateDropDown(ddlEventProject, dr["ProjectID"].ToString()); PopulateDropDown(ddlEventProgram, dr["Prog"].ToString()); PopulateDropDown(ddlEventEntity, dr["ApplicantID"].ToString()); PopulateDropDown(ddlEvent, dr["EventID"].ToString()); PopulateDropDown(ddlEventSubCategory, dr["SubEventID"].ToString()); txtEventDate.Text = dr["Date"].ToString() == "" ? "" : Convert.ToDateTime(dr["Date"].ToString()).ToShortDateString(); txtNotes.Text = dr["Note"].ToString(); chkProjectEventActive.Enabled = true; ddlEventProgram.Enabled = false; ddlEventProject.Enabled = false; } } } catch (Exception ex) { LogError(Pagename, "gvAppraisalInfo_RowDataBound", "", ex.Message); } }
private int GetProjectID(string ProjectNum) { return(ProjectMaintenanceData.GetProjectId(ProjectNum)); }