avoid the duplicate,only once need to display in mvc

vidhya

13y15.8k.NET

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)))
{
@x.TestName
}
tname = @x.TestName.ToString();
}

If x contains
test
test
test
testing
testing

But i need to display

test
testing

47 Replies

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

Shakil Ahmed8y ago
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-------------------------

+1
Sunny Sharma13y ago
It's OK. See me if you need me on C# Corner.

Cheer up!
0
vidhya13y ago
i have done some wrong in linq,after some clarification with client, i continue.

i think , dont want to waste yr time.
0
Sunny Sharma13y ago
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.
0
vidhya13y ago
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())
{
}
0
Sunny Sharma13y ago
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.
0
vidhya13y ago
@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.
0
Sunny Sharma13y ago
vidhya, feedback awaited on my previous reply.
0
Sunny Sharma13y ago
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
}

-------------------------------------------
0
vidhya13y ago
@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.
0
vidhya13y ago

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
0
Sunny Sharma13y ago
you mean total points for individual/unioque testNames or just totals for each gradeBook?
0
vidhya13y ago
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
}
0
Sunny Sharma13y ago
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()
}

--------------------------------------
0
vidhya13y ago
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.
0
Sunny Sharma13y ago
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:

Feedback awaited.

Cheers!
0
vidhya13y ago
no improvement still same
0
Iftikar Hussain13y ago
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) < 0)
{

}
arrayName[i] = x.TestName;
i++;
}

@foreach (var x in Model.Student)
{
if (Array.IndexOf(arrayPoints, @x.TotalPoints) < 0)
{

}
arrayPoints[j] = x.TotalPoints;
j++;
}

@x.TestName
@x.TotalPoints

Regards,
Iftikar
0
vidhya13y ago
i followed your code but i displays duplicate
0
Iftikar Hussain13y ago
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) < 0)
{

}
arrayName[i] = x.TestName;
i++;
}


@foreach (var y in Model.Student)
{
if (Array.IndexOf(arrayPoints, @y.TotalPoints) < 0)
{

}
  arrayPoints[j] = y.TotalPoints.ToString ();
j++;
}

@x.TestName
@y.TotalPoints

Regards,
Iftikar
0
vidhya13y ago
@{
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) < 0)
{

}
arrayName[i] = x.TestName;
i++;
}

@foreach (var y in Model.Student)
{
if (Array.IndexOf(arrayName, @y.TotalPoints) < 0)
{

}
arrayName[j] = y.TotalPoints.ToString ();
j++;
}

@x.TestName
@y.TotalPoints

For testname it work fine, same i tried for total points i does not work. y?
0
Iftikar Hussain13y ago
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) < 0)
{

}
arrayName[i] = x.TestName;
i++;
}

@x.TestName

Regards,
Iftikar
0
vidhya13y ago
s absoultely
0
Iftikar Hussain13y ago
If the

xvalue contains

test
testing
pretest
test
testing
prestest

the output should be?

test
testing
pretest
prestest

Regards,
Iftikar
0
vidhya13y ago
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
0
Iftikar Hussain13y ago
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
0
vidhya13y ago
x contains
test
test
test
testing
testing

@x.TestName displays like this
test
test
testing
testing
test
0
Iftikar Hussain13y ago
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
0
vidhya13y ago
string datatype.
0
Iftikar Hussain13y ago
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
0
vidhya13y ago
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)
{

// if(!(tname.Equals(@x.TestName)))
if (tname != @x.TestName.ToString())
{

}
tname = @x.TestName.ToString();
}

@tname @x.TestName
0
Iftikar Hussain13y ago
this is also looks fine, can you attach your cshtml file?

Regards,
Iftikar
0
vidhya13y ago
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;

}
0
Iftikar Hussain13y ago
from the controller, what is the return view?

Regards,
Iftikar
0
vidhya13y ago
still same no improvement.
0
Iftikar Hussain13y ago
from the controller, what is the return view?

try like this

@foreach (var x in Model.Student)
{
if (tname != @x.TestName)
{

}
tname = @x.TestName;
}

@x.TestName

Regards,
Iftikar
0
vidhya13y ago
public IList Student { get; set; }
0
vidhya13y ago
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();

}
0
Iftikar Hussain13y ago
I think the problem is in the Model. Can you tell me how you have bind the Model.Student?

Regards,
Iftikar
0
vidhya13y ago
@model MavinLMSService.ViewModels.Professor.GradeBook.IndexModel

@{
ViewBag.Title = "Grade Book";
Layout = "~/Views/Shared/_PrimaryLayout.cshtml";
}
@{
var tname="" ;

}


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

// if(!(tname.Equals(@x.TestName)))
if (tname != @x.TestName.ToString())
{

}
tname = @x.TestName.ToString();
}

@tname @x.TestName
0
Iftikar Hussain13y ago
can you share your complete razor code?

Regards,
Iftikar
0
vidhya13y ago
x contains
test
test
test
testing
testing

@tname displays
test
test
testing
testing
test

@x.TestName
test
test
testing
testing
test
0
Iftikar Hussain13y ago
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([email protected]())
{
@x.TestName
}
tname = @x.TestName.ToString();
}

Regards,
Iftikar
0
vidhya13y ago
still i m getting duplicate value.
0
Iftikar Hussain13y ago
try this

@{
var tname="" ;

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

if(tname!=@x.TestName.ToString())
{
@x.TestName
}
tname = @x.TestName.ToString();
}

Regards,
Iftikar
0
vidhya13y ago
still i m getting duplicate value.

we can use list in view class?
0
Iftikar Hussain13y ago
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
0