[ScriptMethod(ResponseFormat = ResponseFormat.Json)]//Specify return format. public static string ListOfInventory() { DataContext db1 = new DataContext("Database=InventoryDB;Server=DESKTOP-6GQP7S7\\SQLEXPRESS;Integrated Security=SSPI"); List <Object> result1 = new List <Object>(); // Get a typed table to run queries. Table <Inventory> Inventory = db1.GetTable <Inventory>(); // Attach the log to show generated SQL. db1.Log = Console.Out; // Query for customers in London. IQueryable <Inventory> inventoryQuery = from x in Inventory select x; var json = new Object(); foreach (Inventory x in inventoryQuery) { json = new JavaScriptSerializer().Serialize(x); result1.Add(json); } // Prevent console window from closing. return(result1.ToJSON()); }
public static string ListOfSalesDetail() { DataContext db = new DataContext("Database=STOREDB;Server=DESKTOP-6GQP7S7\\SQLEXPRESS;Integrated Security=SSPI"); List <SalesDetail> result = new List <SalesDetail>(); // Get a typed table to run queries. Table <SalesDetail> SalesDetail = db.GetTable <SalesDetail>(); // Attach the log to show generated SQL. db.Log = Console.Out; // Query for customers in London. IQueryable <SalesDetail> SalesDetailQuery = from x in SalesDetail select x; foreach (SalesDetail x in SalesDetailQuery) { result.Add(x); Console.WriteLine("ID={0}, City={1}", x.InvoiceNo, x.PurchaseNo); } // Prevent console window from closing. Console.ReadLine(); return(result.ToJSON()); }
public static string ListOfPurchase() { DataContext db = new DataContext("Database=PurchaseDB;Server=DESKTOP-6GQP7S7\\SQLEXPRESS;Integrated Security=SSPI"); List <Purchase> result = new List <Purchase>(); // Get a typed table to run queries. Table <Purchase> Purchase = db.GetTable <Purchase>(); // Attach the log to show generated SQL. db.Log = Console.Out; // Query for customers in London. IQueryable <Purchase> purchaseQuery = from purch in Purchase select purch; var json = new Object(); foreach (Purchase purch in purchaseQuery) { json = new JavaScriptSerializer().Serialize(purch); result.Add(purch); } // Prevent console window from closing. return(result.ToJSON()); }
public static string ListOfSales() { DataContext db = new DataContext("Database=SalesDB;Server=DESKTOP-6GQP7S7\\SQLEXPRESS;Integrated Security=SSPI"); List <Object> result = new List <Object>(); // Get a typed table to run queries. Table <Sales> Sales = db.GetTable <Sales>(); // Attach the log to show generated SQL. db.Log = Console.Out; // Query for customers in London. IQueryable <Sales> SalesQuery = from x in Sales select x; var json = new Object(); foreach (Sales x in SalesQuery) { json = new JavaScriptSerializer().Serialize(x); result.Add(json); } // Prevent console window from closing. Console.ReadLine(); return(result.ToJSON()); }
public static string ListOfDetector() { DataContext db = new DataContext("Database=InventoryDB;Server=DESKTOP-6GQP7S7\\SQLEXPRESS;Integrated Security=SSPI"); List <Object> result = new List <Object>(); // Get a typed table to run queries. Table <Detector> Detector = db.GetTable <Detector>(); // Query for customers in London. IQueryable <Detector> DetectorQuery = from x in Detector select x; var json = new Object(); foreach (Detector x in DetectorQuery) { json = new JavaScriptSerializer().Serialize(x); result.Add(json); } return(result.ToJSON()); }