public List <ItemCategoriesEntity> GetFullPath(int categoryID, Languages langID)
{
using (SqlConnection myConnection = GetSqlConnection())
{
List <ItemCategoriesEntity> itemCategoriesList = new List <ItemCategoriesEntity>();
ItemCategoriesEntity itemCategoriesObject = null;
SqlCommand myCommand = new SqlCommand("ItemCategories_GetFullPath", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Value = categoryID;
myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID;
//----------------------------------------------------------------
// Execute the command
SqlDataReader dr;
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
//itemCategoriesObject = PopulateItemCategoriesEntity(dr);
itemCategoriesObject = (ItemCategoriesEntity)GetEntity(dr, typeof(ItemCategoriesEntity));
itemCategoriesList.Add(itemCategoriesObject);
}
dr.Close();
myConnection.Close();
//Gets result rows count
return(itemCategoriesList);
//----------------------------------------------------------------
}
}
/// <summary>
/// Creates ItemCategories object by calling ItemCategories data provider create method.
/// <example>[Example]bool status=ItemCategoriesFactory.Create(itemCategoriesObject);.</example>
/// </summary>
/// <param name="itemCategoriesObject">The ItemCategories object.</param>
/// <returns>Status of create operation.</returns>
public static ExecuteCommandStatus Create(ItemCategoriesEntity category, ItemsModulesOptions currentModule)
{
//Insert user name------------------------------------------
string username = "";
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
username = HttpContext.Current.User.Identity.Name;
category.InsertUserName = username;
}
//----------------------------------------------------------
ExecuteCommandStatus status = ItemCategoriesSqlDataPrvider.Instance.Create(category, currentModule);
//-------------------------------------
if (status == ExecuteCommandStatus.Done)
{
string folder = DCSiteUrls.GetPath_ItemCategoriesDirectory(category.OwnerName, category.ModuleTypeID, category.CategoryID);
string folderPhysicalPath = DCServer.MapPath(folder);
if (!Directory.Exists(folderPhysicalPath))
{
string defaultFolder = DCSiteUrls.GetPath_DefaultCategoryFolder();
string defaultFolderPhysicalPath = DCServer.MapPath(defaultFolder);
DirectoryInfo diSource = new DirectoryInfo(defaultFolderPhysicalPath);
DirectoryInfo diTarget = new DirectoryInfo(folderPhysicalPath);
DcDirectoryManager.CopyAll(diSource, diTarget);
}
}
//-------------------------------------
return(status);
}
//------------------------------------------
#endregion
#region --------------SaveDetails--------------
public ExecuteCommandStatus SaveDetails(ItemCategoriesEntity itemCategoriesObject, bool AllowDublicateTitlesInCategories, SPOperation operation)
{
Hashtable categoryDetailsCollection = itemCategoriesObject.Details;
ExecuteCommandStatus status = ExecuteCommandStatus.UnknownError;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemCategoriesDetails_Save", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@SPOperation", SqlDbType.Int, 4).Value = (int)operation;
myCommand.Parameters.Add("@CategoryID", 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("@AllowDublicateTitlesInCategories", SqlDbType.Bit, 1);
//--------------------------------------------------------
myCommand.Parameters.Add("@KeyWords", SqlDbType.NVarChar, 256);
//--------------------------------------------------------
// Execute the command
myConnection.Open();
foreach (DictionaryEntry key in categoryDetailsCollection)
{
ItemCategoriesDetailsEntity itemDetails = (ItemCategoriesDetailsEntity)key.Value;
myCommand.Parameters["@CategoryID"].Value = itemCategoriesObject.CategoryID;
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)itemCategoriesObject.ModuleTypeID;
myCommand.Parameters["@ParentID"].Value = itemCategoriesObject.ParentID;
myCommand.Parameters["@AllowDublicateTitlesInCategories"].Value = AllowDublicateTitlesInCategories;
//--------------------------------------------------------
myCommand.Parameters["@KeyWords"].Value = itemDetails.KeyWords;
//--------------------------------------------------------
status = (ExecuteCommandStatus)myCommand.ExecuteScalar();
if (status != ExecuteCommandStatus.Done)
{
break;
}
}
myConnection.Close();
return(status);
}
}
//------------------------------------------
#endregion
#region --------------Update--------------
/// <summary>
/// Updates ItemCategories object by calling ItemCategories data provider update method.
/// <example>[Example]bool status=ItemCategoriesFactory.Update(itemCategoriesObject);.</example>
/// </summary>
/// <param name="itemCategoriesObject">The ItemCategories object.</param>
/// <returns>Status of update operation.</returns>
public static ExecuteCommandStatus Update(ItemCategoriesEntity category, ItemsModulesOptions currentModule)
{
//Update user name------------------------------------------
string username = "";
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
username = HttpContext.Current.User.Identity.Name;
category.LastUpdateUserName = username;
}
//----------------------------------------------------------
ExecuteCommandStatus status = ItemCategoriesSqlDataPrvider.Instance.Update(category, currentModule);
return(status);
}
public static void AddToCart(int itemID, ref ItemsEntity item, ref ItemCategoriesEntity category)
{
Guid OwnerID = SitesHandler.GetOwnerIDAsGuid();
//---------------------------------------------------------
Languages langID = SiteSettings.GetCurrentLanguage();
if (item == null)
{
item = ItemsFactory.GetObject(itemID, langID, UsersTypes.User, OwnerID);
}
if (category == null)
{
category = ItemCategoriesFactory.GetObject(item.CategoryID, langID, OwnerID);
}
if (item != null && category != null)
{
List <ItemsOrdersDetailsModel> CartList = GetCartList();
//---------------------------------------------------------
bool existIntoCart = false;
foreach (ItemsOrdersDetailsModel p in CartList)
{
if (p.ItemID == itemID)
{
p.Quantity += 1;
existIntoCart = true;
break;
}
}
if (!existIntoCart)
{
ItemsOrdersDetailsModel newP = new ItemsOrdersDetailsModel();
newP.ItemID = itemID;
newP.Quantity = 1;
CartList.Add(newP);
}
//---------------------------------------------------------
//Session["Cart"] = CartList;
}
}
//----------------------------------------------------------------------------
#endregion
#region --------------------------SetMetaTags----------------------------
//----------------------------------------------------------------------------
//SetMetaTags
//----------------------------------------------------------------------------
public static void SetMetaTags(ItemCategoriesEntity category)
{
DCMetaBuilder metaBuilder = DCMetaBuilder.Instance;
//------------------------------------------------------------
metaBuilder.Title = category.Title;
//------------------------------------------------------------
if (!string.IsNullOrEmpty(category.KeyWords))
{
metaBuilder.Keywords = category.KeyWords;
}
//------------------------------------------------------------
if (!string.IsNullOrEmpty(category.ShortDescription))
{
metaBuilder.Description = category.ShortDescription;
}
//------------------------------------------------------------
metaBuilder.SubSection = category.Title;
//------------------------------------------------------------
metaBuilder.LastModification = category.LastModification.ToUniversalTime().ToString();
//------------------------------------------------------------
}
//------------------------------------------
#endregion
#region --------------Delete--------------
/// <summary>
/// Deletes single ItemCategories object .
/// <example>[Example]bool status=ItemCategoriesFactory.Delete(categoryID);.</example>
/// </summary>
/// <param name="categoryID">The itemCategoriesObject id.</param>
/// <returns>Status of delete operation.</returns>
public static bool Delete(int CategoryID)
{
Languages langID = SiteSettings.GetCurrentLanguage();
ItemCategoriesEntity category = GetObject(CategoryID, langID, SitesHandler.GetOwnerIDAsGuid());
bool status = ItemCategoriesSqlDataPrvider.Instance.Delete(CategoryID);
if (status)
{
//-------------------------------------
//delete category folder
//-------------------------------------
string folder = DCSiteUrls.GetPath_ItemCategoriesDirectory(category.OwnerName, category.ModuleTypeID, category.CategoryID);
string folderPhysicalPath = DCServer.MapPath(folder);
if (Directory.Exists(folderPhysicalPath))
{
DirectoryInfo dir = new DirectoryInfo(folderPhysicalPath);
DcDirectoryManager.DeletDirectory(dir);
}
//-------------------------------------
}
return(status);
}
public ItemCategoriesEntity GetItemCategoriesObject(int categoryID, Languages langID, Guid OwnerID)
{
ItemCategoriesEntity itemCategoriesObject = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemCategories_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Value = categoryID;
myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID;
//---------------------------------------------------------------------
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = OwnerID;
//---------------------------------------------------------------------
// Execute the command
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
if (itemCategoriesObject == null)
{
itemCategoriesObject = (ItemCategoriesEntity)GetEntity(dr, typeof(ItemCategoriesEntity));
ItemCategoriesDetailsEntity pd = (ItemCategoriesDetailsEntity)GetEntity(dr, typeof(ItemCategoriesDetailsEntity));
itemCategoriesObject.Details[pd.LangID] = pd;
}
else
{
ItemCategoriesDetailsEntity pd = (ItemCategoriesDetailsEntity)GetEntity(dr, typeof(ItemCategoriesDetailsEntity));
itemCategoriesObject.Details[pd.LangID] = pd;
}
}
dr.Close();
}
myConnection.Close();
return(itemCategoriesObject);
}
}
//---------------------------------------------------------
//BuildCategoriesPathLinksInSubFolder
//---------------------------------------------------------
public bool BuildCategoriesPathLinksInSubFolder(int categoryID, bool lastLink, bool setTags)
{
bool hasLinks = false;
if (categoryID > 0)
{
List <ItemCategoriesEntity> cdp = ItemCategoriesFactory.GetFullPath(categoryID);
if (cdp.Count > 0)
{
hasLinks = true;
ItemCategoriesEntity lastCat = null;
ItemsModulesOptions currentModule = ItemsModulesOptions.GetType(cdp[0].ModuleTypeID);
string url = "";
for (int i = 0; i < cdp.Count; i++)
{
if (lastLink && i == cdp.Count - 1)
{
lastCat = cdp[i];
_PathControl.AddLink(lastCat.Title, null);
if (setTags)
{
DCMetaBuilder metaBuilder = DCMetaBuilder.Instance;
metaBuilder.SubSection = lastCat.Title;
metaBuilder.Title = lastCat.Title;
}
}
else
{
//url = "../default.aspx?id=" + cdp[i].CategoryID;
DCSiteUrls.Instance.BuildItemCategoriesLink(cdp[i].CategoryID, cdp[i].Title, currentModule);
_PathControl.AddLink(cdp[i].Title, url);
}
}
}
}
return(hasLinks);
}
//-------------------------------------------------------
public void InitializeAllOpjects()
{
#region Initial lItem
InitialItem = new ItemsEntity();
//InitialItem.CategoryID = xxxx;
//InitialItem.ItemID
//InitialItem.CategoryID
//InitialItem.ModuleTypeID = moduleType;
//InitialItem.PhotoExtension
InitialItem.Url = Url;
InitialItem.Email = Email;
InitialItem.MailBox = MailBox;
InitialItem.ZipCode = ZipCode;
InitialItem.Tels = Tels;
InitialItem.Fax = Fax;
InitialItem.Mobile = Mobile;
InitialItem.ItemDate = ItemDate;
InitialItem.ItemEndDate = ItemEndDate;
InitialItem.IsAvailable = IsAvailable;
InitialItem.YoutubeCode = YoutubeCode;
InitialItem.GoogleLatitude = GoogleLatitude;
InitialItem.GoogleLongitude = GoogleLongitude;
InitialItem.Price = Price;
/*
* InitialItem.SenderName
* InitialItem.SenderEMail
* InitialItem.SenderCountryID
* InitialItem.Reply
* InitialItem.ReplyDate
* InitialItem.IsSeen
* InitialItem.IsReplied
* InitialItem.IsReviewed
* InitialItem.ToUserID
* InitialItem.ActivatedBy
* InitialItem.ReviewedBy
* InitialItem.OwnerID */
InitialItem.Type = Type;
#endregion
#region InitialItemArDetails
InitialItemArDetails = new ItemsDetailsEntity();
//InitialItemArDetails.ItemID = InitialItem.ItemID;
InitialItemArDetails.LangID = Languages.Ar;
InitialItemArDetails.Title = ArItemTitle;
InitialItemArDetails.ShortDescription = ArItemShortDescrpyion;
InitialItemArDetails.Description = ArItemDetails;
InitialItemArDetails.KeyWords = ArItemSeoKeyWords;
InitialItemArDetails.Address = ArItemAddress;
InitialItemArDetails.AuthorName = ArItemAuthorName;
#endregion
#region InitialItemArDetails
InitialItemEnDetails = new ItemsDetailsEntity();
//InitialItemEnDetails.ItemID = InitialItem.ItemID;
InitialItemEnDetails.LangID = Languages.En;
InitialItemEnDetails.Title = EnItemTitle;
InitialItemEnDetails.ShortDescription = EnItemShortDescrpyion;
InitialItemEnDetails.Description = EnItemDetails;
InitialItemEnDetails.KeyWords = EnItemSeoKeyWords;
InitialItemEnDetails.Address = EnItemAddress;
InitialItemEnDetails.AuthorName = EnItemAuthorName;
#endregion
#region Initial Category
InitialCategory = new ItemCategoriesEntity();
//InitialCategory.CategoryID;
//InitialCategory.PhotoExtension;
//InitialCategory.ModuleTypeID;
//InitialCategory.ParentID;
//InitialCategory.TypeID =Type;
InitialCategory.ItemDate = ItemDate;
InitialCategory.IsAvailable = IsAvailable;
InitialCategory.YoutubeCode = YoutubeCode;
InitialCategory.GoogleLatitude = GoogleLatitude;
InitialCategory.GoogleLongitude = GoogleLongitude;
#endregion
#region Initial Category Parent
InitialCategoryParent = new ItemCategoriesEntity();
//InitialCategoryParent.CategoryID;
//InitialCategoryParent.PhotoExtension;
//InitialCategoryParent.ModuleTypeID;
//InitialCategoryParent.ParentID;
//InitialCategoryParent.TypeID =Type;
InitialCategoryParent.ItemDate = ItemDate;
InitialCategoryParent.IsAvailable = IsAvailable;
InitialCategoryParent.YoutubeCode = YoutubeCode;
InitialCategoryParent.GoogleLatitude = GoogleLatitude;
InitialCategoryParent.GoogleLongitude = GoogleLongitude;
#endregion
#region InitialCategoryArDetails
InitialCategoryArDetails = new ItemCategoriesDetailsEntity();
//InitialCategoryArDetails.CategoryID = InitialCategory.CategoryID;
InitialCategoryArDetails.LangID = Languages.Ar;
InitialCategoryArDetails.Title = ArCategoryTitle;
InitialCategoryArDetails.ShortDescription = ArItemShortDescrpyion;
InitialCategoryArDetails.Description = ArItemDetails;
InitialCategoryArDetails.KeyWords = ArItemSeoKeyWords;
#endregion
#region InitialCategoryEnDetails
InitialCategoryEnDetails = new ItemCategoriesDetailsEntity();
//InitialCategoryEnDetails.CategoryID = InitialCategory.CategoryID;
InitialCategoryEnDetails.LangID = Languages.En;
InitialCategoryEnDetails.Title = EnCategoryTitle;
InitialCategoryEnDetails.ShortDescription = EnItemShortDescrpyion;
InitialCategoryEnDetails.Description = EnItemDetails;
InitialCategoryEnDetails.KeyWords = EnItemSeoKeyWords;
#endregion
#region InitialArComment
InitialArComment = new ItemsCommentsEntity();
//InitialArComment.CommentID
//InitialArComment.ItemID
InitialArComment.LangID = Languages.Ar;
//InitialArComment.ModuleTypeID
//InitialArComment.BaseModuleType
InitialArComment.SenderName = ArSenderName;
InitialArComment.CountryID = SenderCountryID;
//InitialArComment.CtryShort
InitialArComment.SendingDate = DateTime.Now;
InitialArComment.SenderEmail = SenderEMail;
InitialArComment.CommentTitle = ArCommentTitle;
InitialArComment.CommentText = ArItemDetails;
InitialArComment.IsActive = IsAvailable;
InitialArComment.IsSeen = IsSeen;
#endregion
#region InitialEnComment
InitialEnComment = new ItemsCommentsEntity();
//InitialEnComment.CommentID
//InitialEnComment.ItemID
InitialEnComment.LangID = Languages.En;
//InitialEnComment.ModuleTypeID
//InitialEnComment.BaseModuleType
InitialEnComment.SenderName = EnSenderName;
InitialEnComment.CountryID = SenderCountryID;
//InitialEnComment.CtryShort
InitialEnComment.SendingDate = DateTime.Now;
InitialEnComment.SenderEmail = SenderEMail;
InitialEnComment.CommentTitle = EnCommentTitle;
InitialEnComment.CommentText = EnItemDetails;
InitialArComment.IsActive = IsAvailable;
InitialArComment.IsSeen = IsSeen;
#endregion
#region InitialArMessages
InitialArMessages = new MessagesEntity();
//InitialArMessages.MessageID=;
//InitialArMessages.ModuleTypeID
//InitialArMessages.CategoryID ;
InitialArMessages.Name = ArSenderName;
InitialArMessages.Mobile = Mobile;
InitialArMessages.EMail = Email;
InitialArMessages.NationalityID = SiteSettings.Admininstration_SiteDefaultCountryID;
InitialArMessages.CountryID = SiteSettings.Admininstration_SiteDefaultCountryID;
InitialArMessages.Address = ArItemAddress;
InitialArMessages.JobTel = JobTel;
InitialArMessages.Type = Type;
InitialArMessages.Title = ArMessageTitle;
InitialArMessages.Details = ArItemDetails;
InitialArMessages.ShortDescription = ArItemShortDescrpyion;
InitialArMessages.Reply = ArItemDetails;
InitialArMessages.ReplyDate = DateTime.Now;
InitialArMessages.IsAvailable = IsAvailable;
InitialArMessages.IsSeen = IsSeen;
InitialArMessages.IsReplied = IsReplied;
InitialArMessages.LangID = Languages.Ar;
InitialArMessages.Gender = Gender.Male;
InitialArMessages.BirthDate = BirthDate;
InitialArMessages.CityID = CityID;
InitialArMessages.UserCityName = UserCityNameAr;
InitialArMessages.Tel = Tels;
InitialArMessages.Fax = Fax;
InitialArMessages.MailBox = MailBox;
InitialArMessages.ZipCode = ZipCode;
InitialArMessages.JobID = JobID;
InitialArMessages.JobText = JobTextAr;
InitialArMessages.Company = CompanyAr;
InitialArMessages.ActivitiesID = ActivitiesID;
InitialArMessages.Url = Url;
//InitialArMessages.PhotoExtension
InitialArMessages.SocialStatus = SocialStatus;
InitialArMessages.EducationLevel = EducationLevel;
InitialArMessages.EmpNo = EmpNo;
InitialArMessages.HasSmsService = HasSmsService;
InitialArMessages.HasEmailService = HasEmailService;
//InitialArMessages.Notes1
//InitialArMessages.Notes2
InitialArMessages.AgeRang = AgeRang;
InitialArMessages.ItemDate = ItemDate;
InitialArMessages.YoutubeCode = YoutubeCode;
InitialArMessages.GoogleLatitude = GoogleLatitude.ToString();
InitialArMessages.GoogleLongitude = GoogleLongitude.ToString();
InitialArMessages.Price = Price;
InitialArMessages.KeyWords = ArItemSeoKeyWords;
InitialArMessages.LastModification = DateTime.Now;
#endregion
#region InitialEnMessages
InitialEnMessages = new MessagesEntity();
//InitialEnMessages.MessageID=;
//InitialEnMessages.ModuleTypeID
//InitialEnMessages.CategoryID ;
InitialEnMessages.Name = EnSenderName;
InitialEnMessages.Mobile = Mobile;
InitialEnMessages.EMail = Email;
InitialEnMessages.NationalityID = SiteSettings.Admininstration_SiteDefaultCountryID;
InitialEnMessages.CountryID = SiteSettings.Admininstration_SiteDefaultCountryID;
InitialEnMessages.Address = EnItemAddress;
InitialEnMessages.JobTel = JobTel;
InitialEnMessages.Type = Type;
InitialEnMessages.Title = EnMessageTitle;
InitialEnMessages.Details = EnItemDetails;
InitialEnMessages.ShortDescription = EnItemShortDescrpyion;
InitialEnMessages.Reply = EnItemDetails;
InitialEnMessages.ReplyDate = DateTime.Now;
InitialEnMessages.IsAvailable = IsAvailable;
InitialEnMessages.IsSeen = IsSeen;
InitialEnMessages.IsReplied = IsReplied;
InitialEnMessages.LangID = Languages.En;
InitialEnMessages.Gender = Gender.Male;
InitialEnMessages.BirthDate = BirthDate;
InitialEnMessages.CityID = CityID;
InitialEnMessages.UserCityName = UserCityNameEn;
InitialEnMessages.Tel = Tels;
InitialEnMessages.Fax = Fax;
InitialEnMessages.MailBox = MailBox;
InitialEnMessages.ZipCode = ZipCode;
InitialEnMessages.JobID = JobID;
InitialEnMessages.JobText = JobTextEn;
InitialEnMessages.Company = CompanyEn;
InitialEnMessages.ActivitiesID = ActivitiesID;
InitialEnMessages.Url = Url;
//InitialEnMessages.PhotoExtension
InitialEnMessages.SocialStatus = SocialStatus;
InitialEnMessages.EducationLevel = EducationLevel;
InitialEnMessages.EmpNo = EmpNo;
InitialEnMessages.HasSmsService = HasSmsService;
InitialEnMessages.HasEmailService = HasEmailService;
//InitialEnMessages.Notes1
//InitialEnMessages.Notes2
InitialEnMessages.AgeRang = AgeRang;
InitialEnMessages.ItemDate = ItemDate;
InitialEnMessages.YoutubeCode = YoutubeCode;
InitialEnMessages.GoogleLatitude = GoogleLatitude.ToString();
InitialEnMessages.GoogleLongitude = GoogleLongitude.ToString();
InitialEnMessages.Price = Price;
InitialEnMessages.KeyWords = EnItemSeoKeyWords;
InitialEnMessages.LastModification = DateTime.Now;
#endregion
}
//------------------------------------------
#endregion
#region --------------Create--------------
/// <summary>
/// Converts the ItemCategories object properties to SQL paramters and executes the create ItemCategories procedure
/// and updates the ItemCategories object with the SQL data by reference.
/// <example>[Example]bool status=ItemCategoriesSqlDataPrvider.Instance.Create(itemCategoriesObject);.</example>
/// </summary>
/// <param name="itemCategoriesObject">The ItemCategories object.</param>
/// <returns>The status of create query.</returns>
public ExecuteCommandStatus Create(ItemCategoriesEntity itemCategoriesObject, ItemsModulesOptions currentModule)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemCategories_Create", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@PhotoExtension", SqlDbType.VarChar, 5).Value = itemCategoriesObject.PhotoExtension;
myCommand.Parameters.Add("@IsAvailable", SqlDbType.Bit, 1).Value = itemCategoriesObject.IsAvailable;
myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)itemCategoriesObject.ModuleTypeID;
myCommand.Parameters.Add("@ParentID", SqlDbType.Int, 4).Value = (int)itemCategoriesObject.ParentID;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@InsertUserName", SqlDbType.NVarChar, 64).Value = (string)itemCategoriesObject.InsertUserName;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@TypeID", SqlDbType.Int, 4).Value = itemCategoriesObject.TypeID;
//----------------------------------------------------------------------------------
//New Columns
//--------------------------------------
//-----------------------------
if (itemCategoriesObject.ItemDate != DateTime.MinValue)
{
myCommand.Parameters.Add("@ItemDate", SqlDbType.DateTime).Value = (DateTime)itemCategoriesObject.ItemDate;
}
else
{
myCommand.Parameters.Add("@ItemDate", SqlDbType.DateTime).Value = DBNull.Value;
}
//-----------------------------
myCommand.Parameters.Add("@IsMain", SqlDbType.Bit, 1).Value = itemCategoriesObject.IsMain;
myCommand.Parameters.Add("@Priority", SqlDbType.Int, 4).Value = (int)itemCategoriesObject.Priority;
myCommand.Parameters.Add("@Photo2Extension", SqlDbType.VarChar, 5).Value = itemCategoriesObject.Photo2Extension;
myCommand.Parameters.Add("@VideoExtension", SqlDbType.VarChar, 5).Value = itemCategoriesObject.VideoExtension;
myCommand.Parameters.Add("@AudioExtension", SqlDbType.VarChar, 5).Value = itemCategoriesObject.AudioExtension;
myCommand.Parameters.Add("@FileExtension", SqlDbType.VarChar, 5).Value = itemCategoriesObject.FileExtension;
myCommand.Parameters.Add("@Height", SqlDbType.Int, 4).Value = (int)itemCategoriesObject.Height;
myCommand.Parameters.Add("@Width", SqlDbType.Int, 4).Value = (int)itemCategoriesObject.Width;
myCommand.Parameters.Add("@YoutubeCode", SqlDbType.VarChar).Value = (string)itemCategoriesObject.YoutubeCode;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@GoogleLatitude", SqlDbType.Float).Value = itemCategoriesObject.GoogleLatitude;
myCommand.Parameters.Add("@GoogleLongitude", SqlDbType.Float).Value = itemCategoriesObject.GoogleLongitude;
myCommand.Parameters.Add("@OnlyForRegisered", SqlDbType.Bit).Value = itemCategoriesObject.OnlyForRegisered;
//-------------------------------------
myCommand.Parameters.Add("@PublishPhoto", SqlDbType.Bit).Value = itemCategoriesObject.PublishPhoto;
myCommand.Parameters.Add("@PublishPhoto2", SqlDbType.Bit).Value = itemCategoriesObject.PublishPhoto2;
myCommand.Parameters.Add("@PublishFile", SqlDbType.Bit).Value = itemCategoriesObject.PublishFile;
myCommand.Parameters.Add("@PublishAudio", SqlDbType.Bit).Value = itemCategoriesObject.PublishAudio;
myCommand.Parameters.Add("@PublishVideo", SqlDbType.Bit).Value = itemCategoriesObject.PublishVideo;
myCommand.Parameters.Add("@PublishYoutbe", SqlDbType.Bit).Value = itemCategoriesObject.PublishYoutbe;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = itemCategoriesObject.OwnerID;
myCommand.Parameters.Add("@OwnerName", SqlDbType.VarChar).Value = itemCategoriesObject.OwnerName;
//----------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar();
if (status == ExecuteCommandStatus.Done)
{
itemCategoriesObject.CategoryID = (int)myCommand.Parameters["@CategoryID"].Value;
status = SaveDetails(itemCategoriesObject, currentModule.AllowDublicateTitlesInCategories, SPOperation.Insert);
}
myConnection.Close();
return(status);
//----------------------------------------------------------------------------------
}
}