SMS-22: Student Course Offer Entry happens Using Jquery Multiple Data Save List view dropdownlist Load using Angular js in ASP.NET MVC

12/5/2021 10:41:21 AM

Introduction

In this post, I will show How Student Course Offer Entry happens Using Jquery Multiple Data Save List view dropdownlist Load using Angular js in ASP.NET MVC.

Steps:

Step-1: In StudentCourseOfferDAL.cs Class Add AddNewInfoDAL().

Go to Solution Explorer > DAL Folder > StudentCourseOfferDAL.css with writing the below code.

public void AddNewInfoDAL(StudentCourseOfferDAO aDao)

{

int[] ids = aDao.CourseId.Split(',').Select(int.Parse).ToArray();

for(int i =0; i< ids.Length; i++)

{

int aId = ids[i];

SqlCommand com = new SqlCommand("sp_Insert_StudentCourseOffer_Info", conn);

com.CommandType = CommandType.StoredProcedure;

com.Parameters.AddWithValue("@StudentId", aDao.StudentId);

com.Parameters.AddWithValue("@TrimesterInfoId", aDao.TrimesterInfoId);

com.Parameters.AddWithValue("@CourseOfferDate", aDao.CourseOfferDate);

com.Parameters.AddWithValue("@CourseId", aId);

conn.Open();

com.ExecuteNonQuery();

conn.Close();

}

Step-2: Create store Procedure for Save Student Course Offer.
Go to SQL Server 2014 > dbStudentMangeSystem database> Programmability> stored procedures> Select New> stored procedure>Create sp_Insert_StudentCourseOffer_Info

with writing the below code.

create PROCEDURE [dbo].[sp_Insert_StudentCourseOffer_Info]

-- Add the parameters for the stored procedure here

@CourseId int=null ,

@TrimesterInfoId int=null ,

@StudentId int=null ,

@CourseOfferDate datetime=null

AS

BEGIN

INSERT INTO [dbo].[tblStudentCourseOffer]

([CourseId]

,[TrimesterInfoId]

,[StudentId]

,[CourseOfferDate])

VALUES

(@CourseId

,@TrimesterInfoId

,@StudentId

,@CourseOfferDate)

END

Step-3: StudentCourseOfferList page with writing the below code.

<h1 class="m-0 text-dark">Student Course Offer List</h1>

</div>

</ol>

</div>

</div>

</div>

</div>

<label>Student ID & Name</label>

<option ng-repeat="e in StudentIDNO" value="{{e.StudentId}}">{{e.StudentIdNO}}</option>

</select>

</div>

<label>Trimester Name</label>

<option ng-repeat="e in Trimester" value="{{e.TrimesterInfoId}}">{{e.TrimesterInfoName}}</option>

</select>

</div>

<br />

<button type="button" class="btn btn-success" onclick="GetList()" >Search</button>

</div>

<thead>

<tr>

<td>Course Name</td>

</tr>

</thead>

</tbody>

</table>

</div>

</section>

</div>

Step-4: search button click to get Student Course Offer List by select Student ID and Trimester Name StudentCourseOfferList page with writing the below code.

function GetList() {

var prm = "";

if ($('#StudentId').val() != "") {

prm = prm + " and StudentId ='" + $('#StudentId').val() + "'";

}

if ($('#TrimesterInfoId').val() != "") {

prm = prm + " and TrimesterInfoId ='" + $('#TrimesterInfoId').val() + "'";

}

var urlPath = '@Url.Action("GetStudentCourseOfferList", "StudentCourseOffer")';

$.ajax({

url: urlPath,

dataType: 'json',