ASP.NET Discussion Boards

Re: How to Upgrade Publish website page in latest version at Visual Studio 2012

Richard Deeming4-Jul-21 21:36

4-Jul-21 21:36

The version of the "publish" page is linked to the version of Visual Studio. If you want the newer page, you need to upgrade Visual Studio.

VS2019 community edition is free, so there's no reason to continue using such an ancient version:
Visual Studio Community 2019 - Free IDE and Developer Tools[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

HTTPPOST of EditReport not comiting data to database

Carl Cummings (Canada)2-Jul-21 17:34

Carl Cummings (Canada)

2-Jul-21 17:34

Hi All I am new to MVC and EntityFramework and am having a problem getting my form to save changes back to the database.

I have the following model

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Services.Providers;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HAZID.Core.Models
{
    public class HAZID_Forms : HAZID_Base_Entity
    {

        [Display(Name = "HAZID_Workers_Id", ResourceType = typeof(Resources.Resource))]
        [Required(ErrorMessageResourceName = "HAZID_Workers_Id_Error_Msg", ErrorMessageResourceType = typeof(Resources.Resource))]
        public int HAZID_Workers_Id { get; set; }

        [Display(Name = "HAZID_Supervisors_Id", ResourceType = typeof(Resources.Resource))]
        [Required(ErrorMessageResourceName = "HAZID_Supervisor_Id_Error_Msg", ErrorMessageResourceType = typeof(Resources.Resource))]
        public int HAZID_Supervisors_Id { get; set; }

        [Display(Name = "HAZID_Form_DateTime", ResourceType = typeof(Resources.Resource))]
        public DateTime HAZID_Form_DateTime { get; set; }

        [Display(Name = "HAZID_District_Id", ResourceType = typeof(Resources.Resource))]
        [Required(ErrorMessageResourceName = "HAZID_District_Id_Error_Msg", ErrorMessageResourceType = typeof(Resources.Resource))]
        public int HAZID_District_Id { get; set; }

        [Display(Name = "HAZID_Hazard_Location", ResourceType = typeof(Resources.Resource))]
        [DataType(DataType.MultilineText)]
        [Required(ErrorMessageResourceName = "HAZID_Hazard_Location_Error_Msg", ErrorMessageResourceType = typeof(Resources.Resource))]
        public string HAZID_Hazard_Location { get; set; }

        [Display(Name = "HAZID_Hazard_Description", ResourceType = typeof(Resources.Resource))]
        [DataType(DataType.MultilineText)]
        [Required(ErrorMessageResourceName = "HAZID_Hazard_Description_Error_Msg", ErrorMessageResourceType = typeof(Resources.Resource))]
        public string HAZID_Hazard_Description { get; set; }
        public string HAZID_Hazard_Description_Short { get { return HAZID_Hazard_Description.ToString().SubStringTo(30); } }

        [Display(Name = "HAZID_Workers_Suggstion", ResourceType = typeof(Resources.Resource))]
        [DataType(DataType.MultilineText)]
        public string HAZID_Workers_Suggstion { get; set; }
        public string HAZID_Workers_Suggstion_Short { get { return HAZID_Workers_Suggstion.ToString().SubStringTo(30); } }

        [Display(Name = "HAZID_Position", ResourceType = typeof(Resources.Resource))]
        public string HAZID_Position { get; set; }

        [Display(Name = "HAZID_Status_Id", ResourceType = typeof(Resources.Resource))]
        public int? HAZID_Status_Id { get; set; }

        [Display(Name = "HAZID_Hazard_Type_Id", ResourceType = typeof(Resources.Resource))]
        public int? HAZID_Hazard_Type_Id { get; set; }

        [Display(Name = "HAZID_Control_Description", ResourceType = typeof(Resources.Resource))]
        [DataType(DataType.MultilineText)]
        public string HAZID_Control_Description { get; set; }

        [Display(Name = "HAZID_Person_Responsible_Name", ResourceType = typeof(Resources.Resource))]
        public string HAZID_Person_Responsible_Name { get; set; }

        [Display(Name = "HAZID_Applcability_To_Others_Flag", ResourceType = typeof(Resources.Resource))]
        public bool HAZID_Applcability_To_Others_Flag { get; set; }

        [Display(Name = "HAZID_Risk_Severity_Id", ResourceType = typeof(Resources.Resource))]
        public int? HAZID_Risk_Severity_Id { get; set; }

        [Display(Name = "HAZID_Risk_Probability_Id", ResourceType = typeof(Resources.Resource))]
        public int? HAZID_Risk_Probability_Id { get; set; }

        [Display(Name = "HAZID_Action_Taken", ResourceType = typeof(Resources.Resource))]
        [DataType(DataType.MultilineText)]
        public string HAZID_Action_Taken { get; set; }

    }
}

Two ViewModels

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using HAZID.Core.Models;

namespace HAZID.Core.ViewModels
{
    public class HAZID_Form_View_Model
    {
        public HAZID_Forms HAZID_Form { get; set; }
        public IEnumerable<HAZID_Branch_Districts> HAZID_Branch_Districts { get; set; }
        public IEnumerable<HAZID_Persons> HAZID_Persons { get; set; }
        public IEnumerable<HAZID_Hazard_Types> HAZID_Hazard_Types { get; set; }
        public IEnumerable<HAZID_Risk_Severity_Types> HAZID_Risk_Severity_Types { get; set; }
        public IEnumerable<HAZID_Risk_Probability_Types> HAZID_Risk_Probability_Types { get; set; }
        public IEnumerable<HAZID_Statuses> HAZID_Statuses { get; set; }
    }
}

<pre>using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using HAZID.Core.Models;

namespace HAZID.Core.ViewModels
{
    public class HAZID_Forms_View_Model
    {
        public IEnumerable<HAZID_Forms> HAZID_Forms { get; set; }
        public IEnumerable<HAZID_Branch_Districts> HAZID_Branch_Districts { get; set; }
        public IEnumerable<HAZID_Hazard_Types> HAZID_Hazard_Types { get; set; }
        public IEnumerable<HAZID_Risk_Severity_Types> HAZID_Risk_Severity_Types { get; set; }
        public IEnumerable<HAZID_Risk_Probability_Types> HAZID_Risk_Probability_Types { get; set; }
        public IEnumerable<HAZID_Statuses> HAZID_Statuses { get; set; }
        public IEnumerable<HAZID_Persons> HAZID_Persons { get; set; }
    }
}

The Controller looks like this

using HAZID.Core.Contracts;
using HAZID.Core.Models;
using HAZID.Core.ViewModels;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace HAZID.WebUI.Controllers
{
    public class HAZID_ApplicationController : Controller
    {
        IHAZID_Repository<HAZID_Forms> hazidForms;
        IHAZID_Repository<HAZID_Branch_Districts> hazidBranchDistricts;
        IHAZID_Repository<HAZID_Hazard_Types> hazidHazardTypes;
        IHAZID_Repository<HAZID_Risk_Severity_Types> hazidRiskSeverityTypes;
        IHAZID_Repository<HAZID_Risk_Probability_Types> hazidRiskProbabilityTypes;
        IHAZID_Repository<HAZID_Statuses> hazidStatuses;
        IHAZID_Repository<HAZID_Persons> hazidPersons;

        public HAZID_ApplicationController(IHAZID_Repository<HAZID_Forms> hazidFormContext, IHAZID_Repository<HAZID_Branch_Districts> hazidBranchDistrictContext, 
                                           IHAZID_Repository<HAZID_Hazard_Types> hazidHazardTypeContext, IHAZID_Repository<HAZID_Risk_Severity_Types> hazidRiskSeverityTypeContext,
                                           IHAZID_Repository<HAZID_Risk_Probability_Types> hazidRiskProbabilityTypeContext, IHAZID_Repository<HAZID_Statuses> hazidStatusContext, 
                                           IHAZID_Repository<HAZID_Persons> hazidPersonContext)
        {
            this.hazidForms = hazidFormContext;
            this.hazidBranchDistricts = hazidBranchDistrictContext;
            this.hazidHazardTypes = hazidHazardTypeContext;
            this.hazidRiskSeverityTypes = hazidRiskSeverityTypeContext;
            this.hazidRiskProbabilityTypes = hazidRiskProbabilityTypeContext;
            this.hazidStatuses = hazidStatusContext;
            this.hazidPersons = hazidPersonContext;
        }

        // GET: HASSApplication
        public ActionResult ListReports()
        {
            HAZID_Forms_View_Model hazidFormsViewModel = new HAZID_Forms_View_Model();

            hazidFormsViewModel.HAZID_Forms = hazidForms.Collection().ToList();
            hazidFormsViewModel.HAZID_Branch_Districts = hazidBranchDistricts.Collection();
            hazidFormsViewModel.HAZID_Hazard_Types = hazidHazardTypes.Collection();
            hazidFormsViewModel.HAZID_Risk_Severity_Types = hazidRiskSeverityTypes.Collection();
            hazidFormsViewModel.HAZID_Risk_Probability_Types = hazidRiskProbabilityTypes.Collection();
            hazidFormsViewModel.HAZID_Statuses = hazidStatuses.Collection();
            hazidFormsViewModel.HAZID_Persons = hazidPersons.Collection();
            return View(hazidFormsViewModel);
        }

        public ActionResult EditReport(int id)
        {
            HAZID_Forms hazidFormToEdit = hazidForms.Find(id);
            if (hazidFormToEdit == null)
            {
                return HttpNotFound();
            }
            else
            {
                HAZID_Form_View_Model hazidFormViewModel = new HAZID_Form_View_Model();
                hazidFormViewModel.HAZID_Form = hazidFormToEdit;
                hazidFormViewModel.HAZID_Branch_Districts = hazidBranchDistricts.Collection();
                hazidFormViewModel.HAZID_Hazard_Types = hazidHazardTypes.Collection();
                hazidFormViewModel.HAZID_Risk_Severity_Types = hazidRiskSeverityTypes.Collection();
                hazidFormViewModel.HAZID_Risk_Probability_Types = hazidRiskProbabilityTypes.Collection();
                hazidFormViewModel.HAZID_Statuses = hazidStatuses.Collection();
                hazidFormViewModel.HAZID_Persons = hazidPersons.Collection();
                return View(hazidFormViewModel);
            }
        }

        [HttpPost]
        public ActionResult EditReport(HAZID_Form_View_Model hazidFormViewModel, int id)
        {
            HAZID_Forms hazidFormToEdit = hazidForms.Find(id);

            if (hazidFormToEdit == null)
            {
                return HttpNotFound();
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return View(hazidFormViewModel);
                }

                hazidFormToEdit = hazidFormViewModel.HAZID_Form;
                hazidForms.Commit();

                return RedirectToAction("ListReports");
            }
        }

        public ActionResult ViewForm(int id)
        {
            HAZID_Forms hazidFormToView = hazidForms.Find(id);
            if (hazidFormToView == null)
            {
                return HttpNotFound();
            }
            else
            {
                HAZID_Form_View_Model hazidFormViewModel = new HAZID_Form_View_Model();
                hazidFormViewModel.HAZID_Form = hazidFormToView;
                hazidFormViewModel.HAZID_Branch_Districts = hazidBranchDistricts.Collection();
                hazidFormViewModel.HAZID_Hazard_Types = hazidHazardTypes.Collection();
                hazidFormViewModel.HAZID_Risk_Severity_Types = hazidRiskSeverityTypes.Collection();
                hazidFormViewModel.HAZID_Risk_Probability_Types = hazidRiskProbabilityTypes.Collection();
                hazidFormViewModel.HAZID_Statuses = hazidStatuses.Collection();
                hazidFormViewModel.HAZID_Persons = hazidPersons.Collection();
                return View(hazidFormViewModel);
            }
        }
    }
}

