public StudentOrganisationApp.App_Data.Organization getOrganizationByID(int orgID, ref int statusID) { var org = dataContext.sp_GetOrganizationByID(orgID).First(); StudentOrganisationApp.App_Data.Organization organization = new App_Data.Organization(); organization.OrganizationName = org.OrganizationName; organization.Category_ID = org.Category_ID; organization.Description = org.Description; organization.MeetingBuilding = org.MeetingBuilding; organization.MeetingRoom = org.MeetingRoom; organization.MeetingDay = org.MeetingDay; organization.MeetingTime = org.MeetingTime; statusID = org.Status_ID; organization.RegistrarApproval = org.RegistrarApproval; organization.RequirementsMet = org.RequirementsMet; organization.RequirementsMetDate = org.RequirementsMetDate; organization.DateProposed = org.DateProposed; organization.ProposalAccepted = org.ProposalAccepted; organization.ProposalDenied = org.ProposalDenied; organization.ProposalNotes = org.ProposalNotes; organization.ConstitutionAccepted = org.ConstitutionAccepted; organization.ConstitutionNotes = org.ConstitutionNotes; organization.ConstitutionSubmitted = org.ConstitutionSubmitted; organization.ConstitutionUpdated = org.ConstitutionUpdated; organization.ConstitutionDenied = org.ConstitutionDenied; organization.MeetingFrequency = org.MeetingFrequency; organization.CX_Code = org.CX_Code; organization.OAccount = org.OAccount; organization.ProjectCode = org.ProjectCode; return(organization); }
protected void btnCanelDates_Click(object sender, EventArgs e) { try { int ordID = Convert.ToInt32(ddlOrganization.SelectedItem.Value); int statusID = -1; App_Data.Organization OrgForEdit = OrganizationDAO.getOrganizationByID(ordID, ref statusID); txtConstitution.Text = Convert.ToDateTime(OrgForEdit.ConstitutionSubmitted).ToShortDateString(); txtConstitutionAccepted.Text = Convert.ToDateTime(OrgForEdit.ConstitutionAccepted).ToShortDateString(); txtConstitutionDenied.Text = Convert.ToDateTime(OrgForEdit.ConstitutionDenied).ToShortDateString(); txtConstitutionUpdated.Text = Convert.ToDateTime(OrgForEdit.ConstitutionUpdated).ToShortDateString(); txtDatePrposalPacketSub.Text = Convert.ToDateTime(OrgForEdit.DateProposed).ToShortDateString(); txtDatedenied.Text = Convert.ToDateTime(OrgForEdit.ConstitutionAccepted).ToShortDateString(); txtDateAccepted.Text = Convert.ToDateTime(OrgForEdit.ConstitutionDenied).ToShortDateString(); txtProposalNotes.Text = OrgForEdit.ProposalNotes; txtConstitutionNotes.Text = OrgForEdit.ConstitutionNotes; } catch (Exception) { lblMessage.Text = "Unable to retrieve the Organization data!!"; } }
protected void btnGoMain_Click(object sender, EventArgs e) { try { if (Convert.ToInt32(ddlOrganization.SelectedItem.Value) != -1) { pnlSelectOrganization.Visible = false; btnCanelAll.Visible = true; pnlEditing.Visible = true; int ordID = Convert.ToInt32(ddlOrganization.SelectedItem.Value); int statusID = -1; App_Data.Organization OrgForEdit = OrganizationDAO.getOrganizationByID(ordID, ref statusID); lblOrganizationEdit.Text = OrgForEdit.OrganizationName; txtorg.Text = OrgForEdit.OrganizationName; ddlCategory.SelectedValue = OrgForEdit.Category_ID.ToString(); txtDescription.Text = OrgForEdit.Description; txtMeetTime.Text = OrgForEdit.MeetingTime; txtBuilding.Text = OrgForEdit.MeetingBuilding; txtMeetRoom.Text = OrgForEdit.MeetingRoom; string value = "-1"; if (OrgForEdit.MeetingDay == null) { ddlMeetingDay.Items.FindByValue("-1").Selected = true; } else { value = ddlMeetingDay.Items.FindByText(OrgForEdit.MeetingDay).Value; ddlMeetingDay.SelectedValue = value; } if (OrgForEdit.MeetingFrequency == null) { ddlMeetingFrequency.Items.FindByValue("-1").Selected = true; } else { value = ddlMeetingFrequency.Items.FindByText(OrgForEdit.MeetingFrequency).Value; ddlMeetingFrequency.SelectedValue = value; } //added 8.11.2016 txtOAccount.Text = OrgForEdit.OAccount; txtProjectCode.Text = OrgForEdit.ProjectCode; if (OrgForEdit.RegistrarApproval == null) { txtRegApproval.Text = string.Empty; } else { txtRegApproval.Text = Convert.ToDateTime(OrgForEdit.RegistrarApproval).ToShortDateString(); } if (OrgForEdit.RequirementsMetDate == null) { txtRequirementMetDate.Text = string.Empty; } else { txtRequirementMetDate.Text = Convert.ToDateTime(OrgForEdit.RequirementsMetDate).ToShortDateString(); } if (OrgForEdit.RequirementsMet == true) { chkBoxRegApproval.Checked = true; txtRequirementMetDate.Visible = true; lblRequirementMetDate.Visible = true; btnCalPopReuirmentsMet.Visible = true; } else { chkBoxRegApproval.Checked = false; txtRequirementMetDate.Visible = false; lblRequirementMetDate.Visible = false; btnCalPopReuirmentsMet.Visible = false; txtRequirementMetDate.Text = string.Empty; } ddlStatus.SelectedValue = statusID.ToString(); txtCXCode.Text = OrgForEdit.CX_Code; txtCXCode.Text = txtCXCode.Text.Trim(); //bind the grd to advisors from org UploadedAdvisors = AdvisorDAO.getAdvisorsForOrg(ordID); grdAdvisors.DataSource = UploadedAdvisors; grdAdvisors.DataBind(); txtConstitution.Text = OrgForEdit.ConstitutionSubmitted == null ?string.Empty:Convert.ToDateTime(OrgForEdit.ConstitutionSubmitted).ToShortDateString(); txtConstitutionAccepted.Text = OrgForEdit.ConstitutionAccepted == null ? string.Empty : Convert.ToDateTime(OrgForEdit.ConstitutionAccepted).ToShortDateString(); txtConstitutionDenied.Text = OrgForEdit.ConstitutionDenied == null ? string.Empty : Convert.ToDateTime(OrgForEdit.ConstitutionDenied).ToShortDateString(); txtConstitutionUpdated.Text = OrgForEdit.ConstitutionUpdated == null ? string.Empty : Convert.ToDateTime(OrgForEdit.ConstitutionUpdated).ToShortDateString(); txtDatePrposalPacketSub.Text = OrgForEdit.DateProposed == null ? string.Empty : Convert.ToDateTime(OrgForEdit.DateProposed).ToShortDateString(); txtDatedenied.Text = OrgForEdit.ProposalAccepted == null ? string.Empty : Convert.ToDateTime(OrgForEdit.ProposalAccepted).ToShortDateString(); txtDateAccepted.Text = OrgForEdit.ProposalDenied == null ? string.Empty : Convert.ToDateTime(OrgForEdit.ProposalDenied).ToShortDateString(); txtProposalNotes.Text = OrgForEdit.ProposalNotes; txtConstitutionNotes.Text = OrgForEdit.ConstitutionNotes; //Bind Comments to grid grdComments.DataSource = OrganizationDAO.getCommentsByOrganizationID(Convert.ToInt32(ddlOrganization.SelectedValue)); grdComments.DataBind(); ddlReqEvent.DataSource = RequiredEventDAO.getRequiredEventList(); ddlReqEvent.DataTextField = "RequiredEvent1"; ddlReqEvent.DataValueField = "RequiredEvent_ID"; ddlReqEvent.DataBind(); ddlReqEventSignUp.DataSource = RequiredEventDAO.getRequiredEventList(); ddlReqEventSignUp.DataTextField = "RequiredEvent1"; ddlReqEventSignUp.DataValueField = "RequiredEvent_ID"; ddlReqEventSignUp.DataBind(); cmbStudents.DataSource = StudentDAO.getNonExeMembersForOrgID(Convert.ToInt32(ddlOrganization.SelectedValue)); cmbStudents.DataTextField = "LastName"; cmbStudents.DataValueField = "Student_ID"; cmbStudents.DataBind(); cmbStudents.SelectedValue = "-1"; cmbStudentsInMembers.DataSource = StudentDAO.getNonMembersForOrgID(Convert.ToInt32(ddlOrganization.SelectedValue)); cmbStudentsInMembers.DataTextField = "LastName"; cmbStudentsInMembers.DataValueField = "Student_ID"; cmbStudentsInMembers.DataBind(); cmbStudentsInMembers.SelectedValue = "-1"; UploadedExeMembers = MemberTypeDAO.getExeMembersByOrgID(ordID); grdExeMember.DataSource = UploadedExeMembers; grdExeMember.DataBind(); UploadedOrgMembers = MemberTypeDAO.getMembersByOrgID(ordID); grdMember.DataSource = UploadedOrgMembers; grdMember.DataBind(); } } catch (Exception ex) { lblMessage.Text = "Unable to retrieve the organization data!!"; lblMessage.Text += "/n/n" + ex.Message; lblMessage.Text += "/n/n" + ex.StackTrace; } }
protected void btnCanel_Click(object sender, EventArgs e) { try { int ordID = Convert.ToInt32(ddlOrganization.SelectedItem.Value); int statusID = -1; App_Data.Organization OrgForEdit = OrganizationDAO.getOrganizationByID(ordID, ref statusID); txtorg.Text = OrgForEdit.OrganizationName; ddlCategory.SelectedValue = OrgForEdit.Category_ID.ToString(); txtDescription.Text = OrgForEdit.Description; txtMeetTime.Text = OrgForEdit.MeetingTime; txtBuilding.Text = OrgForEdit.MeetingBuilding; txtMeetRoom.Text = OrgForEdit.MeetingRoom; string value = "-1"; if (OrgForEdit.MeetingDay == null) { ddlMeetingDay.Items.FindByValue("-1").Selected = true; } else { value = ddlMeetingDay.Items.FindByText(OrgForEdit.MeetingDay).Value; ddlMeetingDay.SelectedValue = value; } if (OrgForEdit.MeetingFrequency == null) { ddlMeetingFrequency.Items.FindByValue("-1").Selected = true; } else { value = ddlMeetingFrequency.Items.FindByText(OrgForEdit.MeetingFrequency).Value; ddlMeetingFrequency.SelectedValue = value; } //added 8.11.2016 txtOAccount.Text = OrgForEdit.OAccount; txtProjectCode.Text = OrgForEdit.ProjectCode; if (OrgForEdit.RegistrarApproval == null) { txtRegApproval.Text = string.Empty; } else { txtRegApproval.Text = Convert.ToDateTime(OrgForEdit.RegistrarApproval).ToShortDateString(); } if (OrgForEdit.RequirementsMetDate == null) { txtRequirementMetDate.Text = string.Empty; } else { txtRequirementMetDate.Text = Convert.ToDateTime(OrgForEdit.RequirementsMetDate).ToShortDateString(); } if (OrgForEdit.RequirementsMet == true) { chkBoxRegApproval.Checked = true; txtRequirementMetDate.Visible = true; lblRequirementMetDate.Visible = true; btnCalPopReuirmentsMet.Visible = true; } else { chkBoxRegApproval.Checked = false; txtRequirementMetDate.Visible = false; lblRequirementMetDate.Visible = false; btnCalPopReuirmentsMet.Visible = false; txtRequirementMetDate.Text = string.Empty; } ddlStatus.SelectedValue = statusID.ToString(); txtCXCode.Text = OrgForEdit.CX_Code; txtCXCode.Text = txtCXCode.Text.Trim(); UploadedAdvisors.Clear(); //bind the grd to advisors from org UploadedAdvisors = AdvisorDAO.getAdvisorsForOrg(ordID); grdAdvisors.DataSource = UploadedAdvisors; grdAdvisors.DataBind(); } catch (Exception) { lblMessage.Text = "Unable to retrieve the Organization data!!"; } }