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