protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
string foldername = Request.Form["foldername"];
string selectid = Request.Form["selectid"];
string message = Request.Form["message"];
if (selectid.Contains("root"))
{
selectid = selectid.Remove(0, "root".Length);
eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders();
model.Foldername = foldername.Trim();
model.ParentID = int.Parse(selectid);
model.isDeleted = 1;
model.isOffline = 0;
Fbll.Add(model);
Response.Write("success");
Response.End();
}
else if (selectid.Contains("folder"))
{
selectid = selectid.Remove(0, "folder".Length);
//insert message
eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message();
model.Question = message.Trim();
model.FolderID = int.Parse(selectid);
model.isOffLine = 0;
model.isPublic = 1;
model.isVariations = 0;
model.RelatedID = 0;
model.sortOrder = SortOrderHelper.GetSortOrder(model.FolderID);
model.isDeleted = 1;
bll.Add(model);
//insert answer
eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers();
ansmodel.Answer = "";
ansmodel.MessageID = bll.GetMaxId() - 1;
ansmodel.isDeleted = 0;
abll.Add(ansmodel);
Response.Write("success");
Response.End();
}
}
catch
{
}
}
}
public void PasteFromCopy()
{
try
{
if (toID.Contains(Nodetype.message.ToString()))
{
int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length));
int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length));
eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message();
model = bll.GetModel(iMsgID);
model.FolderID = iToFolderID;
model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID);
bll.Add(model);
int newID = bll.GetMaxId() - 1;
//add variation
DataSet ds = bll.GetList(" relatedid = " + iMsgID);
if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
model.ID = int.Parse(dr["ID"].ToString());
model.RelatedID = newID;
model.Question = dr["Question"].ToString();
model.isOffLine = 0;
model.isPublic = 1;
model.isVariations = 1;//设置成true
model.isDeleted = 1;
model.FolderID = null;
model.sortOrder = null;
bll.Add(model);
}
}
eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers();
//if answer exist, update answer ,else if answer not exist,add answer
ds = abll.GetList(" messageid = " + iMsgID);
if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0)
{
//insert answer with answer content
ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString();
ansmodel.MessageID = newID;
ansmodel.isDeleted = 0;
abll.Add(ansmodel);
}
else
{
//insert answer without content
ansmodel.Answer = "";
ansmodel.MessageID = newID;
ansmodel.isDeleted = 0;
abll.Add(ansmodel);
}
}
}
catch
{
}
}
/// <summary>
/// The PostgreSQL index sort ordering to be used.
/// </summary>
/// <remarks>
/// https://www.postgresql.org/docs/current/static/indexes-ordering.html
/// </remarks>
/// <param name="indexBuilder">The builder for the index being configured.</param>
/// <param name="values">The sort order to use for each column.</param>
/// <returns>A builder to further configure the index.</returns>
public static IndexBuilder HasSortOrder(
this IndexBuilder indexBuilder,
params SortOrder[]?values)
{
Check.NotNull(indexBuilder, nameof(indexBuilder));
Check.NullButNotEmpty(values, nameof(values));
if (!SortOrderHelper.IsDefaultSortOrder(values))
{
indexBuilder.Metadata.SetSortOrder(values);
}
return(indexBuilder);
}
private void CopyNextTo([NotNull] DragCopyPipeline pipeline)
{
Debug.ArgumentNotNull(pipeline, nameof(pipeline));
int sortOrder;
int sortOrderDelta;
ItemTreeViewItem parent;
ItemTreeViewItem anchor;
SortOrderHelper.GetSortOrder(pipeline.Target, pipeline.Position, pipeline.Items.Count(), out sortOrder, out sortOrderDelta, out parent, out anchor);
if (parent == null)
{
AppHost.MessageBox(Resources.CopyItems_CopyNextTo_Parent_is_not_an_item, Resources.Error, MessageBoxButton.OK, MessageBoxImage.Error);
pipeline.Abort();
return;
}
pipeline.Owner = parent;
pipeline.Anchor = anchor;
var fieldId = IdManager.GetFieldId("/sitecore/templates/System/Templates/Sections/Appearance/Appearance/__Sortorder");
foreach (var item in pipeline.Items)
{
var newName = string.Format(Resources.CopyItems_CopyNextTo_Copy_of__0_, item.Name);
var newItemUri = item.ItemUri.Site.DataService.Copy(item.ItemUri, parent.ItemUri.ItemId, newName);
if (newItemUri == ItemUri.Empty)
{
AppHost.MessageBox(string.Format(Resources.CopyItems_CopyNextTo_Failed_to_copy___0_, item.Name), Resources.Error, MessageBoxButton.OK, MessageBoxImage.Information);
pipeline.Abort();
return;
}
var newItem = new DragCopyPipeline.NewItem
{
Item = item,
NewName = newName,
NewItemUri = newItemUri,
SortOrder = sortOrder
};
ItemModifier.Edit(newItemUri, fieldId, sortOrder.ToString(CultureInfo.InvariantCulture));
sortOrder += sortOrderDelta;
pipeline.NewItems.Add(newItem);
}
}
/// <summary>
/// The PostgreSQL index NULL sort ordering to be used.
/// </summary>
/// <remarks>
/// https://www.postgresql.org/docs/current/static/indexes-ordering.html
/// </remarks>
/// <param name="indexBuilder">The builder for the index being configured.</param>
/// <param name="values">The sort order to use for each column.</param>
/// <returns>A builder to further configure the index.</returns>
public static IndexBuilder HasNullSortOrder(
[NotNull] this IndexBuilder indexBuilder,
[CanBeNull] params NullSortOrder[] values)
{
Check.NotNull(indexBuilder, nameof(indexBuilder));
Check.NullButNotEmpty(values, nameof(values));
var sortOrders = indexBuilder.Metadata.GetSortOrder();
if (!SortOrderHelper.IsDefaultNullSortOrder(values, sortOrders))
{
indexBuilder.Metadata.SetNullSortOrder(values);
}
return(indexBuilder);
}
/// <summary>
/// The PostgreSQL index NULL sort ordering to be used.
/// </summary>
/// <remarks>
/// https://www.postgresql.org/docs/current/static/indexes-ordering.html
/// </remarks>
/// <param name="indexBuilder">The builder for the index being configured.</param>
/// <param name="values">The sort order to use for each column.</param>
/// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param>
/// <returns>A builder to further configure the index.</returns>
public static IConventionIndexBuilder?HasNullSortOrder(
this IConventionIndexBuilder indexBuilder,
IReadOnlyList <NullSortOrder>?values,
bool fromDataAnnotation)
{
if (indexBuilder.CanSetNullSortOrder(values, fromDataAnnotation))
{
if (!SortOrderHelper.IsDefaultNullSortOrder(values, indexBuilder.Metadata.IsDescending))
{
indexBuilder.Metadata.SetNullSortOrder(values, fromDataAnnotation);
}
return(indexBuilder);
}
return(null);
}
/// <summary>
/// The PostgreSQL index NULL sort ordering to be used.
/// </summary>
/// <remarks>
/// https://www.postgresql.org/docs/current/static/indexes-ordering.html
/// </remarks>
/// <param name="indexBuilder">The builder for the index being configured.</param>
/// <param name="values">The sort order to use for each column.</param>
/// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param>
/// <returns>A builder to further configure the index.</returns>
public static IConventionIndexBuilder HasNullSortOrder(
[NotNull] this IConventionIndexBuilder indexBuilder,
[CanBeNull] IReadOnlyList <NullSortOrder> values,
bool fromDataAnnotation)
{
if (indexBuilder.CanSetNullSortOrder(values, fromDataAnnotation))
{
var sortOrders = indexBuilder.Metadata.GetSortOrder();
if (!SortOrderHelper.IsDefaultNullSortOrder(values, sortOrders))
{
indexBuilder.Metadata.SetNullSortOrder(values, fromDataAnnotation);
}
return(indexBuilder);
}
return(null);
}
/// <summary>
/// The PostgreSQL index sort ordering to be used.
/// </summary>
/// <remarks>
/// https://www.postgresql.org/docs/current/static/indexes-ordering.html
/// </remarks>
/// <param name="indexBuilder">The builder for the index being configured.</param>
/// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param>
/// <param name="values">The sort order to use for each column.</param>
/// <returns>A builder to further configure the index.</returns>
public static IConventionIndexBuilder?HasSortOrder(
this IConventionIndexBuilder indexBuilder,
IReadOnlyList <SortOrder>?values,
bool fromDataAnnotation)
{
if (indexBuilder.CanSetSortOrder(values, fromDataAnnotation))
{
Check.NotNull(indexBuilder, nameof(indexBuilder));
Check.NullButNotEmpty(values, nameof(values));
if (!SortOrderHelper.IsDefaultSortOrder(values))
{
indexBuilder.Metadata.SetSortOrder(values, fromDataAnnotation);
}
return(indexBuilder);
}
return(null);
}
public async Task <ActionResult> Get(long userId, int?pageSize = null, int?pageNumber = null, string sortOrder = null)
{
SortOrder parsedSortOrder = SortOrder.Descending; //Default sort order shows most recent items first
if (!string.IsNullOrEmpty(sortOrder))
{
//If sort order is not null, check it has a valid value
if (!SortOrderHelper.TryParse(sortOrder, out parsedSortOrder))
{
return(BadRequest($"Sort order '' is not valid, enter ASC or DESC"));
}
}
var charges = await _chargeRepository.ListAsync(
predicate : x => x.Event.User.Id == userId,
sortOptions : new SortOptions(nameof(Charge.Id), parsedSortOrder),
pageSize : pageSize,
pageNumber : pageNumber);
return(Ok(_mapper.Map <List <GetChargeResponse> >(charges)));
}
public void PasteFromCut()
{
if (toID.Contains(Nodetype.message.ToString()))
{
int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length));
int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length));
eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message();
model = bll.GetModel(iMsgID);
model.FolderID = iToFolderID;
model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID);
bll.Add(model);
int newID = bll.GetMaxId() - 1;
//add variation
DataSet ds = bll.GetList(" relatedid = " + iMsgID);
if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
model.ID = int.Parse(dr["ID"].ToString());
model.RelatedID = newID;
model.Question = dr["Question"].ToString();
model.isOffLine = 0;
model.isPublic = 1;
model.isVariations = 1;//设置成true
model.isDeleted = 1;
model.FolderID = null;
model.sortOrder = null;
bll.Add(model);
}
}
eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers();
//if answer exist, update answer ,else if answer not exist,add answer
string ans = string.Empty;
ds = abll.GetList(" messageid = " + iMsgID);
if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0)
{
//insert answer with answer content
ans = ds.Tables[0].Rows[0]["answer"].ToString();
ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString();
ansmodel.MessageID = newID;
ansmodel.isDeleted = 0;
abll.Add(ansmodel);
}
else
{
//insert answer
ansmodel.Answer = "";
ansmodel.MessageID = newID;
ansmodel.isDeleted = 0;
abll.Add(ansmodel);
}
int newAnsID = abll.GetMaxId() - 1;
//if rule exist, update rule
eChartProject.Model.eChart.server_contents_rule rulemodel = new eChartProject.Model.eChart.server_contents_rule();
ds = RuleBll.GetList(" messageid = " + iMsgID);
if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//insert rule
rulemodel.MessageID = newID;
rulemodel.Rule1 = dr["Rule1"].ToString();
RuleBll.Add(rulemodel);
int newRuleID = RuleBll.GetMaxId() - 1;
//update answer
ansmodel.ID = newAnsID;
ansmodel.Answer = ans.Replace("<img id=\"" + dr["ID"].ToString() + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />", "<img id=\"" + newRuleID + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />");
ansmodel.MessageID = newID;
ansmodel.isDeleted = 0;
abll.Update(ansmodel);
ans = ansmodel.Answer;
}
}
bll.Delete(iMsgID);
}
}
