//------------------------------------------ #endregion #region --------------Delete-------------- /// <summary> /// Deletes single UsersData object . /// <example>[Example]bool status=UsersDataFactory.Delete(userProfileID);.</example> /// </summary> /// <param name="userProfileID">The usersDataObject id.</param> /// <returns>Status of delete operation.</returns> public static bool Delete(Guid userID) { UsersDataEntity usersDataObject = GetUsersDataObject(userID, SitesHandler.GetOwnerIDAsGuid()); bool status = UsersDataSqlDataPrvider.Instance.Delete(userID); if (status) { MembershipUser user = Membership.GetUser(userID); Membership.DeleteUser(user.UserName, true); //------------------------------------------------ //DeleteFiles(usersDataObject); //------------------------------------------------ UsersDataFactory.DeleteUserFolder(user, usersDataObject); //------------------------------------------------------------------------ } 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 --------------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 static void IncreaseSubSiteVisites() { HttpContext context = HttpContext.Current; OwnerInterfaceType interfaceType = SitesHandler.GetOwnerInterfaceType(); if (interfaceType == OwnerInterfaceType.SubSites) { Guid OwnerID = SitesHandler.GetOwnerIDAsGuid(); string OwnerIdentifire = SitesHandler.GetOwnerIdentifire(); //-------------------------------------- List <string> visitorSubSites = null; try { visitorSubSites = (List <string>)context.Session["VisitorSubSites"]; } catch { } //-------------------------------------- if (visitorSubSites == null) { visitorSubSites = new List <string>(); } //-------------------------------------- foreach (string site in visitorSubSites) { if (OwnerIdentifire == site) { return; } } //-------------------------------------- UsersDataFactory.IncreaseVisits(OwnerID); visitorSubSites.Add(OwnerIdentifire); context.Session["VisitorSubSites"] = visitorSubSites; } }
//------------------------------------------ /// <summary> /// Converts the SMSArchive object properties to SQL paramters and executes the create SMSArchive procedure /// and updates the SMSArchive object with the SQL data by reference. /// <example>[Example]bool result=SMSArchiveSqlDataPrvider.Instance.Create(sMSArchive);.</example> /// </summary> /// <param name="sMSArchive">The SMSArchive object.</param> /// <returns>The result of create query.</returns> public bool Create(SMSArchiveEntity sMSArchive) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSArchive_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@Sender", SqlDbType.NVarChar, 20).Value = sMSArchive.Sender; myCommand.Parameters.Add("@RecieverMobile", SqlDbType.NVarChar, 20).Value = sMSArchive.RecieverMobile; myCommand.Parameters.Add("@Message", SqlDbType.NVarChar, 500).Value = sMSArchive.Message; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)sMSArchive.LangID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; //Get ID value from database and set it in object sMSArchive.ID = (int)myCommand.Parameters["@ID"].Value; } myConnection.Close(); return(result); } }
//---------------------------------------------------------------------------- /// <summary> /// Gets single SMSNumbers object . /// <example>[Example]SMSNumbersEntity sMSNumbers=SMSNumbersSqlDataPrvider.Instance.GetObject(numID);.</example> /// </summary> /// <param name="numID">The sMSNumbers id.</param> /// <returns>SMSNumbers object.</returns> public SMSNumbersEntity GetObject(long numID) { SMSNumbersEntity sMSNumbers = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSNumbers_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Value = numID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { sMSNumbers = PopulateEntity(dr); } dr.Close(); } myConnection.Close(); return(sMSNumbers); } }
//------------------------------------------ /// <summary> /// Gets single SMSArchive object . /// <example>[Example]SMSArchiveEntity sMSArchive=SMSArchiveSqlDataPrvider.Instance.GetSMSArchiveObject(id);.</example> /// </summary> /// <param name="id">The sMSArchive id.</param> /// <returns>SMSArchive object.</returns> public SMSArchiveEntity GetSMSArchiveObject(int id) { SMSArchiveEntity sMSArchive = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSArchive_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Value = id; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { sMSArchive = PopulateSMSArchiveEntityFromIDataReader(dr); } dr.Close(); } myConnection.Close(); return(sMSArchive); } }
/// <summary> /// Gets All SMSCredit Records. /// <example>[Example]DataTable dtSMSCredit=SMSCreditSqlDataPrvider.Instance.GetAllSMSCredit();.</example> /// </summary> /// <returns>The result of query.</returns> public DataTable GetAllSMSCredit() { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSCredit_GetAll", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- SqlDataAdapter da = new SqlDataAdapter(myCommand); DataTable dt = new DataTable(); // Execute the command myConnection.Open(); da.Fill(dt); myConnection.Close(); return(dt); } }
//------------------------------------------ public bool Delete(int ModuleTypeID, string mobileNo) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSNumbers_DeleteByNo", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ModuleTypeID; myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = mobileNo; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; } myConnection.Close(); return(result); } }
//------------------------------------------ #endregion #region --------------Save-------------- public bool Save(VoteQuestionsEntity voteQuestions, SPOperation operation) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("VoteQuestions_Save", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@SPOperation", SqlDbType.Int, 4).Value = (int)operation; if (operation == SPOperation.Insert) { myCommand.Parameters.Add("@QuesID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; } else { myCommand.Parameters.Add("@QuesID", SqlDbType.Int, 4).Value = voteQuestions.QuesID; } myCommand.Parameters.Add("@QuestionText", SqlDbType.NVarChar, 128).Value = voteQuestions.QuestionText; myCommand.Parameters.Add("@LangID", SqlDbType.Int).Value = (int)voteQuestions.LangID; myCommand.Parameters.Add("@AnswersCount", SqlDbType.Int, 4).Value = voteQuestions.AnswersCount; myCommand.Parameters.Add("@IsMain", SqlDbType.Bit, 1).Value = voteQuestions.IsMain; myCommand.Parameters.Add("@IsClosed", SqlDbType.Bit, 1).Value = voteQuestions.IsClosed; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; //Get ID value from database and set it in object voteQuestions.QuesID = (int)myCommand.Parameters["@QuesID"].Value; } myConnection.Close(); return(status); } }
public MailListGroupsEntity GetObject(int groupID) { MailListGroupsEntity mailListGroups = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("MailListGroups_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = groupID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { mailListGroups = PopulateEntity(dr); } dr.Close(); } myConnection.Close(); return(mailListGroups); } }
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); //---------------------------------------------------------------- } }
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); } }
//------------------------------------------ #endregion #region -------------GetSiteDeparmentsInDataTable--------------- public DataTable GetSiteDeparmentsInDataTable(int moduleTypeID, int parentID, Languages langID, bool isAvailableCondition) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SiteDeparments_GetAll", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------- myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)moduleTypeID; myCommand.Parameters.Add("@ParentID", SqlDbType.Int, 4).Value = parentID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; myCommand.Parameters.Add("@SiteHasMultiLanguages", SqlDbType.Bit).Value = SiteSettings.Languages_HasMultiLanguages; myCommand.Parameters.Add("@IsAvailableCondition", SqlDbType.Bit, 1).Value = isAvailableCondition; myCommand.Parameters.Add("@pageIndex", SqlDbType.Int, 4).Value = -1; myCommand.Parameters.Add("@pageSize", SqlDbType.Int, 4).Value = -1; myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int, 4).Direction = ParameterDirection.Output; //---------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------- // Execute the command SqlDataAdapter da = new SqlDataAdapter(myCommand); DataTable dt = new DataTable(); myConnection.Open(); da.Fill(dt); myConnection.Close(); return(dt); //---------------------------------------------------------------- } }
public List <SiteDeparmentsEntity> GetAll(int moduleTypeID, int parentID, Languages langID, bool isAvailableCondition, int pageIndex, int pageSize, out int totalRecords) { using (SqlConnection myConnection = GetSqlConnection()) { List <SiteDeparmentsEntity> siteDeparmentsList = new List <SiteDeparmentsEntity>(); SiteDeparmentsEntity siteDeparmentsObject; //Hashtable temp = new Hashtable(); SqlCommand myCommand = new SqlCommand("SiteDeparments_GetAll", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)moduleTypeID; myCommand.Parameters.Add("@ParentID", SqlDbType.Int, 4).Value = parentID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; myCommand.Parameters.Add("@SiteHasMultiLanguages", SqlDbType.Bit).Value = SiteSettings.Languages_HasMultiLanguages; myCommand.Parameters.Add("@IsAvailableCondition", SqlDbType.Bit, 1).Value = isAvailableCondition; myCommand.Parameters.Add("@pageIndex", SqlDbType.Int, 4).Value = pageIndex; myCommand.Parameters.Add("@pageSize", SqlDbType.Int, 4).Value = pageSize; myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int, 4).Direction = ParameterDirection.Output; //---------------------------------------------------------------- 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); //if (!temp.Contains(siteDeparmentsObject.DepartmentID)) //{ // siteDeparmentsList.Add(siteDeparmentsObject); // temp.Add(siteDeparmentsObject.DepartmentID, null); //} siteDeparmentsObject = (SiteDeparmentsEntity)GetEntity(dr, typeof(SiteDeparmentsEntity)); siteDeparmentsList.Add(siteDeparmentsObject); } dr.Close(); myConnection.Close(); //Gets result rows count totalRecords = (int)myCommand.Parameters["@TotalRecords"].Value; if (totalRecords < 0) { totalRecords = siteDeparmentsList.Count; } return(siteDeparmentsList); //---------------------------------------------------------------- } }
//------------------------------------------ /// <summary> /// Converts the SMSNumbers object properties to SQL paramters and executes the update SMSNumbers procedure. /// <example>[Example]bool result=SMSNumbersSqlDataPrvider.Instance.Update(sMSNumbers);.</example> /// </summary> /// <param name="sMSNumbers">The SMSNumbers object.</param> /// <returns>The result of update query.</returns> public ExecuteCommandStatus Update(SMSNumbersEntity sMSNumbers) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSNumbers_Update", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Value = sMSNumbers.NumID; myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = sMSNumbers.Numbers; myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = sMSNumbers.GroupID; myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 200).Value = sMSNumbers.Name; myCommand.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = sMSNumbers.IsActive; myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)sMSNumbers.ModuleTypeID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar(); myConnection.Close(); return(status); } }
//------------------------------------------ /// <summary> /// Converts the SMSNumbers object properties to SQL paramters and executes the create SMSNumbers procedure /// and updates the SMSNumbers object with the SQL data by reference. /// <example>[Example]bool result=SMSNumbersSqlDataPrvider.Instance.Create(sMSNumbers);.</example> /// </summary> /// <param name="sMSNumbers">The SMSNumbers object.</param> /// <returns>The result of create query.</returns> public ExecuteCommandStatus Create(SMSNumbersEntity sMSNumbers) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSNumbers_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = sMSNumbers.Numbers; myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 200).Value = sMSNumbers.Name; myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = sMSNumbers.GroupID; //-------------------------------------------------------------------------------- myCommand.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = sMSNumbers.IsActive; //myCommand.Parameters.Add("@JoinDate", SqlDbType.DateTime,8).Value = mailListUsers.JoinDate; myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)sMSNumbers.ModuleTypeID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)sMSNumbers.LangID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar(); if (status == ExecuteCommandStatus.Done) { //Get ID value from database and set it in object sMSNumbers.NumID = (long)myCommand.Parameters["@NumID"].Value; } myConnection.Close(); return(status); } }
//------------------------------------------ public SMSNumbersEntity GetSMSNumbersObjectByNumber(int ModuleTypeID, string mobileNo) { SMSNumbersEntity sMSNumbers = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSNumbers_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ModuleTypeID; myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = mobileNo; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { sMSNumbers = PopulateEntity(dr); } dr.Close(); } myConnection.Close(); return(sMSNumbers); } }
//------------------------------------------ #endregion #region --------------GetAll-------------- public List <VoteQuestionsEntity> GetAll(bool olnyPreviousVotes, Languages langID, int pageIndex, int pageSize, out int totalRecords) { using (SqlConnection myConnection = GetSqlConnection()) { List <VoteQuestionsEntity> voteQuestionsList = new List <VoteQuestionsEntity>(); VoteQuestionsEntity voteQuestions; SqlCommand myCommand = new SqlCommand("VoteQuestions_GetAll", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@PreviousVotes", SqlDbType.Bit, 1).Value = olnyPreviousVotes; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 8).Value = (int)langID; myCommand.Parameters.Add("@pageIndex", SqlDbType.Int, 4).Value = pageIndex; myCommand.Parameters.Add("@pageSize", SqlDbType.Int, 4).Value = pageSize; myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int, 4).Direction = ParameterDirection.Output; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { (voteQuestions) = PopulateEntity(dr); voteQuestionsList.Add(voteQuestions); } dr.Close(); myConnection.Close(); //Gets result rows count totalRecords = (int)myCommand.Parameters["@TotalRecords"].Value; return(voteQuestionsList); } }
//------------------------------------------ #endregion #region --------------GetObject-------------- public static ItemsCommentsEntity GetObject(int commentID) { ItemsCommentsEntity itemComment; HttpContext context = HttpContext.Current; string cacheKey = "itemComment" + commentID; if (context.Items[cacheKey] == null) { itemComment = ItemsCommentsSqlDataPrvider.Instance.GetObject(commentID, SitesHandler.GetOwnerIDAsGuid()); context.Items[cacheKey] = itemComment; } else { itemComment = (ItemsCommentsEntity)context.Items[cacheKey]; } //return the object return(itemComment); }
//------------------------------------------ #endregion #region --------------GetMain-------------- public VoteQuestionsEntity GetMain(Languages langID) { VoteQuestionsEntity voteQuestions = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("VoteQuestions_GetMain", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)langID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { voteQuestions = PopulateEntity(dr); } dr.Close(); } myConnection.Close(); return(voteQuestions); } }
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; } } } }
//------------------------------------------ #endregion #region --------------GetAll-------------- public List <MailListGroupsEntity> GetAll() { using (SqlConnection myConnection = GetSqlConnection()) { List <MailListGroupsEntity> mailListGroupsList = new List <MailListGroupsEntity>(); MailListGroupsEntity mailListGroups; SqlCommand myCommand = new SqlCommand("MailListGroups_GetAll", myConnection); //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- myCommand.CommandType = CommandType.StoredProcedure; // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { mailListGroups = PopulateEntity(dr); mailListGroupsList.Add(mailListGroups); } dr.Close(); myConnection.Close(); return(mailListGroupsList); } }
//---------------------------------------------------------------------------------------------------------- public static void IncreaseSubSiteVisites2() { Guid OwnerID = SitesHandler.GetOwnerIDAsGuid(); UsersDataFactory.IncreaseVisits(OwnerID); }
//------------------------------------------ #endregion #region --------------Save-------------- public ExecuteCommandStatus Save(MailListGroupsEntity mailListGroups, SPOperation operation) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("MailListGroups_Save", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters //GroupID if (operation == SPOperation.Insert) { myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; } else { myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = mailListGroups.GroupID; } //SPOperation myCommand.Parameters.Add("@SPOperation", SqlDbType.Int, 4).Value = (int)operation; //Name myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 64).Value = mailListGroups.Name; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar(); if (status == ExecuteCommandStatus.Done) { //Get ID value from database and set it in object mailListGroups.GroupID = (int)myCommand.Parameters["@GroupID"].Value; } myConnection.Close(); return(status); } }
//------------------------------------------ public List <SMSNumbersEntity> GetAll(int ModuleTypeID, Languages LangID, int GroupID, bool isAvailableCondition, string searchText, int pageIndex, int pageSize, out int totalRecords) { using (SqlConnection myConnection = GetSqlConnection()) { List <SMSNumbersEntity> smsUsersList = new List <SMSNumbersEntity>(); SMSNumbersEntity smsUser; SqlCommand myCommand = new SqlCommand("SMSNumbers_GetAll", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ModuleTypeID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)LangID; myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = GroupID; myCommand.Parameters.Add("@IsAvailableCondition", SqlDbType.Bit).Value = isAvailableCondition; myCommand.Parameters.Add("@SearchText", SqlDbType.VarChar).Value = searchText; myCommand.Parameters.Add("@pageIndex", SqlDbType.Int, 4).Value = pageIndex; myCommand.Parameters.Add("@pageSize", SqlDbType.Int, 4).Value = pageSize; myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int, 4).Direction = ParameterDirection.Output; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { (smsUser) = PopulateEntity(dr); smsUsersList.Add(smsUser); } dr.Close(); myConnection.Close(); //Gets result rows count totalRecords = (int)myCommand.Parameters["@TotalRecords"].Value; return(smsUsersList); } }
public void Decrease() { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSCredit_Decrease", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); int x = myCommand.ExecuteNonQuery(); myConnection.Close(); } }
public bool DeleteAll() { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSArchive_Delete_all", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; } myConnection.Close(); return(result); } }
//------------------------------------------ #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); }
//--------------------------------------------------------------------------------------- #region --------------GetAllNumbersOnly-------------- public List <string> GetAllNumbersOnly(int ModuleTypeID, Languages LangID, int groupID, bool isAvailableCondition, string SearchText) { using (SqlConnection myConnection = GetSqlConnection()) { List <string> numbersList = new List <string>(); string Numbers; SqlCommand myCommand = new SqlCommand("SMSNumbers_GetNumbersOnly", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ModuleTypeID; myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)LangID; myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = groupID; myCommand.Parameters.Add("@IsAvailableCondition", SqlDbType.Bit).Value = isAvailableCondition; myCommand.Parameters.Add("@SearchText", SqlDbType.VarChar).Value = SearchText; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Numbers = (string)dr["Numbers"]; numbersList.Add(Numbers); } dr.Close(); myConnection.Close(); return(numbersList); } }