public void Save(DataSet ds, DbTransaction transaction) { DataRow drCourse = ds.Tables[Entities.Course.TABLE_NAME].Rows[0]; DACourse oDACourse = new DACourse(); DACourseMaterial oDACourseMaterial = new DACourseMaterial(); DACultureResources oDACr = new DACultureResources(); //Saving culture resources for Course name:Start DataTable dtCourseCr = ds.Tables[Entities.CultureResources.TABLE_NAME]; oDACr.PersistCultureResource(dtCourseCr, transaction); drCourse[Entities.Course.COURSE_NAME] = (Int64)dtCourseCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for Course name:Finish //Saving culture resources for Course desc:Start DataTable dtCourseDescCr = ds.Tables[Enumaration.ManageCourseKeys.DT_CourseDescriptionCultureRes]; oDACr.PersistCultureResource(dtCourseDescCr, transaction); drCourse[Entities.Course.DESCRIPTION] = (Int64)dtCourseDescCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for Course desc:Finish //Saving culture resources for Course Icon:Start DataTable dtCourseIconCr = ds.Tables[Enumaration.ManageCourseKeys.DT_CourseFileUploadCultureRes]; oDACr.PersistCultureResource(dtCourseIconCr, transaction); drCourse[Entities.Course.ICON] = (Int64)dtCourseIconCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for Course Icon:Finish //Saving Course Start oDACourse.SaveCourse(transaction, drCourse); string courseId = drCourse[Entities.Course.COURSE_ID].ToString(); //Saving Course Finish //Saving Course Material Start DataTable dtCourseMaterial = ds.Tables[Entities.CourseMaterial.TABLE_NAME]; oDACourseMaterial.DeleteCourseMaterialForCourseId(transaction, courseId); foreach (DataRow row in dtCourseMaterial.Rows) { row[Entities.CourseMaterial.COURSE_MATERIAL_ID] = DBNull.Value; row[Entities.CourseMaterial.COURSE_ID] = int.Parse(courseId); oDACourseMaterial.SaveCourseMaterial(transaction, row); } //Saving Course Material Finish }
public void PersistXML(DataRow drCourse, DACourse oDACourse) { string xmlId = "-1"; if (drCourse[Entities.Course.XML_ID] != DBNull.Value) { xmlId = drCourse[Entities.Course.XML_ID].ToString(); } Entities.SP_USP_CourseCultureXML sp = new Entities.SP_USP_CourseCultureXML(drCourse[Entities.Course.COURSE_ID].ToString(), xmlId ); DataSet dsXML = oDACourse.ExecuteStoredProcedure(Entities.SP_USP_CourseCultureXML.SP_NAME, sp.ParamsList); if (xmlId.Equals("-1")) { drCourse[Entities.Course.XML_ID] = Convert.ToInt64(dsXML.Tables[0].Rows[0][Entities.CultureXML.XML_ID].ToString()); oDACourse.SaveCourse(null, drCourse); } }