public List<ListItem> ExecuteQuery(ListQuery query)
{
using (var site = CreateSite(query.List.Web.Url))
{
using (var web = site.OpenWeb())
{
var serverList = web.Lists.TryGetList(query.List.Title);
var listQuery = new SPQuery { Query = query.Query };
return serverList.GetItems(listQuery).Cast<SPListItem>()
.Select(i => new ListItem(query.List)
{
Id = i.ID,
Columns =
query.List
.Fields
.ToDictionary(
f => f.InternalName,
f => i.GetFormattedValue(f.InternalName))
})
.ToList();
}
}
}
//[OutputCache(NoStore = true, Duration = 0, VaryByParam = "None")]
public Object Post(ApiRequestType requestType)
{
var curUser = _service.GetCurrentUser();
if (requestType.RequestType == "currentUserDetail")
{
return(_service.GetCurrentUser());
}
else if (requestType.RequestType == "getDepartmentHead")
{
ListQuery <User> query = new ListQuery <User>();
query.PageSize = 999;
query.Parameters = new List <QueryParameter>();
query.Parameters.Add(new QueryParameter()
{
Name = "DHDivisionId", Value = requestType.Parameters.ElementAt(0).Value
});
//query.Parameters.Add(new QueryParameter() { Name = "DepartmentHead", Value = "yes" });
var list = _service.GetByQuery(query);
return(list);
}
else if (requestType.RequestType == "getDeparmtmentOwner")
{
ListQuery <User> query = new ListQuery <User>();
query.PageSize = 999;
query.Parameters = new List <QueryParameter>();
query.Parameters.Add(new QueryParameter()
{
Name = "DODivisionId", Value = requestType.Parameters.ElementAt(0).Value
});
//query.Parameters.Add(new QueryParameter() { Name = "DeparmtmentOwner", Value = "yes" });
var list = _service.GetByQuery(query);
return(list);
}
else if (requestType.RequestType == "ResponsibleUsers")
{
ListQuery <User> query = new ListQuery <User>();
if (requestType.Parameters != null)
{
foreach (var p in requestType.Parameters)
{
query.PageSize = 999;
query.Parameters = new List <QueryParameter>();
query.Parameters.Add(new QueryParameter()
{
Name = "ResponsibleUsers", Value = requestType.Parameters.ElementAt(0).Value
});
if (p.Name == "filterText")
{
query.Parameters.Add(new QueryParameter()
{
Name = "filterText", Value = p.Value
});
}
}
}
var list = _service.GetByQuery(query);
return(list);
}
else if (requestType.RequestType == "User")
{
ListQuery <User> query = new ListQuery <User>();
if (requestType.Parameters != null)
{
foreach (var p in requestType.Parameters)
{
query.PageSize = 999;
query.Parameters = new List <QueryParameter>();
query.Parameters.Add(new QueryParameter()
{
Name = "User", Value = requestType.Parameters.ElementAt(0).Value
});
if (p.Name == "filterText")
{
query.Parameters.Add(new QueryParameter()
{
Name = "filterText", Value = p.Value
});
}
}
}
var list = _service.GetByQuery(query);
return(list);
}
else if (requestType.RequestType == "DependentUsers")
{
ListQuery <User> query = new ListQuery <User>();
if (requestType.Parameters != null)
{
foreach (var p in requestType.Parameters)
{
query.PageSize = 999;
query.Parameters = new List <QueryParameter>();
query.Parameters.Add(new QueryParameter()
{
Name = "DependentUsers", Value = requestType.Parameters.ElementAt(0).Value
});
if (p.Name == "filterText")
{
query.Parameters.Add(new QueryParameter()
{
Name = "filterText", Value = p.Value
});
}
}
}
var list = _service.GetByQuery(query);
return(list);
}
return(null);
}
public async Task <List <PublisherViewModel> > Handle(ListQuery request, CancellationToken cancellationToken)
{
var publisherSet = await _context.Publishers.PagedToListAsync(request.Page, request.PageSize);
return(PublisherViewModel.CreateFromPublishers(publisherSet).ToList());
}
public int Count(ListQuery listQuery, object query = null)
{
return(UnitOfWork.Session.ExecuteScalar <int>(@"SELECT COUNT(*) FROM Organizations"));
}
// Methods
public void Start(string[] args)
{
// Get credential
var credential = AuthorizationManager <ServiceCredential> .GetCredential(
new ServiceAccountProvider(),
ApiKeyPath,
ApplicationScopes);
// Create request
var requestFactory = new GDataRequestFactory(null);
requestFactory.CustomHeaders.Add("Authorization: Bearer " + ((ServiceAccountCredential)credential).Token.AccessToken);
// Create service using the request
var service = new SpreadsheetsService(null)
{
RequestFactory = requestFactory
};
// Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
string docKey = "1dAa5tHdqkq2brQ5pfoFjiv1GkVxge52bn99Oz2AgrQw";
string gDocsURL = "https://spreadsheets.google.com/feeds/spreadsheets/private/full/{0}";
string docURL = String.Format(gDocsURL, docKey);
SpreadsheetQuery query = new SpreadsheetQuery()
{
Uri = new Uri(docURL)
};
// Make a request to the API and get all spreadsheets.
SpreadsheetFeed feed = service.Query(query);
if (feed.Entries.Count == 0)
{
Console.WriteLine("There are no sheets");
}
SpreadsheetEntry spreadsheet = feed.Entries.SingleOrDefault() as SpreadsheetEntry;
var worksheet = spreadsheet.Worksheets.Entries.SingleOrDefault(e => (e as WorksheetEntry).Title.Text == "Data") as WorksheetEntry;
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listQuery.SpreadsheetQuery = "type=Sales";
ListFeed listFeed = service.Query(listQuery);
Console.WriteLine(listFeed.Entries.Count);
return;
// Iterate through each row, printing its cell values.
foreach (ListEntry row in listFeed.Entries)
{
// Print the first column's cell value
Console.WriteLine(row.Title.Text);
// Iterate over the remaining columns, and print each cell value
foreach (ListEntry.Custom element in row.Elements)
{
Console.WriteLine(element.Value);
}
}
return;
// Iterate through all of the spreadsheets returned
foreach (SpreadsheetEntry sheet in feed.Entries)
{
// Print the title of this spreadsheet to the screen
Console.WriteLine(sheet.Title.Text);
// Make a request to the API to fetch information about all
// worksheets in the spreadsheet.
var wsFeed = sheet.Worksheets;
// Iterate through each worksheet in the spreadsheet.
foreach (WorksheetEntry entry in wsFeed.Entries)
{
// Get the worksheet's title, row count, and column count.
string title = entry.Title.Text;
var rowCount = entry.Rows;
var colCount = entry.Cols;
// Print the fetched information to the screen for this worksheet.
Console.WriteLine(title + "- rows:" + rowCount + " cols: " + colCount);
//// Create a local representation of the new worksheet.
//WorksheetEntry worksheet = new WorksheetEntry();
//worksheet.Title.Text = "New Worksheet";
//worksheet.Cols = 10;
//worksheet.Rows = 20;
//// Send the local representation of the worksheet to the API for
//// creation. The URL to use here is the worksheet feed URL of our
//// spreadsheet.
//WorksheetFeed NewwsFeed = sheet.Worksheets;
//service.Insert(NewwsFeed, worksheet);
}
}
}
public async Task <ActionResult> Udklipslist(ListQuery query)
{
try
{
using (var dbmunin = new ILABNew2Entities())
{
int flicks = query.P * query.Size;
var l = await dbmunin.udklip.ToListAsync();
if (!string.IsNullOrEmpty(query.Q))
{
string[] sQuery = query.Q.Split(' ');
for (int i = 0; i < sQuery.Length; i++)
{
l = l.Where(x => x.Overskrift.ToLower().Contains(sQuery[i].ToLower()) ||
(x.Note != null && x.Note.ToLower().Contains(sQuery[i].ToLower())) ||
(x.Mappe != null && x.Mappe.ToLower().Contains(sQuery[i].ToLower()))).ToList();
}
}
var column = typeof(Udklip).GetProperty(query.S,
BindingFlags.SetProperty | BindingFlags.IgnoreCase |
BindingFlags.Public | BindingFlags.Instance);
if (column != null)
{
if (query.O.ToUpper() == "DESC")
{
l = l.OrderByDescending(x => column.GetValue(x, null)).ToList();
}
else
{
l = l.OrderBy(x => column.GetValue(x, null)).ToList();
}
}
var pageResult = l.Select(x => new UdklipDto()
{
Id = x.UdklipsID,
Datering = x.Datering,
Overskrift = x.Overskrift,
Mappe = x.Mappe
}).Skip(1).Take(query.Size);
if (l.Count > flicks)
{
pageResult = l.Select(x => new UdklipDto()
{
Id = x.UdklipsID,
Datering = x.Datering,
Overskrift = x.Overskrift,
Mappe = x.Mappe
}).Skip(flicks).Take(query.Size);
}
//1971.12.09
Regex regx = new Regex(@"^([0-9]{4})[- \/.](0[1-9]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])$");
foreach (var o in pageResult)
{
if (o.Datering == null)
{
continue;
}
if (!regx.IsMatch(o.Datering))
{
o.ErrorCode = 1;
}
}
var listResult = new MuninListViewModel <UdklipDto>()
{
Count = l.Count,
Pages = l.Count / query.Size,
Data = pageResult.ToList()
};
var result = JsonConvert.SerializeObject(listResult, Utils.JsonSettings());
return(Content(result));
}
}
catch (Exception ex)
{
return(Content("Fejl:" + ex.Message));
}
}
public async Task <ActionResult <PaginatedList <ContactDto> > > GetAll([FromQuery] ListQuery query)
{
return(await Mediator.Send(query));
}
public System.Web.Mvc.ActionResult ExportFullDumpReport(string ResponsibleEmail, string ChapterName, string Owner, string RoleName, string UserName, string TAT)
{
string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
DataTable table = new DataTable();
using (SqlConnection con1 = new SqlConnection(constr))
{
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.CommandText = "spIssueDetails";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Division", ResponsibleEmail);
cmd1.Parameters.AddWithValue("@ResponsibleEmail", ResponsibleEmail);
cmd1.Parameters.AddWithValue("@ChapterName", ChapterName);
cmd1.Parameters.AddWithValue("@Owner", Owner);
cmd1.Parameters.AddWithValue("@RoleName", RoleName);
cmd1.Parameters.AddWithValue("@UserName", UserName);
cmd1.CommandType = CommandType.StoredProcedure;
con1.Open();
cmd1.Connection = con1;
// da.SelectCommand = cmd1;
//da.Fill(dt);
using (var da = new SqlDataAdapter(cmd1))
{
da.Fill(table);
}
// }
for (int c = 0; c < table.Rows.Count - 1; c++)
{
ListQuery <IssueManagementCommentLog> query = new ListQuery <IssueManagementCommentLog>();
query.Parameters = new List <QueryParameter>();
string RequestNo = table.Rows[c]["ID_Request"].ToString();
string ChapterNameNew = table.Rows[c]["ChapterNameFromSystem"].ToString();
string PendingWithEmail = table.Rows[c]["ID_Pending_with_Email"].ToString();
string ResponsibleWithEmail = table.Rows[c]["ID_Responsible_Email"].ToString();
if (ChapterNameNew == "MyPidilite" || ChapterNameNew == "WSS Service Cell")
{
query.Parameters.Add(new QueryParameter()
{
Name = "RequestNo", Value = RequestNo
});
query.Parameters.Add(new QueryParameter()
{
Name = "ChapterName", Value = ChapterNameNew
});
query.Parameters.Add(new QueryParameter()
{
Name = "ID_Responsible_Email", Value = ResponsibleWithEmail
});
}
else
{
query.Parameters.Add(new QueryParameter()
{
Name = "RequestNo", Value = RequestNo
});
query.Parameters.Add(new QueryParameter()
{
Name = "ChapterName", Value = ChapterNameNew
});
query.Parameters.Add(new QueryParameter()
{
Name = "PendingWithEmail", Value = PendingWithEmail
});
}
var data = commentLogService.GetByQuery(query);
if (data.Items.Count > 0)
{
table.Rows[c]["ID_Comments"] = data.Items[0].ID_Comments.ToString();
}
}
}
DataRow[] DR = null;
System.Web.UI.WebControls.GridView gd = new System.Web.UI.WebControls.GridView();
if (ChapterName == "Market_Sudhar" || ChapterName == "Pilworld_WSS_feedback")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>45");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=45");
}
}
else if (ChapterName == "Dealer Feedback")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Action With Timeline", DataField = "ID_Comments" });
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>7");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=7");
}
}
else if (ChapterName == "Customer Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "Action With Timeline", DataField = "ID_Comments" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>7");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=7");
}
}
else if (ChapterName == "MyPidilite")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Latest Comments", DataField = "ID_Comments"
});
if (TAT == "Beyond")
{
DR = table.Select("id_TAT_status='Beyond TAT'");
}
else if (TAT == "Within")
{
DR = table.Select("id_TAT_status='Within TAT'");
}
}
else if (ChapterName == "WSS Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "ResponsibleWithEmail", DataField = "ID_Responsible_Email" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("id_TAT_status='Beyond TAT'");
}
else if (TAT == "Within")
{
DR = table.Select("id_TAT_status='Within TAT'");
}
}
else if (ChapterName == "Risk_Management")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Category", DataField = "ID_Category" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Target Date", DataField = "ID_Target_Date" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
DR = table.Select("PendingSince>0");
}
else if (ChapterName == "BirthdayLunch" || ChapterName == "Sampark" || ChapterName == "Suggestion_at_Facebook" || ChapterName == "SimplifiedSuggestion")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
DR = table.Select("PendingSince>0");
}
DataTable dtFinal = table.Clone();
foreach (DataRow d in DR)
{
dtFinal.ImportRow(d);
}
gd.DataSource = dtFinal;//table;
gd.AutoGenerateColumns = false;
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "Comments", DataField = "ID_Comments" });
////gd.Columns.Add(new BoundField() { HeaderText = "Status", DataField = "ID_status" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_Dept" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
//gd.Columns.Add(new BoundField() { HeaderText = "LoggedDate", DataField = "ID_Logged_Date" });
gd.DataBind();
var sb = new System.Text.StringBuilder();
var tw = new System.IO.StringWriter(sb);
var htw = new System.Web.UI.HtmlTextWriter(tw);
gd.RenderControl(htw);
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=IssueDetails.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Full Dump Report"));
con1.Close();
}
}
public void Init()
{
query = new ListQuery("");
}
public Task GetCategory(ListQuery listQuery)
{
throw new NotImplementedException();
}
public PublicCompositeTypeGenerationResultImpl(
CompositeModel cModel,
CompositeTypeModel tModel,
EventHandler <AssemblyLoadingArgs> loadingEvt,
IDictionary <Assembly, Assembly> assDic,
CompositeCodeGenerationInfo codeGenerationInfo
)
{
//var orderer = new TypeLoadOrderer( cModel );
var collectionsFactory = cModel.ApplicationModel.CollectionsFactory;
var publicTypes = cModel
.GetAllCompositeTypes()
.Concat(cModel.GetAllFragmentTypes())
//.OrderBy( t => t, orderer )
.Where(t => cModel.ApplicationModel.AffectedAssemblies.Contains(t.GetAssembly()))
.OrderBy(t => t.Equals(cModel.MainCodeGenerationType) ? 0 : 1) // Populate main code generation type first
.Select(t => GetGeneratedPublicType(t, cModel, codeGenerationInfo, loadingEvt, assDic))
.Distinct()
.ToArray();
var mainTypes = publicTypes.Where(iResult => iResult.IsPublicTypeMainCompositeType());
if (!mainTypes.Any() || mainTypes.Skip(1).Any())
{
throw new ArgumentException((mainTypes.Any() ? "Too many" : "Too little") + " generated main types (" + String.Join(", ", mainTypes) + "), exactly one allowed.");
}
var mainType = mainTypes.First();
this._compositeFactory = (CompositeFactory)mainType.GetAssembly().GetType(mainType.Name + codeGenerationInfo.CompositeFactorySuffix, true)
#if WINDOWS_PHONE_APP
.GetAllInstanceConstructors().First()
#else
.GetConstructors()[0]
#endif
.Invoke(null);
var fragmentTypeGenerationResults = tModel.FragmentTypeInfos.Keys
//.OrderBy( t => t, orderer )
.Select(t => Tuple.Create(t, GetParticipantType(t, cModel, codeGenerationInfo, loadingEvt, assDic, codeGenerationInfo.FragmentPrefix, true)))
.Where(t => t.Item2 != null)
.Select(t => (FragmentTypeGenerationResult) new FragmentTypeGenerationResultImpl(t.Item1, t.Item2))
.ToArray();
var concernInvocationGenerationResults = tModel.ConcernInvocationTypeInfos.Keys
//.OrderBy( t => t, orderer )
.Select(t => Tuple.Create(t, GetParticipantType(t, cModel, codeGenerationInfo, loadingEvt, assDic, codeGenerationInfo.ConcernInvocationPrefix)))
.Where(t => t.Item2 != null)
.Select(t => (TypeGenerationResult) new TypeGenerationResultImpl(t.Item2, t.Item1))
.ToArray();
var sideEffectInvocationGenerationResults = tModel.SideEffectInvocationTypeInfos.Keys
//.OrderBy( t => t, orderer )
.Select(t => Tuple.Create(t, GetParticipantType(t, cModel, codeGenerationInfo, loadingEvt, assDic, codeGenerationInfo.SideEffectInvocationPrefix)))
.Where(t => t.Item2 != null)
.Select(t => (TypeGenerationResult) new TypeGenerationResultImpl(t.Item2, t.Item1))
.ToArray();
var privateCompositeGenerationresults = tModel.PrivateCompositeTypeInfos.Keys
//.OrderBy( t => t, orderer )
.Select(t => Tuple.Create(t, GetParticipantType(t, cModel, codeGenerationInfo, loadingEvt, assDic, codeGenerationInfo.PrivateCompositePrefix)))
.Where(t => t.Item2 != null)
.Select(t => (TypeGenerationResult) new TypeGenerationResultImpl(t.Item2, t.Item1))
.ToArray();
var pGArgs = collectionsFactory.NewDictionaryProxy(
tModel.PublicCompositeGenericArguments
.Select((gArg, idx) => Tuple.Create(gArg, idx))
.GroupBy(tuple => tuple.Item1.DeclaringType)
.ToDictionary(grouping => grouping.Key, grouping => collectionsFactory.NewListProxy(grouping.Select(tuple => tuple.Item2).ToList()).CQ));
this._generatedPublicMainType = mainType;
this._maxParamCountForCtors = mainType
#if WINDOWS_PHONE_APP
.GetAllInstanceConstructors().First()
#else
.GetConstructors(BindingFlags.Instance | BindingFlags.Public)[0]
#endif
.GetParameters().Length;
this._generatedPublicTypes = collectionsFactory.NewListProxy(publicTypes.Select(
pt => (GeneratedTypeInfo) new GeneratedTypeInfoImpl(pt))
.ToList()).CQ;
this._publicCompositeGenericArguments = pGArgs.CQ;
this._privateCompositeGenerationResults = collectionsFactory.NewListProxyFromParams(privateCompositeGenerationresults).CQ;
this._fragmentGenerationResults = collectionsFactory.NewListProxyFromParams(fragmentTypeGenerationResults).CQ;
this._concernInvocationGenerationResults = collectionsFactory.NewListProxyFromParams(concernInvocationGenerationResults).CQ;
this._sideEffectInvocationGenerationResults = collectionsFactory.NewListProxyFromParams(sideEffectInvocationGenerationResults).CQ;
// Remember to remove Qi4CS assembly if present
assDic.Remove(ReflectionHelper.QI4CS_ASSEMBLY);
}
public ListQueryResult<Core.Domian.Settings.IssueManagementCommentLog> GetByQuery(ListQuery<Core.Domian.Settings.IssueManagementCommentLog> query)
{
var result = new ListQueryResult<Teckraft.Core.Domian.Settings.IssueManagementCommentLog>();
var list = new List<Teckraft.Core.Domian.Settings.IssueManagementCommentLog>();
using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
var linqquery = dbcontext.IssueManagementCommentLogs.Where(it => it.Id > 0);
if (query.Parameters.Count > 0)
{
foreach (var item in query.Parameters)
{
if (item.Name == "RequestNo")
{
var val = item.Value;
linqquery = linqquery.Where(k => k.ID_Request == val);
}
else if (item.Name == "ChapterName")
{
var val = item.Value;
linqquery = linqquery.Where(j => j.id_System_Name == val);
}
else if (item.Name == "PendingWithEmail")
{
var val = (item.Value);
linqquery = linqquery.Where(it => (it.ID_Pending_With_Email == val));
}
}
linqquery = linqquery.OrderByDescending(it => it.RCT);
foreach (var dbitem in linqquery)
{
list.Add(mappingProvider.Map(dbitem));
}
}
}
result.Items = list;
return result;
}
public List <CashOrderNumberCounter> List(ListQuery listQuery, object query = null)
{
throw new System.NotImplementedException();
}
public int Count(ListQuery listQuery, object query = null)
{
throw new System.NotImplementedException();
}
// this method updates a row in the google spreadsheet // MySpreadsheetIntegration-v1
public static void AddRowToGoogleSpreadsheet()
{
try
{
clsUtransEditorStaticClass.AuthorizeRequestGoogleSheetsAPI();
SpreadsheetEntry spreadsheet = null;
//string docKey = "1A5be20hhg2fe2AGWe6BpeJmtdI-_ITcTSF1WiIVbyTY";
//string gDocsURL = "https://docs.google.com/spreadsheet/ccc?key={0}";
//string docURL = String.Format(gDocsURL, docKey);
//FeedQuery singleQuery = new FeedQuery();
//singleQuery.Uri = new Uri(docKey);
//AtomFeed newFeed = service.Query(singleQuery);
//AtomEntry retrievedEntry = newFeed.Entries[0];
//MessageBox.Show(retrievedEntry.Title.Text);
////SpreadsheetsService service = new SpreadsheetsService("MySpreadsheetIntegration-v1");
// TODO: Authorize the service object for a specific user (see other sections)
// Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
SpreadsheetQuery query = new SpreadsheetQuery();
// Make a request to the API and get all spreadsheets.
SpreadsheetFeed feed = service.Query(query);
if (feed.Entries.Count == 0)
{
// TODO: There were no spreadsheets, act accordingly.
MessageBox.Show("google didn't find any spreadsheets.");
}
// TODO: Choose a spreadsheet more intelligently based on your
// app's needs.
////SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];
////MessageBox.Show(spreadsheet.Title.Text);
//Console.WriteLine(spreadsheet.Title.Text);
//loop through the feeds to find the spreadsheet with the correct name
for (int i = 0; i < feed.Entries.Count; i++)
{
spreadsheet = (SpreadsheetEntry)feed.Entries[i];
if (spreadsheet.Title.Text == "UtransEditorCountyNotificationList")
{
//MessageBox.Show("found it!!!");
break;
}
else
{
//MessageBox.Show("Didn't find a spreadsheet with the name UtransEditorCountyNotificationList. The info was not saved to a google spreadsheet.");
}
}
// Get the first worksheet of the first spreadsheet.
// TODO: Choose a worksheet more intelligently based on your
// app's needs.
WorksheetFeed wsFeed = spreadsheet.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = service.Query(listQuery);
// Create a local representation of the new row.
ListEntry row = new ListEntry();
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "logdate", Value = DateTime.Now.ToString("d")
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "countyid", Value = clsGlobals.strCountyID
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "agrcnotes", Value = clsGlobals.strUserInputForSpreadsheet.ToString().Trim()
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "agrcsegment", Value = clsGlobals.strAgrcSegment.ToString().Trim()
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "cntysegment", Value = clsGlobals.strCountySegmentTrimed
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "leftfrom", Value = clsGlobals.strCountyFROMADDR_L
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "leftto", Value = clsGlobals.strCountyTOADDR_L
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "rightfrom", Value = clsGlobals.strCountyFROMADDR_R
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "rightto", Value = clsGlobals.strCountyTOADDR_R
});
row.Elements.Add(new ListEntry.Custom()
{
LocalName = "city", Value = clsGlobals.strGoogleSpreadsheetCityField
});
// Send the new row to the API for insertion.
service.Insert(listFeed, row);
}
catch (Exception ex)
{
clsGlobals.logger.Error(Environment.NewLine + "Error Message: " + ex.Message + Environment.NewLine + "Error Source: " + ex.Source + Environment.NewLine + "Error Location:" + ex.StackTrace + Environment.NewLine + "Target Site: " + ex.TargetSite);
MessageBox.Show("Error Message: " + Environment.NewLine + ex.Message + Environment.NewLine + Environment.NewLine +
"Error Source: " + Environment.NewLine + ex.Source + Environment.NewLine + Environment.NewLine +
"Error Location:" + Environment.NewLine + ex.StackTrace,
"UTRANS Editor tool error!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public async Task <List <DimensionViewModel> > Handle(ListQuery request, CancellationToken cancellationToken)
{
var dimensionSet = await _context.Dimensions.PagedToListAsync(request.Page, request.PageSize);
return(DimensionViewModel.CreateFromDimensions(dimensionSet).ToList());
}
static void Main(string[] args)
{
//Get credentials
Console.Write("Enter your username:"******"Enter your password:"******"my-service");
service.setUserCredentials(user, password);
ListFeed listFeed = null;
SpreadsheetFeed feed = null;
IProgress <string> p = new Progress <string>(Console.WriteLine);
//Get list of spreadsheets
var getSheets = Task.Run(() =>
{
p.Report("Getting all your Google spreadsheets...");
var query = new SpreadsheetQuery();
feed = service.Query(query);
});
getSheets.Wait();
//Show list of spreadsheets...
foreach (SpreadsheetEntry entry in feed.Entries.OrderBy(x => x.Title.Text))
{
Console.WriteLine(entry.Title.Text);
}
Console.WriteLine("Which spreadsheet would you like to see the contents of?");
var title = Console.ReadLine();
//Get list of spreadsheets
var getInfo = Task.Run(() =>
{
p.Report("Reading rows from spreadsheet");
var query = new SpreadsheetQuery();
query.Title = title;
feed = service.Query(query);
var spreadsheet = feed.Entries.FirstOrDefault() as SpreadsheetEntry;
var wsFeed = spreadsheet.Worksheets;
var worksheet = wsFeed.Entries.FirstOrDefault() as WorksheetEntry;
//Define the URL to request the list feed of the worksheet
var listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
p.Report(string.Format("Spreadsheet table link: {0}", listFeedLink.HRef));
//Rows in spreadsheet
var listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = service.Query(listQuery);
});
getInfo.Wait();
//Iterate through the rows...
foreach (ListEntry row in listFeed.Entries)
{
foreach (ListEntry.Custom element in row.Elements)
{
Console.WriteLine(element.Value);
}
}
//NOTE: google docs always treats the first row as the header row...
Console.WriteLine("Type a new value for the first cell in the first column:");
var newValue = Console.ReadLine();
Console.WriteLine("Updating row data...");
var updateRow = (ListEntry)listFeed.Entries[0];
ListEntry.Custom updateMe = updateRow.Elements[0];
updateMe.Value = newValue;
updateRow.Update();
Console.Read();
}
public async Task <ActionResult <ListResponse <UserResponse> > > GetUsersListAsync([FromQuery] UserFilter filter, [FromQuery] ListOptions options, [FromServices] ListQuery <UserResponse, UserFilter> query) => await query.RunAsync(filter, options);
public static async Task <PageListDto <T> > ToPagedListAsync <T>(this IQueryable <T> queryable, ListQuery query)
{
var count = await queryable.CountAsync();
var results = await queryable
.Skip(query.PageSize *query.Page)
.Take(query.PageSize)
.ToListAsync();
return(new PageListDto <T>
{
Page = query.Page,
PageSize = query.PageSize,
Count = results.Count,
Total = count,
Items = results
});
}
public async Task GetKnowledgeArticleList(ListQuery listQuery)
{
await ContentAccessor.ListAsync <ContentEntry>(x => x.Category.ParentCategory.Name == listQuery.QueryKey);
}
public async Task <ActionResult <ListResponse <TypeFoodResponse> > > GetTypeFoodsListAsync([FromQuery] TypeFoodFilter typeFood, [FromQuery] ListOptions options, [FromServices] ListQuery <TypeFoodResponse, TypeFoodFilter> query) => await query.RunAsync(typeFood, options);
public async Task <List <Categories> > GetKnowledgeCategoryList(ListQuery listQuery)
{
var category = await CategoryAccessor.ListAsync <Categories>(x => x.ParentCategory.Name == KnowledgeBusiness.PublishKey && x.Name == listQuery.QueryKey, listQuery.PageIndex);
return(category.ToList());
}
public async Task <List <ListItem> > ExecuteQuery(ListQuery query, int?pageSize)
{
return(await Task.Factory.StartNew(() =>
{
System.Threading.Thread.Sleep(2000);
return new List <ListItem>
{
new ListItem(query.List)
{
Id = 1,
Columns = new Dictionary <string, string>
{
{ Internals.Text, "Test1" },
{ Internals.User, "Owner1" },
{ Internals.Date, "Date1" },
{ Internals.DateTime, "DateTime1" },
{ Internals.Lookup, "Lookup1" },
{ Internals.MultiLookup, "MultiLookup1" },
{ Internals.Integer, "Integer1" },
{ Internals.Note, "Note1" + Environment.NewLine + "Seccond Line" },
{ Internals.Url, "Url1" },
{ Internals.Choice, "Choice1" },
{ Internals.Boolean, "Boolean1" },
{ Internals.Readonly, "Readonly1" },
{ Internals.Hidden, "Hidden1" },
{ Internals.Number, "Number1" },
{ Internals.Currency, "Currency1" },
{ Internals.Computed, "Computed1" },
{ Internals.MultiChoice, "MultiChoice1" },
{ Internals.Guid, "Guid1" },
{ Internals.Calculated, "Calculated1" },
{ Internals.File, "File1" },
{ Internals.Attachments, "Attachments1" },
{ Internals.ContentTypeId, "ContentTypeId1" },
{ Internals.Geolocation, "Geolocation1" },
{ Internals.SortTest, "SortTest1" },
}
},
new ListItem(query.List)
{
Id = 2,
Columns = new Dictionary <string, string>
{
{ Internals.Text, "Test2" },
{ Internals.User, "Owner2" },
{ Internals.Date, "" },
{ Internals.Url, null },
}
},
new ListItem(query.List)
{
Id = 3,
Columns = new Dictionary <string, string>
{
{ Internals.Text, "Test3" },
{ Internals.User, "Owner3" }
}
},
};
}));
}
static void Main()
{
// spreadsheet service and auth
SpreadsheetsService _service = new SpreadsheetsService(sheetService);
_service.setUserCredentials(userName, password);
// new spreadsheet query
SpreadsheetQuery query = new SpreadsheetQuery();
query.Title = sheetTitle; // will find the spreadsheet using title
// make the request
SpreadsheetFeed feed = _service.Query(query);
// get spreadsheet
SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];
// request the spreadsheets worksheet feeds
WorksheetFeed wsFeeds = spreadsheet.Worksheets;
// target worksheet
WorksheetEntry worksheet = (WorksheetEntry)wsFeeds.Entries[worksheetNumber];
// need request url for the list feed
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// fetch a list
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed parcelList = _service.Query(listQuery);
// fetch list of members
WorksheetEntry memberWorksheet = (WorksheetEntry)wsFeeds.Entries[0];
AtomLink memberListFeedLink = memberWorksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery memberListQuery = new ListQuery(memberListFeedLink.HRef.ToString());
ListFeed memberList = _service.Query(memberListQuery);
// loop through each entry and update the legal cell for each row
int i = 0;
foreach (ListEntry entry in parcelList.Entries)
{
i++;
PropertyInfo property = new PropertyInformation().GetPropertyInfo("", entry.Elements[parcelColumnNumber].Value.ToString());
Parcel parcel = new Parcel(property, memberList);
Console.WriteLine("{0} => {1}, {2}", i, parcel.Number, parcel.IsMember);
// look at each element in entry
foreach (ListEntry.Custom element in entry.Elements)
{
if (element.LocalName == "legal")
{
element.Value = parcel.Legal;
}
if (element.LocalName == "subdivision")
{
element.Value = parcel.Subdivision;
}
if (element.LocalName == "filing")
{
element.Value = parcel.Filing;
}
if (element.LocalName == "ismember")
{
element.Value = parcel.IsMember == true ? "1" : "0";
}
if (element.LocalName == "grantsigned")
{
element.Value = parcel.GrantSigned;
}
if (element.LocalName == "grantfiled")
{
element.Value = parcel.GrantFiled;
}
if (element.LocalName == "memberid")
{
element.Value = parcel.MemberId;
}
if (element.LocalName == "annexmarkercolor")
{
var color = "";
if (parcel.IsMember)
{
color = "small_blue";
}
else
{
color = parcel.IsAnnexed ? "small_red" : "small_yellow";
}
element.Value = color;
}
// mailing address
if (element.LocalName == "mailaddress1")
{
element.Value = parcel.MailAddress1;
}
if (element.LocalName == "mailaddress2")
{
element.Value = parcel.MailAddress2;
}
if (element.LocalName == "mailaddresscity")
{
element.Value = parcel.MailAddressCity;
}
if (element.LocalName == "mailaddressstate")
{
element.Value = parcel.MailAddressState;
}
if (element.LocalName == "mailaddresszip")
{
element.Value = parcel.MailAddressZip;
}
// 1st owner
if (element.LocalName == "owner1")
{
element.Value = parcel.Owner1;
}
// 2nd owner
if (element.LocalName == "owner2")
{
element.Value = parcel.Owner2;
}
}
entry.Update();
}
Console.WriteLine("Done, press any key");
Console.ReadKey();
}
public List <Organization> List(ListQuery listQuery, object query = null)
{
return(UnitOfWork.Session.Query <Organization>(@"SELECT * FROM Organizations").ToList());
}
public async Task <ActionResult> BogListe(ListQuery query)
{
try
{
using (var dbmunin = new ILABNew2Entities())
{
int flicks = query.P * query.Size;
var l = await dbmunin.Bibliotek.ToListAsync();
if (!string.IsNullOrEmpty(query.Q))
{
string[] sQuery = query.Q.Split(' ');
for (int i = 0; i < sQuery.Length; i++)
{
l =
l.Where(
x => (x.Bogkode != null && x.Bogkode.ToLower().Contains(sQuery[i].ToLower())) ||
(x.Note != null && x.Note.ToLower().Contains(sQuery[i].ToLower())) ||
(x.Titel != null && x.Titel.ToLower().Contains(sQuery[i].ToLower())) ||
(x.Forfatter != null && x.Forfatter.ToLower().Contains(sQuery[i].ToLower())) ||
(x.Undertitel != null && x.Undertitel.ToLower().Contains(sQuery[i].ToLower())))
.ToList();
}
}
var column = typeof(Bibliotek).GetProperty(query.S,
BindingFlags.SetProperty | BindingFlags.IgnoreCase |
BindingFlags.Public | BindingFlags.Instance);
if (column != null)
{
if (query.O.ToUpper() == "DESC")
{
l = l.OrderByDescending(x => column.GetValue(x, null)).ToList();
}
else
{
l = l.OrderBy(x => column.GetValue(x, null)).ToList();
}
}
var pageResult = l.Select(x => new BiblioteksDto()
{
ID = x.BibliotekID,
BogKode = x.Bogkode,
Titel = x.Titel,
Forfatter = x.Forfatter,
Udgivet = (x.Udgivet != null)? x.Udgivet.Value:0,
}).Skip(1).Take(query.Size);
if (l.Count > flicks)
{
pageResult = l.Select(x => new BiblioteksDto()
{
ID = x.BibliotekID,
BogKode = x.Bogkode,
Titel = x.Titel,
Forfatter = x.Forfatter,
Udgivet = (x.Udgivet != null) ? x.Udgivet.Value : 0,
}).Skip(flicks).Take(query.Size);
}
var listResult = new MuninListViewModel <BiblioteksDto>()
{
Count = l.Count,
Pages = l.Count / query.Size,
Data = pageResult.ToList()
};
var result = JsonConvert.SerializeObject(listResult, Utils.JsonSettings());
return(Content(result));
}
}
catch (Exception ex)
{
return(Content("Fejl:" + ex.Message));
}
}
public async Task <List <BookViewModel> > Handle(ListQuery request, CancellationToken cancellationToken)
{
var bookSet = await _context.Books.PagedToListAsync(request.Page, request.PageSize);
return(BookViewModel.CreateFromBooks(bookSet, true, true, true, true).ToList());
}
public static void Main(string[] args)
{
Console.WriteLine("Working...");
long bukow = 50217665; // bukowskaii's player id
Region bRegion = new Region(Region.Regions.NA);
Console.WriteLine("Getting List of all champions...");
List <ChampionDto> allChampions = ChampionAPI.RetrieveAllChampions(bRegion.ChampionRegion);
Console.WriteLine("Getting masteries for Bukowskaii...");
List <ChampionMasteryDto> myMasteries = ChampionMasteryAPI.GetAllChampionMastery(bRegion.ChampionMasteryRegion, bukow);
Console.WriteLine("Getting Dictionary of champion Ids and champion metadata...");
Dictionary <long, ChampionMetaData> championLookup = StaticDataAPI.GetChampionMetaData(bRegion.ChampionRegion);
Console.WriteLine("Writing info to file...");
List <long> loggedIds = new List <long>();
StringBuilder sb = new StringBuilder();
foreach (ChampionMasteryDto mastery in myMasteries)
{
string champName = championLookup[mastery.ChampionId].Name;
string champTitle = championLookup[mastery.ChampionId].Title;
sb.AppendLine(champName + " -- " + champTitle + "," +
mastery.ChampionId + "," +
mastery.ChestGranted + "," +
mastery.TokensEarned + "," +
UnixTimeStampToDateTime(mastery.LastPlayTime) + "," +
mastery.ChampionLevel + "," +
mastery.ChampionPoints);
loggedIds.Add(mastery.ChampionId);
}
foreach (ChampionDto champion in allChampions)
{
if (!loggedIds.Contains(champion.Id))
{
string champName = championLookup[champion.Id].Name;
string champTitle = championLookup[champion.Id].Title;
sb.AppendLine(champName + " - " + champTitle + "," +
champion.Id + "," +
"False," +
"0," +
"0," +
"0," +
"0");
}
}
//File.WriteAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "LeagueData.csv"), sb.ToString());
//Console.WriteLine("Done! -- Press any key to exit.");
//Thread.Sleep(100);
//Console.ReadKey(false);
//Thread.Sleep(100);
const string ClientId = "376250057781-pud8thtu2qrku59p4jkusf5o97d0nc1e.apps.googleusercontent.com";
string ClientSecret = "WAIKheO-M3YQ6RVlDrK0DC8i";
string scope = "https://spreadsheets.google.com/feeds";
string redirect = "urn:ietf:wg:oauth:2.0:oob";
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.ClientId = ClientId;
parameters.ClientSecret = ClientSecret;
parameters.RedirectUri = redirect;
parameters.Scope = scope;
string authorizationUrl = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
Process.Start(authorizationUrl);
Console.WriteLine("Paste your authorization code:");
parameters.AccessCode = Console.ReadLine();
//parameters.AccessCode = "4/6op1327wcvTW8eMwFm4D4ZETIS2JCDSas8oifd1OD9M";
OAuthUtil.GetAccessToken(parameters);
string accessToken = parameters.AccessToken;
Console.WriteLine("OAuthAccessToken: " + accessToken);
GOAuth2RequestFactory requestFactory =
new GOAuth2RequestFactory(null, "LoL Crate Parse", parameters);
SpreadsheetsService service = new SpreadsheetsService("LoL Crate Parse");
service.RequestFactory = requestFactory;
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed feed = service.Query(query);
if (feed.Entries.Count > 0)
{
SpreadsheetEntry selectedEntry = new SpreadsheetEntry();
foreach (SpreadsheetEntry entry in feed.Entries)
{
if (entry.Title.Text == "LoL Crates")
{
selectedEntry = entry;
}
}
WorksheetFeed wFeed = selectedEntry.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wFeed.Entries[0];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = service.Query(listQuery);
int entries = listFeed.Entries.Count;
int remaining = 0;
ListEntry existingRow;
do
{
existingRow = (ListEntry)listFeed.Entries[0];
existingRow.Delete();
listFeed = service.Query(listQuery);
remaining++;
Console.WriteLine(string.Format("Deleting {0} of {1} complete", remaining, entries));
} while (listFeed.Entries.Count > 0);
string[] rows = sb.ToString().Trim('\n').Split('\n');
entries = rows.Length;
remaining = 0;
foreach (string row in rows)
{
Console.WriteLine(string.Format("Inserting {0} of {1} complete", remaining, entries));
string[] elements = row.Split(',');
ListEntry toAdd = new ListEntry();
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "champion", Value = elements[0]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "id", Value = elements[1]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "chest", Value = elements[2]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "tokensearned", Value = elements[3]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "lastplayed", Value = elements[4]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "champlevel", Value = elements[5]
});
toAdd.Elements.Add(new ListEntry.Custom()
{
LocalName = "masterypoints", Value = elements[6]
});
service.Insert(listFeed, toAdd);
remaining++;
}
}
Console.WriteLine("Done! -- Press any key to exit.");
Thread.Sleep(100);
Console.ReadKey(false);
}
public ListQueryResult <User> GetByQuery(ListQuery <User> query)
{
var result = new ListQueryResult <User>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var linqQuery = dbcontext.UserDetails.Where(it => it.UserId > 0);
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "username")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.UserName == p.Value);
}
}
else if (p.Name == "title")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.Title == p.Value);
}
}
else if (p.Name.ToLower() == "dhdivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentHeads.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name.ToLower() == "dodivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentOwners.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name == "ResponsibleUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
else if (p.Name == "DependentUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
}
}
foreach (var item in linqQuery)
{
if (result.Items == null)
{
result.Items = new List <User>();
}
var usr = _mapper.Map(item);
result.Items.Add(usr);
}
}
return(result);
}
public ListQueryResult <IssueManagementAnchorComment> GetByQuery(ListQuery <IssueManagementAnchorComment> query)
{
return(this.issueRepository.GetByQuery(query));
}