My Edit view looks like this

@model HAZID.Core.ViewModels.HAZID_Form_View_Model

@{
    ViewBag.Title = "Edit Report";
}

@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()

<div class="form-horizontal">
    <h4>HASS Report Details</h4>
    <hr />
    @Html.ValidationSummary(true, "", new { @class = "text-danger" })
    @Html.HiddenFor(model => model.HAZID_Form.Id)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Workers_Id)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Form_DateTime)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_District_Id)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Supervisors_Id)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Hazard_Location)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Hazard_Description)
    @Html.HiddenFor(model => model.HAZID_Form.HAZID_Workers_Suggstion)

    <div class="form-group col-md-10">
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Workers_Id)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Persons.FirstOrDefault(c => c.Id == Model.HAZID_Form.HAZID_Workers_Id).Full_Name)
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Position)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Form.HAZID_Position)
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Form_DateTime)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Form.HAZID_Form_DateTime.ToString())
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Supervisors_Id)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Persons.FirstOrDefault(c => c.Id == Model.HAZID_Form.HAZID_Supervisors_Id).Full_Name)
            </div>
        </div>
        <div class="row">
            @{
                var hazidDistrictName = string.Empty;
                if (System.Threading.Thread.CurrentThread.CurrentUICulture.Name == "en")
                {
                    hazidDistrictName = Model.HAZID_Branch_Districts.FirstOrDefault(c => c.Id == Model.HAZID_Form.HAZID_District_Id).English_Description.ToString();
                }
                else
                {
                    hazidDistrictName = Model.HAZID_Branch_Districts.FirstOrDefault(c => c.Id == Model.HAZID_Form.HAZID_District_Id).French_Description.ToString();
                }
            }
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_District_Id)
            </div>
            <div class="col-7">
                @Html.Raw(hazidDistrictName)
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Hazard_Location)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Form.HAZID_Hazard_Location)
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Hazard_Description)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Form.HAZID_Hazard_Description)
            </div>
        </div>
        <div class="row">
            <div class="col-3">
                @Html.CustomLabelFor(model => model.HAZID_Form.HAZID_Workers_Suggstion)
            </div>
            <div class="col-7">
                @Html.Raw(Model.HAZID_Form.HAZID_Workers_Suggstion)
            </div>
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Status_Id, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-3">
            @Html.DropDownListFor(model => model.HAZID_Form.HAZID_Status_Id, new SelectList(Model.HAZID_Statuses, "Id", Resources.Resource.HAZID_Column_Select), Resources.Resource.HAZID_Status_Id_Select, new { htmlAttributes = new { @class = "form-control", id = "HAZID_Form_HAZID_Status_Id" } })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Action_Taken, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.EditorFor(model => model.HAZID_Form.HAZID_Action_Taken, new { htmlAttributes = new { @class = "form-control", @style = "width:100% !important; min-width:600px; height:100px" } })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Hazard_Type_Id, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-4">
            @Html.DropDownListFor(model => model.HAZID_Form.HAZID_Hazard_Type_Id, new SelectList(Model.HAZID_Hazard_Types, "Id", Resources.Resource.HAZID_Column_Select), Resources.Resource.HAZID_Hazard_Type_Select, new { htmlAttributes = new { @class = "form-control", id = "HAZID_Form_HAZID_Hazard_Type_Id" } })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Risk_Severity_Id, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-4">
            @Html.DropDownListFor(model => model.HAZID_Form.HAZID_Risk_Severity_Id, new SelectList(Model.HAZID_Risk_Severity_Types, "Id", Resources.Resource.HAZID_Column_Select), Resources.Resource.HAZID_Risk_Severity_Id_Select, new { htmlAttributes = new { @class = "form-control", id = "HAZID_Form_HAZID_Risk_Severity_Id" } })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Hazard_Type_Id, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-4">
            @Html.DropDownListFor(model => model.HAZID_Form.HAZID_Risk_Probability_Id, new SelectList(Model.HAZID_Risk_Probability_Types, "Id", Resources.Resource.HAZID_Column_Select), Resources.Resource.HAZID_Risk_Probability_Id_Select, new { htmlAttributes = new { @class = "form-control", id = "HAZID_Form_HAZID_Risk_Probability_Id" } })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Control_Description, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-4">
            @Html.EditorFor(model => model.HAZID_Form.HAZID_Control_Description, new { htmlAttributes = new { @class = "form-control", @style = "width:100% !important; min-width:600px; height:100px" } })
            @Html.ValidationMessageFor(model => model.HAZID_Form.HAZID_Control_Description, "", new { @class = "text-danger" })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Person_Responsible_Name, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.EditorFor(model => model.HAZID_Form.HAZID_Person_Responsible_Name, new { htmlAttributes = new { @class = "form-control" } })
            @Html.ValidationMessageFor(model => model.HAZID_Form.HAZID_Person_Responsible_Name, "", new { @class = "text-danger" })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.HAZID_Form.HAZID_Applcability_To_Others_Flag, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.CheckBoxFor(model => model.HAZID_Form.HAZID_Applcability_To_Others_Flag)
        </div>
    </div>

    <div class="form-group">
        <div class="col-md-offset-2 col-md-10">
            <input type="submit" value="Save" class="btn btn-outline-primary" />
        </div>
    </div>
