public HttpResponseMessage EditSoftwareReleaseNotes(SoftwareReleaseNote softwareReleaseNotes) { HttpResponseMessage response = Request.CreateResponse(); try { ReleaseNote releaseNote = _dbEntities.ReleaseNotes.Where(a => a.ReleaseID == softwareReleaseNotes.SoftwareReleaseId && a.ReleaseNoteTypeCode == softwareReleaseNotes.SoftwareReleaseNoteTypeCode ).FirstOrDefault(); if (releaseNote != null) { releaseNote.ReleaseNoteTypeCode = softwareReleaseNotes.SoftwareReleaseNoteTypeCode; releaseNote.LastModifiedDateTime = softwareReleaseNotes.LastModifiedDateTime; releaseNote.LastModifiedUserName = softwareReleaseNotes.LastModifiedUserName; releaseNote.CreatedDateTime = softwareReleaseNotes.CreatedDateTime; _dbEntities.SaveChanges(); } int LocaleID = Convert.ToInt32(softwareReleaseNotes.Language); DialectText dialectText = _dbEntities.DialectTexts.Where(a => a.MicrosoftLocaleID == LocaleID && a.TextID == releaseNote.ReleaseNoteTextID).FirstOrDefault(); if (dialectText != null) { dialectText.LanguageText = softwareReleaseNotes.ReleaseNote; _dbEntities.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, releaseNote.ReleaseID)); } catch (Exception ex) { response.Content = new StringContent("[]"); response.StatusCode = HttpStatusCode.InternalServerError; } return(response); }
public HttpResponseMessage AddSoftwareReleaseNotes(SoftwareReleaseNote softwareReleaseNotes) { HttpResponseMessage response = Request.CreateResponse(); try { TextReference textReference = new TextReference(); textReference.TextID = _dbEntities.TextReferences.Max(m => m.TextID) + 1; _dbEntities.TextReferences.Add(textReference); _dbEntities.SaveChanges(); ReleaseNote releaseNoteTemp = _dbEntities.ReleaseNotes.Where(a => a.ReleaseID == softwareReleaseNotes.SoftwareReleaseId && a.ReleaseNoteTypeCode == softwareReleaseNotes.SoftwareReleaseNoteTypeCode && a.ReleaseNoteTextID == textReference.TextID ).FirstOrDefault(); if (releaseNoteTemp == null) { ReleaseNote releaseNote = new ReleaseNote() { ReleaseID = softwareReleaseNotes.SoftwareReleaseId, ReleaseNoteTypeCode = softwareReleaseNotes.SoftwareReleaseNoteTypeCode, ReleaseNoteTextID = textReference.TextID, LastModifiedUserName = softwareReleaseNotes.LastModifiedUserName, CreatedDateTime = softwareReleaseNotes.CreatedDateTime, LastModifiedDateTime = softwareReleaseNotes.LastModifiedDateTime }; _dbEntities.ReleaseNotes.Add(releaseNote); _dbEntities.SaveChanges(); DialectText dialectText = new DialectText() { MicrosoftLocaleID = Convert.ToInt32(softwareReleaseNotes.Language), TextID = textReference.TextID, LanguageText = softwareReleaseNotes.ReleaseNote, ModifiedbyDatabaseLoginName = softwareReleaseNotes.LastModifiedUserName, ModificationDateTime = softwareReleaseNotes.LastModifiedDateTime }; _dbEntities.DialectTexts.Add(dialectText); _dbEntities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, softwareReleaseNotes.SoftwareReleaseId)); } return(Request.CreateResponse(HttpStatusCode.Ambiguous, softwareReleaseNotes.SoftwareReleaseId)); } catch (Exception ex) { response.Content = new StringContent("[]"); response.StatusCode = HttpStatusCode.InternalServerError; } return(response); }