protected void LoadOrderSummary(string orderNum)
{
cnDryClean.Open();
string sql = "select c.ClothName, c.ClothCleaningPrice FROM Cloth c " +
"INNER JOIN Orders o ON c.ClothId = o.ClothId WHERE OrderNum = @orderNum";
using (SqlCommand cmd = new SqlCommand(sql, cnDryClean))
{
cmd.Parameters.Add("@orderNum", SqlDbType.VarChar);
cmd.Parameters["@orderNum"].Value = orderNum;
SqlDataReader dr = cmd.ExecuteReader();
ordersTable.Load(dr);
dr.Close();
}
cnDryClean.Close();
OrdersGrid.DataSource = ordersTable;
OrdersGrid.DataBind();
}
protected void dataBind()
{
OrdersGrid.DataSource = (DataTable)Session["SqlDataSource"];
OrdersGrid.DataBind();
}
protected void OrdersGrid_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
OrdersGrid.DataBind();
}
protected void SearchOrders_Click(object sender, EventArgs e)
{
String timeperiod = RadioButtonList1.SelectedValue.ToString();
String status = RadioButtonList3.SelectedValue.ToString();
String sql = "";
String sql2 = "";
conn = new MySqlConnection(GetConnectionString());
if (timeperiod.Equals("By Day"))
{
String temp = DropDownList3.SelectedValue.ToString();
sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where DATE_FORMAT(Date_Time,'%d-%M-%Y') like '" + temp + "'";
}
if (timeperiod.Equals("By Week"))
{
String temp = DropDownList1.SelectedValue.ToString();
sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where WEEK(Date_Time) = " + temp + "";
}
if (timeperiod.Equals("By Month"))
{
String temp = DropDownList2.SelectedValue.ToString();
sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where MONTHNAME(Date_Time) = '" + temp + "'";
}
if (timeperiod.Equals("By Quarter"))
{
String temp = DropDownList4.SelectedValue.ToString();
sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where QUARTER(Date_Time) = " + temp + "";
}
if (timeperiod.Equals("Custom Date"))
{
String date1 = TextBox5.Text;
String date2 = TextBox6.Text;
sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where DATE(Date_Time) BETWEEN '" + date1 + "' AND '" + date2 + "'";
}
if (status.Equals("") || status.Equals("All"))
{
sql2 = "";
}
if (status.Equals("Received"))
{
sql2 = " and Order_Received='Completed'";
}
if (status.Equals("Pending"))
{
sql2 = " and Order_Received='Pending'";
}
Response.Write(sql + sql2);
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand(sql + sql2, conn);
MySqlDataReader dr1 = comm.ExecuteReader();
OrdersGrid.DataSource = dr1;
OrdersGrid.DataBind();
dr1.Close();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
}
