public JsonResult GetHotListContacts()
{
var dropdownValues = cachingService.GetDropdownValues(this.Identity.ToAccountID());
ReportViewModel viewModel = new ReportViewModel
{
CustomStartDate = DateTime.Now.ToUniversalTime().AddDays(-30),
CustomEndDate = DateTime.Now.ToUniversalTime(),
PageNumber = 1,
ShowTop = 10
};
var lifecycleStages = dropdownValues.Where(s => s.DropdownID == (byte)DropdownFieldTypes.LifeCycle)
.Select(s => s.DropdownValuesList).ToList().FirstOrDefault().Where(d => d.IsActive == true).Select(d => d.DropdownValueID).ToArray();
viewModel.LifeStageIds = lifecycleStages;
ReportDataResponse response = reportService.GetHotListData(new ReportDataRequest
{
ReportViewModel = viewModel,
AccountId = this.Identity.ToAccountID(),
UserId = this.Identity.ToUserID(),
RoleId = this.Identity.ToRoleID(),
IsSTAdmin = this.Identity.IsSTAdmin(),
IsDasboardView = true
});
response.ReportId = GetReportId(Reports.HotList);
response.HotlistGridData.Contacts = response.ContactIds = new List <int>();
return(Json(new { success = true, response = response }, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage GetHotListLeads()
{
var dropdownValues = cachingService.GetDropdownValues(this.AccountId);
ReportViewModel viewModel = new ReportViewModel
{
CustomStartDate = DateTime.Now.ToUniversalTime().AddDays(-30),
CustomEndDate = DateTime.Now.ToUniversalTime(),
PageNumber = 1,
ShowTop = 10
};
var lifecycleStages = dropdownValues.Where(s => s.DropdownID == (byte)DropdownFieldTypes.LifeCycle)
.Select(s => s.DropdownValuesList).ToList().FirstOrDefault().Where(d => d.IsActive == true).Select(d => d.DropdownValueID).ToArray();
viewModel.LifeStageIds = lifecycleStages;
ReportDataResponse response = reportService.GetHotListData(new ReportDataRequest
{
ReportViewModel = viewModel,
AccountId = this.AccountId,
UserId = this.UserId,
RoleId = this.RoleId,
IsSTAdmin = this.IsSTAdmin,
IsDasboardView = true
});
response.ReportId = GetReportId(Reports.HotList);
response.HotlistGridData.Contacts = response.ContactIds = new List <int>();
return(Request.BuildResponse(response));
}
public HttpResponseMessage RunHotList(ReportViewModel viewmodel)
{
if (viewmodel.PeriodId != 7)
{
viewmodel.CustomStartDate = ToUserUtcDateTime(viewmodel.CustomStartDate);
viewmodel.CustomEndDate = ToUserUtcDateTime(viewmodel.CustomEndDate);
}
ReportDataResponse response = reportService.GetHotListData(new ReportDataRequest
{
ReportViewModel = viewmodel,
AccountId = this.AccountId,
RoleId = this.RoleId,
RequestedBy = this.UserId,
UserId = this.UserId,
IsDasboardView = false
});
// UpdateLastRunActivity(viewmodel.ReportId, viewmodel.ReportName);
//Guid guid = Guid.NewGuid();
//ViewBag.Guid = guid.ToString();
//if (response.ContactIds != null)
//{
// AddCookie("ContactsGuid", guid.ToString(), 1);
// var contactIds = response.ContactIds;
// cachingService.StoreSavedSearchContactIds(guid.ToString(), contactIds);
//}
return(Request.BuildResponse(response));
}
public HttpResponseMessage GetContacts(ReportViewModel viewmodel)
{
viewmodel.CustomStartDate = viewmodel.CustomStartDate != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomStartDate) : DateTime.MinValue;
viewmodel.CustomEndDate = ToUserUtcDateTime(viewmodel.CustomEndDate);
if (viewmodel.ReportType != Reports.FirstLeadSourceReport && viewmodel.ReportType != Reports.AllLeadSourceReport && viewmodel.ReportType != Reports.DatabaseLifeCycleReport)
{
viewmodel.CustomStartDatePrev = viewmodel.CustomStartDatePrev != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomStartDatePrev) : DateTime.MinValue;
viewmodel.CustomEndDatePrev = viewmodel.CustomEndDatePrev != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomEndDatePrev) : DateTime.MaxValue;
}
ReportDataRequest request = new ReportDataRequest()
{
ReportViewModel = viewmodel,
AccountId = this.AccountId,
RequestedBy = this.UserId,
RoleId = this.RoleId,
IsSTAdmin = this.IsSTAdmin
};
ReportDataResponse response = new ReportDataResponse();
if (viewmodel.Type == 'T')
{
response = reportService.GetTrafficByTypeContacts(request);
}
else if (viewmodel.Type == 'P')
{
response = reportService.GetOpportunityPipelineContacts(request);
}
else if (viewmodel.Type == 'S')
{
response = reportService.GetTrafficBySourceContacts(request);
}
else if (viewmodel.Type == 'L')
{
response = reportService.GetTrafficByLifeCycleContacts(request);
}
else if (viewmodel.Type == 'C')
{
response = reportService.GetTrafficByTypeAndLifeCycleContacts(request);
}
else if (viewmodel.Type == 'A' && (viewmodel.ActivityModule == "Contacts" || viewmodel.ActivityModule == "Tours" || viewmodel.ActivityModule == "Notes"))
{
request.ModuleId = viewmodel.ActivityModule == "Contacts" ? (byte)AppModules.Contacts : viewmodel.ActivityModule == "Tours" ? (byte)AppModules.ContactTours : (byte)AppModules.ContactNotes;
response = reportService.GetActivityReportContacts(request);
}
else if (viewmodel.ReportType == Reports.FirstLeadSourceReport)
{
response = reportService.FirstLeadSourceReportContacts(request);
}
else if (viewmodel.ReportType == Reports.AllLeadSourceReport)
{
response = reportService.AllLeadSourceReportContacts(request);
}
else if (viewmodel.ReportType == Reports.DatabaseLifeCycleReport)
{
response = reportService.AllDatabaseReportContacts(request);
}
return(Request.BuildResponse(response));
}
private void BindReport(ReportEntity reportEntity, string filter)
{
MemoryStream memStream = new MemoryStream();
StreamWriter writer = new StreamWriter(memStream);
writer.Write(reportEntity.RdlText);
writer.Flush();
memStream.Seek(0, SeekOrigin.Begin);
rvMain.LocalReport.LoadReportDefinition(memStream);
ReportDataResponse rdr = BusinessManager.Execute <ReportDataRequest, ReportDataResponse>(new ReportDataRequest(reportEntity, filter));
foreach (DataTable dt in rdr.Data)
{
rvMain.LocalReport.DataSources.Add(new ReportDataSource(dt.TableName, dt));
}
}
public HttpResponseMessage GetReportData(ReportViewModel viewmodel)
{
viewmodel.CustomStartDate = viewmodel.CustomStartDate != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomStartDate) : DateTime.MinValue;
viewmodel.CustomEndDate = ToUserUtcDateTime(viewmodel.CustomEndDate);
viewmodel.CustomStartDatePrev = viewmodel.CustomStartDatePrev != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomStartDatePrev) : DateTime.MinValue;
viewmodel.CustomEndDatePrev = viewmodel.CustomEndDatePrev != DateTime.MinValue ? ToUserUtcDateTime(viewmodel.CustomEndDatePrev) : DateTime.MinValue;
ReportDataRequest request = new ReportDataRequest()
{
ReportViewModel = viewmodel,
AccountId = this.AccountId,
RequestedBy = this.UserId,
RoleId = this.RoleId
};
ReportDataResponse response = new ReportDataResponse();
if (viewmodel.Type == 'T')
{
response = reportService.GetTrafficByTypeData(request);
}
if (viewmodel.Type == 'P')
{
response = reportService.GetOpportunityPipeline(request);
}
if (viewmodel.Type == 'S')
{
response = reportService.GetTrafficBySourceData(request);
}
if (viewmodel.Type == 'L')
{
response = reportService.GetTrafficByLifeCycleData(request);
}
if (viewmodel.Type == 'A')
{
response = reportService.GetActivityData(request);
}
if (viewmodel.Type == 'C')
{
response = reportService.GetTrafficByTypeAndLifeCycleData(request);
}
// UpdateLastRunActivity(viewmodel.ReportId, viewmodel.ReportName);
return(Request.BuildResponse(response));
}