</div>
}

<div>
    @Html.ActionLink("Back to List", "ListReports")
</div>

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
    <script type="text/javascript">
        $(function () {
            $("#HAZID_Form_HAZID_Status_Id").select2();
            $("#HAZID_Form_HAZID_Hazard_Type_Id").select2();
            $("#HAZID_Form_HAZID_Risk_Severity_Id").select2();
            $("#HAZID_Form_HAZID_Risk_Probability_Id").select2();
            $('.select2-container').css("width", "100%");
        });
    </script>
}

My problem is when I click the save the data is there but after the commit and redirect the data was not saved to the database.

if someone can help me it would be very much appreciated.

Re: HTTPPOST of EditReport not comiting data to database

Richard Deeming4-Jul-21 21:34

Richard Deeming

4-Jul-21 21:34

Member 15016778 wrote:

HAZID_Forms hazidFormToEdit = hazidForms.Find(id);
...
hazidFormToEdit = hazidFormViewModel.HAZID_Form;
hazidForms.Commit();

Your code finds the form with the specified ID, and stores it in a local variable.

It then overwrites the local variable with the value from the view-model, breaking any link between the variable and the repository.

It then tells the repository to commit the changes. But there are no changes to commit, because you've not updated anything that the repository knows about.

Instead of overwriting the local variable, you need to update the entity returned from the Find method using the properties of the view-model.

