title: For cricket project: Want to count bowlers spell and over
body: <p>I am currently working on cricket project. So i have to display that blower's spell and which over is running in current spell. 
  You can see screenshot here</p>
  
  <p><img src="https://i.stack.imgur.com/bSeaS.png" alt="Bowlers Over"></p>
  
  <p>For Ex.
  As in screenshot there is 4 bowler <code>b1</code>, <code>b2</code>, <code>b3</code>, <code>b4</code>.  </p>
  
  <ul>
  <li>When <code>B1</code> bowling 1st over then <code>spell = 1</code> and <code>spellover = 1</code></li>
  <li>When <code>B2</code> bowling 2nd over then <code>spell = 1</code> and <code>spellover = 1</code></li>
  <li>When <code>B1</code> bowling 3rd over then <code>spell = 1</code> and <code>spellover = 2</code></li>
  <li>When <code>B2</code> bowling 4th over then <code>spell = 1</code> and <code>spellover = 2</code></li>
  </ul>
  
  <p>Now bowler is change</p>
  
  <ul>
  <li>When <code>B3</code> bowling 5th over then <code>spell = 1</code> and <code>spellover = 1</code></li>
  <li>When <code>B4</code> bowling 6th over then <code>spell = 1</code> and <code>spellover = 1</code></li>
  <li>When <code>B3</code> bowling 7th over then <code>spell = 1</code> and <code>spellover = 2</code></li>
  <li>When <code>B4</code> bowling 8th over then <code>spell = 1</code> and <code>spellover = 2</code></li>
  </ul>
  
  <p>Now again bowler change and B1 and B2 is ready for bowling</p>
  
  <ul>
  <li>When <code>B1</code> bowling 9th over then <code>spell = 2</code> and <code>spellover = 1</code></li>
  <li>When <code>B2</code> bowling 10th over then <code>spell = 2</code> and <code>spellover = 1</code></li>
  </ul>
  
  <p>I want exactly above record of <code>spell</code> and <code>spellover</code> from database. When bowlers bowling continuous link break it means bowler's one spell is over.</p>
  
  <p>Here you can see my database record</p>
  
  <p><img src="https://i.stack.imgur.com/Zzu8H.png" alt="Database_Record"></p>
  
  <p>If any have idea in linq view then also you can suggest me how to do this in linq view.</p>