public static void CreateUnLinkPackage() { TblPackage sqlPackage = new TblPackage(); sqlPackage.StrPackageCode = "Unlinked"; DataTable packageTable = sqlPackage.SelectOne(); if (packageTable == null || packageTable.Rows.Count == 0) { sqlPackage.StrPackageCode = "Unlinked"; sqlPackage.NCategoryID = 1; sqlPackage.NStatus = 2; sqlPackage.DtValidEnd = DateTime.Now; sqlPackage.DtValidStart = DateTime.Now; sqlPackage.NMaxSession = 10000; sqlPackage.Insert(); } }