protected void Search_Click(object sender, EventArgs e)
{
try
{
OrderRequestBE obj = new OrderRequestBE();
if (!string.IsNullOrWhiteSpace(txtCustomerId.Text))
{
obj.CustomerId = Convert.ToInt32(txtCustomerId.Text.Trim());
}
obj.CustomerTypeId = CustomerTypeUserControl1.SelectedValue;
if (!string.IsNullOrWhiteSpace(txtOrderDate.Text))
{
obj.OrderDate = Convert.ToDateTime(txtOrderDate.Text);
}
gvwOrder.DataSource = _orderBA.GetAllOrder(obj);
gvwOrder.DataBind();
}
catch (Exception ex)
{
lblError0.Text = ex.ToString();
}
}
public List <OrderResponseBE> GetAllOrder(OrderRequestBE obj)
{
try
{
return(_orderDA.GetAllOrder(obj));
}
catch (Exception)
{
throw;
}
}
public List <OrderResponseBE> GetAllOrder(OrderRequestBE obj)
{
List <OrderResponseBE> orders = new List <OrderResponseBE>();
using (_connection = new SqlConnection(_connectionString))
{
//var query = "SELECT c.*, ct.CustomerTypeName FROM Customer c " +
// "INNER JOIN CustomerType ct " +
// "ON c.CustomerTypeId = ct.CustomerTypeId";
//var query = "SELECT [Order].OrderId, [Order].OrderDate, Customer.FirstName, Customer.LastName, CustomerType.CustomerTypeName, ( OrderDetail.UnitPrice* OrderDetail.Quantity ) AS TotalAmount " +
// "FROM (((( Customer INNER JOIN CustomerType ON Customer.CustomerTypeId = CustomerType.CustomerTypeId ) " +
// "INNER JOIN [Order] ON Customer.CustomerId = [Order].CustomerId ) " +
// "INNER JOIN OrderDetail ON[Order].OrderId= OrderDetail.ProductId )) " +
// "WHERE Customer.CustomerId = @customerId AND CustomerType.CustomerTypeId = @customerTypeId AND [Order].OrderDate = @orderDate";
//SqlCommand command = new SqlCommand(query, _connection);
//Connection to db passing stored procedure name
SqlCommand command = new SqlCommand("usp_OrderDetailsOfCustomer", _connection);
//command.CommandText = "usp_OrderDetailsOfCustomer";
command.CommandType = CommandType.StoredProcedure;
//InputParameters
command.Parameters.AddWithValue("@customerId", obj.CustomerId);
command.Parameters.AddWithValue("@customerTypeId", obj.CustomerTypeId);
command.Parameters.AddWithValue("@orderDate", obj.OrderDate);
try
{
_connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
OrderResponseBE order = new OrderResponseBE();
order.OrderId = Convert.ToInt32(reader["OrderId"]);
order.OrderDate = Convert.ToDateTime(reader["OrderDate"]);
order.FirstName = Convert.ToString(reader["FirstName"]);
order.LastName = Convert.ToString(reader["LastName"]);
order.CustomerTypeName = Convert.ToString(reader["CustomerTypeName"]);
order.TotalAmount = Convert.ToDouble(reader["TotalAmount"]);
//Adding object to the list
orders.Add(order);
}
reader.Close();
return(orders);
}
catch (Exception)
{
throw;
}
}
}
