コード例 #1
0
        public static void Update(EstimateBO estimateToUpdate)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateHeader> repo = new GenericRepository <EstimateHeader>(context);

            var config   = new MapperConfiguration(cfg => cfg.CreateMap <EstimateBO, EstimateHeader>());
            var mapper   = config.CreateMapper();
            var estimate = mapper.Map <EstimateHeader>(estimateToUpdate);

            //var estimate = new EstimateHeader
            //{
            //    AAC_PER = estimateToUpdate.AAC_PER,
            //    Agency = estimateToUpdate.Agency,
            //    BrandID = estimateToUpdate.BrandID,
            //    Campaign = estimateToUpdate.Campaign,
            //    ClientID = estimateToUpdate.ClientID,
            //    EST_Date = estimateToUpdate.EST_Date,
            //    EST_ID = estimateToUpdate.EST_ID,
            //    EST_NO = estimateToUpdate.EST_NO,
            //    Gross_Cost = estimateToUpdate.Gross_Cost,
            //    Net_Cost = estimateToUpdate.Net_Cost,
            //    PeriodFrom = estimateToUpdate.PeriodFrom,
            //    PeriodTo = estimateToUpdate.PeriodTo,
            //    PO_Date = estimateToUpdate.PO_Date,
            //    PO_NO = estimateToUpdate.PO_NO,
            //    SAC_PER = estimateToUpdate.SAC_PER,
            //    Status = estimateToUpdate.Status

            //};
            repo.Update(estimate);

            repo.Save();
        }
コード例 #2
0
        public static EstimateBO GetEstimateById(int id)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateHeader> repo = new GenericRepository <EstimateHeader>(context);
            var item = repo.GetById(id);

            var config   = new MapperConfiguration(cfg => cfg.CreateMap <EstimateHeader, EstimateBO>());
            var mapper   = config.CreateMapper();
            var estimate = mapper.Map <EstimateBO>(item);

            //var estimate = new EstimateBO
            //{
            //    AAC_PER = item.AAC_PER,
            //    Agency = item.Agency,
            //    BrandID = item.BrandID,
            //    Campaign = item.Campaign,
            //    ClientID = item.ClientID,
            //    EST_Date = item.EST_Date,
            //    EST_ID = item.EST_ID,
            //    EST_NO = item.EST_NO,
            //    Gross_Cost = item.Gross_Cost,
            //    Net_Cost = item.Net_Cost,
            //    PeriodFrom = item.PeriodFrom,
            //    PeriodTo = item.PeriodTo,
            //    PO_Date = item.PO_Date,
            //    PO_NO = item.PO_NO,
            //    SAC_PER = item.SAC_PER,
            //    Status = item.Status
            //};
            return(estimate);
        }
コード例 #3
0
        public static void DeleteEstimates(List <int> ids)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateHeader> repo = new GenericRepository <EstimateHeader>(context);

            foreach (var id in ids)
            {
                repo.Delete(id);
            }

            repo.Save();
        }
コード例 #4
0
        public static ScheduleBO GetScheduleById(int id)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateScheduled> repo = new GenericRepository <EstimateScheduled>(context);
            var item = repo.GetById(id);

            var config    = new MapperConfiguration(cfg => cfg.CreateMap <EstimateScheduled, ScheduleBO>());
            var mapper    = config.CreateMapper();
            var schedules = mapper.Map <ScheduleBO>(item);

            return(schedules);
        }
コード例 #5
0
        public static List <ScheduleBO> GetAllSchedules()
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateScheduled> repo = new GenericRepository <EstimateScheduled>(context);
            var results = repo.GetAll();

            var config    = new MapperConfiguration(cfg => cfg.CreateMap <EstimateScheduled, ScheduleBO>());
            var mapper    = config.CreateMapper();
            var schedules = mapper.Map <List <ScheduleBO> >(results);

            return(schedules);
        }
コード例 #6
0
        public static object GetAllSchedulesForEdition(int id)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateScheduled> repo = new GenericRepository <EstimateScheduled>(context);
            var results = repo.GetAllWhere(p => p.EST_EditionID == id);

            var config    = new MapperConfiguration(cfg => cfg.CreateMap <EstimateScheduled, ScheduleBO>());
            var mapper    = config.CreateMapper();
            var schedules = mapper.Map <List <ScheduleBO> >(results);

            return(schedules);
        }
コード例 #7
0
        public static PublicationBO GetPublicationById(int id)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimatePublication> repo = new GenericRepository <EstimatePublication>(context);
            var item = repo.GetById(id);

            var config      = new MapperConfiguration(cfg => cfg.CreateMap <EstimatePublication, PublicationBO>());
            var mapper      = config.CreateMapper();
            var publication = mapper.Map <PublicationBO>(item);

            return(publication);
        }
