/// <summary>
/// Update size (direct to DB)
/// </summary>
/// <param name="originalSize">originalsize</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalDeleted">originalDeleted</param>
///
/// <param name="newSize">newSize</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newDeleted">newDeleted</param>
public void UpdateDirect(string originalSize, int originalCompanyId, bool originalDeleted, string newSize, int newCompanyId, bool newDeleted)
{
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway(null);
workPointRepairsRepairPointSizeGateway.Update(originalSize, originalCompanyId, originalDeleted, newSize, newCompanyId, newDeleted);
}
/// <summary>
/// Undelete size
/// </summary>
/// <param name="size_">size_</param>
/// <param name="companyId">companyId</param>
public void UnDeleteDirect(string size_, int companyId)
{
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway(null);
workPointRepairsRepairPointSizeGateway.UnDelete(size_, companyId);
}
protected void cvSize_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway();
if (workPointRepairsRepairPointSizeGateway.IsUsedInPointRepair(args.Value.Trim(), Int32.Parse(hdfCompanyId.Value)))
{
args.IsValid = false;
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Insert material
/// </summary>
/// <param name="size_">size_</param>
/// <param name="companyId">companyId</param>
/// <param name="deleted">deleted</param>
public void InsertDirect(string size_, int companyId, bool deleted)
{
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway(null);
workPointRepairsRepairPointSizeGateway.Insert(size_, companyId, deleted);
}
/// <summary>
/// Save all size to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
SizeInformationTDS sizeInformationChanges = (SizeInformationTDS)Data.GetChanges();
if (sizeInformationChanges != null)
{
if (sizeInformationChanges.SizeInformation.Rows.Count > 0)
{
SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationChanges);
foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationChanges.SizeInformation)
{
// Insert new size
if ((!row.Deleted) && (!row.InDatabase))
{
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway();
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSizeGateway.LoadAllBySize_(row.Size_, row.COMPANY_ID);
if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0)
{
workPointRepairsRepairPointSize.InsertDirect(row.Size_, row.COMPANY_ID, row.Deleted);
}
else
{
workPointRepairsRepairPointSize.UnDeleteDirect(row.Size_, row.COMPANY_ID);
}
}
// Update size
if ((!row.Deleted) && (row.InDatabase))
{
string originalSize_ = row.NewSize_;
string newSize_ = row.Size_;
int originalCompanyId = companyId;
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway();
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSizeGateway.LoadAllBySize_(newSize_, companyId);
if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0)
{
workPointRepairsRepairPointSize.InsertDirect(newSize_, originalCompanyId, false);
}
else
{
workPointRepairsRepairPointSize.UnDeleteDirect(newSize_, originalCompanyId);
}
if (workPointRepairsRepairPointSizeGateway.IsUsedInPointRepair(originalSize_, companyId))
{
WorkPointRepairsRepairGateway workPointRepairsRepairGateway = new WorkPointRepairsRepairGateway(null);
workPointRepairsRepairGateway.UpdateSize(originalSize_, companyId, newSize_, companyId);
}
workPointRepairsRepairPointSize.DeleteDirect(originalSize_, companyId);
}
// Delete size
if ((row.Deleted) && (row.InDatabase))
{
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSize.DeleteDirect(row.Size_, row.COMPANY_ID);
}
}
}
}
}
