private void LoadAddress()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int contactId = Int32.Parse(hdfContactId.Value);
AddressGateway addressGateway = new AddressGateway();
addressGateway.LoadByContactId(contactId, companyId);
if (addressGateway.Table.Rows.Count > 0)
{
tbxAddress.Text = addressGateway.GetAddress(contactId);
tbxCity.Text = addressGateway.GetCity(contactId);
tbxProvState.Text = addressGateway.GetProvinceFullName(contactId);
tbxPostalCode.Text = addressGateway.GetPostalCode(contactId);
tbxCountry.Text = addressGateway.GetCountry(contactId);
}
else
{
tbxAddress.Text = "";
tbxCity.Text = "";
tbxProvState.Text = "";
tbxPostalCode.Text = "";
tbxCountry.Text = "";
}
}
/// <summary>
/// UpdateForProcess
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="companiesId">companiesId</param>
/// <param name="salesmanId">salesmanId</param>
/// <param name="projectLeadId">projectLeadId</param>
/// <param name="companyId">companyId</param>
public void UpdateForReport(int projectId, int companiesId, int salesmanId, int projectLeadId, int companyId)
{
CompaniesGateway companiesGateway = new CompaniesGateway();
AddressGateway addressGateway = new AddressGateway();
ContactsGateway contactsGateway = new ContactsGateway();
PhoneGateway phoneGateway = new PhoneGateway();
EmployeeGateway employeeGateway = new EmployeeGateway();
ProjectSynopsisReportTDS.LFS_PROJECTRow projectRow = GetProjectRow(projectId);
// Companies Name
companiesGateway.LoadAllByCompaniesId(companiesId, companyId);
projectRow.ClientName = companiesGateway.GetName(companiesId);
// Companies Address
addressGateway.LoadByCompaniesId(companiesId, companyId);
projectRow.ClientAddress = addressGateway.GetAddressByCompaniesId(companiesId);
// Submitted By
// ...If the project has a record at history
employeeGateway.LoadByEmployeeId(salesmanId);
projectRow.SubmittedBy = employeeGateway.GetLastName(salesmanId) + " " + employeeGateway.GetFirstName(salesmanId);
// ... Leaded By
if (projectLeadId > 0)
{
employeeGateway.LoadByEmployeeId(projectLeadId);
projectRow.LeadedBy = employeeGateway.GetLastName(projectLeadId) + " " + employeeGateway.GetFirstName(projectLeadId);
}
else
{
projectRow.LeadedBy = "";
}
// ... Primary contact
if (!projectRow.IsClientPrimaryContactIDNull())
{
// ... ... Primary contact name
contactsGateway.LoadAllByContactId(projectRow.ClientPrimaryContactID, companyId);
projectRow.ClientPrimaryContactName = contactsGateway.GetCompleteName(projectRow.ClientPrimaryContactID);
// ... ... Primary contact position
projectRow.ClientPrimaryContactPosition = contactsGateway.GetCompaniesPosition(projectRow.ClientPrimaryContactID);
// ... ... Phone
phoneGateway.LoadByContactId(projectRow.ClientPrimaryContactID, companyId);
projectRow.ClientPrimaryContactPhones = phoneGateway.GetPhones(projectRow.ClientPrimaryContactID);
}
// ... Secondary contact
if (!projectRow.IsClientSecondaryContactIDNull())
{
// ... ... Primary contact name
contactsGateway.LoadAllByContactId(projectRow.ClientSecondaryContactID, companyId);
projectRow.ClientSecondaryContactName = contactsGateway.GetCompleteName(projectRow.ClientSecondaryContactID);
// ... ... Primary contact position
projectRow.ClientSecondaryContactPosition = contactsGateway.GetCompaniesPosition(projectRow.ClientSecondaryContactID);
// ... ... Phone
phoneGateway.LoadByContactId(projectRow.ClientSecondaryContactID, companyId);
projectRow.ClientSecondaryContactPhones = phoneGateway.GetPhones(projectRow.ClientSecondaryContactID);
}
}
