Exemplo n.º 1
0
    protected void Page_InIt(object sender, EventArgs e)
    {
        //ErrorMessage  CSSClass ProductIdUrlParameter
        PersonifyControlBase objbase = new PersonifyControlBase();
        var    ctrl = new Personify.WebControls.Membership.UI.MembershipListingControl();
        string customTableClassName = "Sme.personifyPages";

        string where = "Parametername ='ProductDetails'";
        DataSet customTableRecord = CustomTableItemProvider.GetItems(customTableClassName, where);

        if (customTableRecord != null)
        {
            ctrl.Step1RegistrationUrl = customTableRecord.Tables[0].Rows[0]["ParameterValue"].ToString();
        }
        ctrl.ProductIdUrlParameter = "productid";



        //LoadDropdownList(ddlErrorMessage);
        //if (!string.IsNullOrEmpty(ErrorMessage)) { ctrl.ErrorMessage = ErrorMessage; }
        //if (!string.IsNullOrEmpty(ProductIdUrlParameter)) { ctrl.ProductIdUrlParameter = "productId"; }
        //if (!string.IsNullOrEmpty(RateCodeUrlParameter)) { ctrl.RateCodeUrlParameter = RateCodeUrlParameter; }
        //LoadDropdownList(ddlStep1RegistrationUrl);
        //if (!string.IsNullOrEmpty(Step1RegistrationUrl)) { ctrl.Step1RegistrationUrl = Step1RegistrationUrl; }

        objbase.InitPersonifyWebControl(ctrl);
        phPersonifyControl.Controls.Add(ctrl);
    }
Exemplo n.º 2
0
    protected void Page_InIt(object sender, EventArgs e)
    {
        PersonifyControlBase objbase = new PersonifyControlBase();
        var    ctrl = new Personify.WebControls.Membership.UI.MembershipJoinRegistrationControl();
        string customTableClassName = "Sme.personifyPages";

        string where = "Parametername ='MbrJoinStep2'";
        DataSet customTableRecord = CustomTableItemProvider.GetItems(customTableClassName, where);


        //if (!string.IsNullOrEmpty(CancelUrl)) { ctrl.CancelUrl = CancelUrl; }
        //if (!string.IsNullOrEmpty(CompanySearchEnable)) { ctrl.CompanySearchEnable = System.Boolean.Parse(CompanySearchEnable); }
        //if (!string.IsNullOrEmpty(CustomCssClass)) { ctrl.CustomCssClass = CustomCssClass; }
        //LoadDropdownList(ddlErrorMessage);
        //if (!string.IsNullOrEmpty(ErrorMessage)) { ctrl.ErrorMessage = ErrorMessage; }
        //LoadDropdownList(ddlImageDirectory);
        //if (!string.IsNullOrEmpty(ImageDirectory)) { ctrl.ImageDirectory = ImageDirectory; }
        //if (!string.IsNullOrEmpty(LinkCompanyEnable)) { ctrl.LinkCompanyEnable = System.Boolean.Parse(LinkCompanyEnable); }
        //if (!string.IsNullOrEmpty(ProductIdUrlParameter)) { ctrl.ProductIdUrlParameter = ProductIdUrlParameter; }
        //if (!string.IsNullOrEmpty(QueryStringParametersToPreserve)) { ctrl.QueryStringParametersToPreserve = QueryStringParametersToPreserve; }
        //if (!string.IsNullOrEmpty(RateCodeUrlParameter)) { ctrl.RateCodeUrlParameter = RateCodeUrlParameter; }
        //LoadDropdownList(ddlStep2Url);
        if (customTableRecord != null)
        {
            ctrl.Step2Url = customTableRecord.Tables[0].Rows[0]["ParameterValue"].ToString();
        }
        //LoadDropdownList(ddlUserExistUrl);
        //if (!string.IsNullOrEmpty(UserExistUrl)) { ctrl.UserExistUrl = UserExistUrl; }
        objbase.InitPersonifyWebControl(ctrl);
        phPersonifyControl.Controls.Add(ctrl);
    }
Exemplo n.º 3
0
        /// <summary>
        /// Get the brand list
        /// </summary>
        /// <param name="brandItemID"></param>
        /// <returns></returns>
        public string GetBrandName()
        {
            string returnValue = string.Empty;

            try
            {
                var brands = CustomTableItemProvider.GetItems(BrandItem.CLASS_NAME)
                             .Columns("ItemId,BrandName")
                             .ToList();
                if (!DataHelper.DataSourceIsEmpty(brands))
                {
                    ddlBrand.DataSource     = brands;
                    ddlBrand.DataTextField  = "BrandName";
                    ddlBrand.DataValueField = "ItemId";
                    ddlBrand.DataBind();
                    string selectText = ValidationHelper.GetString(ResHelper.GetString("Kadena.InvProductForm.BrandWaterMark"), string.Empty);
                    ddlBrand.Items.Insert(0, new ListItem(selectText, "0"));
                }
            }
            catch (Exception ex)
            {
                EventLogProvider.LogException("CMSWebParts_Kadena_Campaign_Web_Form_AddCampaignProducts", "GetBrandName", ex, CurrentSite.SiteID, ex.Message);
            }
            return(returnValue);
        }
