API using htpResponseMessage

Hi Ramco,

1. Install the necessary NuGet packages for Entity Framework Core and the database provider you are using (e.g. Microsoft.EntityFrameworkCore.SqlServer).
2. Create a database context class that inherits from DbContext and configure the connection string to your database in the OnConfiguring method. You can also create entity classes that correspond to the views in your database and define their properties.
3. In the controller class, inject an instance of the database context class into the constructor.
4. Create a new action method in the controller that returns an HttpResponseMessage object. In the action method, you can use the database context to execute the LINQ query shown in your code. The query will return a list of anonymous objects, which you can convert to a list of a custom DTO (data transfer object) using the SELECT LINQ operator.
5. Use the Ok method of the HttpResponseMessage object to return the list of DTOs to the client as the HTTP response, along with a status code of 200 (OK).

Based on your problem you can use below code :-

[HttpGet]
public HttpResponseMessage GetData(DateTime frDate, DateTime toDate, string ddlDeliveryStatus) {
  var result = (from t in context.ViewSessionDeliveryCalendarDetailsStudents join t2 in context.ViewBookDetails on t.BookID equals t2.ID where t.CurrentStatus == "Due" &&
    t.SessionDate.Value.Date >= frDate &&
    t.SessionDate.Value.Date <= toDate &&
    (ddlDeliveryStatus != "" ? t.BookDeliveryStatus == ddlDeliveryStatus.SelectedValue : 1 == 1) orderby t.Name select new {
      t.GroupName,
        t.SessionDate,
        t.BookTitle,
        t2.AmazoName,
        t2.AmazonURL,
        GrpName = t.SessionType == "Regular" ? t.GroupName : t.LeadNumber
    }).ToList();

  var data = result.Select(x => new CustomDto {
    GroupName = x.GroupName,
      SessionDate = x.SessionDate,
      BookTitle = x.BookTitle,
      AmazoName = x.AmazoName,
      AmazonURL = x.AmazonURL
  }).ToList();

  return Request.CreateResponse(HttpStatusCode.OK, data);
}