Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

LeadContactBLL.vb

Imports APPCODE.DAL

Public Class LeadContactBLL
    Private Shared _spname As String = "_spLeadContact"

Public Shared Function Insert(ByVal LeadContact_Title As String, ByVal LeadContact_Name As String, ByVal LeadContact_DesigId As Integer,
                                  ByVal LeadContact_Email As String, ByVal LeadContact_MobileNo As String, ByVal LeadContact_OfficeNo As String,
                                  ByVal LeadContact_Extention As String, ByVal LeadContact_CreatedID As String,
                                  ByVal LeadContact_LeadID As Integer, ByVal AudtTrail_LogId As Integer, ByVal PrimaryContact As Boolean) As Integer
        Dim sqlparams(11) As SqlParameter
        Try
            sqlparams(0) = New SqlParameter("@Mode", "Insert")
            sqlparams(1) = New SqlParameter("@LeadContact_Title", LeadContact_Title)
            sqlparams(2) = New SqlParameter("@LeadContact_Name", LeadContact_Name)
            sqlparams(3) = New SqlParameter("@LeadContact_DesigId", LeadContact_DesigId)
            sqlparams(4) = New SqlParameter("@LeadContact_Email", LeadContact_Email)
            sqlparams(5) = New SqlParameter("@LeadContact_MobileNo", LeadContact_MobileNo)
            sqlparams(6) = New SqlParameter("@LeadContact_OfficeNo", LeadContact_OfficeNo)
            sqlparams(7) = New SqlParameter("@LeadContact_Extention", LeadContact_Extention)
            sqlparams(8) = New SqlParameter("@LeadContact_CreatedID", LeadContact_CreatedID)
            sqlparams(9) = New SqlParameter("@LeadContact_LeadID", LeadContact_LeadID)
            sqlparams(10) = New SqlParameter("@AudtTrail_LogId", AudtTrail_LogId)
            sqlparams(11) = New SqlParameter("@LeadContact_Primary", PrimaryContact)
            Return DBBridge.ExecuteNonQuery(_spname, sqlparams)
        Catch ex As Exception
            Throw ex
        End Try
    End Function

Public Shared Function QuickInsert(ByVal LeadContact_Name As String, ByVal LeadContact_Email As String, ByVal LeadContact_MobileNo As String, ByVal LeadContact_OfficeNo As String,
                                  ByVal LeadContact_Extention As String, ByVal LeadContact_CreatedID As String, ByVal LeadContact_LeadID As Integer,
                                  ByVal AudtTrail_LogId As Integer, ByVal PrimaryContact As Boolean) As Integer
        Dim sqlparams(10) As SqlParameter
        Try
            sqlparams(0) = New SqlParameter("@Mode", "Insert")
            sqlparams(1) = New SqlParameter("@LeadContact_Name", LeadContact_Name)
            sqlparams(2) = New SqlParameter("@LeadContact_Email", LeadContact_Email)
            sqlparams(3) = New SqlParameter("@LeadContact_MobileNo", LeadContact_MobileNo)
            sqlparams(4) = New SqlParameter("@LeadContact_OfficeNo", LeadContact_OfficeNo)
            sqlparams(5) = New SqlParameter("@LeadContact_Extention", LeadContact_Extention)
            sqlparams(6) = New SqlParameter("@LeadContact_CreatedID", LeadContact_CreatedID)
            sqlparams(7) = New SqlParameter("@LeadContact_LeadID", LeadContact_LeadID)
            sqlparams(8) = New SqlParameter("@AudtTrail_LogId", AudtTrail_LogId)
            sqlparams(9) = New SqlParameter("@LeadContact_Primary", PrimaryContact)
            sqlparams(10) = New SqlParameter("@LeadContact_DesigId", 0)
            Return DBBridge.ExecuteNonQuery(_spname, sqlparams)
        Catch ex As Exception
            Throw ex
        End Try
    End Function