Exemplo n.º 4
0
 public static object GetBusinessUnits(EvaluationContext context, params object[] parameters)
 {
     try
     {
         int userID = ValidationHelper.GetInteger(parameters[0], 0);
         var data   = CustomTableItemProvider.GetItems <UserBusinessUnitsItem>()
                      .WhereEquals("UserID", userID)
                      .Columns("BusinessUnitID")
                      .ToList();
         var buList = new List <string>();
         if (!DataHelper.DataSourceIsEmpty(data))
         {
             data.ForEach(x =>
             {
                 var unitName = CustomTableItemProvider.GetItem <BusinessUnitItem>(x.BusinessUnitID);
                 buList.Add(unitName?.GetStringValue("BusinessUnitName", string.Empty) ?? string.Empty);
             });
         }
         return(String.Join(",", buList));
     }
     catch (Exception ex)
     {
         EventLogProvider.LogInformation("Kadena Macro methods", "GetBusinessUnits", ex.Message);
         return(string.Empty);
     }
 }
Exemplo n.º 5
0
        public void UpdateUserBudgetAllocationRecords(int userId, string year, decimal?totalToBeDeducted)
        {
            var userBudgetDetails = CustomTableItemProvider.GetItems(CustomTableClassName).WhereEquals("UserID", userId).WhereEquals("Year", year).FirstOrDefault();

            userBudgetDetails.SetValue("UserRemainingBudget", userBudgetDetails.GetValue("UserRemainingBudget", default(decimal)) - totalToBeDeducted);
            userBudgetDetails.Update();
        }
Exemplo n.º 6
0
 /// <summary>
 ///  This method will get all the allocated user
 /// </summary>
 /// <param name="ProductId"></param>
 private void BindEditProduct(int ProductId)
 {
     try
     {
         lstUsers = new List <AllocateProduct>();
         List <AllocateProduct> lstProduct  = new List <AllocateProduct>();
         string        customTableClassName = "KDA.UserAllocatedProducts";
         DataClassInfo customTable          = DataClassInfoProvider.GetDataClassInfo(customTableClassName);
         if (customTable != null)
         {
             var customTableData = CustomTableItemProvider.GetItems(customTableClassName)
                                   .WhereStartsWith("ProductID", ProductId.ToString());
             foreach (CustomTableItem item in customTableData)
             {
                 AllocateProduct objProduct = new AllocateProduct();
                 objProduct.EmailID  = ValidationHelper.GetString(item.GetValue("EmailID"), string.Empty);
                 objProduct.UserName = UserInfoProvider.GetUserInfo(ValidationHelper.GetInteger(item.GetValue("UserID"), 0)).FullName;
                 objProduct.Quantity = ValidationHelper.GetInteger(item.GetValue("Quantity"), 0);
                 objProduct.UserID   = ValidationHelper.GetInteger(item.GetValue("UserID"), 0);
                 lstProduct.Add(objProduct);
             }
             lstUsers.AddRange(lstProduct);
         }
         RepSelectedUser.DataSource = lstProduct;
         RepSelectedUser.DataBind();
     }
     catch (Exception ex)
     {
         EventLogProvider.LogException("Product allocation update BindEdit", "EXCEPTION", ex);
     }
 }
Exemplo n.º 7
0
        private void DoStuff()
        {
            var products = DocumentHelper.GetDocuments("PbcLinear.Product");

            foreach (var product in products)
            {
                if (product != null)
                {
                    var stringSKU =
                        ValidationHelper.GetString(product.DocumentName, String.Empty, CultureInfo.CurrentCulture);


                    // once we find product from step 3 we look up matching category from our list in step 2
                    var categoryRecord = CustomTableItemProvider.GetItems <ProductAssociationsItem>()
                                         .FirstOrDefault(x => x.ProductSKUNumber == stringSKU);
                    // if product detail and product category are not null, add relationship to table mapping product detail node id and product category node id
                    if (categoryRecord != null)
                    {
                        ProcessCategory(product.NodeID, categoryRecord.ProductCategory1);
                        ProcessCategory(product.NodeID, categoryRecord.ProductCategory2);
                        ProcessCategory(product.NodeID, categoryRecord.ProductCategory3);
                    }
                }
            }
        }
Exemplo n.º 8
0
        public IEnumerable <AirportDto> GetAirportDtos(string searchPhrase = null)
        {
            if (AirportsTable != null)
            {
                var query = CustomTableItemProvider.GetItems(CustomTableClassName)
                            .OrderBy("AirportName");

                if (!string.IsNullOrWhiteSpace(searchPhrase))
                {
                    query.WhereContains(NameColumn, searchPhrase);
                }

                foreach (var airport in query)
                {
                    var iataCode = ValidationHelper.GetString(airport.GetValue(IataCodeColumn), "");
                    var name     = ValidationHelper.GetString(airport.GetValue(NameColumn), "");

                    yield return(new AirportDto
                    {
                        AirportIataCode = iataCode,
                        AirportName = name
                    });
                }
            }
        }
Exemplo n.º 9
0
    /// <summary>
    /// Gets the custom table item and moves it down. Called when the "Get and move item down" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool GetAndMoveCustomTableItemDown()
    {
        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(customTableClassName);

        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text'";
            int    topN    = 1;
            string columns = "ItemID";

            // Get the data set according to the parameters
            DataSet dataSet = CustomTableItemProvider.GetItems(customTableClassName, where, null, topN, columns);

            if (!DataHelper.DataSourceIsEmpty(dataSet))
            {
                // Get the custom table item ID
                int itemID = ValidationHelper.GetInteger(dataSet.Tables[0].Rows[0][0], 0);
                var item   = CustomTableItemProvider.GetItem(itemID, customTableClassName);

                // Move the item down
                item.Generalized.MoveObjectDown();

                return(true);
            }
        }

        return(false);
    }
