/// <summary>
/// SaveForEdit
/// </summary>
public void SaveForEdit()
{
foreach (WorkViewTDS.WorkViewSortTempRow rowViewSort in (WorkViewTDS.WorkViewSortTempDataTable)Data.Tables["WorkViewSortTemp"])
{
WorkViewSort workViewSort = new WorkViewSort(null);
if (!rowViewSort.Deleted && !rowViewSort.InDatabase && rowViewSort.Selected)
{
workViewSort.InsertDirect(rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID, rowViewSort.Order_, rowViewSort.Deleted);
}
if (!rowViewSort.Deleted && rowViewSort.InDatabase && rowViewSort.Selected)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway();
workViewSortGateway.LoadAllByViewIdWorkTypeSortId(rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID);
int originalViewId = rowViewSort.ViewID;
string originalWorkType = rowViewSort.WorkType;
int originalCompanyId = rowViewSort.COMPANY_ID;
int originalSortId = rowViewSort.SortID;
int originalOrder = workViewSortGateway.GetOrder(rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID);
bool originalDeleted = workViewSortGateway.GetDeleted(rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID);
workViewSort.UpdateDirect(originalViewId, originalWorkType, originalCompanyId, originalSortId, originalOrder, originalDeleted, rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID, rowViewSort.Order_, rowViewSort.Deleted);
}
if (rowViewSort.Deleted && rowViewSort.InDatabase && !rowViewSort.Selected)
{
workViewSort.DeleteDirectForEditView(rowViewSort.ViewID, rowViewSort.WorkType, rowViewSort.COMPANY_ID, rowViewSort.SortID);
}
}
}
/// <summary>
/// InsertDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="sortId">sortId</param>
/// <param name="order">order</param>
/// <param name="deleted">deleted</param>
public void InsertDirect(int viewId, string workType, int companyId, int sortId, int order, bool deleted)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(null);
workViewSortGateway.Insert(viewId, workType, companyId, sortId, order, deleted);
}
/// <summary>
/// ProcessForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void ProcessForEdit(int viewId, string workType, int companyId)
{
foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTRow rowViewSort in (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)Data.Tables["LFS_WORK_TYPE_VIEW_SORT"])
{
WorkViewSort workViewSort = new WorkViewSort();
workViewSort.LoadAllByViewIdWorkTypeSortId(viewId, workType, companyId, rowViewSort.SortID);
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(workViewSort.Data);
if (workViewSort.ExistsByViewIDWorkTypeCompanyIdSortId(viewId, workType, companyId, rowViewSort.SortID))
{
if (rowViewSort.Selected)
{
Insert(viewId, workType, companyId, rowViewSort.SortID, rowViewSort.Order_, true, true, false);
}
else
{
// delete
Insert(viewId, workType, companyId, rowViewSort.SortID, 0, false, true, true);
}
}
else
{
if (rowViewSort.Selected)
{
Insert(viewId, workType, companyId, rowViewSort.SortID, rowViewSort.Order_, true, false, false);
}
}
}
}
/// <summary>
/// DeleteDirectForEditView
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="sortId">sortId</param>
public void DeleteDirectForEditView(int viewId, string workType, int companyId, int sortId)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(null);
workViewSortGateway.DeleteForEditView(viewId, workType, companyId, sortId);
}
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int viewId, int companyId)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(null);
workViewSortGateway.Delete(viewId, companyId);
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalViewId">originalViewId</param>
/// <param name="originalWorkType">originalWorkType</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalSortId">originalSortId</param>
/// <param name="originalOrder">originalOrder</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="newViewId">newViewId</param>
/// <param name="newWorkType">newWorkType</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newSortId">newSortId</param>
/// <param name="newOrder">newOrder</param>
/// <param name="newDeleted">newDeleted</param>
public void UpdateDirect(int originalViewId, string originalWorkType, int originalCompanyId, int originalSortId, int originalOrder, bool originalDeleted, int newViewId, string newWorkType, int newCompanyId, int newSortId, int newOrder, bool newDeleted)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(null);
workViewSortGateway.Update(originalViewId, originalWorkType, originalCompanyId, originalSortId, originalOrder, originalDeleted, newViewId, newWorkType, newCompanyId, newSortId, newOrder, newDeleted);
}
/// <summary>
/// LoadByViewIdWorkTypeSortId
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="sortId">sortId</param>
public void LoadByViewIdWorkTypeSortId(int viewId,string workType, int companyId, int sortId)
{
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(Data);
workViewSortGateway.LoadByViewIdWorkTypeSortId(viewId, workType, companyId, sortId);
}
/// <summary>
/// UpdateForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void UpdateForEdit(int viewId, string workType, int companyId)
{
foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTRow row in (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)Table)
{
if ((row.WorkType == workType) && (row.COMPANY_ID == companyId))
{
WorkViewSort workViewSort = new WorkViewSort();
workViewSort.LoadByViewIdWorkTypeSortId(viewId, workType, companyId, row.SortID);
WorkViewSortGateway workViewSortGateway = new WorkViewSortGateway(workViewSort.Data);
if (workViewSort.ExistsByViewIDWorkTypeCompanyIdSortId(viewId, workType, companyId, row.SortID))
{
row.Selected = true;
row.Order_ = workViewSortGateway.GetOrder(viewId, workType, companyId, row.SortID);
}
else
{
row.Selected = false;
row.SetOrder_Null();
}
}
}
}