public void TestMethodHomePage_Widget_Table_DTO()
        {
            tblHomePage_Widget tbl_home_page_widget = new tblHomePage_Widget();

            tbl_home_page_widget.Widget_Id     = 21;
            tbl_home_page_widget.User_Id       = "65465sd4fsdfsdfsd";
            tbl_home_page_widget.widget_x      = 0;
            tbl_home_page_widget.widget_y      = 1;
            tbl_home_page_widget.widget_width  = 10;
            tbl_home_page_widget.widget_height = 20;

            HomePage_WidgetDTO dto = HomePage_WidgetDTO_Converter.Convert(tbl_home_page_widget);

            Assert.IsNotNull(dto);

            tbl_home_page_widget = HomePage_WidgetDTO_Converter.Convert(dto);

            Assert.IsNotNull(tbl_home_page_widget);


            IList <tblHomePage_Widget> list_tbl_home_page = new List <tblHomePage_Widget>();

            list_tbl_home_page.Add(tbl_home_page_widget);
            list_tbl_home_page.Add(tbl_home_page_widget);
            list_tbl_home_page.Add(tbl_home_page_widget);
            list_tbl_home_page.Add(tbl_home_page_widget);
            list_tbl_home_page.Add(tbl_home_page_widget);


            IList <HomePage_WidgetDTO> listdto = HomePage_WidgetDTO_Converter.Convert(list_tbl_home_page);

            Assert.IsNotNull(listdto);

            Assert.AreEqual(listdto.Count, 5);
        }
        public void Convert_Dashboard_Widget_Dto_TO_HomePage_Widget_DTO()
        {
            Dashboard_Widget_DTO dashboard_widget_dto = new Dashboard_Widget_DTO(ChartType.Gauge);
            HomePage_WidgetDTO   dto = HomePage_WidgetDTO_Converter.Convert(dashboard_widget_dto);

            Assert.IsNotNull(dto);
        }
 /// <summary>
 /// Add Widget to homepage
 /// </summary>
 /// <param name="home_page_widget_dto"></param>
 public bool Widget_Pin_To_HomePage(int widget_id, string user_id)
 {
     if (Get_Home_Page_By_ID_And_User_ID(widget_id, user_id) == null)
     {
         try
         {
             tblHomePage_Widget tbl_homepage_widget = HomePage_WidgetDTO_Converter.Convert(Get_Dashboard_Widget_By_Widget_ID_For_Home_Page(widget_id));
             tbl_homepage_widget.User_Id = user_id;
             _dbcontext.tblHomePage_Widget.Add(tbl_homepage_widget);
             _dbcontext.SaveChanges();
             return(true);
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
     else
     {
         throw new Exception(Resources.widget_all_ready_added);
     }
 }
        public HomePage_WidgetDTO Update(HomePage_WidgetDTO home_page_widget_dto)
        {
            tblHomePage_Widget tbl_home_page_update = Get_Home_Page_By_ID_And_User_ID(home_page_widget_dto.Widget_Id, home_page_widget_dto.User_Id);

            try
            {
                if (tbl_home_page_update != null)
                {
                    tbl_home_page_update = HomePage_WidgetDTO_Converter.Convert(home_page_widget_dto);
                    _dbcontext.tblHomePage_Widget.Attach(tbl_home_page_update);
                    _dbcontext.Entry(tbl_home_page_update).State = EntityState.Modified;

                    _dbcontext.SaveChanges();
                    return(home_page_widget_dto);
                }
                else
                {
                    throw new ArgumentNullException("Home Page widget not forund");
                }
            }
            catch { throw; }
        }
        private HomePage_WidgetDTO Get_Dashboard_Widget_By_Widget_ID_For_Home_Page(int widget_id)
        {
            Dashboard_Widget_DTO dashboard_widget_dto = _dashboadRepository.Get_Dashboard_Widget_By_Id(widget_id);

            return(HomePage_WidgetDTO_Converter.Convert(dashboard_widget_dto));
        }
        public List <HomePage_WidgetDTO> Get_Widgets_For_Home_Page(string user_id)
        {
            IEnumerable <tblHomePage_Widget> tbl_homepage_widget = _dbcontext.tblHomePage_Widget.Where(homepage => homepage.User_Id == user_id);

            return(HomePage_WidgetDTO_Converter.Convert(tbl_homepage_widget));
        }
        public HomePage_WidgetDTO Get_Widget_For_Home_Page(int widget_id, string user_id)
        {
            tblHomePage_Widget tbl_homepage_widget = _dbcontext.tblHomePage_Widget.SingleOrDefault(homepage => homepage.Widget_Id == widget_id && homepage.User_Id == user_id);

            return(HomePage_WidgetDTO_Converter.Convert(tbl_homepage_widget));
        }