Exemplo n.º 10
0
        /// <summary>
        /// Converts an Object's IDs, Guids, or CodeNames to the Objects CodeNames
        /// </summary>
        /// <param name="classObjSummary">The Class Object Summary</param>
        /// <param name="ObjectIdentifications">List of Object IDs, Guids, or CodeNames</param>
        /// <returns>A list of the Object's Code Names</returns>
        private static IEnumerable <string> ObjectIdentitiesToCodeNames(ClassObjSummary classObjSummary, IEnumerable <object> ObjectIdentifications)
        {
            switch (classObjSummary.ClassName.ToLower())
            {
            case "cms.tree":
            case "cms.document":
                return(new DocumentQuery().Where(ObjectIdentitiesWhere(classObjSummary, ObjectIdentifications)).Columns(classObjSummary.CodeNameColumn).Select(x => (string)x.GetValue(classObjSummary.CodeNameColumn)).ToArray());

            default:
                if (classObjSummary.ClassIsDocumentType)
                {
                    return(new DocumentQuery(classObjSummary.ClassName).Where(ObjectIdentitiesWhere(classObjSummary, ObjectIdentifications)).Columns(classObjSummary.CodeNameColumn).Select(x => (string)x.GetValue(classObjSummary.CodeNameColumn)).ToArray());
                }
                else if (classObjSummary.ClassIsCustomTable)
                {
                    return(CustomTableItemProvider.GetItems(classObjSummary.ClassName).Where(ObjectIdentitiesWhere(classObjSummary, ObjectIdentifications)).Columns(classObjSummary.CodeNameColumn).Select(x => (string)x.GetValue(classObjSummary.CodeNameColumn)).ToArray());
                }
                else if (classObjSummary.ClassIsForm)
                {
                    return(BizFormItemProvider.GetItems(classObjSummary.ClassName).Where(ObjectIdentitiesWhere(classObjSummary, ObjectIdentifications)).Columns(classObjSummary.CodeNameColumn).Select(x => (string)x.GetValue(classObjSummary.CodeNameColumn)).ToArray());
                }
                else
                {
                    return(new ObjectQuery(classObjSummary.ClassName).Where(ObjectIdentitiesWhere(classObjSummary, ObjectIdentifications)).Columns(classObjSummary.CodeNameColumn).Select(x => (string)x.GetValue(classObjSummary.CodeNameColumn)).ToArray());
                }
            }
        }
    public static object GetValueFromCustomTableByItemGUID(EvaluationContext context, params object[] parameters)
    {
        if (parameters[0] == null || parameters[1] == null || parameters[2] == null)
        {
            return(null);
        }

        string CustomTableName = ValidationHelper.GetString(parameters[0], "");
        string UniqueID        = ValidationHelper.GetString(parameters[1], "");
        string ColumnName      = ValidationHelper.GetString(parameters[2], "");

        DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(CustomTableName);

        if (customTable != null)
        {
            var ds = CustomTableItemProvider.GetItems(CustomTableName)
                     .Column(ColumnName)
                     .WhereEquals("ItemGUID", UniqueID)
                     .TopN(1);

            if (!DataHelper.DataSourceIsEmpty(ds) && ds.Tables[0].Rows.Count > 0)
            {
                return(ds.Tables[0].Rows[0][0]);
            }
        }

        return(null);
    }
Exemplo n.º 12
0
        private void PopulateErrors(IEnumerable <MailingAddressDto> badAddresses)
        {
            var errorsDictionary = CustomTableItemProvider
                                   .GetItems("KDA.AddressErrors")
                                   .ToDictionary(i => i["ErrorCode"].ToString(), i => i["ErrorDescription"].ToString());
            var missingCodes = new HashSet <string>();

            foreach (var address in badAddresses)
            {
                string errorDescription;
                if (errorsDictionary.TryGetValue(address.ErrorMessage, out errorDescription))
                {
                    address.ErrorMessage = errorDescription;
                }
                else
                {
                    if (!missingCodes.Contains(address.ErrorMessage))
                    {
                        missingCodes.Add(address.ErrorMessage);
                    }
                }
            }
            if (missingCodes.Any())
            {
                var exc = new KeyNotFoundException($"The error description is not found for following key(s): {string.Join(", ", missingCodes)}");
                EventLogProvider.LogWarning("Mailing Addresses Load", "WARNING", exc, CurrentSite.SiteID, string.Empty);
            }
        }
Exemplo n.º 13
0
    /// <summary>
    /// Gets the custom table item and moves it up. Called when the "Get and move item up" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool GetAndMoveCustomTableItemUp()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);

        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text'";
            int    topN    = 1;
            string columns = "ItemID";

            // Get the data set according to the parameters
            DataSet dataSet = customTableProvider.GetItems(customTableClassName, where, null, topN, columns);

            if (!DataHelper.DataSourceIsEmpty(dataSet))
            {
                // Get the custom table item ID
                int itemID = ValidationHelper.GetInteger(dataSet.Tables[0].Rows[0][0], 0);

                // Move the item up
                customTableProvider.MoveItemUp(itemID, customTableClassName);

                return(true);
            }
        }

        return(false);
    }
Exemplo n.º 14
0
    /// <summary>
    /// Deletes customTableItem. Called when the "Delete item" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool DeleteCustomTableItem()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);

        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text%'";

            // Get the data
            DataSet customTableItems = customTableProvider.GetItems(customTableClassName, where, null);
            if (!DataHelper.DataSourceIsEmpty(customTableItems))
            {
                // Loop through the individual items
                foreach (DataRow customTableItemDr in customTableItems.Tables[0].Rows)
                {
                    // Create object from DataRow
                    CustomTableItem deleteCustomTableItem = CustomTableItem.New(customTableItemDr, customTableClassName);

                    // Delete custom table item from database
                    deleteCustomTableItem.Delete();
                }

                return(true);
            }
        }

        return(false);
    }
        private List <CustomTableItem> GetAuthors(string authorsId)
        {
            List <int>             authorsIdArray = new List <int>(Array.ConvertAll(authorsId.Split('|'), int.Parse));
            List <CustomTableItem> ArticleAuthors = new List <CustomTableItem>();

            // Get Authors list
            List <CustomTableItem> Authors = CacheHelper.Cache(cs =>
            {
                List <CustomTableItem> data = CustomTableItemProvider.GetItems("MedioClinic.Authors").ToList();

                if (data != null && cs.Cached)
                {
                    cs.CacheDependency = CacheHelper.GetCacheDependency("customtableitem|medioclinic.authors|all");
                }

                return(data);
            }, new CacheSettings(10, string.Format("MedioClinic_GetAuthors()|{0}", SiteContext.CurrentSiteName)));

            foreach (var item in Authors)
            {
                if (authorsIdArray.Contains(item.GetIntegerValue("ItemId", -1)))
                {
                    ArticleAuthors.Add(item);
                }
            }

            return(ArticleAuthors);
        }
Exemplo n.º 16
0
 /// <summary>
 /// custom validator for checking the uniqueness of the busines unit number
 /// </summary>
 protected void cvBUNumber_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
 {
     try
     {
         BusinessUnitItem objBusinessUnit = new BusinessUnitItem();
         var buNumber = ValidationHelper.GetLong(txtBUNumber.Text, default(int));
         int itemID   = QueryHelper.GetInteger("itemID", 0);
         if (itemID > 0)
         {
             var buData = CustomTableItemProvider.GetItems <BusinessUnitItem>()
                          .WhereEquals("BusinessUnitNumber", buNumber)
                          .And()
                          .WhereNotEquals("ItemID", itemID)
                          .Columns("BusinessUnitNumber")
                          .FirstOrDefault();
             args.IsValid = DataHelper.DataSourceIsEmpty(buData);
         }
         else
         {
             var buData = CustomTableItemProvider.GetItems <BusinessUnitItem>()
                          .WhereEquals("BusinessUnitNumber", buNumber)
                          .Columns("BusinessUnitNumber")
                          .FirstOrDefault();
             args.IsValid = DataHelper.DataSourceIsEmpty(buData);
         }
     }
     catch (Exception ex)
     {
         EventLogProvider.LogException("BusinessUnit.ascx.cs", "cvBUNumber_ServerValidate()", ex);
     }
 }
Exemplo n.º 17
0
        /// <summary>
        /// Global event for User object to update FY Budget
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void KDAUser_Update_After(object sender, ObjectEventArgs e)
        {
            bool     userFYBudgetEnabled = SettingsKeyInfoProvider.GetBoolValue("KDA_UserFYBudgetEnabled", SiteContext.CurrentSiteID);
            UserInfo user = e.Object as UserInfo;

            if (user != null && userFYBudgetEnabled)
            {
                double budget = user.GetDoubleValue("FYBudget", 0);
                if (budget > 0)
                {
                    UserFYBudgetAllocationItem userBudget = CustomTableItemProvider.GetItems <UserFYBudgetAllocationItem>()
                                                            .Where(x => x.UserID.Equals(user.UserID) &&
                                                                   x.Year.Equals(DateTime.Now.Year.ToString()) &&
                                                                   x.SiteID.Equals(SiteContext.CurrentSiteID))
                                                            .FirstOrDefault();
                    if (userBudget == null)
                    {
                        userBudget = new UserFYBudgetAllocationItem();
                    }
                    userBudget.Year   = DateTime.Now.Year.ToString();
                    userBudget.UserID = user.UserID;
                    userBudget.Budget = budget;
                    userBudget.SiteID = SiteContext.CurrentSiteID;
                    if (userBudget.ItemID > 0)
                    {
                        userBudget.Update();
                    }
                    else
                    {
                        userBudget.Insert();
                    }
                }
            }
        }
Exemplo n.º 18
0
 public static void InsertIBFForm(OrderDTO orderDetails)
 {
     try
     {
         var productItems = orderDetails.Items.ToList();
         foreach (var product in productItems)
         {
             bool isExist = true;
             InboundTrackingItem inboundData = CustomTableItemProvider.GetItems <InboundTrackingItem>().WhereEquals("SKUID", product.SKU.KenticoSKUID).FirstOrDefault();
             if (inboundData == null)
             {
                 inboundData = new InboundTrackingItem();
                 isExist     = false;
             }
             inboundData.SKUID      = product.SKU.KenticoSKUID;
             inboundData.QtyOrdered = product.UnitCount;
             if (!isExist)
             {
                 inboundData.Insert();
             }
             else
             {
                 inboundData.Update();
             }
         }
     }
     catch (Exception ex)
     {
         EventLogProvider.LogInformation("ShoppingCartHelper", "GetOrderTotal", ex.Message);
     }
 }
