public static long GetDefaultCnsDataRefTypeId() { long defaultRefTypeId = 1; CNS_DataRefType defaultCnsDataRefType = GetDefaultCnsDataRefType(); if (defaultCnsDataRefType != null) defaultRefTypeId = defaultCnsDataRefType.DataRefTypeID; return defaultRefTypeId; }
public static bool DeleteCnsDataRefType(long dataRefTypeId, out string retMessage) { bool ret = false; string message = ""; try { bool validationFail = false; if (UtilsSecurity.HaveAdminRole() == false) { message = "Please login as User having admin Role to Delete RefType"; validationFail = true; } if (validationFail == false) { if (dataRefTypeId == 0) { message = "Missing or Empty DataRefType ID Argument"; validationFail = true; } } if (validationFail == false) { CNS_DataRefType cnsDataRefTypeExisting = GetCnsDataRefType(dataRefTypeId); if (cnsDataRefTypeExisting == null) { message = "The DataRefType with ID [" + dataRefTypeId.ToString(CultureInfo.InvariantCulture) + "] does not exist"; validationFail = true; } else if (cnsDataRefTypeExisting.IsSystem) { message = "The System Data RefType Cannot be Deleted"; validationFail = true; } else if (cnsDataRefTypeExisting.IsDefault) { message = "Please set another DataRefType as Default and then Delete this RefType"; validationFail = true; } } if (validationFail == false) { DataSource.BeginTransaction(); DataSource.DeleteCnsDataRefType(dataRefTypeId); DataSource.CompleteTransaction(); ret = true; } } catch (Exception ex) { message = "DBError:" + ex.Message; LogManager.Log(LogLevel.Error, "DataCommon-DeleteCnsDataRefType", message); } retMessage = message; return(ret); }
public static CNS_DataRefType GetDefaultCnsDataRefType() { CNS_DataRefType defaultCnsDataRefType = null; Database db = HaveDb(); if (db != null) { defaultCnsDataRefType = db.SingleOrDefault<CNS_DataRefType>("SELECT * FROM CNS_DataRefType Where IsDefault=@0", 1); } else { Dictionary<Guid, CNS_DataRefType> allCnsDataRefTypeList = FileSource.LoadCNSDataRefTypeData(); foreach (KeyValuePair<Guid, CNS_DataRefType> item in allCnsDataRefTypeList) { if (item.Value.IsDefault == true) { defaultCnsDataRefType = item.Value; break; } } } return defaultCnsDataRefType; }
private static string GetListSingleItemView(CNS_DataRefType cnsDataRefType, long pageNo, long itemsPerPage, long dataIndex, string templateSuffix) { string htmlTextItem = ""; if (cnsDataRefType != null) { string message; List <TemplateDataRefTypeListDetailItem.EditAction> editActionList = new List <TemplateDataRefTypeListDetailItem.EditAction>(); if (UtilsSecurity.HaveAdminRole() == true) { editActionList.Add(new TemplateDataRefTypeListDetailItem.EditAction { Id = cnsDataRefType.DataRefTypeID.ToString(), DataIndex = dataIndex.ToString(), PageNo = pageNo.ToString(), ItemsPerPage = itemsPerPage.ToString(), TemplateSuffix = templateSuffix }); } var templateItem = new TemplateDataRefTypeListDetailItem { DataRefType = cnsDataRefType.DataRefType, IsDefault = cnsDataRefType.IsDefault, IsInActive = !cnsDataRefType.IsActive, EditActionList = editActionList }; htmlTextItem = templateItem.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } return(htmlTextItem); }
public static bool SaveCNSDataRefTypeData(Dictionary <Guid, CNS_DataRefType> cnsDataRefTypeList) { bool ret = false; if (cnsDataRefTypeList.Count > 0) { List <CNS_DataRefType> cnsDataRefTypeValueList = new List <CNS_DataRefType>(); CNS_DataRefType[] cnsDataRefTypeArray = new CNS_DataRefType[cnsDataRefTypeList.Values.Count]; cnsDataRefTypeList.Values.CopyTo(cnsDataRefTypeArray, 0); cnsDataRefTypeValueList.AddRange(cnsDataRefTypeArray); ret = JsonStore <CNS_DataRefType> .SaveData(cnsDataRefTypeValueList, true); } return(ret); }
public static long SaveCnsDataRefType(string dataRefType, bool dataRefTypeIsDefault, bool dataRefTypeIsActive, long dataRefTypeId, out string retMessage) { long id = 0; string message = ""; try { bool validationFail = false; if (UtilsSecurity.HaveAdminRole() == false) { message = "Please login as User Having Admin to Save RefType"; validationFail = true; } if (validationFail == false) { if (string.IsNullOrEmpty(dataRefType) == true) { message = "Missing or Empty DataRefType Argument"; validationFail = true; } } if (validationFail == false) { CNS_DataRefType cnsDataRefTypeExisting = GetCnsDataRefType(dataRefType); if ((cnsDataRefTypeExisting != null) && (cnsDataRefTypeExisting.DataRefTypeID != dataRefTypeId)) { message = "The DataRefType [" + dataRefType + "] allready exists"; validationFail = true; } } var cnsDataRefType = new CNS_DataRefType(); if (validationFail == false) { if (dataRefTypeId != 0) { cnsDataRefType = GetCnsDataRefType(dataRefTypeId); if (cnsDataRefType == null) { message = "The DataRefType having ID [" + dataRefTypeId + "] cannot be Retrieved"; validationFail = true; } } } if (validationFail == false) { long maxRefTypeId = GetMaxCnsDataRefTypeId() + 1; cnsDataRefType.IsActive = dataRefTypeIsActive; if (dataRefTypeId == 0) { cnsDataRefType.Sequence = maxRefTypeId; cnsDataRefType.IsActive = true; cnsDataRefType.IsSystem = false; } cnsDataRefType.DataRefType = dataRefType; cnsDataRefType.IsDefault = dataRefTypeIsDefault; DataSource.BeginTransaction(); if (cnsDataRefType.IsDefault) { CNS_DataRefType defaultCnsDataRefType = GetDefaultCnsDataRefType(); if (defaultCnsDataRefType != null) { if (defaultCnsDataRefType.DataRefTypeID != cnsDataRefType.DataRefTypeID) { defaultCnsDataRefType.IsDefault = false; DataSource.UpdateCnsDataRefType(defaultCnsDataRefType); } } } if (cnsDataRefType.DataRefTypeID == 0) { cnsDataRefType.DataRefTypeID = maxRefTypeId; DataSource.InsertCnsDataRefType(cnsDataRefType); id = cnsDataRefType.DataRefTypeID; } else { DataSource.UpdateCnsDataRefType(cnsDataRefType); id = cnsDataRefType.DataRefTypeID; } DataSource.CompleteTransaction(); } } catch (Exception ex) { id = 0; message = "DBError:" + ex.Message; LogManager.Log(LogLevel.Error, "DataCommon-SaveCnsDataRefType", message); DataSource.AbortTransaction(); } retMessage = message; return(id); }
public static long SaveCndData(long parentDataId, long dataRefId, long dataRefTypeId, long dataTypeId, string dataValue, bool dataIsActive, bool isPublic, long dataId, out string retMessage) { long id = 0; string message = ""; try { bool validationFail = false; if (isPublic == false) { if ((UtilsSecurity.HaveAdminRole() == false) && (UtilsSecurity.HaveAuthorRole() == false)) { message = "Please login as User Having Admin/Author Role to Save Data"; validationFail = true; } } if (validationFail == false) { if ((dataRefTypeId == 0) || (dataTypeId == 0) || (string.IsNullOrEmpty(dataValue) == true)) { message = "Missing or Empty Data Argument"; validationFail = true; } } CND_Data cndData = new CND_Data(); if (validationFail == false) { if (dataId != 0) { cndData = GetCndData(dataId); if (cndData == null) { message = "The Data having ID [" + dataId + "] cannot be Retrieved"; validationFail = true; } else { if ((cndData.UserID != UtilsSecurity.GetUserId()) && (UtilsSecurity.HaveAdminRole() == false)) { message = "The Data having ID [" + dataId + "] can be edited only the User who created it"; validationFail = true; } } } } Guid parentDataGuid = Guid.Empty; if (validationFail == false) { if (parentDataId != 0) { CND_Data cndDataParent = GetCndData(parentDataId); if (cndDataParent == null) { message = "The Parent Data having ID [" + parentDataId + "] cannot be Retrieved"; validationFail = true; } else { parentDataGuid = cndDataParent.DataGUID; } } } CNS_DataType cnsDataType = GetCnsDataType(dataTypeId); if (validationFail == false) { if (cnsDataType == null) { message = "The DataType [" + dataTypeId + "] does not exist"; validationFail = true; } } CNS_DataRefType cnsDataRefType = GetCnsDataRefType(dataRefTypeId); if (validationFail == false) { if (cnsDataRefType == null) { message = "The DataRefType [" + dataRefTypeId + "] does not exist"; validationFail = true; } } if (validationFail == false) { cndData.IsActive = dataIsActive; if (dataId == 0) { cndData.Sequence = GetMaxCndDataId() + 1; cndData.IsActive = true; } cndData.DataTypeID = cnsDataType.DataTypeID; cndData.DataTypeGUID = cnsDataType.DataTypeGUID; cndData.DataRefTypeID = cnsDataRefType.DataRefTypeID; cndData.DataRefTypeGUID = cnsDataRefType.DataRefTypeGUID; cndData.DataRefID = dataRefId; cndData.DataValue = dataValue; if (parentDataId > 0) { cndData.ParentDataID = parentDataId; cndData.ParentDataGUID = parentDataGuid; } DataSource.BeginTransaction(); if (cndData.DataID == 0) { DataSource.InsertCndData(cndData); id = cndData.DataID; } else { DataSource.UpdateCndData(cndData); id = cndData.DataID; } DataSource.CompleteTransaction(); } } catch (Exception ex) { id = 0; message = "DBError:" + ex.Message; LogManager.Log(LogLevel.Error, "DataCommon-SaveCndData", message); DataSource.AbortTransaction(); } retMessage = message; return(id); }
public static CNS_DataRefType GetCnsDataRefType(long dataRefTypeID) { CNS_DataRefType cnsDataRefType = DataSource.GetCnsDataRefType(dataRefTypeID, ""); return(cnsDataRefType); }
public static string GetListAllItemView(long pageNo, long itemsPerPage, long dataIndex, string templateSuffix) { string message = ""; if (itemsPerPage == 0) { itemsPerPage = UtilsGeneric.DefaultItemsPerPage; } long totalPages; long totalItems; string htmlTextItemList = ""; string htmlAddItemList = ""; if (UtilsSecurity.HaveAdminRole() == false) { TemplateDataRefTypeView dataRefTypeView = new TemplateDataRefTypeView { DataIndex = dataIndex.ToString(), PageNo = pageNo.ToString(), ItemsPerPage = itemsPerPage.ToString(), TemplateSuffix = templateSuffix, }; htmlTextItemList = dataRefTypeView.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } else { #region Add Link if (UtilsSecurity.HaveAdminRole() == true) { TemplateDataRefTypeSaveAdd templateSaveAdd = new TemplateDataRefTypeSaveAdd { DataIndex = dataIndex.ToString(), PageNo = pageNo.ToString(), ItemsPerPage = itemsPerPage.ToString(), TemplateSuffix = templateSuffix, }; htmlAddItemList = templateSaveAdd.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } #endregion #region Get Fill List #region Get Paged Data List <CNS_DataRefType> cnsDataRefTypeList = DataCommon.GetAllCnsDataRefType(pageNo, itemsPerPage, out totalPages, out totalItems); #endregion if (cnsDataRefTypeList.Count > 0) { #region Get Pager Details string topPagerDetails = UtilsGeneric.GetItemPagerView(pageNo, itemsPerPage, dataIndex, templateSuffix, totalPages, RefreshListFunctionName, ""); string bottomPagerDetails = UtilsGeneric.GetLinkPagerView(pageNo, itemsPerPage, dataIndex, templateSuffix, totalPages, totalItems, RefreshListFunctionName, ""); #endregion #region Append Top Pager if (topPagerDetails.Trim().Length > 0) { htmlTextItemList += topPagerDetails; } #endregion #region Append Items int index = 0; for (; index < cnsDataRefTypeList.Count; index++) { CNS_DataRefType cnsDataRefType = cnsDataRefTypeList[index]; string htmlTextItemTemplate = GetListSingleItemView(cnsDataRefType, pageNo, itemsPerPage, dataIndex, templateSuffix); htmlTextItemList += htmlTextItemTemplate; } #endregion #region Append Bottom Pager if (bottomPagerDetails.Trim().Length > 0) { htmlTextItemList += bottomPagerDetails; } #endregion } #endregion #region Set Fill List if (htmlTextItemList.Length == 0) { TemplateDataRefTypeListDetailEmpty dataRefTypeListDetailEmpty = new TemplateDataRefTypeListDetailEmpty { DataIndex = dataIndex.ToString(), PageNo = pageNo.ToString(), ItemsPerPage = itemsPerPage.ToString(), TemplateSuffix = templateSuffix, }; htmlTextItemList = dataRefTypeListDetailEmpty.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } #endregion } return(htmlAddItemList + htmlTextItemList); }
public static string GetSaveDetailView(long dataRefTypeId, long pageNo, long itemsPerPage, long dataIndex, string templateSuffix) { string message = ""; string htmlSaveDetail = ""; long revisionNo = 0; string dataRefTypeName = ""; bool dataRefTypeIsDefault = false; bool dataRefTypeIsActive = true; bool dataRefTypeIsSystem = false; if (UtilsSecurity.HaveAdminRole() == false) { TemplateDataRefTypeView dataRefTypeView = new TemplateDataRefTypeView { DataIndex = dataIndex.ToString(), PageNo = pageNo.ToString(), ItemsPerPage = itemsPerPage.ToString(), TemplateSuffix = templateSuffix }; htmlSaveDetail = dataRefTypeView.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } else { #region Get DataRefType Details if (dataRefTypeId > 0) { CNS_DataRefType cnsDataRefTypeExisting = DataCommon.GetCnsDataRefType(dataRefTypeId); if (cnsDataRefTypeExisting != null) { dataRefTypeName = cnsDataRefTypeExisting.DataRefType; dataRefTypeIsDefault = cnsDataRefTypeExisting.IsDefault; dataRefTypeIsActive = cnsDataRefTypeExisting.IsActive; dataRefTypeIsSystem = cnsDataRefTypeExisting.IsSystem; revisionNo = cnsDataRefTypeExisting.RevisionNo; } } #endregion #region Set Action bool showAdminInfo = false; bool enableSave = true; bool enableDelete = true; if (UtilsSecurity.HaveAdminRole() == false) { showAdminInfo = true; enableSave = false; enableDelete = false; } #endregion #region Set Template string addActionHtml = ""; string editActionHtml = ""; if (dataRefTypeId == 0) { var templateSaveAdd = new TemplateDataRefTypeSaveDetailAdd { AddActionDisabled = !enableSave, DataIndex = dataIndex.ToString("N0", CultureInfo.InvariantCulture), PageNo = pageNo.ToString("N0", CultureInfo.InvariantCulture), ItemsPerPage = itemsPerPage.ToString("N0", CultureInfo.InvariantCulture), TemplateSuffix = templateSuffix, }; addActionHtml = templateSaveAdd.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } else { var templateSaveEdit = new TemplateDataRefTypeSaveDetailEdit { Id = dataRefTypeId.ToString(), DataIndex = dataIndex.ToString("N0", CultureInfo.InvariantCulture), PageNo = pageNo.ToString("N0", CultureInfo.InvariantCulture), ItemsPerPage = itemsPerPage.ToString("N0", CultureInfo.InvariantCulture), TemplateSuffix = templateSuffix, SaveActionDisabled = !enableSave, DeleteActionDisabled = !enableDelete, }; editActionHtml = templateSaveEdit.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); } List <TemplateDataRefTypeSaveDetail.DataRefTypeNameEnabled> dataRefTypeNameEnabledList = new List <TemplateDataRefTypeSaveDetail.DataRefTypeNameEnabled>(); List <TemplateDataRefTypeSaveDetail.DataRefTypeNameDisabled> dataRefTypeNameDisabledList = new List <TemplateDataRefTypeSaveDetail.DataRefTypeNameDisabled>(); if (dataRefTypeIsSystem == false) { dataRefTypeNameEnabledList.Add(new TemplateDataRefTypeSaveDetail.DataRefTypeNameEnabled { DataRefType = dataRefTypeName, AddMode = (dataRefTypeId == 0) ? true : false, }); } else { dataRefTypeNameDisabledList.Add(new TemplateDataRefTypeSaveDetail.DataRefTypeNameDisabled { DataRefType = dataRefTypeName, AddMode = (dataRefTypeId == 0) ? true : false, }); } List <TemplateDataRefTypeSaveDetail.IsActiveVisible> isActiveVisibleList = new List <TemplateDataRefTypeSaveDetail.IsActiveVisible>(); if (dataRefTypeIsActive == true) { isActiveVisibleList.Add(new TemplateDataRefTypeSaveDetail.IsActiveVisible { IsActive = true }); } var templateSaveDetail = new TemplateDataRefTypeSaveDetail { //Id = dataRefTypeId.ToString("N0", CultureInfo.InvariantCulture), RevisionNo = revisionNo.ToString(), DataRefTypeNameEnabledList = dataRefTypeNameEnabledList, DataRefTypeNameDisabledList = dataRefTypeNameDisabledList, IsDefault = dataRefTypeIsDefault, IsActiveVisibleList = isActiveVisibleList, AddAction = addActionHtml, EditAction = editActionHtml, ShowAdminInfo = showAdminInfo, }; htmlSaveDetail = templateSaveDetail.GetFilled(templateSuffix, UtilsGeneric.Validate, UtilsGeneric.ThrowException, out message); #endregion } return(htmlSaveDetail); }