how do remove employee When one used

Question

1.00/5 (1 vote)

See more:

During my rdlc development client demand that base on total beats ,then there is employee available then put it ,or else put empty row ,i am using following code,but problem is that same employee is repeated, i thought that if we remove employee from the list when it is used,then it could be done.

C#

int SecBeat2 = _service.GetBeatBySector_Id(sectorId).Count();
           for (int i = 1; i <= SecBeat2; i++ )
           {
               var bsec4 = _service.GetAllBeatStatus().Where(x => x.Date == dt && x.Sector_Id == sectorId && x.Shift == 1).FirstOrDefault();

               if (bsec4 != null)
               {

                   Employee emp = _service.GetEmployee(bsec4.Employee_Id);
                   Beat beat = beats.FirstOrDefault(x => x.Id == bsec4.Beat_Id && x.Sector_Id == sectorId);
                   dataset.Beat.Rows.Add(
                     emp.Name,
                      emp.Id,
                      emp.CellNo
                       //bs1.HasWireless
              );


               }
               else
               {

                       dataset.Beat.Rows.Add("", "", "");


               }
           }

Posted 13-Mar-15 1:07am

Sajid227

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2015-03-13T01:42:00

Didn't we already seen this?

Try this:

C#

int SecBeat2 = _service.GetBeatBySector_Id(sectorId).Count();
            for (int i = 1; i <= SecBeat2; i++ )
            {
                var bsec4 = _service.GetAllBeatStatus().Where(x => x.Date == dt && x.Sector_Id == sectorId && x.Shift == 1).FirstOrDefault();
               
                if (bsec4 != null)
                {
                    
                    Employee emp = _service.GetEmployee(bsec4.Employee_Id);
                    Beat beat = beats.FirstOrDefault(x => x.Id == bsec4.Beat_Id && x.Sector_Id == sectorId);
            if (emp != null)
                    dataset.Beat.Rows.Add(
                      emp.Name,
                       emp.Id,
                       emp.CellNo
                        //bs1.HasWireless
            else
                dataset.Beat.Rows.Add("", "", "");
               );
                  
 
                }
            }

If your emp query returns default (probably null, adjust if it is not so) you will add empty row. If it finds the employee it will add it normally (assuming you have all needed objects ready (dataset) )

Good luck