Create a Mobile Website

I will supply the username for the outlook emaill and azure login. - Watch Video. The video is from the Cardlogix demo system I recorded from a droid pc emulator today, the first part I scooted a screen shot in that would be what I would like to see. [login to view URL] Cardlogix made the app in the video and they will send the data to use via a web service where we write it into our database using C# app or MIRTH. I need to have a Splash screen with Login (ASP.NET Membership), second screen like there first screen but with Search and Add Patient. I need the new app to read the data back and display or edit. I need to have a search option using NationalID or LastName or DOB. I need to be able to add patients. For patients found during a search I would like to be able to update the data or photos using cam on phone / laptop.. They MIGHT NOT make the final app and I will be stuck adding the New Patient and Update features so I would like to be ready. I would like it in AZURE if possible in C# or VB .NET with a new outlook account that could be usedas a mobile website. We can use 1 table for now assuming only 1 kid for now and I have all the fields they sent us in 1 table. The create SQL table with the fields I understand to be used below, they should match the fields in the video. I have not checked all these fields against the demo app to see that they followed the field list. Mike Caldwell This app is for LIFEMEDID and the logos are on [login to view URL] SourceCode access is expected at completion. DROP TABLE [dbo].[PersonAF] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PersonAF]( [PersonID] [int] NOT NULL, [MedicalRecordNumber] [varchar](64) NULL, [EnterpriseID] [uniqueidentifier] NOT NULL, [CreatedDate] [varchar](64) NULL, [DeactivatedDate] [varchar](64) NULL, [ModifiedDate] [varchar](64) NULL, [OwnedByDataProvider] [varchar](64) NULL, [pd_First] [varchar](64) NULL, [pd_Last] [varchar](64) NULL, [pd_middle] [varchar](64) NULL, [pd_Address] [varchar](64) NULL, [pd_Address2] [varchar](64) NULL, [pd_city] [varchar](64) NULL, [pd_state] [varchar](64) NULL, [pd_Zip] [varchar](64) NULL, [pd_DateofBirth] [varchar](64) NULL, [pd_Sex] [varchar](64) NULL, [pd_IDType] [varchar](64) NULL, [pd_NationalityNationalNumber] [varchar](64) NULL, [ma_Address1] [varchar](64) NULL, [ma_Address2] [varchar](64) NULL, [ma_POBox] [varchar](64) NULL, [ma_ZipCode] [varchar](64) NULL, [ma_Remarks] [varchar](1024) NULL, [wl_StreetName] [varchar](64) NULL, [wl_StreetNumber] [varchar](64) NULL, [wl_BuildingName] [varchar](64) NULL, [wl_BuildingNumber] [varchar](64) NULL, [wl_Area] [varchar](64) NULL, [wl_City] [varchar](64) NULL, [wl_LocationDescription] [varchar](64) NULL, [ci_WorkPhone1] [varchar](64) NULL, [ci_WorkPhone2] [varchar](64) NULL, [ci_WorkFax] [varchar](64) NULL, [ci_HomePhone1] [varchar](64) NULL, [ci_HomePhone2] [varchar](64) NULL, [ci_HomeFax] [varchar](64) NULL, [ci_MobileNumber] [varchar](64) NULL, [ci_PagerNumber] [varchar](64) NULL, [ci_EmmaiilAddress] [varchar](64) NULL, [ci_WebAddress] [varchar](64) NULL, [fl_CommercialName] [varchar](64) NULL, [fl_TradeName] [varchar](64) NULL, [fl_BankName] [varchar](64) NULL, [fl_Branch] [varchar](64) NULL, [PictureMaster] [image] NULL, [PictureSpouse] [image] NULL, [PictureChild] [image] NULL, [PatientMRNQRCode] [image] NULL, CONSTRAINT [PK_PersonAF] PRIMARY KEY CLUSTERED ( [PersonID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO