protected void ProcessCategory(int productNodeId, string categoryPath) { if (!string.IsNullOrEmpty(categoryPath)) { var categoryItem = FindProductCategory(categoryPath); if (categoryItem != null) { RelationshipInfoProvider.AddRelationship(productNodeId, categoryItem.NodeID, productCategoryProductRelationshipID); } // if product detail or product category are null log error and add to error tracker (add error tracking custom table)fields, product detail name, product category name and explanation of what's wrong else { // Prepares the code name (class name) of the custom table to which the data record will be added string customTableClassName = "PbcLinear.ProcessCategoryErrors"; // Gets the custom table DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(customTableClassName); if (customTable != null) { // Creates a new custom table item CustomTableItem newCustomTableItem = CustomTableItem.New(customTableClassName); // Sets the values for the fields of the custom table (ItemText in this case) newCustomTableItem.SetValue("ProductNodeId", productNodeId); newCustomTableItem.SetValue("CategoryPath", categoryPath); newCustomTableItem.SetValue("Error", "categoryItem is null "); if (productNodeId == 0) { var newError = newCustomTableItem.GetValue("Error") + " productNodeId is empty"; newCustomTableItem.SetValue("Error", newError); } if (!string.IsNullOrEmpty(categoryPath)) { var newError = newCustomTableItem.GetValue("Error") + " categoryPath is empty"; newCustomTableItem.SetValue("Error", newError); } // Save the new custom table record into the database newCustomTableItem.Insert(); } } } }
public void AdjustUserRemainingBudget(string year, int userID, decimal adjustment) { CustomTableItem userBudgetDetails = CustomTableItemProvider.GetItems(CustomTableClassName).WhereEquals("UserID", userID).WhereEquals("Year", year).FirstOrDefault(); if (userBudgetDetails != null) { userBudgetDetails.SetValue("UserRemainingBudget", userBudgetDetails.GetValue("UserRemainingBudget", default(decimal)) + (adjustment)); userBudgetDetails.Update(); } }
public UserBudgetItem CreateUserBudgetWithYear(string year, int siteID, int userId) { DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(CustomTableClassName); CustomTableItem newCustomTableItem = CustomTableItem.New(CustomTableClassName); if (customTable != null) { newCustomTableItem.SetValue("UserID", userId); newCustomTableItem.SetValue("Year", year); newCustomTableItem.SetValue("Budget", default(decimal)); newCustomTableItem.SetValue("UserRemainingBudget", default(decimal)); newCustomTableItem.SetValue("SiteID", siteID); newCustomTableItem.Insert(); return(new UserBudgetItem() { ItemID = newCustomTableItem.ItemID, Budget = newCustomTableItem.GetValue("Budget", default(decimal)), UserID = userId, UserRemainingBudget = newCustomTableItem.GetValue("UserRemainingBudget", default(decimal)), Year = year }); } return(null); }
/// <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); }
/// <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); }
private string GetRegion(string City) { City = City.Trim(); string result = string.Empty; if (string.IsNullOrEmpty(City)) { return(string.Empty); } // Creates a new Custom table item provider CustomTableItemProvider customTableProvider = new CustomTableItemProvider(MembershipContext.AuthenticatedUser); string customTableClassName = "customtable.GeoLoc"; // Checks if Custom table 'Sample table' exists DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName); if (customTable != null) { // Prepares the parameters string where = string.Format("entId in (select entEntId from customtable_geoloc where entID in (select entEntId from customtable_geoloc where (entGeoLocName='{0}' OR entGeoLocName LIKE '{0} |%' OR entGeoLocName LIKE '%| {0} |%' OR entGeoLocName LIKE '%| {0}') AND cast(entId as int)>=1000))", City); te.Text = where; DataSet DataSet = customTableProvider.GetItems(customTableClassName, where, null); if (!DataHelper.DataSourceIsEmpty(DataSet)) { // Gets the custom table item ID int entID = ValidationHelper.GetInteger(DataSet.Tables[0].Rows[0][0], 0); // Gets the custom table item CustomTableItem CustomTableItem = customTableProvider.GetItem(entID, customTableClassName); if (CustomTableItem != null) { result = ValidationHelper.GetString(CustomTableItem.GetValue("entDDLValue"), ""); } } } return(result); }
public static object GetCustomTableValue(EvaluationContext context, params object[] parameters) { if (parameters.Length == 3) { string customTableCodeName = ValidationHelper.GetString(parameters[0], ""); int customTableID = ValidationHelper.GetInteger(parameters[1], -1); string customTableReturnFieldName = ValidationHelper.GetString(parameters[2], ""); CustomTableItem cti = CustomTableItemProvider.GetItem(customTableID, customTableCodeName); if (cti != null) { return(cti.GetValue(customTableReturnFieldName)); } else { return(null); } } else { throw new NotSupportedException("Custom macro GetCustomTableValue() requires three parameters"); } }
/// <summary> /// Lấy mã định danh mới /// </summary> /// <param name="dataYear">Mã theo năm</param> /// <param name="dataTable">Tiếp đầu ngữ của bảng</param> /// <param name="dataLen">Chiều dài số tự tăng</param> /// <param name="dataTXT">Mô tả về mã định danh</param> /// <returns>Mã định danh</returns> public static string Fn_Get_MaDinhDanh(string dataYear, string dataTable, int dataLen, string dataTXT) { string maDinhDanh; string dataYY = string.IsNullOrEmpty(dataYear) ? DateTime.Now.Year.ToString().Substring(2, 2) : dataYear.Substring(2, 2); // Create new Custom table item provider CustomTableItemProvider customTableProvider = new CustomTableItemProvider(CMSContext.CurrentUser); // Prepares the code name of the custom table string Code_MaLuuTru = "DX.MaLuuTru"; // Check if Custom table exists DataClassInfo DX_MaLuuTru = DataClassInfoProvider.GetDataClass(Code_MaLuuTru); maDinhDanh = "19000001"; if (DX_MaLuuTru != null) { // Prepare the parameters string where = string.Format("MaTXT = '{0}{1}'", dataTable, dataYY); // Get the data set according to the parameters DataSet dataSet = customTableProvider.GetItems(Code_MaLuuTru, where, null, 1, "ItemID"); 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 DX_MaLuuTru_Item = customTableProvider.GetItem(itemID, Code_MaLuuTru); if (DX_MaLuuTru_Item != null) { string maTXT = ValidationHelper.GetString(DX_MaLuuTru_Item.GetValue("MaTXT"), ""); int maNUM = ValidationHelper.GetInteger(DX_MaLuuTru_Item.GetValue("MaNUM"), 0); int maLEN = ValidationHelper.GetInteger(DX_MaLuuTru_Item.GetValue("MaLEN"), 0); // Set new values DX_MaLuuTru_Item.SetValue("MaNUM", maNUM + 1); // Save the changes DX_MaLuuTru_Item.Update(); StringBuilder sb = new StringBuilder(); string newText = sb.Append('0', maLEN - maNUM.ToString().Length).ToString() + maNUM + 1; maDinhDanh = maTXT + newText; } } else { // Create new custom table item CustomTableItem newItem = new CustomTableItem(Code_MaLuuTru, customTableProvider); // Set the ItemText field value newItem.SetValue("MaTXT", dataTable + dataYY); newItem.SetValue("maNUM", 1); newItem.SetValue("maLEN", dataLen); newItem.SetValue("ActiveNUM", true); newItem.SetValue("MoTaTXT", dataTXT); // Insert the custom table item into database newItem.Insert(); StringBuilder sb = new StringBuilder(); string newText = dataTable + dataYY + sb.Append('0', dataLen - 0.ToString().Length).ToString() + 1; maDinhDanh = newText; } } // Return return(maDinhDanh); }
/// <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 = new CustomTableItem(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; }