protected DistributorSalesman Map(DistributorSalesmanImport distributorSalesmanImport, List<string> mappingvalidationList)
        {
            var exists = Queryable.FirstOrDefault(_context.tblCostCentre, p => p.Cost_Centre_Code == distributorSalesmanImport.Code && p.CostCentreType == (int)CostCentreType.DistributorSalesman);
            Guid id = exists != null ? exists.Id : Guid.NewGuid();

            var distributor =
                Queryable.FirstOrDefault(_context.tblCostCentre, p =>
                    p.Cost_Centre_Code == distributorSalesmanImport.DistributorCode &&
                    p.CostCentreType == (int) CostCentreType.Distributor) ;
            if (distributor == null) { mappingvalidationList.Add(string.Format((string) "Invalid Distributor Code {0}", (object) distributorSalesmanImport.DistributorCode)); }
            var distributorId = distributor != null ? distributor.Id : Guid.Empty;

            var distributorSalesman = new DistributorSalesman(id);
            distributorSalesman.Name = distributorSalesmanImport.Name;
            distributorSalesman.CostCentreCode = distributorSalesmanImport.Code;
            distributorSalesman.CostCentreType = CostCentreType.DistributorSalesman;
            distributorSalesman.ParentCostCentre=new CostCentreRef(){Id = distributorId};
            return distributorSalesman;

        }
        private User MapUser(DistributorSalesmanImport distributorSalesmanImport,List<string> mappingUserValidationList)
        {
            var exists = Queryable.FirstOrDefault(_context.tblUsers, p => p.Code == distributorSalesmanImport.Code);
            Guid id = exists != null ? exists.Id : Guid.NewGuid();

            var costCentre =Queryable.FirstOrDefault(_context.tblCostCentre, p => p.Cost_Centre_Code == distributorSalesmanImport.Code);
            if (costCentre == null) { mappingUserValidationList.Add(string.Format((string) "Invalid DistributorSalesman Code {0}", (object) distributorSalesmanImport.Code)); }

            var distributorSalesmanUser = new User(id);
            distributorSalesmanUser.CostCentre =costCentre!=null?costCentre.Id:Guid.Empty;
            distributorSalesmanUser.Username = distributorSalesmanImport.Name;
            distributorSalesmanUser.FirstName = distributorSalesmanImport.Name;
            distributorSalesmanUser.Code = distributorSalesmanImport.Code;
            distributorSalesmanUser.UserType = UserType.DistributorSalesman;
            distributorSalesmanUser.Password = EncryptorMD5.GetMd5Hash("12345678");
            distributorSalesmanUser.Mobile = distributorSalesmanImport.MobileNumber;

            return distributorSalesmanUser;
        }