Exemplo n.º 19
0
    private void GetLieu()
    {
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(MembershipContext.AuthenticatedUser);

        string customTableClassName = "customtable.region";

        // Check if Custom table 'Sample table' exists

        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);

        if (customTable != null)
        {
            string where = "itemID<>'1'";
            string  orderby = "Libelle";
            DataSet data    = customTableProvider.GetItems(customTableClassName, where, orderby);
            if (!DataHelper.DataSourceIsEmpty(data))
            {
                // Bind lieu to the drop-down list
                this.drpLieu.DataSource     = data;
                this.drpLieu.DataTextField  = "Libelle";
                this.drpLieu.DataValueField = "ItemID";
                this.drpLieu.DataBind();
                RemoveDuplicateItems(drpLieu);

                // Add default '(tous)' value
                this.drpLieu.Items.Insert(0, new ListItem("FILTRER PAR REGION", "0"));

                // Add PRES DE CHEZ VOUS value
                this.drpLieu.Items.Insert(drpLieu.Items.Count, new ListItem("Près de chez vous", "1"));
            }
        }
    }
Exemplo n.º 20
0
        /// <summary>
        /// This method will get all the users and bind it to repeater
        /// </summary>
        /// <param name="pageIndex"></param>
        private void BindUsers(int pageIndex)
        {
            List <AllocateProduct> lstAllocatedProd = new List <AllocateProduct>();
            string customTableClassName             = "KDA.UserAllocatedProducts";
            var    users = UserInfoProvider.GetUsers().Columns("Email", "UserID", "FullName").OnSite(CurrentSite.SiteID).OrderBy("FullName")
                           .Skip(PageSize * (pageIndex - 1))
                           .Take(PageSize);

            foreach (UserInfo user in users)
            {
                AllocateProduct objProduct = new AllocateProduct();
                objProduct.EmailID  = user.Email;
                objProduct.UserID   = user.UserID;
                objProduct.UserName = user.FullName;
                objProduct.Quantity = CustomTableItemProvider.GetItems(customTableClassName)
                                      .WhereEquals("ProductID", productId).WhereEquals("UserID", user.UserID).FirstOrDefault()?.GetValue("Quantity", default(int)) ?? 0;
                if (lstUsers.FindIndex(item => item.UserID == user.UserID) > -1)
                {
                    objProduct.Selected = true;
                }
                lstAllocatedProd.Add(objProduct);
            }
            RepterDetails.DataSource = lstAllocatedProd;
            RepterDetails.DataBind();
            PopulatePager(UserInfoProvider.GetUsers().OnSite(CurrentSite.SiteID).Count(), pageIndex);
        }
Exemplo n.º 21
0
        /// <summary>
        /// Get the State list
        /// </summary>
        /// <returns></returns>
        public string GetStateGroup()
        {
            string returnValue = string.Empty;

            try
            {
                var states = CustomTableItemProvider.GetItems(StatesGroupItem.CLASS_NAME)
                             .Columns("ItemID,States,GroupName")
                             .ToList();
                if (!DataHelper.DataSourceIsEmpty(states))
                {
                    ddlState.DataSource     = states;
                    ddlState.DataTextField  = "GroupName";
                    ddlState.DataValueField = "ItemID";
                    ddlState.DataBind();
                    string selectText = ValidationHelper.GetString(ResHelper.GetString("Kadena.InvProductForm.StateWaterMark"), string.Empty);
                    ddlState.Items.Insert(0, new ListItem(selectText, "0"));
                    RepStateInfo.DataSource = states;
                    RepStateInfo.DataBind();
                }
            }
            catch (Exception ex)
            {
                EventLogProvider.LogException("CMSWebParts_Kadena_Campaign_Web_Form_AddCampaignProducts", "GetStateGroup", ex, CurrentSite.SiteID, ex.Message);
            }
            return(returnValue);
        }
