Phase 2 agent ops
$250-750 AUD
Paid on delivery
Rename the application to AgentOps
Please be mindful that this web app should be usable via a smartphone.
For lists within the app we would prefer to have a single self referencing table:-
CREATE TABLE [dbo].[tblType](
[TypeID] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_tblType_TypeID] DEFAULT (newid()),
[RelatedTypeId] [uniqueidentifier] NULL,
[Description] [varchar](50) NULL,
[SortKey] [int] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_tblType_Active] DEFAULT ((1)),
CONSTRAINT [PK_tblType] PRIMARY KEY CLUSTERED
(
[TypeID] ASC
)
)
The groups field in the user account needs to be database driven (using the above table). Can you under the account management screen add a section to maintain the groups list ( a popup window would be nice). This code should be generic so we can use it to maintain any future lists. Groups should not be able to be deleted if a user account refers to it. Please name to master record for the ‘Groups’ as LIST_USER_GROUP and please ensure there is one list record named ‘Agent Ops’. When displaying the lists please ensure the sortkey and active flags are used. If when displaying the list a record refers to an inactive record, please have this record appear in the list but make it display as greyed out to indicate it is inactive.
Once logged on
Please make the property address field an auto complete field (telerik). If no match is found then the Add New property button should appear, clicking this will use the address typed into the autocomplete field to populate the address field (one of the fields for a property record). If a match is found then the record should be able to be selected and then edited. If it is edited a history of the old record should be kept in
All fields other than the primary key that end with ‘Id’ are lookup fields to values in the tblType table. The Types should be identified as LIST_PROPERTY_ and then the fieldname without the Id txt. Except the CreatedBy and ModifiedBy which should be self evident. AccountId should equal the logged on users GroupId. The displayId should be an incremental Integer, you can do this with the database or code.
Addresses should be validated using [url removed, login to view] – sign up for a free trial to test. If necessary add another field to the table above where the full address can be stored.
Once a property record has been saved enable the upload pictures section. Photos of the property should be uploaded here using Asynchronous Upload (Telerik) and then managed like this [url removed, login to view] with the positioning of the images persisting via the database. A table should be created to hold the images and relate them to a property (if you wish I can provide a script for this table – it should be reasonably straight forward tho)
A property can be deleted if it has not been published (next phase of project).
Project ID: #11048145
About the project
Awarded to:
