// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Insert costing sheet
/// </summary>
/// <param name="clientId">clientId</param>
/// <param name="name">name</param>
/// <param name="startDate">startDate</param>
/// <param name="endDate">endDate</param>
/// <param name="totalLabourHoursCad">totalLabourHoursCad</param>
/// <param name="totalLabourHoursUsd">totalLabourHoursUsd</param>
/// <param name="totalMaterialsCad">totalMaterialsCad</param>
/// <param name="totalMaterialsUsd">totalMaterialsUsd</param>
/// <param name="totalUnitsCad">totalUnitsCad</param>
/// <param name="totalUnitsUsd">totalUnitsUsd</param>
/// <param name="totalOtherCostsCad">totalOtherCostsCad</param>
/// <param name="totalOtherCostsUsd">totalOtherCostsUsd</param>
/// <param name="grandTotalCad">grandTotalCad</param>
/// <param name="grandTotalUsd">grandTotalUsd</param>
/// <param name="state">state</param>
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
/// <param name="totalSubcontractorsCad">totalSubcontractorsCad</param>
/// <param name="totalSubcontractorsUsd">totalSubcontractorsUsd</param>
/// <returns>CostingSheetID</returns>
public int InsertDirect(int clientId, string name, DateTime startDate, DateTime endDate, decimal totalLabourHoursCad, decimal totalLabourHoursUsd, decimal totalMaterialsCad, decimal totalMaterialsUsd, decimal totalUnitsCad, decimal totalUnitsUsd, decimal totalOtherCostsCad, decimal totalOtherCostsUsd, decimal grandTotalCad, decimal grandTotalUsd, string state, bool deleted, int companyId, decimal totalSubcontractorsCad, decimal totalSubcontractorsUsd, decimal grandRevenue, decimal grandProfit, decimal grandGrossMargin, string combinedProjects)
{
// Insert costing sheet and get costing sheet ID
ProjectCombinedCostingSheetGateway projectCostingSheetGateway = new ProjectCombinedCostingSheetGateway(null);
int costingSheetId = projectCostingSheetGateway.Insert(clientId, name, startDate, endDate, totalLabourHoursCad, totalLabourHoursUsd, totalMaterialsCad, totalMaterialsUsd, totalUnitsCad, totalUnitsUsd, totalOtherCostsCad, totalOtherCostsUsd, grandTotalCad, grandTotalUsd, state, deleted, companyId, totalSubcontractorsCad, totalSubcontractorsUsd, grandRevenue, grandProfit, grandGrossMargin, combinedProjects);
return costingSheetId;
}
/// <summary>
/// UpdateStateDirect
/// </summary>
/// <param name="originalCostingSheetId">originalCostingSheetId</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="newState">newState</param>
public void UpdateStateDirect(int originalCostingSheetId, int originalCompanyId, string newState)
{
ProjectCombinedCostingSheetGateway projectCostingSheetGateway = new ProjectCombinedCostingSheetGateway(null);
projectCostingSheetGateway.UpdateState(originalCostingSheetId, originalCompanyId, newState);
}
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="costingSheetId">costingSheetId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int costingSheetId, int companyId)
{
ProjectCombinedCostingSheetGateway projectCostingSheetGateway = new ProjectCombinedCostingSheetGateway(null);
projectCostingSheetGateway.Delete(costingSheetId, companyId);
}
/// <summary>
/// Update costing sheet
/// </summary>
/// <param name="costingSheetId">costingSheetId</param>
/// <param name="originalClientId">originalClientId</param>
/// <param name="originalName">originalName</param>
/// <param name="originalStartDate">originalStartDate</param>
/// <param name="originalEndDate">originalEndDate</param>
/// <param name="originalTotalLabourHoursCad">originalTotalLabourHoursCad</param>
/// <param name="originalTotalLabourHoursUsd">originalTotalLabourHoursUsd</param>
/// <param name="originalTotalMaterialsCad">originalTotalMaterialsCad</param>
/// <param name="originalTotalMaterialsUsd">originalTotalMaterialsUsd</param>
/// <param name="originalTotalUnitsCad">originalTotalUnitsCad</param>
/// <param name="originalTotalUnitsUsd">originalTotalUnitsUsd</param>
/// <param name="originalTotalOtherCostsCad">originalTotalOtherCostsCad</param>
/// <param name="originalTotalOtherCostsUsd">originalTotalOtherCostsUsd</param>
/// <param name="originalGrandTotalCad">originalGrandTotalCad</param>
/// <param name="originalGrandTotalUsd">originalGrandTotalUsd</param>
/// <param name="originalState">originalState</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalTotalSubcontractorsCad">originalTotalSubcontractorsCad</param>
/// <param name="originalTotalSubcontractorsUsd">originalTotalSubcontractorsUsd</param>
///
/// <param name="newProjectId">newProjectId</param>
/// <param name="newName">newName</param>
/// <param name="newStartDate">newStartDate</param>
/// <param name="newEndDate">newEndDate</param>
/// <param name="newTotalLabourHoursCad">newTotalLabourHoursCad</param>
/// <param name="newTotalLabourHoursUsd">newTotalLabourHoursUsd</param>
/// <param name="newTotalMaterialsCad">newTotalMaterialsCad</param>
/// <param name="newTotalMaterialsUsd">newTotalMaterialsUsd</param>
/// <param name="newTotalUnitsCad">newTotalUnitsCad</param>
/// <param name="newTotalUnitsUsd">newTotalUnitsUsd</param>
/// <param name="newTotalOtherCostsCad">newTotalOtherCostsCad</param>
/// <param name="newTotalOtherCostsUsd">newTotalOtherCostsUsd</param>
/// <param name="newGrandTotalCad">newGrandTotalCad</param>
/// <param name="newGrandTotalUsd">newGrandTotalUsd</param>
/// <param name="newState">newState</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newTotalSubcontractorsCad">newTotalSubcontractorsCad</param>
/// <param name="newTotalSubcontractorsUsd">newTotalSubcontractorsUsd</param>
public void UpdateDirect(int costingSheetId, int originalClientId, string originalName, DateTime originalStartDate, DateTime originalEndDate, decimal originalTotalLabourHoursCad, decimal originalTotalLabourHoursUsd, decimal originalTotalMaterialsCad, decimal originalTotalMaterialsUsd, decimal originalTotalUnitsCad, decimal originalTotalUnitsUsd, decimal originalTotalOtherCostsCad, decimal originalTotalOtherCostsUsd, decimal originalGrandTotalCad, decimal originalGrandTotalUsd, string originalState, bool originalDeleted, int originalCompanyId, decimal originalTotalSubcontractorsCad, decimal originalTotalSubcontractorsUsd, decimal originalGrandRevenue, decimal originalGrandProfit, decimal originalGrandGrossMargin, int newProjectId, string newName, DateTime newStartDate, DateTime newEndDate, decimal newTotalLabourHoursCad, decimal newTotalLabourHoursUsd, decimal newTotalMaterialsCad, decimal newTotalMaterialsUsd, decimal newTotalUnitsCad, decimal newTotalUnitsUsd, decimal newTotalOtherCostsCad, decimal newTotalOtherCostsUsd, decimal newGrandTotalCad, decimal newGrandTotalUsd, string newState, bool newDeleted, int newCompanyId, decimal newTotalSubcontractorsCad, decimal newTotalSubcontractorsUsd, decimal newGrandRevenue, decimal newGrandProfit, decimal newGrandGrossMargin, string originalCombinedProjects, string newCombinedProjects)
{
ProjectCombinedCostingSheetGateway projectCostingSheetGateway = new ProjectCombinedCostingSheetGateway(null);
projectCostingSheetGateway.Update(costingSheetId, originalClientId, originalName, originalStartDate, originalEndDate, originalTotalLabourHoursCad, originalTotalLabourHoursUsd, originalTotalMaterialsCad, originalTotalMaterialsUsd, originalTotalUnitsCad, originalTotalUnitsUsd, originalTotalOtherCostsCad, originalTotalOtherCostsUsd, originalGrandTotalCad, originalGrandTotalUsd, originalState, originalDeleted, originalCompanyId, originalTotalSubcontractorsCad, originalTotalSubcontractorsUsd, originalGrandRevenue, originalGrandProfit, originalGrandGrossMargin, newProjectId, newName, newStartDate, newEndDate, newTotalLabourHoursCad, newTotalLabourHoursUsd, newTotalMaterialsCad, newTotalMaterialsUsd, newTotalUnitsCad, newTotalUnitsUsd, newTotalOtherCostsCad, newTotalOtherCostsUsd, newGrandTotalCad, newGrandTotalUsd, newState, newDeleted, newCompanyId, newTotalSubcontractorsCad, newTotalSubcontractorsUsd, newGrandRevenue, newGrandProfit, newGrandGrossMargin, originalCombinedProjects, newCombinedProjects);
}