コード例 #1
0
        public static List <SemesterCourseAssociation> UpdateSemesterCourseAssociation(SemesterCourseAssociation semesterCourseAssociation)
        {
            AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
            DataSet   ds        = new DataSet();

            SqlParameter[] sqlParameter =
            {
                new SqlParameter("@SetAction",  semesterCourseAssociation.SetAction.ToUpper()),
                new SqlParameter("@SemesterId", semesterCourseAssociation.SemesterId),
                new SqlParameter("@CourseIds",  semesterCourseAssociation.CourseIds)
            };

            ds = objHelper.ExecDataSetProc("Gkl_USP_UpdateSemesterCourseAssociation", sqlParameter);
            List <SemesterCourseAssociation> objlm = null;

            objlm = ds.Tables[0].AsEnumerable()
                    .Select(row => new SemesterCourseAssociation
            {
                SemesterId = row.Field <int>("SemesterId"),
                CourseId   = row.Field <int>("CourseId"),
                CourseCode = Common.ConvertFromDBVal <string>(row["CourseCode"]),
                CourseName = Common.ConvertFromDBVal <string>(row["CourseName"])
            }).ToList();

            return(objlm);
        }
コード例 #2
0
 public IHttpActionResult UpdateSemesterCourseAssociation(SemesterCourseAssociation semesterCourseAssociation)
 {
     return(Ok(new { results = semesterCourseAssociationService.UpdateSemesterCourseAssociation(semesterCourseAssociation) }));
 }
コード例 #3
0
 public List <SemesterCourseAssociation> UpdateSemesterCourseAssociation(SemesterCourseAssociation semesterCourseAssociation)
 {
     return(SemesterCourseAssociationDS.UpdateSemesterCourseAssociation(semesterCourseAssociation));
 }