//Delete From DB
public void Delete(CommissionableRouteItem CommissionableRouteItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteCommissionableRouteItem_v1(
CommissionableRouteItem.CommissionableRouteItemId,
adminUserGuid,
CommissionableRouteItem.VersionNumber
);
}
public CommissionableRouteItemVM(
CommissionableRouteItem commissionableRouteItem,
//CommissionableRouteGroup commissionableRouteGroup,
PolicyRouting policyRouting,
Supplier supplier,
Product product)
{
CommissionableRouteItem = commissionableRouteItem;
//CommissionableRouteGroup = commissionableRouteGroup;
PolicyRouting = policyRouting;
Product = product;
Supplier = supplier;
}
//Add Data From Linked Tables for Display
public void EditForDisplay(CommissionableRouteItem CommissionableRouteItem)
{
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(CommissionableRouteItem.ProductId);
if (product != null)
{
CommissionableRouteItem.ProductName = product.ProductName;
}
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(CommissionableRouteItem.SupplierCode, CommissionableRouteItem.ProductId);
if (supplier != null)
{
CommissionableRouteItem.SupplierName = supplier.SupplierName;
}
}
//Add to DB
public void Add(CommissionableRouteItem commissionableRouteItem, PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
int? commissionableRouteItemId = new Int32();
db.spDesktopDataAdmin_InsertCommissionableRouteItem_v1(
ref commissionableRouteItemId,
commissionableRouteItem.TravelIndicator,
commissionableRouteItem.ClassOfTravel,
commissionableRouteItem.CommissionAmount,
commissionableRouteItem.CommissionAmountCurrencyCode,
commissionableRouteItem.NegotiatedFareFlag,
commissionableRouteItem.BSPCommission,
commissionableRouteItem.CommissionableTaxCodes,
commissionableRouteItem.CommissionOnTaxes,
commissionableRouteItem.RemarksOrRoute,
commissionableRouteItem.SupplierCode,
commissionableRouteItem.ProductId,
commissionableRouteItem.CommissionableRouteGroupId,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid
);
commissionableRouteItem.CommissionableRouteItemId = (int)commissionableRouteItemId;
}
