public void Save(DataSet ds) { objDARooms = new DATrainingRooms(); DACultureResources oDACr = new DACultureResources(); using (DbTransaction transaction = objDARooms.CreateTransaction()) { try { DataTable dtRoom = ds.Tables[Entities.TrainingRooms.TABLE_NAME]; DataRow room = dtRoom.Rows[0]; //Saving culture resources for slide name:Start DataTable dtCr = ds.Tables[Entities.CultureResources.TABLE_NAME]; oDACr.PersistCultureResource(dtCr, transaction); room[Entities.TrainingRooms.ROOM_NAME] = (Int64)dtCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for slide name:Finish objDARooms.Save(transaction, room); objDARooms.CommitTransaction(transaction); } catch (Exception e) { objDARooms.RollbackTransaction(transaction); throw e; } } }
private static void SaveSurveyChoices(DataSet ds, DbTransaction transaction, DACultureResources oDACr, Int64 slideId) { DASurveyChoices oDACat = new DASurveyChoices(); DataTable dtChoice = ds.Tables[Entities.SlideSurveyChoices.TABLE_NAME]; foreach (DataRow dr in dtChoice.Rows) { if (!dr[Entities.SlideSurveyChoices.IS_CHANGED].ToString().Equals("1") && !dr[Entities.SlideSurveyChoices.IS_NEW].ToString().Equals("1") && !dr[Entities.SlideSurveyChoices.IS_DELETED].ToString().Equals("1")) { continue; } DataTable dtCulture = Entities.CultureResources.GetDataTable(); DataRow row = dtCulture.NewRow(); foreach (DataColumn col in dtCulture.Columns) { if (dtChoice.Columns.Contains(col.ColumnName)) { row[col.ColumnName] = dr[col.ColumnName]; } } row[Entities.CultureResources.ID] = dr[Entities.SlideSurveyChoices.CHOICE_TEXT]; oDACr.PersistCultureResource(row, transaction); if (dr[Entities.SlideSurveyChoices.IS_NEW].ToString().Equals("1")) { dr[Entities.SlideSurveyChoices.CHOICE_TEXT] = row[Entities.CultureResources.ID]; dr[Entities.SlideSurveyChoices.SLIDE_ID] = slideId; dr[Entities.SlideSurveyChoices.CHOICE_ID] = DBNull.Value; } oDACat.Save(transaction, dr); } }
public DataSet Save(DataSet ds, string phase, string year, string createdBy) { DACultureResources oDACultureRes = new DACultureResources(); Entities.SP_USP_ImportMysteryShopper objSP = new Entities.SP_USP_ImportMysteryShopper(createdBy, phase, year, ds.GetXml()); DataSet dsMysteryShopperHeader = oDACultureRes.ExecuteStoredProcedure(Entities.SP_USP_ImportMysteryShopper.SP_NAME, objSP.ParamsList); return(dsMysteryShopperHeader); }
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 DataSet GetMysteryShopperById(string mysteryShopperId) { DACultureResources oDACultureRes = new DACultureResources(); Entities.SP_USP_GetMysteryShopperById usp = new Entities.SP_USP_GetMysteryShopperById(mysteryShopperId.ToString()); DataSet ds = oDACultureRes.ExecuteStoredProcedure(Entities.SP_USP_GetMysteryShopperById.SP_NAME, usp.ParamsList); ds.Tables[0].TableName = Entities.MysteryShopperHeader.TABLE_NAME; ds.Tables[1].TableName = Entities.MysteryShopperData.TABLE_NAME; return(ds); }
public DataSet GetQuestionSectionById(string id) { DACultureResources ODaCr = new DACultureResources(); DataSet dsReturn = oDAQs.GetSectionById(id); dsReturn.Tables[0].TableName = Entities.QuestionSections.TABLE_NAME; dsReturn.Tables.Add(ODaCr.GetCultureResourceById(dsReturn.Tables[0].Rows[0][Entities.QuestionSections.SECTION_NAME].ToString()) ); return(dsReturn); }
private void SaveSurveyDetails(DataSet ds, DbTransaction transaction, DACultureResources oDACr, Int64 slideId) { //Saving Categories Start SaveSurveyCategories(ds, transaction, oDACr, slideId); //Saving Categories Finish //Saving Choice Start SaveSurveyChoices(ds, transaction, oDACr, slideId); //Saving Choice Finish //Saving Questions Start SaveSurveyQuestions(ds, transaction, oDACr, slideId); //Saving Questions Finish }
private void SaveSurveyCategories(DataSet ds, DbTransaction transaction, DACultureResources oDACr, Int64 slideId) { DASlideSurveyCategory oDACat = new DASlideSurveyCategory(); DataTable dtCategory = ds.Tables[Entities.SlideSurveyCategory.TABLE_NAME]; foreach (DataRow dr in dtCategory.Rows) { if (!dr[Entities.SlideSurveyCategory.IS_CHANGED].ToString().Equals("1") && !dr[Entities.SlideSurveyCategory.IS_NEW].ToString().Equals("1") && !dr[Entities.SlideSurveyCategory.IS_DELETED].ToString().Equals("1") ) { continue; } DataTable dtCategoryCulture = Entities.CultureResources.GetDataTable(); DataRow row = dtCategoryCulture.NewRow(); foreach (DataColumn col in dtCategoryCulture.Columns) { if (dtCategory.Columns.Contains(col.ColumnName)) { row[col.ColumnName] = dr[col.ColumnName]; } } row[Entities.CultureResources.ID] = dr[Entities.SlideSurveyCategory.CATEGORY_TEXT]; int tempCategoryId = -1; oDACr.PersistCultureResource(row, transaction); if (dr[Entities.SlideSurveyCategory.IS_NEW].ToString().Equals("1")) { dr[Entities.SlideSurveyCategory.CATEGORY_TEXT] = row[Entities.CultureResources.ID]; dr[Entities.SlideSurveyCategory.SLIDE_ID] = slideId; tempCategoryId = Convert.ToInt32(dr[Entities.SlideSurveyCategory.CATEGORY_ID]); dr[Entities.SlideSurveyCategory.CATEGORY_ID] = DBNull.Value; } oDACat.Save(transaction, dr); //adding for the first time we assign a temp id to category. If this category has been associated with the survey question then we //have to remove the temp id from survey question and assign the db id to it.For this purpose we are storing temp id in dictionary along //with the db id.Later on adding survey questions we will retrieve the db id from this dictionary and change the temp id of question category if (tempCategoryId > 0) { dicCategoryTempActualId.Add(tempCategoryId, Convert.ToInt32(dr[Entities.SlideSurveyCategory.CATEGORY_ID]) ); } } }
public DataSet GetDrivingAssessmentTestForDriver(string refNum) { DACultureResources oDA = new DACultureResources(); Entities.SP_USP_GetDrivingAssessmentTestForDriver usp = new Entities.SP_USP_GetDrivingAssessmentTestForDriver(refNum); DataSet ds = oDA.ExecuteStoredProcedure(Entities.SP_USP_GetDrivingAssessmentTestForDriver.SP_NAME, usp.ParamsList); if (ds != null) { if (!ds.Tables[0].Columns.Contains(Entities.SP_USP_GetDrivingAssessmentTestForDriver.MUTILPLE_PERSON) && !ds.Tables[0].Columns.Contains(Entities.SP_USP_GetDrivingAssessmentTestForDriver.NO_PERSON) ) { ds.Tables[0].TableName = Entities.Persons.TABLE_NAME; ds.Tables[1].TableName = Entities.DrivingAssessmentTest.TABLE_NAME; ds.Tables[2].TableName = Entities.DrivingAssessmentDetails.TABLE_NAME; ds.Tables[3].TableName = Entities.DrivingAssessmentImages.TABLE_NAME; } } return(ds); }
private void SaveSurveyQuestions(DataSet ds, DbTransaction transaction, DACultureResources oDACr, Int64 slideId) { DASurveyQuestion oDA = new DASurveyQuestion(); DataTable dtSurveyQuestion = ds.Tables[Entities.SlideSurveyQuestions.TABLE_NAME]; foreach (DataRow dr in dtSurveyQuestion.Rows) { //Only persist those rows that are new or changed if (!dr[Entities.SlideSurveyQuestions.IS_CHANGED].ToString().Equals("1") && !dr[Entities.SlideSurveyQuestions.IS_NEW].ToString().Equals("1") && !dr[Entities.SlideSurveyQuestions.IS_DELETED].ToString().Equals("1")) { continue; } DataTable dtQuestionCulture = Entities.CultureResources.GetDataTable(); DataRow row = dtQuestionCulture.NewRow(); foreach (DataColumn col in dtQuestionCulture.Columns) { if (dtSurveyQuestion.Columns.Contains(col.ColumnName)) { row[col.ColumnName] = dr[col.ColumnName]; } } row[Entities.CultureResources.ID] = dr[Entities.SlideSurveyQuestions.SURVEY_QUESTION_TEXT]; oDACr.PersistCultureResource(row, transaction); int id = Convert.ToInt32(dr[Entities.SlideSurveyQuestions.CATEGORY_ID]); if (dr[Entities.SlideSurveyQuestions.IS_NEW].ToString().Equals("1")) { dr[Entities.SlideSurveyQuestions.SURVEY_QUESTION_TEXT] = row[Entities.CultureResources.ID]; dr[Entities.SlideSurveyQuestions.SLIDE_ID] = slideId; dr[Entities.SlideSurveyQuestions.SURVEY_QUESTION_ID] = DBNull.Value; } if (dicCategoryTempActualId.ContainsKey(id)) { dr[Entities.SlideSurveyQuestions.CATEGORY_ID] = dicCategoryTempActualId[id]; } oDA.Save(transaction, dr); } }
public void Save(DataSet ds, DbTransaction transaction) { DataRow drSlide = ds.Tables[Entities.TrainingSlide.TABLE_NAME].Rows[0]; DASlide oDASlide = new DASlide(); DACultureResources oDACr = new DACultureResources(); //Saving culture resources for slide name:Start DataTable dtSlideCr = ds.Tables[Entities.CultureResources.TABLE_NAME]; PersistSlideCultureText(transaction, drSlide, oDACr, dtSlideCr); //Saving culture resources for slide name:Finish //Saving culture resources for slide main details:Start SaveSlideFiles(ds, transaction, drSlide, oDACr); //Saving culture resources for slide main details:Finish //Saving slide Start oDASlide.SaveSlides(transaction, drSlide); Int64 slideId = Convert.ToInt64(drSlide[Entities.TrainingSlide.SLIDE_ID]); //Saving slide Finish switch (int.Parse(drSlide[Entities.TrainingSlide.SLIDE_TYPE].ToString())) { case (int)Enumaration.SlideType.Questionnaire: { SaveSurveyDetails(ds, transaction, oDACr, slideId); break; } case (int)Enumaration.SlideType.Navigation: { SaveNavigationDetails(ds, transaction, oDACr, slideId); break; } } }
public void PersistExamTemplate(DataSet ds) { DAExamTemplate daET = new DAExamTemplate(); DACultureResources daCR = new DACultureResources(); using (DbTransaction transaction = daET.CreateTransaction()) { try { DataTable dtCR = ds.Tables[Entities.CultureResources.TABLE_NAME]; DataTable dtET = ds.Tables[Entities.TestTemplate.TABLE_NAME]; DataTable dtSWQ = ds.Tables[Entities.TestTemplateSectionWiseQuestions.TABLE_NAME]; daCR.PersistCultureResource(dtCR, transaction); dtET.Rows[0][Entities.TestTemplate.CULTURE_NAME] = (Int64)dtCR.Rows[0][Entities.CultureResources.ID]; daET.PersistExamTemplates(dtET, dtSWQ, transaction); daET.CommitTransaction(transaction); } catch (Exception e) { daET.RollbackTransaction(transaction); throw e; } } }
public void PersistQuestionSections(DataSet ds) { DAQuestionSections daQS = new DAQuestionSections(); DACultureResources daCR = new DACultureResources(); using (DbTransaction transaction = daQS.CreateTransaction()) { try { DataTable dtCR = ds.Tables[Entities.CultureResources.TABLE_NAME]; DataTable dtQS = ds.Tables[Entities.QuestionSections.TABLE_NAME]; daCR.PersistCultureResource(dtCR, transaction); dtQS.Rows[0][Entities.QuestionSections.SECTION_NAME] = (Int64)dtCR.Rows[0][Entities.CultureResources.ID]; daQS.PersistQuestionSections(dtQS, transaction); daQS.CommitTransaction(transaction); } catch (Exception e) { daQS.RollbackTransaction(transaction); throw e; } } }
public void Save(DataSet ds) { DACultureResources oDACr = new DACultureResources(); DataRow drTrainingTemplate = null; using (System.Data.Common.DbTransaction transaction = oDACr.CreateTransaction()) { try { drTrainingTemplate = ds.Tables[Entities.TrainingTemplate.TABLE_NAME].Rows[0]; DATrainingTemplate oDATrainingTemplate = new DATrainingTemplate(); DATrainingTempFinesOnAbsent oDAFines = new DATrainingTempFinesOnAbsent(); DATrainingTemplatePlan oDAPlan = new DATrainingTemplatePlan(); //Saving culture resources for TrainingTemplate desc:Start DataTable dtTrainingTemplateDescCr = ds.Tables[Enumaration.ManageTrainingTemplateKeys.DT_TrainingTemplateDescriptionCultureRes]; oDACr.PersistCultureResource(dtTrainingTemplateDescCr, transaction); drTrainingTemplate[Entities.TrainingTemplate.DESCRIPTION] = (Int64)dtTrainingTemplateDescCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for TrainingTemplate desc:Finish //Saving culture resources for TrainingTemplate name:Start DataTable dtTrainingTemplateNameCr = ds.Tables[Enumaration.ManageTrainingTemplateKeys.DT_TrainingTemplateNameCultureRes]; oDACr.PersistCultureResource(dtTrainingTemplateNameCr, transaction); drTrainingTemplate[Entities.TrainingTemplate.TRAINING_NAME] = (Int64)dtTrainingTemplateNameCr.Rows[0][Entities.CultureResources.ID]; //Saving culture resources for TrainingTemplate name:Finish //Saving TrainingTemplate Start oDATrainingTemplate.SaveTrainingTemplate(transaction, drTrainingTemplate); string TrainingTemplateId = drTrainingTemplate[Entities.TrainingTemplate.TRAINING_TEMP_ID].ToString(); //Saving TrainingTemplate Finish //Saving TrainingTemplate Fine Start DataTable dtTrainingTemplateMaterial = ds.Tables[Entities.TrainingTempFinesOnAbsent.TABLE_NAME]; oDAFines.DeleteTrainingTempFinesOnAbsentForTrainingTempId(transaction, TrainingTemplateId); foreach (DataRow row in dtTrainingTemplateMaterial.Rows) { row[Entities.TrainingTempFinesOnAbsent.TEMP_FINES_ABSENT_ID] = DBNull.Value; row[Entities.TrainingTempFinesOnAbsent.TRAINING_TEMP_ID] = int.Parse(TrainingTemplateId); oDAFines.SaveFinesOnAbsent(transaction, row); } //Saving TrainingTemplate Fine Finish //Saving TrainingTemplate Plan Start DataTable dtPlan = ds.Tables[Entities.TrainingTemplatePlan.TABLE_NAME]; oDAPlan.DeleteTrainingTemplatePlanForTrainingTempId(transaction, TrainingTemplateId); foreach (DataRow row in dtPlan.Rows) { row[Entities.TrainingTemplatePlan.TEMPLATE_PLAN_ID] = DBNull.Value; row[Entities.TrainingTemplatePlan.TRAINING_TEMP_ID] = int.Parse(TrainingTemplateId); oDAPlan.SavePlan(transaction, row); } //Saving TrainingTemplate Plan Finish oDACr.CommitTransaction(transaction); } catch (Exception ex) { oDACr.RollbackTransaction(transaction); throw ex; } } if (drTrainingTemplate != null) { PersistTrainingXML(drTrainingTemplate); } }
private void SaveSlideFiles(DataSet ds, DbTransaction transaction, DataRow drSlide, DACultureResources oDACr) { DataTable dtSlideFileUpload = ds.Tables[Enumaration.ManageSlideKeys.DT_SlideFileUploadCultureRes]; foreach (DataRow dr in dtSlideFileUpload.Rows) { oDACr.PersistCultureResource(dr, transaction); switch (dr[Entities.CultureResources.TYPE].ToString()) { case "1": drSlide[Entities.TrainingSlide.ANIMATION_ID] = dr[Entities.CultureResources.ID]; break; case "2": drSlide[Entities.TrainingSlide.AUDIO_ID] = dr[Entities.CultureResources.ID]; break; case "3": drSlide[Entities.TrainingSlide.IMAGE_ID] = dr[Entities.CultureResources.ID]; break; } } }
private void SaveNavigationDetails(DataSet ds, DbTransaction transaction, DACultureResources oDACr, Int64 slideId) { DataTable dtChoice = ds.Tables[Entities.SlideNavigation.TABLE_NAME]; DataTable dtCR = ds.Tables[Enumaration.ManageSlideKeys.DT_SlideNavigationCultureRes]; DataTable dtLinks = ds.Tables[Entities.SlideNavigationLinks.TABLE_NAME]; Dictionary <string, string> dictionary = new Dictionary <string, string>(); foreach (DataRow dr in dtCR.Rows) { string key = string.Empty; key = dr[Entities.CultureResources.ID].ToString(); if (dr[Entities.CultureResources.IS_NEW].ToString().Equals("1")) { //key = dr[Entities.CultureResources.ID].ToString(); dr[Entities.CultureResources.ID] = DBNull.Value; } oDACr.PersistCultureResource(dr, transaction); //if (dr[Entities.CultureResources.IS_NEW].ToString().Equals("1")) //{ dictionary.Add(key, dr[Entities.CultureResources.ID].ToString()); //} } DASlideNavigation oDA = new DASlideNavigation(); DASlideNavLinks oDALinks = new DASlideNavLinks(); foreach (DataRow dr in dtChoice.Rows) { string navigationChoiceId = string.Empty; bool isNewOrChanged = (dr[Entities.SlideNavigation.IS_NEW].ToString().Equals("1") || dr[Entities.SlideNavigation.IS_CHANGED].ToString().Equals("1") ); bool isIncompleteAddition = dr[Entities.SlideNavigation.IS_ADDING].ToString().Equals("1"); string oldNavigationChoiceId = string.Empty; if (isNewOrChanged && !isIncompleteAddition) { if (dr[Entities.SlideNavigation.IS_NEW].ToString().Equals("1")) { oldNavigationChoiceId = dr[Entities.SlideNavigation.NAVIGATION_CHOICE_ID].ToString(); dr[Entities.SlideNavigation.NAVIGATION_CHOICE_ID] = DBNull.Value; dr[Entities.SlideNavigation.SLIDE_ID] = slideId; } else { oldNavigationChoiceId = dr[Entities.SlideNavigation.NAVIGATION_CHOICE_ID].ToString(); } if (dictionary.ContainsKey(dr[Entities.SlideNavigation.TITLE].ToString())) { dr[Entities.SlideNavigation.TITLE] = Convert.ToInt64(dictionary[dr[Entities.SlideNavigation.TITLE].ToString()]); } if (dictionary.ContainsKey(dr[Entities.SlideNavigation.AUDIO].ToString())) { dr[Entities.SlideNavigation.AUDIO] = Convert.ToInt64(dictionary[dr[Entities.SlideNavigation.AUDIO].ToString()]); } else { dr[Entities.SlideNavigation.AUDIO] = DBNull.Value; } if (dictionary.ContainsKey(dr[Entities.SlideNavigation.DESCRIPTION].ToString())) { dr[Entities.SlideNavigation.DESCRIPTION] = Convert.ToInt64(dictionary[dr[Entities.SlideNavigation.DESCRIPTION].ToString()]); } else { dr[Entities.SlideNavigation.DESCRIPTION] = DBNull.Value; } if (dictionary.ContainsKey(dr[Entities.SlideNavigation.IMAGE].ToString())) { dr[Entities.SlideNavigation.IMAGE] = Convert.ToInt64(dictionary[dr[Entities.SlideNavigation.IMAGE].ToString()]); } else { dr[Entities.SlideNavigation.IMAGE] = DBNull.Value; } if (dictionary.ContainsKey(dr[Entities.SlideNavigation.VIDEO].ToString())) { dr[Entities.SlideNavigation.VIDEO] = Convert.ToInt64(dictionary[dr[Entities.SlideNavigation.VIDEO].ToString()]); } else { dr[Entities.SlideNavigation.VIDEO] = DBNull.Value; } oDA.Save(transaction, dr); navigationChoiceId = dr[Entities.SlideNavigation.NAVIGATION_CHOICE_ID].ToString(); DataRow[] links = dtLinks.Select(Entities.SlideNavigationLinks.NAVIGATION_CHOICE_ID + "=" + oldNavigationChoiceId); foreach (DataRow link in links) { isNewOrChanged = (link[Entities.SlideNavigationLinks.IS_NEW].ToString().Equals("1") || link[Entities.SlideNavigationLinks.IS_CHANGED].ToString().Equals("1") ); isIncompleteAddition = link[Entities.SlideNavigationLinks.IS_ADDING].ToString().Equals("1"); if (isIncompleteAddition || !isNewOrChanged) { continue; } link[Entities.SlideNavigationLinks.NAVIGATION_CHOICE_ID] = Convert.ToInt64(navigationChoiceId); if (dictionary.ContainsKey(link[Entities.SlideNavigationLinks.FILE_LINK].ToString())) { link[Entities.SlideNavigationLinks.FILE_LINK] = Convert.ToInt64(dictionary[link[Entities.SlideNavigationLinks.FILE_LINK].ToString()]); } else { link[Entities.SlideNavigationLinks.FILE_LINK] = DBNull.Value; } if (dictionary.ContainsKey(link[Entities.SlideNavigationLinks.DESCRIPTION].ToString())) { link[Entities.SlideNavigationLinks.DESCRIPTION] = Convert.ToInt64(dictionary[link[Entities.SlideNavigationLinks.DESCRIPTION].ToString()]); } else { link[Entities.SlideNavigationLinks.DESCRIPTION] = DBNull.Value; } oDALinks.Save(transaction, link); } } } }
private static void PersistSlideCultureText(DbTransaction transaction, DataRow drSlide, DACultureResources oDACr, DataTable dtSlideCr) { foreach (DataRow row in dtSlideCr.Rows) { string id = row[Entities.CultureResources.ID].ToString(); if (row[Entities.CultureResources.IS_NEW] != DBNull.Value && row[Entities.CultureResources.IS_NEW].ToString().Equals("1") ) { row[Entities.CultureResources.ID] = DBNull.Value; } oDACr.PersistCultureResource(row, transaction); if (drSlide[Entities.TrainingSlide.SLIDE_NAME].ToString().Equals(id)) { drSlide[Entities.TrainingSlide.SLIDE_NAME] = Convert.ToInt64(row[Entities.CultureResources.ID]); } else if (drSlide[Entities.TrainingSlide.DESCRIPTION].ToString().Equals(id)) { drSlide[Entities.TrainingSlide.DESCRIPTION] = Convert.ToInt64(row[Entities.CultureResources.ID]); } } }
public void Save(DataSet ds, DbTransaction transaction, Enumaration.PageMode pageMode) { DataSet dataToSave = ds; DataRow drQp = ds.Tables[Entities.QuestionsPool.TABLE_NAME].Rows[0]; DataTable dtQpCatOne = null; DataTable dtQpCatTwo = null; DAQuestionsPool oDAQp = new DAQuestionsPool(); DACultureResources oDACr = new DACultureResources(); //Saving culture resources for questions:Start DataTable dtQpCr = ds.Tables[Enumaration.ManageQuestionKeys.DT_QuestionTextCultureRes]; oDACr.PersistCultureResource(dtQpCr, transaction); //Saving culture resources for questions:Finish if (Convert.ToInt16(drQp[Entities.QuestionsPool.TYPE_ID]).Equals((int)Enumaration.QuestionType.Categorybased)) { //Saving culture resources for CATEGORIES:Start dtQpCatOne = ds.Tables[Enumaration.ManageQuestionKeys.DT_QuestionCatOneCultureRes]; oDACr.PersistCultureResource(dtQpCatOne, transaction); dtQpCatTwo = ds.Tables[Enumaration.ManageQuestionKeys.DT_QuestionCatTwoCultureRes]; oDACr.PersistCultureResource(dtQpCatTwo, transaction); } //Saving culture resources for CATEGORIES:Finish //Saving questions Start drQp[Entities.QuestionsPool.QUESTION_TEXT] = (Int64)dtQpCr.Rows[0][Entities.CultureResources.ID]; if (dtQpCatOne != null && dtQpCatTwo != null) { drQp[Entities.QuestionsPool.CATEGORY_ONE] = (Int64)dtQpCatOne.Rows[0][Entities.CultureResources.ID]; drQp[Entities.QuestionsPool.CATEGORY_TWO] = (Int64)dtQpCatTwo.Rows[0][Entities.CultureResources.ID]; } oDAQp.SaveQuestionsPool(transaction, drQp, pageMode); //Saving questions Finish DAAnswersPool ODaAp = new DAAnswersPool(); DataRow[] answersToPersist = ds.Tables[Entities.AnswersPool.TABLE_NAME].Select( Entities.AnswersPool.IS_NEW + " =1 OR " + Entities.AnswersPool.IS_CHANGED + " =1 OR " + Entities.AnswersPool.IS_DELETED + " =1 " ); foreach (DataRow drAp in answersToPersist) { DataRow[] drApCrs = ds.Tables[Enumaration.ManageQuestionKeys.DT_AnswerTextCultureRes]. Select(Entities.CultureResources.ID + "=" + drAp[Entities.AnswersPool.ANSWER_TEXT]); DataRow drApCr = drApCrs[0]; if (drAp[Entities.AnswersPool.IS_NEW] != DBNull.Value && drAp[Entities.AnswersPool.IS_NEW].ToString().Equals("1")) { drApCr[Entities.CultureResources.ID] = DBNull.Value; drAp[Entities.AnswersPool.ID] = DBNull.Value; } //Saving culture resources for answer:Start oDACr.PersistCultureResource(drApCr, transaction); //Saving culture resources for answer:Finish //Saving answers Start drAp[Entities.AnswersPool.QUESTION_ID] = (Int64)drQp[Entities.QuestionsPool.ID]; drAp[Entities.AnswersPool.ANSWER_TEXT] = (Int64)drApCr[Entities.CultureResources.ID]; if (drAp[Entities.AnswersPool.IS_NEW].Equals("1") && drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE] != DBNull.Value) { String tempIdWithImage = drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE].ToString(); if (drQp.Table.Columns.Contains(Entities.QuestionsPool.TEMP_ID)) { drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE] = drQp[Entities.QuestionsPool.TEMP_ID].ToString() + "/" + drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE].ToString(); } else { drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE] = drQp[Entities.QuestionsPool.ID].ToString() + "/" + drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE].ToString(); } ODaAp.SaveAnswers(transaction, drAp); drAp[Entities.AnswersPool.TEMP_ID_FOR_IMAGE] = tempIdWithImage; } else { ODaAp.SaveAnswers(transaction, drAp); } //Saving answers Finish } //Generate Questions XML It should be the last item int the function oDAQp.PersistXML(transaction, drQp[Entities.QuestionsPool.ID].ToString()); }