public ExpOrderDetails getExpOrderDetails(int orderNo)
{
ExpOrderDetails orderDetails = null;
string Name, Gender, Address, PostalCode, HP, Email, ServiceDesc, Timeslot, Date, ServiceType, Image;
decimal Price;
int OrderNo;
string queryStr = "SELECT * FROM OrderDetails WHERE OrderNo = @OrderNO";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
cmd.Parameters.AddWithValue("@OrderNo", orderNo);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
OrderNo = int.Parse(dr["OrderNo"].ToString());
Name = dr["Name"].ToString();
Address = dr["Address"].ToString();
PostalCode = dr["PostalCode"].ToString();
ServiceDesc = dr["ServiceDesc"].ToString();
//Prod_Image = dr["Product_Image"].ToString();
//Price = decimal.Parse(dr["Price"].ToString());
Price = 15;
Gender = dr["Gender"].ToString();
HP = dr["HP"].ToString();
Email = dr["Email"].ToString();
//Timeslot = dr["Timeslot"].ToString();
Timeslot = "11:00-13:00";
Date = dr["Date"].ToString();
ServiceType = dr["ServiceType"].ToString();
Image = dr["Image"].ToString();
orderDetails = new ExpOrderDetails(OrderNo, Name, Gender, Address, PostalCode, HP, Email, ServiceDesc, Timeslot, Price, Date, ServiceType, Image);
}
else
{
orderDetails = null;
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderDetails);
}
public List <ExpOrderDetails> getExpOrderDetailsAll()
{
List <ExpOrderDetails> orderDetailsList = new List <ExpOrderDetails>();
string Name, Gender, Address, PostalCode, HP, Email, ServiceDesc, Timeslot, Date, ServiceType, Image;
decimal Price;
int OrderNo;
string queryStr = "SELECT * FROM OrderDetails Order By OrderNo";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
OrderNo = int.Parse(dr["OrderNo"].ToString());
Name = dr["Name"].ToString();
Address = dr["Address"].ToString();
PostalCode = dr["PostalCode"].ToString();
ServiceDesc = dr["ServiceDesc"].ToString();
//Price = decimal.Parse(dr["Price"].ToString());
Price = 15;
Gender = dr["Gender"].ToString();
HP = dr["HP"].ToString();
Email = dr["Email"].ToString();
Timeslot = dr["Timeslot"].ToString();
Date = dr["Date"].ToString();
ServiceType = dr["ServiceType"].ToString();
Image = dr["Image"].ToString();
ExpOrderDetails od = new ExpOrderDetails(OrderNo, Name, Gender, Address, PostalCode, HP, Email, ServiceDesc, Timeslot, Price, Date, ServiceType, Image);
orderDetailsList.Add(od);
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderDetailsList);
}
