Farmer Buddy, understood end to end.

flowchart LR
  A["Farmer Hub folder\nEarlier snapshot"] --> C["454 identical shared files"]
  B["FarmerBuddy-Design-2023\nNewer snapshot"] --> C
  A --> D["Historical SQL + reports + presentation"]
  B --> E["12 extra files\nIDE metadata + admin photos"]
  A --> F["3 changed shared files"]
  B --> F
  B --> G["Sanitized Personal Project\nGitHub-safe working copy"]
  style G fill:#78d44b,color:#07140d,stroke:#2e7d32
        

flowchart TB
  Browser["Desktop / mobile browser"] --> IIS["IIS Express or IIS"]
  IIS --> Public["Public Web Forms\nHome, registration, login"]
  IIS --> User["User area\nArticles, crops, schemes, advice"]
  IIS --> Admin["Admin area\nContent and user management"]
  Public --> CB["C# code-behind"]
  User --> CB
  Admin --> CB
  Public --> SDS["SqlDataSource controls"]
  User --> SDS
  Admin --> SDS
  CB --> ADO["System.Data.SqlClient"]
  SDS --> DB[("SQL Server\nFarmerBuddy")]
  ADO --> DB
  CB -.-> Weather["Weather API\nlegacy integration"]
  CB -.-> SMS["SMS gateway\nlegacy integration"]
        

sequenceDiagram
  actor F as Farmer
  participant P as ASPX page
  participant C as Code-behind
  participant S as SQL Server
  F->>P: Submit login / search / content form
  P->>C: Raise server-side event
  C->>C: Read controls and session
  C->>S: Execute query or command
  S-->>C: Rows / scalar / affected count
  C-->>P: Bind controls or redirect
  P-->>F: Render complete HTML response
        

flowchart LR
  Visitor["Visitor"] --> Register["Register"]
  Visitor --> Browse["View public home"]
  Register --> Login["User login"]
  Login --> Farmer["Farmer workspace"]
  Farmer --> Learn["Articles, crops, video"]
  Farmer --> Support["Schemes and insurance"]
  Farmer --> Ask["Ask expert"]
  Farmer --> Profile["Profile / password"]
  AdminLogin["Admin login"] --> Admin["Admin dashboard"]
  Admin --> Content["Manage content"]
  Admin --> Users["Verify and manage users"]
  Admin --> Answers["Answer questions"]
  Expert["Expert role"] -. "represented in data,\nnot fully separated in navigation" .-> Answers
        

erDiagram
  REGISTRATION {
    int id PK
    nvarchar username UK
    nvarchar e_mail UK
    nvarchar password
    nvarchar user_type
    bit veriefied
  }
  EXPERT_ADVICE {
    int eid PK
    nvarchar username FK
    nvarchar question
    nvarchar answer
    nvarchar status
  }
  OTP_DATA {
    bigint id PK
    nvarchar username FK
    nvarchar otp
    datetime expires_at
  }
  ARTICLE_DATA { int aid PK nvarchar article_title nvarchar authors }
  PRODUCT_DATA { int pid PK nvarchar pname decimal mrp_amount decimal sell_amount }
  GOV_SCHEME_DATA { int gid PK nvarchar schemeName decimal amount }
  CROP_INSURANCE_DATA { int cid PK nvarchar companyName nvarchar InsuranceName }
  VIDEOS_DATA { int vid PK nvarchar title nvarchar link }
  VIDEO { int id PK nvarchar title nvarchar url }
  GRAINS { int id PK nvarchar grains UK }
  TIPS_DATA { int id PK nvarchar tips }
  REGISTRATION ||--o{ EXPERT_ADVICE : asks
  REGISTRATION ||--o{ OTP_DATA : requests
        

flowchart LR
  Internet["Untrusted browser input"] --> Forms["Forms and query strings"]
  Forms --> App["Legacy Web Forms app"]
  Upload["Uploaded files"] --> App
  App --> DB[("User and content data")]
  App --> APIs["Weather / SMS providers"]
  subgraph Trust boundary
    App
    DB
  end
  R1["SQL injection"] -.-> Forms
  R2["Stored XSS"] -.-> Forms
  R3["Arbitrary file upload"] -.-> Upload
  R4["Broken access control"] -.-> App
  R5["Secret leakage"] -.-> APIs
        

flowchart LR
  Dev["Developer on Windows"] --> Script["scripts/Start-FarmerBuddy.ps1"]
  Script --> IIS["IIS Express\nlocalhost:51873"]
  IIS --> Site["D:\\Saurabh Dindokar Career\\FarmerBuddy-Personal-Project"]
  Site --> Static["Public page and assets"]
  Site -. "when installed" .-> SQL["SQL Server Express\nFarmerBuddy database"]
  Schema["database/FarmerBuddy.Schema.sql"] --> SQL
        

flowchart TB
  Web["Responsive web client\naccessible design system"] --> API["ASP.NET Core Web API"]
  API --> Auth["ASP.NET Core Identity\nroles + secure recovery"]
  API --> Services["Domain services\ncontent, advice, catalogue"]
  Services --> EF["Entity Framework Core"]
  EF --> DB[("SQL Server / PostgreSQL")]
  Services --> Files["Private object storage\nvalidated uploads"]
  Services --> Integrations["Weather + notification adapters"]
  API --> Obs["Structured logs, metrics, tracing"]
  CI["GitHub Actions"] --> Tests["Build, test, scan"]
  Tests --> Deploy["Versioned deployment"]
        

gantt
  title Farmer Buddy personal-project modernization
  dateFormat  YYYY-MM-DD
  axisFormat  %d %b
  section Foundation
  Inventory, sanitize, documentation :done, f1, 2026-08-18, 3d
  Repeatable local database           :f2, after f1, 4d
  section Security
  Identity and role authorization     :s1, after f2, 7d
  Parameterized data access           :s2, after f2, 7d
  Safe uploads and integrations       :s3, after s1, 5d
  section Product
  Repair expert advice and recovery   :p1, after s2, 5d
  Modern responsive visual system     :p2, after s3, 8d
  Content quality and accessibility   :p3, after p2, 5d
  section Delivery
  Automated tests and CI              :d1, after s2, 8d
  Container/cloud deployment option   :d2, after d1, 6d