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);
}
