Home

• Home--index
  • Files: index.aspx, index.aspx.vb
  • Purpose: Serves as the main dashboard for the inventory management system, displaying a summary count of various inventory items (EVMs, Ballot Boxes, VVPATs, Stationery, Forms) and providing descriptive information about these categories.
  • Key Components:
    • ASP.NET Controls (Dashboard Counters):
      • Dashboard (Label): Page title.
      • CntEvm (Label): Displays count of EVM units.
      • EVM (Label): "EVM" label.
      • CntBB (Label): Displays count of Ballot Boxes.
      • BallotBox (Label): "Ballot Box" label.
      • CntVvpat (Label): Displays count of VVPAT units.
      • VVPAT (Label): "VVPAT" label.
      • CntStnry (Label): Displays count of Stationery Items.
      • StationaryItems (Label): "Stationery Items" label.
      • CntForms (Label): Displays total count of Forms.
      • Forms (Label): "Forms" label.
    • ASP.NET Controls (Informational Cards):
      • lblEvmUnits, lblEvmUnitsdesc (Labels): Title and description for EVM Units.
      • lblControlUnits, lblCu (Labels): Title and count for Control Units, with image.
      • lblBallotUnits, lblBU (Labels): Title and count for Ballot Units, with image.
      • lblVVPatUnits, lblVvpat (Labels): Title and count for VVPAT Units, with image.
      • lblBallotBoxes, lblBB (Labels): Title and count for Ballot Boxes, with image and description.
      • lblStationeryItems, lblStnry, lblStationeryItemsDesc (Labels): Title, count, description, and list of stationery items (e.g., "Stationery Articles", "Envelopes", "Sign Boards", etc.).
      • lblFormsPRI, lblFormPRI (Labels): Title, count, and description for Forms PRI.
      • lblFormsUlb1, lblFormULB (Labels): Title, count, and description for Forms Municipalities.
      • lblFormsUlb2, lblFormMC (Labels): Title, count, and description for Forms MC.
    • HTML Elements:
      • Various div elements for layout (col-md-6, col-lg-2, col-xlg-3, card, box, etc.) and styling (e.g., bg-cyan, bg-success).
      • Image tags (<img>) for visual representation of EVM components and Ballot Box.
      • A hidden "Open Modal" link (aModal) and a corresponding modal structure (Modal1) (appears to be a generic modal not specifically tied to the dashboard content, perhaps for future use or inherited from a master page).
    • Client-Side (JavaScript):
      • No custom JavaScript beyond basic preloader fade-out (likely from Master Page) and the commented out jQuery for DataTables (which is not relevant for this page).
      • The only specific script in Content3 is empty.
    • Server-Side (VB.NET - index.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For database interaction.
      • Page_Load event:
        • Retrieves myLang, userName, userLevel, dis_code, block_code from Session.
        • Calls getInventoryCounts() on initial page load.
      • getInventoryCounts() (Private Sub):
        • Uses ErmsInterface.hbInterface and ErmsBLL for data access.
        • Sets parameters for a SqlCommand (@disBlkPanch) based on userLevel (e.g., "000" for "13", "001"/"006"/"012"/"013" for dis_code, others for block_code).
        • Calls MyInterface1.SELECTData(mycommand1, "getInventoryCounts") to retrieve inventory counts.
        • Populates the Text property of various Label controls (lblCu, lblBU, lblBB, lblVvpat, lblStnry, lblFormPRI, lblFormULB, lblFormMC, CntEvm, CntBB, CntStnry, CntForms, CntVvpat) with the fetched data.
      • MyGrid_RowDataBound (Commented Sub): This commented-out event handler indicates that a GridView named MyGrid was perhaps used previously on this dashboard for displaying election-related data, but it's now removed or replaced.

EVM

• EVMUnitWiseSummary--viewEVM
  • Files: viewEVM.aspx, viewEVM.aspx.vb
  • Purpose: Displays a summary of EVM unit availability (Control Units, Ballot Units, VVPAT Units) across districts, including a chart visualization and a detailed grid view, with an option to export to Excel.
  • google.charts -- getChartData function
  • AsyncPostBackTrigger
  • gridview aspSa

    GridView with existing_grid id
    GetEVMSummaryDataTable binds data from db to grid
    

  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title ("EVM Unit Wise Summary").
      • hdnLangCode (HiddenField): Stores the current language code for JavaScript use.
      • dvList (Div): Container for the chart and grid.
      • lineChart (Div): HTML container for the Google Column Chart.
      • existing_grid (GridView):
        • Displays "District Name", "CU Units", "BU Units", and "VVPAT Units".
        • ShowFooter="true" is set, indicating a potential total row (though not explicitly shown in data binding logic).
        • OnRowDataBound colors rows based on District_Code ("9998" for LightPink, "9999" for LightGray and bold), likely for special/summary rows.
      • lbl_error, lblStatus (Labels): For displaying messages.
      • uprog1 (UpdateProgress): Preloader.
      • btnExport (Button): "Export to Excel" button.
      • cancel_button (Button): Resets the page.
      • panel1 (UpdatePanel): Encloses content for AJAX.
    • Client-Side (JavaScript):
      • Includes Google Charts loader (loaderGoogle.js).
      • $(".preloader").fadeOut();: Hides preloader on page load.
      • google.charts.load, google.charts.setOnLoadCallback(drawVisualizationNew): Loads Google Charts and calls drawVisualizationNew.
      • drawVisualizationNew():
        • Retrieves language code from hdnLangCode.
        • Makes an AJAX call ($.ajax) to the viewEVM.aspx/getChartData WebMethod to fetch chart data.
        • On success, parses the JSON data.
        • Creates a google.visualization.DataTable.
        • Adds columns based on language (hi-IN or English).
        • Iterates through the fetched jsonData to add rows to the DataTable (place, CuVal, BuVal, Vvpat).
        • Creates a google.visualization.BarChart (or ComboChart in commented code) in the lineChart div.
        • Sets chart options (title, axis labels, gridlines, view window, series type).
    • Server-Side (VB.NET - viewEVM.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For database access.
      • ErmsInterface.hbInterface, ErmsBLL: For data access (SELECTData).
      • Page_Load event:
        • Retrieves userName, dis_code, userLevel from Session.
        • Sets hdnLangCode.Value.
        • Sets lblTitle text.
        • On initial load:
          • Calls objCommonFunctions.GetEVMSummaryDataTable() to fetch the summary data.
          • Binds the returned DataTable to existing_grid.
          • Manages visibility of existing_grid, lbl_error, and btnExport based on data availability.
      • cancel_button_Click event: Redirects to viewEVM.aspx.
      • existing_grid_RowDataBound event:
        • Sets BackColor and Font.Bold for specific rows in the grid based on District_Code ("9998" and "9999"). This is likely used to highlight summary or special rows.
      • getChartData() (WebMethod - Public Shared Function):
        • This is the WebMethod called by client-side JavaScript for the chart data.
        • Retrieves lang and dis from HttpContext.Current.Session.
        • Creates a SqlClient.SqlCommand and sets parameters (@lang, @dis, @chartFor="BB" - Note: @chartFor="BB" seems incorrect for EVM data, it should likely be "EVM" or similar. This could be a bug or a shared stored procedure.).
        • Calls MyInterface.SELECTData(MyCommand, "GetChartData") to retrieve chart data from the database.
        • Converts the DataTable to a JSON string using obj.getJsonStringofTable(mytable) for client-side consumption.
      • ExportExcel (Protected Sub):
        • Creates a DataTable named "EVM_Summary".
        • Adds columns based on existing_grid headers.
        • Iterates through existing_grid rows to extract data from labels (lblDisName, lblCU, lblBU, lblTotalUnits) and populates the DataTable.
        • Uses ClosedXML.Excel to generate and download an Excel report named "EvmReport.xlsx".
• EVMUnitList--viewLocation
  • Files: viewLocation.aspx, viewLocation.aspx.vb
  • Purpose: Displays a list of EVM units by location and allows viewing their location on a Google Map.
  • Key Components:
    • ASP.NET Controls:
      • rbUnitType (RadioButtonList): Allows selection of unit types, auto-posts back on selection change.
      • existing_grid (GridView): Displays unit data, including "Item SrNo", "Current Location", and "View On Map".
      • lbl_error, lblStatus, lblTitle, lblNoRow (Labels): For displaying messages and titles.
      • btnShow (Button): "View All" button to trigger map data display.
      • btnCancel (Button): "Cancel" button to navigate back.
      • panel1 (UpdatePanel): Encloses the form and grid, enabling partial page updates.
      • rptMarkers (Repeater): Used to generate JavaScript array of markers for Google Maps.
      • dvList (Div): Container for the existing_grid.
      • dvMap, dvMapModal (Divs): Containers for Google Maps.
      • myMapModal (Modal): Bootstrap modal to display a larger map view.
    • Client-Side (JavaScript):
      • Includes Google Maps API (https://maps.googleapis.com/maps/api/js).
      • markers JavaScript array populated by rptMarkers (Latitude, Longitude, SrNo).
      • window.onload function: Initializes the main map (dvMap) with markers from markers array.
      • showMapModal(lat, lng) function: Initializes a new Google Map within the myMapModal at the specified latitude and longitude when a "View on Map" link in the grid is clicked.
      • jQuery/DataTables initialization for existing_grid.
      • Preloader fade-out.
    • Server-Side (VB.NET - viewLocation.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: Used for database interactions.
      • Page_Load event:
        • Handles caching.
        • Retrieves session variables (UserID, gblDistrictCode, etc.).
        • Determines dis_code and wh_code based on userLevel.
        • Calls objCommonFunctions.PopulateUnitTypes(rbUnitType) on initial load.
        • Calls rbUnitType_SelectedIndexChanged on initial load.
      • rbUnitType_SelectedIndexChanged event:
        • Re-determines dis_code and wh_code based on userLevel (duplicate logic, could be refactored).
        • Calls objCommonFunctions.getEVMLocationList(rbUnitType.SelectedValue, dis_code, wh_code) to fetch data.
        • Binds the returned DataTable to existing_grid.
        • Stores the DataTable in Session("mapData").
        • Handles empty data results by displaying lbl_error.
      • btnShow_Click event:
        • Retrieves Session("mapData").
        • Filters the DataTable to include only rows with valid Latitude values.
        • Binds the filtered data to rptMarkers to update the map markers.
        • Displays an alert if no data is found for the map.
• UpdateConsumtion--StationeryStockConsume
  • Files: StationeryStockConsume.aspx, StationeryStockConsume.aspx.vb
  • Purpose: Allows users to consume stationery stock, including specifying quantities and serial number ranges for certain item types.
  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title.
      • dvPri (Div), lblElectionFor (Label), rbPriPost (RadioButtonList): For selecting Election Type.
      • rbUnitType (DropDownList): For selecting Stationery Unit Type (e.g., EVM, Ballot).
      • DV (Div), rbBallotBoxStationery (RadioButtonList): Visible only when rbUnitType is "BALLOT", for selecting specific Ballot Box stationery.
      • lblDis, ddlDis (Label, DropDownList): District information (conditionally visible/enabled based on user level).
      • dvList (Div): Container for the existing_grid.
      • existing_grid (GridView):
        • Displays "Item Name", "Item Description", "Available Stock".
        • Includes editable TextBox columns for "New Received Stock", "From Sr. No.", and "To Sr. No.".
        • OnRowCommand and OnRowDeleting events defined (though OnRowCommand is empty in provided code, and OnRowDeleting is not implemented).
        • OnRowDataBound handles visibility of Sr. No. columns and adds AsyncPostBackTrigger for textboxes.
      • lbl_error, lblStatus (Labels): For displaying error and success messages.
      • uprog1 (UpdateProgress): Shows preloader during async postbacks.
      • save_button, cancel_button (Buttons): For saving data and canceling.
      • panel1 (UpdatePanel): Encloses most of the content, with triggers for radio buttons and buttons.
    • Client-Side (JavaScript):
      • Includes DataTables (datatables.min.js).
      • pageLoad() and initializeDataTable() functions: Re-initializes DataTables after partial postbacks to ensure proper functionality.
      • Preloader fade-out.
    • Server-Side (VB.NET - StationeryStockConsume.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For data access and common operations.
      • LoginUser (UserData object): Stores session user information.
      • Page_Load event:
        • Handles caching.
        • Retrieves LoginUser data and myLang.
        • Sets lblTitle text.
        • On initial load:
          • Populates rbPriPost (Election Type) and rbUnitType (Stationery Type).
          • Sets default selected index for rbPriPost and rbUnitType.
          • Populates ddlDis based on LoginUser.UserLevel.
          • Calls objCommonFunctions.PopulateStationeryAvailableDataTable to fetch initial data for the grid.
          • Binds data to existing_grid and handles empty data.
      • save_button_Click event:
        • Creates a DataTable (tbl_StationeryMapping) to hold consumed stationery details.
        • Iterates through existing_grid rows to collect UnitID, AllotedQuantity, FromSrNo, ToSrNo from user input.
        • Calls dbconnect.UpdateStationeryStock to save the data to the database.
        • Handles success/failure messages and re-binds the grid after a successful update.
        • Note on validation: The commented-out code for From Sr.No., To Sr.No., and qty.Text validation suggests an intended validation logic that is currently disabled.
      • cancel_button_Click event: Redirects to the same page, effectively resetting the form.
      • rbPriPost_SelectedIndexChanged event:
        • Re-populates rbUnitType based on the selected Election Type.
        • Clears and re-binds existing_grid with updated data based on the new selections.
        • Manages visibility of DV (BallotBoxStationery section).
      • rbUnitType_SelectedIndexChanged event:
        • Clears and re-binds existing_grid.
        • If rbUnitType.SelectedValue is "BALLOT":
          • Filters MyTable to group by ItemName and ItemSpecification.
          • Populates rbBallotBoxStationery with these filtered values.
          • Calls fillgrid_ballot() to display specific ballot stationery.
          • Sets DV.Visible = True.
        • Otherwise, sets DV.Visible = False.
      • MessageBox (Private Sub): A helper function to display client-side JavaScript alerts.
      • existing_grid_RowCommand (Empty Sub): A placeholder for potential future command handling.
      • rbBallotBoxStationery_SelectedIndexChanged event: Calls fillgrid_ballot().
      • fillgrid_ballot() (Protected Sub): Filters MyTable based on rbBallotBoxStationery.SelectedValue and binds the result to existing_grid.
      • existing_grid_RowDeleting (Empty Sub): A placeholder for potential future row deletion handling.
      • existing_grid_RowDataBound event:
        • Sets visibility of columns 4 and 5 (Sr. No. related) based on rbUnitType.SelectedValue.
        • Adds AsyncPostBackTrigger for lblFromSrNo and lblItemCounts textboxes within the grid to enable partial updates on text changes.
        • Calculates unitCounts (appears to be a running total, though lblCnt is always empty).
      • lblFromSrNo_TextChanged, lblItemCounts_TextChanged events:
        • Call UpdateToSrNo to automatically calculate To Sr. No. based on From Sr. No. and New Received Stock.
      • UpdateToSrNo (Private Sub):
        • Calculates To Sr. No. based on From Sr. No. and New Received Stock.
        • Handles potential errors during conversion.
• MarkDisposed--StationeryStockDispose
  • Files: StationeryStockDispose.aspx, StationeryStockDispose.aspx.vb
  • Purpose: Allows users to mark stationery stock as disposed, including specifying quantities and serial number ranges, and remarks for disposal.
  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title.
      • dvPri (Div), lblElectionFor (Label), rbPriPost (RadioButtonList): For selecting Election Type.
      • rbUnitType (DropDownList): For selecting Stationery Unit Type (e.g., EVM, Ballot).
      • DV (Div), rbBallotBoxStationery (RadioButtonList): Visible only when rbUnitType is "BALLOT", for selecting specific Ballot Box stationery.
      • lblDis, ddlDis (Label, DropDownList): District information (conditionally visible/enabled based on user level).
      • dvList (Div): Container for the existing_grid.
      • existing_grid (GridView):
        • Displays "Item Name", "Item Description", "Available Stock".
        • Includes editable TextBox columns for "New Received Stock", "From Sr. No.", "To Sr. No.", and "Remarks".
        • OnRowCommand and OnRowDeleting events defined (empty implementations in provided code).
        • OnRowDataBound handles visibility of Sr. No. columns and adds AsyncPostBackTrigger for textboxes.
      • lbl_error, lblStatus (Labels): For displaying error and success messages.
      • uprog1 (UpdateProgress): Shows preloader during async postbacks.
      • save_button, cancel_button (Buttons): For saving data and canceling.
      • panel1 (UpdatePanel): Encloses most of the content, with triggers for radio buttons and buttons.
    • Client-Side (JavaScript):
      • Includes DataTables (datatables.min.js).
      • pageLoad() and initializeDataTable() functions: Re-initializes DataTables after partial postbacks.
      • Preloader fade-out.
    • Server-Side (VB.NET - StationeryStockDispose.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For data access and common operations.
      • LoginUser (UserData object): Stores session user information.
      • Page_Load event:
        • Handles caching.
        • Retrieves LoginUser data and myLang.
        • Sets lblTitle text.
        • On initial load, populates dropdowns (rbPriPost, rbUnitType, ddlDis) and existing_grid with available stationery data.
      • save_button_Click event:
        • Creates a DataTable (tbl_StationeryMapping) to collect disposal details.
        • Iterates through existing_grid rows to get UnitID, AllotedQuantity (disposed quantity), FromSrNo, ToSrNo, and remarks.
        • Includes validation: Checks if remarks is empty when AllotedQuantity is greater than 0, displaying an alert if so.
        • Calls dbconnect.UpdateStationeryStock (with True for IsConsume and False for IsReceive, implying disposal logic) to update the database.
        • Handles success/failure messages and re-binds the grid.
      • cancel_button_Click event: Redirects to the same page.
      • rbPriPost_SelectedIndexChanged event: Updates rbUnitType and existing_grid based on the selected election type.
      • rbUnitType_SelectedIndexChanged event:
        • Updates existing_grid with data for the selected stationery type.
        • If "BALLOT" is selected, populates rbBallotBoxStationery and calls fillgrid_ballot().
      • MessageBox (Private Sub): Client-side alert helper.
      • existing_grid_RowCommand (Empty Sub): Placeholder.
      • rbBallotBoxStationery_SelectedIndexChanged event: Calls fillgrid_ballot().
      • fillgrid_ballot() (Protected Sub): Filters and binds grid data for ballot box stationery.
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • existing_grid_RowDataBound event:
        • Controls visibility of "From Sr. No.", "To Sr. No." columns based on stationery type.
        • Adds AsyncPostBackTrigger for lblFromSrNo and lblItemCounts textboxes.
      • lblFromSrNo_TextChanged, lblItemCounts_TextChanged events: Call UpdateToSrNo.
      • CustomValidator1_ServerValidate (Protected Sub): Performs server-side validation to ensure remarks are provided if a quantity is entered.
      • UpdateToSrNo (Private Sub): Calculates To Sr. No. based on From Sr. No. and New Received Stock.
• Summary--StationeryStockSummary
  • Files: StationeryStockSummary.aspx, StationeryStockSummary.aspx.vb
  • Purpose: Provides a summary view of stationery stock, including entered, allocated, consumed, disposed, and available quantities. Allows filtering by election type, stationery type, district, and block, and offers an export to Excel option.
  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title.
      • dvPri, lblElectionFor, rbPriPost (Div, Label, RadioButtonList): For selecting Election Type.
      • rbUnitType (DropDownList): For selecting Stationery Unit Type.
      • DV, rbBallotBoxStationery (Div, RadioButtonList): For specific Ballot Box stationery (conditionally visible).
      • lblDis, ddlDis (Label, DropDownList): For selecting District. AutoPostBack enabled.
      • dvBlock, lblBlk, ddlBlk (Div, Label, DropDownList): For selecting Block (conditionally visible based on user level and election type). AutoPostBack enabled.
      • dvList (Div): Container for existing_grid.
      • existing_grid (GridView):
        • Displays various stock metrics: "Item Name", "Item Description", "MyEnteredStock", "AllocatedToMe", "MyTotalStock", "AllocatedToOthers", "TotalConsumed", "Disposed", "AvailableForAllocation".
        • Header styles applied.
        • OnRowCommand and OnRowDeleting events defined (empty implementations in provided code).
      • lbl_error, lblStatus (Labels): For messages.
      • uprog1 (UpdateProgress): Shows preloader.
      • btnExport (Button): "Export to Excel" button.
      • cancel_button (Button): "Cancel" button.
      • panel1 (UpdatePanel): Encloses controls for partial postbacks.
    • Client-Side (JavaScript):
      • Includes DataTables (datatables.min.js).
      • pageLoad() and initializeDataTable() functions: Ensures DataTables re-initialization after AJAX updates.
      • Preloader fade-out.
    • Server-Side (VB.NET - StationeryStockSummary.aspx.vb):
      • Inherits SetCulture.
      • Uses commonFunctions and ClosedXML.Excel for Excel export.
      • LoginUser (UserData object): Stores session user information.
      • Page_Load event:
        • Handles caching.
        • Retrieves session variables and LoginUser data.
        • Sets lblTitle text.
        • On initial load: Populates rbPriPost (Election Type) and calls rbPriPost_SelectedIndexChanged to cascade loading.
      • fill_grid() (Private Sub):
        • Determines the user (stock owner code) and is_self flag based on ddlDis and ddlBlk selections and LoginUser.UserLevel.
        • Calls objCommonFunctions.GetStationeryStockSummary to fetch the summary data.
        • Binds the returned List(Of StockItem.StockSummary) to existing_grid.
        • Handles empty data.
      • cancel_button_Click event: Redirects to the same page.
      • rbPriPost_SelectedIndexChanged event:
        • Populates rbUnitType based on the selected Election Type.
        • Calls rbUnitType_SelectedIndexChanged to cascade loading.
      • rbUnitType_SelectedIndexChanged event:
        • Populates ddlDis (District) based on user level, setting the default to the user's district if applicable.
        • Calls ddlDis_SelectedIndexChanged to cascade loading.
      • ddlDis_SelectedIndexChanged event:
        • Determines lblBlk.Text (Block/ULB/MC) based on rbPriPost.SelectedValue.
        • Populates ddlBlk (Block) based on the selected District and Election Type.
        • Handles enabling/disabling ddlDis and ddlBlk based on LoginUser.UserLevel.
        • Calls ddlBlk_SelectedIndexChanged to cascade loading.
        • Calls fill_grid().
      • ddlBlk_SelectedIndexChanged event: Calls fill_grid().
      • MessageBox (Private Sub): Client-side alert helper.
      • existing_grid_RowCommand (Empty Sub): Placeholder.
      • rbBallotBoxStationery_SelectedIndexChanged event: Calls fillgrid_ballot().
      • fillgrid_ballot() (Protected Sub): Filters grid data for ballot box stationery when rbUnitType is "BALLOT".
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • existing_grid_RowDataBound event: (Commented out in provided code, suggesting it's not actively used or was for previous versions of the grid. It previously tried to add async triggers and calculate unitCounts.)
      • lblFromSrNo_TextChanged, UpdateToSrNo (Private Subs): These functions are present but seem to be remnants from a page with editable Sr. No. fields (like StationeryStockConsume or StationeryStockDispose). In a summary page, these would typically not be relevant as data is displayed, not edited. lblItemCounts_TextChanged is commented out.
      • ExportExcel (Protected Sub):
        • Creates a DataTable from the existing_grid data.
        • Uses ClosedXML.Excel to create an Excel workbook from the DataTable.
        • Sets response headers for Excel download and streams the workbook to the client.
• Add/ModifyItems--updateStationeryMasters
  • Files: updateStationeryMasters.aspx, updateStationeryMasters.aspx.vb
  • Purpose: Allows an administrator (likely "000" user level) to add, edit, activate, and deactivate stationery master items.
  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title ("Update Stock").
      • dvPri, lblElectionFor, rbPriPost (Div, Label, RadioButtonList): For selecting Election Type.
      • rbUnitType (DropDownList): For selecting Stationery Unit Type.
      • DV, rbBallotBoxStationery (Div, RadioButtonList): For specific Ballot Box stationery (conditionally visible).
      • lblDis, ddlDis (Label, DropDownList): District dropdown (visible=false, enabled=false in ASPX, but code implies it's for filtering if active).
      • btn_add_new (Button): Redirects to AddNewMaster.aspx to add a new item.
      • dvList (Div): Container for existing_grid.
      • existing_grid (GridView):
        • Displays "Item Name", "Item Description", and "Actions".
        • "Actions" column includes LinkButton for "Edit", "DeActivate", and "ReActivate". The text of the activate/deactivate button changes based on the is_active field.
        • OnRowCommand handles clicks on "Edit", "DeActivate", "ReActivate" and redirects to respective pages with id as a query parameter.
        • OnRowDeleting event defined (empty implementation).
      • panel1 (UpdatePanel): Encloses most of the content.
    • Client-Side (JavaScript):
      • Includes DataTables (datatables.min.js).
      • pageLoad() and initializeDataTable() functions: Ensures DataTables re-initialization.
      • Preloader fade-out.
    • Server-Side (VB.NET - updateStationeryMasters.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For data access.
      • LoginData (UserData object): Stores session user information.
      • Page_Load event:
        • Handles caching.
        • Retrieves LoginData and myLang.
        • Sets lblTitle text.
        • On initial load: Populates rbPriPost (Election Type) and calls rbPriPost_SelectedIndexChanged.
      • fillgrid() (Private Sub):
        • Checks LoginData.UserLevel. If "000" (likely admin), it populates existing_grid with all available stationery master data.
        • If rbUnitType.SelectedValue is "BALLOT", it groups the data to populate rbBallotBoxStationery and then calls fillgrid_ballot().
        • If not "000", the grid is cleared.
      • rbPriPost_SelectedIndexChanged event:
        • Populates rbUnitType based on selected election type.
        • Calls rbUnitType_SelectedIndexChanged to trigger grid fill.
      • rbUnitType_SelectedIndexChanged event: Calls fillgrid().
      • MessageBox (Private Sub): Client-side alert helper.
      • rbBallotBoxStationery_SelectedIndexChanged event: Calls fillgrid_ballot().
      • fillgrid_ballot() (Protected Sub): Filters MyTable by ItemSpecification from rbBallotBoxStationery.SelectedValue and binds to existing_grid. Sets DV.Visible = True.
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • existing_grid_RowDataBound (Empty Sub): Placeholder.
      • btn_add_new_Click event: Redirects to AddNewMaster.aspx with query parameters from current selections.
      • existing_grid_RowCommand event:
        • Handles "Edit" command: Redirects to EditMaster.aspx with id and rbBallotBoxStationery as query parameters.
        • Handles "DeActivate" command: Redirects to DeactivateMaster.aspx with id.
        • Handles "ReActivate" command: Redirects to ReactivateMaster.aspx with id.

BallotBox

• MyBallotBox--addBallotBox
  • Files: addBallotBox.aspx, addBallotBox.aspx.vb
  • Purpose: Allows users to add new Ballot Boxes to the inventory, specifying series, model (size), purchase date, count, and serial number range. Also displays a list of existing Ballot Boxes and provides options to delete them or view generated QR codes.
  • Related Fixes/Notes: "[CLOSED] 3. Add BallotBox Line 105 requres as commint . what will be reason (PARAMJEET)? -No-" (This note likely refers to a comment that was needed or removed around line 105 in a previous version of the code, possibly related to the save_button_Click logic).
  • Key Components:
    • ASP.NET Controls (Input Form - formNom):
      • lblTitle (Label): Page title ("Add Ballot").
      • ddlSeries (DropDownList): For selecting Ballot Box Series. AutoPostBack enabled.
      • ddlModel (DropDownList): For selecting Ballot Box Model/Size.
      • ddlMon, ddlYr (DropDownLists): For selecting Month and Year of Purchase.
      • txtUnitCounts (TextBox): For entering the number of units. Includes RegularExpressionValidator for numbers.
      • txtFromSrNo (TextBox): For entering the starting serial number. AutoPostBack enabled. Includes RegularExpressionValidator.
      • txtToSrNo (TextBox): Displays the calculated ending serial number (read-only).
      • txtUnitID (Label - hidden): Likely used to store an ID for updates (though the current flow is for adding).
      • lbl_error, lblStatus (Labels): For displaying messages.
      • uprog1 (UpdateProgress): Shows preloader.
      • save_button (Button): Saves the new Ballot Box entries.
      • cancel_button (Button - partially commented out in ASPX): Likely intended for resetting the form or navigating back.
    • ASP.NET Controls (List View - dvList):
      • existing_grid (GridView):
        • Displays details of existing Ballot Boxes: "Series Name", "Size", "Mon-Year of Purchase", "No. of Ballot Boxes", "Sr. No. Range".
        • DataKeyNames set to from_sr_no, to_sr_no, series, box_size for row command arguments.
        • Includes a "Delete" LinkButton (hidden header, visible item template) with OnClientClick for confirmation.
        • Includes a "View QR" Button that triggers a ShowQR command.
      • cancel_button (Button - present in dvList): Allows navigating back.
    • Client-Side (JavaScript):
      • Includes jQuery and DataTables.
      • calculateToSrNo(): JavaScript function that calculates txtToSrNo based on txtFromSrNo and txtUnitCounts on input change.
      • confirmDelete(): JavaScript function for delete confirmation.
      • pageLoad() and initializeDataTable(): Ensures DataTables re-initialization after AJAX updates.
    • Server-Side (VB.NET - addBallotBox.aspx.vb):
      • Inherits System.Web.UI.Page.
      • commonFunctions object: For database interactions.
      • user (UserData object): Stores session user information.
      • list_ (List(Of Ballot.Ballot_Series)): Stores Ballot Series master data, persisted in ViewState.
      • Page_Load event:
        • Retrieves user and session data.
        • Sets lblTitle text.
        • On initial load:
          • Calls objCommonFunctions.Ballot_Series_Master_Get() to get series data.
          • Populates ddlSeries and stores the data in ViewState("BallotSeriesList").
          • Calls ddlSeries_SelectedIndexChanged to populate related dropdowns.
          • Calls fill_grid() to display existing Ballot Boxes.
        • On postbacks, retrieves list_ from ViewState.
      • ddlSeries_SelectedIndexChanged event:
        • Retrieves selected series data from list_ (from ViewState).
        • Populates ddlModel, ddlMon, ddlYr with corresponding values from the selected series.
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • save_button_Click event:
        • Performs validation on input fields (ddlModel, txtUnitCounts, ddlSeries, ddlMon, ddlYr).
        • If validation passes, calls DBAccess.UpdateBallotBoxStock to save the new Ballot Box entry. (Note: The UpdateBallotBoxStock method is used for adding, indicated by the last parameter 1).
        • Clears input fields and displays success/error messages. Sets focus to txtFromSrNo on "Invalid Sr No" error.
      • cancel_button_Click event: Redirects to addBallotBox.aspx, effectively resetting the page.
      • MessageBox (Private Sub): Client-side alert helper.
      • existing_grid_RowDataBound (Commented out code): This section contains commented-out logic that would have manipulated cell visibility and text, and handled QR button visibility based on QR_Generated status. It seems this functionality might have been moved or refactored.
      • existing_grid_RowCommand event:
        • Handles "delete" command: Calls DBAccess.deleteBallotMaster using DataKeys (from_sr_no, to_sr_no, series, box_size) and re-fills the grid.
        • Handles "ShowQR" command:
          • Calls DBAccess.Show_Ballot_ByID to retrieve QR data.
          • Generates QR codes as images (objCommonFunctions.getQRCODE) and constructs HTML for printing.
          • Stores the HTML in Session("strText") and redirects to printForm.aspx to display/print QR codes.
      • fill_grid() (Private Sub):
        • Calls objCommonFunctions.Show_Ballot_Owner to get a list of Ballot_Stock_Owner objects.
        • Binds the list to existing_grid to display current Ballot Boxes.
• Allocate--BallotBoxAllocation
  • Files: BallotBoxAllocation.aspx, BallotBoxAllocation.aspx.vb
  • Purpose: Enables the allocation and de-allocation of Ballot Boxes to different administrative levels (District, Block, Political Party) by users with appropriate permissions.
  • Key Components:
    • ASP.NET Controls (Filter/Selection):
      • lblTitle (Label): Page title ("Ballot Box Allocation").
      • div_state, lblState, ddlState (Div, Label, DropDownList): For selecting State. AutoPostBack.
      • div_district, lblDis, ddlDis (Div, Label, DropDownList): For selecting District. Conditionally visible. AutoPostBack.
      • div_block, lblBlk, ddlBlk (Div, Label, DropDownList): For selecting Block. Conditionally visible. AutoPostBack.
      • div_Polparty, lblPolparty, ddlPolparty (Div, Label, DropDownList): For selecting Political Party. Conditionally visible. AutoPostBack.
    • ASP.NET Controls (Grids):
      • existing_grid (GridView - Left side): Displays "No Ballot Box For Allocation".
        • Shows qr_text_description.
        • Includes an "Allocate" Button with CommandName="AllocateQR".
        • DataKeyNames set to qr_text_description, to_user_id, from_user_id, is_received.
      • existing_grid1 (GridView - Right side): Displays "No Ballot Box Alloted".
        • Shows qr_text_description.
        • Includes a "Received" Button (visible if is_received is true) and a "De-Allocate" Button (visible if is_received is false).
        • DataKeyNames are the same as existing_grid.
    • ASP.NET Controls (Messages/Actions):
      • lbl_error, lblStatus (Labels): For messages.
      • uprog1 (UpdateProgress): Preloader.
      • save_button (Button - hidden): Remains from other pages, not actively used in this allocation context.
      • cancel_button (Button): Resets the page.
      • panel1 (UpdatePanel): Encloses content for AJAX.
    • Client-Side (JavaScript):
      • Includes DataTables.
      • pageLoad() and initializeDataTable(), initialize1DataTable(): Ensures DataTables re-initialization for both grids.
      • Preloader fade-out.
    • Server-Side (VB.NET - BallotBoxAllocation.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For database.
      • user (UserData object): Current logged-in user.
      • Page_Load event:
        • Handles caching.
        • Retrieves user and myLang.
        • Sets lblTitle text.
        • On initial load: Populates ddlState and calls ddlState_SelectedIndexChanged.
      • save_button_Click (Handles a hidden button, contains commented-out or old logic for generic stationery update, not specific to this page's QR allocation). This method's logic doesn't seem to be used for the allocate/de-allocate actions.
      • cancel_button_Click event: Redirects to BallotBoxAllocation.aspx.
      • ddlState_SelectedIndexChanged event:
        • Populates ddlDis (District) based on the selected state.
        • Sets ddlState.Enabled based on user.UserLevel.
        • Sets ddlDis to the user's district if applicable.
        • Calls ddlDis_SelectedIndexChanged.
        • Hides other dropdowns if no districts are found.
      • ddlDis_SelectedIndexChanged event:
        • If the selected district matches the user's district, populates ddlBlk (Block).
        • Sets ddlBlk to the user's block if applicable.
        • Calls ddlBlk_SelectedIndexChanged.
        • Hides other dropdowns if no blocks are found.
        • Calls FillGrid(ddlDis) if no blocks found or if ddlDis is the primary filter.
      • ddlBlk_SelectedIndexChanged event:
        • Logic varies based on user.UserLevel:
          • "000" (State): Calls FillGrid(ddlDis). Hides block.
          • "001", "006" (District): Calls FillGrid(ddlBlk).
          • "002", "003" (Block): Populates ddlPolparty if the selected block is the user's block. Otherwise, hides political party dropdown.
        • Calls FillGrid(sender) (or specific dropdown) to update grids.
      • ddlPolparty_SelectedIndexChanged event: Calls FillGrid(sender).
      • existing_grid_RowCommand event (for existing_grid - left grid):
        • Handles "AllocateQR" command: Extracts qrTextDescription and to_user_id from CommandArgument.
        • Calls UpdateData(qrTextDescription, qr_to_user, 3) (action 3 likely means allocate).
      • existing_grid1_RowCommand event (for existing_grid1 - right grid):
        • Handles "DeAllocateQR" command: Extracts qrTextDescription and to_user_id.
        • Calls UpdateData(qrTextDescription, qr_to_user, 4) (action 4 likely means de-allocate).
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • existing_grid_RowDataBound (Empty Sub): Placeholder.
      • FillGrid(_picker As DropDownList, Optional _value As String = "") (Public Sub):
        • Fetches available Ballot Boxes (Show_Ballot_User_Id with "from" type) and binds to existing_grid.
        • Fetches allocated Ballot Boxes (Show_Ballot_User_Id with "to" type) and binds to existing_grid1.
      • UpdateData(qrTextDescription As String, qr_to_user As String, action As Int16) (Private Sub):
        • Calls DBAccess.UpdateBallotBoxStock to perform the actual allocation/de-allocation in the database.
        • Re-fills the grids after the update.
• UnitSummary--viewBallotBox
  • Files: viewBallotBox.aspx, viewBallotBox.aspx.vb
  • Purpose: Displays a summary of Ballot Box distribution, including a chart visualization and a detailed grid view, with an option to export to Excel.
  • Potential Issue: Invalid column name 'to_location_id'. (As noted previously, this suggests a database schema mismatch or a typo in the underlying stored procedure or data access for viewBallotBox that has not been directly addressed in the provided code snippets.)
  • Key Components:
    • ASP.NET Controls:
      • lblTitle (Label): Page title ("Ballot Box Summary").
      • hdnLangCode (HiddenField): Stores the current language code for JavaScript use.
      • dvList (Div): Container for the chart and grid.
      • lineChart (Div): HTML container for the Google Column Chart.
      • existing_grid (GridView):
        • Displays "Available At" (DisplayName) and "No. of Ballot Boxes" (NoOf_Units).
        • ShowFooter="true" implies a total row, though the data binding might handle it implicitly.
        • OnRowDataBound colors rows based on to_user_code ("9998" for LightPink, "9999" for LightGray and bold).
      • lbl_error, lblStatus (Labels): For messages.
      • uprog1 (UpdateProgress): Preloader.
      • btnExport (Button): "Export to Excel" button.
      • cancel_button (Button): Resets the page.
      • panel1 (UpdatePanel): Encloses content for AJAX.
    • Client-Side (JavaScript):
      • Includes Google Charts loader (loaderGoogle.js).
      • $(".preloader").fadeOut();: Hides preloader on page load.
      • google.charts.load, google.charts.setOnLoadCallback(drawVisualizationNew): Loads Google Charts and calls the drawVisualizationNew function.
      • drawVisualizationNew():
        • Retrieves language code from hdnLangCode.
        • Creates a google.visualization.DataTable.
        • Adds columns based on language.
        • Iterates through existing_grid tbody rows (skipping header and the very first data row - index === 1 means it skips the row that is typically a "Total" or special row, or simply starts from the second data row) to extract "Place" and "Ballot Box Count".
        • Creates a google.visualization.ColumnChart in lineChart div using the extracted data.
        • Sets chart options (title, axis labels, text rotation, font size, min value, no legend).
    • Server-Side (VB.NET - viewBallotBox.aspx.vb):
      • Inherits SetCulture.
      • user (UserData object): Current logged-in user.
      • commonFunctions object: For database access.
      • ErmsInterface.hbInterface, ErmsBLL: For data access (SELECTData).
      • Page_Load event:
        • Retrieves user and session data (UserID, gblDistrictCode, UserLevel, MyLanguage).
        • Sets hdnLangCode.Value.
        • Sets lblTitle text.
        • On initial load:
          • Calls objCommonFunctions.getBallotBoxListSummary_Category_Wise(user.Code) to fetch summary data.
          • Binds the returned List(Of Ballot.BallotSummary) to existing_grid.
          • Manages visibility of existing_grid, lbl_error, and btnExport based on data availability.
      • cancel_button_Click event: Redirects to viewBallotBox.aspx.
      • existing_grid_RowDataBound event:
        • Sets BackColor and Font.Bold for specific rows in the grid based on to_user_code ("9998" and "9999"). This is likely used to highlight summary or special rows.
      • getChartData() (WebMethod - Public Shared Function):
        • This function is a WebMethod, meaning it can be called directly from client-side JavaScript via AJAX.
        • Retrieves lang and dis from HttpContext.Current.Session.
        • Creates a SqlClient.SqlCommand and sets parameters (@lang, @dis, @chartFor="BB").
        • Calls MyInterface.SELECTData(MyCommand, "GetChartData") to retrieve chart data from the database.
        • Converts the DataTable to a JSON string using obj.getJsonStringofTable(mytable) for client-side consumption.
        • Note: The drawVisualizationNew JavaScript in the ASPX doesn't call this WebMethod. It appears to render the chart directly from the existing_grid's already bound data. This getChartData WebMethod might be a remnant or intended for a different use case (e.g., initial chart load via AJAX without a full postback to bind the grid).
      • ExportExcel (Protected Sub):
        • Creates a DataTable from the existing_grid's data.
        • Uses ClosedXML.Excel to generate an Excel file.
        • Sets response headers and streams the Excel file for download.
• UnitTest--viewBallotBoxList
  • Files: viewBallotBoxList.aspx, viewBallotBoxList.aspx.vb
  • Purpose: Displays a detailed list of individual Ballot Boxes, their current locations, and provides options to view QR codes and view their location on a map. Allows filtering by district and block.
  • Potential Issue: Invalid column name 'to_location_id'. (This error is explicitly mentioned in the initial prompt and likely applies to the data retrieval for this page, specifically to the getBallotBoxListSummary_Unit_Wise method or its underlying query.)
  • Key Components:
    • ASP.NET Controls (Filter/Selection):
      • lblTitle (Label): Page title ("Ballot Box Unit List").
      • lblDis, ddlDis (Label, DropDownList): For selecting District. AutoPostBack enabled.
      • dvBlock, lblBlk, ddlBlk (Div, Label, DropDownList): For selecting Block. Conditionally visible. AutoPostBack enabled.
    • ASP.NET Controls (Grid/Actions):
      • lbl_error, lblStatus (Labels): For messages.
      • uprog1 (UpdateProgress): Preloader.
      • dvList (Div): Container for existing_grid.
      • existing_grid (GridView):
        • Displays "Item Description" (qrtext) and "Item Location" (DisplayName).
        • Includes a HyperLink to viewBBonMap.aspx (for viewing on map), enabled only if latitude is valid.
        • Includes a "View QR" Button with CommandName="ShowQR".
      • btnExport (Button): "Export to Excel" button.
      • map_button (Button): "View All On Map" button, redirects to viewBBonMap.aspx with selected district/block.
      • cancel_button (Button): Resets the page.
      • panel1 (UpdatePanel): Encloses content for AJAX.
    • Client-Side (JavaScript):
      • Includes DataTables.
      • pageLoad() and initializeDataTable(): Ensures DataTables re-initialization.
      • Preloader fade-out.
    • Server-Side (VB.NET - viewBallotBoxList.aspx.vb):
      • Inherits SetCulture.
      • commonFunctions object: For database access.
      • LoginUser (UserData object): Current logged-in user.
      • Page_Load event:
        • Handles caching.
        • Retrieves session variables and LoginUser data.
        • Sets lblTitle text.
        • On initial load:
          • Populates ddlDis (District) and sets default/selected based on LoginUser.DistrictCode and Session variables.
          • Calls ddlDis_SelectedIndexChanged to cascade loading.
          • Calls fill_grid().
      • fill_grid() (Private Sub):
        • Determines user (code for filtering) based on ddlBlk or ddlDis selection.
        • Calls objCommonFunctions.getBallotBoxListSummary_Unit_Wise(user, "") to retrieve unit-wise summary.
        • Binds the returned List(Of BallotSummaryList) to existing_grid.
        • Manages visibility of dvList and lbl_error.
      • cancel_button_Click event: Redirects to viewBallotBoxList.aspx.
      • ddlDis_SelectedIndexChanged event:
        • Sets lblBlk.Text.
        • Populates ddlBlk (Block) based on selected district and election type "001" (likely hardcoded for Panchayat Raj institutions).
        • Handles enabling/disabling ddlDis and ddlBlk based on LoginUser.UserLevel and Session variables.
        • Calls ddlBlk_SelectedIndexChanged to cascade.
      • ddlBlk_SelectedIndexChanged event: Calls fill_grid().
      • MessageBox (Private Sub): Client-side alert helper.
      • existing_grid_RowCommand event:
        • Handles "ShowQR" command:
          • Retrieves qr_text_description from CommandArgument.
          • Generates QR code image data (objCommonFunctions.getQRCODE).
          • Constructs HTML to display the QR code.
          • Stores HTML in Session("strText") and Session("unitType").
          • Uses ScriptManager.RegisterStartupScript to open printForm.aspx in a new window.
      • map_button_Click event:
        • Stores ddlBlk.SelectedIndex and ddlDis.SelectedIndex in Session.
        • Redirects to viewBBonMap.aspx passing to_user_code from either ddlBlk or ddlDis.
      • existing_grid_RowDeleting (Empty Sub): Placeholder.
      • existing_grid_RowDataBound (Empty Sub): Placeholder.
      • ExportExcel (Protected Sub):
        • Creates a DataTable with "Item Description" and "Item Location" columns.
        • Populates the DataTable by iterating through existing_grid rows and extracting text from qr_text and Display_Name labels.
        • Uses ClosedXML.Excel to generate and download an Excel report.
• UnitList--viewBallotBoxList
  • (This entry effectively points to the same viewBallotBoxList.aspx page as UnitTest--viewBallotBoxList based on the file paths and content.)
  • Related Fixes/Notes:
    • Invalid column name 'to_location_id'. (This likely applies here as well, as it's the same underlying page/data access.)
    • "[CLOSED] 4. PrintQR page condition when there is 0 in the result of dorpdown in line 306 then what to do?" This note from the Readme.md likely refers to a scenario in this page's QR viewing/printing logic where no QR data is found or a dropdown selection for QR is empty.