public List <SiteDeparmentsEntity> GetFullPathByRelatedPageID(int RelatedPageID, Languages langID) { using (SqlConnection myConnection = GetSqlConnection()) { List <SiteDeparmentsEntity> siteDeparmentsList = new List <SiteDeparmentsEntity>(); SiteDeparmentsEntity siteDeparmentsObject = null; SqlCommand myCommand = new SqlCommand("SiteDeparments_GetFullPathByRelatedPageID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@RelatedPageID", SqlDbType.Int, 4).Value = RelatedPageID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; //---------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------- // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { //siteDeparmentsObject = PopulateSiteDeparmentsEntity(dr); siteDeparmentsObject = (SiteDeparmentsEntity)GetEntity(dr, typeof(SiteDeparmentsEntity)); siteDeparmentsList.Add(siteDeparmentsObject); } dr.Close(); myConnection.Close(); //Gets result rows count return(siteDeparmentsList); //---------------------------------------------------------------- } }
//---------------------------------------------------------------------------- #endregion #region --------------------------SetMetaTags---------------------------- //---------------------------------------------------------------------------- //SetMetaTags //---------------------------------------------------------------------------- public static void SetMetaTags(SiteDeparmentsEntity siteDepartment) { DCMetaBuilder metaBuilder = DCMetaBuilder.Instance; string siteName = SiteTextsManager.Instance.SiteName.Trim(); //------------------------------------------------------------ metaBuilder.Title = siteDepartment.Title; //------------------------------------------------------------ if (!string.IsNullOrEmpty(siteDepartment.KeyWords)) { metaBuilder.Keywords = siteDepartment.KeyWords; } //------------------------------------------------------------ if (!string.IsNullOrEmpty(siteDepartment.ShortDescription)) { metaBuilder.Description = siteDepartment.ShortDescription; } //------------------------------------------------------------ metaBuilder.Author = siteName; //------------------------------------------------------------ metaBuilder.PubDate = siteDepartment.Date_Added.ToUniversalTime().ToString(); //------------------------------------------------------------ metaBuilder.LastModification = siteDepartment.LastModification.ToUniversalTime().ToString(); //------------------------------------------------------------ metaBuilder.Source = siteName; //------------------------------------------------------------ }
/// <summary> /// Creates SiteDeparments object by calling SiteDeparments data provider create method. /// <example>[Example]bool status=SiteDeparmentsFactory.Create(siteDeparmentsObject);.</example> /// </summary> /// <param name="siteDeparmentsObject">The SiteDeparments object.</param> /// <returns>Status of create operation.</returns> public static ExecuteCommandStatus Create(SiteDeparmentsEntity siteDepartment) { //Insert user name------------------------------------------ string username = ""; if (HttpContext.Current.User.Identity.IsAuthenticated) { username = HttpContext.Current.User.Identity.Name; siteDepartment.InsertUserName = username; } //---------------------------------------------------------- return(SiteDeparmentsSqlDataPrvider.Instance.Create(siteDepartment)); }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Updates SiteDeparments object by calling SiteDeparments data provider update method. /// <example>[Example]bool status=SiteDeparmentsFactory.Update(siteDeparmentsObject);.</example> /// </summary> /// <param name="siteDeparmentsObject">The SiteDeparments object.</param> /// <returns>Status of update operation.</returns> public static ExecuteCommandStatus Update(SiteDeparmentsEntity siteDepartment) { //Update user name------------------------------------------ string username = ""; if (HttpContext.Current.User.Identity.IsAuthenticated) { username = HttpContext.Current.User.Identity.Name; siteDepartment.LastUpdateUserName = username; } //---------------------------------------------------------- ExecuteCommandStatus status = SiteDeparmentsSqlDataPrvider.Instance.Update(siteDepartment); return(status); }
//------------------------------------------ #endregion #region --------------SaveDetails-------------- public ExecuteCommandStatus SaveDetails(SiteDeparmentsEntity siteDeparmentsObject, SPOperation operation) { Hashtable siteDepartmentDetailsCollection = siteDeparmentsObject.Details; ExecuteCommandStatus status = ExecuteCommandStatus.UnknownError; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SiteDeparmentsDetails_Save", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@SPOperation", SqlDbType.Int, 4).Value = (int)operation; myCommand.Parameters.Add("@DepartmentID", SqlDbType.Int, 4); myCommand.Parameters.Add("@LangID", SqlDbType.Int); myCommand.Parameters.Add("@Title", SqlDbType.NVarChar, 128); myCommand.Parameters.Add("@ShortDescription", SqlDbType.NVarChar, 512); myCommand.Parameters.Add("@Description", SqlDbType.NVarChar); //---------------------- myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4); myCommand.Parameters.Add("@ParentID", SqlDbType.Int, 4); //-------------------------------------------------------- myCommand.Parameters.Add("@KeyWords", SqlDbType.NVarChar, 256); //-------------------------------------------------------- // Execute the command myConnection.Open(); foreach (DictionaryEntry key in siteDepartmentDetailsCollection) { SiteDeparmentsDetailsEntity itemDetails = (SiteDeparmentsDetailsEntity)key.Value; myCommand.Parameters["@DepartmentID"].Value = siteDeparmentsObject.DepartmentID; myCommand.Parameters["@LangID"].Value = (int)itemDetails.LangID; myCommand.Parameters["@Title"].Value = itemDetails.Title; myCommand.Parameters["@ShortDescription"].Value = itemDetails.ShortDescription; myCommand.Parameters["@Description"].Value = itemDetails.Description; // myCommand.Parameters["@ModuleTypeID"].Value = (int)siteDeparmentsObject.ModuleTypeID; myCommand.Parameters["@ParentID"].Value = siteDeparmentsObject.ParentID; myCommand.Parameters["@KeyWords"].Value = itemDetails.KeyWords; status = (ExecuteCommandStatus)myCommand.ExecuteScalar(); if (status != ExecuteCommandStatus.Done) { break; } } myConnection.Close(); return(status); } }
//------------------------------------------ #endregion #region --------------Create-------------- /// <summary> /// Converts the SiteDeparments object properties to SQL paramters and executes the create SiteDeparments procedure /// and updates the SiteDeparments object with the SQL data by reference. /// <example>[Example]bool status=SiteDeparmentsSqlDataPrvider.Instance.Create(siteDeparmentsObject);.</example> /// </summary> /// <param name="siteDeparmentsObject">The SiteDeparments object.</param> /// <returns>The status of create query.</returns> public ExecuteCommandStatus Create(SiteDeparmentsEntity siteDeparmentsObject) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SiteDeparments_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@DepartmentID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@PhotoExtension", SqlDbType.VarChar, 5).Value = siteDeparmentsObject.PhotoExtension; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@IsAvailable", SqlDbType.Bit, 1).Value = siteDeparmentsObject.IsAvailable; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = siteDeparmentsObject.ModuleTypeID; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@ParentID", SqlDbType.Int, 4).Value = (int)siteDeparmentsObject.ParentID; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@RelatedModuleTypeID", SqlDbType.Int, 4).Value = siteDeparmentsObject.RelatedModuleTypeID; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@RelatedPageID", SqlDbType.Int, 4).Value = siteDeparmentsObject.RelatedPageID; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@InsertUserName", SqlDbType.NVarChar, 64).Value = (string)siteDeparmentsObject.InsertUserName; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@TypeID", SqlDbType.Int, 4).Value = siteDeparmentsObject.TypeID; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@Url", SqlDbType.NVarChar, 128).Value = siteDeparmentsObject.Url; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = siteDeparmentsObject.OwnerID; myCommand.Parameters.Add("@OwnerName", SqlDbType.VarChar).Value = siteDeparmentsObject.OwnerName; //---------------------------------------------------------------------------------- // Execute the command myConnection.Open(); ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar(); if (status == ExecuteCommandStatus.Done) { siteDeparmentsObject.DepartmentID = (int)myCommand.Parameters["@DepartmentID"].Value; status = SaveDetails(siteDeparmentsObject, SPOperation.Insert); } myConnection.Close(); return(status); //---------------------------------------------------------------------------------- } }
public SiteDeparmentsEntity GetSiteDeparmentsObject(int departmentID, Languages langID) { SiteDeparmentsEntity siteDeparmentsObject = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SiteDeparments_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@DepartmentID", SqlDbType.Int, 4).Value = departmentID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; //---------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { if (siteDeparmentsObject == null) { /* siteDeparmentsObject = PopulateSiteDeparmentsEntity(dr); * SiteDeparmentsDetailsEntity pd = PopulateSiteDeparmentsDetailsEntity(dr); */ siteDeparmentsObject = (SiteDeparmentsEntity)GetEntity(dr, typeof(SiteDeparmentsEntity)); SiteDeparmentsDetailsEntity pd = (SiteDeparmentsDetailsEntity)GetEntity(dr, typeof(SiteDeparmentsDetailsEntity)); siteDeparmentsObject.Details[pd.LangID] = pd; } else { //SiteDeparmentsDetailsEntity pd = PopulateSiteDeparmentsDetailsEntity(dr); SiteDeparmentsDetailsEntity pd = (SiteDeparmentsDetailsEntity)GetEntity(dr, typeof(SiteDeparmentsDetailsEntity)); siteDeparmentsObject.Details[pd.LangID] = pd; } } dr.Close(); } myConnection.Close(); return(siteDeparmentsObject); } }
public static void AddTitlePath(PathLinksClass pc, Label lblTitle) { if (MoversFW.Components.UrlManager.ChechIsValidIntegerParameter("id")) { int siteDepartmentID = Convert.ToInt32(HttpContext.Current.Request.QueryString["id"]); Languages lang = SiteSettings.GetCurrentLanguage(); SiteDeparmentsEntity depObject = SiteDeparmentsFactory.GetObject(siteDepartmentID, lang); if (depObject != null) { if (pc != null) { pc.AddLink(depObject.Title, null); } if (lblTitle != null) { lblTitle.Text = depObject.Title; } } } }
//--------------------------------------------------------- //BuildDepartmentsPathLinks //--------------------------------------------------------- public bool BuildDepartmentsPathLinks(int moduleDepartment, bool lastLink, bool setTags) { bool hasLinks = false; if (moduleDepartment > 0) { List <SiteDeparmentsEntity> sdp = SiteDeparmentsFactory.GetFullPath(moduleDepartment); if (sdp.Count > 0) { hasLinks = true; SiteDeparmentsEntity lastDep = null; SiteDeparmentsEntity tempdep = null; string url = ""; for (int i = 0; i < sdp.Count; i++) { tempdep = sdp[i]; if (lastLink && i == sdp.Count - 1) { lastDep = tempdep; _PathControl.AddLink(tempdep.Title, null); if (setTags) { DCMetaBuilder metaBuilder = DCMetaBuilder.Instance; metaBuilder.Section = tempdep.Title; metaBuilder.Title = tempdep.Title; } } else { url = GetSiteDepartmentsURl(tempdep.Url, tempdep.RelatedModuleTypeID, tempdep.RelatedPageID, tempdep.DepartmentID); _PathControl.AddLink(tempdep.Title, url); } } } } return(hasLinks); }