Exemplo n.º 22
0
        protected void ddlPosNo_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                string selectedPos = ddlPosNo.SelectedValue;
                BindData();
                SKUInfo skuDetails = SKUInfoProvider.GetSKUs().WhereEquals("SKUNumber", selectedPos).FirstObject;
                if (skuDetails != null)
                {
                    string folderName = libraryFolderName;
                    folderName              = !string.IsNullOrEmpty(folderName) ? folderName.Replace(" ", "") : "CampaignProducts";
                    txtLongDes.Text         = skuDetails.SKUDescription;
                    txtEstPrice.Text        = ValidationHelper.GetString(skuDetails.SKUPrice, string.Empty);
                    ddlPosNo.SelectedValue  = ValidationHelper.GetString(skuDetails.SKUNumber, string.Empty);
                    txtShortDes.Text        = skuDetails.SKUName;
                    txtActualPrice.Text     = ValidationHelper.GetString(skuDetails.SKUPrice, string.Empty);
                    ddlStatus.SelectedValue = skuDetails.SKUEnabled == true ? "1" : "0";
                    imgProduct.ImageUrl     = ValidationHelper.GetString(skuDetails.SKUImagePath, string.Empty);
                    imgProduct.Visible      = imgProduct.ImageUrl != string.Empty ? true : false;
                    txtExpDate.Text         = ValidationHelper.GetString(skuDetails.SKUValidUntil, string.Empty);
                    txtQuantity.Text        = ValidationHelper.GetString(skuDetails.SKUAvailableItems, string.Empty);
                    txtWeight.Text          = ValidationHelper.GetString(skuDetails.SKUWeight, string.Empty);
                    CampaignsProduct product = CampaignsProductProvider.GetCampaignsProducts().WhereEquals("NodeSKUID", skuDetails.SKUID).FirstObject;
                    if (product != null)
                    {
                        txtBundleQnt.Text             = ValidationHelper.GetString(product.QtyPerPack, string.Empty);
                        ddlBrand.SelectedValue        = ValidationHelper.GetString(product.BrandID, string.Empty);
                        ddlState.SelectedValue        = ValidationHelper.GetString(product.State, string.Empty);
                        ddlProdCategory.SelectedValue = ValidationHelper.GetString(product.CategoryID, string.Empty);
                        BindEditProduct(ValidationHelper.GetInteger(product.CampaignsProductID, 0));
                        ViewState["ProductId"] = product.CampaignsProductID;
                    }
                }
                else
                {
                    ViewState["ProductId"] = null;
                    EmptyFields(false);
                    var pos = CustomTableItemProvider.GetItems(POSNumberItem.CLASS_NAME)
                              .WhereEquals("POSNumber", selectedPos)
                              .FirstOrDefault();
                    if (pos != null && pos.GetValue("BrandID") != null)
                    {
                        var brand = CustomTableItemProvider.GetItems(BrandItem.CLASS_NAME)
                                    .WhereEquals("BrandCode", pos.GetValue("BrandID"))
                                    .FirstOrDefault();
                        if (brand != null)
                        {
                            ddlBrand.SelectedValue = brand.GetValue("ItemId").ToString();
                        }
                    }
                }

                ddlPosNo.SelectedValue = selectedPos;
            }
            catch (Exception ex)
            {
                EventLogProvider.LogException("CMSWebParts_Kadena_Inventory_porduct_POSchanged", "BindCategories", ex, CurrentSite.SiteID, ex.Message);
            }
        }
 private void BindItemSpecsList(ISheet sheet)
 {
     string[] itemSpecsList = CustomTableItemProvider.GetItems <ProductItemSpecsItem>().ToList().Select(x => x.ItemSpec).ToArray();
     if (itemSpecsList != null && itemSpecsList.Count() > 0)
     {
         AddOneFromManyValidation(16, "ItemSpecsList", itemSpecsList, sheet);
     }
 }
 private void BindStatesGroupList(ISheet sheet)
 {
     string[] statesGroupList = CustomTableItemProvider.GetItems <StatesGroupItem>().ToList().Select(x => x.GroupName).ToArray();
     if (statesGroupList != null && statesGroupList.Count() > 0)
     {
         AddOneFromManyValidation(5, "StatesGroupList", statesGroupList, sheet);
     }
 }
 private void BindBrandList(ISheet sheet)
 {
     string[] brandList = CustomTableItemProvider.GetItems <BrandItem>().ToList().Select(x => x.BrandName).ToArray();
     if (brandList != null && brandList.Count() > 0)
     {
         AddOneFromManyValidation(8, "BrandList", brandList, sheet);
     }
 }
Exemplo n.º 26
0
 private CustomTableItem GetFavoriteRecord(int siteId, int userId, int productDocumentId)
 {
     return(CustomTableItemProvider.GetItems(CustomTableName)
            .WhereEquals("ItemSiteID", siteId)
            .WhereEquals("ItemUserID", userId)
            .WhereEquals("ItemDocumentID", productDocumentId)
            .FirstObject);
 }
Exemplo n.º 27
0
        public Submission GetSubmission(Guid submissionId)
        {
            var submission = CustomTableItemProvider.GetItems(SubmissionsTable)
                             .WhereEquals("SubmissionId", submissionId)
                             .SingleOrDefault();

            return(mapper.Map <Submission>(submission));
        }
 private void BindPOSList(ISheet sheet)
 {
     string[] posList = CustomTableItemProvider.GetItems <POSNumberItem>().ToList().Select(x => x.POSNumber.ToString()).ToArray();
     if (posList != null && posList.Count() > 0)
     {
         AddOneFromManyValidation(2, "POSList", posList, sheet);
     }
 }
        public List <BusinessUnit> GetBusinessUnits()
        {
            ObjectQuery <CustomTableItem> businessUnits = CustomTableItemProvider.GetItems(BusinessUnitsCustomTableName)
                                                          .WhereEquals("SiteID", SiteContext.CurrentSiteID)
                                                          .And()
                                                          .WhereTrue("Status");

            return(businessUnits.Select(x => CreateBusinessUnit(x)).ToList());
        }
