using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class ProjectDetails : System.Web.UI.Page
{
//int ppCurrStatusID = 0;
//string ppCurrStatus = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
#region Populate Combos
//ASP.NET 2.0
SqlDataSource ds = new SqlDataSource();
ds.ConnectionString = ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
ds.DataSourceMode = SqlDataSourceMode.DataSet;
// Populate drop-downs
Utilities.populateCombo(ds, isVenueJKDropDown, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, mgmtContactedDropDown, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, partOfOpPlanDropDown, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, alakhbar, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, transportation, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, insurance, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, ivc, "mspYesNoGetAll", "YesNoOptionValue", "YesNoOptionText");
Utilities.populateCombo(ds, categoryDropDown, "mspEventCategoryGetAll", "EventCategoryID", "EventCategory");
Utilities.populateCombo(ds, startHourDropDown, "mspHourGetAll", "HourID", "HourValue");
Utilities.populateCombo(ds, startMinuteDropDown, "mspMinuteGetAll", "MinuteID", "MinuteValue");
Utilities.populateCombo(ds, endHourDropDown, "mspHourGetAll", "HourID", "HourValue");
Utilities.populateCombo(ds, endMinuteDropDown, "mspMinuteGetAll", "MinuteID", "MinuteValue");
Utilities.populateCombo(ds, jkNameDropDown, "mspJKGetAll", "JKID", "JKName");
Utilities.populateCombo(ds, venueNameDropDown, "mspVenueGetAll", "VenueID", "VenueName");
Utilities.populateCombo(ds, venueTypeDropDown, "mspVenueTypeGetAll", "VenueTypeID", "VenueType");
Utilities.populateCombo(ds, venueCityDropDown, "mspCityGetAll", "CityID", "CityName");
startHourDropDown.Items.Remove("Select One");
startMinuteDropDown.Items.Remove("Select One");
endHourDropDown.Items.Remove("Select One");
endMinuteDropDown.Items.Remove("Select One");
// Need to add entry for "New Venue" to venueNameDropDown
venueNameDropDown.Items.Insert(1, "New Venue");
#endregion
#region Set up calendar control
// Set up special dates
eventDateCalendar.AddSpecialDate(-1, 7, 11, "Immamat Day");
eventDateCalendar.AddSpecialDate(-1, 3, 21, "Navroz");
eventDateCalendar.AddSpecialDate(-1, 12, 13, "Shah Karim's B'day");
//To add dates programatically, do so in a loop
//eventDateCalendar.AddSpecialDate(Convert.ToDateTime(dateVenueRow.ProposedProjectDate.ToString()), projectRow.ProjectTitle);
// Set up calendar behavior
eventDateCalendar.DatePickerMode = true;
//These are set by ReadWriteManager.cs
//eventDateCalendar.AllowDeselect = true;
//eventDateCalendar.OnClientDateChanged = "onDateChange";
//eventDateCalendar.TextBoxId = proposedDateTextBox.ID;
eventDateCalendar.DateFormat = "MMM dd yyyy";
// Set Min date to date specified in Web.config variable "MinCalendarDate"
eventDateCalendar.DateMin = Convert.ToDateTime(ConfigurationManager.AppSettings["MinCalendarDate"]);
// Set Max date to date specified in Web.config variable "MaxCalendarDate"
eventDateCalendar.DateMax = Convert.ToDateTime(ConfigurationManager.AppSettings["MaxCalendarDate"]);
eventDateCalendar.TitleText = "Today is " + DateTime.Now.ToString("dddd MMMM dd, yyyy") + " ";
eventDateCalendar.ShowYearSelector = false;
#endregion
// If ProjectID was passed in then retrieve project details from DB
if (Request.QueryString["ProjectID"] != null)
{
// Get the ProjectID from the QueryString
//int projectID = 6;
int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
// Get project details for this project from DB
dsProjectTableAdapters.tblProjectTableAdapter projectTableAdapter = new dsProjectTableAdapters.tblProjectTableAdapter();
dsProject.tblProjectDataTable dtProject = new dsProject.tblProjectDataTable();
dsProject.tblProjectRow projectRow;
dtProject = projectTableAdapter.GetByID(projectID);
// We have a single project, so a single row of data
projectRow = (dsProject.tblProjectRow)dtProject.Rows[0];
//Response.Write("here");
//Response.End();
string coeRefNum = projectRow.COENumber;
string projectTitle = projectRow.ProjectTitle;
string projectTitleForFileName = Utilities.removeIllegalChars(projectTitle);
string boardPortfolioName = projectRow.BoardPortfolioName;
string boardPortfolioSubDirName = Utilities.removeIllegalChars(boardPortfolioName);
string uploadedServicesFileName = string.Format(@"{0}{1}{2}", coeRefNum, "_", projectTitleForFileName + "_ServiceRequest.xls");
string userUploadPath = ConfigurationManager.AppSettings["UserUploadFolderPath"];
string userUploadFolder = ConfigurationManager.AppSettings["UserUploadFolder"];
string createdBy = projectRow.CreatedBy;
string modifiedBy = projectRow.ModifiedBy;
// Set controls
coeRefNumLabel.Text = coeRefNum;
if (!projectRow.IsGLCodeNull())
{
glCodeValueLabel.Text = projectRow.GLCode.ToString();
}
else
{
glCodeValueLabel.Text = "None";
}
// Populate Status dropdown first
// Contents generated in ReadWriteManager.cs
projectTitleTextBox.Text = projectRow.ProjectTitle;
if (!projectRow.IsProjectDescriptionNull())
{
descriptionTextBox.Text = projectRow.ProjectDescription;
}
if (!projectRow.IsEventCategoryIDNull())
{
categoryDropDown.Items.FindByValue(projectRow.EventCategoryID.ToString()).Selected = true;
}
#region Set Board/Portfolio Details
// Get Board/Portfolio details from DB
dsProjectTableAdapters.mspProjectCommitteeGetByProjectIDTableAdapter project_committeeTableAdapter = new dsProjectTableAdapters.mspProjectCommitteeGetByProjectIDTableAdapter();
dsProject.mspProjectCommitteeGetByProjectIDDataTable dtProjectCommittee = new dsProject.mspProjectCommitteeGetByProjectIDDataTable();
dtProjectCommittee = project_committeeTableAdapter.GetByProjectID(projectID);
DataTableReader dtReader = new DataTableReader(dtProjectCommittee);
// Loop through datatable to set the Board/Portfolio controls
string keyPartners = "";
while (dtReader.Read())
{
// If IsPrimaryOrganizerYN = 1, set controls for primary organizer
if (dtReader["IsPrimaryOrganizerYN"].ToString() == 1.ToString())
{
boardPortfolioValueLabel.Text = dtReader["BoardPortfolioName"].ToString();
boardPortfolioIDHidden.Value = dtReader["BoardPortfolioID"].ToString();
committeeTextBox.Text = dtReader["CommitteeName"].ToString();
}
else
{
if(keyPartners.Length > 0)
{
keyPartners += ", ";
}
keyPartners += dtReader["BoardPortfolioName"].ToString();
}
}
// Set the Key Partners value label
if (keyPartners.Length == 0)
{
keyPartners = "None";
}
keyPartnerValueLabel.Text = keyPartners;
#endregion
if (!projectRow.IsPartOfOperationalPlanYNNull())
{
partOfOpPlanDropDown.Items.FindByValue(projectRow.PartOfOperationalPlanYN.ToString()).Selected = true;
}
// If dataset returns DBNull then modify dsProject.xsd
// See ProjectNotes as an example
// Article at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingannotationswithtypeddataset.asp
projectNotesTextBox.Text = projectRow.ProjectNotes;
#region Set Date/Venue Details
//Get date/venue details from DB for this project
dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter dateVenueAdapter = new dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter();
dsProject.mspDateVenueGetByProjectIDDataTable dtDateVenue = new dsProject.mspDateVenueGetByProjectIDDataTable();
dsProject.mspDateVenueGetByProjectIDRow dateVenueRow;
dtDateVenue = dateVenueAdapter.GetByProjectID(projectID);
if (dtDateVenue.Rows.Count > 0)
{
// Set date/venue controls since there's at least one date/venue row
// This would be the place to add event date controls dynamically
// to the form for each date that makes up this event.
// The height of the DIV for the date controls would have to be
// adjusted accordingly
dateVenueRow = (dsProject.mspDateVenueGetByProjectIDRow)dtDateVenue.Rows[0];
if (!dateVenueRow.IsProjectDateIDNull())
{
projectDateIDHidden.Value = dateVenueRow.ProjectDateID.ToString();
}
if (!dateVenueRow.IsProposedProjectDateNull())
{
proposedDateTextBox.Text = dateVenueRow.ProposedProjectDate.ToString();
proposedDateHidden.Value = dateVenueRow.ProposedProjectDate.ToString();
}
//Attempt to pre-set event date when calendar is opened isn't working
//eventDateCalendar.SelectedDate = (DateTime)dateVenueRow.ProposedProjectDate;
// PadLeft method specifies to add a leading zero if
// the numeric time string is less than 4 characters (eg. 900 -> 0900)
if (!dateVenueRow.IsProposedStartTimeNull())
{
startHourDropDown.Items.FindByText(dateVenueRow.ProposedStartTime.ToString().PadLeft(4, '0').Substring(0, 2)).Selected = true;
startMinuteDropDown.Items.FindByText(dateVenueRow.ProposedStartTime.ToString().PadLeft(4, '0').Substring(2, 2)).Selected = true;
}
if (!dateVenueRow.IsProposedEndTimeNull())
{
endHourDropDown.Items.FindByText(dateVenueRow.ProposedEndTime.ToString().PadLeft(4, '0').Substring(0, 2)).Selected = true;
endMinuteDropDown.Items.FindByText(dateVenueRow.ProposedEndTime.ToString().PadLeft(4, '0').Substring(2, 2)).Selected = true;
}
if (dateVenueRow.IsJKIDNull())
{
isVenueJKDropDown.Items.FindByText("No").Selected = true;
}
else
{
isVenueJKDropDown.Items.FindByText("Yes").Selected = true;
jkNameDropDown.Items.FindByValue(dateVenueRow.JKID.ToString()).Selected = true;
if (!dateVenueRow.IsMgmtCommContactedYNNull())
{
mgmtContactedDropDown.Items.FindByValue(dateVenueRow.MgmtCommContactedYN.ToString()).Selected = true;
}
}
if (!dateVenueRow.IsJKIDNull())
{
isVenueJKDropDown.Items.FindByText("Yes").Selected = true;
}
else
{
venueNameDropDown.Visible = true;
if (!dateVenueRow.IsVenueIDNull())
{
venueNameDropDown.Items.FindByValue(dateVenueRow.VenueID.ToString()).Selected = true;
}
if (!dateVenueRow.IsVenueTypeIDNull())
{
venueTypeDropDown.Items.FindByValue(dateVenueRow.VenueTypeID.ToString()).Selected = true;
}
if (!dateVenueRow.IsVenueAddressNull())
{
addressTextBox.Text = dateVenueRow.VenueAddress.ToString();
}
if (!dateVenueRow.IsCityIDNull())
{
venueCityDropDown.Items.FindByValue(dateVenueRow.CityID.ToString()).Selected = true;
}
if (!dateVenueRow.IsProvinceAbbrevNull())
{
provinceStringLabel.Text = dateVenueRow.ProvinceAbbrev.ToString();
}
if (!dateVenueRow.IsVenuePostalCodeNull())
{
postalCodeTextBox.Text = dateVenueRow.VenuePostalCode.ToString();
}
if (!dateVenueRow.IsVenueCapacityNull())
{
capacityTextBox.Text = dateVenueRow.VenueCapacity.ToString();
}
}
// Set visibility and enale/disable JK and Venue controls
isVenueJKDropDown_SelectedIndexChanged(isVenueJKDropDown, e);
venueNameDropDown_SelectedIndexChanged(venueNameDropDown, e);
}
#endregion
#region Set Project Service Details
// Get project service details from DB
dsProjectTableAdapters.tblProject_ServiceTableAdapter project_serviceTableAdapter = new dsProjectTableAdapters.tblProject_ServiceTableAdapter();
dsProject.tblProject_ServiceDataTable dtProjectServices = new dsProject.tblProject_ServiceDataTable();
dtProjectServices = project_serviceTableAdapter.GetByProjectID(projectID);
//DataTableReader dtReader = new DataTableReader(dtProjectServices);
dtReader = new DataTableReader(dtProjectServices);
// Loop through datatable to set the dropdowns
while (dtReader.Read())
{
// Get a handle on the dropdown
//DropDownList dropdown = (DropDownList) FindControl("ctl00$middleContent$" + dtReader["ServiceStringID"].ToString());
DropDownList dropdown = (DropDownList)FindControl(dtReader["ServiceStringID"].ToString());
// Set the yes/no value
dropdown.Items.FindByValue(dtReader["YesNoOptionValue"].ToString()).Selected = true;
}
if (FileHandler.CheckUploadedFileExists(userUploadPath, boardPortfolioSubDirName, uploadedServicesFileName))
{
ppServicesSpreadsheetHyperLink.NavigateUrl = userUploadFolder + "/" + boardPortfolioSubDirName + "/" + uploadedServicesFileName;
ppServicesSpreadsheetHyperLink.Text = "Uploaded File";
}
#endregion
// Enable/Disable controls based on role and status
ReadWriteManager.SetProjectDetailsPermissions(projectRow.PPStatusID, projectRow.PPStatus, form1, ds);
// Finish setting proposalStatusDropDown
proposalStatusDropDown.Items.Remove("Select One");
// Now select the current status of the project
proposalStatusDropDown.Items.FindByValue(projectRow.PPStatusID.ToString()).Selected = true;
#region Set CreatedBy and ModifiedBy
CreatedByLabel.Text = createdBy;
ModifiedByLabel.Text = modifiedBy;
#endregion
// store the current status in a hidden form element
ppCurrStatusIDHidden.Value = proposalStatusDropDown.SelectedValue;
}
else
{
// Project ID was not retrieved from Query String
}
// clean up
}
// Validate intially to force *s to appear before the first round-trip
Page.Validate();
}
protected void updateStatusButton_Click(object sender, EventArgs e)
{
if (Request.QueryString["ProjectID"] != null)
{
bool result;
string updateStatusResult;
// Get the new status
int ppNewStatusID = Convert.ToInt32(proposalStatusDropDown.SelectedValue);
string ppNewStatus = proposalStatusDropDown.SelectedItem.ToString();
if (ppNewStatusID != Convert.ToInt32(ppCurrStatusIDHidden.Value))
{
string coeRefNum = coeRefNumLabel.Text;
// Store the new status in the hidden form element
ppCurrStatusIDHidden.Value = ppNewStatusID.ToString();
string projectTitle = projectTitleTextBox.Text;
string boardPortfolioName = boardPortfolioValueLabel.Text;
int boardPortfolioID;
result = Int32.TryParse(boardPortfolioIDHidden.Value, out boardPortfolioID);
string committeeName = committeeTextBox.Text;
string proposedProjectDate = proposedDateTextBox.Text;
string proposedStartTime = startHourDropDown.SelectedItem + ":" + startMinuteDropDown.SelectedItem;
string proposedEndTime = endHourDropDown.SelectedItem + ":" + endMinuteDropDown.SelectedItem;
// Get the current logged user
string modifiedBy = User.Identity.Name;
//string modifiedBy = Request.ServerVariables["LOGON_USER"];
string userName = Utilities.GetLoggedInUserID(modifiedBy);
int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
// TO DO
// If the Chair is attempting to set the status to Post-event Eval Review,
// check that HR values have been provided before allowing status change
// Get table adapter for Project table
dsProjectTableAdapters.tblProjectTableAdapter projectTableAdapter = new dsProjectTableAdapters.tblProjectTableAdapter();
// Call the method to update the database
projectTableAdapter.UpdatePPStatusByID(ppNewStatusID, modifiedBy, projectID);
//send email notification
string sendResult;
sendResult = PPSNotification.SendStatusUpdateEmail(coeRefNum, projectTitle, proposedProjectDate,
proposedStartTime, proposedEndTime, boardPortfolioName, boardPortfolioID,
committeeName, ppNewStatus, userName);
// Display message for user
updateStatusResult = "Project status has been set to '" + ppNewStatus + "'. " + sendResult;
saveResultLabel.Text = saveResultLabel2.Text = updateStatusResult; // top and bottom of page
}
else
{
// Display message for user
updateStatusResult = "<b>WARNING!</b> Project status is already set to '" + ppNewStatus + "'. Please change status first.";
saveResultLabel.Text = saveResultLabel2.Text = updateStatusResult; // top and bottom of page
}
}
}
protected void updateEventDateButton_Click(object sender, EventArgs e)
{
bool result;
string changeDateResult;
DateTime proposedProjectDate;
string modifiedBy = Request.ServerVariables["LOGON_USER"];
int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
if (Request.QueryString["ProjectID"] != null)
{
// Update Project Date
int projectDateID;
result = Int32.TryParse(projectDateIDHidden.Value, out projectDateID);
//result = DateTime.TryParse(proposedDateHidden.Value, out proposedProjectDate);
result = DateTime.TryParse(proposedDateTextBox.Text, out proposedProjectDate);
if (result == false)
{
//Error, so cannot save changes. Most likely NULL date passed in
// Display message for user
changeDateResult = "There was an error changing the date. Make sure a date has been selected.";
saveResultLabel.Text = saveResultLabel2.Text = changeDateResult; // top and bottom of page
}
else
{
// Get table adapter for Project date & venue (adapter based on stored proc)
dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter date_venueAdapter = new dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter();
// Call the method to update the database
date_venueAdapter.UpdateEventDateByID(
projectDateID, projectID, proposedProjectDate, modifiedBy);
changeDateResult = "Event date was succesfully changed to " + proposedProjectDate.ToLongDateString();
saveResultLabel.Text = saveResultLabel2.Text = changeDateResult; // top and bottom of page
}
}
}
protected void saveProjectButton_Click(object sender, EventArgs e)
{
Page.Validate("eventDetails");
if (Request.QueryString["ProjectID"] != null)
{
// Create variable to hold return value from SP
int spReturnVal;
bool result;
string modifiedBy = Request.ServerVariables["LOGON_USER"];
int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
// Get project details
string projectTitle = projectTitleTextBox.Text;
string projectTitleForFileName = Utilities.removeIllegalChars(projectTitle);
string boardPortfolioName = boardPortfolioValueLabel.Text;
string boardPortfolioSubDirName = Utilities.removeIllegalChars(boardPortfolioName);
int eventCategoryID;
result = Int32.TryParse(categoryDropDown.SelectedValue, out eventCategoryID);
string projectDescription = descriptionTextBox.Text;
int partOfOpPlan = Convert.ToInt32(partOfOpPlanDropDown.SelectedValue);
string projectNotes = projectNotesTextBox.Text;
// BoardPortfolioID needed to insert/update committee name
int boardPortfolioID;
result = Int32.TryParse(boardPortfolioIDHidden.Value, out boardPortfolioID);
string committeeName = committeeTextBox.Text;
string uploadResult = "";
string userUploadFolderPath = ConfigurationManager.AppSettings["UserUploadFolderPath"];
string rootUploadFolder = ConfigurationManager.AppSettings["UserUploadFolder"];
string userServicesFileName = servicesFileUpload.PostedFile.FileName;
string createdServicesFileName = "";
string allowedServicesFileExtensions = ".xls";
userServicesFileName = userServicesFileName.Substring(userServicesFileName.LastIndexOfAny(new char[] { Char.Parse(@"\"), Char.Parse(@"/") }) + 1);
// Upload the Services spreadsheet if it was specified
uploadResult = FileHandler.UploadFile(servicesFileUpload, false,
boardPortfolioSubDirName, coeRefNumLabel.Text, projectTitleForFileName + "_ServiceRequest",
userUploadFolderPath, rootUploadFolder, allowedServicesFileExtensions);
// If file was uploaded, display message & URL for uploaded file
if (uploadResult.IndexOf(@rootUploadFolder) == 0)
{
ppServicesSpreadsheetHyperLink.NavigateUrl = uploadResult;
ppServicesSpreadsheetHyperLink.Text = "New Uploaded File";
createdServicesFileName = uploadResult.Substring(uploadResult.LastIndexOfAny(new char[] { Char.Parse(@"\"), Char.Parse(@"/") }) + 1);
uploadResult = "File '" + userServicesFileName + "' uploaded as '" + createdServicesFileName + "'.";
}
else
{
// Suppress messages if user indicated that no services are required
if (alakhbar.SelectedItem.ToString().ToUpper() == "NO"
&& transportation.SelectedItem.ToString().ToUpper() == "NO"
&& insurance.SelectedItem.ToString().ToUpper() == "NO"
&& ivc.SelectedItem.ToString().ToUpper() == "NO")
{
uploadResult = "";
}
else if (uploadResult == "File for upload not specified")
{
uploadResult = "Services are required but request form was not uploaded.";
}
}
// Display upload result message for user
saveResultLabel.Text = saveResultLabel2.Text =uploadResult; // top and bottom of page
// Get table adapter for Project table
dsProjectTableAdapters.tblProjectTableAdapter projectTableAdapter = new dsProjectTableAdapters.tblProjectTableAdapter();
// Call the method to update project table in the database
//spReturnVal = (int)projectTableAdapter.UpdateByID(...not working
projectTableAdapter.UpdateByID(projectTitle, eventCategoryID,
projectDescription, partOfOpPlan, projectNotes, modifiedBy, projectID,
boardPortfolioID, committeeName);
// Retrieve return value
// hard-coded because was not able to retrieve it from the method call
spReturnVal = 0;
if (spReturnVal != 0)
{
// Error condition
}
// Update Project Date & Venue details
int projectDateID;
result = Int32.TryParse(projectDateIDHidden.Value, out projectDateID);
DateTime proposedProjectDate;
result = DateTime.TryParse(proposedDateTextBox.Text, out proposedProjectDate);
if (result == false)
{
proposedProjectDate = Convert.ToDateTime("01/01/2006");
}
DateTime proposedStartTime; //= Convert.ToDateTime(startHourDropDown.SelectedItem + ":" + startMinuteDropDown.SelectedItem);
result = DateTime.TryParse(startHourDropDown.SelectedItem + ":" + startMinuteDropDown.SelectedItem, out proposedStartTime);
DateTime proposedEndTime; //= Convert.ToDateTime(endHourDropDown.SelectedItem + ":" + endMinuteDropDown.SelectedItem);
result = DateTime.TryParse(endHourDropDown.SelectedItem + ":" + endMinuteDropDown.SelectedItem, out proposedEndTime);
int jkID = -1;
Int16 mgmtCommContactedYN = 0;
int venueID = -1;
string newVenueName = null;
int venueTypeID = 0;
string venueAddress = null;
int venueCityID = 0;
string venuePostalCode = null;
string venueCapacity = null;
// If the venue is not a JK
if (isVenueJKDropDown.SelectedItem.ToString().ToUpper() == "NO")
{
// If it's a new venue, get the details
if (venueNameDropDown.SelectedItem.ToString().ToUpper() == "NEW VENUE")
{
newVenueName = newVenueNameTextBox.Text;
venueTypeID = Convert.ToInt32(venueTypeDropDown.SelectedValue);
venueAddress = addressTextBox.Text;
venueCityID = Convert.ToInt32(venueCityDropDown.SelectedValue);
venuePostalCode = postalCodeTextBox.Text;
venueCapacity = capacityTextBox.Text;
}
else
{
// VenueID needs to be added or updated for project date
venueID = Convert.ToInt32(venueNameDropDown.SelectedValue);
}
}
else
{
// If the venue IS a JK
if (isVenueJKDropDown.SelectedItem.ToString().ToUpper() == "YES")
{
jkID = Convert.ToInt32(jkNameDropDown.SelectedValue);
mgmtCommContactedYN = Convert.ToInt16(mgmtContactedDropDown.SelectedValue);
}
}
// Get table adapter for Project date & venue (adapter based on stored proc)
dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter date_venueAdapter = new dsProjectTableAdapters.mspDateVenueGetByProjectIDTableAdapter();
// Call the method to update the database
date_venueAdapter.UpdateByProjectID(
projectDateID, projectID, proposedProjectDate, proposedStartTime,
proposedEndTime, jkID, mgmtCommContactedYN, modifiedBy, newVenueName,
venueTypeID, venueAddress, venueCityID, venuePostalCode, venueCapacity, venueID);
// Update project service details
short alakhbarRequired;
result = Int16.TryParse(alakhbar.SelectedValue, out alakhbarRequired);
short transportationRequired;
result = Int16.TryParse(transportation.SelectedValue, out transportationRequired);
short insuranceRequired;
result = Int16.TryParse(insurance.SelectedValue, out insuranceRequired);
short ivcRequired;
result = Int16.TryParse(ivc.SelectedValue, out ivcRequired);
// Get table adapter for Project_Service table
dsProjectTableAdapters.tblProject_ServiceTableAdapter project_serviceTableAdapter = new dsProjectTableAdapters.tblProject_ServiceTableAdapter();
// Call the method to update the database
project_serviceTableAdapter.UpdateByProjectID(projectID, "alakhbar", alakhbarRequired, modifiedBy, modifiedBy);
project_serviceTableAdapter.UpdateByProjectID(projectID, "transportation", transportationRequired, modifiedBy, modifiedBy);
project_serviceTableAdapter.UpdateByProjectID(projectID, "insurance", insuranceRequired, modifiedBy, modifiedBy);
project_serviceTableAdapter.UpdateByProjectID(projectID, "ivc", ivcRequired, modifiedBy, modifiedBy);
// Retrieve return value
spReturnVal = 0;
if (spReturnVal != 0)
{
// Error condition
}
// Code for Target Segments
int newPrimaryTargetID;
Int32.TryParse(Request.Form["IsPrimaryTargetRadioButton"], out newPrimaryTargetID);
int rowNo = 0;
GridView targetGrid = (GridView)FindControl("TargetSegmentGridView");
SqlDataSource SqlDataSource1 = (SqlDataSource)FindControl("SqlDataSource1");
foreach (GridViewRow row in targetGrid.Rows)
{
string newAdditional = Request.Form["IsAdditionalCheckBox" + (rowNo + 1)];
int projectTargetSegmentID = (int)targetGrid.DataKeys[rowNo].Value;
int targetSegmentID = (int)targetGrid.DataKeys[rowNo].Values[1];
bool IsOrigPrimaryTarget = (bool)targetGrid.DataKeys[rowNo].Values[2];
//Response.Write("projectTargetSegmentID: " + projectTargetSegmentID + "<br>");
//Response.Write("TargetSegmentID: " + targetSegmentID + "<br>");
//Response.Write("NewPrimaryTargetID: " + newPrimaryTargetID + "<br>");
//Response.Write("New TargetSegmentID: " + newAdditional + "<br>");
//Response.Write("IsOrigPrimaryTarget: " + IsOrigPrimaryTarget + "<br>");
if (projectTargetSegmentID == 0)
{
if (newPrimaryTargetID == targetSegmentID)
{
// Create new row & set as primary
//Response.Write("Create new row & set as primary<br><br>");
SqlDataSource1.UpdateParameters.Clear();
// Setting update params
SqlDataSource1.UpdateParameters.Add("ProjectID", projectID.ToString());
SqlDataSource1.UpdateParameters.Add("TargetSegmentID", targetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("IsPrimaryTargetYN", 1.ToString());
SqlDataSource1.UpdateParameters.Add("ModifiedBy", modifiedBy);
SqlDataSource1.Update();
}
else if (Convert.ToInt32(newAdditional) == targetSegmentID)
{
// Create new row, but don't set as primary
//Response.Write("Create new row but don't set as primary<br><br>");
SqlDataSource1.UpdateParameters.Clear();
SqlDataSource1.UpdateParameters.Add("ProjectID", projectID.ToString());
SqlDataSource1.UpdateParameters.Add("TargetSegmentID", targetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("IsPrimaryTargetYN", 0.ToString());
SqlDataSource1.UpdateParameters.Add("ModifiedBy", modifiedBy);
SqlDataSource1.Update();
}
else
{
// Do nothing
//Response.Write("Do nothing 1<br><br>");
}
}
else
{
// Update or Delete
if (newPrimaryTargetID != targetSegmentID)
{
if (Convert.ToInt32(newAdditional) != targetSegmentID)
{
// Delete the existing row
//Response.Write("Delete the existing row<br><br>");
SqlDataSource1.DeleteParameters.Clear();
SqlDataSource1.DeleteParameters.Add("Project_TargetSegmentID", projectTargetSegmentID.ToString());
SqlDataSource1.Delete();
}
else if (IsOrigPrimaryTarget)
{
// Set Primary target to 0 or NULL & update row
//Response.Write("Set Primary target to 0 or NULL & update row<br><br>");
SqlDataSource1.UpdateParameters.Clear();
SqlDataSource1.UpdateParameters.Add("Project_TargetSegmentID", projectTargetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("ProjectID", projectID.ToString());
SqlDataSource1.UpdateParameters.Add("TargetSegmentID", targetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("IsPrimaryTargetYN", 0.ToString());
SqlDataSource1.UpdateParameters.Add("ModifiedBy", modifiedBy);
SqlDataSource1.Update();
}
else
{
// Do nothing
//Response.Write("Do nothing 2<br><br>");
}
}
else if (!IsOrigPrimaryTarget)
{
// Set Primary target to 1 & update row
//Response.Write("Set Primary target to 1 & update row<br><br>");
SqlDataSource1.UpdateParameters.Clear();
SqlDataSource1.UpdateParameters.Add("Project_TargetSegmentID", projectTargetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("ProjectID", projectID.ToString());
SqlDataSource1.UpdateParameters.Add("TargetSegmentID", targetSegmentID.ToString());
SqlDataSource1.UpdateParameters.Add("IsPrimaryTargetYN", 1.ToString());
SqlDataSource1.UpdateParameters.Add("ModifiedBy", modifiedBy);
SqlDataSource1.Update();
}
else
{
// Do nothing
//Response.Write("Do nothing 3<br><br>");
}
}
// increment the row count
rowNo++;
}
targetGrid.DataBind();
//Code for Target segments Above
}
else
{
// The ID was not received so handle problem
}
}
protected void isVenueJKDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
if (isVenueJKDropDown.SelectedItem.ToString().ToUpper() == "NO")
{
//venueDetails.Style["top"] = jkNameLabel.Style["top"];
jkNameLabel.Visible = false;
jkNameValidator.Visible = false;
jkNameDropDown.Visible = false;
jkNameDropDown.Enabled = false;
mgmtContactedLabel.Visible = false;
mgmtContactedValidator.Visible = false;
mgmtContactedDropDown.Visible = false;
mgmtContactedDropDown.Enabled = false;
// Show the venue section
venueDetails.Visible = true;
//venueDetails.Style["visibility"] = "show";
venueNameLabel.Visible = true;
venueNameDropDown.Visible = true;
venueNameDropDown.Attributes.Add("onMouseOver","checkEvent(this.event)");
venueNameDropDown.Attributes.Add("onMouseOut", "checkEvent(this.event)");
//venueNameDropDown.Attributes.Add("onMouseMove", "checkEvent(this.event)");
}
else
{
jkNameLabel.Visible = true;
jkNameValidator.Visible = true;
jkNameDropDown.Visible = true;
jkNameDropDown.Enabled = true;
jkNameDropDown.Attributes.Add("onMouseOver", "checkEvent(this.event)");
jkNameDropDown.Attributes.Add("onMouseOut", "checkEvent(this.event)");
//jkNameDropDown.Attributes.Add("onMouseMove", "checkEvent(this.event)");
mgmtContactedLabel.Visible = true;
mgmtContactedValidator.Visible = true;
mgmtContactedDropDown.Visible = true;
mgmtContactedDropDown.Enabled = true;
// Hide the venue section
venueDetails.Visible = false;
//venueDetails.Style["visibility"] = "hidden";
}
}
protected void venueNameDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
if (venueNameDropDown.SelectedItem.ToString().ToUpper() == "NEW VENUE")
{
// Show/Enable & clear controls if not already visible
if (!newVenueNameLabel.Visible)
{
newVenueNameLabel.Visible = true;
newVenueNameValidator.Visible = true;
newVenueNameTextBox.Visible = true;
venueTypeLabel.Visible = true;
addressLabel.Visible = true;
cityLabel.Visible = true;
provinceLabel.Visible = true;
provinceStringLabel.Visible = true;
postalCodeLabel.Visible = true;
capacityLabel.Visible = true;
venueTypeValidator.Visible = true;
addressValidator.Visible = true;
venueCityValidator.Visible = true;
postalCodeValidator.Visible = true;
capacityValidator.Visible = true;
venueTypeDropDown.Visible = true;
addressTextBox.Visible = true;
venueCityDropDown.Visible = true;
postalCodeTextBox.Visible = true;
capacityTextBox.Visible = true;
venueTypeDropDown.Enabled = true;
addressTextBox.Enabled = true;
venueCityDropDown.Enabled = true;
postalCodeTextBox.Enabled = true;
capacityTextBox.Enabled = true;
// Blank out the controls
venueTypeDropDown.ClearSelection();
addressTextBox.Text = "";
venueCityDropDown.ClearSelection();
postalCodeTextBox.Text = "";
capacityTextBox.Text = "";
}
}
else if (venueNameDropDown.SelectedItem.ToString().ToUpper() == "SELECT ONE")
{
// Hide/Disable the controls
newVenueNameLabel.Visible = false;
newVenueNameValidator.Visible = false;
newVenueNameTextBox.Visible = false;
// Blank out the controls
venueTypeDropDown.ClearSelection();
addressTextBox.Text = "";
venueCityDropDown.ClearSelection();
postalCodeTextBox.Text = "";
capacityTextBox.Text = "";
venueTypeLabel.Visible = false;
addressLabel.Visible = false;
cityLabel.Visible = false;
provinceLabel.Visible = false;
provinceStringLabel.Visible = false;
postalCodeLabel.Visible = false;
capacityLabel.Visible = false;
venueTypeValidator.Visible = false;
addressValidator.Visible = false;
venueCityValidator.Visible = false;
postalCodeValidator.Visible = false;
capacityValidator.Visible = false;
venueTypeDropDown.Visible = false;
addressTextBox.Visible = false;
venueCityDropDown.Visible = false;
postalCodeTextBox.Visible = false;
capacityTextBox.Visible = false;
}
else
{
//Get venue details from DB for this venueID
dsProjectTableAdapters.tluVenueTableAdapter venueAdapter = new dsProjectTableAdapters.tluVenueTableAdapter();
dsProject.tluVenueDataTable dtVenue = new dsProject.tluVenueDataTable();
dsProject.tluVenueRow venueRow;
dtVenue = venueAdapter.GetByID(Convert.ToInt32(venueNameDropDown.SelectedValue));
if (dtVenue.Rows.Count > 0)
{
venueTypeLabel.Visible = true;
addressLabel.Visible = true;
cityLabel.Visible = true;
provinceLabel.Visible = true;
provinceStringLabel.Visible = true;
postalCodeLabel.Visible = true;
capacityLabel.Visible = true;
venueTypeValidator.Visible = true;
addressValidator.Visible = true;
venueCityValidator.Visible = true;
postalCodeValidator.Visible = true;
capacityValidator.Visible = true;
venueTypeDropDown.Visible = true;
addressTextBox.Visible = true;
venueCityDropDown.Visible = true;
postalCodeTextBox.Visible = true;
capacityTextBox.Visible = true;
// Blank out the controls
venueTypeDropDown.ClearSelection();
newVenueNameTextBox.Text = "";
addressTextBox.Text = "";
venueCityDropDown.ClearSelection();
postalCodeTextBox.Text = "";
capacityTextBox.Text = "";
venueRow = (dsProject.tluVenueRow)dtVenue.Rows[0];
venueTypeDropDown.Items.FindByValue(venueRow.VenueTypeID.ToString()).Selected = true;
if (!venueRow.IsVenueAddressNull())
{
addressTextBox.Text = venueRow.VenueAddress.ToString();
}
venueCityDropDown.Items.FindByValue(venueRow.CityID.ToString()).Selected = true;
//if (!venueRow.IsProvinceAbbrevNull())
//{
// provinceStringLabel.Text = venueRow.ProvinceAbbrev.ToString();
//}
if (!venueRow.IsVenuePostalCodeNull())
{
postalCodeTextBox.Text = venueRow.VenuePostalCode.ToString();
}
if (!venueRow.IsVenueCapacityNull())
{
capacityTextBox.Text = venueRow.VenueCapacity.ToString();
}
}
// Hide/Disable the controls
newVenueNameLabel.Visible = false;
newVenueNameValidator.Visible = false;
newVenueNameTextBox.Visible = false;
venueTypeDropDown.Enabled = false;
addressTextBox.Enabled = false;
venueCityDropDown.Enabled = false;
postalCodeTextBox.Enabled = false;
capacityTextBox.Enabled = false;
}
}
}