Add / Update Record

Ramco Ramco

In Controller how i can track whether it is Update or Add

@foreach (var item in Model)
{

}

@Html.DisplayNameFor(model => model.Id)	@Html.DisplayNameFor(model => model.Description)	@Html.DisplayNameFor(model => model.IsActive)	Action
@Html.DisplayFor(modelItem => item.Id)	@Html.DisplayFor(modelItem => item.Description)	@Html.DisplayFor(modelItem => item.IsActive)	Edit @if (item.IsActive) { data-path="@Url.Action("Delete", "Location", new { id = @item.Id })" style='margin-left:5px'> Delete } else { Delete }

@using (Html.BeginForm("CreateEdit", "Location", FormMethod.Post))
{

}

**********************************************

[HttpPost]
public ActionResult CreateEdit(Location objLocation)
{
if (ModelState.IsValid)
{
dbLocation.Add(objLocation);
//return Json(new { success = true, message = "Successfully Saved" });
}

return RedirectToAction("Index");
}

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajendran S5y ago
Check this one for add the value to database via Linq

https://www.c-sharpcorner.com/blogs/linq-transaction-commit-and-roll-back
Ramco Ramco5y ago
Hi Sachin

I just didn't want to use Ajax that's why i changed view by using
@using (Html.BeginForm("CreateEdit", "Location", FormMethod.Post)) . Atleast i didn't wanted Ajax for Edit/Update. Ajax is the only way for this.

If Ajax is the only way for this can u pls guide what will be the Ajax Post.

Thanks
Sachin Singh5y ago
why do you want to do more, if this is the case then send one extra parameter like Action?
$("#btnUpdate").click(function(){

var action="Update";
// ajax post

});
$("#btnAdd").click(function(){

var action="Add";
// ajax post

});
[HttpPost]
        public ActionResult CreateEdit(Location objLocation,string Action)
        {
            if (ModelState.IsValid)
            {
                //  take decision based on Action
            }

            return RedirectToAction("Index");
        }
Ramco Ramco5y ago
Hi Sachin/Salman

I have belwo function on btnEdit click.

Suppose Id value is AA. How i can append U to Id means UAA. Then in Controller how i should remove 1st character "U" from Id & save with the remaining Value .

Is there any other best option possible.

$('body').on('click', '[id*=btnEdit]', function () {
var data = $(this).parents('tr').find('td');
var Id = data.eq(0).html();
var Description = data.eq(1).html();
var IsActive = data.eq(2).html();
$('[id*=txtId]').val(Id);
$('[id*=txtDescription]').val(Description);
$('[id*=txtISActive]').val(IsActive);
$(".modal-title").html("Update");
//$('#myModal').modal("show");
});

Thanks
Salman Beg5y ago
If the objLocation contains id value then it's a edit otherwise create. Usually for create we don't have any unique id but after the record saved in db it will generate id but while editing you are using id to bind the data. So in action method you can check if id is null then it's a create otherwise edit. Thanks
Sachin Singh5y ago
One thing is, while Add we don't send the Id but with Update, we Do send the Id. so, your code should be
[HttpPost]
        public ActionResult CreateEdit(Location objLocation)
        {
            if (ModelState.IsValid)
            {
   if(objLocation.Id==0)
{
                dbLocation.Add(objLocation);
//_context.Locations.Add(ObjLocation);
//_context.SaveChanges();
// here Id is not present.
return Json(new { success = true, message = "Successfully Saved"
});
            }
else {
dbLocation.Update(objLocation);
// _context.Locations.Entry(objLocation).state= EntityState.Modified;
//_context.SaveChanges();
// here objLocation contains the Id.
}

            return RedirectToAction("Index");
        }