public ValidateResponse CreateNewServiceGroup(servicegroup serviceGroup) { ValidateResponse resposne = new ValidateResponse(); try { using (var context = new FitnessProEntities()) { IMapper iMapper = revMapConfig.CreateMapper(); ServiceGroup eServiceGroup = new ServiceGroup(); iMapper.Map(serviceGroup, eServiceGroup); context.ServiceGroups.Add(eServiceGroup); context.SaveChanges(); resposne.IsSuccess = true; } } catch (Exception ex) { resposne.IsSuccess = false; resposne.ValidationMessages = new List <string> { ex.ToString() }; } return(resposne); }
public List <ServiceGroupViewModel> ServiceGroupList() { List <ServiceGroup> groupList = null; List <ServiceGroupViewModel> vmServicegGroup = null; using (var context = new FitnessProEntities()) { groupList = context.ServiceGroups.ToList(); vmServicegGroup = Utility.Mapper.MappingServiceGroup(groupList); return(vmServicegGroup); }; }
public List <ServiceViewModel> ServiceGroupList() { using (var context = new FitnessProEntities()) { IMapper iMapper = config.CreateMapper(); List <ServiceViewModel> serviceGroup = (from sg in context.ServiceGroups group sg by sg.ServiceGroupId into sgg join s in context.Services on sgg.FirstOrDefault().ServiceGroupId equals s.ServiceGroupId select new ServiceViewModel { ServiceGroupId = sgg.FirstOrDefault().ServiceGroupId, GroupName = sgg.FirstOrDefault().GroupName, ServiceId = s.ServiceId, ServiceName = s.ServiceName }).ToList(); //var result = serviceGroup.GroupBy(x => x.ServiceGroupId); //List<ServiceViewModel> serviceGroup = (from sg in context.ServiceGroups // group sg by sg.GroupName into sgg // join s in context.Services on sgg.FirstOrDefault().ServiceGroupId equals s.ServiceGroupId // select new ServiceGroupList<string, ServiceViewModel> // { // ServiceGroupName = sgg.Key, // }).ToList(); //var result = serviceGroup.GroupBy(x => x.ServiceGroupId); //var test = (from sg in context.ServiceGroups // join s in context.Services on sg.ServiceGroupId equals s.ServiceGroupId // select new ServiceGroupList<string,ServiceViewModel> // { // ServiceGroupName = sg.GroupName, // SeriveList= // }) // .GroupBy(x => x.GroupName) // .ToList(); //List < servicegroup > mServicegroup = iMapper.Map<List<ServiceGroup>, List<ServiceViewModel>>(serviceGroup); // return mServicegroup; return(serviceGroup); } }