Exemplo n.º 30
0
        public List <int> CheckFavoriteProductIds(List <int> productIds)
        {
            var favorites = CustomTableItemProvider.GetItems(CustomTableName)
                            .WhereEquals("ItemSiteID", SiteContext.CurrentSiteID)
                            .WhereEquals("ItemUserID", MembershipContext.AuthenticatedUser.UserID)
                            .WhereIn("ItemDocumentID", productIds);

            return(favorites.Select(f => Convert.ToInt32(f["ItemDocumentID"])).ToList());
        }
		/// <summary>
		/// GetDocumentResource
		/// </summary>
		/// <param name="ui"></param>
		/// <param name="className"></param>
		/// <param name="treeProvider"></param>
		/// <param name="whereClause"></param>
		/// <param name="orderby"></param>
		/// <param name="whereTextClause"></param>
		/// <param name="lookupDataSet"></param>
		/// <param name="pResourceType"></param>
		/// <returns>List</returns>
		protected List<Resource> GetDocumentResource(UserInfo ui, string className, TreeProvider treeProvider,
			string whereClause, string orderby, string whereTextClause, DataSet lookupDataSet,
			ResourceTypes pResourceType = ResourceTypes.All)
		{

            int lookupval = GetDocTypeValueFromTileMap(className, ui);
			CustomTableItemProvider tp = new CustomTableItemProvider((UserInfo)Session["KenticoUserInfo"]);
			string filtercriteria = "LookupValue = " + lookupval + " and (ISNULL(StateLEA,'')='' or StateLEA = '" +
									DistrictParms.LoadDistrictParms().ClientID + "' or StateLEA = '" +
									DistrictParms.LoadDistrictParms().State + "')";
			DataSet resourcesToShow = tp.GetItems("thinkgate.TileMap_Lookup", filtercriteria, string.Empty);

			List<Resource> lstResource = new List<Resource>();
			foreach (DataRow dr in resourcesToShow.Tables[0].Select().OrderBy(p => p["ItemOrder"].ToString()))
			{
                if (isInstructionMaterial == true && dr["KenticoDocumentTypeToShow"].ToString().ToLower() == "thinkgate.competencylist")
                {
                    continue;
                }
				string[] columnNames =
				{
					dr["DescriptionColumnName"].ToString(), dr["NameColumnName"].ToString(),
					dr["AttachmentColumnName"].ToString(), dr["FriendlyName"].ToString()
				};
				List<Resource> resource =
					(from s in
                        GetDocuments(ui, dr["KenticoDocumentTypeToShow"].ToString(), treeProvider, whereClause,
                            string.Empty, columnNames,
							 whereTextClause, lookupDataSet, pResourceType)
					 select new Resource
					 {
						 Source =
							 s.NodeAliasPath.IndexOf(_districts.ToString(), StringComparison.Ordinal) >= 0
								 ? District
                                    : s.NodeAliasPath.IndexOf(_stateDocuments.ToString(), StringComparison.Ordinal) >= 0
                                        ? State
                                            : s.NodeAliasPath.IndexOf(_sharedDocuments.ToString(), StringComparison.Ordinal) >= 0
                                            ? SharedDocument //US15667
                                                : MyDocuments,
						 ID = s.ID,
						 DocumentType = s.DocumentType,
						 ID_Encrypted = "",
						 NodeAliasPath = s.NodeAliasPath,
						 ResourceName = s.ResourceName,
						 Description = s.Description,
						 Type = s.Type,
						 Subtype = s.Subtype,
						 ViewLink = s.ViewLink,
						 DocumentForeignKeyValue = s.DocumentForeignKeyValue,
						 DocumentNodeID = Convert.ToInt32(s.DocumentNodeID),
                         ExpirationDate = s.ExpirationDate,
                         AverageRating = s.AverageRating
												  
					 }).ToList<Resource>();
				if (resource.Count == 0)
				{
					resource = new List<Resource>();
				}
				lstResource.AddRange(resource);
			}
			return lstResource;
		}
		/// <summary>
		/// GetDocTypeValueFromTileMap
		/// </summary>
		/// <param name="resourceToShow"></param>
		/// <returns>int</returns>
        private int GetDocTypeValueFromTileMap(string resourceToShow, UserInfo ui)
		{
            CustomTableItemProvider tp = new CustomTableItemProvider(ui);
         
            DataSet lookupDataSet = tp.GetItems("thinkgate.TileMap", "BaseTileType = '" + resourceToShow + "' ",
                string.Empty);
			int lookupval = 0;
			if (lookupDataSet.Tables[0].Rows.Count > 0)
			{
				lookupval = (int)lookupDataSet.Tables[0].Rows[0]["Value"];
			}

			return lookupval;

		}
    void btnGUID_Click(object sender, EventArgs e)
    {
        try
        {
            // Create GUID field
            FormFieldInfo ffiGuid = new FormFieldInfo();

            // Fill FormInfo object
            ffiGuid.Name = "ItemGUID";
            ffiGuid.Caption = "GUID";
            ffiGuid.DataType = FormFieldDataTypeEnum.GUID;
            ffiGuid.DefaultValue = "";
            ffiGuid.Description = "";
            ffiGuid.FieldType = FormFieldControlTypeEnum.CustomUserControl;
            ffiGuid.Settings["controlname"] = Enum.GetName(typeof(FormFieldControlTypeEnum), FormFieldControlTypeEnum.LabelControl).ToLower();
            ffiGuid.PrimaryKey = false;
            ffiGuid.System = true;
            ffiGuid.Visible = false;
            ffiGuid.Size = 0;
            ffiGuid.AllowEmpty = false;

            FormInfo.AddFormField(ffiGuid);

            // Update table structure - columns could be added
            bool old = TableManager.UpdateSystemFields;
            TableManager.UpdateSystemFields = true;
            string schema = FormInfo.GetXmlDefinition();
            TableManager.UpdateTableBySchema(dci.ClassTableName, schema);
            TableManager.UpdateSystemFields = old;

            // Update xml schema and form definition
            dci.ClassFormDefinition = schema;
            dci.ClassXmlSchema = TableManager.GetXmlSchema(dci.ClassTableName);

            dci.Generalized.LogEvents = false;

            // Save the data
            DataClassInfoProvider.SetDataClass(dci);

            dci.Generalized.LogEvents = true;

            // Generate default queries
            SqlGenerator.GenerateDefaultQueries(dci, true, false);

            // Clear cached data
            CMSObjectHelper.RemoveReadOnlyObjects(CustomTableItemProvider.GetObjectType(className), true);
            CustomTableItemProvider.Remove(className, true);
            // Clear the object type hashtable
            ProviderStringDictionary.ReloadDictionaries(className, true);

            // Clear the classes hashtable
            ProviderStringDictionary.ReloadDictionaries("cms.class", true);

            // Clear class strucures
            ClassStructureInfo.Remove(className, true);

            // Ensure GUIDs for all items
            CustomTableItemProvider tableProvider = new CustomTableItemProvider();
            tableProvider.UpdateSystemFields = false;
            tableProvider.LogSynchronization = false;
            DataSet dsItems = tableProvider.GetItems(className, null, null);
            if (!DataHelper.DataSourceIsEmpty(dsItems))
            {
                foreach (DataRow dr in dsItems.Tables[0].Rows)
                {
                    CustomTableItem item = new CustomTableItem(dr, className, tableProvider);
                    item.ItemGUID = Guid.NewGuid();
                    item.Update();
                }
            }

            // Log event
            UserInfo currentUser = CMSContext.CurrentUser;
            EventLog.LogEvent(EventLogProvider.EVENT_TYPE_INFORMATION, DateTime.Now, "Custom table", "GENERATEGUID", currentUser.UserID, currentUser.UserName, 0, null, null, string.Format(ResHelper.GetAPIString("customtable.GUIDGenerated", "Field 'ItemGUID' for custom table '{0}' was created and GUID values were generated."), dci.ClassName), 0, null);

            URLHelper.Redirect(URLHelper.AddParameterToUrl(URLRewriter.CurrentURL, "gen", "1"));
        }
        catch (Exception ex)
        {
            lblError.Visible = true;
            lblError.Text = GetString("customtable.ErrorGUID") + ex.Message;

            // Log event
            EventLog.LogEvent("Custom table", "GENERATEGUID", ex);
        }
    }