You'll also need to repopulate the view-model collections before displaying the view again.

private void PopulateLookups(HAZID_Form_View_Model hazidFormViewModel)
{
    hazidFormViewModel.HAZID_Branch_Districts = hazidBranchDistricts.Collection();
    hazidFormViewModel.HAZID_Hazard_Types = hazidHazardTypes.Collection();
    hazidFormViewModel.HAZID_Risk_Severity_Types = hazidRiskSeverityTypes.Collection();
    hazidFormViewModel.HAZID_Risk_Probability_Types = hazidRiskProbabilityTypes.Collection();
    hazidFormViewModel.HAZID_Statuses = hazidStatuses.Collection();
    hazidFormViewModel.HAZID_Persons = hazidPersons.Collection();
}

[HttpGet]
public ActionResult EditReport(int id)
{
    HAZID_Forms hazidFormToEdit = hazidForms.Find(id);
    if (hazidFormToEdit == null)
    {
        return HttpNotFound();
    }
    
    HAZID_Form_View_Model hazidFormViewModel = new HAZID_Form_View_Model();
    hazidFormViewModel.HAZID_Form = hazidFormToEdit;
    PopulateLookups(hazidFormViewModel);
    return View(hazidFormViewModel);
}

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult EditReport(HAZID_Form_View_Model hazidFormViewModel, int id)
{
    HAZID_Forms hazidFormToEdit = hazidForms.Find(id);
    if (hazidFormToEdit == null)
    {
        return HttpNotFound();
    }
    
    if (!ModelState.IsValid)
    {
        PopulateLookups(hazidFormViewModel);
        return View(hazidFormViewModel);
    }

    // Copy the properties from the view-model to the entity:
    hazidFormToEdit.HAZID_Status_Id = hazidFormViewModel.HAZID_Form.HAZID_Status_Id;
    hazidFormToEdit.HAZID_Action_Taken = hazidFormViewModel.HAZID_Form.HAZID_Action_Taken;
    ...
    
    hazidForms.Commit();

    return RedirectToAction("ListReports");
}

