/// <summary>
/// LoadAllByMaterialId
/// </summary>
/// <param name="materialId">materialId</param>
/// <param name="companyId">companyId</param>
public void LoadAllByMaterialId(int materialId, int companyId)
{
MaterialsInformationCostHistoryExceptionsInformationGateway materialsInformationCostHistoryExceptionsInformationGateway = new MaterialsInformationCostHistoryExceptionsInformationGateway(Data);
materialsInformationCostHistoryExceptionsInformationGateway.LoadAllByMaterialId(materialId, companyId);
}
/// <summary>
/// Save all materials to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId, int materialId)
{
MaterialsInformationTDS costHistoryExceptionsInformationChanges = (MaterialsInformationTDS)Data.GetChanges();
if (costHistoryExceptionsInformationChanges.CostHistoryExceptionsInformation.Rows.Count > 0)
{
MaterialsInformationCostHistoryExceptionsInformationGateway materialsInformationCostHistoryExceptionsInformationGateway = new MaterialsInformationCostHistoryExceptionsInformationGateway(costHistoryExceptionsInformationChanges);
foreach (MaterialsInformationTDS.CostHistoryExceptionsInformationRow row in (MaterialsInformationTDS.CostHistoryExceptionsInformationDataTable)costHistoryExceptionsInformationChanges.CostHistoryExceptionsInformation)
{
// Insert new costs exceptions
if ((!row.Deleted) && (!row.InDatabase))
{
MaterialsCostHistoryExceptions materialsCostHistoryExceptions = new MaterialsCostHistoryExceptions(null);
materialsCostHistoryExceptions.InsertDirect(row.CostID, row.RefID, materialId, row.Work_, row.Function_, row.UnitOfMeasurement, row.CostCad, row.CostUsd, row.Deleted, row.COMPANY_ID);
}
// Update costs exceptions
if ((!row.Deleted) && (row.InDatabase))
{
int costId = row.CostID;
int refId = row.RefID;
bool originalDeleted = row.Deleted;
int originalCompanyId = companyId;
// original values
string originalWork = materialsInformationCostHistoryExceptionsInformationGateway.GetWork_Original(costId, refId);
string originalFunction = materialsInformationCostHistoryExceptionsInformationGateway.GetFunction_Original(costId, refId);
string originalUnitOfMeasurement = materialsInformationCostHistoryExceptionsInformationGateway.GetUnitOfMeasurementOriginal(costId, refId);
decimal originalCostCad = materialsInformationCostHistoryExceptionsInformationGateway.GetCostCadOriginal(costId, refId);
decimal originalCostUsd = materialsInformationCostHistoryExceptionsInformationGateway.GetCostUsdOriginal(costId, refId);
// new values
string newWork = materialsInformationCostHistoryExceptionsInformationGateway.GetWork_Original(costId, refId);
string newFunction = materialsInformationCostHistoryExceptionsInformationGateway.GetFunction_Original(costId, refId);
string newUnitOfMeasurement = materialsInformationCostHistoryExceptionsInformationGateway.GetUnitOfMeasurement(costId, refId);
decimal newCostCad = materialsInformationCostHistoryExceptionsInformationGateway.GetCostCad(costId, refId);
decimal newCostUsd = materialsInformationCostHistoryExceptionsInformationGateway.GetCostUsd(costId, refId);
MaterialsCostHistoryExceptions materialsCostHistoryExceptions = new MaterialsCostHistoryExceptions(null);
materialsCostHistoryExceptions.UpdateDirect(costId, refId, materialId, originalWork, originalFunction, originalUnitOfMeasurement, originalCostCad, originalCostUsd, originalDeleted, originalCompanyId, costId, refId, materialId, newWork, newFunction, newUnitOfMeasurement, newCostCad, newCostUsd, originalDeleted, originalCompanyId);
}
// Deleted costs exceptions
if ((row.Deleted) && (row.InDatabase))
{
MaterialsCostHistoryExceptions materialsCostHistoryExceptions = new MaterialsCostHistoryExceptions(null);
materialsCostHistoryExceptions.DeleteDirect(row.CostID, row.RefID, row.COMPANY_ID);
}
}
}
}
protected void grdCostsExceptions_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 refId = Int32.Parse(((Label)e.Row.FindControl("lblExceptionRefIDEdit")).Text.Trim());
int costId = Int32.Parse(((Label)e.Row.FindControl("lblExceptionCostIDEdit")).Text.Trim());
MaterialsInformationCostHistoryExceptionsInformationGateway materialsInformationCostHistoryExceptionsInformationGateway = new MaterialsInformationCostHistoryExceptionsInformationGateway(materialsInformationTDS);
string workFunction = materialsInformationCostHistoryExceptionsInformationGateway.GetWorkFunction(costId, refId);
((DropDownList)e.Row.FindControl("ddlExceptionWorkFunctionEdit")).SelectedValue = workFunction;
string unitOfMeasurement = materialsInformationCostHistoryExceptionsInformationGateway.GetUnitOfMeasurement(costId, refId);
((DropDownList)e.Row.FindControl("ddlExceptionUnitOfMeasurementMaterialsEdit")).SelectedValue = unitOfMeasurement;
}
}
