/// <summary> /// GetMaterialData /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="materialId">v</param> /// <param name="work_">work_</param> /// <param name="newRow">newRow</param> private void GetMaterialData(DateTime startDate, DateTime endDate, int materialId, string work_, ProjectCostingSheetAddTDS.MaterialsInformationRow newRow) { ProjectCostingSheetAddMaterialListGateway projectCostingSheetAddMaterialListGateway = new ProjectCostingSheetAddMaterialListGateway(); projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialIdWork_(startDate, endDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialId(startDate, endDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialIdWork_(startDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialId(startDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByMaterialId(materialId); } } } } DataRow materialRow = projectCostingSheetAddMaterialListGateway.GetRow(materialId); newRow.CostUsd = (decimal)materialRow["CostUsd"]; newRow.CostCad = (decimal)materialRow["CostCad"]; }
/// <summary> /// GetCostUsd /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="description">description</param> /// <param name="work_">work_</param> /// <param name="companyId">companyId</param> /// <returns>cost</returns> private decimal GetCostUsd(DateTime startDate, DateTime endDate, string description, string work_, int companyId) { decimal cost = 0; MaterialsGateway materialsGateway = new MaterialsGateway(); materialsGateway.LoadByDescription(description, companyId); if (materialsGateway.Table.Rows.Count > 0) { int materialId = materialsGateway.GetMaterialId(description); ProjectCostingSheetAddMaterialListGateway projectCostingSheetAddMaterialListGateway = new ProjectCostingSheetAddMaterialListGateway(); projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialIdWork_(startDate, endDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialId(startDate, endDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialIdWork_(startDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialId(startDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByMaterialId(materialId); } } } } DataRow materialRow = projectCostingSheetAddMaterialListGateway.GetRow(materialId); cost = (decimal)materialRow["CostUsd"]; } return cost; }