Public Shared Function Update(ByVal LeadContact_Title As String, ByVal LeadContact_Name As String, ByVal LeadContact_DesigId As Integer,
                                  ByVal LeadContact_Email As String, ByVal LeadContact_MobileNo As String, ByVal LeadContact_OfficeNo As String,
                                  ByVal LeadContact_Extention As String, ByVal LeadContact_ModifiedID As Integer, ByVal LeadContact_LeadId As Integer, ByVal AudtTrail_LogId As Integer) As Integer
        Dim sqlparams(10) As SqlParameter
        Try
            sqlparams(0) = New SqlParameter("@Mode", "Update")
            sqlparams(1) = New SqlParameter("@LeadContact_Title", LeadContact_Title)
            sqlparams(2) = New SqlParameter("@LeadContact_Name", LeadContact_Name)
            sqlparams(3) = New SqlParameter("@LeadContact_DesigId", LeadContact_DesigId)
            sqlparams(4) = New SqlParameter("@LeadContact_Email", LeadContact_Email)
            sqlparams(5) = New SqlParameter("@LeadContact_MobileNo", LeadContact_MobileNo)
            sqlparams(6) = New SqlParameter("@LeadContact_OfficeNo", LeadContact_OfficeNo)
            sqlparams(7) = New SqlParameter("@LeadContact_Extention", LeadContact_Extention)
            sqlparams(8) = New SqlParameter("@LeadContact_ModifiedID", LeadContact_ModifiedID)
            sqlparams(9) = New SqlParameter("@LeadContact_LeadId", LeadContact_LeadId)
            sqlparams(10) = New SqlParameter("@AudtTrail_LogId", AudtTrail_LogId)
            Return DBBridge.ExecuteNonQuery(_spname, sqlparams)
        Catch ex As Exception
            Throw ex
        End Try
    End Function

Public Shared Function UpdatePrimaryContact(ByVal LeadContactID As Integer, ByVal LeadContact_ModifiedID As Integer, ByVal LeadContact_LeadId As Integer,
                                                ByVal AudtTrail_LogId As Integer) As Integer
        Dim sqlparams(4) As SqlParameter
        Try
            sqlparams(0) = New SqlParameter("@Mode", "UpdatePrimaryContact")
            sqlparams(1) = New SqlParameter("@LeadContact_Id", LeadContactID)
            sqlparams(2) = New SqlParameter("@LeadContact_ModifiedID", LeadContact_ModifiedID)
            sqlparams(3) = New SqlParameter("@LeadContact_LeadId", LeadContact_LeadId)
            sqlparams(4) = New SqlParameter("@AudtTrail_LogId", AudtTrail_LogId)
            Return DBBridge.ExecuteNonQuery(_spname, sqlparams)
        Catch ex As Exception
            Throw ex
        End Try
    End Function

