protected void View_Click(object sender, EventArgs e)
{
conn = new MySqlConnection(GetConnectionString());
String orderid = TextBox8.Text;
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("Select Order_ID,Amount,Quantity,Date_Time from Order_Detail_Store where Order_ID='" + orderid + "'", conn);
MySqlDataReader dr1 = comm.ExecuteReader();
OrderStatus1.DataSource = dr1;
OrderStatus1.DataBind();
dr1.Close();
comm.CommandText = "Select Order_Made,Order_Ready,Order_Dispatch,Order_Received from Order_Detail_Store where Order_ID='" + orderid + "'";
dr1 = comm.ExecuteReader();
OrderStatus2.DataSource = dr1;
OrderStatus2.DataBind();
dr1.Close();
comm.CommandText = "Select p.Product_ID,p.Company_Name,p.Product_Name,o.Quantity,o.Amount from Master_Products p, Order_Product_Store o where o.Product_ID = p.Product_ID";
dr1 = comm.ExecuteReader();
OrderProductsGrid.DataSource = dr1;
OrderProductsGrid.DataBind();
dr1.Close();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
TextBox8.Text = "";
}
//public OrderStatus GetOrderStatus(OrderStatus orderstatus)
//{
// string fetchOrderStatus = $"SELECT * FROM Mobifix_DB.ORDER_STATUS WHERE LOWER (ORDER_STATUS_ID) = '{ orderstatus.OrderStatusID.ToString() }'";
// var dtResult = MySqlOrderStatusHelper.ExecuteQuery(fetchOrderStatus);
// var getorderstatus = FillOrderStatusModel(dtResult);
// return getorderstatus.FirstOrDefault<OrderStatus>();
//}
public OrderStatus1 GetOrderStatus(OrderStatus1 orderstatus)
{
//string fetchOrderStatus = $"SELECT * FROM Mobifix_DB.ORDER_STATUS WHERE LOWER (ORDER_STATUS_ID) = '{ orderstatus.OrderStatusID.ToString() }'";
string fetchOrderStatus = $"SELECT ORDER_ID, ORDER_PLACED_DATE, ESTIMIATED_DATE_OF_DELIVER, ORDER_STATUS_DESC FROM Mobifix_DB.ORDER_TABLE ot INNER JOIN ORDER_STATUS os ON ot.ORDER_ID = os.FK_ORDER_ID WHERE LOWER (ORDER_ID) = '{ orderstatus.OrderID.ToString() }'";
var dtResult = MySqlOrderStatusHelper.ExecuteQuery(fetchOrderStatus);
var getorderstatus = FillOrderStatus1Model(dtResult);
return(getorderstatus.FirstOrDefault <OrderStatus1>());
}
private IList <OrderStatus1> FillOrderStatus1Model(DataTable dtOrderStatus1)
{
var orderstatus1List = new List <OrderStatus1>();
if (null != dtOrderStatus1 && dtOrderStatus1.Rows.Count > 0)
{
foreach (DataRow row in dtOrderStatus1.Rows)
{
var orderstatus1 = new OrderStatus1();
orderstatus1.OrderID = Convert.ToInt32(row["ORDER_ID"]);
OrderStatusDesc OrderStatus1;
if (Enum.TryParse <OrderStatusDesc>(row["ORDER_STATUS_DESC"].ToString(), out OrderStatus1))
{
orderstatus1.OrderstatusDesc = OrderStatus1.ToString();
}
orderstatus1.OrderstatusDesc = Convert.ToString(row["ORDER_STATUS_DESC"]);
orderstatus1.OrderDate = Convert.ToDateTime(row["ORDER_PLACED_DATE"]);
orderstatus1.ExpectedDate = Convert.ToDateTime(row["ESTIMIATED_DATE_OF_DELIVER"]);
orderstatus1List.Add(orderstatus1);
}
}
return(orderstatus1List);
}
