ASP.net/SQL Server page with date/event grids
$100-500 USD
Paid on delivery
I have a database that includes, among other things, the following columns: Unique identifier time arrived (datetime time in (datetime) time out (datetime) This data spans a few years, but I'm only focused on the last week or so (so queries have to consider that there are multiple years with the same month/day/time, and I only want the current year/week). I need to create an ASP.net page that will among other things include something like the attached .xls file. Each day is defined as midnight (0000) to 2359:59. As is evident, this will involve grids of numbers (in one section, 24 rows and 8 columns). Each section would best be handed separately for formatting purposes. I use the term "grid", but it does not necessarily have to be a grid per se. I do need to be able to apply labels to the column and row headers similar to what appears in the .xls file. Moreover, "yesterday", "yesterday-1", etc. must be replaced by the actual dates. I am flexible regarding the exact means by which to do this (e.g. how to create and lay out the numbers, whether by variants on data grids, populating an HTML grid, no grids at all, etc.). However, it must be easily formatted for appearance/presentation purposes (which should not be difficult), and the overall approach to writing the queries that populate each section should be somewhat formulaic/programmatic. In other words, I would like as few queries as possible, e.g. one query for each column or even each grid if possible, as opposed to a separate queries for each single number (e.g. 24 x 8 = 192 separate queries - no way). A dummy connection string can be supplied, as I will likely modify the file a bit to match my particular needs. I will be happy to answer specific questions regarding the project. A small bonus would be given for a selectable date range. In other words, instead of 8 fixed columns, the start and end date for the range could be user-selected.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2000/XP SQL Server 2000/2005 Internet Explorer >= 6.0 and Firefox
Project ID: #3792185
About the project
Awarded to:
11 freelancers are bidding on average $161 for this job
