public static bool CreateDesign(DesignDummyViewModel dummy, int page_id) { using (ClientDataContext context = new ClientDataContext()) { if (dummy.ad_id != 0) { //var FolioEntity = CreateDummyFolio(); //var FolioEntity = context.tbl_dummy_folio; var PageEntity = context.tbl_dummy_page.Where(x => x.dummy_page_id == page_id).FirstOrDefault(); // PageEntity.tbl_dummy_folio = FolioEntity; var PagePlacementEntity = dummy.ToEntity(); PagePlacementEntity.tbl_dummy_page = PageEntity; //Unity.Work.Repository<tbl_dummy_page_placement>().Insert(PagePlacementEntity); context.tbl_dummy_page_placement.Add(PagePlacementEntity); context.SaveChanges(); ////remove existing item //var existingItem = Unity.Work.Repository<tbl_dummy_page_placement>().GetAll().Where(x => x.dummy_page_id == page_id && x.media_page_number_id == dummy.ad_id).FirstOrDefault(); //if(existingItem!= null) //{ // Unity.Work.Repository<tbl_dummy_page_placement>().Delete(existingItem); //} // Unity.Work.Save(); } return(true); } }
public static tbl_dummy_page_placement CreateDummyPagePlacement(DesignDummyViewModel dummy) { return(new tbl_dummy_page_placement { x_position_start = dummy.xStart, y_position_start = dummy.yStart, media_page_number_id = dummy.ad_id }); }
//public static DummyData GetDesignDataByPageId(int page_id) //{ // using (ClientDataContext context = new ClientDataContext()) // { // var dummyData = new DummyData(); // var PageEntity = context.tbl_dummy_page.Where(x => x.dummy_page_id == page_id).FirstOrDefault(); // dummyData.page_id = page_id; // if (PageEntity != null) // { // dummyData.PageName = PageEntity.page_name; // dummyData.page_number = PageEntity.page_number.GetValueOrDefault(); // var placements = context.tbl_dummy_page_placement.ToList().Where(x => x.dummy_page_id == page_id).Select(pl => new DesignDummyViewModel // { // ad_id = pl.media_page_number_id, // xStart = pl.x_position_start, // yStart = pl.y_position_start, // placed_ad = GetAdViewById(pl.media_page_number_id) // }).ToList(); // dummyData.dummy = placements; // //var uniquAds = placements.Select(x => x.ad_id).Distinct(); // } // return dummyData; // } //} public static bool CreatePages(DesignDummyViewModel dummy, int page_id) { return(true); }