Exemplo n.º 34
0
    /// <summary>
    /// Gets and bulk updates custom table items. Called when the "Get and bulk update items" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool GetAndBulkUpdateCustomTableItems()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);
        if (customTable != null)
        {
            // Prepare the parameters

            string where = "ItemText LIKE N'New text%'";

            // Get the data
            DataSet customTableItems = customTableProvider.GetItems(customTableClassName, where, null);
            if (!DataHelper.DataSourceIsEmpty(customTableItems))
            {
                // Loop through the individual items
                foreach (DataRow customTableItemDr in customTableItems.Tables[0].Rows)
                {
                    // Create object from DataRow
                    CustomTableItem modifyCustomTableItem = CustomTableItem.New(customTableItemDr, customTableClassName);

                    string itemText = ValidationHelper.GetString(modifyCustomTableItem.GetValue("ItemText"), "");

                    // Set new values
                    modifyCustomTableItem.SetValue("ItemText", itemText.ToUpper());

                    // Save the changes
                    modifyCustomTableItem.Update();
                }

                return true;
            }
        }

        return false;
    }
Exemplo n.º 35
0
    /// <summary>
    /// Gets the custom table item and moves it up. Called when the "Get and move item up" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool GetAndMoveCustomTableItemUp()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);
        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text'";
            int topN = 1;
            string columns = "ItemID";

            // Get the data set according to the parameters
            DataSet dataSet = customTableProvider.GetItems(customTableClassName, where, null, topN, columns);

            if (!DataHelper.DataSourceIsEmpty(dataSet))
            {
                // Get the custom table item ID
                int itemID = ValidationHelper.GetInteger(dataSet.Tables[0].Rows[0][0], 0);

                // Move the item up
                customTableProvider.MoveItemUp(itemID, customTableClassName);

                return true;
            }
        }

        return false;
    }
Exemplo n.º 36
0
    /// <summary>
    /// Gets and updates custom table item. Called when the "Get and update item" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool GetAndUpdateCustomTableItem()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);
        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text'";
            int topN = 1;
            string columns = "ItemID";

            // Get the data set according to the parameters
            DataSet dataSet = customTableProvider.GetItems(customTableClassName, where, null, topN, columns);

            if (!DataHelper.DataSourceIsEmpty(dataSet))
            {
                // Get the custom table item ID
                int itemID = ValidationHelper.GetInteger(dataSet.Tables[0].Rows[0][0], 0);

                // Get the custom table item
                CustomTableItem updateCustomTableItem = customTableProvider.GetItem(itemID, customTableClassName);

                if (updateCustomTableItem != null)
                {
                    string itemText = ValidationHelper.GetString(updateCustomTableItem.GetValue("ItemText"), "");

                    // Set new values
                    updateCustomTableItem.SetValue("ItemText", itemText.ToLowerCSafe());

                    // Save the changes
                    updateCustomTableItem.Update();

                    return true;
                }
            }
        }

        return false;
    }
Exemplo n.º 37
0
    /// <summary>
    /// Deletes customTableItem. Called when the "Delete item" button is pressed.
    /// Expects the CreateCustomTableItem method to be run first.
    /// </summary>
    private bool DeleteCustomTableItem()
    {
        // Create new Custom table item provider
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser);

        string customTableClassName = "customtable.sampletable";

        // Check if Custom table 'Sample table' exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);
        if (customTable != null)
        {
            // Prepare the parameters
            string where = "ItemText LIKE N'New text%'";

            // Get the data
            DataSet customTableItems = customTableProvider.GetItems(customTableClassName, where, null);
            if (!DataHelper.DataSourceIsEmpty(customTableItems))
            {
                // Loop through the individual items
                foreach (DataRow customTableItemDr in customTableItems.Tables[0].Rows)
                {
                    // Create object from DataRow
                    CustomTableItem deleteCustomTableItem = CustomTableItem.New(customTableItemDr, customTableClassName);

                    // Delete custom table item from database
                    deleteCustomTableItem.Delete();
                }

                return true;
            }
        }

        return false;
    }