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")); }