//public ActionResult _Create([DataSourceRequest]DataSourceRequest request, TB_LatestNewsExt model)
        //{
        //    string Msg = "";
        //    try
        //    {
        //        TB_LatestNewsRepository modelRepo = new TB_LatestNewsRepository();
        //        if (modelRepo.Create(model, ref Msg, this) == false)
        //        {
        //            return this.Json(new DataSourceResult { Errors = Msg });
        //        }
        //    }
        //    catch (Exception ex)
        //    {
        //        string error = ErrorHandling.HandleException(ex);
        //        return this.Json(new DataSourceResult { Errors = error });
        //    }
        //    return Json(new[] { model }.ToDataSourceResult(request, ModelState));
        //}
        public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_LatestNewsExt model)
        {
            string Msg = "";
            try
            {
                TB_LatestNewsRepository modelRepo = new TB_LatestNewsRepository();
                if (modelRepo.Delete(model, ref Msg, this) == false)
                {
                    return this.Json(new DataSourceResult { Errors = Msg });
                }
            }
            catch (Exception ex)
            {
                string hostName1 = Dns.GetHostName();
                string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString();
                string PageName = Convert.ToString(Session["PageName"]);
                //string GetUserIPAddress = GetUserIPAddress1();
                using (BaseRepository baseRepo = new BaseRepository())
                {
                    //BizContext BizContext1 = new BizContext();
                    BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress);
                }
                Session["PageName"] = "";
                string error = ErrorHandling.HandleException(ex);
                return this.Json(new DataSourceResult { Errors = error });
            }

            return Json(request);
        }
        public bool Update(TB_LatestNewsExt model, ref string Msg, Controller ctrl)
        {
            bool status = true;

            var obj = db.TB_LatestNews.Where(x => x.ID == model.ID).FirstOrDefault();
            obj.UserID = Convert.ToInt64(model.UserID);
            obj.Title_tr = model.Title_tr;
            obj.Title_en = model.Title_en;
            obj.Title_de = model.Title_de;
            obj.Title_fr = model.Title_fr;
            obj.Title_ru = model.Title_ru;
            obj.Title_ar = model.Title_ar;
            obj.Description_tr = model.Description_tr;
            obj.Description_en = model.Description_en;
            obj.Description_de = model.Description_de;
            obj.Description_fr = model.Description_fr;
            obj.Description_ru = model.Description_ru;
            obj.Description_ar = model.Description_ar;
            obj.PostImage = model.PostImage;
            obj.Travel = model.Travel;
            obj.Active = model.Active;
            obj.Createddate = model.CreatedDate;
            db.SaveChanges();

            return status;
        }
        public List<TB_LatestNewsExt> ReadAll(int TableID)
        {
            List<TB_LatestNewsExt> list = new List<TB_LatestNewsExt>();
            DBEntities entity = new DBEntities();
            var TableIDparam = new SqlParameter("@TableID", TableID);
            var Cultureparam = new SqlParameter("@CultureCode", CultureCode);
            var result = entity.Database.SqlQuery<TB_LatestNews>("B_DisplayTableNew_BizTbl_Table_Sp @TableID,@CultureCode", TableIDparam, Cultureparam).ToList();
            DataTable dt = new DataTable();
            dt.Columns.Add("ID");
            dt.Columns.Add("UserID");
            dt.Columns.Add("Title_tr");
            dt.Columns.Add("Title_en");
            dt.Columns.Add("Title_de");
            dt.Columns.Add("Title_fr");
            dt.Columns.Add("Title_ru");
            dt.Columns.Add("Title_ar");
            dt.Columns.Add("Description_tr");
            dt.Columns.Add("Description_en");
            dt.Columns.Add("Description_de");
            dt.Columns.Add("Description_fr");
            dt.Columns.Add("Description_ru");
            dt.Columns.Add("Description_ar");
            dt.Columns.Add("PostImage");
            dt.Columns.Add("Travel");
            dt.Columns.Add("Active");
            dt.Columns.Add("Createddate");
            foreach (TB_LatestNews dr in result)
            {
                dt.Rows.Add(dr.ID, dr.UserID, dr.Title_tr, dr.Title_en, dr.Title_de, dr.Title_fr, dr.Title_ru, dr.Title_ar,dr.Description_tr,dr.Description_en,dr.Description_de,
                    dr.Description_fr,dr.Description_ru,dr.Description_ar,dr.PostImage,dr.Travel,dr.Active,dr.Createddate);
            }

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    TB_LatestNewsExt model = new TB_LatestNewsExt();
                    model.ID = Convert.ToInt32(dr["ID"]);
                    model.UserID = Convert.ToInt32(dr["UserID"]);
                    model.Title_tr = dr["Title_tr"].ToString();
                    model.Title_en = dr["Title_en"].ToString();
                    model.Title_de = dr["Title_de"].ToString();
                    model.Title_fr = dr["Title_fr"].ToString();
                    model.Title_ru = dr["Title_ru"].ToString();
                    model.Title_ar = dr["Title_ar"].ToString();
                    model.Description_tr = dr["Description_tr"].ToString();
                    model.Description_en = dr["Description_en"].ToString();
                    model.Description_de = dr["Description_de"].ToString();
                    model.Description_fr = dr["Description_fr"].ToString();
                    model.Description_ru = dr["Description_ru"].ToString();
                    model.Description_ar = dr["Description_ar"].ToString();
                    model.PostImage = dr["PostImage"].ToString();
                    model.Travel = dr["Travel"].ToString();
                    model.Active = Convert.ToBoolean(dr["Active"]);
                    model.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
                   // model.OpUserID = Convert.ToInt64(dr["OpUserID"]);
                    list.Add(model);
                }
            }

            return list;
        }
        public TB_LatestNewsExt GetLatestNewsByID(int LatestNewsID)
        {
            DataTable dt = new DataTable();
            SQLCon.Open();
            SqlCommand cmd = new SqlCommand("B_GetLatestNewsByID_TB_LatestNews_SP", SQLCon);
            cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
            cmd.Parameters.AddWithValue("@LatestNewsID", LatestNewsID);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(dt);
            SQLCon.Close();
            TB_LatestNewsExt LatestNewsObj = new TB_LatestNewsExt();
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {

                    LatestNewsObj.ID = Convert.ToInt32(dr["ID"]);
                    LatestNewsObj.UserID = Convert.ToInt32(dr["UserID"]);
                    LatestNewsObj.Title_tr = dr["Title_tr"].ToString();
                    LatestNewsObj.Title_en = dr["Title_en"].ToString();
                    LatestNewsObj.Title_de = dr["Title_de"].ToString();
                    LatestNewsObj.Title_fr = dr["Title_fr"].ToString();
                    LatestNewsObj.Title_ru = dr["Title_ru"].ToString();
                    LatestNewsObj.Title_ar = dr["Title_ar"].ToString();
                    LatestNewsObj.Description_tr = dr["Description_tr"].ToString();
                    LatestNewsObj.Description_en = dr["Description_en"].ToString();
                    LatestNewsObj.Description_de = dr["Description_de"].ToString();
                    LatestNewsObj.Description_fr = dr["Description_fr"].ToString();
                    LatestNewsObj.Description_ru = dr["Description_ru"].ToString();
                    LatestNewsObj.Description_ar = dr["Description_ar"].ToString();
                    LatestNewsObj.PostImage = dr["PostImage"].ToString();
                    //LatestNewsObj.Travel = dr["Travel"].ToString();
                    LatestNewsObj.Active = Convert.ToBoolean(dr["Active"]);
                    LatestNewsObj.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
                    //EmailObj.Operation = dr["Operation"].ToString();
                }
            }

            return LatestNewsObj;
        }
        //public bool Create(TB_LatestNewsExt model, ref string Msg, Controller ctrl)
        //{
        //    bool status = true;
        //    TB_LatestNewsExt obj = new TB_LatestNewsExt();
        //    obj.ID = model.ID;
        //    obj.UserID = model.UserID;
        //    obj.Title_tr = model.Title_tr;
        //    obj.Title_en = model.Title_en;
        //    obj.Title_de = model.Title_de;
        //    obj.Title_fr = model.Title_fr;
        //    obj.Title_ru = model.Title_ru;
        //    obj.Title_ar = model.Title_ar;
        //    obj.Description_tr = model.Description_tr;
        //    obj.Description_en = model.Description_en;
        //    obj.Description_de = model.Description_de;
        //    obj.Description_fr = model.Description_fr;
        //    obj.Description_ru = model.Description_ru;
        //    obj.Description_ar = model.Description_ar;
        //    obj.PostImage = model.PostImage;
        //    obj.Travel = model.Travel;
        //    obj.Active = model.Active;
        //    obj.CreatedDate = DateTime.Now;
        //    //obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
        //    db.TB_LatestNews.Add(obj);
        //    db.SaveChanges();
        //    int id = obj.ID;
        //    return status;
        //}
        public bool Delete(TB_LatestNewsExt model, ref string Msg, Controller ctrl)
        {
            bool status = true;

            var obj = db.TB_LatestNews.Where(x => x.ID == model.ID).FirstOrDefault();
            db.TB_LatestNews.Remove(obj);
            db.SaveChanges();

            return status;
        }