public ActionResult Response()
{
try
{
//var FormId = Convert.ToInt32(Session["FormId"].ToString());
List <ResponseFormModal> form = new List <ResponseFormModal>();
//var FormItem = db.ResponseForms.Where(x=>x.FormId==FormId).ToList();
var FormItem = db.ResponseForms.ToList();
if (FormItem.Count > 0)
{
foreach (var item in FormItem)
{
ResponseFormModal displayform = new ResponseFormModal();
displayform.ResponseFormID = item.ResponseFormID;
displayform.FormName = item.FormName;
displayform.UserEmail = item.UserEmail;
displayform.Name = item.Name;
displayform.FormId = item.FormId;
form.Add(displayform);
}
}
return(PartialView(form));
}
catch (Exception e)
{
throw e;
}
}
public ActionResult ExporttoExcel(int FormId)
{
List <ResponseFormModal> ResponseFormModalList = new List <ResponseFormModal>();
var data = db.ResponseForms.Where(x => x.FormId == FormId).ToList();
if (data.Count > 0)
{
foreach (var item in data)
{
ResponseFormModal rm = new ResponseFormModal();
rm.ResponseFormID = item.ResponseFormID;
rm.FormId = item.FormId;
rm.FormName = item.FormName;
rm.UserEmail = item.UserEmail;
rm.Name = item.Name;
ResponseFormModalList.Add(rm);
}
}
MemoryStream ms = new MemoryStream(ExportToExcel(ResponseFormModalList));
return(File(ms, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"));
}
