/// <summary> /// This methods check in database if tag exist, then returns tag Nid /// else add tag to database and return Nid of Newly created tag /// </summary> /// <param name="Tag">Input Tag name</param> /// <returns>Tag NId</returns> public int CreateAndGetTagNid(string Tag) { CMSHelper ObjCMSHelper = new CMSHelper(); string ResultNid = string.Empty; int RetVal = 0; string DBConnectionStatusMessage = string.Empty; List<System.Data.Common.DbParameter> DbParams = null; DIConnection ObjDIConnection = null; int MaxTagId = -1; try { // Call method to get connection object ObjDIConnection = ObjCMSHelper.GetConnectionObject(out DBConnectionStatusMessage); // Check if connection object is not null if (ObjDIConnection == null) { RetVal = -1; return RetVal; } // Innitilze DbParams object DbParams = new List<System.Data.Common.DbParameter>(); // create tag parameter System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter(); Param1.ParameterName = "@Tags"; Param1.DbType = DbType.String; Param1.Value = Tag; DbParams.Add(Param1); // Execute stored procedure to get tag Nid MaxTagId = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_CreateAndGetTagNid", CommandType.StoredProcedure, DbParams)); if (MaxTagId > 0) { RetVal = MaxTagId; } } catch (Exception Ex) { RetVal = -1; Global.CreateExceptionString(Ex, null); } finally { DbParams = null; ObjDIConnection = null; } return RetVal; }
public bool DeleteTagsMappingsByTagId(int Tag) { CMSHelper ObjCMSHelper = new CMSHelper(); string ResultNid = string.Empty; bool RetVal = false; List<System.Data.Common.DbParameter> DbParams = null; DIConnection ObjDIConnection = null; int RetDelTagId = -1; try { // Call method to get connection object ObjDIConnection = ObjCMSHelper.GetConnectionObject(); // Check if connection object is not null if (ObjDIConnection == null) { RetVal = false; return RetVal; } // Innitilze DbParams object DbParams = new List<System.Data.Common.DbParameter>(); // create tag parameter System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter(); Param1.ParameterName = "@TagId"; Param1.DbType = DbType.Int32; Param1.Value = Tag; DbParams.Add(Param1); // Execute stored procedure to get tag Nid RetDelTagId = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_DeleteTagsMappingsByTagId", CommandType.StoredProcedure, DbParams)); if (RetDelTagId > 0) { RetVal = true; } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } finally { DbParams = null; ObjDIConnection = null; } return RetVal; }
public bool AddMenuCategory(string CategoryName, string LinkText, string HeaderText, string HeaderDesc,string PageName) { DIConnection ObjDIConnection = null; CMSHelper Helper = new CMSHelper(); List<System.Data.Common.DbParameter> DbParams = null; bool RetVal = false; int AddMenuCategory = -1; try { //Get Connection Object ObjDIConnection = Helper.GetConnectionObject(); // Checke if Connection object is null then return null and stop further flow to execute if (ObjDIConnection == null) { return RetVal; } // If Connection object is not null then excute further code else { DbParams = new List<System.Data.Common.DbParameter>(); // create database parameters System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param1.ParameterName = "@MenuCategory"; Param1.DbType = DbType.String; Param1.Value = CategoryName; DbParams.Add(Param1); System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param2.ParameterName = "@LinkText"; Param2.DbType = DbType.String; Param2.Value = LinkText; DbParams.Add(Param2); System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param3.ParameterName = "@HeaderText"; Param3.DbType = DbType.String; Param3.Value = HeaderText; DbParams.Add(Param3); System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param4.ParameterName = "@HeaderDesc"; Param4.DbType = DbType.String; Param4.Value = HeaderDesc; DbParams.Add(Param4); System.Data.Common.DbParameter Param5 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param5.ParameterName = "@IsVisible"; Param5.DbType = DbType.String; Param5.Value = true; DbParams.Add(Param5); System.Data.Common.DbParameter Param6 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param6.ParameterName = "@PageName"; Param6.DbType = DbType.String; Param6.Value = PageName; DbParams.Add(Param6); // Execute stored procedure to add menu category from database AddMenuCategory = Convert.ToInt32(ObjDIConnection.ExecuteNonQuery("sp_AddMenuCategory", CommandType.StoredProcedure, DbParams)); // Check if return datatable is not null and having atleast 1 record if (AddMenuCategory > 0) { RetVal = true; } } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } finally { ObjDIConnection = null; } return RetVal; }
public bool MoveUpNDownMenuCat(string MenuCategory, bool MoveUp, bool MoveDown,string PageName) { bool RetVal = false; DIConnection ObjDIConnection = null; CMSHelper Helper = new CMSHelper(); List<System.Data.Common.DbParameter> DbParams = null; int MenuCateMoved = -1; try { //Get Connection Object ObjDIConnection = Helper.GetConnectionObject(); // Checke if Connection object is null then return null and stop further flow to execute if (ObjDIConnection == null) { return RetVal; } // If Connection object is not null then excute further code else { DbParams = new List<System.Data.Common.DbParameter>(); // create database parameters System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param1.ParameterName = "@MenuCategory"; Param1.DbType = DbType.String; Param1.Value = MenuCategory; DbParams.Add(Param1); // create database parameters System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param2.ParameterName = "@MoveUp"; Param2.DbType = DbType.Int16; Param2.Value = MoveUp; DbParams.Add(Param2); // create database parameters System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param3.ParameterName = "@MoveDown"; Param3.DbType = DbType.Int16; Param3.Value = MoveDown; DbParams.Add(Param3); System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param4.ParameterName = "@PageName"; Param4.DbType = DbType.String; Param4.Value = PageName; DbParams.Add(Param4); // Execute stored procedure to delete menu category from database MenuCateMoved = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_MoveUpNDownMenuCat", CommandType.StoredProcedure, DbParams)); if (MenuCateMoved >= 0) { RetVal = true; } } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } finally { ObjDIConnection = null; } return RetVal; }
public string GetMenuCategoriesListJson(bool IsCategoryVisible,string PageName) { System.Web.Script.Serialization.JavaScriptSerializer jSearializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List<MenuCategories> RetMenuCat = null; string RetVal = string.Empty; DIConnection ObjDIConnection = null; CMSHelper Helper = new CMSHelper(); List<System.Data.Common.DbParameter> DbParams = null; DataTable DtRetData = null; try { //Get Connection Object ObjDIConnection = Helper.GetConnectionObject(); // Checke if Connection object is null then return null and stop further flow to execute if (ObjDIConnection == null) { return RetVal; } // If Connection object is not null then excute further code else { DbParams = new List<System.Data.Common.DbParameter>(); // create database parameters System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param1.ParameterName = "@IsVisible"; Param1.DbType = DbType.Int32; Param1.Value = IsCategoryVisible; DbParams.Add(Param1); System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param2.ParameterName = "@PageName"; Param2.DbType = DbType.String; Param2.Value = PageName; DbParams.Add(Param2); // Execute stored procedure to get Tags From Database DtRetData = ObjDIConnection.ExecuteDataTable("sp_GetMenuCategoriesByPageName", CommandType.StoredProcedure, DbParams); // Check if return datatable is not null and having atleast 1 record if (DtRetData != null && DtRetData.Rows.Count > 0) { RetMenuCat = new List<MenuCategories>(); // Itterate through loop for (int Icount = 0; Icount < DtRetData.Rows.Count; Icount++) { MenuCategories ObjMenuCat = new MenuCategories(); ObjMenuCat.MenuCategory = DtRetData.Rows[Icount]["MenuCategory"].ToString(); ObjMenuCat.LinkText = DtRetData.Rows[Icount]["LinkText"].ToString(); ObjMenuCat.HeaderText = DtRetData.Rows[Icount]["HeaderText"].ToString(); ObjMenuCat.HeaderDesc = DtRetData.Rows[Icount]["HeaderDesc"].ToString(); ObjMenuCat.PageName = DtRetData.Rows[Icount]["PageName"].ToString(); // assign tag value to list RetVal RetMenuCat.Add(ObjMenuCat); } } RetVal = jSearializer.Serialize(RetMenuCat); } } catch (Exception Ex) { RetVal = string.Empty; Global.CreateExceptionString(Ex, null); } finally { ObjDIConnection = null; } return RetVal; }
public bool DeleteMenuCategory(string CategoryName) { bool RetVal = false; DIConnection ObjDIConnection = null; CMSHelper Helper = new CMSHelper(); List<System.Data.Common.DbParameter> DbParams = null; int DeleteMenuCate = -1; try { //Get Connection Object ObjDIConnection = Helper.GetConnectionObject(); // Checke if Connection object is null then return null and stop further flow to execute if (ObjDIConnection == null) { return RetVal; } // If Connection object is not null then excute further code else { DbParams = new List<System.Data.Common.DbParameter>(); // create database parameters System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter Param1.ParameterName = "@MenuCategory"; Param1.DbType = DbType.String; Param1.Value = CategoryName; DbParams.Add(Param1); // Execute stored procedure to delete menu category from database DeleteMenuCate = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_DeleteMenuCategory", CommandType.StoredProcedure, DbParams)); if (DeleteMenuCate >= 0) { RetVal = true; } } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } finally { ObjDIConnection = null; } return RetVal; }
// Create new content page andd add link on main html page private bool AddCMSContentToDB(DataContent CMSDataContent) { bool RetVal = false; string ConnectionMessage = string.Empty; List<System.Data.Common.DbParameter> DbParams = new List<System.Data.Common.DbParameter>(); DIConnection ObjDIConnection = null; int DtAddCmsCont = -1; try { CMSHelper ObjCMSHelper = new CMSHelper(); // call method to get connection object ObjDIConnection = ObjCMSHelper.GetConnectionObject(out ConnectionMessage); // create database parameters System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter(); Param1.ParameterName = "@MenuCategory"; Param1.DbType = DbType.String; Param1.Value = CMSDataContent.MenuCategory; DbParams.Add(Param1); System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter(); Param2.ParameterName = "@Title"; Param2.DbType = DbType.String; Param2.Value = CMSDataContent.Title; DbParams.Add(Param2); System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter(); Param3.ParameterName = "@Date"; Param3.DbType = DbType.DateTime; Param3.Value = CMSDataContent.Date; DbParams.Add(Param3); System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter(); Param4.ParameterName = "@Thumbnail"; Param4.DbType = DbType.String; Param4.Value = CMSDataContent.Thumbnail; DbParams.Add(Param4); System.Data.Common.DbParameter Param5 = ObjDIConnection.CreateDBParameter(); Param5.ParameterName = "@Summary"; Param5.DbType = DbType.String; Param5.Value = CMSDataContent.Summary; DbParams.Add(Param5); System.Data.Common.DbParameter Param6 = ObjDIConnection.CreateDBParameter(); Param6.ParameterName = "@Description"; Param6.DbType = DbType.String; Param6.Value = CMSDataContent.Description; DbParams.Add(Param6); System.Data.Common.DbParameter Param7 = ObjDIConnection.CreateDBParameter(); Param7.ParameterName = "@PDFUpload"; Param7.DbType = DbType.String; Param7.Value = CMSDataContent.PDFUpload; DbParams.Add(Param7); System.Data.Common.DbParameter Param8 = ObjDIConnection.CreateDBParameter(); Param8.ParameterName = "@DateAdded"; Param8.DbType = DbType.DateTime; Param8.Value = CMSDataContent.DateAdded; DbParams.Add(Param8); System.Data.Common.DbParameter Param9 = ObjDIConnection.CreateDBParameter(); Param9.ParameterName = "@DateModified"; Param9.DbType = DbType.DateTime; Param9.Value = CMSDataContent.DateModified; DbParams.Add(Param9); System.Data.Common.DbParameter Param10 = ObjDIConnection.CreateDBParameter(); Param10.ParameterName = "@Archived"; Param10.DbType = DbType.Boolean; Param10.Value = CMSDataContent.Archived; DbParams.Add(Param10); System.Data.Common.DbParameter Param11 = ObjDIConnection.CreateDBParameter(); Param11.ParameterName = "@ArticleTagId"; Param11.DbType = DbType.Int32; Param11.Value = CMSDataContent.ArticleTagID; DbParams.Add(Param11); System.Data.Common.DbParameter Param12 = ObjDIConnection.CreateDBParameter(); Param12.ParameterName = "@UserNameEmail"; Param12.DbType = DbType.String; Param12.Value = CMSDataContent.UserNameEmail; DbParams.Add(Param12); System.Data.Common.DbParameter Param14 = ObjDIConnection.CreateDBParameter(); Param14.ParameterName = "@URL"; Param14.DbType = DbType.String; Param14.Value = CMSDataContent.URL; DbParams.Add(Param14); System.Data.Common.DbParameter Param15 = ObjDIConnection.CreateDBParameter(); Param15.ParameterName = "@LngCode"; Param15.DbType = DbType.String; Param15.Value = CMSDataContent.LngCode; DbParams.Add(Param15); System.Data.Common.DbParameter Param16 = ObjDIConnection.CreateDBParameter(); Param16.ParameterName = "@IsDeleted"; Param16.DbType = DbType.Boolean; Param16.Value =CMSDataContent.IsDeleted; DbParams.Add(Param16); System.Data.Common.DbParameter Param17 = ObjDIConnection.CreateDBParameter(); Param17.ParameterName = "@IsHidden"; Param17.DbType = DbType.Boolean; Param17.Value = CMSDataContent.IsHidden; DbParams.Add(Param17); System.Data.Common.DbParameter Param18 = ObjDIConnection.CreateDBParameter(); Param18.ParameterName = "@Fld1"; Param18.DbType = DbType.String; Param18.Value = ""; DbParams.Add(Param18); System.Data.Common.DbParameter Param19 = ObjDIConnection.CreateDBParameter(); Param19.ParameterName = "@Fld2"; Param19.DbType = DbType.String; Param19.Value = ""; DbParams.Add(Param19); System.Data.Common.DbParameter Param20 = ObjDIConnection.CreateDBParameter(); Param20.ParameterName = "@Fld3"; Param20.DbType = DbType.String; Param20.Value = ""; DbParams.Add(Param20); System.Data.Common.DbParameter Param21 = ObjDIConnection.CreateDBParameter(); Param21.ParameterName = "@Fld4"; Param21.DbType = DbType.String; Param21.Value = ""; DbParams.Add(Param21); System.Data.Common.DbParameter Param22 = ObjDIConnection.CreateDBParameter(); Param22.ParameterName = "@Fld5"; Param22.DbType = DbType.String; Param22.Value = ""; DbParams.Add(Param22); System.Data.Common.DbParameter Param23 = ObjDIConnection.CreateDBParameter(); Param23.ParameterName = "@Fld6"; Param23.DbType = DbType.String; Param23.Value = ""; DbParams.Add(Param23); System.Data.Common.DbParameter Param24 = ObjDIConnection.CreateDBParameter(); Param24.ParameterName = "@Fld1Text"; Param24.DbType = DbType.String; Param24.Value = ""; DbParams.Add(Param24); System.Data.Common.DbParameter Param25 = ObjDIConnection.CreateDBParameter(); Param25.ParameterName = "@Fld2Text"; Param25.DbType = DbType.String; Param25.Value = ""; DbParams.Add(Param25); System.Data.Common.DbParameter Param26 = ObjDIConnection.CreateDBParameter(); Param26.ParameterName = "@Fld3Text"; Param26.DbType = DbType.String; Param26.Value = ""; DbParams.Add(Param26); System.Data.Common.DbParameter Param27= ObjDIConnection.CreateDBParameter(); Param27.ParameterName = "@Fld4Text"; Param27.DbType = DbType.String; Param27.Value = ""; DbParams.Add(Param27); System.Data.Common.DbParameter Param28 = ObjDIConnection.CreateDBParameter(); Param28.ParameterName = "@Fld5Text"; Param28.DbType = DbType.String; Param28.Value = ""; DbParams.Add(Param28); System.Data.Common.DbParameter Param29 = ObjDIConnection.CreateDBParameter(); Param29.ParameterName = "@Fld6Text"; Param29.DbType = DbType.String; Param29.Value = ""; DbParams.Add(Param29); // Execute stored procedure to Insert CMS Content In Database DtAddCmsCont = ObjDIConnection.ExecuteNonQuery("sp_AddCMSContent", CommandType.StoredProcedure, DbParams); //To check if records inserted in database,check if count of no of rows effected is greater than 0 if (DtAddCmsCont > 0) { RetVal = true; } // return false else { RetVal = false; } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } return RetVal; }
/// Create CMS database for adaptation If Database Not exise /// </summary> /// <param name="CMSDatabaseName">Name of the created Cms Database</param> /// <returns>True if database created or already exist</returns> public bool MigratorHtmlContentToDb(List<DataContent> InputListDataContent, out string ContentDbImportMessage) { bool RetVal = false; DIConnection ObjDIConnection = null; CMSHelper ObjCmsHelper = new CMSHelper(); string DbScripts = string.Empty; string LngDbScripts = string.Empty; string ConnectionMessage = string.Empty; string QryStr = string.Empty; DataTable DTCounts; List<System.Data.Common.DbParameter> DbParams = new List<System.Data.Common.DbParameter>(); try { ObjDIConnection = ObjCmsHelper.GetConnectionObject(out ConnectionMessage); if (ObjDIConnection == null) { ContentDbImportMessage = ConnectionMessage; RetVal = false; return RetVal; } else { foreach (DataContent DContent in InputListDataContent) { try { if (!string.IsNullOrEmpty(DContent.Title) || !string.IsNullOrEmpty(DContent.Summary.ToString()) || !string.IsNullOrEmpty(DContent.Thumbnail.ToString()) || !string.IsNullOrEmpty(DContent.Description.ToString()) || !string.IsNullOrEmpty(DContent.PDFUpload.ToString())) { QryStr = "select * from DataContent where Title='" + DContent.Title.Replace("'", "''") + "'" + "and Date='" + DContent.Date + "' and Summary='" + DContent.Summary.Replace("'", "''") + "'"; DTCounts = ObjDIConnection.ExecuteDataTable(QryStr); if (DTCounts.Rows.Count == 0) { QryStr = "INSERT into DataContent (MenuCategory, Title, Date, Thumbnail, Summary, Description, PDFUpload, DateAdded,DateModified, Archived, ArticleTagId, UserNameEmail, URL, LngCode, IsDeleted,IsHidden) Values (" + "'" + DContent.MenuCategory + "','" + DContent.Title.Replace("'", "''") + "','" + DContent.Date + "','" + DContent.Thumbnail + "','" + DContent.Summary.Replace("'", "''") + "','" + DContent.Description.Replace("'", "''") + "','" + DContent.PDFUpload + "','" + DContent.DateAdded + "','" + DContent.DateModified + "','" + DContent.Archived + "','" + DContent.ArticleTagID + "','" + DContent.UserNameEmail.Replace("'", "''") + "','" + DContent.URL + "','" + DContent.LngCode + "','" + DContent.IsDeleted + "','" + DContent.IsHidden + "')"; ObjDIConnection.ExecuteNonQuery(QryStr); } } } catch (Exception Ex) { string ExceptionMgs = "Exception occured in method ImportHtmlContentToDb while insering records in database,"; ExceptionMgs = " Exception message is" + Ex.InnerException.ToString() + "Stack trace is" + Ex.StackTrace.ToString(); Global.WriteErrorsInLogFolder(ExceptionMgs); ContentDbImportMessage = "Error occured while importing datavalues to database"; RetVal = false; } } } // Set Retval to true RetVal = true; // Dispose connection object ObjDIConnection.Dispose(); } catch (Exception ex) { ContentDbImportMessage = "Error occured while importing datavalues to database"; RetVal = false; Global.CreateExceptionString(ex, null); } finally { // dispose connection object ObjDIConnection = null; } ContentDbImportMessage = string.Empty; return RetVal; }
public bool ShowHideArticlebyContentId(int ContentId, bool IsHidden) { CMSHelper ObjCMSHelper = new CMSHelper(); string ResultNid = string.Empty; bool RetVal = false; List<System.Data.Common.DbParameter> DbParams = null; DIConnection ObjDIConnection = null; int RetDelTagId = -1; try { // Call method to get connection object ObjDIConnection = ObjCMSHelper.GetConnectionObject(); // Check if connection object is not null if (ObjDIConnection == null) { RetVal = false; return RetVal; } // Innitilze DbParams object DbParams = new List<System.Data.Common.DbParameter>(); System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter(); Param1.ParameterName = "@ContentId"; Param1.DbType = DbType.Int32; Param1.Value = ContentId; DbParams.Add(Param1); System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter(); Param2.ParameterName = "@IsHidden"; Param2.DbType = DbType.Boolean; Param2.Value = IsHidden; DbParams.Add(Param2); // Execute stored procedure to get tag Nid RetDelTagId = Convert.ToInt32(ObjDIConnection.ExecuteNonQuery("sp_ShowHideArticlesByContentId", CommandType.StoredProcedure, DbParams)); if (RetDelTagId > 0) { RetVal = true; } } catch (Exception Ex) { RetVal = false; Global.CreateExceptionString(Ex, null); } finally { DbParams = null; ObjDIConnection = null; } return RetVal; }