//--------------------------------------------------------------------------- #endregion #region ---------------------------RegisterInSms--------------------------- //--------------------------------------------------------------------------- public static void RegisterInSms(MessagesEntity msg) { MessagesModuleOptions msgModule = MessagesModuleOptions.GetType(msg.ModuleTypeID); Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID; SMSNumbersFactory.RegisterInSms(msg.ModuleTypeID, msg.Mobile, langID, msgModule.SmsAutomaticActivation); }
//---------------------------------------------------------------------------- #endregion #region --------------------------SetMetaTags---------------------------- //---------------------------------------------------------------------------- //SetMetaTags //---------------------------------------------------------------------------- public static void SetMetaTags(MessagesEntity msg) { DCMetaBuilder metaBuilder = DCMetaBuilder.Instance; string siteName = SiteTextsManager.Instance.SiteName.Trim(); //------------------------------------------------------------ metaBuilder.Title = msg.Title; //------------------------------------------------------------ if (!string.IsNullOrEmpty(msg.KeyWords)) { metaBuilder.Keywords = msg.KeyWords; } //------------------------------------------------------------ if (!string.IsNullOrEmpty(msg.ShortDescription)) { metaBuilder.Description = msg.ShortDescription; } //------------------------------------------------------------ if (!string.IsNullOrEmpty(msg.Name)) { metaBuilder.Author = msg.Name + " , " + siteName; } //------------------------------------------------------------ metaBuilder.PubDate = msg.Date_Added.ToUniversalTime().ToString(); //------------------------------------------------------------ metaBuilder.LastModification = msg.LastModification.ToUniversalTime().ToString(); //------------------------------------------------------------ metaBuilder.Source = siteName; //------------------------------------------------------------ }
public MessagesEntity GetMessagesObject(int messageID, UsersTypes viewerType, Guid OwnerID) { MessagesEntity msg = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("Messages_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ViewerType ", SqlDbType.Int, 4).Value = (int)viewerType; myCommand.Parameters.Add("@MessageID", SqlDbType.Int, 4).Value = messageID; //--------------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = OwnerID; //--------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { //msg = PopulateEntity(dr); msg = (MessagesEntity)GetEntity(dr, typeof(MessagesEntity)); } dr.Close(); } myConnection.Close(); return(msg); } }
//------------------------------------------ #endregion #region ---------------------------RegisterInMailList--------------------------- //--------------------------------------------------------------------------- public static void RegisterInMailList(MessagesEntity msg) { MessagesModuleOptions msgModule = MessagesModuleOptions.GetType(msg.ModuleTypeID); Languages langID = (Languages)SiteSettings.Languages_DefaultLanguageID; MailListUsersFactory.RegisterInMailList(msg.ModuleTypeID, msg.EMail, langID, msgModule.MailListAutomaticActivation, msgModule.MailListSendingMailActivation); }
//------------------------------------------ #endregion #region --------------GetMessagesObject-------------- public static MessagesEntity GetMessagesObject(int messageID, UsersTypes viewerType, Guid OwnerID) { MessagesEntity msg = MessagesSqlDataPrvider.Instance.GetMessagesObject(messageID, viewerType, OwnerID); //return the object return(msg); }
/// <summary> /// Creates Messages object by calling Messages data provider create method. /// <example>[Example]bool status=MessagesFactory.Create(msg);.</example> /// </summary> /// <param name="msg">The Messages object.</param> /// <returns>Status of create operation.</returns> public static bool Create(MessagesEntity msg, bool createMsgFolder) { //Insert user name------------------------------------------ string username = ""; if (HttpContext.Current.User.Identity.IsAuthenticated) { username = HttpContext.Current.User.Identity.Name; msg.InsertUserName = username; } //---------------------------------------------------------- bool status = MessagesSqlDataPrvider.Instance.Create(msg); //------------------------------------- if (status && createMsgFolder) { // Create msg folder string folder = DCSiteUrls.GetPath_MessagesDirectory(msg.OwnerName, msg.ModuleTypeID, msg.CategoryID, msg.MessageID); string folderPhysicalPath = DCServer.MapPath(folder); if (!Directory.Exists(folderPhysicalPath)) { string defaultFolder = DCSiteUrls.GetPath_DefaultMessageFolder(); string defaultFolderPhysicalPath = DCServer.MapPath(defaultFolder); DirectoryInfo diSource = new DirectoryInfo(defaultFolderPhysicalPath); DirectoryInfo diTarget = new DirectoryInfo(folderPhysicalPath); DcDirectoryManager.CopyAll(diSource, diTarget); } } //------------------------------------- return(status); }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Updates Messages object by calling Messages data provider update method. /// <example>[Example]bool status=MessagesFactory.Update(msg);.</example> /// </summary> /// <param name="msg">The Messages object.</param> /// <returns>Status of update operation.</returns> public static bool Update(MessagesEntity msg) { //Update user name------------------------------------------ string username = ""; if (HttpContext.Current.User.Identity.IsAuthenticated) { username = HttpContext.Current.User.Identity.Name; msg.LastUpdateUserName = username; } //---------------------------------------------------------- bool status = MessagesSqlDataPrvider.Instance.Update(msg); return(status); }
//------------------------------------------ #endregion #region --------------Delete-------------- /// <summary> /// Deletes single Messages object . /// <example>[Example]bool status=MessagesFactory.Delete(messageID);.</example> /// </summary> /// <param name="messageID">The msg id.</param> /// <returns>Status of delete operation.</returns> public static bool Delete(int messageID) { MessagesEntity msg = MessagesFactory.GetMessagesObject(messageID, UsersTypes.Admin, SitesHandler.GetOwnerIDAsGuid()); bool status = MessagesSqlDataPrvider.Instance.Delete(messageID); //------------------------------------- if (status) { //delete message folder //------------------------------------- string folder = DCSiteUrls.GetPath_MessagesDirectory(msg.OwnerName, msg.ModuleTypeID, msg.CategoryID, msg.MessageID); string folderPhysicalPath = DCServer.MapPath(folder); if (Directory.Exists(folderPhysicalPath)) { DirectoryInfo dir = new DirectoryInfo(folderPhysicalPath); DcDirectoryManager.DeletDirectory(dir); } } //------------------------------------- return(status); }
//--------------------------------------------------------------------------- public static void UpdateSmsMobileNo(string oldMobile, MessagesEntity msg) { SMSNumbersEntity smsUser = SMSNumbersFactory.GetObject(msg.ModuleTypeID, oldMobile); if (smsUser != null) { if (!string.IsNullOrEmpty(msg.Mobile)) { smsUser.Numbers = msg.Mobile; SMSNumbersFactory.Update(smsUser); } else { SMSNumbersFactory.Delete(smsUser.NumID); } } else { MessagesFactory.RegisterInSms(msg); } }
//--------------------------------------------------------------------------- public static void UpdateMailListEmail(string oldEmail, MessagesEntity msg) { MailListUsersEntity mlUser = MailListUsersFactory.GetObject(msg.ModuleTypeID, oldEmail); if (mlUser != null) { if (!string.IsNullOrEmpty(msg.EMail)) { mlUser.Email = msg.EMail; MailListUsersFactory.Update(mlUser); } else { MailListUsersFactory.Delete(mlUser.UserID); } } else { MessagesFactory.RegisterInMailList(msg); } }
public static void AddTitlePath(PathLinksClass pc, Label lblTitle) { if (MoversFW.Components.UrlManager.ChechIsValidIntegerParameter("id")) { int messageID = Convert.ToInt32(HttpContext.Current.Request.QueryString["id"]); Languages lang = SiteSettings.GetCurrentLanguage(); MessagesEntity msg = MessagesFactory.GetMessagesObject(messageID, UsersTypes.Admin, SitesHandler.GetOwnerIDAsGuid()); if (msg != null) { if (pc != null) { pc.AddLink(msg.Title, null); } if (lblTitle != null) { lblTitle.Text = msg.Title; } } } }
//------------------------------------------------------- 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 Messages object properties to SQL paramters and executes the create Messages procedure /// and updates the Messages object with the SQL data by reference. /// <example>[Example]bool status=MessagesSqlDataPrvider.Instance.Create(msg);.</example> /// </summary> /// <param name="msg">The Messages object.</param> /// <returns>The status of create query.</returns> public bool Create(MessagesEntity msg) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("Messages_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@MessageID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 128).Value = msg.Name; myCommand.Parameters.Add("@Mobile", SqlDbType.NVarChar, 32).Value = msg.Mobile; myCommand.Parameters.Add("@EMail", SqlDbType.VarChar, 128).Value = msg.EMail; myCommand.Parameters.Add("@NationalityID", SqlDbType.Int, 4).Value = msg.NationalityID; myCommand.Parameters.Add("@CountryID", SqlDbType.Int, 4).Value = msg.CountryID; myCommand.Parameters.Add("@Address", SqlDbType.NVarChar, 256).Value = msg.Address; myCommand.Parameters.Add("@JobTel", SqlDbType.NVarChar, 32).Value = msg.JobTel; myCommand.Parameters.Add("@Type", SqlDbType.Int, 4).Value = msg.Type; myCommand.Parameters.Add("@Title", SqlDbType.NVarChar, 128).Value = msg.Title; myCommand.Parameters.Add("@Details", SqlDbType.NText).Value = msg.Details; myCommand.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = msg.UserId; myCommand.Parameters.Add("@ToItemID", SqlDbType.Int, 4).Value = msg.ToItemID; myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)msg.ModuleTypeID; //------------------------------------------------------ myCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Value = msg.CategoryID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)msg.LangID; myCommand.Parameters.Add("@ToUserID", SqlDbType.UniqueIdentifier).Value = msg.ToUserID; //------------------------------------------------------ myCommand.Parameters.Add("@EmpNo", SqlDbType.Int, 4).Value = msg.EmpNo; myCommand.Parameters.Add("@Gender", SqlDbType.Int, 4).Value = (int)msg.Gender; myCommand.Parameters.Add("@BirthDate", SqlDbType.VarChar, 32).Value = msg.BirthDate; myCommand.Parameters.Add("@SocialStatus", SqlDbType.Int, 4).Value = msg.SocialStatus; myCommand.Parameters.Add("@EducationLevel", SqlDbType.Int, 4).Value = msg.EducationLevel; myCommand.Parameters.Add("@CityID", SqlDbType.Int, 4).Value = msg.CityID; myCommand.Parameters.Add("@UserCityName", SqlDbType.NVarChar).Value = msg.UserCityName; myCommand.Parameters.Add("@Tel", SqlDbType.NVarChar, 32).Value = msg.Tel; myCommand.Parameters.Add("@HasSmsService", SqlDbType.Bit, 1).Value = msg.HasSmsService; myCommand.Parameters.Add("@HasEmailService", SqlDbType.Bit, 1).Value = msg.HasEmailService; myCommand.Parameters.Add("@AgeRang", SqlDbType.Int, 4).Value = msg.AgeRang; //------------------------------------------------------ myCommand.Parameters.Add("@Notes1", SqlDbType.NVarChar, 512).Value = msg.Notes1; myCommand.Parameters.Add("@Notes2", SqlDbType.NVarChar, 512).Value = msg.Notes2; //------------------------------------------------------ myCommand.Parameters.Add("@Fax", SqlDbType.NVarChar, 32).Value = msg.Fax; myCommand.Parameters.Add("@MailBox", SqlDbType.NVarChar, 32).Value = msg.MailBox; myCommand.Parameters.Add("@ZipCode", SqlDbType.NVarChar, 32).Value = msg.ZipCode; myCommand.Parameters.Add("@JobID", SqlDbType.Int, 4).Value = msg.JobID; myCommand.Parameters.Add("@JobText", SqlDbType.NVarChar, 64).Value = msg.JobText; myCommand.Parameters.Add("@Url", SqlDbType.NVarChar, 128).Value = msg.Url; myCommand.Parameters.Add("@PhotoExtension", SqlDbType.VarChar, 5).Value = msg.PhotoExtension; //------------------------------------------------------ myCommand.Parameters.Add("@Company", SqlDbType.NVarChar, 64).Value = msg.Company; myCommand.Parameters.Add("@ActivitiesID", SqlDbType.Int, 4).Value = msg.ActivitiesID; myCommand.Parameters.Add("@ExtraData", SqlDbType.NVarChar).Value = OurSerializer.Serialize(msg.ExtraData); //------------------------------------------------------ myCommand.Parameters.Add("@FileExtension", SqlDbType.VarChar, 5).Value = msg.FileExtension; //------------------------------------------------------ //New Parameters //----------------- myCommand.Parameters.Add("@IsMain", SqlDbType.Bit).Value = msg.IsMain; myCommand.Parameters.Add("@VideoExtension", SqlDbType.VarChar, 5).Value = msg.VideoExtension; myCommand.Parameters.Add("@AudioExtension", SqlDbType.VarChar, 5).Value = msg.AudioExtension; myCommand.Parameters.Add("@Priority", SqlDbType.Int, 4).Value = (int)msg.Priority; myCommand.Parameters.Add("@Photo2Extension", SqlDbType.VarChar, 5).Value = msg.Photo2Extension; myCommand.Parameters.Add("@Height", SqlDbType.Int, 4).Value = msg.Height; myCommand.Parameters.Add("@Width", SqlDbType.Int, 4).Value = msg.Width; //---------------------------------------------------------------------------------- if (msg.ItemDate != DateTime.MinValue) { myCommand.Parameters.Add("@ItemDate", SqlDbType.DateTime).Value = (DateTime)msg.ItemDate; } else { myCommand.Parameters.Add("@ItemDate", SqlDbType.DateTime).Value = DBNull.Value; } //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@InsertUserName", SqlDbType.NVarChar, 64).Value = (string)msg.InsertUserName; myCommand.Parameters.Add("@YoutubeCode", SqlDbType.VarChar, 16).Value = (string)msg.YoutubeCode; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@GoogleLatitude", SqlDbType.NVarChar).Value = msg.GoogleLatitude; myCommand.Parameters.Add("@GoogleLongitude", SqlDbType.NVarChar).Value = msg.GoogleLongitude; myCommand.Parameters.Add("@Price", SqlDbType.NVarChar, 128).Value = msg.Price; myCommand.Parameters.Add("@OnlyForRegisered", SqlDbType.Bit).Value = msg.OnlyForRegisered; //------------------------------------- myCommand.Parameters.Add("@PublishPhoto", SqlDbType.Bit).Value = msg.PublishPhoto; myCommand.Parameters.Add("@PublishPhoto2", SqlDbType.Bit).Value = msg.PublishPhoto2; myCommand.Parameters.Add("@PublishFile", SqlDbType.Bit).Value = msg.PublishFile; myCommand.Parameters.Add("@PublishAudio", SqlDbType.Bit).Value = msg.PublishAudio; myCommand.Parameters.Add("@PublishVideo", SqlDbType.Bit).Value = msg.PublishVideo; myCommand.Parameters.Add("@PublishYoutbe", SqlDbType.Bit).Value = msg.PublishYoutbe; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@ShortDescription", SqlDbType.NText).Value = msg.ShortDescription; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = msg.OwnerID; myCommand.Parameters.Add("@OwnerName", SqlDbType.VarChar).Value = msg.OwnerName; //---------------------------------------------------------------------------------- myCommand.Parameters.Add("@KeyWords", SqlDbType.NVarChar, 256).Value = msg.KeyWords; //---------------------------------------------------------------------------------- // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; //Get ID value from database and set it in object msg.MessageID = (int)myCommand.Parameters["@MessageID"].Value; } myConnection.Close(); return(status); } }
//--------------------------------------------------------------------------- public static void UnRegisterInSms(MessagesEntity msg) { SMSNumbersFactory.Delete(msg.ModuleTypeID, msg.Mobile); }
//--------------------------------------------------------------------------- public static void UnRegisterInMailList(MessagesEntity msg) { MailListUsersFactory.Delete(msg.ModuleTypeID, msg.EMail); }