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))); } }
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); } } }