コード例 #8
0
        public static object GetAllPublicationsForEstimate(int id)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimatePublication> repo = new GenericRepository <EstimatePublication>(context);
            var results = repo.GetAllWhere(p => p.EST_ID == id);

            var config       = new MapperConfiguration(cfg => cfg.CreateMap <EstimatePublication, PublicationBO>());
            var mapper       = config.CreateMapper();
            var publications = mapper.Map <List <PublicationBO> >(results);

            return(publications);
        }
コード例 #9
0
        public static List <PublicationBO> GetAllPublications()
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimatePublication> repo = new GenericRepository <EstimatePublication>(context);
            var results = repo.GetAll();

            var config       = new MapperConfiguration(cfg => cfg.CreateMap <EstimatePublication, PublicationBO>());
            var mapper       = config.CreateMapper();
            var publications = mapper.Map <List <PublicationBO> >(results);

            return(publications);
        }
コード例 #10
0
        public static List <ClientBO> GetClients()
        {
            EstimateDBEntities context            = new EstimateDBEntities();
            GenericRepository <ClientMaster> repo = new GenericRepository <ClientMaster>(context);

            var results = repo.GetAll();

            var config  = new MapperConfiguration(cfg => cfg.CreateMap <ClientMaster, ClientBO>());
            var mapper  = config.CreateMapper();
            var clients = mapper.Map <List <ClientBO> >(results);

            return(clients);
        }
コード例 #11
0
        public static object GetBrands()
        {
            EstimateDBEntities context           = new EstimateDBEntities();
            GenericRepository <BrandMaster> repo = new GenericRepository <BrandMaster>(context);

            var results = repo.GetAll();

            var config = new MapperConfiguration(cfg => cfg.CreateMap <BrandMaster, BrandBO>());
            var mapper = config.CreateMapper();
            var brands = mapper.Map <List <BrandBO> >(results);

            return(brands);
        }
コード例 #12
0
        public static void Update(ScheduleBO schToUpdate)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateScheduled> repo = new GenericRepository <EstimateScheduled>(context);

            var config   = new MapperConfiguration(cfg => cfg.CreateMap <ScheduleBO, EstimateScheduled>());
            var mapper   = config.CreateMapper();
            var schedule = mapper.Map <EstimateScheduled>(schToUpdate);

            repo.Update(schedule);

            repo.Save();
        }
コード例 #13
0
        public static void Update(PublicationBO pubToUpdate)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimatePublication> repo = new GenericRepository <EstimatePublication>(context);

            var config      = new MapperConfiguration(cfg => cfg.CreateMap <PublicationBO, EstimatePublication>());
            var mapper      = config.CreateMapper();
            var publication = mapper.Map <EstimatePublication>(pubToUpdate);

            repo.Update(publication);

            repo.Save();
        }
コード例 #14
0
        public static void Save(EditionBO editionToAdd)
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateEdition> repo = new GenericRepository <EstimateEdition>(context);

            var config  = new MapperConfiguration(cfg => cfg.CreateMap <EditionBO, EstimateEdition>());
            var mapper  = config.CreateMapper();
            var edition = mapper.Map <EstimateEdition>(editionToAdd);

            repo.Insert(edition);

            repo.Save();
        }
コード例 #15
0
        public static List <EstimateBO> GetAllEstimates()
        {
            EstimateDBEntities context = new EstimateDBEntities();
            GenericRepository <EstimateHeader> repo = new GenericRepository <EstimateHeader>(context);
            var results = repo.GetAll();

            //List<EstimateBO> estimates = new List<EstimateBO>();

            var config    = new MapperConfiguration(cfg => cfg.CreateMap <EstimateHeader, EstimateBO>());
            var mapper    = config.CreateMapper();
            var estimates = mapper.Map <List <EstimateBO> >(results);

            //foreach (var item in results)
            //{
            //    var estimate = new EstimateBO
            //    {
            //        AAC_PER = item.AAC_PER,
            //        Agency = item.Agency,
            //        BrandID = item.BrandID,
            //        Campaign = item.Campaign,
            //        ClientID = item.ClientID,
            //        EST_Date = item.EST_Date,
            //        EST_ID = item.EST_ID,
            //        EST_NO = item.EST_NO,
            //        Gross_Cost = item.Gross_Cost,
            //        Net_Cost = item.Net_Cost,
            //        PeriodFrom = item.PeriodFrom,
            //        PeriodTo = item.PeriodTo,
            //        PO_Date = item.PO_Date,
            //        PO_NO = item.PO_NO,
            //        SAC_PER = item.SAC_PER,
            //        Status = item.Status
            //    };
            //    estimates.Add(estimate);
            //}
            return(estimates);
        }
コード例 #16
0
 public GenericRepository(EstimateDBEntities context)
 {
     this.Context = context;
     this.DbSet   = context.Set <T>();
 }