<%@ CodePage=1252 %> <% 'Include Common Files @1-C42A9701 %> <% 'End Include Common Files 'Initialize Page @1-AA05EE8B ' Variables Dim PathToRoot, ScriptPath, TemplateFilePath Dim FileName Dim Redirect Dim IsService Dim Tpl, HTMLTemplate Dim TemplateFileName Dim ComponentName Dim PathToCurrentPage Dim Attributes ' Events Dim CCSEvents Dim CCSEventResult ' Connections Dim DBConnection1 ' Page controls Dim users2 Dim cars Dim ChildControls Session.CodePage=28591 Response.ContentType = CCSContentType IsService = False Redirect = "" TemplateFileName = "admin.html" Set CCSEvents = CreateObject("Scripting.Dictionary") PathToCurrentPage = "./" FileName = "admin.asp" PathToRoot = "./" ScriptPath = Left(Request.ServerVariables("PATH_TRANSLATED"), Len(Request.ServerVariables("PATH_TRANSLATED")) - Len(FileName)) TemplateFilePath = ScriptPath 'End Initialize Page 'Authenticate User @1-3A3D5059 CCSecurityRedirect "3", Empty 'End Authenticate User 'Initialize Objects @1-F0EFCE9B BindEvents "Page" CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeInitialize", Nothing) Set DBConnection1 = New clsDBConnection1 DBConnection1.Open Set Attributes = New clsAttributes Attributes("pathToRoot") = PathToRoot ' Controls Set users2 = New clsGridusers2 Set cars = New clsGridcars users2.Initialize DBConnection1 cars.Initialize DBConnection1 ' Events %> <% BindEvents Empty CCSEventResult = CCRaiseEvent(CCSEvents, "AfterInitialize", Nothing) 'End Initialize Objects 'Go to destination page @1-6D35F4FD If NOT ( Redirect = "" ) Then UnloadPage Response.Redirect Redirect End If 'End Go to destination page 'Initialize HTML Template @1-2DA4DCFB CCSEventResult = CCRaiseEvent(CCSEvents, "OnInitializeView", Nothing) Set HTMLTemplate = new clsTemplate HTMLTemplate.Encoding = "iso-8859-1" Set HTMLTemplate.Cache = TemplatesRepository HTMLTemplate.LoadTemplate TemplateFilePath & TemplateFileName HTMLTemplate.SetVar "@CCS_PathToRoot", PathToRoot Set Tpl = HTMLTemplate.Block("main") CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShow", Nothing) 'End Initialize HTML Template 'Show Page @1-818586C5 Attributes.Show HTMLTemplate, "page:" Set ChildControls = CCCreateCollection(Tpl, Null, ccsParseOverwrite, _ Array(users2, cars)) ChildControls.Show Dim MainHTML HTMLTemplate.Parse "main", False If IsEmpty(MainHTML) Then MainHTML = HTMLTemplate.GetHTML("main") CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeOutput", Nothing) If CCSEventResult Then Response.Write MainHTML 'End Show Page 'Unload Page @1-CB210C62 UnloadPage Set Tpl = Nothing Set HTMLTemplate = Nothing 'End Unload Page 'UnloadPage Sub @1-9EFA50F9 Sub UnloadPage() CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeUnload", Nothing) If DBConnection1.State = adStateOpen Then _ DBConnection1.Close Set DBConnection1 = Nothing Set CCSEvents = Nothing Set Attributes = Nothing Set users2 = Nothing Set cars = Nothing End Sub 'End UnloadPage Sub Class clsGridusers2 'users2 Class @23-5EF1269D 'users2 Variables @23-3C38B211 ' Private variables Private VarPageSize ' Public variables Public ComponentName, CCSEvents Public Visible, Errors Public DataSource Public PageNumber Public Command Public TemplateBlock Public IsDSEmpty Public ForceIteration Public Attributes Private ShownRecords Public Recordset Private CCSEventResult ' Grid Controls Public StaticControls, RowControls, NoRecordsControls Dim first_name 'End users2 Variables 'users2 Class_Initialize Event @23-C45C5BE6 Private Sub Class_Initialize() ComponentName = "users2" Visible = True Set CCSEvents = CreateObject("Scripting.Dictionary") Set Attributes = New clsAttributes Set Errors = New clsErrors Set DataSource = New clsusers2DataSource Set Command = New clsCommand PageSize = CCGetParam(ComponentName & "PageSize", Empty) If IsNumeric(PageSize) And Len(PageSize) > 0 Then If PageSize <= 0 Then Errors.AddError(CCSLocales.GetText("CCS_GridPageSizeError", Empty)) If PageSize > 100 Then PageSize = 100 End If If NOT IsNumeric(PageSize) OR IsEmpty(PageSize) Then _ PageSize = 1 _ Else _ PageSize = CInt(PageSize) PageNumber = CCGetParam(ComponentName & "Page", 1) If Not IsNumeric(PageNumber) And Len(PageNumber) > 0 Then Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty)) PageNumber = 1 ElseIf Len(PageNumber) > 0 Then If PageNumber > 0 Then PageNumber = CLng(PageNumber) Else Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty)) PageNumber = 1 End If Else PageNumber = 1 End If Set first_name = CCCreateControl(ccsLabel, "first_name", Empty, ccsText, Empty, CCGetRequestParam("first_name", ccsGet)) IsDSEmpty = True End Sub 'End users2 Class_Initialize Event 'users2 Initialize Method @23-57CE6952 Sub Initialize(objConnection) If NOT Visible Then Exit Sub Set DataSource.Connection = objConnection DataSource.PageSize = PageSize DataSource.AbsolutePage = PageNumber End Sub 'End users2 Initialize Method 'users2 Class_Terminate Event @23-B97CC660 Private Sub Class_Terminate() Set CCSEvents = Nothing Set DataSource = Nothing Set Command = Nothing Set Errors = Nothing Set Attributes = Nothing End Sub 'End users2 Class_Terminate Event 'users2 Show Method @23-71EE2E20 Sub Show(Tpl) Dim HasNext If NOT Visible Then Exit Sub Dim RowBlock, NoRecordsBlock With DataSource .Parameters("expr25") = CCGetUserID() End With CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeSelect", Me) Set Recordset = DataSource.Open(Command) If DataSource.Errors.Count = 0 Then IsDSEmpty = Recordset.EOF Set TemplateBlock = Tpl.Block("Grid " & ComponentName) If TemplateBlock is Nothing Then Exit Sub Set RowBlock = TemplateBlock.Block("Row") Set NoRecordsBlock = TemplateBlock.Block("NoRecords") Set RowControls = CCCreateCollection(RowBlock, Null, ccsParseAccumulate, _ Array(first_name)) CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShow", Me) If NOT Visible Then Exit Sub RowControls.PreserveControlsVisible Errors.AddErrors DataSource.Errors If Errors.Count > 0 Then TemplateBlock.HTML = CCFormatError("Grid " & ComponentName, Errors) Else ' Show NoRecords block if no records are found If Recordset.EOF Then Attributes.Show TemplateBlock, "users2:" TemplateBlock.Block("NoRecords").Parse ccsParseOverwrite End If HasNext = HasNextRow() ForceIteration = False Do While ForceIteration Or HasNext Attributes("rowNumber") = ShownRecords + 1 If HasNext Then first_name.Value = Recordset.Fields("first_name") End If CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShowRow", Me) Attributes.Show TemplateBlock.Block("Row"), "users2:" RowControls.Show If HasNext Then Recordset.MoveNext ShownRecords = ShownRecords + 1 HasNext = HasNextRow() Loop Attributes.Show TemplateBlock, "users2:" TemplateBlock.Parse ccsParseOverwrite End If End Sub 'End users2 Show Method 'users2 PageSize Property Let @23-54E46DD6 Public Property Let PageSize(NewValue) VarPageSize = NewValue DataSource.PageSize = NewValue End Property 'End users2 PageSize Property Let 'users2 PageSize Property Get @23-9AA1D1E9 Public Property Get PageSize() PageSize = VarPageSize End Property 'End users2 PageSize Property Get 'users2 RowNumber Property Get @23-F32EE2C6 Public Property Get RowNumber() RowNumber = ShownRecords + 1 End Property 'End users2 RowNumber Property Get 'users2 HasNextRow Function @23-9BECE27A Public Function HasNextRow() HasNextRow = NOT Recordset.EOF AND ShownRecords < PageSize End Function 'End users2 HasNextRow Function End Class 'End users2 Class @23-A61BA892 Class clsusers2DataSource 'users2DataSource Class @23-CB220BE0 'DataSource Variables @23-03335E47 Public Errors, Connection, Parameters, CCSEvents Public Recordset Public SQL, CountSQL, Order, Where, Orders, StaticOrder Public PageSize Public PageCount Public AbsolutePage Public Fields Dim WhereParameters Public AllParamsSet Public CmdExecution Public InsertOmitIfEmpty Public UpdateOmitIfEmpty Private CurrentOperation Private CCSEventResult ' Datasource fields Public first_name 'End DataSource Variables 'DataSource Class_Initialize Event @23-51069C7E Private Sub Class_Initialize() Set CCSEvents = CreateObject("Scripting.Dictionary") Set Fields = New clsFields Set Recordset = New clsDataSource Set Recordset.DataSource = Me Set Errors = New clsErrors Set Connection = Nothing AllParamsSet = True Set first_name = CCCreateField("first_name", "first_name", ccsText, Empty, Recordset) Fields.AddFields Array(first_name) Set Parameters = Server.CreateObject("Scripting.Dictionary") Set WhereParameters = Nothing SQL = "SELECT TOP {SqlParam_endRecord} * " & vbLf & _ "FROM users {SQL_Where} {SQL_OrderBy}" CountSQL = "SELECT COUNT(*) " & vbLf & _ "FROM users" Where = "" Order = "" StaticOrder = "" End Sub 'End DataSource Class_Initialize Event 'BuildTableWhere Method @23-CA8700E3 Public Sub BuildTableWhere() Dim WhereParams If Not WhereParameters Is Nothing Then _ Exit Sub Set WhereParameters = new clsSQLParameters With WhereParameters Set .Connection = Connection Set .ParameterSources = Parameters Set .DataSource = Me .AddParameter 1, "expr25", ccsInteger, Empty, Empty, Empty, False .Criterion(1) = .Operation(opEqual, False, "user_id", .getParamByID(1)) .AssembledWhere = .Criterion(1) WhereParams = .AssembledWhere If Len(Where) > 0 Then If Len(WhereParams) > 0 Then _ Where = Where & " AND " & WhereParams Else If Len(WhereParams) > 0 Then _ Where = WhereParams End If End With End Sub 'End BuildTableWhere Method 'Open Method @23-40984FC5 Function Open(Cmd) Errors.Clear If Connection Is Nothing Then Set Open = New clsEmptyDataSource Exit Function End If Set Cmd.Connection = Connection Cmd.CommandOperation = cmdOpen Cmd.PageSize = PageSize Cmd.ActivePage = AbsolutePage Cmd.CommandType = dsTable CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildSelect", Me) Cmd.SQL = SQL Cmd.CountSQL = CountSQL BuildTableWhere Cmd.Where = Where Cmd.OrderBy = Order If(Len(StaticOrder)>0) Then If Len(Order)>0 Then Cmd.OrderBy = ", "+Cmd.OrderBy Cmd.OrderBy = StaticOrder + Cmd.OrderBy End If Cmd.Options("TOP") = True CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteSelect", Me) If Errors.Count = 0 And CCSEventResult Then _ Set Recordset = Cmd.Exec(Errors) CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteSelect", Me) Set Recordset.FieldsCollection = Fields Set Open = Recordset End Function 'End Open Method 'DataSource Class_Terminate Event @23-41B4B08D Private Sub Class_Terminate() If Recordset.State = adStateOpen Then _ Recordset.Close Set Recordset = Nothing Set Parameters = Nothing Set Errors = Nothing End Sub 'End DataSource Class_Terminate Event End Class 'End users2DataSource Class @23-A61BA892 Class clsGridcars 'cars Class @47-CD58647D 'cars Variables @47-C724A62F ' Private variables Private VarPageSize ' Public variables Public ComponentName, CCSEvents Public Visible, Errors Public DataSource Public PageNumber Public Command Public TemplateBlock Public IsDSEmpty Public ForceIteration Public Attributes Private ShownRecords Public Recordset Private CCSEventResult ' Grid Controls Public StaticControls, RowControls, NoRecordsControls Dim RowOpenTag Dim RowComponents Dim price Dim ID Dim ImageLink1 Dim RowCloseTag Dim Navigator 'End cars Variables 'cars Class_Initialize Event @47-79563D3C Private Sub Class_Initialize() ComponentName = "cars" Visible = True Set CCSEvents = CreateObject("Scripting.Dictionary") Set Attributes = New clsAttributes Set Errors = New clsErrors Set DataSource = New clscarsDataSource Set Command = New clsCommand PageSize = CCGetParam(ComponentName & "PageSize", Empty) If IsNumeric(PageSize) And Len(PageSize) > 0 Then If PageSize <= 0 Then Errors.AddError(CCSLocales.GetText("CCS_GridPageSizeError", Empty)) If PageSize > 100 Then PageSize = 100 End If If NOT IsNumeric(PageSize) OR IsEmpty(PageSize) Then _ PageSize = 80 _ Else _ PageSize = CInt(PageSize) PageNumber = CCGetParam(ComponentName & "Page", 1) If Not IsNumeric(PageNumber) And Len(PageNumber) > 0 Then Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty)) PageNumber = 1 ElseIf Len(PageNumber) > 0 Then If PageNumber > 0 Then PageNumber = CLng(PageNumber) Else Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty)) PageNumber = 1 End If Else PageNumber = 1 End If Set RowOpenTag = CCCreatePanel("RowOpenTag") Set RowComponents = CCCreatePanel("RowComponents") Set price = CCCreateControl(ccsLink, "price", Empty, ccsFloat, Empty, CCGetRequestParam("price", ccsGet)) Set ID = CCCreateControl(ccsHidden, "ID", Empty, ccsInteger, Empty, CCGetRequestParam("ID", ccsGet)) Set ImageLink1 = CCCreateControl(ccsImageLink, "ImageLink1", Empty, ccsText, Empty, CCGetRequestParam("ImageLink1", ccsGet)) Set RowCloseTag = CCCreatePanel("RowCloseTag") Set Navigator = CCCreateNavigator(ComponentName, "Navigator", FileName, 10, tpSimple) Navigator.PageSizes = Array("1", "5", "10", "25", "50") RowComponents.AddComponents(Array(price,ID,ImageLink1)) IsDSEmpty = True End Sub 'End cars Class_Initialize Event 'cars Initialize Method @47-57CE6952 Sub Initialize(objConnection) If NOT Visible Then Exit Sub Set DataSource.Connection = objConnection DataSource.PageSize = PageSize DataSource.AbsolutePage = PageNumber End Sub 'End cars Initialize Method 'cars Class_Terminate Event @47-B97CC660 Private Sub Class_Terminate() Set CCSEvents = Nothing Set DataSource = Nothing Set Command = Nothing Set Errors = Nothing Set Attributes = Nothing End Sub 'End cars Class_Terminate Event 'cars Show Method @47-5AF9A77D Sub Show(Tpl) Dim HasNext If NOT Visible Then Exit Sub Dim RowBlock, NoRecordsBlock CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeSelect", Me) Set Recordset = DataSource.Open(Command) If DataSource.Errors.Count = 0 Then IsDSEmpty = Recordset.EOF Set TemplateBlock = Tpl.Block("Grid " & ComponentName) If TemplateBlock is Nothing Then Exit Sub Set RowBlock = TemplateBlock.Block("Row") Set NoRecordsBlock = TemplateBlock.Block("NoRecords") Set StaticControls = CCCreateCollection(TemplateBlock, Null, ccsParseOverwrite, _ Array(Navigator)) Navigator.PageSize = PageSize Navigator.SetDataSource Recordset Set RowControls = CCCreateCollection(RowBlock, Null, ccsParseAccumulate, _ Array(RowOpenTag, RowComponents, RowCloseTag)) Attributes("numberOfColumns") = 4 CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShow", Me) If NOT Visible Then Exit Sub RowControls.PreserveControlsVisible Errors.AddErrors DataSource.Errors If Errors.Count > 0 Then TemplateBlock.HTML = CCFormatError("Grid " & ComponentName, Errors) Else ' Show NoRecords block if no records are found If Recordset.EOF Then Attributes.Show TemplateBlock, "cars:" TemplateBlock.Block("NoRecords").Parse ccsParseOverwrite End If HasNext = HasNextRow() ForceIteration = False Do While ForceIteration Or HasNext Attributes("rowNumber") = ShownRecords + 1 If HasNext Then price.Value = Recordset.Fields("price") price.Parameters = CCGetQueryString("QueryString", Array("ccsForm")) price.Parameters = CCAddParam(price.Parameters, "ID", Recordset.Fields("price_param1")) price.Page = "caredit.asp" ID.Value = Recordset.Fields("ID") ImageLink1.Value = Recordset.Fields("ImageLink1") ImageLink1.Parameters = CCGetQueryString("QueryString", Array("ccsForm")) ImageLink1.Parameters = CCAddParam(ImageLink1.Parameters, "ID", Recordset.Fields("ImageLink1_param1")) ImageLink1.Page = "caredit.asp" End If CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShowRow", Me) Attributes.Show TemplateBlock.Block("Row"), "cars:" RowControls.Show If HasNext Then Recordset.MoveNext ShownRecords = ShownRecords + 1 HasNext = HasNextRow() Loop Attributes.Show TemplateBlock, "cars:" StaticControls.Show End If End Sub 'End cars Show Method 'cars PageSize Property Let @47-54E46DD6 Public Property Let PageSize(NewValue) VarPageSize = NewValue DataSource.PageSize = NewValue End Property 'End cars PageSize Property Let 'cars PageSize Property Get @47-9AA1D1E9 Public Property Get PageSize() PageSize = VarPageSize End Property 'End cars PageSize Property Get 'cars RowNumber Property Get @47-F32EE2C6 Public Property Get RowNumber() RowNumber = ShownRecords + 1 End Property 'End cars RowNumber Property Get 'cars HasNextRow Function @47-9BECE27A Public Function HasNextRow() HasNextRow = NOT Recordset.EOF AND ShownRecords < PageSize End Function 'End cars HasNextRow Function End Class 'End cars Class @47-A61BA892 Class clscarsDataSource 'carsDataSource Class @47-A80BAE2D 'DataSource Variables @47-B165C754 Public Errors, Connection, Parameters, CCSEvents Public Recordset Public SQL, CountSQL, Order, Where, Orders, StaticOrder Public PageSize Public PageCount Public AbsolutePage Public Fields Dim WhereParameters Public AllParamsSet Public CmdExecution Public InsertOmitIfEmpty Public UpdateOmitIfEmpty Private CurrentOperation Private CCSEventResult ' Datasource fields Public price Public price_param1 Public ID Public ImageLink1 Public ImageLink1_param1 'End DataSource Variables 'DataSource Class_Initialize Event @47-52B5ABA9 Private Sub Class_Initialize() Set CCSEvents = CreateObject("Scripting.Dictionary") Set Fields = New clsFields Set Recordset = New clsDataSource Set Recordset.DataSource = Me Set Errors = New clsErrors Set Connection = Nothing AllParamsSet = True Set price = CCCreateField("price", "price", ccsFloat, Empty, Recordset) Set price_param1 = CCCreateField("price_param1", "ID", ccsText, Empty, Recordset) Set ID = CCCreateField("ID", "ID", ccsInteger, Empty, Recordset) Set ImageLink1 = CCCreateField("ImageLink1", "image1", ccsText, Empty, Recordset) Set ImageLink1_param1 = CCCreateField("ImageLink1_param1", "ID", ccsText, Empty, Recordset) Fields.AddFields Array(price, price_param1, ID, ImageLink1, ImageLink1_param1) SQL = "SELECT TOP {SqlParam_endRecord} * " & vbLf & _ "FROM cars {SQL_Where} {SQL_OrderBy}" CountSQL = "SELECT COUNT(*) " & vbLf & _ "FROM cars" Where = "" Order = "price" StaticOrder = "" End Sub 'End DataSource Class_Initialize Event 'BuildTableWhere Method @47-98E5A92F Public Sub BuildTableWhere() End Sub 'End BuildTableWhere Method 'Open Method @47-6EA306C4 Function Open(Cmd) Errors.Clear If Connection Is Nothing Then Set Open = New clsEmptyDataSource Exit Function End If Set Cmd.Connection = Connection Cmd.CommandOperation = cmdOpen Cmd.PageSize = PageSize Cmd.ActivePage = AbsolutePage Cmd.CommandType = dsTable CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildSelect", Me) Cmd.SQL = SQL Cmd.CountSQL = CountSQL Cmd.Where = Where Cmd.OrderBy = Order If(Len(StaticOrder)>0) Then If Len(Order)>0 Then Cmd.OrderBy = ", "+Cmd.OrderBy Cmd.OrderBy = StaticOrder + Cmd.OrderBy End If Cmd.Options("TOP") = True CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteSelect", Me) If Errors.Count = 0 And CCSEventResult Then _ Set Recordset = Cmd.Exec(Errors) CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteSelect", Me) Set Recordset.FieldsCollection = Fields Set Open = Recordset End Function 'End Open Method 'DataSource Class_Terminate Event @47-41B4B08D Private Sub Class_Terminate() If Recordset.State = adStateOpen Then _ Recordset.Close Set Recordset = Nothing Set Parameters = Nothing Set Errors = Nothing End Sub 'End DataSource Class_Terminate Event End Class 'End carsDataSource Class @47-A61BA892 %>