HiI have implemented in an form to upload a file in my project MVC asp net cUpload the file is not mandatoryMy problemwhen dont upload file I have confirmation that the values of form they where stored on databaseIf I upload file instead I dont have confirmation that the values of form they where stored on database despite the fact that the values are registered in the databaseHow to do resolve thisviewltscript type34textjavascript34gt function var msg 39

Display (Show) Success Message after record inserted using TempData in ASP.Net MVC

comunida...

SOLVED CLOSED ACTIVE ANSWERED
User: comunidadmexicanaroma
Posted: on May 28, 2021 06:59 AM
Forum: ASP.Net MVC
Answer: 1
Views: 15662
Sample Code: Download

Hi,

I have implemented in an form to upload a file in my project MVC asp net c#

Upload the file is not mandatory.

My problem:

when don't upload file I have confirmation that the values of form they where stored on database
If I upload file instead I don't have confirmation that the values of form they where stored on database, despite the fact that the values are registered in the database

How to do resolve this?

view

<script type="text/javascript">
    $(function () {
        var msg = '@ViewData["result"]';
        console.log(msg);
          if (msg > 0)
          {
              alert("Ok");
              var url = "@Url.Action("Index", "Home")";
              window.location.href = url;
          }
});
</script>

controller

[HttpPost]
public ActionResult Index(PersonModel person, HttpPostedFileBase file)
{

    if (file != null && file.ContentLength > 0)
    {
        var fileName = System.IO.Path.GetFileNameWithoutExtension(file.FileName);
        var fileExtension = System.IO.Path.GetExtension(file.FileName);

        if (fileExtension.ToString() == ".jpeg" ||
                    fileExtension.ToString() == ".jpg" ||
                    fileExtension.ToString() == ".gif" ||
                    fileExtension.ToString() == ".png")
        {
            fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "_" + fileName.Trim() + fileExtension;
            var userfolderpath = System.IO.Path.Combine(Server.MapPath("~/UploadedFiles/"), fileName);
            file.SaveAs(userfolderpath);

            MTsqlinsert(person);
        }
        else
        {
            TempData["Message"] = "Please upload only image (jpg,gif,png)";
        }
    }
    else
    {
        MTsqlinsert(person);
    }

    if (ModelState.IsValid)
    {
        return View(person);
    }

    return View(person);
}
    private void MTsqlinsert(PersonModel person)
    {
        try
        {
            string constr = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;

            using (MySqlConnection con =
                new MySqlConnection(constr))
            {
                using (MySqlCommand command =
                    new MySqlCommand("SP", con))
                {
                    command.Connection = con;
                    command.CommandType = CommandType.StoredProcedure;
                    con.Open();
                    ViewData["result"] = command.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
        catch (Exception ex)
        {
            string message = string.Format("<b>Message:</b> {0}<br /><br />", ex.Message);
            message += string.Format("<b>StackTrace:</b> {0}<br /><br />", ex.StackTrace.Replace(Environment.NewLine, string.Empty));
            message += string.Format("<b>Source:</b> {0}<br /><br />", ex.Source.Replace(Environment.NewLine, string.Empty));
            message += string.Format("<b>TargetSite:</b> {0}", ex.TargetSite.ToString().Replace(Environment.NewLine, string.Empty));
            ModelState.AddModelError(string.Empty, message);
        }
    }

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on May 28, 2021 08:06 AM
Modified: on Jun 03, 2021 02:29 AM
Report

Hi comunidadmexi...,

Refer below code.

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Index(PersonModel person, HttpPostedFileBase file)
    {
        if (file != null && file.ContentLength > 0)
        {
            var fileName = System.IO.Path.GetFileNameWithoutExtension(file.FileName);
            string fileExtension = System.IO.Path.GetExtension(file.FileName);
            if (fileExtension.ToLower() == ".jpeg" || fileExtension.ToLower() == ".jpg" ||
                fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
            {
                fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "_" + fileName.Trim() + fileExtension;
                var userfolderpath = System.IO.Path.Combine(Server.MapPath("~/UploadedFiles/"), fileName);
                file.SaveAs(userfolderpath);
                MTsqlinsert(person);
            }
            else
            {
                ViewData["result"] = "Please upload only image (jpg,gif,png)";
            }
        }
        else
        {
            MTsqlinsert(person);
        }

        return View(person);
    }

    private void MTsqlinsert(PersonModel person)
    {
        int result = 0;
        ViewData["result"] = result;

        string constr = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
        using (MySqlConnection con = new MySqlConnection(constr))
        {
            using (MySqlCommand command = new MySqlCommand("SP", con))
            {
                command.Connection = con;
                command.CommandType = CommandType.StoredProcedure;
                try
                {
                    con.Open();
                    result = command.ExecuteNonQuery();
                    ViewData["result"] = result;
                }
                catch (Exception ex)
                {
                    string message = string.Format("<b>Message:</b> {0}<br /><br />", ex.Message);
                    message += string.Format("<b>StackTrace:</b> {0}<br /><br />", ex.StackTrace.Replace(Environment.NewLine, string.Empty));
                    message += string.Format("<b>Source:</b> {0}<br /><br />", ex.Source.Replace(Environment.NewLine, string.Empty));
                    message += string.Format("<b>TargetSite:</b> {0}", ex.TargetSite.ToString().Replace(Environment.NewLine, string.Empty));
                    ModelState.AddModelError(string.Empty, message);
                }
                finally
                {
                    con.Close();
                }
            }
        }
    }
}

View

@model FileUpload_Confirm_Alert_MVC.Models.PersonModel

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
</head>
<body>
    @using (Html.BeginForm("Index", "Home", FormMethod.Post, new { enctype = "multipart/form-data" }))
    {
        <input type="file" name="file" />
        <input type="submit" id="btnUpload" value="Upload" />
    }
    <script type="text/javascript">
        $(function () {
            var msg = '@ViewData["result"]';
            if (msg != null && msg != '') {
                if (msg == "Please upload only image (jpg,gif,png)") {
                    alert(msg);
                } else {
                    if (parseInt(msg) > 0) {
                        alert("Ok");
                    }
                }
            }
        });
    </script>
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display (Show) Success Message after record inserted using TempData in ASP.Net MVC

Company

Explore

Follow us

Contact Us