<%@ Page Language="C#" AutoEventWireup="true" Inherits="System.Web.UI.Page" %> <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Configuration" %> <%@ Import Namespace="System.Web.Script.Serialization" %> <%@ Import Namespace="System.Globalization" %> <% Response.ContentType = "application/json"; string connStr = ConfigurationManager.ConnectionStrings["RestaurantDb"].ConnectionString; using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); string query = "SELECT Num, Name, Tel, Price, TarYY, TarMM, TarDD, [Time] FROM dbo.MoshRoz1"; using (SqlDataAdapter da = new SqlDataAdapter(query, conn)) { DataTable dt = new DataTable(); da.Fill(dt); var invoices = new System.Collections.Generic.List(); DateTime utcNow = DateTime.UtcNow; CultureInfo invariantCulture = CultureInfo.InvariantCulture; foreach (DataRow row in dt.Rows) { invoices.Add(new { Num = row["Num"].ToString(), Name = row["Name"].ToString(), Tel = row["Tel"].ToString(), Price = Convert.ToDecimal(row["Price"]), DateGregorian = utcNow.ToString("yyyy-MM-dd", invariantCulture), PersianDate = row["TarYY"].ToString() + "/" + row["TarMM"].ToString() + "/" + row["TarDD"].ToString(), Time = row["Time"].ToString() }); } JavaScriptSerializer js = new JavaScriptSerializer(); Response.Write(js.Serialize(invoices)); } } %>