/// <summary>
/// Save
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="companyId">companyId</param>
/// <param name="loginId">loginId</param>
public void Save(int companyId, int loginId)
{
foreach (DataMigrationTDS.DataMigrationProjectRow row in (DataMigrationTDS.DataMigrationProjectDataTable)Table)
{
// get parameters
DateTime date = DateTime.Now;
Int64 countryId = row.CountryID;
Int64? provinceId = null; if (!row.IsProvinceIDNull()) provinceId = row.ProvinceID;
Int64? countyId = null; if (!row.IsCountyIDNull()) countyId = row.CountyID;
Int64? cityId = null; if (!row.IsCityIDNull()) cityId = row.CityID;
int officeId = row.OfficeID;
int? projectLeadId = null; if (!row.IsProjectLeadIDNull()) projectLeadId = row.ProjectLeadID;
int salesmanId = row.SalesmanID;
string projectState = "Active";
string projectType = "Project";
string name = row.Name;
int clientId = row.COMPANIES_ID;
string projectNumber = GetProjectNumber(row, companyId);
DataMigrationProjectGateway dataMigrationProjectGateway = new DataMigrationProjectGateway(null);
if (dataMigrationProjectGateway.GetProjectIdByName(row.Name) == 0)
{
int projectId = dataMigrationProjectGateway.InsertProject(countryId, officeId, projectLeadId, salesmanId, projectNumber, projectType, projectState, name, "", null, null, null, clientId, null, null, "", false, null, null, null, provinceId, cityId, companyId, countyId);
dataMigrationProjectGateway.InsertHistory(projectId, 1, projectState, DateTime.Now, loginId, companyId);
ProjectNumberGateway projectNumberGateway = new ProjectNumberGateway();
projectNumberGateway.Load();
ProjectNumber projectNumberForLoad = new ProjectNumber(projectNumberGateway.Data);
string pnProjectIncrement = projectNumberForLoad.GetProjectIncrement(date.Year, companyId);
int projectIncrement = int.Parse(pnProjectIncrement);
dataMigrationProjectGateway.UpdateProjectNumber(date.Year, projectIncrement, companyId);
}
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="companyId">companyId</param>
/// <param name="loginId">loginId</param>
public void Save(int companyId, int loginId)
{
foreach (DataMigrationTDS.JlDataMigrationRow row in (DataMigrationTDS.JlDataMigrationDataTable)Table)
{
// Get ids & location
ProjectGateway projectGateway = new ProjectGateway();
DataMigrationProjectGateway dataMigrationProjectGateway = new DataMigrationProjectGateway(null);
string name = string.Format("{0} Data Migration Project", row.Client);
int projectId = dataMigrationProjectGateway.GetProjectIdByName(name);
if (projectId != 0)
{
projectGateway.LoadByProjectId(projectId);
// get parameters
Int64 countryId = projectGateway.GetCountryID(projectId);
Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = projectGateway.GetProvinceID(projectId);
Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = projectGateway.GetCountyID(projectId);
Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = projectGateway.GetCityID(projectId);
//Save section
int section_assetId = SaveSection(row, projectId, countryId, provinceId, countyId, cityId, companyId);
Guid originalId = row.OriginalID;
if (row.JLiner)
{
SaveJLWork(originalId, section_assetId, row.NumLats, row.NotLinedYet, row.AllMeasured, row.IssueWithLaterals, row.NotMeasuredYet, row.NotDeliveredYet, projectId, countryId, provinceId, countyId, cityId, companyId);
}
// Insert in DataMigration Table
string originalSectionId = row.OriginalSectionID;
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
assetSewerSectionGateway.LoadByAssetId(section_assetId, companyId);
string newSectionId = assetSewerSectionGateway.GetSectionId(section_assetId);
DataMigrationGateway dataMigrationGateway = new DataMigrationGateway(null);
dataMigrationGateway.InsertDataMigration(originalId, originalSectionId, section_assetId, newSectionId);
}
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="companyId">companyId</param>
/// <param name="loginId">loginId</param>
public void Save(int companyId, int loginId)
{
foreach (DataMigrationTDS.DataMigrationRow row in (DataMigrationTDS.DataMigrationDataTable)Table)
{
// Get ids & location
ProjectGateway projectGateway = new ProjectGateway();
DataMigrationProjectGateway dataMigrationProjectGateway = new DataMigrationProjectGateway(null);
string name = string.Format("{0} Data Migration Project", row.Client);
int projectId = dataMigrationProjectGateway.GetProjectIdByName(name);
if (projectId != 0)
{
projectGateway.LoadByProjectId(projectId);
// get parameters
Int64 countryId = projectGateway.GetCountryID(projectId);
Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = projectGateway.GetProvinceID(projectId);
Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = projectGateway.GetCountyID(projectId);
Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = projectGateway.GetCityID(projectId);
//Save section
int section_assetId = SaveSection(row, projectId, countryId, provinceId, countyId, cityId, companyId);
if (row.RehabAssessment)
{
string raComments = "";
SaveRAWork(row, projectId, section_assetId, companyId, raComments, loginId);
}
if (row.FullLengthLining)
{
string fllComments = "";
SaveFLLWork(row, projectId, section_assetId, companyId, fllComments, loginId);
}
if (row.JLiner)
{
SaveJLWork(projectId, section_assetId, companyId);
}
// Insert in DataMigration Table
Guid originalId = row.OriginalID;
string originalSectionId = row.OriginalSectionID;
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
assetSewerSectionGateway.LoadByAssetId(section_assetId, companyId);
string newSectionId = assetSewerSectionGateway.GetSectionId(section_assetId);
DataMigrationGateway dataMigrationGateway = new DataMigrationGateway(null);
dataMigrationGateway.InsertDataMigration(originalId, originalSectionId, section_assetId, newSectionId);
}
}
}