/// <summary>
/// Save all costs to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
MaterialsInformationTDS costHistoryInformationChanges = (MaterialsInformationTDS)Data.GetChanges();
if (costHistoryInformationChanges.CostHistoryInformation.Rows.Count > 0)
{
MaterialsInformationCostHistoryInformationGateway materialsInformationCostHistoryInformationGateway = new MaterialsInformationCostHistoryInformationGateway(costHistoryInformationChanges);
foreach (MaterialsInformationTDS.CostHistoryInformationRow row in (MaterialsInformationTDS.CostHistoryInformationDataTable)costHistoryInformationChanges.CostHistoryInformation)
{
// Insert new costs
if ((!row.Deleted) && (!row.InDatabase))
{
MaterialsCostHistory materialsCostHistory = new MaterialsCostHistory(null);
materialsCostHistory.InsertDirect(row.CostID, row.MaterialID, row.Date, row.UnitOfMeasurement, row.CostCad, row.CostUsd, row.Deleted, row.COMPANY_ID);
}
// Update costs
if ((!row.Deleted) && (row.InDatabase))
{
int costId = row.CostID;
int materialId = row.MaterialID;
bool originalDeleted = row.Deleted;
int originalCompanyId = companyId;
// original values
DateTime originalDate = materialsInformationCostHistoryInformationGateway.GetDateOriginal(costId, materialId);
string originalUnitOfMeasurement = materialsInformationCostHistoryInformationGateway.GetUnitOfMeasurementOriginal(costId, materialId);
decimal originalCostCad = materialsInformationCostHistoryInformationGateway.GetCostCadOriginal(costId, materialId);
decimal originalCostUsd = materialsInformationCostHistoryInformationGateway.GetCostUsdOriginal(costId, materialId);
// new values
DateTime newDate = materialsInformationCostHistoryInformationGateway.GetDate(costId, materialId);
string newUnitOfMeasurement = materialsInformationCostHistoryInformationGateway.GetUnitOfMeasurement(costId, materialId);
decimal newCostCad = materialsInformationCostHistoryInformationGateway.GetCostCad(costId, materialId);
decimal newCostUsd = materialsInformationCostHistoryInformationGateway.GetCostUsd(costId, materialId);
MaterialsCostHistory materialsCostHistory = new MaterialsCostHistory(null);
materialsCostHistory.UpdateDirect(costId, materialId, originalDate, originalUnitOfMeasurement, originalCostCad, originalCostUsd, originalDeleted, originalCompanyId, costId, materialId, newDate, newUnitOfMeasurement, newCostCad, newCostUsd, originalDeleted, originalCompanyId);
}
// Deleted costs
if ((row.Deleted) && (row.InDatabase))
{
MaterialsCostHistory materialsCostHistory = new MaterialsCostHistory(null);
materialsCostHistory.DeleteDirect(row.CostID, row.MaterialID, row.COMPANY_ID);
}
}
}
}
protected void grdCosts_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Edit items
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int materialId = Int32.Parse(hdfCurrentMaterialId.Value);
int costId = Int32.Parse(((Label)e.Row.FindControl("lblCostIDEdit")).Text.Trim());
MaterialsInformationCostHistoryInformationGateway materialsInformationCostHistoryInformationGateway = new MaterialsInformationCostHistoryInformationGateway(materialsInformationTDS);
string unitOfMeasurement = materialsInformationCostHistoryInformationGateway.GetUnitOfMeasurement(costId, materialId);
((DropDownList)e.Row.FindControl("ddlUnitOfMeasurementMaterialsEdit")).SelectedValue = unitOfMeasurement;
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAllByMaterialId
/// </summary>
/// <param name="materialId">materialId</param>
/// <param name="companyId">companyId</param>
public void LoadAllByMaterialId(int materialId, int companyId)
{
MaterialsInformationCostHistoryInformationGateway materialsInformationCostHistoryInformationGateway = new MaterialsInformationCostHistoryInformationGateway(Data);
materialsInformationCostHistoryInformationGateway.LoadAllByMaterialId(materialId, companyId);
}