NB: Don't use @Html.Raw(...) when displaying values in your view unless you expect the property to contain valid HTML which you want to include in your output. As it stands, your code is vulnerable to a persisted cross-site scripting (XSS) attack[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: HTTPPOST of EditReport not comiting data to database

Carl Cummings (Canada)5-Jul-21 2:02

Carl Cummings (Canada)

5-Jul-21 2:02

Thanks soo much that makes since. I just thought i could copy the whole thing in one step but now i see that is not the case.

As for the raw i was once again not sure as I need to get the text from a different column based on the language.

If you know a better way i would appreciate any insight.

Visual Studio Freezes during build solution

Robymon1-Jul-21 22:37

Robymon

1-Jul-21 22:37

Hi,

My solution have 3 layers (Business class project, Data Class Project and Application (ASP.Net, C#)). I can build Business and Data Class project, but when i build solution my Visual studio freezes and not showing any result in Output. after 5 or 10 minutes will get pop up message "Visual studio stopped working" and restart visual studio. I tried the below solutions to sort this issue, but nothing did help me.

1) Deleted files from Temporary folders
1.1)C:\Users\<user name="">\AppData\Local\Temp\Temporary ASP.NET Files
1.2)C:\Users\<user name="">\AppData\Local\Microsoft\WebsiteCache
1.3) C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files
1.4) C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files

2) Repair Visual studio
3) Uninstall and Re-Install Visual studio
4) Delete the .SUO file

I Can build this solution in my Personnel laptop(Windows 7) but in my workstation(Windows 8) have this problem. I am using Visual Studio 2012.

Please help me to sort this issue.

Re: Visual Studio Freezes during build solution

Richard Deeming1-Jul-21 23:15

Richard Deeming

1-Jul-21 23:15

