CreateDataEntirely.sql

USE [SalesManagerDB]
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'admin2', N'$MYHASH$V1$10000$8jqLiGal7KMeSQx4+dLefHFO8Ngms7ocQnMal1rfQD3PaKTRAA==', 1, CAST(N'2023-05-12T17:01:39.257' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'bao', N'$MYHASH$V1$10000$I+5xF1SWQfu8Ikjoga8wUPMW1Msg2mKqXVpCiT8neOmN9Mq+AA==', 1, CAST(N'2023-05-12T13:28:39.347' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'binh', N'$MYHASH$V1$10000$/QsC0aASYDmu86ccU5jhFHVI1htuELsmSRm02xu0E1zPwlsuAA==', 1, CAST(N'2023-06-19T10:21:40.823' AS DateTime), N'danghoan', CAST(N'2023-06-19T10:22:00.920' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'CaoHH', N'$MYHASH$V1$10000$cjbPmtgUwJnIoecqLKghWOoU5AocoO+KjGN15UZ317Ug4nsYAA==', 11, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'VanB', CAST(N'2023-06-19T09:51:32.953' AS DateTime), N'DangHoa123', NULL, NULL, NULL)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'danghan', N'$MYHASH$V1$10000$0faWnIDFm7PqHa4fNoKnm5dTEyjpufjK68ZYar8EOcff69/jAA==', 1, CAST(N'2023-06-18T09:38:49.857' AS DateTime), N'admin2', CAST(N'2023-06-24T10:03:33.880' AS DateTime), N'danghan', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'DangHoan', N'$MYHASH$V1$10000$fm0MOD076NjWYNa20YIKm5t/eb9J44212Gxz8EUZFm/5RguCAA==', 1, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'VanB', CAST(N'2023-06-23T16:59:17.457' AS DateTime), N'DangHoan', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'hahahuhu', N'$MYHASH$V1$10000$kkKIbGHD2q2Y5TJ/NekFxPpIABlBK/MrvX9RSZ3sYsHV9UceAA==', 11, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'VanB', NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'hehe', N'$MYHASH$V1$10000$NpkiZeuri6+J/mqOnJCBSY9ZAB4beJxcykjAYEZTNKWhV4AnAA==', 11, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'hello', N'$MYHASH$V1$10000$p1tN68tfpo8uaM48LyS6HZpZ8JtxmoGgV9iicc+08tjpDYNfAA==', 1, CAST(N'2023-04-24T11:25:34.823' AS DateTime), N'vanb', CAST(N'2023-04-24T11:27:30.743' AS DateTime), N'hello', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'huyen', N'$MYHASH$V1$10000$XnPyQhbFKAs8u4cRXahmfn4QAApgFGJ6EQacL53Vr1Lg/8GGAA==', 11, CAST(N'2023-05-12T11:16:21.517' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:29:13.390' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'lala2', N'$MYHASH$V1$10000$hxja57lJWfbUl7L8JPzYi5ZARATk8cS9gKm+eAZMKO91Mu20AA==', 1, CAST(N'2023-04-20T10:11:13.950' AS DateTime), N'danghoan', CAST(N'2023-06-18T09:14:07.090' AS DateTime), N'admin2', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'let go', N'$MYHASH$V1$10000$dh2DzudLS1F/jOR7Rcr7IZ+UpN9CK8gtRnMqywCWlH1mVqPhAA==', 11, CAST(N'2023-04-20T09:42:43.697' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'moihon', N'$MYHASH$V1$10000$u3yBumRSc0V97qqFLJEyP3tyc/UiXlknCRXx1FonvUKZ6zqPAA==', 11, CAST(N'2023-04-20T10:25:53.977' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'nhat', N'$MYHASH$V1$10000$mfhMwUxCPj7/WRwYF79TrQxYZ1KKek/94urBlS+b35spcrATAA==', 1, CAST(N'2023-06-19T10:23:07.177' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'nickname', N'$MYHASH$V1$10000$SiehE9Nax3whV7sdKbhxDJ4gLRVgMRaiUMFHzMvDXFaPxqaFAA==', 1, CAST(N'2023-04-20T10:19:06.420' AS DateTime), N'danghoan', CAST(N'2023-04-20T10:21:08.703' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'quangg', N'$MYHASH$V1$10000$8jBROHJhvi6XUdZJBshh1L5Wo03yZcGH/C4KMCs2Y6BSU6WzAA==', 1, CAST(N'2023-05-12T14:12:20.647' AS DateTime), N'danghoan', CAST(N'2023-06-18T09:12:04.600' AS DateTime), N'admin2', NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'schocolate', N'$MYHASH$V1$10000$/3f1X1POkdilFbB/xcH06EAsehyOwYT1E8FM1b/lGGGy8d6uAA==', 12, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'thanhtuan', N'$MYHASH$V1$10000$aI/N7WK9wfSL8v7xzAM8iFAefD3xTkdEzsmSaTuDAsp+4WwvAA==', 11, CAST(N'2023-04-20T10:09:02.650' AS DateTime), N'VanB', CAST(N'2023-04-19T13:46:46.000' AS DateTime), N'DangHoan', NULL, NULL, NULL)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'ThiB', N'$MYHASH$V1$10000$rw46LJzsaLdapBg02+Q9NjZ7bWaAKbba6p6OAQJLgXkXFFnzAA==', 1, CAST(N'2023-04-20T10:09:02.650' AS DateTime), NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'VanA', N'$MYHASH$V1$10000$FKwZH0UlLsJOd9mo6GUx76llym7cjzsXx3xSK3w9FJcRDJ/3AA==', 1, CAST(N'2023-04-20T10:09:02.650' AS DateTime), NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Account] ([Username], [Password], [StatusId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (N'VanBB', N'$MYHASH$V1$10000$20ndpxRUbq5kiUD9DkSRmHZ16wUPf3wYkwZp7NlP345WJ4AfAA==', 1, CAST(N'2023-04-20T10:09:02.650' AS DateTime), NULL, CAST(N'2023-06-18T09:08:42.603' AS DateTime), N'admin2', NULL, NULL, NULL)
GO
SET IDENTITY_INSERT [dbo].[Category] ON 
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Giày thể thao', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'Dụng cụ nhà bếp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'Dụng cụ cầu lông', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, N'Đồ dùng cá nhân', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'Đồ đạc nội thất', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'Mỹ phẩm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'Máy móc, thiết bị', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, N'Trái cây, thực phẩm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'Dược phẩm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10, N'Cây cảnh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (11, N'Hạt giống', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Category] ([Id], [CategoryName], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (12, N'Đồ dùng trang trí', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
SET IDENTITY_INSERT [dbo].[Category] OFF
GO
SET IDENTITY_INSERT [dbo].[Order] ON 
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'VanG', CAST(N'2023-04-11T08:14:09.000' AS DateTime), 10, CAST(N'2023-04-11T08:14:09.000' AS DateTime), N'02 Tôn Đản, Hoà Phát, Cẩm Lệ, ĐN', NULL, CAST(31.00 AS Decimal(8, 2)), 8, 38, CAST(5622.74 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-10T10:43:59.963' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:04:27.610' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'VanA', CAST(N'2023-04-03T00:00:00.000' AS DateTime), 10, CAST(N'2023-04-05T00:00:00.000' AS DateTime), N'54 Nguyễn Lương Bằng', NULL, CAST(5.00 AS Decimal(8, 2)), 8, 5, CAST(3332.56 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-10T10:43:59.963' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:31:18.080' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'DangHan', CAST(N'2023-04-10T10:42:37.000' AS DateTime), 2, CAST(N'2023-04-11T10:42:37.000' AS DateTime), N'02 Lý Thái Tổ', NULL, CAST(12.00 AS Decimal(8, 2)), 9, 12, CAST(214270.59 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-10T10:43:59.963' AS DateTime), N'danghoan', CAST(N'2023-05-12T14:25:12.073' AS DateTime), N'danghoan', CAST(N'2023-06-15T09:23:11.777' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'ThanhTuan', CAST(N'2023-04-09T10:09:35.000' AS DateTime), 10, CAST(N'2023-04-11T10:09:35.000' AS DateTime), N'101 Long Biên, Hà Nội', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(813.12 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-11T10:10:30.120' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:50:33.577' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (13, N'VanManh', CAST(N'2020-04-05T10:32:31.000' AS DateTime), 2, CAST(N'2020-04-11T10:32:31.000' AS DateTime), N'123 Sài Gòn', NULL, CAST(5.00 AS Decimal(8, 2)), 8, 12, CAST(6317.13 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-11T10:33:46.643' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:31:58.707' AS DateTime), N'danghoan', CAST(N'2023-06-15T09:23:23.717' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (14, N'VanD', CAST(N'2020-10-11T13:47:18.000' AS DateTime), 10, CAST(N'2020-10-13T13:47:18.000' AS DateTime), N'121 Bạch Đằng', NULL, CAST(3.00 AS Decimal(8, 2)), 9, 32, CAST(9.54 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-11T13:48:17.497' AS DateTime), N'danghoan', CAST(N'2023-06-15T10:41:42.117' AS DateTime), N'danghoan', CAST(N'2023-06-15T10:41:54.320' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (15, N'ThiB', CAST(N'2021-04-11T13:48:23.000' AS DateTime), 10, CAST(N'2021-04-11T13:48:23.000' AS DateTime), N'572 Cầu Giấy, Hà Nội', NULL, CAST(0.00 AS Decimal(8, 2)), 8, 32, CAST(30096.52 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-11T13:49:19.830' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:32:38.943' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (16, N'ThuyNga', CAST(N'2022-04-11T13:49:23.000' AS DateTime), 2, CAST(N'2022-04-11T13:49:23.000' AS DateTime), N'384 Tôn Đức Thắng', NULL, CAST(3.00 AS Decimal(8, 2)), 8, 2, CAST(98440.21 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-11T13:50:20.287' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:32:23.417' AS DateTime), N'danghoan', CAST(N'2023-06-15T09:23:23.717' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (17, N'Thanh Dat', CAST(N'2023-04-13T10:43:59.000' AS DateTime), 2, CAST(N'2023-04-15T10:43:59.000' AS DateTime), N'Quảng Trị', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(1411.20 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-13T10:44:38.817' AS DateTime), N'danghoan', CAST(N'2023-04-14T16:23:53.057' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (18, N'Thanh Van', CAST(N'2023-04-13T10:46:55.000' AS DateTime), 1, CAST(N'2023-04-13T10:46:55.000' AS DateTime), N'Quảng Trị', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(3003.00 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-13T10:47:18.020' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:42:49.097' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (19, N'User', CAST(N'2023-04-13T11:23:48.000' AS DateTime), 2, CAST(N'2023-04-15T11:23:48.000' AS DateTime), N'Quảng Bình', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(0.00 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-13T11:24:11.963' AS DateTime), N'danghoan', CAST(N'2023-04-13T11:24:23.270' AS DateTime), N'danghoan', CAST(N'2023-04-13T11:27:28.080' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (20, N'wf', CAST(N'2023-04-13T11:26:52.000' AS DateTime), 10, CAST(N'2023-04-13T11:26:52.000' AS DateTime), N'f', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(0.00 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-13T11:27:05.173' AS DateTime), N'danghoan', CAST(N'2023-04-13T11:27:14.403' AS DateTime), N'danghoan', CAST(N'2023-04-13T11:27:23.910' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (21, N'owhgw', CAST(N'2023-04-13T11:27:32.927' AS DateTime), 2, CAST(N'2023-04-13T11:27:32.927' AS DateTime), N'gwg', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(7969.50 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-13T11:27:50.553' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-04-13T11:27:59.207' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (22, N'NguoiMoi', CAST(N'2023-04-14T16:19:26.000' AS DateTime), 2, CAST(N'2023-04-17T16:19:26.000' AS DateTime), N'123 Nguyễn Lương Bằng', NULL, CAST(12.00 AS Decimal(8, 2)), 9, 9, CAST(13715.22 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-14T16:19:53.080' AS DateTime), N'danghoan', CAST(N'2023-04-14T16:21:46.467' AS DateTime), N'danghoan', CAST(N'2023-04-14T16:45:39.757' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (23, N'User2', CAST(N'2023-04-14T16:45:43.000' AS DateTime), 10, CAST(N'2023-04-17T16:45:43.000' AS DateTime), N'45 Âu Cơ', NULL, CAST(0.00 AS Decimal(8, 2)), 9, 0, CAST(38216.64 AS Decimal(8, 2)), 2, N'', CAST(N'2023-04-14T16:47:23.737' AS DateTime), N'danghoan', CAST(N'2023-04-14T16:49:22.157' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (24, N'CaoD', CAST(N'2023-04-19T10:50:57.000' AS DateTime), 2, CAST(N'2023-04-25T10:50:57.000' AS DateTime), N'gwgw', NULL, CAST(43.00 AS Decimal(8, 2)), 8, 3, CAST(1015.27 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-19T10:54:27.980' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:58:14.017' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (25, N'HuynhY', CAST(N'2023-04-19T10:57:57.957' AS DateTime), 2, CAST(N'2023-04-23T10:57:57.000' AS DateTime), N'Ái Nghĩa, Đại Lộc, Quảng Nam', NULL, CAST(2.00 AS Decimal(8, 2)), 8, 2, CAST(246.66 AS Decimal(8, 2)), 1, N'', CAST(N'2023-04-19T10:59:01.737' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:41:40.773' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (26, N'Cường', CAST(N'2023-05-11T12:59:35.000' AS DateTime), 1, CAST(N'2023-05-12T12:59:35.000' AS DateTime), N'Tam Kỷ, Quảng Nam', NULL, CAST(2.00 AS Decimal(8, 2)), 8, 31, CAST(34375.89 AS Decimal(8, 2)), 1, N'', CAST(N'2023-05-12T13:01:18.440' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:39:32.053' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (27, N'Thang', CAST(N'2023-05-12T14:25:20.773' AS DateTime), 2, CAST(N'2023-05-12T14:25:20.773' AS DateTime), N'Da Nang', NULL, CAST(3.00 AS Decimal(8, 2)), 8, 12, CAST(1861.20 AS Decimal(8, 2)), 1, N'', CAST(N'2023-05-12T14:27:54.130' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-12T14:28:08.773' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (28, N'KHB', CAST(N'2023-06-14T17:15:11.087' AS DateTime), 2, CAST(N'2023-06-16T17:15:11.000' AS DateTime), N'Liên Chiểu', NULL, CAST(21.00 AS Decimal(8, 2)), 8, 23, CAST(208.43 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-14T17:16:10.803' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:37:40.813' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (29, N'KHC', CAST(N'2023-06-11T09:44:47.000' AS DateTime), 13, CAST(N'2023-06-12T09:44:47.000' AS DateTime), N'Đại Phong', NULL, CAST(123.00 AS Decimal(8, 2)), 8, 12, CAST(108.24 AS Decimal(8, 2)), 2, N'', CAST(N'2023-06-15T09:47:35.090' AS DateTime), N'danghoan', CAST(N'2023-06-15T10:42:07.730' AS DateTime), N'danghoan', CAST(N'2023-06-15T10:42:11.840' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (30, N'KHD', CAST(N'2023-06-15T10:10:08.420' AS DateTime), 10022, CAST(N'2023-07-15T10:10:08.000' AS DateTime), N'Bình Định', NULL, CAST(77.00 AS Decimal(8, 2)), 10, 50, CAST(38.50 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-15T10:11:25.327' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-15T10:11:54.093' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (31, N'KHF', CAST(N'2020-06-15T11:21:42.000' AS DateTime), 10, CAST(N'2020-06-17T11:21:42.000' AS DateTime), N'Hải Phòng', NULL, CAST(2.00 AS Decimal(8, 2)), 8, 0, CAST(22.00 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-15T11:26:16.190' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:34:50.983' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (32, N'KHG', CAST(N'2022-06-15T11:28:15.000' AS DateTime), 20, CAST(N'2022-06-20T11:28:15.000' AS DateTime), N'Cao Bằng', NULL, CAST(32.00 AS Decimal(8, 2)), 8, 22, CAST(56.16 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-15T11:28:53.787' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:29:24.733' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (33, N'KHI', CAST(N'2021-06-15T15:23:55.000' AS DateTime), 1, CAST(N'2021-06-18T15:23:55.000' AS DateTime), N'Đại Cường', NULL, CAST(12.00 AS Decimal(8, 2)), 9, 21, CAST(9.48 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-15T15:24:38.207' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Order] ([Id], [CustomerName], [OrderDate], [ShipperId], [ShipDate], [ShipAddress], [ShipPostalCode], [ShipPrice], [StatusId], [PrivateDiscount], [TotalPrice], [PaymentMethodId], [Note], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (34, N'Anh A', CAST(N'2023-06-24T09:52:47.253' AS DateTime), 10, CAST(N'2023-06-24T09:52:47.000' AS DateTime), N'Quảng Nam', NULL, CAST(32.00 AS Decimal(8, 2)), 8, 43, CAST(5653.96 AS Decimal(8, 2)), 1, N'', CAST(N'2023-06-24T09:54:01.200' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[Order] OFF
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (1, 6, 3, CAST(813.12 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (1, 7, 4, CAST(470.40 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (1, 52, 14, CAST(280.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (1, 74, 4, CAST(87.04 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (1, 82, 41, CAST(7387.38 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (3, 6, 5, CAST(1355.20 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (3, 7, 4, CAST(470.40 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (3, 9, 4, CAST(966.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (3, 19, 4, CAST(711.36 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (6, 6, 10, CAST(2710.40 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (6, 8, 4, CAST(12.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (6, 21, 101, CAST(240754.91 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (9, 9, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (13, 6, 4, CAST(1084.16 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (13, 7, 1, CAST(117.60 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (13, 9, 10, CAST(2415.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (13, 19, 20, CAST(3556.80 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (14, 39, 1, CAST(11.04 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (15, 20, 20, CAST(44259.60 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (16, 1, 34, CAST(5984.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (16, 7, 30, CAST(3528.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (16, 9, 10, CAST(2415.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (16, 20, 40, CAST(88519.20 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (17, 7, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (18, 26, 12, CAST(3003.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (21, 6, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (21, 9, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (22, 6, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (22, 7, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (22, 8, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (23, 6, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (24, 22, 12, CAST(1003.68 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (25, 9, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (25, 53, 1, CAST(249.70 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (26, 21, 20, CAST(47674.24 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (26, 23, 20, CAST(1894.20 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (26, 53, 1, CAST(249.70 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (27, 1, 12, CAST(2112.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (28, 53, 1, CAST(249.70 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (31, 52, 1, CAST(20.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (32, 52, 2, CAST(40.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (34, 53, 23, CAST(5743.10 AS Decimal(8, 2)))
GO
INSERT [dbo].[OrderDetail] ([OrderId], [ProductId], [NumberOfProducts], [TotalPriceOfProducts]) VALUES (34, 82, 23, CAST(4144.14 AS Decimal(8, 2)))
GO
SET IDENTITY_INSERT [dbo].[PaymentMethod] ON 
GO
INSERT [dbo].[PaymentMethod] ([Id], [PaymentMethodName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Online', CAST(N'2023-04-18T13:27:13.047' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[PaymentMethod] ([Id], [PaymentMethodName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'Direct payment', CAST(N'2023-04-18T13:27:13.047' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[PaymentMethod] OFF
GO
SET IDENTITY_INSERT [dbo].[Permission] ON 
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1060, N'Decentralization: View, Add role, Edit, Delete role', CAST(N'2023-06-21T00:00:00.000' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1061, N'Customer category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T16:36:24.527' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1062, N'Employee category: Search, Export, Add, Delete, Edit, CRUD account', CAST(N'2023-06-21T16:36:24.537' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1064, N'Employee category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T16:37:43.170' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1065, N'Employee category: Search, Export, Delete, Edit', CAST(N'2023-06-21T17:03:16.617' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1066, N'Employee category: Search, Export, Add, Delete, CRUD account', CAST(N'2023-06-21T17:20:03.283' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1067, N'Employee category: Search, Export, Add, CRUD account', CAST(N'2023-06-21T17:20:24.927' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1068, N'Employee category: Search, Export, Add, Delete', CAST(N'2023-06-21T17:20:40.020' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1069, N'Employee category: Search, Export, Add, Edit', CAST(N'2023-06-21T17:21:53.527' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1070, N'Employee category: Search, Export, Add, Edit, CRUD account', CAST(N'2023-06-21T17:22:31.653' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1071, N'Product category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T17:23:04.300' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1072, N'Product category: Search, Export, Add, Edit', CAST(N'2023-06-21T17:25:06.010' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1073, N'Customer category: Search, Export, Add, Edit', CAST(N'2023-06-21T17:25:37.560' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1074, N'Customer category: Search, Export', CAST(N'2023-06-21T17:48:01.010' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1075, N'Order category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T17:59:31.830' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1076, N'Supplier category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T17:59:31.840' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1077, N'Warehouse category: Search, Export, Add, Delete, Edit', CAST(N'2023-06-21T17:59:31.840' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1079, N'Warehouse report: Statistic, Export', CAST(N'2023-06-21T17:59:31.840' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1080, N'Warehouse report: Statistic', CAST(N'2023-06-21T18:00:50.247' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1081, N'Customer category: Search', CAST(N'2023-06-23T08:03:28.987' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1082, N'Employee category: Search', CAST(N'2023-06-23T08:03:28.997' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1083, N'Product category: Search', CAST(N'2023-06-23T08:03:28.997' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1084, N'Order category: Search', CAST(N'2023-06-23T08:03:29.007' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1085, N'Supplier category: Search', CAST(N'2023-06-23T08:03:29.007' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1086, N'Warehouse category: Search', CAST(N'2023-06-23T08:03:29.007' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1087, N'Decentralization: View', CAST(N'2023-06-23T08:03:29.007' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1088, N'Decentralization: View, Edit, Add role', CAST(N'2023-06-23T08:07:01.807' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1089, N'Decentralization: View, Edit, Delete role', CAST(N'2023-06-23T08:07:09.500' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1090, N'Decentralization: View, Edit, Add role, Delete role', CAST(N'2023-06-23T08:07:19.117' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1091, N'Customer category: Search, Add', CAST(N'2023-06-23T08:07:31.767' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1092, N'Employee category: Search, Add', CAST(N'2023-06-23T08:07:31.767' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1093, N'Product category: Search, Add', CAST(N'2023-06-23T08:07:31.777' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1094, N'Supplier category: Search, Add', CAST(N'2023-06-23T08:07:31.777' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1095, N'Warehouse category: Search, Delete', CAST(N'2023-06-23T08:07:31.777' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1096, N'Order category: Search, Add', CAST(N'2023-06-23T08:11:58.390' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1097, N'Customer category: Search, Add, Edit', CAST(N'2023-06-24T08:01:42.540' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1098, N'Customer category: Search, Add, Delete, Edit', CAST(N'2023-06-24T08:16:39.017' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1099, N'Customer category: Search, Add, Delete', CAST(N'2023-06-24T08:16:57.870' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1100, N'Customer category: Search, Export, Delete', CAST(N'2023-06-24T08:17:53.710' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1101, N'Employee category: Search, Add, Edit', CAST(N'2023-06-24T08:26:11.833' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1102, N'Employee category: Search, Add, Edit, CRUD account', CAST(N'2023-06-24T08:57:14.427' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1103, N'Customer category: Search, Export, Add, Delete', CAST(N'2023-06-24T09:38:43.753' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1104, N'Customer category: Search, Export, Add', CAST(N'2023-06-24T09:42:43.557' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1105, N'Warehouse category: Search, Add', CAST(N'2023-06-24T09:42:43.563' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1106, N'Order category: Search, Add, Edit', CAST(N'2023-06-24T09:54:29.290' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1107, N'Product category: Search, Add, Delete', CAST(N'2023-06-24T09:55:55.483' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1108, N'Order category: Search, Add, Delete, Edit', CAST(N'2023-06-24T09:55:55.487' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1109, N'Supplier category: Search, Add, Delete', CAST(N'2023-06-24T09:55:55.487' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1110, N'Warehouse category: Search, Add, Delete', CAST(N'2023-06-24T09:55:55.487' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1111, N'Order category: Search, Add, Delete', CAST(N'2023-06-24T09:56:47.783' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Permission] ([Id], [PermissionName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1112, N'Decentralization: View, Add role, Delete role', CAST(N'2023-06-24T09:57:11.817' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[Permission] OFF
GO
SET IDENTITY_INSERT [dbo].[Person] ON 
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'ThanhTuan', N'Nguyễn Thế', N'Lực', 1, CAST(N'2023-04-19T13:46:46.000' AS DateTime), N'0867854654', N'gho@gmail.com', N'Bắc Giang', 3, CAST(N'2023-04-19T13:47:24.107' AS DateTime), N'danghoan', CAST(N'2023-06-24T09:02:16.223' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'CaoHH', N'Cao Thị', N'H', 0, CAST(N'2023-06-12T11:10:01.000' AS DateTime), N'0573475893', N'caoH@gmail.com', N'Lạng Sơn', 3, NULL, NULL, CAST(N'2023-06-24T09:36:20.870' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'danghan', N'Nguyễn Thế', N'Đăng Hân', 1, CAST(N'2002-02-03T22:23:04.000' AS DateTime), N'0889207876', N'danghannguyen09@gmail.com', N'Quảng Nam', 10, CAST(N'2023-04-04T22:24:16.933' AS DateTime), N'danghoan', CAST(N'2023-06-24T09:42:01.297' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, NULL, N'sf', N'f', 1, CAST(N'2023-02-03T08:31:21.000' AS DateTime), N'058498594', N'abc@gmail.com', N'Quảng Ngãi', 2, CAST(N'2023-04-05T08:32:03.480' AS DateTime), N'danghoan', CAST(N'2023-06-24T09:36:34.493' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'DangHoan', N'Nguyễn Thế', N'Đăng Hoan', 1, CAST(N'2002-02-03T00:00:00.000' AS DateTime), N'0852556258', N'nguyenthedanghoan@gmail.com', N'Quảng Nam', 1, NULL, NULL, CAST(N'2023-06-19T09:51:54.923' AS DateTime), N'DangHoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, NULL, N'Lê', N'Thanh Huyền', 0, CAST(N'2023-04-23T13:41:33.000' AS DateTime), N'0587685743', N'gwg@gmail.com', N'Bình Định', 4, CAST(N'2023-04-19T13:42:17.160' AS DateTime), N'danghoan', CAST(N'2023-06-24T08:16:07.403' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, NULL, N'Customer', N'The New', 1, CAST(N'2023-04-05T09:35:10.000' AS DateTime), N'0904874532', N'newCustomer@gmail.com', N'Quảng Trị', 4, CAST(N'2023-04-05T09:35:41.207' AS DateTime), N'danghoan', CAST(N'2023-06-24T08:16:16.527' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, NULL, N'Trần Văn', N'User2', 1, CAST(N'2023-04-13T10:28:58.000' AS DateTime), N'0478275076', N'user2@gmail.com', N'Đà Nẵng', 4, CAST(N'2023-04-13T10:30:08.753' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:02:43.213' AS DateTime), N'danghoan', CAST(N'2023-06-24T09:40:18.473' AS DateTime), N'danghan', 1)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'VanA', N'Nguyễn Văn', N'A', 1, CAST(N'2002-11-15T00:00:00.000' AS DateTime), N'0428752807', N'vân@gmail.com', N'Quảng Nam', 4, NULL, NULL, CAST(N'2023-04-04T22:22:56.103' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10, N'VanBB', N'Trần Văn', N'B', 0, CAST(N'2001-08-09T00:00:00.000' AS DateTime), N'05747583', N'b@gmail.com', N'Quảng Trị', 3, NULL, NULL, CAST(N'2023-06-18T09:08:42.573' AS DateTime), N'admin2', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (11, NULL, N'Đinh Minh', N'Nhất', 0, CAST(N'2023-04-19T15:57:50.000' AS DateTime), N'0654676953', N'moi@gmail.com', N'Quảng Ngãi', 4, CAST(N'2023-04-19T15:58:14.827' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:03:14.697' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (12, N'hahahuhu', N'Ngô', N'Minh Hằng', 0, CAST(N'2023-04-19T15:58:50.000' AS DateTime), N'0543', N'validate@gmail.com', N'Hà Nội', 3, CAST(N'2023-04-19T15:59:27.833' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:14:19.393' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (13, N'let go', N'Ngô', N'Như Quỳnh', 0, CAST(N'2023-04-23T08:48:28.000' AS DateTime), N'0503475', N'man@gmail.com', N'Bình Định', 3, CAST(N'2023-04-20T08:49:10.410' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:13:25.660' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (14, N'hehe', N'Lê', N'Minh Thư', 0, CAST(N'2023-04-20T09:55:59.000' AS DateTime), N'053454', N'thu@gmail.com', N'Quảng Nam', 2, CAST(N'2023-04-20T09:56:29.800' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:14:30.380' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (15, N'moihon', N'Đoàn', N'Quốc', 1, CAST(N'2002-04-20T10:04:26.000' AS DateTime), N'065743', N'DoanQuoc@gmail.com', N'Hoàng Sa', 2, CAST(N'2023-04-20T10:05:04.697' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:12:06.643' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (16, NULL, N'grg', N'ggr', 0, CAST(N'2023-04-20T10:10:53.000' AS DateTime), N'05454', N'gr@gmail.com', N'hrth', 1, CAST(N'2023-04-20T10:11:16.440' AS DateTime), N'danghoan', CAST(N'2023-06-18T09:14:01.623' AS DateTime), N'admin2', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (17, NULL, N'tret', N'heh', 0, CAST(N'2023-04-20T10:12:23.000' AS DateTime), N'06546', N'g@gmail.com', N'he', 4, CAST(N'2023-04-20T10:12:51.817' AS DateTime), N'danghoan', CAST(N'2023-04-20T10:13:05.137' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (18, N'nickname', N'do', N'doremiphas', 0, CAST(N'2002-04-20T10:17:34.000' AS DateTime), N'0543543897', N'song@gmail.com', N'Trường Sa', 2, CAST(N'2023-04-20T10:19:08.930' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:11:25.507' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (19, NULL, N'gưg', N'toi la ngu', 1, CAST(N'2023-04-20T10:30:35.947' AS DateTime), N'06565', N'guggu@gmail.com', N'ge', 2, CAST(N'2023-04-20T10:30:57.570' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (20, N'hello', N'Đặng', N'Minh Thư', 1, CAST(N'2023-04-24T11:24:58.000' AS DateTime), N'0583495', N'mai@gmail.com', N'Cà Mau', 3, CAST(N'2023-04-24T11:25:18.240' AS DateTime), N'vanb', CAST(N'2023-05-12T11:14:56.830' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (21, NULL, N'hona', N'helo', 1, CAST(N'2023-05-05T14:37:15.107' AS DateTime), N'0593475', N'haon@gmail.com', N'gw', 4, CAST(N'2023-05-05T14:37:42.080' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10021, NULL, N'Nguyễn', N'Thành Đạt', 1, CAST(N'2002-05-06T15:32:41.000' AS DateTime), N'057438756', N'dat@gmail.com', N'Quảng Đại, Đại Cường, Đại Lộc, Quảng Nam', 2, CAST(N'2023-05-06T15:33:25.837' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:11:00.300' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10022, NULL, N'Trần', N'Phước Huy', 1, CAST(N'2000-03-04T15:38:43.000' AS DateTime), N'0547378', N'huy@gmail.com', N'Đà Nẵng', 3, CAST(N'2023-05-06T15:39:34.730' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10023, NULL, N'Trần', N'Văn Bình', 1, CAST(N'2000-05-12T10:58:33.000' AS DateTime), N'0534534', N'vanbinh@gmail.com', N'Hà Nội', 4, CAST(N'2023-05-12T10:59:15.417' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10024, N'huyen', N'Nguyễn Thị', N'Ánh Huyền', 0, CAST(N'2002-05-12T11:15:13.000' AS DateTime), N'0573454354', N'AnhHuyen2002@gmail.com', N'Quảng Nam', 10, CAST(N'2023-05-12T11:15:58.220' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:29:15.857' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10025, N'bao', N'Trần', N'Minh Bảo', 1, CAST(N'2000-05-12T13:27:43.000' AS DateTime), N'0489578342', N'bao@gmail.com', N'Hà Tĩnh', 1, CAST(N'2023-05-12T13:28:42.057' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10026, NULL, N'Truong', N'Quang Do', 1, CAST(N'2023-05-12T14:05:51.517' AS DateTime), N'0876867', N'do@gmail.com', N'gwg', 4, CAST(N'2023-05-12T14:08:17.797' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10027, N'quangg', N'gerg', N'agsg', 1, CAST(N'2002-05-01T14:10:37.000' AS DateTime), N'0605685784', N'ee@gmail.com', N'tyty', 2, CAST(N'2023-05-12T14:12:29.350' AS DateTime), N'danghoan', CAST(N'2023-06-18T09:10:55.933' AS DateTime), N'admin2', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10028, N'admin2', N'master', N'admin1', 1, CAST(N'2023-05-12T16:59:52.773' AS DateTime), N'0543578493', N'admin1@gmail.com', N'Huế', 22, CAST(N'2023-05-12T17:01:40.647' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10029, NULL, N'nguyen', N'danghan', 1, CAST(N'2002-02-03T09:18:28.000' AS DateTime), N'0889207876', N'danghannguyen09@gmail.com', N'Dai Cuong', 1, CAST(N'2023-06-18T09:19:16.023' AS DateTime), N'admin2', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10030, N'nhat', N'Trần Minh', N'Nhật', 1, CAST(N'2002-02-12T08:39:40.000' AS DateTime), N'04567', N'minnhat@gmail.com', N'ừ', 2, CAST(N'2023-06-19T08:40:45.967' AS DateTime), N'danghoan', CAST(N'2023-06-19T10:23:20.640' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10031, N'binh', N'binh', N'cam', 0, CAST(N'2023-06-19T10:20:18.000' AS DateTime), N'09876543', N'binh@gmail.com', N'Quảng Bình', 3, CAST(N'2023-06-19T10:21:19.593' AS DateTime), N'danghoan', CAST(N'2023-06-19T10:22:00.920' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Person] ([Id], [Username], [LastName], [FirstName], [Gender], [BirthDate], [Phone], [Email], [Address], [RoleId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10032, NULL, N'KH', N'C', 0, CAST(N'2002-01-12T11:49:59.000' AS DateTime), N'0432', N'khC@gmail.com', N'Quảng Trị', 4, CAST(N'2023-06-19T11:51:40.643' AS DateTime), N'danghoan', CAST(N'2023-06-19T11:52:49.520' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[Person] OFF
GO
SET IDENTITY_INSERT [dbo].[Product] ON 
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Giày wika', 1, 1, CAST(200.00 AS Decimal(30, 2)), N'$', 3, 12, 0, 0, CAST(N'2023-04-05T11:39:07.377' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:12:18.447' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'Tủ lạnh LG ngăn đá123', 2, 2, CAST(484.00 AS Decimal(30, 2)), N'$', 3, 44, 0, 0, CAST(N'2023-04-05T11:39:07.377' AS DateTime), N'danghoan', CAST(N'2023-05-30T22:25:35.933' AS DateTime), N'danghoan', CAST(N'2023-06-15T14:41:05.120' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'Vợt yonex', 1, 3, CAST(120.00 AS Decimal(30, 2)), N'$', 3, 2, 0, 0, CAST(N'2023-04-05T11:39:07.377' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:49:48.477' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, N'Cầu lông', 4, 3, CAST(3.00 AS Decimal(30, 2)), N'$', 3, 0, 0, 0, CAST(N'2023-04-05T11:50:05.103' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-15T15:13:55.067' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'Giày asias', 1, 1, CAST(345.00 AS Decimal(30, 2)), N'$', 3, 30, 0, 0, CAST(N'2023-04-05T11:59:30.520' AS DateTime), N'danghoan', CAST(N'2023-06-15T15:14:35.630' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (19, N'Chảo chống dính123', 2, 2, CAST(234.00 AS Decimal(30, 2)), N'$', 3, 24, 0, 0, CAST(N'2023-04-05T14:50:51.557' AS DateTime), N'danghoan', CAST(N'2023-05-12T14:23:20.620' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (20, N'Tivi Samsung', 2, 2, CAST(3353.00 AS Decimal(30, 2)), N'$', 3, 34, 0, 0, CAST(N'2023-04-05T14:52:37.627' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (21, N'Bình đun siêu tốc', 1, 2, CAST(3656.00 AS Decimal(30, 2)), N'$', 3, 34.8, 0, 0, CAST(N'2023-04-13T10:32:02.697' AS DateTime), N'danghoan', CAST(N'2023-04-19T10:26:18.060' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (22, N'Tivi Samsung', 1, 2, CAST(123.00 AS Decimal(30, 2)), N'$', 3, 32, 0, 0, CAST(N'2023-04-17T11:19:09.630' AS DateTime), N'danghoan', CAST(N'2023-05-09T14:56:25.433' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (23, N'Bàn ủi đa năng', 1, 2, CAST(123.00 AS Decimal(30, 2)), N'$', 3, 23, 0, 0, CAST(N'2023-04-17T20:49:13.163' AS DateTime), N'danghoan', CAST(N'2023-04-18T15:03:58.983' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (24, N'Khăn lau', 1, 2, CAST(34.00 AS Decimal(30, 2)), N'$', 3, 2, 0, 0, CAST(N'2023-04-17T20:55:25.787' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (25, N'Mũ len', 1, 2, CAST(342.00 AS Decimal(30, 2)), N'$', 3, 34, 0, 0, CAST(N'2023-04-17T20:57:25.470' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (26, N'Mũ lưỡi trai', 1, 2, CAST(325.00 AS Decimal(30, 2)), N'$', 3, 23, 0, 0, CAST(N'2023-04-17T20:57:56.947' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (27, N'NikeAir', 1, 1, CAST(24.00 AS Decimal(30, 2)), N'$', 3, 54, 0, 0, CAST(N'2023-04-17T20:58:26.433' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:18:33.380' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (39, N'Áo mưa', 12, 4, CAST(24.00 AS Decimal(30, 2)), N'$', 3, 54, 0, 0, CAST(N'2023-04-18T08:25:14.027' AS DateTime), N'danghoan', CAST(N'2023-06-15T10:41:13.970' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (40, N'new product 2', 4, 2, CAST(42523.00 AS Decimal(30, 2)), N'$', 3, 5454, 0, 0, CAST(N'2023-04-18T08:27:02.207' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (41, N'5', 1, 2, CAST(543.00 AS Decimal(30, 2)), N'$', 3, 43534, 0, 0, CAST(N'2023-04-18T08:28:59.270' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (42, N'534', 1, 2, CAST(435.00 AS Decimal(30, 2)), N'$', 3, 5435, 0, 0, CAST(N'2023-04-18T08:34:16.890' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (43, N'fwfw', 1, 1, CAST(4354.00 AS Decimal(30, 2)), N'$', 3, 543, 0, 0, CAST(N'2023-04-18T08:39:45.113' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (44, N'rt34', 1, 1, CAST(5435.00 AS Decimal(30, 2)), N'$', 3, 5435, 0, 0, CAST(N'2023-04-18T08:59:56.190' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (45, N'gho', 2, 1, CAST(4534.00 AS Decimal(30, 2)), N'$', 3, 543, 0, 0, CAST(N'2023-04-18T09:43:09.377' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (46, N'hoghwo', 1, 2, CAST(2.40 AS Decimal(30, 2)), N'$', 3, 23, 0, 0, CAST(N'2023-04-18T11:17:08.177' AS DateTime), N'danghoan', CAST(N'2023-04-18T11:17:57.690' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (47, N'ef', 2, 2, CAST(322.00 AS Decimal(30, 2)), N'$', 3, 32, 0, 0, CAST(N'2023-04-18T11:22:00.977' AS DateTime), N'danghoan', CAST(N'2023-04-18T11:22:38.687' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (48, N'aaaaaaaaaaaaa', 2, 1, CAST(242.00 AS Decimal(30, 2)), N'$', 3, 4324, 0, 0, CAST(N'2023-04-18T11:23:44.750' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (49, N'kho moi hehe', 2, 1, CAST(252.00 AS Decimal(30, 2)), N'$', 3, 44, 0, 0, CAST(N'2023-04-18T11:29:42.747' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (50, N'Áo khoác', 4, 1, CAST(435345.00 AS Decimal(30, 2)), N'$', 3, 54, 0, 0, CAST(N'2023-04-18T11:33:27.363' AS DateTime), N'danghoan', CAST(N'2023-05-12T11:19:50.850' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (51, N'Mũ bảo hiểm', 12, 4, CAST(134.00 AS Decimal(30, 2)), N'$', 3, 2, 0, 0, CAST(N'2023-04-18T11:33:58.193' AS DateTime), N'danghoan', CAST(N'2023-06-14T08:48:59.323' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (52, N'Đồng hồ thông minh', 4, 1, CAST(20.00 AS Decimal(30, 2)), N'$', 3, 0, 0, 0, CAST(N'2023-04-18T11:38:36.117' AS DateTime), N'danghoan', CAST(N'2023-05-12T12:50:56.213' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (53, N'Bàn ủi', 1, 5, CAST(454.00 AS Decimal(30, 2)), N'$', 3, 45, 0, 0, CAST(N'2023-04-18T11:41:53.300' AS DateTime), N'danghoan', CAST(N'2023-05-12T12:51:29.800' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (54, N'eww', 1, 2, CAST(5455.00 AS Decimal(30, 2)), N'$', 3, 435, 0, 0, CAST(N'2023-04-18T11:51:41.163' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (55, N'fwf', 2, 2, CAST(543.00 AS Decimal(30, 2)), N'$', 3, 5435, 0, 0, CAST(N'2023-04-18T11:52:35.600' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (56, N'fw', 1, 1, CAST(454.00 AS Decimal(30, 2)), N'$', 3, 5445, 0, 0, CAST(N'2023-04-18T13:06:26.997' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (57, N'gwg323', 2, 2, CAST(5435.00 AS Decimal(30, 2)), N'$', 3, 5454, 0, 0, CAST(N'2023-04-18T13:07:29.477' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:07:39.293' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (58, N'1', 1, 1, CAST(2.00 AS Decimal(30, 2)), N'$', 3, 2, 0, 0, CAST(N'2023-04-18T13:27:01.173' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:27:13.047' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (59, N'e', 1, 2, CAST(3.00 AS Decimal(30, 2)), N'$', 3, 33, 0, 0, CAST(N'2023-04-18T13:27:59.703' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:28:08.170' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (60, N'rwr', 1, 2, CAST(42.00 AS Decimal(30, 2)), N'$', 3, 432, 0, 0, CAST(N'2023-04-18T17:25:51.040' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (61, N'43', 1, 1, CAST(43.00 AS Decimal(30, 2)), N'$', 3, 34, 0, 0, CAST(N'2023-04-18T17:35:33.000' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (62, N'3333333', 1, 1, CAST(32.00 AS Decimal(30, 2)), N'$', 3, 3, 0, 0, CAST(N'2023-04-18T17:36:07.947' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (63, N'áo choàng mùa đông', 1, 2, CAST(543.00 AS Decimal(30, 2)), N'$', 3, 4, 0, 0, CAST(N'2023-04-18T20:21:32.330' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (64, N'32', 1, 1, CAST(43.00 AS Decimal(30, 2)), N'$', 3, 43, 0, 0, CAST(N'2023-04-18T20:22:14.463' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (66, N'543', 1, 2, CAST(4.00 AS Decimal(30, 2)), N'$', 3, 3, 0, 0, CAST(N'2023-04-19T10:46:30.640' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (67, N'Dù gấp tiện lợi', 4, 4, CAST(454.00 AS Decimal(30, 2)), N'$', 3, 25, 0, 0, CAST(N'2023-05-06T14:34:43.823' AS DateTime), N'danghoan', CAST(N'2023-05-06T14:35:21.733' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (68, N'Balo', 1, 4, CAST(534.00 AS Decimal(30, 2)), N'$', 3, 35, 0, 0, CAST(N'2023-05-06T14:37:13.143' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (69, N'hah', 1, 3, CAST(675.00 AS Decimal(30, 2)), N'$', 3, 54, 0, 0, CAST(N'2023-05-06T14:38:12.423' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (70, N'Dầu gội đầu', 1, 4, CAST(754.00 AS Decimal(30, 2)), N'$', 3, 32, 0, 0, CAST(N'2023-05-12T12:59:16.113' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-19T13:25:24.673' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (71, N'getge', 2, 2, CAST(534.00 AS Decimal(30, 2)), N'$', 3, 34, 0, 0, CAST(N'2023-05-12T14:38:43.547' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (72, N'sản phẩm mới', 4, 2, CAST(32.00 AS Decimal(30, 2)), N'$', 3, 21, 0, 0, CAST(N'2023-05-30T22:22:04.557' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (74, N'Ô cao cấp', 2, 4, CAST(32.00 AS Decimal(30, 2)), N'$', 4, 32, 0, 0, CAST(N'2023-06-04T14:57:15.877' AS DateTime), N'danghoan', CAST(N'2023-06-15T11:17:48.213' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (75, N'hehe', 4, 3, CAST(453.00 AS Decimal(30, 2)), N'$', 3, 45, 0, 0, CAST(N'2023-06-05T16:24:54.350' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (76, N'gưg', 2, 3, CAST(54.00 AS Decimal(30, 2)), N'$', 4, 54, 0, 0, CAST(N'2023-06-05T16:26:59.833' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (77, N'rr', 2, 3, CAST(3.00 AS Decimal(30, 2)), N'$', 3, 43, 0, 0, CAST(N'2023-06-05T16:27:22.450' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (78, N'43', 2, 1, CAST(43.00 AS Decimal(30, 2)), N'$', 4, 43, 0, 0, CAST(N'2023-06-05T16:27:43.913' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (79, N'54', 1, 2, CAST(54.00 AS Decimal(30, 2)), N'$', 3, 54, 0, 0, CAST(N'2023-06-05T16:28:03.353' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (80, N'bàn học', 7, 5, CAST(345.00 AS Decimal(30, 2)), N'$', 4, 23, 0, 0, CAST(N'2023-06-06T16:48:21.473' AS DateTime), N'danghoan', CAST(N'2023-06-06T16:49:06.140' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (81, N'e', 2, 1, CAST(54.00 AS Decimal(30, 2)), N'$', 4, 4, 0, 0, CAST(N'2023-06-06T16:50:18.827' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (82, N'cây cam', 15, 10, CAST(234.00 AS Decimal(30, 2)), N'$', 3, 23, 0, 0, CAST(N'2023-06-10T16:43:58.317' AS DateTime), N'danghoan', CAST(N'2023-06-11T09:58:01.977' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (83, N'cây đào', 13, 10, CAST(1233.00 AS Decimal(30, 2)), N'$', 4, 32, 0, 0, CAST(N'2023-06-10T16:45:30.553' AS DateTime), N'danghoan', CAST(N'2023-06-11T09:03:37.743' AS DateTime), N'danghoan', CAST(N'2023-06-11T09:55:36.137' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (84, N'cây vừng', 14, 10, CAST(23443.00 AS Decimal(30, 2)), N'$', 3, 32, 0, 0, CAST(N'2023-06-11T09:08:18.023' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Product] ([Id], [ProductName], [SupplierId], [CategoryId], [ProductPrice], [UnitPrice], [ProductStatusId], [DiscountPercent], [Rating], [ImageId], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (85, N'cây mai', 15, 10, CAST(23.00 AS Decimal(30, 2)), N'$', 3, 23, 0, 0, CAST(N'2023-06-11T09:56:42.757' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
SET IDENTITY_INSERT [dbo].[Role] ON 
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Admin', NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'Employee', NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'Shipper', NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, N'Customer', NULL, NULL, NULL, NULL, CAST(N'2023-04-28T11:57:53.350' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'Employee', NULL, NULL, NULL, NULL, CAST(N'2023-04-28T11:55:18.377' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'admin', CAST(N'2023-04-27T11:40:22.903' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-04-28T11:26:53.493' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'haha', CAST(N'2023-04-28T11:58:04.013' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-04T09:05:25.120' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, N'roleMoi', CAST(N'2023-05-04T09:08:27.707' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:17:17.843' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'heheggs', CAST(N'2023-05-04T09:17:33.200' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-04T10:26:57.367' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10, N'Quản lý nhân sự', CAST(N'2023-05-04T10:29:49.567' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (11, N'Quản lý kho', CAST(N'2023-05-04T10:32:12.537' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (12, N'role moi', CAST(N'2023-05-06T08:25:25.507' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:27:11.897' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (13, N'new role', CAST(N'2023-05-06T08:27:28.827' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:27:32.640' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (14, N'new role', CAST(N'2023-05-06T08:28:38.960' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:28:44.547' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (15, N'role moi', CAST(N'2023-05-06T08:29:56.890' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:30:00.890' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (16, N'chuyen gi se xay ra', CAST(N'2023-05-06T08:30:59.043' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:35:06.723' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (17, N'danghoan', CAST(N'2023-05-06T08:31:47.867' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:34:45.310' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (18, N'dagow', CAST(N'2023-05-06T08:34:56.387' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:35:00.693' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (19, N'khi', CAST(N'2023-05-06T08:36:04.240' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-06T08:36:09.207' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (20, N'moi', CAST(N'2023-05-12T14:54:04.893' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-05-12T14:54:29.897' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (21, N'he', CAST(N'2023-05-12T14:55:22.310' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (22, N'Admin2', CAST(N'2023-05-12T16:40:26.617' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (23, N'roleNew', CAST(N'2023-06-24T09:38:33.923' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-24T09:41:37.590' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (24, N'role2', CAST(N'2023-06-24T09:38:52.453' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-24T09:41:31.650' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[Role] ([Id], [RoleName], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (25, N'sdfg', CAST(N'2023-06-24T09:57:19.483' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-24T09:57:26.860' AS DateTime), N'danghoan', 1)
GO
SET IDENTITY_INSERT [dbo].[Role] OFF
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1066)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1079)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1090)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1103)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1107)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1109)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1110)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1111)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (1, 1112)
GO
INSERT [dbo].[RolePermission] ([RoleId], [PermissionId]) VALUES (23, 1103)
GO
SET IDENTITY_INSERT [dbo].[SalesDetail] ON 
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (1, 1, 1, 1200, 110, CAST(19360.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (2, 19, 6, 343, 63, CAST(17075.52 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (3, 2, 8, 3294, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (4, 2, 9, 4322, 24, CAST(5796.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (6, 2, 7, 5345, 55, CAST(6468.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (7, 2, 19, 25436, 24, CAST(4268.16 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (8, 1, 20, 2542, 60, CAST(132778.80 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (9, 1, 21, 434, 20, CAST(47674.24 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (10, 3, 22, 259, 12, CAST(1003.68 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (11, 3, 23, 3426, 20, CAST(1894.20 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (12, 2, 24, 1234, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (13, 3, 25, 342, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (14, 1, 26, 422, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (15, 1, 27, 68, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (27, 1, 39, 5454, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (28, 1, 40, 54353, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (29, 1, 41, 543, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (30, 1, 42, 435, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (31, 1, 43, 543, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (32, 1, 44, 5435, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (33, 5, 45, 5435, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (35, 3, 47, 23, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (40, 17, 52, 300, 294, CAST(5880.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (41, 19, 53, 454, 38, CAST(9488.60 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (42, 17, 50, 535, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (43, 19, 51, 544, 32, CAST(4202.24 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (44, 21, 54, 543, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (50, 1, 60, 43, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (53, 35, 63, 555, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (56, 40, 66, 42, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (57, 1, 67, 5438, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (58, 1, 68, 5845, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (60, 3, 70, 75834, 10, CAST(5127.20 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (62, 3, 72, 432, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (63, 2, 74, 123, 8, CAST(174.08 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (64, 2, 75, 543, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (65, 3, 76, 543, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (66, 2, 77, 3, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (67, 1, 78, 34, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (68, 2, 79, 54, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (69, 3, 80, 1234, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (70, 3, 81, 54, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (71, 45, 82, 2345, 146, CAST(26306.28 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (72, 45, 83, 15, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (73, 45, 84, 3443, 0, CAST(0.00 AS Decimal(8, 2)))
GO
INSERT [dbo].[SalesDetail] ([Id], [WareHouseId], [ProductId], [Total], [SellNumber], [SalesTotal]) VALUES (74, 45, 85, 43, 9, CAST(159.39 AS Decimal(8, 2)))
GO
SET IDENTITY_INSERT [dbo].[SalesDetail] OFF
GO
SET IDENTITY_INSERT [dbo].[Status] ON 
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'ACTIVITIED', N'Account', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'BLOCK', N'Account', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'AVAILABLE', N'Product', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, N'UNAVAILABLE', N'Product', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'DELETE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'SUCCESS', N'Null', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'FAIL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, N'DELEVERED', N'Order', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'NOT DELEVERY', N'Order', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10, N'CANCELED', N'Order', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (11, N'DELETED', N'Account', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (12, N'PENDING', N'Account', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Status] ([Id], [StatusName], [TypeStatus], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (13, N'NOT ACTIVITIED', N'Account', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
SET IDENTITY_INSERT [dbo].[Status] OFF
GO
SET IDENTITY_INSERT [dbo].[Supplier] ON 
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Công ty TNHH TM&SX Thể thao Hoàng Phong', N'Tầng 1, ô 23 Lô 1, Đền Lừ 2, P. Hoàng Văn Thụ, Q. Hoàng Mai, Hà Nội', N'0986200022', N'tnhh1tv@gmail.com', N'', N'', NULL, NULL, CAST(N'2023-04-19T09:30:14.193' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'LG Official Store', N'TP HCM', N'0580357387', N'lg@gmail.com', N'', N'', NULL, NULL, CAST(N'2023-04-19T09:38:44.693' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, N'Công ty sản xuất dụng cụ thể thao', N'Đà Nẵng', N'068969376', N'ctySanXuat@gmail.com', N'', N'Uy tín, chất lượng, phản hồi khách hàng nhanh, kịp thời', NULL, NULL, CAST(N'2023-04-19T09:53:24.547' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'gw', N'gw', N'0765', N'gw@gmail.com', N'', N'', CAST(N'2023-04-19T09:57:02.557' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'fwf', N'gwg', N'04534', N'@gmail.com', N'gw', N'', CAST(N'2023-04-19T10:18:57.280' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'Công ty sản xuất đồ nội thất', N'Cần Thơ', N'057385437', N'aa@gmail.com', N'', N'Cam kết hoàn tiền nếu sản phẩm bị hư hỏng hoặc không hài lòng khách hàng', CAST(N'2023-05-12T13:03:04.010' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:21:50.403' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (8, N'mới', N'Quảng Bình', N'04589344', N'moi@gmail.com', N'', N'xin chào tôi tên là hến', CAST(N'2023-05-12T13:22:36.513' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:22:59.707' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (9, N'123', N'Quảng Trị', N'0543543', N'guo@gmail.com', N'', N'thối', CAST(N'2023-05-12T13:23:45.917' AS DateTime), N'danghoan', CAST(N'2023-05-12T13:25:28.663' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (10, N'fwgư', N'Kon Tum', N'0583945', N'gu@gmail.com', N'', N'thối nực nực', CAST(N'2023-05-12T13:26:02.370' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (11, N'công ty mới 2', N'geg', N'054365', N'moi@gmail.com', N'', N'ggr', CAST(N'2023-06-07T11:34:11.617' AS DateTime), N'danghoan', CAST(N'2023-06-07T11:34:22.653' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (12, N'gwg', N'g54', N'05435', N'gho@gmail.com', N'543', N'g', CAST(N'2023-06-07T11:34:57.063' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (13, N'ret', N'5435', N'0543', N'5435@gmail.com', N'543', N'ter', CAST(N'2023-06-07T11:35:08.837' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (14, N'ff', N'543', N'0543', N'wf@gmail.com', N'543', N'fwf', CAST(N'2023-06-07T11:35:22.873' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (15, N'534', N'534', N'0534', N'543@gmail.com', N'', N'543', CAST(N'2023-06-07T11:35:32.883' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (16, N'543', N'54', N'054', N'543@gmail.com', N'', N'', CAST(N'2023-06-07T11:35:42.660' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[Supplier] ([Id], [CompanyName], [Address], [Phone], [Email], [Webpage], [Description], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (17, N'534', N'543', N'054', N'53@gmail.com', N'', N'', CAST(N'2023-06-07T11:35:52.223' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[Supplier] OFF
GO
SET IDENTITY_INSERT [dbo].[WareHouse] ON 
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (1, N'Kho thiết bị 1', N'Bạch Đằng', 20963, 574, CAST(N'2023-04-17T11:13:56.160' AS DateTime), N'danghoan', CAST(N'2023-05-12T14:39:04.877' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (2, N'Kho dụng cụ thể thao', N'K34 đường Tôn Đức Thắng', -2337, 337, CAST(N'2023-04-17T11:13:56.160' AS DateTime), N'danghoan', CAST(N'2023-04-17T11:15:45.630' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (3, N'Kho đồ dùng gia đình', N'345 đường Trường Chinh, Cẩm Lệ, Đà Nẵng', 2298, 42, CAST(N'2023-04-17T11:13:56.160' AS DateTime), N'danghoan', CAST(N'2023-04-18T15:09:22.540' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (4, N'hoan', N'gwghwoi', 0, 0, CAST(N'2023-04-18T08:34:37.607' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-10T15:59:41.013' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (5, N'new warehouse', N'new address', 0, 0, CAST(N'2023-04-18T09:42:00.620' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-10T16:34:55.920' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (6, N'4', N'4', 0, 0, CAST(N'2023-04-18T09:43:23.533' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-10T16:34:41.993' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (7, N'', N'', 0, 0, CAST(N'2023-04-18T11:08:22.727' AS DateTime), N'danghoan', NULL, NULL, CAST(N'2023-06-10T15:59:41.023' AS DateTime), N'danghoan', 1)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (17, N'kho mới hoàn toàn', N'địa điểm mới hoàn toàn', 100, 294, CAST(N'2023-04-18T11:34:02.483' AS DateTime), N'danghoan', CAST(N'2023-04-18T15:03:40.843' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (18, N'warehouse', N'Núi Thành', 0, 0, CAST(N'2023-04-18T11:37:48.033' AS DateTime), N'danghoan', CAST(N'2023-06-10T16:35:39.523' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (19, N'kho mới thứ 2', N'địa điểm chưa biết', -343, 133, CAST(N'2023-04-18T11:40:21.960' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:28:19.013' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (21, N'', N'', 0, 0, CAST(N'2023-04-18T11:51:25.517' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (24, N'ghowhgow', N'gwgw', 0, 0, CAST(N'2023-04-18T13:07:15.810' AS DateTime), N'danghoan', CAST(N'2023-04-18T13:07:55.827' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (34, N'3', N'43', 0, 0, CAST(N'2023-04-18T17:35:55.253' AS DateTime), N'danghoan', CAST(N'2023-04-18T17:36:26.050' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (35, N'f3', N'33', 0, 0, CAST(N'2023-04-18T20:20:24.877' AS DateTime), N'danghoan', CAST(N'2023-04-18T20:22:00.620' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (40, N'ge', N'ge', 42, 0, CAST(N'2023-04-19T10:46:20.370' AS DateTime), N'danghoan', CAST(N'2023-04-19T10:46:40.553' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (43, N'kho hạt giống', N'Vịnh Hạ Long', 0, 0, CAST(N'2023-06-10T16:39:18.250' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (44, N'Kho dược phẩm', N'Hà Nội', 0, 0, CAST(N'2023-06-10T16:41:04.423' AS DateTime), N'danghoan', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[WareHouse] ([Id], [WareHouseName], [Address], [NumberOfImport], [NumberOfExport], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy], [DeleteDate], [DeleteBy], [IsDelete]) VALUES (45, N'kho cây trồng 2', N'Vườn Bách Thảo 2', 5831, 155, CAST(N'2023-06-10T16:42:41.167' AS DateTime), N'danghoan', CAST(N'2023-06-10T16:49:06.400' AS DateTime), N'danghoan', NULL, NULL, 0)
GO
SET IDENTITY_INSERT [dbo].[WareHouse] OFF
GO