MVC5(UPDATE)

Question

Hi How to update the foreach values at a short in mvc5 . I am fetching the values in foreach loop after that how to update that values?

Harpreet · Answer

Hi Sir Can u plzz check this one.. i am sending my whole code can u plz check its urgent.. in post method plz check i m not getting that update query View: @using MyDemoProject.Models @model DetailsList @foreach (var item in Model) { @Html.DisplayFor(modelItem => item.Id) @Html.DisplayFor(modelItem => item.Name) @Html.DisplayFor(modelItem => item.OldSeq) } model public class EmpDetails { public int Id { get; set; } public string Name { get; set; } public int OldSeq { get; set; } public int NewSeq { get; set; } } public class DetailsList { public int Id { get; set; } public string Name { get; set; } public int OldSeq { get; set; } public int NewSeq { get; set; } public IEnumerable EmpDetailsList { get; set; } } Controller projectEntities obj = new projectEntities(); [HttpGet] public ActionResult EmployeeDetails() { List c2 = new List (); EmpDetails model = new EmpDetails(); var Empdet = from x in obj.Employees //where x.Id==model.Id select x; foreach(var item in Empdet) { model = new EmpDetails(); model.Id = item.Id; model.Name = item.Name; model.OldSeq = Convert.ToInt16(item.OldSeq); model.NewSeq = Convert.ToInt16(item.NewSeq); c2.Add(model); } DetailsList abc = new DetailsList(); abc.EmpDetailsList = c2; return View(c2); } [HttpPost] public ActionResult EmployeeDetails(DetailsList model) { List results = (from p in obj.Employees where p.Id == model.Id select p).ToList(); foreach (EmpDetails p in results) { p.is_default = false; } obj.SaveChanges(); return View(); } }

Mukesh Kumar · Answer

no problem... try this and let me know.. if you stuck any where. thanks

Harpreet · Answer

ok sir i wiil try this one.. thanku so much

Mukesh Kumar · Answer

Hi Person is a class which contains the person property.. See below a proper full code.. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Xml; using System.Xml.Linq; using System.Data.Sql; using System.Data; namespace Linq_Grouping { class Program { static void Main( string [] args) { Console.WriteLine(  Enter your choice. ); int choice = int .Parse(Console.ReadLine()); if (choice == 1 ) ExecuteLinqForXML(); Console.ReadLine(); } static void ExecuteLinqForXML() { Random rnd = new Random(); XElement Customers = new XElement(  Customers ); for ( int i = 0 ; i 25 ; i++) { Customers.Add( new XElement(  Customer  new XElement(  Id  (  cust_id + (i + 1 ))) new XElement(  Name   Customer + (i + 1 )) new XElement(  Category   Cat + ((i + 1 )) / 4 ) new XElement(  Sales  (rnd.Next( 100  1000 ))) ) ); } var results = from p in Customers.Descendants(  Customer ) group p by p.Element(  Category ).Value into grps select new { Key = grps.Key Values = grps TotalSales = grps.Sum (g => decimal .Parse(g.Element(  Sales ).Value)) Total = grps.Count() AvgSales = grps.Average (g => decimal .Parse(g.Element(  Sales ).Value)) MaxSales = grps.Max(g => decimal .Parse(g.Element(  Sales ).Value)) MinSales = grps.Min(g => decimal .Parse(g.Element(  Sales ).Value)) }; foreach ( var result in results) { Console.WriteLine(  Category -  + result.Key); Console.WriteLine(  Total Sales :  + result.TotalSales +  Average Sales :  + result.AvgSales +  Maximum Sales :  + result.MaxSales +  Minimum Sales :  + result.MinSales); Console.WriteLine(  ID			Name			Category	Sales ); foreach (XElement Customer in result.Values) { Console.WriteLine( Customer.Element(  Id ).Value +  		 + Customer.Element(  Name ).Value +  		 + Customer.Element(  Category ).Value +  		 + Customer.Element(  Sales ).Value +  		 ); } } } } } or refer this link http://www.codeproject.com/Tips/514424/LINQ-Group-By http://stackoverflow.com/questions/7325278/group-by-in-linq Hope this will help you. thanks

Harpreet · Answer

Sir what is Person in list List ?

Mukesh Kumar · Answer

Hi I hope you are asking for update the value using foreach.. so below is the code List Person > results = ( from p in Context . Persons where .... // add where condition here select p ). ToList (); foreach ( Person p in results ) { p . is_default = false ; } Context . SaveChanges (); Hope this will help you. thanks

Harpreet · Answer

Suppose in db table i hv Sequence column. in one id their is multiple sequnce in table. I am fetching all the sequence with id by using foreach loop in Get method(MVC). after fetching i am not able to update that sequnce .how to update the forecah values(sequence).

Mukesh Kumar · Answer

Hi Your question is not bit clear to me... can you explain in better way? thanks