public DashBoardDetailsOutputDTO GetDashBoardDetails(DashBoardInputDTO dashboardInput)
{
DataTable sendResponse = new DataTable();
DashBoardDetailsOutputDTO response = new DashBoardDetailsOutputDTO();
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("spGetDashBoardDetails", con))
{
cmd.CommandType = CommandType.StoredProcedure;
if (dashboardInput != null)
{
SqlParameter tvpParam = cmd.Parameters.AddWithValue("@FromDate", dashboardInput.FromDate);
tvpParam.SqlDbType = SqlDbType.DateTime;
SqlParameter tvparam1 = cmd.Parameters.AddWithValue("@ToDate", dashboardInput.ToDate);
tvparam1.SqlDbType = SqlDbType.DateTime;
}
else
{
SqlParameter tvpParam = cmd.Parameters.AddWithValue("@FromDate", DBNull.Value);
tvpParam.SqlDbType = SqlDbType.DateTime;
SqlParameter tvparam1 = cmd.Parameters.AddWithValue("@ToDate", DBNull.Value);
tvparam1.SqlDbType = SqlDbType.DateTime;
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
da.Fill(ds);
//sendResponse = ds.Tables[0]; // Create
//sendResponse.Merge(ds.Tables[1]);
response.OffersRaised = ds.Tables[0];
response.OffersAccepted = ds.Tables[1];
response.OffersRemoved = ds.Tables[2];
response.VisitedCustomers = ds.Tables[3];
response.TotalNumberOfCustomers = ds.Tables[4];
response.NumberOfTruflRestaurants = ds.Tables[5];
response.RestaurantDetails = ds.Tables[6];
}
}
}
}
catch (Exception ex)
{
ExceptionLogger.WriteToErrorLogFile(ex);
}
//return sendResponse;
return(response);
}
public object GetDashBoardDetails(DashBoardInputDTO dashboardInput)
{
DashBoardDetailsOutputDTO res = new DashBoardDetailsOutputDTO();
res = _adminBL.GetDashBoardDetails(dashboardInput);
try
{
return(Json(new JsonResponseResult {
_ErrorCode = TruflConstants._ErrorCodeSuccess, _Data = res, _StatusCode = TruflConstants._StatusCodeOK, _StatusMessage = TruflConstants._StatusMessageSuccess
}));
}
catch (Exception ex)
{
return(Json(new JsonResponseResult {
_ErrorCode = TruflConstants._ErrorCodeFailed, _Data = ex.ToString(), _StatusCode = TruflConstants._StatusCodeFailed, _StatusMessage = TruflConstants._StatusMessageFailed
}));
}
}