How to call your method inside another method in ASP.NET mvc5?

Question

0.00/5 (No votes)

See more:

Hi Team

I have a ActionResult method and its using [HttpGet] and another with [Httpost], now the challenge is to find a way to call the method that will allow my download functionality to work on View. Meaning i have a button, but the button functionality from the View is to download the record of my table. How do i achieve this using this below attempt logic? I have tried to use separate View to access that method, i was not successful

What I have tried:

C#

<pre>  [HttpGet]
        public ActionResult SearchPeopleDetails()
        {

            RegCoursesViewModel regCoursesView = new RegCoursesViewModel();
            return View(cb.RegPeopleLists.ToList());
        }


        [HttpPost]
        public ActionResult SearchPeopleDetails(RegCoursesViewModel eNtsaRegistration_2)
        {
            if(ModelState.IsValid)
            {
                eNtsaRegistration_2.regPeopleLists.LoginID = Int32.Parse("SearchValue");
                cb.RegPeopleLists.Add(eNtsaRegistration_2.regPeopleLists);
                cb.SaveChanges();
                return RedirectToAction("Download_DelegateReportData");
            }
            return RedirectToAction("Download_DelegateReportData");
        }

[HttpGet]
      public ActionResult Download_DelegateReport()
  {
      RegCoursesViewModel regCoursesView = new RegCoursesViewModel();

      return View(regCoursesView);
  }

//Downloading the Delegate-Information as Excel-Report.

        public void Download_DelegateReportData()
        {
            var _cb = new eNtsaRegistration_2();

            var data = (from q in _cb.RegPeopleLists
                        select new { 
                        LoginID = q.LoginID,
                        Name = q.Name,
                        SSID = q.SISID,
                        Role = q.Role,
                        LastActivity = q.LastActivity,
                        TotalActivity = q.TotalActivity

                        }).ToList();
            var b = ConvertToDataTable(data);
            string attachment = "attachment; filename=eNtsaTraining-Registration.xls";
            Response.ClearContent();
            Response.AddHeader("content-disposition", attachment);
            Response.ContentType = "application/vnd.ms-excel";
            string tb = "";

            foreach (DataColumn dc in b.Columns)
            {
                Response.Write(tb + dc.ColumnName);
                tb = "\t";
            }
            Response.Write("\n");
            int i;
            foreach (DataRow dr in b.Rows)
            {
                tb = "";
                for (i = 0; i < b.Columns.Count; i++)
                {
                    Response.Write(b + dr[i].ToString());
                    tb = "\t";
                }
                Response.Write("\n");
            }
            Response.End();
        }

Posted 22-Sep-20 4:01am

gcogco10

Updated 22-Sep-20 4:15am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2020-09-22T04:15:00

Download_DelegateReportData is not an action, so you cannot redirect to it.

You should also avoid using Response.Write inside an action method. Use an appropriate action result instead.

And you're not sending an Excel file; you're sending a tab-separated values file. You need to use the correct MIME type.

C#

[HttpGet]
public ActionResult Download_DelegateReportData()
{
    using (var cb = new eNtsaRegistration_2())
    {
        var data = (from ... ).ToList();
        var b = ConvertToDataTable(data);
        
        var ms = new MemoryStream();
        using (var writer = new StreamWriter(ms))
        {
            writer.WriteLine(string.Join("\t", b.Columns.Cast<DataColumn>().Select(c => c.ColumnName)));
            foreach (DataRow dr in b.Rows)
            {
                writer.WriteLine(string.Join("\t", dr.ItemArray));
            }
        }
        
        ms.Seek(0L, SeekOrigin.Begin);
        return new FileStreamResult(ms, "text/tab-separated-values") 
        {
            FileDownloadName = "eNtsaTraining-Registration.tsv"
        };
    }
}