public string addNewFlyerBasicData(OFFER_FLYER flyer, string action)
        {
            ReturnObject <int> flyerObj = null;

            try
            {
                FlyersHandler handler = new FlyersHandler();

                var flyerID = handler.AddNewFlyer(flyer, action);
                if (flyerID != -1)
                {
                    flyerObj = new ReturnObject <int>(ErrorConstants.SUCCESS, flyerID);
                }
                else
                {
                    return(JsonConvert.SerializeObject(new ReturnObject <string>(ErrorConstants.ERROR_FAILED_TO_ADD_FLYER, ErrorConstants.ERROR_FAILED_TO_ADD_FLYER_MSG)));
                }

                return(JsonConvert.SerializeObject(flyerObj));
            }
            catch (Exception ex)
            {
                return(JsonConvert.SerializeObject(new ReturnObject <string>(ErrorConstants.ERROR_EXCEPTION, ex.Message)));
            }
        }
Exemplo n.º 2
0
        public int AddNewFlyer(OFFER_FLYER flyer, string action)
        {
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                if (action == "insert")
                {
                    //context.TIME_FRAMEs.InsertOnSubmit(frame);

                    //context.SubmitChanges();

                    //flyer.FRAME_ID = frame.FRAME_ID;

                    flyer.FLYER_APPROVED = null;

                    context.OFFER_FLYERs.InsertOnSubmit(flyer);

                    context.SubmitChanges();

                    return(flyer.FLYER_ID);
                }
                else if (action == "update")
                {
                    //TIME_FRAME objFrame = context.TIME_FRAMEs.Single(x => x.FRAME_ID == frame.FRAME_ID);
                    //objFrame.FRAME_NAME_EN = frame.FRAME_NAME_EN;
                    //objFrame.FRAME_NAME_AR = frame.FRAME_NAME_AR;
                    //objFrame.FRAME_TYPE_ID = frame.FRAME_TYPE_ID;
                    //objFrame.FRAME_DATE_TO = frame.FRAME_DATE_TO;
                    //objFrame.FRAME_DATE_FROM = frame.FRAME_DATE_FROM;

                    //context.SubmitChanges();

                    OFFER_FLYER objFlyer = context.OFFER_FLYERs.Single(x => x.FLYER_ID == flyer.FLYER_ID);
                    objFlyer.FLYER_NAME_AR = flyer.FLYER_NAME_AR;
                    objFlyer.FLYER_NAME_EN = flyer.FLYER_NAME_EN;
                    objFlyer.OFFER_TYPE_ID = flyer.OFFER_TYPE_ID;
                    //objFlyer.FRAME_ID = frame.FRAME_ID;
                    objFlyer.FLYER_IMAGE_URL = flyer.FLYER_IMAGE_URL;
                    objFlyer.PROVIDER_ID     = flyer.PROVIDER_ID;
                    objFlyer.DATE_FROM       = flyer.DATE_FROM;
                    objFlyer.DATE_TO         = flyer.DATE_TO;

                    context.SubmitChanges();

                    return(flyer.FLYER_ID);
                }
                else
                {
                    return(-1);
                }
            }
        }