File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/admin/Expiry_Report.aspx.cs
Back
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; using WebApp.LIBS; namespace VGM.admin { public partial class Expiry_Report : BasePageClass { SqlDataAdapter da, da1; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { string query = "SELECT P.*, M.Medicine_name " + "FROM purchase AS P " + "INNER JOIN medicine AS M ON P.ID = M.ID"; using (SqlCommand cmd = new SqlCommand(query, con)) { con.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); da.Fill(dt); Gridview1.DataSource = dt; Gridview1.DataBind(); } } } } } protected void show_Click(object sender, EventArgs e) { try { string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { con.Open(); DateTime currentDate = DateTime.Now; string query = "SELECT P.*, M.Medicine_name " + "FROM purchase AS P " + "INNER JOIN medicine AS M ON P.ID = M.ID "; if (radio1.Checked) { // Show expired items (items whose expiry date has already passed) query += "WHERE P.Expiry_date < @CurrentDate"; } else if (radio2.Checked) { // Show items expiring in 1 month DateTime oneMonthFromNow = currentDate.AddMonths(1); query += "WHERE P.Expiry_date >= @CurrentDate AND P.Expiry_date < @OneMonthFromNow"; } else if (radio3.Checked) { // Show items expiring exactly 3 months from the current date DateTime threeMonthsFromNow = currentDate.AddMonths(3); query += "WHERE P.Expiry_date = @ThreeMonthsFromNow"; } else if (radio4.Checked) { // Show items expiring exactly 6 months from the current date DateTime sixMonthsFromNow = currentDate.AddMonths(6); query += "WHERE P.Expiry_date = @SixMonthsFromNow"; } using (SqlCommand cmd = new SqlCommand(query, con)) { cmd.Parameters.AddWithValue("@CurrentDate", currentDate); if (radio2.Checked) { DateTime oneMonthFromNow = currentDate.AddMonths(1); cmd.Parameters.AddWithValue("@OneMonthFromNow", oneMonthFromNow); } if (radio3.Checked) { DateTime threeMonthsFromNow = currentDate.AddMonths(3); cmd.Parameters.AddWithValue("@ThreeMonthsFromNow", threeMonthsFromNow); } if (radio4.Checked) { DateTime sixMonthsFromNow = currentDate.AddMonths(6); cmd.Parameters.AddWithValue("@SixMonthsFromNow", sixMonthsFromNow); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); da.Fill(dt); Gridview1.DataSource = dt; Gridview1.DataBind(); } } } } catch(Exception ex) { Response.Write("<script>alert('An error occurred: " + ex.Message + "')</script>"); } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings