File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/Printdoc/salechangesoprint.aspx.cs
Back
using System; using System.Data; using System.Data.SqlClient; using System.Web.UI; using WebApp.LIBS; using Business; using System.Configuration; namespace WebApp.admin.Printdoc { public partial class salechangesoprint : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) { int EditId = Request.QueryString["id"].ConvertInt(); FetchSaleData(EditId); } } } private void FetchSaleData(int saleId) { string connString = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); string query = "SELECT s.InvoiceNo, s.Date, c.CustomerName, SUM(si.Quantity) AS TotalQuantity " + "FROM Sale s " + "JOIN Customer c ON s.CustomerId = c.CustomerId " + "JOIN SaleItem si ON s.SaleId = si.SaleId " + "WHERE s.SaleId = @SaleId " + "GROUP BY s.InvoiceNo, s.Date, c.CustomerName"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@SaleId", saleId); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { GSTNO.Text = SiteSession.CompnayName.GSTNO; CompnayName.Text = SiteSession.CompnayName.CompnayName; AddressData.Text = SiteSession.CompnayName.Address; Phono.Text = SiteSession.CompnayName.PhoneNo.Replace("~", "<br/>"); InvoiceNo.Text = reader["InvoiceNo"].ToString(); InvoiceDate.Text = Convert.ToDateTime(reader["Date"]).ToString("dd/MM/yyyy"); CustomerId.Text = reader["CustomerName"].ToString(); TotalSaman.Text = reader["TotalQuantity"].ToString(); } } } string itemQuery = "SELECT si.*, b.BrandName, w.WeightName, w.Kg AS Weightkg " + "FROM SaleItem si " + "JOIN Brand b ON si.BrandId = b.BrandId " + "JOIN Weight w ON si.WeightId = w.WeightId " + "WHERE si.SaleId = @SaleId"; using (SqlCommand cmd = new SqlCommand(itemQuery, conn)) { cmd.Parameters.AddWithValue("@SaleId", saleId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); LoopItem.DataSource = dt; LoopItem.DataBind(); } } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings