avoid the duplicate,only once need to display in mvc

Question

I need to display the testname, if the testname repeats i need not to avoid it?
i used like this but duplicate is displaying.

@{
var tname="null" ;

}
@foreach (StudentGradeBook x in Model.Student)
{

if(!(tname.Equals(@x.TestName)))
{
<th>@x.TestName</th>
}
tname = @x.TestName.ToString();
}

If x contains
test
test
test
testing
testing

But i need to display

test
testing

Shakil Ahmed · Answer

Its Easier Than Others I think ..Try It ----------------------------------------------------- In View: ----------- @{ string groupName = ""; } @foreach (var item in Model) { @{ if (groupName != item.Group.GroupName) { @Html.DisplayFor(modelItem => item.Group.GroupName) } groupName = item.Group.GroupName; } -----------------------------------OutPut-------------------------

Sunny Sharma · Answer

It's OK. See me if you need me on C# Corner. Cheer up!

vidhya · Answer

i have done some wrong in linq,after some clarification with client, i continue. i think , dont want to waste yr time.

Sunny Sharma · Answer

well, I can get you a complete solution if you can send me a visual representation of your test data for StudentGradeBook and desired output.

vidhya · Answer

sunny, totalpoints is displayed/entered according to the testname, pointspossible is displayed/entered according to the assignmentname. then how is it possible to use like this @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { }

Sunny Sharma · Answer

So, do you wanna do something else or that's perfect? It that's OK then mark it as answer as it will help others find the solution in one go.

vidhya · Answer

@foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @ var tPoints = (from gradeBook in Model.Student where gradeBook.TestName==tName.ToString() select gradeBook.TotalPoints).sum(); @ var pointsPossible = (from gradeBook in Model.Student where gradeBook.TestName==tName.ToString() select gradeBook.PointsPossible).sum(); @tPoints @pointsPossible } I get TotalPoints from testname according to the this I get PointsPossible from assignmentname according to this.

Sunny Sharma · Answer

vidhya, feedback awaited on my previous reply.

Sunny Sharma · Answer

vidhya, use the code below: ------------------------------------------ @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @tName.ToString() } @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @ var tPoints = (from gradeBook in Model.Student where gradeBook.TestName==tName.ToString() select gradeBook.TotalPoints).sum(); @ var pointsPossible = (from gradeBook in Model.Student where gradeBook.TestName==tName.ToString() select gradeBook.PointsPossible).sum(); @tPoints @pointsPossible } -------------------------------------------

vidhya · Answer

@foreach (MavinLMSService.ViewModels.Professor.GradeBook.StudentGradeBook x in Model.Student) { @x.PointsAwarded / @ x.PointsPossible } @foreach(var tPoints in (from gradeBook in Model.Student select gradeBook.TotalPoints).Distinct()) { / @ tPoints } I need to change the 1st for loop like the 2nd for loop how can i change, 1st loop contains 2 fields.

vidhya · Answer

Before sample assignment the heading is totalpoints the corresponding row i need to add the points and display there. pointspossible and totalpoints are displayed in 2nd row

Sunny Sharma · Answer

you mean total points for individual/unioque testNames or just totals for each gradeBook?

vidhya · Answer

Sunny , I need to display the total of totalpoints and pointspossible in the before column. how to add it? total of totalpoints and pointspossible @foreach (MavinLMSService.ViewModels.Professor.GradeBook.StudentGradeBook x in Model.Student) { @x.PointsAwarded / @x.PointsPossible } @foreach(var tPoints in (from gradeBook in Model.Student select gradeBook.TotalPoints).Distinct()) { / @tPoints }

Sunny Sharma · Answer

I've just modified the code: use tName instead of x.Testname: ---------------------- @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @tName.ToString() } --------------------------------------

vidhya · Answer

sunny, I am getting error The name X does not contain in the current content @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @x.TestName } Then i changed like this @x.TestName now its work fine.

Sunny Sharma · Answer

Hi vidhya, I have the solution for you, modify your view as following: ---------------------------- @model MavinLMSService.ViewModels.Professor.GradeBook.IndexModel @{ ViewBag.Title = "Grade Book"; Layout = "~/Views/Shared/_PrimaryLayout.cshtml"; } @foreach(var tName in (from gradeBook in Model.Student select gradeBook.TestName).Distinct()) { @tName.ToString() } ------------------------------------------------------------- Yes, there's one catch also. You need to import the namespace into your view by adding @using System.Data.Linq at the top of your view. However if you want it in all your views then you need to add to the web.config in your Views folder: Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> Feedback awaited. Cheers!

