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); }
public IHttpActionResult UpdateSemesterCourseAssociation(SemesterCourseAssociation semesterCourseAssociation) { return(Ok(new { results = semesterCourseAssociationService.UpdateSemesterCourseAssociation(semesterCourseAssociation) })); }
public List <SemesterCourseAssociation> UpdateSemesterCourseAssociation(SemesterCourseAssociation semesterCourseAssociation) { return(SemesterCourseAssociationDS.UpdateSemesterCourseAssociation(semesterCourseAssociation)); }