This course will teach you to create and update course information using store procedure in ASP.NET MVC JQUERY and AngularJS. Will show how you can load data using storeprocedure and load data in your dropdown list using jquery angularjs and javascript along with ASP.NET MVC framework.

Steps:

Step-1:

• Add GetMAsterDataByID() JsonResult CourseController.cs Controller.
• Go to Solution Explorer > Controllers Folder>   CourseController.css>    in this controller with writing the below code.

        public JsonResult GetMAsterDataByID(int MasterId)
        {
            DataSet ds = aDal.LoadDataByMasterIDDAL(MasterId);
            List<CourseDAO> lists = new List<CourseDAO>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                lists.Add(new CourseDAO
                {
                    CourseId = Convert.ToInt32(dr["CourseId"]),
                    SectionId = Convert.ToInt32(dr["SectionId"]),

                    CourseName = Convert.ToString(dr["CourseName"]),
                    BatchId = Convert.ToInt32(dr["BatchId"])
                });
                //ddlLoadSectonbyBatchID(Convert.ToInt32(dr["BatchId"]));
            }
            return Json(lists, JsonRequestBehavior.AllowGet);
        } 

Step-2:

• Add LoadDataByMasterIDDAL() in CourseDAL.css  class.
• Go to Solution Explorer > DAL Folder > CourseDAL.css  Class with writing the below code.

        public DataSet LoadDataByMasterIDDAL(int CourseId)
        {
            SqlCommand com = new SqlCommand("Get_CourseMaterDataById", conn);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@CourseId", CourseId);
            SqlDataAdapter da = new SqlDataAdapter(com);
            DataSet dss = new DataSet();
            da.Fill(dss);
            return dss;
        }

Step-3:

• Create store Procedure for Course Get One Record.
• Go to SQL Server 2014 > dbStudentMangeSystem database> Programmability> stored procedures> Select New> stored procedure>Create Get_CourseMaterDataById with writing the below code.

create proc [dbo].[Get_CourseMaterDataById]
@CourseId int
as
begin
select * from tblCourse where CourseId=@CourseId

end

Step-4:

• Add GetOneRecord() Function in  CourseControllerJS.js.
• Go to Solution Explorer > Scripts Folder.> AngularController Folder> ‘CourseControllerJS.js’> to get one record.

   $scope.GetOneRecord = function (CourseId) {
        $http.get("/Course/GetMAsterDataByID?MasterId=" + CourseId).then(function (d) {
              $scope.CourseDAO = d.data[0];
              $scope.btnSaveTextCo = "Update";
              $http.get("/Course/ddlLoadSectonbyBatchID?BatchId=" + d.data[0].BatchId).then(function(d) {
                  $scope.Section = d.data;
              }, function (error) {
                  alert("Faild");
              });
        }, function (error) {
            alert("Faild");
        });
    };

For Update Course Information follow below step

Step-5:

• Add Update_Info() JsonResult CourseController.cs Controller.

        public JsonResult Update_Info(CourseDAO aDao)
        {
            string Mes = "";
            try
            {
                aDal.UpdateInfoDAL(aDao);
                Mes = "Operation Successful!!";
            }
            catch (Exception e)
            {
                Mes = "Operation Faild!!";
            }
            return Json(Mes, JsonRequestBehavior.AllowGet);
        }

Step-6:

• Add UpdateInfoDAL() in CourseDAL.css  class.
• Go to Solution Explorer > DAL Folder > CourseDAL.css  Class with writing the below code.

        public void UpdateInfoDAL(CourseDAO aDao)
        {
            SqlCommand com = new SqlCommand("Update_CourseByMasterId", conn);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@CourseId", aDao.CourseId);
            com.Parameters.AddWithValue("@CourseName", aDao.CourseName);
            com.Parameters.AddWithValue("@BatchId", aDao.BatchId);
            com.Parameters.AddWithValue("@SectionId", aDao.SectionId);
            conn.Open();
            com.ExecuteNonQuery();
            conn.Close();
        }

Step-7:

• Create store Procedure for Course Get One Record.
• Go to SQL Server 2014 > dbStudentMangeSystem database> Programmability> stored procedures> Select New> stored procedure>Create Update_CourseByMasterId with writing the below code.

create proc [dbo].[Update_CourseByMasterId]

@CourseId int,
@CourseName nvarchar(500),
@BatchId  int,
@SectionId int
as 

begin

update tblCourse set  CourseName=@CourseName, BatchId=@BatchId,SectionId= @SectionId  where CourseId=@CourseId
end

Step-8:

• Add Update Info in  CourseControllerJS.js file.
• Go to Solution Explorer > Scripts Folder.> AngularController Folder> Create   ‘CourseControllerJS.js’> for   update information    with writing the below highlight code.

  $scope.SaveData = function () {
        if ($scope.btnSaveTextCo == "Save") {
            $scope.btnSaveTextCo = "Saving.....";
            $http({
                method: 'POST',
                url: '/Course/Save_Info',
                data: $scope.CourseDAO
            }).success(function (a) {
                $scope.btnSaveTextCo = "Save";
                $scope.CourseDAO = null;
                alert(a);
            }).error(function () {
                alert("Faild");
            });
        } else {
            $scope.btnSaveTextCo = "Updating.....";
            $http({
                method: 'POST',
                url: '/Course/Update_Info',
                data: $scope.CourseDAO
            }).success(function (a) {
                $scope.btnSaveTextCo = "Save";
                $scope.CourseDAO = null;
                alert(a);
            }).error(function () {
                alert("Faild");
            });
        }
    };

Step-9: Run Application.

Step-10:

• Add Controller  StudentController.cs.
• Go to Solution Explorer > Controllers Folder> Add > Controller> Select MVC 5 Controller-Empty> Click ‘Add’ button> Give Controller Name ’ StudentController’ >  in this controller with writing the below code.

       public ActionResult StudentList()
        {
            return View();
        }

• In the StudentList() Action Result Mouse right button Select Add View > Click Add Button> StudentList.cshtml  page has been created.
• Add Another Action result SectionEntry()with writing the below code.

        public ActionResult StudentEntry()
        {
            return View();
        }

In the StudentEntry() Action Result Mouse right button Select Add View > Click Add Button> StudentEntry.cshtml  page has been created.

Step-11: Run Application.