You need to report the problem to Microsoft.

But the obvious question is, why are you using a version of Visual Studio from nine years ago, when VS2019 community edition is available for free?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Visual Studio Freezes during build solution

Deepak Vasudevan13-Sep-21 21:49

Deepak Vasudevan

13-Sep-21 21:49

Did you try the latest versions of Visual Studio like 2017 or 2019? They have radical improvements right from the installer stage.

ASP.Net Core MVC - Validation Summary not working with bootstrap tabs and dynamically loaded content

SeeSharp223-Jun-21 9:58

SeeSharp2

23-Jun-21 9:58

How do you get dynamically loaded tabs to work in ASP.Net Core MVC?

1. I have a simple Index.cshtml that uses bootstrap tabs to create two tabs from the a tags on the page. (To test out options, I first copied from https://qawithexperts.com/article/asp.net/bootstrap-tabs-with-dynamic-content-loading-in-aspnet-mvc/176)
2. There is a click event on each tab that uses $.ajax() to call the controller and then set the html of the appropriate div.
3. I have a model with one field, a string that is required.
4. I have the create view that Visual Studio created.
5. When I run it and click the first tab, the controller returns PartialView("FirstTabCreate") and loads into the div and everything looks great.
6. The problem is when clicking the "Create" button.
7. The controller method checks if IsValid on the ModelState. If not, here is where I run into a problem. If I return the partial view and the model that was passed in I see my validation errors as expected but because I returned the partial view, I lose my tabs. If I return the main view (Index) then the javascript reloads my partial view and has lost the ModelState at that point.
I am not sure what to return so that this works. I have seen lots of examples online that use dynamically loaded tabs but none of them have models or validation.

Code below: Index Page

@model FirstTab
<!-- Tab Buttons -->
<ul id="tabstrip" class="nav nav-tabs" role="tablist">
    <li class="active">
        <a href="#FirstTab" role="tab" data-toggle="tab">Submission</a>
    </li>
    <li>
        <a href="#SecondTab" role="tab" data-toggle="tab">Search</a>
    </li>
</ul>

<!-- Tab Content Containers -->
<div class="tab-content">
    <div class="tab-pane active" id="FirstTab">
       
    </div>
    <div class="tab-pane fade" id="SecondTab">

    </div>
</div>
<script src="~/lib/jquery/dist/jquery.min.js"></script>
<script>
    $('#tabstrip a').click(function (e) {
        e.preventDefault();
        var tabID = $(this).attr("href").substr(1);
        $(".tab-pane").each(function () {
            console.log("clearing " + $(this).attr("id") + " tab");
            $(this).empty();
        });

        $.ajax({
            url: "/@ViewContext.RouteData.Values["controller"]/" + tabID,
            cache: false,
            type: "get",
            dataType: "html",
            success: function (result) {
                $("#" + tabID).html(result);
            }

        });
        $(this).tab('show');
    });

    $(document).ready(function () {
        $('#tabstrip a')[0].click();
    });
</script>

FirstTabCreate View

@model WebApplication1.Models.FirstTab

<h4>FirstTab</h4>
<hr />
<div class="row">
    <div class="col-md-4">
       <form asp-action="FirstTabCreate">        
            <div asp-validation-summary="ModelOnly" class="text-danger"></div>
            <div class="form-group">
                <label asp-for="FirstName" class="control-label"></label>
                <input asp-for="FirstName" class="form-control" />
                <span asp-validation-for="FirstName" class="text-danger"></span>
            </div>
            <div class="form-group">
                <input type="submit" value="Create" class="btn btn-primary" />
            </div>
        </form>
    </div>
</div>

<div>
    <a asp-action="Index">Back to List</a>
</div>

Model

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models
{
    public class FirstTab
    {
        [Required()]
        public string FirstName { get; set; }
    }
}

Controller

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using System.Diagnostics;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class HomeController : Controller
    {       
        public IActionResult Index()
        {
            return View();
        }

        public ActionResult FirstTab()
        {
            return PartialView("FirstTabCreate");
        }

        public ActionResult FirstTabCreate(FirstTab model)
        {
            if (!ModelState.IsValid)
            {
                return View("FirstTabCreate",  model);
            }
            return Content("Success");
        }

        public ActionResult SecondTab()
        {
            return PartialView("_SecondTab");
        }
    }
}

Re: ASP.Net Core MVC - Validation Summary not working with bootstrap tabs and dynamically loaded content

Richard Deeming23-Jun-21 21:39

Richard Deeming

23-Jun-21 21:39