End Class

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2015-10-31 05:26:12
..	dir	-	0/0	0777	2015-10-31 05:26:12
AccountBLL.vb	text/plain	5.39 KB	0/0	0666	2015-06-08 01:01:12
ActivityBLL.vb	text/plain	41.93 KB	0/0	0666	2015-05-28 04:32:56
AssignToBLL.vb	text/plain	2.75 KB	0/0	0666	2015-06-13 03:38:42
BlogBLL.vb	text/plain	4.69 KB	0/0	0666	2015-01-12 02:00:12
CampaignBLL.vb	text/plain	3.29 KB	0/0	0666	2015-01-29 02:35:24
CampaignTypeBLL.vb	text/plain	1.73 KB	0/0	0666	2015-01-15 11:58:28
CategoryBLL.vb	text/plain	2.02 KB	0/0	0666	2015-01-29 05:46:14
ChargeBLL.vb	text/plain	5.08 KB	0/0	0666	2015-08-14 10:50:32
CityBLL.vb	text/plain	2.06 KB	0/0	0666	2015-01-12 02:00:12
ColoumSettingBLL.vb	text/plain	3.12 KB	0/0	0666	2015-01-28 11:16:54
CompanyBLL.vb	text/plain	2.37 KB	0/0	0666	2015-03-16 05:49:10
CompanyTypeBLL.vb	text/plain	1.55 KB	0/0	0666	2015-01-15 10:25:38
CompetitorBLL.vb	text/plain	2.97 KB	0/0	0666	2015-02-27 10:32:00
ComplaintBLL.vb	text/plain	4.48 KB	0/0	0666	2015-02-26 11:53:14
ContactBLL.vb	text/plain	11.86 KB	0/0	0666	2015-03-03 03:28:32
ContactTypeBLL.vb	text/plain	1.84 KB	0/0	0666	2015-01-29 05:46:14
CountBLL.vb	text/plain	911 B	0/0	0666	2015-04-03 10:28:50
CounterBLL.vb	text/plain	2.02 KB	0/0	0666	2015-01-12 02:00:12
CountryBLL.vb	text/plain	2.26 KB	0/0	0666	2015-01-12 02:00:12
CurrencyBLL.vb	text/plain	1.74 KB	0/0	0666	2015-01-15 10:25:38
CustomerAddressBLL.vb	text/plain	3.95 KB	0/0	0666	2015-01-12 02:00:12
CustomerBLL.vb	text/plain	12.4 KB	0/0	0666	2015-01-12 02:00:12
CustomsReport.vb	text/plain	6.19 KB	0/0	0666	2015-04-08 10:38:58
DashBoardBLL.vb	text/plain	694 B	0/0	0666	2015-06-08 01:01:08
DepartmentBLL.vb	text/plain	1.63 KB	0/0	0666	2015-02-24 04:55:46
DesignationBLL.vb	text/plain	1.62 KB	0/0	0666	2015-01-14 04:59:26
DocumentBLL.vb	text/plain	4.94 KB	0/0	0666	2015-02-03 12:31:40
EmailBLL.vb	text/plain	2.58 KB	0/0	0666	2015-03-16 02:33:12
EmployeeBLL.vb	text/plain	2.3 KB	0/0	0666	2015-01-12 02:00:12
EnquiryBLL.vb	text/plain	991 B	0/0	0666	2015-01-12 02:00:12
ExecptionBLL.vb	text/plain	1.11 KB	0/0	0666	2015-02-28 12:14:52
FaqBLL.vb	text/plain	1.76 KB	0/0	0666	2015-01-12 02:00:12
FollowUpBLL.vb	text/plain	2.56 KB	0/0	0666	2015-01-12 02:00:12
GLAccountBLL.vb	text/plain	1.54 KB	0/0	0666	2015-05-19 02:25:10
GetRateBLL.vb	text/plain	4.3 KB	0/0	0666	2015-01-12 02:00:12
HolidayBLL.vb	text/plain	1.86 KB	0/0	0666	2015-01-12 02:00:12
HomepageImageBLL.vb	text/plain	1.9 KB	0/0	0666	2015-01-12 02:00:12
ImportAccountBLL.vb	text/plain	4.9 KB	0/0	0666	2015-04-30 12:24:32
ImportLeadBLL.vb	text/plain	2.29 KB	0/0	0666	2015-03-02 10:17:46
IndustryBLL.vb	text/plain	1.53 KB	0/0	0666	2015-01-28 11:16:54
InvoiceBLL.vb	text/plain	13.13 KB	0/0	0666	2015-08-14 10:50:32
ItemBLL.vb	text/plain	2.79 KB	0/0	0666	2015-03-16 02:33:12
ItemDetailBLL.vb	text/plain	4.01 KB	0/0	0666	2015-03-16 02:33:12
LeadAddressBLL.vb	text/plain	3.09 KB	0/0	0666	2015-02-28 12:05:54
LeadAssignBLL.vb	text/plain	2.13 KB	0/0	0666	2015-01-12 02:00:12
LeadBLL.vb	text/plain	8.74 KB	0/0	0666	2015-06-20 04:22:34
LeadContactBLL.vb	text/plain	5.91 KB	0/0	0666	2015-04-20 06:31:18
LeadSubTypeBLL.vb	text/plain	1.86 KB	0/0	0666	2015-01-12 02:00:12
LeadTypeBLL.vb	text/plain	1.5 KB	0/0	0666	2015-01-29 05:46:14
LevelBLL.vb	text/plain	1.46 KB	0/0	0666	2015-01-16 11:09:32
MainBLL.vb	text/plain	21.15 KB	0/0	0666	2015-08-31 03:18:22
MainWebsiteBLL.vb	text/plain	4.55 KB	0/0	0666	2015-01-12 02:00:12
ManufacturerBLL.vb	text/plain	1.59 KB	0/0	0666	2015-05-18 10:54:18
MappingTaxNameBLL.vb	text/plain	2.03 KB	0/0	0666	2015-02-18 10:32:54
MemberBLL.vb	text/plain	3.59 KB	0/0	0666	2015-01-12 02:00:14
MenuBLL.vb	text/plain	1.96 KB	0/0	0666	2015-01-12 02:00:14
MenuFooterBLL.vb	text/plain	2.87 KB	0/0	0666	2015-01-12 02:00:12
NewQuotationBLL.vb	text/plain	13.29 KB	0/0	0666	2015-08-14 10:50:32
NewsBLL.vb	text/plain	2.64 KB	0/0	0666	2015-01-12 02:00:12
NoteBLL.vb	text/plain	6.24 KB	0/0	0666	2015-03-23 03:12:02
OpporStageHistoryBLL.vb	text/plain	1.77 KB	0/0	0666	2015-02-27 10:32:00
OpportunityBLL.vb	text/plain	5.58 KB	0/0	0666	2015-03-02 11:53:56
OpportunityStageBLL.vb	text/plain	1.97 KB	0/0	0666	2015-02-24 04:55:46
OrderBLL.vb	text/plain	16.05 KB	0/0	0666	2015-05-02 11:15:52
OrderParcelBLL.vb	text/plain	1.86 KB	0/0	0666	2015-01-12 02:00:14
PageBLL.vb	text/plain	2.69 KB	0/0	0666	2015-01-12 02:00:14
PageSeoBLL.vb	text/plain	6.04 KB	0/0	0666	2015-01-12 02:00:14
PartnerBLL.vb	text/plain	1.8 KB	0/0	0666	2015-01-12 02:00:14
PartnerRestrictBLL.vb	text/plain	1.49 KB	0/0	0666	2015-01-12 02:00:14
PrivilageBLL.vb	text/plain	1.9 KB	0/0	0666	2015-01-13 03:09:38
ProductBLL.vb	text/plain	9.95 KB	0/0	0666	2015-06-29 10:47:18
ProductCategoryBLL.vb	text/plain	2.05 KB	0/0	0666	2015-06-13 02:45:48
ProductSubCategoryBLL.vb	text/plain	2.92 KB	0/0	0666	2015-06-13 02:45:42
ProductUsageUnitBLL.vb	text/plain	1.48 KB	0/0	0666	2015-06-13 02:45:42
ProformaBLL.vb	text/plain	4.97 KB	0/0	0666	2015-03-16 05:49:10
ProspectAddressBLL.vb	text/plain	3.8 KB	0/0	0666	2015-02-24 04:55:46
ProspectBLL.vb	text/plain	5.16 KB	0/0	0666	2015-03-10 12:03:48
ProspectContactBLL.vb	text/plain	9.32 KB	0/0	0666	2015-06-20 05:27:58
QuotationBLL.vb	text/plain	5.07 KB	0/0	0666	2015-03-16 02:33:12
ReasonForLostBLL.vb	text/plain	1.68 KB	0/0	0666	2015-01-29 05:46:14
Region.vb	text/plain	1.49 KB	0/0	0666	2015-01-15 10:25:38
ReplyBLL.vb	text/plain	1.48 KB	0/0	0666	2014-11-21 06:21:12
ReviewBLL.vb	text/plain	1.93 KB	0/0	0666	2015-01-12 02:00:14
SalesOrderBLL.vb	text/plain	12.93 KB	0/0	0666	2015-06-29 10:47:18
SalesTargetBLL.vb	text/plain	2.21 KB	0/0	0666	2015-04-08 10:38:58
SendMailBLL.vb	text/plain	3.37 KB	0/0	0666	2015-04-08 11:47:44
ServiceBLL.vb	text/plain	917 B	0/0	0666	2015-06-29 10:47:18
ServiceCategoryBLL.vb	text/plain	2.05 KB	0/0	0666	2015-06-13 02:45:44
ServiceSubCategoryBLL.vb	text/plain	2.92 KB	0/0	0666	2015-06-13 02:45:46
ServiceUsageUnitBLL.vb	text/plain	1.48 KB	0/0	0666	2015-06-13 02:47:54
SourceBLL.vb	text/plain	1.49 KB	0/0	0666	2015-01-14 11:12:34
StageBLL .vb	text/plain	4.35 KB	0/0	0666	2015-03-02 06:00:56
StatusBLL.vb	text/plain	2.1 KB	0/0	0666	2015-01-28 11:16:54
SubCategoryBLL.vb	text/plain	3.17 KB	0/0	0666	2015-01-29 05:46:14
TaxBLL.vb	text/plain	7.37 KB	0/0	0666	2015-08-14 10:50:32
TicketBLL.vb	text/plain	4.73 KB	0/0	0666	2015-06-29 10:47:20
TrackingBLL.vb	text/plain	4.24 KB	0/0	0666	2015-01-12 02:00:14
UOMBLL.vb	text/plain	1.68 KB	0/0	0666	2015-01-28 11:16:54
UploadExcelBLL.vb	text/plain	4.21 KB	0/0	0666	2015-01-12 02:00:14
UserBLL.vb	text/plain	17.55 KB	0/0	0666	2015-08-14 02:53:54
UserTypeBLL.vb	text/plain	1.48 KB	0/0	0666	2015-01-28 11:16:54
VendorBLL.vb	text/plain	5.29 KB	0/0	0666	2015-06-20 03:23:42
VendorServiceBLL.vb	text/plain	1.4 KB	0/0	0666	2015-01-12 02:00:14
VendorServiceLinkBLL.vb	text/plain	1.72 KB	0/0	0666	2015-01-12 02:00:14
YearBLL.vb	text/plain	1.43 KB	0/0	0666	2015-01-15 10:25:38
ZoneBLL.vb	text/plain	1.43 KB	0/0	0666	2015-01-12 02:00:14

Team Anon Force

https://t.me/Professor6T9x