ABCDFGHIJKLMNOPQRSTUVWXYZ
1
locationlineusp (=stored procedure)regex
2
OpenImis.ePayment\Data\ImisBasePayment.cs69uspRequestGetControlNumberexec.*usp
3
OpenImis.ePayment\Data\ImisBasePayment.cs221uspInsertPaymentIntentexec.*usp
4
OpenImis.ePayment\Data\ImisBasePayment.cs267uspReceiveControlNumberexec.*usp
5
OpenImis.ePayment\Data\ImisBasePayment.cs292uspReceiveControlNumberexec.*usp
6
OpenImis.ePayment\Data\ImisBasePayment.cs434uspAcknowledgeControlNumberexec.*usp
7
OpenImis.ePayment\Data\ImisBasePayment.cs346uspIssueControlNumberexec.*usp
8
OpenImis.ePayment\Data\ImisBasePayment.cs349uspPaidControlNumberexec.*usp
9
OpenImis.ePayment\Data\ImisBasePayment.cs375uspAcknowledgeControlNumberRequestexec.*usp
10
penImis.ePayment\Data\ImisBasePayment.cs428uspReceivePaymentexec.*usp
11
OpenImis.ModulesV3\ClaimModule\Data\ImisClaims.cs140uspAPIGetClaimsexec.*usp
12
OpenImis.ModulesV3\ClaimModule\Repositories\ClaimRepository.cs77uspRestApiUpdateClaimFromPhoneexec.*usp
13
OpenImis.ModulesV3\ClaimModule\Repositories\ClaimRepository.cs387uspAPIGetClaimsexec.*usp
14
OpenImis.ModulesV3\FeedbackModule\Repositories\FeedbackRepository.cs97uspInsertFeedbackexec.*usp
15
OpenImis.ModulesV3\InsureeModule\Repositories\FamilyRepository.cs216uspConsumeEnrollmentsexec.*usp
16
OpenImis.ModulesV3\InsureeModule\Repositories\InsureeRepository.cs34uspAPIGetCoverageexec.*usp
17
OpenImis.ModulesV3\PolicyModule\Repositories\PolicyRenewalRepository.c47uspGetPolicyRenewalsexec.*usp
18
OpenImis.ModulesV3\PolicyModule\Repositories\PolicyRenewalRepository.cs130uspIsValidRenewalexec.*usp
19
20
locationlineudf (=stored function)regex
21
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs131udfGetSnapshotIndicatorsudf
22
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs181udfNewPoliciesPhoneStatisticsudf
23
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs182udfNewPoliciesPhoneStatisticsudf
24
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs183udfExpiredPoliciesPhoneStatisticsudf
25
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs184udfExpiredPoliciesPhoneStatisticsudf
26
OpenImis.ModulesV3\ReportModule\Repositories\ReportRepository.cs185udfCollectedContributionudf
27
28
locationlinesql/orm/linq
29
OpenImis.ePayment\Data\ImisBaseLocations.cs23
var sSQL = @"SELECT LV.LocationId,code,LW.locationname Ward,LV.LocationName Village,LW.LocationID WardID FROM tblOfficerVillages OV
tbl
30
OpenImis.ePayment\Data\ImisBaseLocations.cs24 INNER JOIN tblOfficer O ON OV.OfficerId = O.OfficerID AND O.ValidityTo IS NULL AND OV.ValidityTo IS NULLtbl
31
OpenImis.ePayment\Data\ImisBaseLocations.cs25 LEFT JOIN tblLocations LV ON LV.LocationId = OV.LocationId AND LV.LocationType = 'V' AND LV.ValidityTo IS NULLtbl
32
OpenImis.ePayment\Data\ImisBaseLocations.cs26 LEFT JOIN tblLocations LW ON LW.LocationId = LV.ParentLocationId AND LW.ValidityTo IS NULLtbl
33
OpenImis.ePayment\Data\ImisBasePayment.cs107
var sSQL = @"UPDATE tblPayment SET TypeOfPayment = @TypeOfPayment,TransferFee = @TransferFee WHERE PaymentID = @paymentId";
tbl
34
OpenImis.ePayment\Data\ImisBasePayment.cs306 var sSQL = @"SELECT * FROM tblControlNumber WHERE PaymentID != @PaymentID AND ControlNumber = @ControlNumber";tbl
35
OpenImis.ePayment\Data\ImisBasePayment.cs499 FROM tblControlNumber WHERE PaymentID IN({0})", PaymentIds);tbl
36
OpenImis.ePayment\Data\ImisBasePayment.cs556 FROM tblPayment AS Paymenttbl
37
OpenImis.ePayment\Data\ImisBasePayment.cs557 INNER JOIN tblPaymentDetails AS PaymentDetails ON PaymentDetails.PaymentID=Payment.PaymentIDtbl
38
OpenImis.ePayment\Data\ImisBasePayment.cs558 INNER JOIN tblPremium AS Premium ON Premium.PremiumID=PaymentDetails.PremiumIDtbl
39
OpenImis.ePayment\Data\ImisBasePayment.cs568 FROM tblPayment AS Paymenttbl
40
OpenImis.ePayment\Data\ImisBasePayment.cs569 LEFT JOIN tblPaymentDetails AS PaymentDetails ON PaymentDetails.PaymentID=Payment.PaymentIDtbl
41
OpenImis.ePayment\Data\ImisBasePayment.cs570 LEFT JOIN tblInsuree AS Insuree ON Insuree.CHFID=PaymentDetails.InsuranceNumbertbl
42
OpenImis.ePayment\Data\ImisBasePayment.cs571 LEFT JOIN tblProduct AS Product ON Product.ProductCode=PaymentDetails.ProductCodetbl
43
OpenImis.ePayment\Data\ImisBasePayment.cs572 LEFT JOIN tblLocations AS District ON Product.LocationId=District.LocationId AND District.LocationType='D'tbl
44
OpenImis.ePayment\Data\ImisBasePayment.cs573 LEFT JOIN tblLocations AS Region ON Product.LocationId=Region.LocationId AND Region.LocationType='R'tbl
45
OpenImis.ePayment\Data\ImisBasePayment.cs574 LEFT JOIN tblControlNumber AS ControlNumber ON ControlNumber.PaymentID=Payment.PaymentIDtbl
46
OpenImis.ePayment\Data\ImisBasePayment.cs575 LEFT JOIN tblPremium AS Premium ON Premium.PremiumID=PaymentDetails.PremiumIDtbl
47
OpenImis.ePayment\Data\ImisBasePayment.cs576 LEFT JOIN tblPolicy AS Policy ON Policy.PolicyID=Premium.PolicyIDtbl
48
OpenImis.ePayment\Data\ImisBasePayment.cs578 FROM tblPremium Ptbl
49
OpenImis.ePayment\Data\ImisBasePayment.cs579 INNER JOIN tblPaymentDetails PD ON PD.PremiumID = P.PremiumIdtbl
50
OpenImis.ePayment\Data\ImisBasePayment.cs580 INNER JOIN tblPayment Pay ON Pay.PaymentID = PD.PaymentIDtbl
51
OpenImis.ePayment\Data\ImisBasePayment.cs669 FROM tblPayment AS Paymenttbl
52
OpenImis.ePayment\Data\ImisBasePayment.cs670 LEFT JOIN tblPaymentDetails AS PaymentDetails ON PaymentDetails.PaymentID=Payment.PaymentIDtbl
53
OpenImis.ePayment\Data\ImisBasePayment.cs712 var sSQl = @"SELECT tblPayment.PaymentID,tblPayment.DateLastSMS,tblPayment.MatchedDatetbl
54
OpenImis.ePayment\Data\ImisBasePayment.cs713 FROM tblControlNumbertbl
55
OpenImis.ePayment\Data\ImisBasePayment.cs714 RIGHT OUTER JOIN tblInsureetbl
56
OpenImis.ePayment\Data\ImisBasePayment.cs715 RIGHT OUTER JOIN tblProducttbl
57
OpenImis.ePayment\Data\ImisBasePayment.cs716 RIGHT OUTER JOIN tblPaymenttbl
58
OpenImis.ePayment\Data\ImisBasePayment.cs717 INNER JOIN tblPaymentDetailstbl
59
OpenImis.ePayment\Data\ImisBasePayment.cs718 ON tblPayment.PaymentID = tblPaymentDetails.PaymentIDtbl
60
OpenImis.ePayment\Data\ImisBasePayment.cs719 ON tblProduct.ProductCode = tblPaymentDetails.ProductCodetbl
61
OpenImis.ePayment\Data\ImisBasePayment.cs720 ON tblInsuree.CHFID = tblPaymentDetails.InsuranceNumbertbl
62
OpenImis.ePayment\Data\ImisBasePayment.cs721 ON tblControlNumber.PaymentID = tblPayment.PaymentIDtbl
63
OpenImis.ePayment\Data\ImisBasePayment.cs722 LEFT OUTER JOIN tblPremiumtbl
64
OpenImis.ePayment\Data\ImisBasePayment.cs723 LEFT OUTER JOIN tblPolicytbl
65
OpenImis.ePayment\Data\ImisBasePayment.cs724 ON tblPremium.PolicyID = tblPolicy.PolicyIDtbl
66
OpenImis.ePayment\Data\ImisBasePayment.cs725 ON tblPaymentDetails.PremiumID = tblPremium.PremiumIdtbl
67
OpenImis.ePayment\Data\ImisBasePayment.cs726 WHERE (tblProduct.ValidityTo IS NULL) AND (tblInsuree.ValidityTo IS NULL)tbl
68
OpenImis.ePayment\Data\ImisBasePayment.cs727 AND tblPayment.PaymentStatus >= 4 AND tblPayment.PaymentStatus < 5";tbl
69
OpenImis.ePayment\Data\ImisBasePayment.cs751 var sSQL = @"UPDATE tblPaymenttbl
70
OpenImis.ePayment\Data\ImisBasePayment.cs771 var sSQL = @"SELECT PaymentID FROM tblControlNumber WHERE ControlNumber = @ControlNumber";tbl
71
OpenImis.ePayment\Data\ImisBasePayment.cs805 var sSQL = @"SELECT * FROM tblPayment WHERE ReceivedDate BETWEEN @DateFrom AND @DateTo";tbl
72
OpenImis.ePayment\Data\ImisBasePayment.cs844 var sSQL = @"UPDATE tblPaymenttbl
73
OpenImis.ePayment\Data\ImisBasePayment.cs864 var sSQL = @"UPDATE tblPaymenttbl
74
OpenImis.ePayment\Data\ImisBasePayment.cs886 var sSQL = @"UPDATE tblPaymenttbl
75
OpenImis.ePayment\Data\ImisBasePayment.cs909
var sSQL = @"SELECT PaymentID FROM tblPayment WHERE PaymentID = @paymentId And PaymentStatus<>@PaymentStatus And ValidityTo is Null";
tbl
76
OpenImis.ePayment\Data\ImisBasePayment.cs937 var sSQL = @"SELECT PaymentID FROM tblPayment WHERE PaymentID = @paymentId And ValidityTo is Null";tbl
77
OpenImis.ePayment\Data\ImisBasePayment.cs964 var sSQL = @"UPDATE tblPaymenttbl
78
OpenImis.ePayment\Data\ImisBasePayment.cs983 public TblOfficer GetOfficerInfo(int officerId)tbl
79
OpenImis.ePayment\Data\ImisBasePayment.cs986 return context.TblOfficer.Where(o => o.OfficerId == officerId).FirstOrDefault();tbl
80
OpenImis.ePayment\Data\ImisPolicy.cs84 FROM tblPremium AS PR INNER JOINtbl
81
OpenImis.ePayment\Data\ImisPolicy.cs85 tblPolicy AS P ON P.PolicyID = PR.PolicyID AND P.ValidityTo IS NULL INNER JOINtbl
82
OpenImis.ePayment\Data\ImisPolicy.cs86 tblReporting AS R ON R.ReportingId = PR.ReportingCommissionID INNER JOINtbl
83
OpenImis.ePayment\Data\ImisPolicy.cs87 tblOfficer O ON P.OfficerID = O.OfficerIDtbl
84
OpenImis.ePayment\Escape\Payment\Data\GepgUtility.cs101 FROM tblInsuree WHERE CHFID = @InsureeNumber";tbl
85
OpenImis.ePayment\Escape\Payment\Data\GepgUtility.cs128 FROM tblOfficer WHERE ValidityTo IS NULL AND Code = @OfficerCode";tbl
86
OpenImis.ePayment\Escape\Payment\Data\GepgUtility.cs428 FROM tblProduct ptbl
87
OpenImis.ePayment\Escape\Payment\Data\GepgUtility.cs429 inner join tblPaymentDetails pd on p.ProductCode=pd.ProductCodetbl
88
OpenImis.ePayment\Escape\Payment\Data\GepgUtility.cs450
var getAccountCodeQuery = @"SELECT AccCodePremiums FROM tblProduct WHERE ProductCode = @ProductCode AND ValidityTo is NULL";
tbl
89
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs263
var getProductsSPCodes = @"SELECT DISTINCT tblProduct.AccCodePremiums FROM tblProduct WHERE tblProduct.AccCodePremiums LIKE 'SP[0-9][0-9][0-9
tbl
90
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs301
var sSQL = @"SELECT PaymentId, ExpectedAmount, ReceivedAmount, PaymentStatus FROM tblPayment WHERE PaymentId=@Id And PaymentStatus<=@PaymentS
tbl
91
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs421 FROM tblControlNumber CNtbl
92
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs426 FROM tblPaymentDetails PDtbl
93
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs427 LEFT OUTER JOIN tblControlNumber CN ON PD.PaymentId = CN.PaymentIdtbl
94
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs432 FROM tblPayment Ptbl
95
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs433 LEFT OUTER JOIN tblControlNumber CN ON P.PaymentId = CN.PaymentIdtbl
96
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs485 FROM tblControlNumber CNtbl
97
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs486 INNER JOIN tblPaymentDetails PD ON CN.PaymentID = PD.PaymentIDtbl
98
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs487 INNER JOIN tblPayment P ON PD.PaymentID = P.PaymentIDtbl
99
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs488 LEFT OUTER JOIN tblOfficer O ON Code = @OfficerCodetbl
100
OpenImis.ePayment\Escape\Payment\Data\ImisPayment.cs500 INNER JOIN tblPayment P ON P.PaymentId = dt.BillId;tbl