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