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