public List <ReportExcel> GetAllSheetDetail(StoreProcedureName spName, string userId)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var result = connection.Query <ReportExcel>(spName.ToString(), new { UserId = userId }, commandType: CommandType.StoredProcedure);
var allSheetDetail = result.ToList();
var aa = allSheetDetail.GroupBy(q => q.masId).Where(p => p.Count() < 112);
foreach (var a in aa)
{
{
for (int i = 1; i < 113; i++)
{
if (!a.Any(q => q.QuestionId == i))
{
connection.Execute(
"insert into dbo.QuestionSheetDetail(masterId,questionId,SelectOptionId)values(@masterId,@questionId,@selectOption)",
new { masterId = a.Key, questionId = i, selectOption = -1 });
}
}
}
}
return(allSheetDetail);
}
}
public List <VM_AttituteViewReportMain> GetReport21(StoreProcedureName spName, string userId)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var result = connection.Query <VM_AttituteViewReportMain>(spName.ToString(), new { UserId = userId }, commandType: CommandType.StoredProcedure);
return(result.ToList());
}
}
public List <FrequencyBaseViewReport> GetReport(StoreProcedureName spName, string userId)
{
try
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var result = connection.Query <FrequencyBaseViewReport>(spName.ToString(), new { UserId = userId }, commandType: CommandType.StoredProcedure);
return(result.ToList());
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}