/// <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;
}