Readings Controller:
Create Action:
Task 1: Add a DatePicker control to select a date when adding a new reading.
JobsController
action (index)
Task 2: using a join, join v2_Customers and v2_Jobs on v2_Customer.Company_UUID = user_1.Company_UUID. This should load all jobs for the current user.
Task 3: i need a drop-down control at the top of the page that when selected will reload the page based on the selection.
Options: Job completed, Job Pending, Job, Open Lead, Closed Lead, Estimated, Completed
Task 4: i need a DatePicker or date control to load jobs based on the date selected.
Customers Page
Task 5: Add a data pager. Show 5 records at a time.
CustomersController
Task 6: The Function below is not working, i am getting a Null error...
Function Schedule() As ActionResult
Dim entities As New floodpro2Entities()
Dim user__1 As v2_Users = [login to view URL](Function(u) u.User_Name = [login to view URL] AndAlso u.user_id_mob = 1).SingleOrDefault()
Dim db As New floodpro2Entities
Dim schedViewQuery1 = From j In db.v2_Customer_Events
Join c In db.v2_Customer On c.Cust_UUID Equals j.cust_UUID
Where (c.Company_UUID = user__1.Company_UUID) And j.Appt_Date IsNot Nothing
Group By j.cust_UUID, c.Last_Name, [login to view URL], j.Task_Description, [login to view URL], [login to view URL], j.Appt_Date, j.Appt_Start_Time, j.Appt_End_Time Into AsEnumerable()
Select New schedView With {.UUID = cust_UUID,
.Lname = Last_Name,
.TaskDesc = Task_Description,
.Task = Task,
.ApptDate = Appt_Date,
.Employee = Employee,
.ApptStart = Appt_Start_Time,
.ApptEnd = Appt_End_Time,
.Remarks = Remarks
}
Return View(schedViewQuery1)
End Function
Hi,
I am a full time freelancer and an expert in Microsoft Technologies. I have more than 7+ years of extensive experience including ASP.Net MVC + C# + SQL Server. I would like to offer you my services.
Please let me know if we can work together.