public Distributor MapDistributor(tblCostCentre tblCC) { if (tblCC == null) return null; var distributor = new Distributor(tblCC.Id) {CostCentreType = CostCentreType.Distributor}; if (tblCC.tblRegion != null) distributor.Region = tblCC.tblRegion.Map(); if (tblCC.Tier_Id != null) distributor.ProductPricingTier = _ctx.tblPricingTier.FirstOrDefault(n => n.id == tblCC.Tier_Id).Map(); distributor.CostCentreCode = tblCC.Cost_Centre_Code; if (tblCC.PaybillNumber != null) distributor.PaybillNumber = tblCC.PaybillNumber; if (tblCC.MerchantNumber != null) distributor.MerchantNumber = tblCC.MerchantNumber; return distributor; }
private OutletDTO Map(tblCostCentre tbl) { var dto = new OutletDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, CostCentreCode = tbl.Cost_Centre_Code, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, RouteMasterId = tbl.RouteId ?? Guid.Empty, OutletCategoryMasterId = tbl.Outlet_Category_Id ?? Guid.Empty, OutletTypeMasterId = tbl.Outlet_Type_Id ?? Guid.Empty, DiscountGroupMasterId = tbl.Outlet_DiscountGroupId ?? Guid.Empty, OutletProductPricingTierMasterId = tbl.Tier_Id ?? Guid.Empty, VatClassMasterId = tbl.VATClass_Id ?? Guid.Empty, Latitude = tbl.StandardWH_Latitude, Longitude = tbl.StandardWH_Longtitude, IsApproved = tbl.IM_Status == (int)EntityStatus.Active, ShippingAddresses = new List<ShipToAddressDTO>(), SpecialPricingTierMasterId = tbl.SpecialPricingTierId ?? Guid.Empty, }; foreach (var item in tbl.tblShipToAddress.Where(n => n.IM_Status == (int)EntityStatus.Active)) { var addressitem = new ShipToAddressDTO { OutletId = dto.MasterId, MasterId = item.Id, DateCreated = item.IM_DateCreated, DateLastUpdated = item.IM_DateLastUpdated, StatusId = item.IM_Status, Name = item.Name, Code = item.Code, Description = item.Description, PostalAddress = item.PostalAddress, PhysicalAddress = item.PhysicalAddress, Longitude = item.Longitude ?? 0, Latitude = item.Latitude ?? 0 }; dto.ShippingAddresses.Add(addressitem); } return dto; }
private StoreDTO Map(tblCostCentre tbl) { var dto = new StoreDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, CostCentreCode = tbl.Cost_Centre_Code, Name = tbl.Name, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, Longitude = tbl.StandardWH_Longtitude, Latitude = tbl.StandardWH_Latitude, VatRegistrationNo = tbl.StandardWH_VatRegistrationNo }; return dto; }
private DistributorPendingDispatchWarehouseDTO Map(tblCostCentre tbl) { var dto = new DistributorPendingDispatchWarehouseDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, CostCentreCode = tbl.Cost_Centre_Code, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, VatRegistrationNo = tbl.StandardWH_VatRegistrationNo, Longitude = tbl.StandardWH_Longtitude, Latitude = tbl.StandardWH_Latitude }; return dto; }
private DistributorSalesmanDTO Map(tblCostCentre tbl) { var dto = new DistributorSalesmanDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, CostCentreCode = tbl.Cost_Centre_Code, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, RouteMasterId = tbl.RouteId ?? Guid.Empty, VatRegistrationNo = tbl.StandardWH_VatRegistrationNo, Latitude = tbl.StandardWH_Latitude, Longitude = tbl.StandardWH_Longtitude, TypeId = tbl.CostCentreType2, }; return dto; }
private CommoditySupplierDTO Map(tblCostCentre tbl) { var dto = new CommoditySupplierDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, CostCentreCode = tbl.Cost_Centre_Code, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, CommoditySupplierTypeId = tbl.CostCentreType2, JoinDate = tbl.JoinDate ?? new DateTime(), AccountNo = tbl.AccountNumber, PinNo = tbl.Revenue_PIN, BankId = tbl.BankId.HasValue? tbl.BankId.Value:Guid.Empty, BankBranchId = tbl.BankBranchId.HasValue? tbl.BankBranchId.Value:Guid.Empty, AccountName=tbl.AccountName }; return dto; }
private ImportEntity Map(tblCostCentre item) { var result = new ImportEntity {MasterDataCollective = MasterDataCollective.Outlet.ToString()}; result.Fields[0] = string.IsNullOrEmpty(item.Cost_Centre_Code)?"":item.Cost_Centre_Code.Trim(); result.Fields[1] =string.IsNullOrEmpty(item.Name)?"":item.Name.Trim(); result.Fields[2] = item.IM_Status == 1 ? true.ToString() : false.ToString(); return result; }
/// <summary> /// Deprecated Method for adding a new object to the tblCostCentre EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotblCostCentre(tblCostCentre tblCostCentre) { base.AddObject("tblCostCentre", tblCostCentre); }
/// <summary> /// Create a new tblCostCentre object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param> /// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param> /// <param name="iM_Status">Initial value of the IM_Status property.</param> /// <param name="costCentreType2">Initial value of the CostCentreType2 property.</param> public static tblCostCentre CreatetblCostCentre(global::System.Guid id, global::System.String name, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status, global::System.Int32 costCentreType2) { tblCostCentre tblCostCentre = new tblCostCentre(); tblCostCentre.Id = id; tblCostCentre.Name = name; tblCostCentre.IM_DateCreated = iM_DateCreated; tblCostCentre.IM_DateLastUpdated = iM_DateLastUpdated; tblCostCentre.IM_Status = iM_Status; tblCostCentre.CostCentreType2 = costCentreType2; return tblCostCentre; }
private DistributorDTO Map(tblCostCentre tbl) { var dto = new DistributorDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, CostCentreCode = tbl.Cost_Centre_Code, ParentCostCentreId = tbl.ParentCostCentreId ?? Guid.Empty, CostCentreTypeId = tbl.CostCentreType ?? 0, ProducerId = tbl.ParentCostCentreId ?? Guid.Empty, Owner = tbl.Distributor_Owner, PIN = tbl.Distributor_PIN, AccountNo = tbl.Cost_Centre_Code, RegionMasterId = tbl.Distributor_RegionId ?? Guid.Empty, ASMUserMasterId = tbl.Distributor_ASM_Id, SalesRepUserMasterId = tbl.SalesRep_Id, SurveyorUserMasterId = tbl.Surveyor_Id, ProductPricingTierMasterId = tbl.Tier_Id ?? Guid.Empty, PaybillNumber = tbl.PaybillNumber, MerchantNumber = tbl.MerchantNumber }; var asm = _context.tblUsers.FirstOrDefault(n => n.Id == dto.ASMUserMasterId); var salesRep = _context.tblUsers.FirstOrDefault(n => n.Id == dto.SalesRepUserMasterId); var surveyor = _context.tblUsers.FirstOrDefault(n => n.Id == dto.SurveyorUserMasterId); if (salesRep != null) { dto.SalesRepDTO = new UserDTO { MasterId = salesRep.Id, DateCreated = salesRep.IM_DateCreated, DateLastUpdated = salesRep.IM_DateLastUpdated ?? DateTime.Now, StatusId = salesRep.IM_Status, Username = salesRep.UserName, CostCentre = salesRep.CostCenterId, Password = salesRep.Password, PIN = salesRep.PIN, UserTypeId = salesRep.UserType, Mobile = salesRep.Mobile, GroupMasterId = salesRep.GroupId ?? Guid.Empty, TillNumber = salesRep.TillNumber }; } if (asm != null) { dto.ASMDTO = new UserDTO { MasterId = asm.Id, DateCreated = asm.IM_DateCreated, DateLastUpdated = asm.IM_DateLastUpdated ?? DateTime.Now, StatusId = asm.IM_Status, Username = asm.UserName, CostCentre = asm.CostCenterId, Password = asm.Password, PIN = asm.PIN, UserTypeId = asm.UserType, Mobile = asm.Mobile, GroupMasterId = asm.GroupId ?? Guid.Empty, TillNumber = asm.TillNumber }; } if (surveyor != null) { dto.SurveyorDTO = new UserDTO { MasterId = surveyor.Id, DateCreated = surveyor.IM_DateCreated, DateLastUpdated = surveyor.IM_DateLastUpdated ?? DateTime.Now, StatusId = surveyor.IM_Status, Username = surveyor.UserName, CostCentre = surveyor.CostCenterId, Password = surveyor.Password, PIN = surveyor.PIN, UserTypeId = surveyor.UserType, Mobile = surveyor.Mobile, GroupMasterId = surveyor.GroupId ?? Guid.Empty, TillNumber = surveyor.TillNumber }; } return dto; }