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);
}
public HttpResponseMessage GetReleaseNotes(string SoftwareReleaseID, string language, string SoftwareReleaseNoteTypeCode)
{
HttpResponseMessage response = Request.CreateResponse();
try
{
int softwareReleaseId = 0;
if (!string.IsNullOrEmpty(SoftwareReleaseID))
{
softwareReleaseId = Convert.ToInt32(SoftwareReleaseID);
}
int MicrosoftLocaleID = Convert.ToInt32(language);
List <SoftwareReleaseNote> softwareReleaseNoteList = (from dt in _dbEntities.DialectTexts
join rn in _dbEntities.ReleaseNotes on dt.TextID equals rn.ReleaseNoteTextID
where rn.ReleaseID == softwareReleaseId && rn.ReleaseNoteTypeCode == SoftwareReleaseNoteTypeCode &&
dt.MicrosoftLocaleID == MicrosoftLocaleID select new SoftwareReleaseNote {
SoftwareReleaseId = rn.ReleaseID,
ReleaseNote = dt.LanguageText,
SoftwareReleaseNoteTypeCode = rn.ReleaseNoteTypeCode,
ReleaseNoteTextId = rn.ReleaseNoteTextID
}).OrderByDescending(o => o.ReleaseNoteTextId).ToList();
if (softwareReleaseNoteList.Count > 0)
{
SoftwareReleaseNote softwareReleaseNote = new SoftwareReleaseNote();
softwareReleaseNote = softwareReleaseNoteList.FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.OK, softwareReleaseNote));
}
}
catch (Exception ex)
{
response.Content = new StringContent("[]");
response.StatusCode = HttpStatusCode.InternalServerError;
}
return(response);
}
