private ProjectNavigatorTDS SubmitSearch()
{
// Retrive parameters
string projectNumber = tbxProjectNumber.Text.Trim();
string name = tbxName.Text.Trim();
string client = tbxClient.Text.Trim();
string projectType = "";
string projectState = "";
string country = "";
if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_ADMIN"]))
{
projectType = ddlProjectType.SelectedItem.Value.ToString();
projectState = ddlProjectState.SelectedItem.Value.ToString();
}
else
{
projectType = ddlProjectTypeAdmin.SelectedItem.Value.ToString();
projectState = ddlProjectStateAdmin.SelectedItem.Value.ToString();
}
if (ddlCountry.SelectedIndex > 0)
{
country = ddlCountry.SelectedValue;
}
// Load data
ProjectNavigatorGateway projectNavigatorGateway = new ProjectNavigatorGateway();
projectNavigatorGateway.LoadByProjectNumberNameClientProjectTypeProjectStateCountry(projectNumber, name, client, projectType, projectState, country);
return (ProjectNavigatorTDS)projectNavigatorGateway.Data;
}
private void StepProposalsIn()
{
// Set instruction
mWizard2 master2 = (mWizard2)this.Master;
master2.WizardInstruction = "Please select the proposal you would like to duplicate.";
// Set grid to initial state
lblError.Visible = false;
// Prepare initial data
// ... Load data
ProjectNavigatorGateway projectNavigatorGateway = new ProjectNavigatorGateway(duplicateProjectNavigatorTDS);
projectNavigatorGateway.LoadByProjectType("Proposal");
//... for the total rows
if (projectNavigatorGateway.Table.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + projectNavigatorGateway.Table.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
// ... Store datasets
Session["duplicateProjectNavigatorTDS"] = duplicateProjectNavigatorTDS;
Session["addDuplicateProjectNavigator"] = duplicateProjectNavigatorTDS.LFS_PROJECT_NAVIGATOR;
}
private void UpdateDatabase()
{
try
{
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
projectGateway.Update3();
projectTDS.AcceptChanges();
// Save notes
int companyId = Int32.Parse(Session["companyID"].ToString());
ProjectNavigatorGateway projectNavigatorGateway = new ProjectNavigatorGateway(projectNavigatorTDS);
ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
projectNavigatorProjectNotes.Save(companyId);
Session["lfsProjectTDS"] = projectTDS;
Session["projectNavigatorTDS"] = projectNavigatorTDS;
Session["lfsLibraryTDS"] = libraryTDS;
}
catch (Exception ex)
{
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}