public List<TextLocalised> GetDashBoardWidgetText(int wdgId)
        {
            List<TextLocalised> lWidgetTexts = new List<TextLocalised>();
            SqlDataReader oReader;

            try
            {

                using (SqlCommand oComm = new SqlCommand())
                {

                    if (Sqlconn.State == ConnectionState.Closed)
                        Sqlconn.Open();

                    oComm.Connection = Sqlconn;
                    oComm.CommandType = CommandType.StoredProcedure;
                    oComm.CommandText = "DashBoard.GetDashBoardWidgetText";

                    SqlParameter pWdgID = new SqlParameter("@WDGID", SqlDbType.Int);
                    pWdgID.Value = wdgId;
                    oComm.Parameters.Add(pWdgID);

                    oReader = oComm.ExecuteReader();

                    while (oReader.Read())
                    {
                        TextLocalised widgetText = new TextLocalised()
                        {
                            content = oReader["wdg_text_Content"] != DBNull.Value ? oReader["wdg_text_Content"].ToString() : string.Empty,
                            title = oReader["wdg_text_Title"] != DBNull.Value ? oReader["wdg_text_Title"].ToString() : string.Empty,
                            locale = oReader["wdg_text_Locale"] != DBNull.Value ? oReader["wdg_text_Locale"].ToString() : string.Empty
                        };

                        lWidgetTexts.Add(widgetText);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (Sqlconn.State == ConnectionState.Open)
                    Sqlconn.Close();
            }

            return lWidgetTexts;
        }
        public int AddWidgetText(int wdgID, TextLocalised textLocalised)
        {
            int wdgTextID;

            try
            {
                using (SqlCommand oComm = new SqlCommand())
                {

                    if (Sqlconn.State == ConnectionState.Closed)
                        Sqlconn.Open();
                    oComm.Connection = Sqlconn;
                    oComm.CommandType = CommandType.StoredProcedure;
                    oComm.CommandText = "DashBoard.AddWidgetText";

                    SqlParameter pWdgID = new SqlParameter("@WDG_ID", SqlDbType.Int);
                    pWdgID.Value = wdgID;
                    oComm.Parameters.Add(pWdgID);

                    SqlParameter pTitle = new SqlParameter("@WDG_TEXT_TITLE", SqlDbType.NVarChar);
                    pTitle.Value = textLocalised.title;
                    oComm.Parameters.Add(pTitle);

                    SqlParameter pContent = new SqlParameter("@WDG_TEXT_CONTENT", SqlDbType.NText);
                    pContent.Value = textLocalised.content;
                    oComm.Parameters.Add(pContent);

                    SqlParameter pLocale = new SqlParameter("@WDG_TEXT_LOCALE", SqlDbType.NVarChar);
                    pLocale.Value = textLocalised.locale;
                    oComm.Parameters.Add(pLocale);

                    SqlParameter pWDGTextID = new SqlParameter("@WDG_TEXT_ID", SqlDbType.Int);
                    pWDGTextID.Direction = ParameterDirection.Output;
                    oComm.Parameters.Add(pWDGTextID);

                    oComm.ExecuteNonQuery();

                    wdgTextID = (int)pWDGTextID.Value;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (Sqlconn.State == ConnectionState.Open)
                    Sqlconn.Close();
            }

            return wdgTextID;
        }
        public List<TextLocalised> GetDashBoardTexts(int dashboardId)
        {
            List<TextLocalised> lTexts = new List<TextLocalised>();
            SqlDataReader oReader;

            try
            {

                using (SqlCommand oComm = new SqlCommand())
                {

                    if (Sqlconn.State == ConnectionState.Closed)
                        Sqlconn.Open();

                    oComm.Connection = Sqlconn;
                    oComm.CommandType = CommandType.StoredProcedure;
                    oComm.CommandText = "DashBoard.GetDashBoardText";

                    SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int);
                    pDashBoardID.Value = dashboardId;
                    oComm.Parameters.Add(pDashBoardID);

                    oReader = oComm.ExecuteReader();

                    while (oReader.Read())
                    {
                        TextLocalised textsLocalised = new TextLocalised()
                        {
                            title = oReader["dsb_text_Title"] != DBNull.Value ? oReader["dsb_text_Title"].ToString() : string.Empty,
                            locale = oReader["dsb_text_Locale"] != DBNull.Value ? oReader["dsb_text_Locale"].ToString() : string.Empty,
                        };

                        lTexts.Add(textsLocalised);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (Sqlconn.State == ConnectionState.Open)
                    Sqlconn.Close();
            }

            return lTexts;
        }
 public ActionResult AddWidgetText(int wdgID, TextLocalised textLocalised)
 {
     throw new NotImplementedException();
 }