/// <summary>
/// Save all Service to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
ProjectNavigatorTDS serviceChanges = (ProjectNavigatorTDS)Data.GetChanges();
if (serviceChanges != null)
{
if (serviceChanges.ProjectService.Rows.Count > 0)
{
ProjectNavigatorProjectServiceGateway projectNavigatorProjectServiceGateway = new ProjectNavigatorProjectServiceGateway(serviceChanges);
foreach (ProjectNavigatorTDS.ProjectServiceRow row in (ProjectNavigatorTDS.ProjectServiceDataTable)serviceChanges.ProjectService)
{
// Insert new Service
if ((!row.Deleted) && (!row.InDatabase))
{
int? serviceId = null; if (!row.IsServiceIDNull()) serviceId = row.ServiceID;
string description = ""; if (!row.IsDescriptionNull()) description = row.Description;
string averageSize = ""; if (!row.IsAverageSizeNull()) averageSize = row.AverageSize;
decimal? averagePrice = null; if (!row.IsAveragePriceNull()) averagePrice = row.AveragePrice;
ProjectService projectService = new ProjectService(null);
projectService.InsertDirect(row.ProjectID, row.RefID, serviceId, description, averageSize, averagePrice, row.Quantity, row.Deleted, row.COMPANY_ID);
}
// Update Service
if ((!row.Deleted) && (row.InDatabase))
{
int projectId = row.ProjectID;
int refId = row.RefID;
bool originalDeleted = false;
int originalCompanyId = companyId;
// original values
int? originalServiceId = projectNavigatorProjectServiceGateway.GetServiceIDOriginal(projectId, refId);
string originalDescription = projectNavigatorProjectServiceGateway.GetDescriptionOriginal(projectId, refId);
string originalAverageSize = projectNavigatorProjectServiceGateway.GetAverageSizeOriginal(projectId, refId);
decimal? originalAveragePrice = projectNavigatorProjectServiceGateway.GetAveragePriceOriginal(projectId, refId);
int originalQuantity = projectNavigatorProjectServiceGateway.GetQuantityOriginal(projectId, refId);
// new values
int? newServiceId = projectNavigatorProjectServiceGateway.GetServiceID(projectId, refId);
string newDescription = projectNavigatorProjectServiceGateway.GetDescription(projectId, refId);
string newAverageSize = projectNavigatorProjectServiceGateway.GetAverageSize(projectId, refId);
decimal? newAveragePrice = projectNavigatorProjectServiceGateway.GetAveragePrice(projectId, refId);
int newQuantity = projectNavigatorProjectServiceGateway.GetQuantity(projectId, refId);
ProjectService projectService = new ProjectService(null);
projectService.UpdateDirect(projectId, refId, originalServiceId, originalDescription, originalAverageSize, originalAveragePrice, originalQuantity, originalDeleted, originalCompanyId, projectId, refId, newServiceId, newDescription, newAverageSize, newAveragePrice, newQuantity, originalDeleted, originalCompanyId);
}
// Deleted Service
if ((row.Deleted) && (row.InDatabase))
{
ProjectService projectService = new ProjectService(null);
projectService.DeleteDirect(row.ProjectID, row.RefID, row.COMPANY_ID);
}
}
}
}
}
private void InsertProjectService(int originalProjectId)
{
// ... Data for current project
ProjectTDS projectTDSTemp = new ProjectTDS();
ProjectServiceGateway projectServiceGatewayTemp = new ProjectServiceGateway(projectTDSTemp);
projectServiceGatewayTemp.LoadAllByProjectId(originalProjectId);
ProjectServiceGateway projectServiceGateway = new ProjectServiceGateway(projectTDS);
projectServiceGateway.LoadAllByProjectId(originalProjectId);
// ... Definition of general variables
int refId;
int? serviceId = null;
string description;
string averageSize;
decimal? averagePrice = null;
int quantity;
bool deleted;
decimal total;
foreach (ProjectTDS.LFS_PROJECT_SERVICERow row in projectTDSTemp.Tables["LFS_PROJECT_SERVICE"].Rows)
{
refId = row.RefID;
try { serviceId = row.ServiceID; }
catch { serviceId = null; }
try { description = row.Description; }
catch { description = ""; }
try { averageSize = row.AverageSize; }
catch { averageSize = ""; }
try { averagePrice = row.AveragePrice; }
catch { averagePrice = null; }
quantity = row.Quantity;
deleted = row.Deleted;
try { total = row.AveragePrice * row.Quantity; }
catch { total = 0; }
// ... Insert Service
ProjectService projectService = new ProjectService(projectTDS);
projectService.Insert(0, refId, serviceId, description, averageSize, averagePrice, quantity, deleted, total, Int32.Parse(hdfCompanyId.Value.Trim()));
}
}