vidhya · Answer

no improvement still same

Iftikar Hussain · Answer

try like this @{ var arrayName = new string[Model.Student.Count]; var arrayPoints = new int[Model.Student.Count]; var i = 0; var j = 0; } @foreach (var x in Model.Student) { if (Array.IndexOf(arrayName, @x.TestName) { @x.TestName } arrayName[i] = x.TestName; i++; } @foreach (var x in Model.Student) { if (Array.IndexOf(arrayPoints, @x.TotalPoints) { @x.TotalPoints } arrayPoints[j] = x.TotalPoints; j++; } Regards, Iftikar

vidhya · Answer

i followed your code but i displays duplicate

Iftikar Hussain · Answer

use different array @{ var arrayName = new string[Model.Student.Count]; var arrayPoints = new string[Model.Student.Count]; var i = 0; var j = 0; } @foreach (var x in Model.Student) { if (Array.IndexOf(arrayName, @x.TestName) { @x.TestName } arrayName[i] = x.TestName; i++; } @foreach (var y in Model.Student) { if (Array.IndexOf( arrayPoints , @y.TotalPoints) { @y.TotalPoints } arrayPoints [j] = y.TotalPoints.ToString (); j++; } Regards, Iftikar

vidhya · Answer

@{ var arrayName = new string[Model.Student.Count]; var i = 0; var j = 0; } @foreach (var x in Model.Student) { if (Array.IndexOf(arrayName, @x.TestName) { @x.TestName } arrayName[i] = x.TestName; i++; } @foreach (var y in Model.Student) { if (Array.IndexOf(arrayName, @y.TotalPoints) { @y.TotalPoints } arrayName[j] = y.TotalPoints.ToString (); j++; } For testname it work fine, same i tried for total points i does not work. y?

Iftikar Hussain · Answer

try like this @{ var arrayName = new string[Model.Student.Count]; var i = 0; } @foreach (var x in Model.Student) { if (Array.IndexOf(arrayName, @x.TestName) { @x.TestName } arrayName[i] = x.TestName; i++; } Regards, Iftikar

vidhya · Answer

s absoultely

Iftikar Hussain · Answer

If the xvalue contains test testing pretest test testing prestest the output should be? test testing pretest prestest Regards, Iftikar

vidhya · Answer

xvalue contains test testing pretest test testing prestest tname="" testname=test it dispalys test tname=test testname=testing it dispalys testing tname=testing testname=pretest it dispalys pretest tname=pretest testname=test it dispalys test tname=test testname=testing it dispalys testing tname=testing testname=pretest it dispalys pretest

Iftikar Hussain · Answer

can you debug the code by putting the break point in your view @{var tname="" ;} @foreach (var x in Model.Student) { if (tname != @x.TestName) { @x.TestName } tname = @x.TestName; } Regards, Iftikar

vidhya · Answer

x contains test test test testing testing @x.TestName displays like this test test testing testing test

Iftikar Hussain · Answer

try like this and tell me the output @{var tname="" ;} @foreach (var x in Model.Student) { if (tname != @x.TestName) { @x.TestName } tname = @x.TestName; } Regards, Iftikar

vidhya · Answer

string datatype.

Iftikar Hussain · Answer

Yes I have, as I said it is working fine. I want to check if anything special character in your cshtml file. so only I am asking you to attach it instead of pasting. also tell me what is the data type TestName property Regards, Iftikar

vidhya · Answer

I sent already its ok i send again @model MavinLMSService.ViewModels.Professor.GradeBook.IndexModel @{ ViewBag.Title = "Grade Book"; Layout = "~/Views/Shared/_PrimaryLayout.cshtml"; } @{ var tname="" ; } @foreach (GradeBook.StudentGradeBook x in Model.Student) { @tname // if(!(tname.Equals(@x.TestName))) if (tname != @x.TestName.ToString()) { @x.TestName } tname = @x.TestName.ToString(); }

Iftikar Hussain · Answer

this is also looks fine, can you attach your cshtml file? Regards, Iftikar

vidhya · Answer

public ActionResult Index(Guid id) { return View(_service.IndexBuildView(id)); //return View(); } public IndexModel IndexBuildView(Guid courseSectionId) { CourseSection cs = _courseSectionRepo.GetSectionById(courseSectionId); IndexModel outer = new IndexModel { CourseSectionId = courseSectionId, CourseName = cs.Course.CourseTitle, SectionNumber = cs.SectionNumber, }; var res = from asg in _gradebookRepo.GetStudentsGradeBook(courseSectionId) select new StudentGradeBook {FirstName =asg .FirstName ,LastName =asg .LastName , AssignmentName = asg.AssignmentName, PointsPossible = asg.PointsPossible, DueDateTime = (DateTime)asg.DueDateTime, PointsAwarded =asg .PointsAwarded ,SubmissionDateTime =asg.SubmissionDateTime,TestName =asg.TestName ,TotalPoints =asg.TotalPoints }; outer.Student = res.ToList(); return outer; }

Iftikar Hussain · Answer

from the controller, what is the return view? Regards, Iftikar

vidhya · Answer

still same no improvement.

Iftikar Hussain · Answer

from the controller, what is the return view? try like this @foreach (var x in Model.Student) { if (tname != @x.TestName) { @x.TestName } tname = @x.TestName; } Regards, Iftikar

vidhya · Answer

public IList Student { get; set; }

vidhya · Answer

public List GetStudentsGradeBook(Guid courseSectionId) { int roler = (int)CourseSectionRoster.CourseRoleTypes.Student; List lsgb = new List (); var result = from p in _context.Person2 join cs in _context.CourseSectionRoster on p.PersonId equals cs.PersonId join a in _context.Assignments on cs.CourseSectionId equals a.CourseSectionId join t in _context.Test on cs.CourseSectionId equals t.CourseSectionId join asg in _context.AssignmentSubmission on a.AssignmentId equals asg.AssignmentId into asgn from agn in asgn.DefaultIfEmpty() where a.GradeBook == true && cs.CourseSectionId == courseSectionId && cs.CourseRole == roler select new {p.FirstName , p.LastName , a.AssignmentName , a.MakeAvailable , a.PointsPossible , a.DueDateTime,agn.PointsAwarded,agn.SubmissionDateTime ,t.TestName,t.TotalPoints }; //select new { p.FirstName, p.LastName, a.AssignmentName, a.MakeAvailable, a.PointsPossible, a.DueDateTime, agn.PointsAwarded }; foreach (var item in result) { StudentGradeBook sgb = new StudentGradeBook() { FirstName = item.FirstName, LastName = item.LastName, AssignmentName = item.AssignmentName, PointsPossible = item.PointsPossible, DueDateTime = Convert.ToDateTime(item.DueDateTime), PointsAwarded = item.PointsAwarded, //SubmissionDateTime =( (DateTime ?)item.SubmissionDateTime).HasValue ?Convert .ToDateTime (item .SubmissionDateTime ):Convert .ToDateTime ("1/1/0001") SubmissionDateTime =item .SubmissionDateTime , TestName =item.TestName, TotalPoints =item.TotalPoints }; lsgb.Add(sgb); } return lsgb.ToList(); }

Iftikar Hussain · Answer

I think the problem is in the Model. Can you tell me how you have bind the Model.Student? Regards, Iftikar

vidhya · Answer

@model MavinLMSService.ViewModels.Professor.GradeBook.IndexModel @{ ViewBag.Title = "Grade Book"; Layout = "~/Views/Shared/_PrimaryLayout.cshtml"; } @{ var tname="" ; } @foreach (GradeBook.StudentGradeBook x in Model.Student) { @tname // if(!(tname.Equals(@x.TestName))) if (tname != @x.TestName.ToString()) { @x.TestName } tname = @x.TestName.ToString(); }

Iftikar Hussain · Answer

can you share your complete razor code? Regards, Iftikar

vidhya · Answer

x contains test test test testing testing @tname displays test test testing testing test @x.TestName test test testing testing test

Iftikar Hussain · Answer

strange I am not getting..can you debug the out put like this and let me know the output @{ var tname="" ; } @foreach (StudentGradeBook x in Model.Student) { @tname if(tname!=@x.TestName.ToString()) { @x.TestName } tname = @x.TestName.ToString(); } Regards, Iftikar

vidhya · Answer

still i m getting duplicate value.

Iftikar Hussain · Answer

try this @{ var tname="" ; } @foreach (StudentGradeBook x in Model.Student) { if( tname!= @x.TestName.ToString() ) { @x.TestName } tname = @x.TestName.ToString(); } Regards, Iftikar

vidhya · Answer

still i m getting duplicate value. we can use list in view class?

Iftikar Hussain · Answer

Hi, Try like this @{ var tname="" ; } @foreach (StudentGradeBook x in Model.Student) { if(!(tname.Equals(@x.TestName))) { @x.TestName } tname = @x.TestName.ToString(); } Regards, Iftikar