The documentation suggests you need to parse the dynamic form to enable validation:
Add Validation to Dynamic Forms | Model validation in ASP.NET Core MVC | Microsoft Docs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: ASP.Net Core MVC - Validation Summary not working with bootstrap tabs and dynamically loaded content

SeeSharp224-Jun-21 2:21

SeeSharp2

24-Jun-21 2:21

Thanks, this does work but it does not solve my issue. Doing this essentially causes the form validation to happen all client side and so my Controller method does not get called. One of the business requirements is to log validation errors in the database, which I was doing in the Controller method when ModelState was not valid.

I'll look to see if there is a way to get all validation errors client side so that I can still log them in the db. It just seems like there should be an easier way to do tabs.

Re: ASP.Net Core MVC - Validation Summary not working with bootstrap tabs and dynamically loaded content

Richard Deeming24-Jun-21 3:54

Richard Deeming

24-Jun-21 3:54

Client-side validation prevents a costly round-trip to the server, and reduces the number of times the server code has to run just to reject the request as invalid.

If you log every single validation error, then unless you're very lucky with your users, I suspect you're going to end up with a "validation errors" database that grows by hundreds of gigabytes every day.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: ASP.Net Core MVC - Validation Summary not working with bootstrap tabs and dynamically loaded content

SeeSharp224-Jun-21 4:16

SeeSharp2

24-Jun-21 4:16

Speed is an important part of this data entry app and so they want to know who keeps making the same mistakes over and over. For example, who keeps forgetting to fill in a phone number. This way they can train users to be more efficient.

So, I get your point, but no, it won't be nearly that bad.

We actually are replacing a Java based web app and the current table for validation errors is big, but not too big.

Crystal Report Issue in ASP.Net 2010.

Mohammad Salmani8-Jun-21 20:43

Mohammad Salmani

8-Jun-21 20:43

Hi,

Failed to open crystal report in browser in ASP.Net and debugging shows some reference error.
Tried many solution but failed.

Thanks & Kind Regards
Mohammad Salmani

Re: Crystal Report Issue in ASP.Net 2010.

Richard Deeming8-Jun-21 21:31

Richard Deeming

8-Jun-21 21:31

There's a secret error somewhere in your secret code. You need to fix that.

Seriously, how do you expect anyone to be able to help you if you won't show the relevant parts of your code, or even provide the full error message?! D'Oh! | :doh:

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Crystal Report Issue in ASP.Net 2010.

Mohammad Salmani8-Jun-21 22:36

Mohammad Salmani

8-Jun-21 22:36

I am getting the below errors.

Uncaught ReferenceError: bobj is not defined

GEThttp://localhost:82/aspnet_client/system_web/2_0_50727/crystalreportviewers13/js/crviewer/crv.js

GEThttp://localhost:82/aspnet_client/system_web/2_0_50727/crystalreportviewers13/js/crviewer/crv.js

tried many solution available on google

Thanks & Regards
Mohammad Salmani

Re: Crystal Report Issue in ASP.Net 2010.

Richard Deeming8-Jun-21 22:51

Richard Deeming

8-Jun-21 22:51

Crystal Reports is not installed properly. There are lots of hits on Google for that error message. For example:
How do I resolve "bobj is undefined" issue? | SAP Blogs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Crystal Report Issue in ASP.Net 2010.

Mohammad Salmani10-Jun-21 4:11

Mohammad Salmani

10-Jun-21 4:11

Thanks Richard

OutputCacheProvider...

Kornfeld Eliyahu Peter19-May-21 22:29

Kornfeld Eliyahu Peter

19-May-21 22:29

I set the cache provider below, but the Add method never called... Only several Get calls I receive...
Any idea why?

public class MyCacheProvider : OutputCacheProvider
{
  public override object Add(string key, object entry, DateTime utcExpiry)
  {
    return entry;
  }

  public override object Get(string key)
  {
    return null;
  }

  public override void Remove(string key)
  {
  }

  public override void Set(string key, object entry, DateTime utcExpiry)
  {
  }
}

"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012

aspnet credentials from web.config

philippegent8-May-21 2:14

philippegent

8-May-21 2:14

