From ce832a0bddc02a21d9c382f46b81dd6c114f35f9 Mon Sep 17 00:00:00 2001
From: MikunoNaka <bokuwakanojogahoshii@yahoo.com>
Date: Sat, 26 Jun 2021 03:18:55 +0530
Subject: Storing HSN as string now

---
 server/database/database.go | 2 +-
 server/database/items.go    | 4 ++--
 server/router/items.go      | 3 +--
 3 files changed, 4 insertions(+), 5 deletions(-)

(limited to 'server')

diff --git a/server/database/database.go b/server/database/database.go
index f8d9092..2339d29 100644
--- a/server/database/database.go
+++ b/server/database/database.go
@@ -23,7 +23,7 @@ func InitDB() {
     Model     TEXT NOT NULL,
     Desc      TEXT,
     UnitPrice REAL,
-    HSN       BLOB,
+    HSN       TEXT,
     TotalGST  REAL,
     Category  TEXT,
     Brand     TEXT)`,
diff --git a/server/database/items.go b/server/database/items.go
index 059f5e6..5a637cd 100644
--- a/server/database/items.go
+++ b/server/database/items.go
@@ -17,7 +17,7 @@ type Item struct {
   Model       string
   Description string
   UnitPrice   float64
-  HSN         int
+  HSN         string
   TotalGST    float64
   Category    string 
   Brand       string
@@ -32,7 +32,7 @@ func GetAllItems() []Item {
   var (
     model, desc, cat, brand string
     unitPrice, GST float64
-    HSN int
+    HSN string
   )
 
   for rows.Next() {
diff --git a/server/router/items.go b/server/router/items.go
index 684d1d8..540fdf3 100644
--- a/server/router/items.go
+++ b/server/router/items.go
@@ -25,7 +25,6 @@ func getAllItems(ctx *gin.Context) {
 func registerItem(ctx *gin.Context) {
   // extract data not string
   price, _ := strconv.ParseFloat(ctx.Query("price"), 64)
-  hsn, _ := strconv.Atoi(ctx.Query("hsn"))
   gst, _ := strconv.ParseFloat(ctx.Query("gst"), 64)
   cat := "cat coming soon"
   brand := "brand coming soon"
@@ -34,7 +33,7 @@ func registerItem(ctx *gin.Context) {
     Model:       ctx.Query("model"),
     Description: ctx.Query("desc"),
     UnitPrice:   price,
-    HSN:         hsn,
+    HSN:         ctx.Query("hsn"),
     TotalGST:    gst,
     Category:    cat,
     Brand:       brand,
-- 
cgit v1.2.3