or
Hello all! I would like to discuss an application scenario so that I, later, will be able to properly identify issue I am facing. The reason I am doing this on a WinApp is that ASP.NET scheduler turned out to be restricted and could not cope with the huge list of Resource and massive number of appointments.
The scenario is as follows:
CREATE
TABLE
[dbo].[Job]
(
[OID] [
bigint
] IDENTITY(1, 1)
NOT
NULL
,
[BatchID] [
varchar
](250)
NOT
NULL
,
[PharmacyID] [
bigint
]
NOT
NULL
,
[BranchID] [
bigint
]
NOT
NULL
,
[PharmacyCoordinatorID] [
bigint
]
NOT
NULL
,
[LocumTypeID] [
int
]
NOT
NULL
,
[JobShiftTypeID] [
int
]
NOT
NULL
,
[JobDate] [smalldatetime]
NOT
NULL
,
[Rate] [money]
NOT
NULL
,
[RatePlus] [money]
NOT
NULL
,
[StartTime] [smalldatetime]
NOT
NULL
,
[EndTime] [smalldatetime]
NOT
NULL
,
[PriorityID] [tinyint]
NOT
NULL
,
[JobCode] [
varchar
](100)
NOT
NULL
,
[JobStatusID] [
int
]
NOT
NULL
,
[UserID] [
bigint
]
NOT
NULL
,
[RegisteredDate] [smalldatetime]
NOT
NULL
,
[LastModifiedAt] [
timestamp
]
NOT
NULL
,
CONSTRAINT
[PK__Jobs__056690C222951AFD]
PRIMARY
KEY
CLUSTERED ([OID]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
CREATE
TABLE
[dbo].[JobBooking](
[OID] [
bigint
] IDENTITY(1,1)
NOT
NULL
,
[LocumID] [
bigint
]
NOT
NULL
,
[JobID] [
bigint
]
NOT
NULL
,
[BookingTime] [smalldatetime]
NOT
NULL
,
[LastModifiedAt] [
timestamp
]
NOT
NULL
,
CONSTRAINT
[PK__Bookings__73951AED4AA30C57]
PRIMARY
KEY
CLUSTERED
(
[OID]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
CREATE
TABLE
[dbo].[JobShiftType]
(
[OID] [
int
] IDENTITY(1, 1)
NOT
NULL
,
[
Name
] [
varchar
](50)
NOT
NULL
,
[LastModifiedAt] [
timestamp
]
NOT
NULL
,
CONSTRAINT
[PK_Shift]
PRIMARY
KEY
CLUSTERED ([OID]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
SET
IDENTITY_INSERT [dbo].[JobShiftType]
ON
INSERT
[dbo].[JobShiftType] ([OID], [
Name
])
VALUES
(1, N
'None'
)
INSERT
[dbo].[JobShiftType] ([OID], [
Name
])
VALUES
(2, N
'Shift 1'
)
INSERT
[dbo].[JobShiftType] ([OID], [
Name
])
VALUES
(3, N
'Shift 2'
)
SET
IDENTITY_INSERT [dbo].[JobShiftType]
OFF
CREATE
TABLE
[dbo].[LocumType]
(
[OID] [
int
] IDENTITY(1, 1)
NOT
NULL
,
[
Name
] [
varchar
](100)
NOT
NULL
,
[Code] [
varchar
](4)
NOT
NULL
,
[PictureID] [
int
]
NOT
NULL
,
[LastModifiedAt] [
timestamp
]
NOT
NULL
,
CONSTRAINT
[PK__LocumTyp__3776C388173876EA]
PRIMARY
KEY
CLUSTERED ([OID]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
SET
IDENTITY_INSERT [dbo].[LocumType]
ON
INSERT
[dbo].[LocumType] ([OID], [
Name
], [Code], [PictureID])
VALUES
(1, N
'Type A'
, N
'P '
, 1)
INSERT
[dbo].[LocumType] ([OID], [
Name
], [Code], [PictureID])
VALUES
(2, N
'Type B'
, N
'D '
, 2)
INSERT
[dbo].[LocumType] ([OID], [
Name
], [Code], [PictureID])
VALUES
(3, N
'Type C'
, N
'ACT '
, 3)
SET
IDENTITY_INSERT [dbo].[LocumType]
OFF
CREATE
TABLE
[dbo].[JobStatus]
(
[OID] [
int
] IDENTITY(1, 1)
NOT
NULL
,
[
Name
] [
varchar
](100)
NOT
NULL
,
[Code] [
varchar
](5)
NOT
NULL
,
[PictureID] [
int
]
NOT
NULL
,
[LastModifiedAt] [
timestamp
]
NOT
NULL
,
CONSTRAINT
[PK_JobStatuses]
PRIMARY
KEY
CLUSTERED ([OID]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
SET
IDENTITY_INSERT [dbo].[JobStatus]
ON
INSERT
[dbo].[JobStatus] ([OID], [
Name
], [Code], [PictureID])
VALUES
(1, N
'Ready to book'
, N
'J_RTB'
, 13)
INSERT
[dbo].[JobStatus] ([OID], [
Name
], [Code], [PictureID])
VALUES
(2, N
'Pending'
, N
'J_P'
, 14)
INSERT
[dbo].[JobStatus] ([OID], [
Name
], [Code], [PictureID])
VALUES
(3, N
'Booked'
, N
'J_B'
, 15)
INSERT
[dbo].[JobStatus] ([OID], [
Name
], [Code], [PictureID])
VALUES
(4, N
'Cancelled'
, N
'J_CAN'
, 16)
INSERT
[dbo].[JobStatus] ([OID], [
Name
], [Code], [PictureID])
VALUES
(6, N
'CallBack'
, N
'J_CAL'
, 17)
SET
IDENTITY_INSERT [dbo].[JobStatus]
OFF
Here are the actions that are required:
private
void
gridNegara_CellClick(
object
sender, GridViewCellEventArgs e)
{
int
i = gridNegara.CurrentRow.Index;
txtKodeNeg.Text = (gridNegara.Rows[i].Cells[0].Value).ToString();
txtNamaNeg.Text = (gridNegara.Rows[i].Cells[1].Value).ToString();
txtIbuKotaNeg.Text = (gridNegara.Rows[i].Cells[2].Value).ToString();
}