To send emails from an (old) asp.net website I use the following code :    
-------

    Protected Sub SendMail(sender As Object, e As System.EventArgs)
        Try
            Dim smtpSection As SmtpSection = CType(ConfigurationManager.GetSection("system.net/mailSettings/smtp"), SmtpSection)
            
            Dim smtp As New SmtpClient
            smtp.Host = smtpSection.Network.Host
            smtp.EnableSsl = smtpSection.Network.EnableSsl
            smtp.UseDefaultCredentials = smtpSection.Network.DefaultCredentials
            smtp.Port = smtpSection.Network.Port
  
            'solution 1 does not work !
            'Dim networkCred As NetworkCredential = New Net.NetworkCredential(smtpSection.Network.UserName, smtpSection.Network.Password)
            'smtp.Credentials = networkCred
            
            'solution 2 does not work !
            'Dim networkCred As New Net.NetworkCredential(smtpSection.Network.UserName, smtpSection.Network.Password)
            'smtp.Credentials = networkCred
            
            'solution 3 does work !!!
            smtp.Credentials = New Net.NetworkCredential("yyyyyy@xxxxxx.com", "zzzzzz")
            
            Using mm As New MailMessage(smtpSection.From, txtTo.Text.Trim())
                mm.Subject = txtSubject.Text.Trim()
                mm.Body = txtBody.Text.Trim()
                mm.IsBodyHtml = False
                
                TextBox2.Text = smtpSection.Network.UserName
                TextBox3.Text = smtpSection.Network.Password
                TextBox4.Text = smtpSection.Network.Host
                TextBox5.Text = smtpSection.Network.Port
                TextBox6.Text = smtpSection.Network.EnableSsl
                TextBox7.Text = smtpSection.Network.DefaultCredentials
                TextBox8.Text = smtpSection.From
                TextBox9.Text = txtTo.Text.Trim()
                
                smtp.Send(mm)

            End Using
            
        Catch error_t As Exception
            TextBox1.Text = error_t.ToString
        End Try
        
    End Sub
-------

The web.config section contains this : 
-------

      <smtp deliveryMethod="Network" from="yyyyyy@xxxxxx.com" >
        <network
            host="smtp-auth.mailprotect.be"
            port="2525"
            userName="yyyyyyyy@xxxxxxxx.com "
            password="zzzzzz"
            defaultCredentials="false"
            enableSsl="false"
        />
      </smtp>
------

The namespaces loaded are : 

    <%@ Import Namespace="System.Net" %>
    <%@ Import Namespace="System.Net.Mail" %>
    <%@ Import Namespace="System.Configuration" %>
    <%@ Import Namespace="System.Net.Configuration" %>

Solution 3 works fine but I don't like to show passwords in a page.

When using solution 1 or 2 the mailserver replies it does not relay, so apparently the credentials are not retrieved work properly.
All the other parameters do show properly in the textboxes I designed to test this sub.

Does anyone have a suggestion ?

Thanks.

Philippe Caron

Re: aspnet credentials from web.config

Dave Kreskowiak8-May-21 4:58

Dave Kreskowiak

8-May-21 4:58

Two things. ASP.NET code always executes on the server, never the client. That code will never be shown as part of "a page".

The first two attempts you show as "does not work" are because you're making assumptions about what those smtpSection.Network.UserName and smtpSection.Network.Password properties are returning. I would be willing to bet they don't return anything, so you're creating a NetworkCredential with blank username and password.

How do you tell? One word: debugger. Set a breakpoint on the line that creates the NetworkCredential and examine the values of UserName and Password. Chances are good those values are not what you think they are.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: aspnet credentials from web.config

Richard Deeming18-May-21 3:56

Richard Deeming

18-May-21 3:56

You shouldn't need any of that code. The SmtpClient will initialize itself based on the settings in the web.config file automatically.

The SmtpClient constructor[^] calls the Initialize method[^], which reads the settings from the config file.

If it's not working, then you need to debug your code to see what settings are actually being read from your config file.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Store Dataset into session variable

Member 1189497423-Apr-21 23:59

Member 11894974

23-Apr-21 23:59

Store Dataset into session variable

Re: Store Dataset into session variable

Richard MacCutchan24-Apr-21 2:25

Richard MacCutchan

24-Apr-21 2:25

Is that an instruction or a proud boast?

Re: Store Dataset into session variable

Deepak Vasudevan13-Sep-21 21:45

Deepak Vasudevan

13-Sep-21 21:45

I look at it as a project manager trying to give direction to a team member however inadvertently instead of typing in Microsoft Teams ended up submitting a new post in CodeProject.

Re: Store Dataset into session variable

C0ding_j3ff28-Apr-21 12:02

C0ding_j3ff

28-Apr-21 12:02

Is this some kind of spam? If not, I'm sorry, but it definitely looks like it LOL.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.