public async Task <IActionResult> UpdateProject([FromBody] Models.DTO.Project upProj, long id)
{
if (ModelState.IsValid)
{
var project = await DbContext.Projects.FirstOrDefaultAsync(x => x.Id == id);
if (project == null)
{
return(StatusCode(StatusCodes.Status404NotFound, string.Format("Project with ID = {0} not found", 0)));
}
var version = await DbContext.Versions.FirstOrDefaultAsync(x => x.Name == upProj.Version);
if (version == null)
{
version = new Models.Version
{
Name = upProj.Version
};
await DbContext.Versions.AddAsync(version);
await DbContext.SaveChangesAsync();
}
project.Name = upProj.Name;
project.Version = version;
DbContext.Projects.Update(project);
await DbContext.SaveChangesAsync();
return(Ok(project));
}
return(BadRequest(ModelState));
}
//[Route("dokument/{parentregister}/{parentregisterowner}/{registername}/{itemowner}/{documentname}/slett")]
//[Route("dokument/{registername}/{organization}/{documentname}/slett")]
public ActionResult DeleteConfirmed(string registername, string documentname, int versionNumber, string parentregister, string parentregisterowner)
{
Document document = (Document)_registerItemService.GetRegisterItem(parentregister, registername, documentname, versionNumber);
string registerUrl = document.register.GetObjectUrl();
if (DocumentIsCurrentVersion(document))
{
Models.Version versjonsgruppe = document.versioning;
var versionsOfDocument = _registerItemService.GetAllVersionsOfItembyVersioningId(versjonsgruppe.systemId);
if (versionsOfDocument.Count() > 1)
{
GetNewCurrentVersion(document);
db.RegisterItems.Remove(document);
}
else
{
db.RegisterItems.Remove(document);
db.SaveChanges();
db.Versions.Remove(versjonsgruppe);
}
}
else
{
db.RegisterItems.Remove(document);
}
db.SaveChanges();
return(Redirect(registerUrl));
}
public async Task <IActionResult> AddProject([FromBody] Models.DTO.Project newProject)
{
if (ModelState.IsValid)
{
var version = await DbContext.Versions.FirstOrDefaultAsync(x => x.Name == newProject.Version);
if (version == null)
{
version = new Models.Version {
Name = newProject.Version
};
await DbContext.Versions.AddAsync(version);
await DbContext.SaveChangesAsync();
}
var project = new Models.Project
{
Name = newProject.Name,
Version = version
};
await DbContext.Projects.AddAsync(project);
await DbContext.SaveChangesAsync();
return(Ok(project));
}
return(BadRequest(ModelState));
}
private void BtnCreate_Click(object sender, RoutedEventArgs e)
{
if (!versionSettings.Validate())
{
WarningAlert.Show("Invalid settings. One or more settings are not filled in.");
return;
}
if (!edit)
{
Version = new Models.Version();
}
if (tbName.Text.Length > 0)
{
Version.Name = tbName.Text;
Version.Locale = (cbLocales.SelectedItem as ComboBoxItem).Tag.ToString();
Version.Settings = versionSettings;
Version.Pages = new System.Collections.ObjectModel.ObservableCollection <Models.Page>();
DialogResult = true;
Close();
}
else
{
lbNameError.Text = "Enter a name";
}
}
private List <Models.RegisterItem> GetListOfVersions(string versionName, Models.Register register, string Owner)
{
Models.Version versionGroup = new Models.Version();
versionGroup.systemId = Guid.NewGuid();
versionGroup.lastVersionNumber = 1;
List <Models.RegisterItem> versions = new List <Models.RegisterItem>();
for (int i = 0; i < 5; i++)
{
Models.Document document = new Document();
document.systemId = Guid.Parse("c6056ed8-e040-42ef-b3c8-02f66fbb0ce" + i);
document.name = versionName;
document.seoname = RegisterUrls.MakeSeoFriendlyString(document.name);
Organization organisasjon = NewOrganization(Owner);
document.documentowner = organisasjon;
document.submitter = organisasjon;
document.versionNumber = versionGroup.lastVersionNumber;
document.versioning = versionGroup;
document.versioningId = versionGroup.systemId;
document.register = register;
versions.Add(document);
versionGroup.lastVersionNumber++;
}
versionGroup.currentVersion = versions[0].systemId;
foreach (Models.RegisterItem doc in versions)
{
doc.versioning.currentVersion = versionGroup.currentVersion;
}
return(versions);
}
public async Task <ActionResult <Material> > UpdateMaterial(NewVersionMaterialDTO model)
{
if (ModelState.IsValid)
{
Material material = _context.Materials.Include(p => p.Versions).FirstOrDefault(p => p.Name == model.Name);
if (material == null)
{
return(NoContent());
}
var materialPath = $"{_filesPath}{model.Name}\\";
var release = material.Versions.Count + 1;
var version = new Models.Version()
{
MaterialId = material.Id,
Material = material,
Release = release,
UploadDate = DateTime.Now,
Size = model.File.Length,
Path = $"{materialPath}{model.Name}_{release}"
};
_context.Versions.Add(version);
Directory.CreateDirectory(materialPath);
System.IO.File.WriteAllBytes($"{materialPath}{model.Name}_{release}", model.File);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMaterial", new { id = material.Id }, material));
}
return(BadRequest("Invalid model"));
}
public static TreeViewItem GetTreeViewForProject(Project project, Models.Version currentVersion)
{
TreeViewItem root = UiUtils.GetTreeViewItem(project.Name, "ProjectWhite.png");
root.Tag = project;
project.TreeViewItem = root;
foreach (Models.Page page in currentVersion.Pages)
{
TreeViewItem pageItem = UiUtils.GetTreeViewItem(page.Name, "PageWhite.png");
pageItem.Tag = page;
page.TreeViewItem = pageItem;
foreach (Section section in page.Sections)
{
TreeViewItem sectionItem = UiUtils.GetTreeViewItem(section.Name, "SectionWhite.png");
sectionItem.Tag = section;
section.TreeViewItem = sectionItem;
foreach (Models.Control control in section.Controls)
{
TreeViewItem controlItem = UiUtils.GetTreeViewItem(control.Name, "ControlWhite.png");
controlItem.Tag = control;
control.TreeViewItem = controlItem;
sectionItem.Items.Add(controlItem);
}
pageItem.Items.Add(sectionItem);
}
root.Items.Add(pageItem);
}
return(root);
}
//public IActionResult Updates() => View();
public IActionResult Updates(Models.Version ver)
{
ViewBag.Sys_Code = ver.Ver_Sys_Code;
ViewBag.Ver_Code = ver.Ver_Code;
return(View(repository.Updates.Where(r => r.Upd_Sys_Code == ver.Ver_Sys_Code &&
r.Upd_Ver_Code == ver.Ver_Code)));
}
private void LoadPages(Models.Version version)
{
foreach (Models.Page page in version.Pages)
{
ListBoxItem item = new ListBoxItem();
item.Content = page.Name;
item.Tag = page.Id;
lsbPages.Items.Add(item);
}
}
public void DeleteVersionGroup(Guid versioningId)
{
var queryResult = from v in _dbContext.Versions
where v.systemId == versioningId
select v;
Models.Version versiongroup = queryResult.FirstOrDefault();
_dbContext.Versions.Remove(versiongroup);
_dbContext.SaveChanges();
}
public RedirectToActionResult Delete(Models.Version ver)
{
if (ModelState.IsValid)
{
repository.DeleteVersion(ver.Ver_Sys_Code, ver.Ver_Code);
}
// ModelState.Clear();
return(RedirectToAction(nameof(VersionController.Index)));
}
public void Update(ZIPEntities context)
{
var currentVersion = context.Versions.Where(a => a.Type == "ZIPCodeLookup").FirstOrDefault();
if (currentVersion == null)
{
currentVersion = new Models.Version() { Type = "ZIPCodeLookup", LastUpdateAttempt = DateTime.Now, LastUpdateSuccess = DateTime.Parse("01/01/1900") };
context.Versions.Add(currentVersion);
}
else
{
currentVersion.LastUpdateAttempt = DateTime.Now;
}
int itemsAdded = 0;
int itemsModified = 0;
string remoteFile = "http://www.unitedstateszipcodes.org/zip_code_database.csv";
string localFile = AppDomain.CurrentDomain.GetData("DataDirectory").ToString() + @"\download\zip_code_database.csv";
var webClient = new WebClient();
webClient.DownloadFile(remoteFile, localFile);
using (var reader = new StreamReader(localFile))
{
while (reader.Peek() >= 0)
{
var zipLine = reader.ReadLine();
if (zipLine != null)
{
List<ZIP> updatedZIPs = ParseZipLine(zipLine);
if (updatedZIPs != null)
{
foreach (var updatedZIP in updatedZIPs)
{
var existingZIP = context.ZIPs.Find(updatedZIP.ZIPCode);
if (existingZIP == null)
{
itemsAdded++;
context.ZIPs.Add(updatedZIP);
}
else
{
itemsModified++;
context.Entry<ZIP>(existingZIP).CurrentValues.SetValues(updatedZIP);
}
}
}
}
}
}
currentVersion.LastUpdateItemsAdded = itemsAdded;
currentVersion.LastUpdateItemsModified = itemsModified;
currentVersion.LastUpdateSuccess = DateTime.Now;
context.SaveChanges();
}
public ActionResult DeleteChapterForExistingArticle(int id)
{
Chapter chapterToDelete = db.Chapters.Find(id);
Models.Version oldVersion = chapterToDelete.Version;
Article article = oldVersion.Article;
Chapter[] chaptersOfOldVersion = oldVersion.Chapters.ToArray();
// remove old associations
article.CurrentVersionId = null;
article.CurrentVersion = null;
oldVersion.CurrentArticle = null;
db.SaveChanges();
// create new version
Models.Version newVersion = new Models.Version {
ArticleId = article.ArticleId,
ModifierUserId = User.Identity.GetUserId(),
VersionNo = oldVersion.VersionNo + 1,
DateChange = DateTime.Now,
DescriptionChange = "Removed chapter '" + chapterToDelete.Title + "'",
CurrentArticle = new Article[] { article },
};
db.Versions.Add(newVersion);
db.SaveChanges();
article.CurrentVersion = newVersion;
db.SaveChanges();
// copy all the chapters of the old version, excepting the one to delete, into the new version
foreach (Chapter chapterOfOldVersion in chaptersOfOldVersion)
{
if (chapterOfOldVersion.ChapterId == chapterToDelete.ChapterId)
{
continue;
}
db.Chapters.Add(new Chapter {
VersionId = newVersion.VersionId,
Title = chapterOfOldVersion.Title,
Content = chapterOfOldVersion.Content
});
db.SaveChanges();
}
newVersion.ChangedChapterId = chapterToDelete.ChapterId;
newVersion.ChangedChapter = chapterToDelete;
db.SaveChanges();
TempData["articleShowMessage"] = "The chapter has been removed.";
return(RedirectToRoute("Default", new { controller = "Article", action = "Show", id = article.ArticleId }));
}
public IActionResult SelectVersion(Models.Version ver)
{
SetKeyField("Syr_Ver_Code", ver.Ver_Code);
return(View(nameof(Index),
new SystemRegistration
{
Syr_Cst_Code = GetKeyField("Syr_Cst_Code"),
Syr_Sys_Code = GetKeyField("Syr_Sys_Code"),
Syr_Ver_Code = GetKeyField("Syr_Ver_Code")
}));
}
public IActionResult SelectVersion(Models.Version ver)
{
SetKeyField("Syr_Ver_Code", ver.Ver_Code);
return(RedirectToAction(nameof(SystemRegistrationForm), new
{
cst_code = GetKeyField("Syr_Cst_Code"),
sys_code = GetKeyField("Syr_Sys_Code"),
ver_code = GetKeyField("Syr_Ver_Code")
}));
}
public ActionResult Edit([Bind(Include = "id_Version,Active,version_Name,id_current_Quarter")] Models.Version version)
{
if (ModelState.IsValid)
{
db.Entry(version).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.id_current_Quarter = new SelectList(db.currentQuarters, "id_current_Quarter", "idcurrent_Quarter", version.id_current_Quarter);
return View(version);
}
private void BtnEdit_Click(object sender, RoutedEventArgs e)
{
Models.Version selectedVersion = Project.Versions.Single(version => version.Id == selectedVersionId);
NewVersion dialog = new NewVersion(provider.GetDefaultVersionSettings(), selectedVersion);
if (dialog.ShowDialog().Value)
{
Project.Versions[Project.Versions.IndexOf(selectedVersion)] = dialog.Version;
LoadVersions();
}
}
public ActionResult <string> Get()
{
var versionInfo = new Models.Version
{
Company = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyCompanyAttribute>().Company,
Product = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyProductAttribute>().Product,
ProductVersion = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyInformationalVersionAttribute>().InformationalVersion
};
return(Ok(versionInfo));
}
public ActionResult Delete(Guid id)
{
Models.Version ver = repoWrapper.Version.GetById(id);
if (ver == null)
{
return(BadRequest());
}
ver.IsDeleted = true;
repoWrapper.Save();
return(Ok());
}
public ActionResult Edit([Bind(Include = "Id,filename,CreateDateTime,VersionNumber,documentId")] Models.Version version)
{
if (ModelState.IsValid)
{
db.Entry(version).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.documentId = new SelectList(db.Documents, "Id", "Name", version.documentId);
return(View(version));
}
public static List <string> GetAllIds(Models.Version version)
{
List <string> result = new List <string>();
result.Add(version.Id);
foreach (Models.Page page in version.Pages)
{
result.AddRange(GetAllIds(page));
}
return(result);
}
private void BtnRemove_Click(object sender, RoutedEventArgs e)
{
if (Project.Versions.Count() != 1)
{
Models.Version selectedVersion = Project.Versions.Single(version => version.Id == selectedVersionId);
Studio.RemoveManualItem(selectedVersion, true);
}
else
{
ErrorAlert.Show("A manual must have at least 1 version!");
}
}
// GET: Version/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.Version version = db.Versions.Find(id);
if (version == null)
{
return(HttpNotFound());
}
return(View(version));
}
public Guid NewVersioningGroup(Models.RegisterItem registerItem)
{
Models.Version versjoneringsGruppe = new Models.Version();
versjoneringsGruppe.systemId = Guid.NewGuid();
versjoneringsGruppe.currentVersion = registerItem.systemId;
versjoneringsGruppe.containedItemClass = registerItem.register.containedItemClass;
versjoneringsGruppe.lastVersionNumber = registerItem.versionNumber;
_dbContext.Entry(versjoneringsGruppe).State = EntityState.Modified;
_dbContext.Versions.Add(versjoneringsGruppe);
_dbContext.SaveChanges();
return(versjoneringsGruppe.systemId);
}
// GET: Versions/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Models.Version version = db.Versions.Find(id);
if (version == null)
{
return HttpNotFound();
}
return View(version);
}
public IActionResult SelectVersion(Models.Version ver)
{
HttpContext.Session.Set("Ver_Code", Encoding.ASCII.GetBytes(ver.Ver_Code));
HttpContext.Session.TryGetValue("Cst_Code", out var Cst_Code);
HttpContext.Session.TryGetValue("Sys_Code", out var Sys_Code);
HttpContext.Session.TryGetValue("Ver_Code", out var Ver_Code);
return(View(nameof(Index),
new SystemRegistration
{
Syr_Cst_Code = Encoding.ASCII.GetString(Cst_Code, 0, Cst_Code.Length),
Syr_Sys_Code = Encoding.ASCII.GetString(Sys_Code, 0, Sys_Code.Length),
Syr_Ver_Code = Encoding.ASCII.GetString(Ver_Code, 0, Ver_Code.Length)
}));
}
// GET: Version/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.Version version = db.Versions.Find(id);
if (version == null)
{
return(HttpNotFound());
}
ViewBag.documentId = new SelectList(db.Documents, "Id", "Name", version.documentId);
return(View(version));
}
private void CopyChaptersFromOldVersionToNewVersion(Models.Version oldVersion, Models.Version newVersion)
{
Chapter[] chaptersOfOldVersion = oldVersion.Chapters.ToArray();
foreach (Chapter chapterOfOldVersion in chaptersOfOldVersion)
{
db.Chapters.Add(new Chapter {
VersionId = newVersion.VersionId,
Title = chapterOfOldVersion.Title,
Content = chapterOfOldVersion.Content
});
db.SaveChanges();
}
}
public ActionResult <string> Get()
{
Log.Information("Get app information");
var versionInfo = new Models.Version
{
Company = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyCompanyAttribute>().Company,
Product = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyProductAttribute>().Product,
ProductVersion = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyInformationalVersionAttribute>().InformationalVersion
};
Log.Information($"Acquired version is {versionInfo.ProductVersion}");
Log.Debug($"Full version info: {@versionInfo}");
return(Ok(versionInfo));
}
// GET: Versions/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Models.Version version = db.Versions.Find(id);
if (version == null)
{
return HttpNotFound();
}
ViewBag.id_current_Quarter = new SelectList(db.currentQuarters, "id_current_Quarter", "idcurrent_Quarter", version.id_current_Quarter);
return View(version);
}
private void LoadVersions(Project project, Models.Version startVersion = null)
{
foreach (Models.Version version in project.Versions)
{
ListBoxItem item = new ListBoxItem();
item.Content = version.Name;
item.Tag = version;
if (startVersion != null && startVersion == version)
{
item.IsSelected = true;
}
lsbVersions.Items.Add(item);
}
}
public void Update(BankEntities context)
{
var currentVersion = context.Versions.Where(a => a.Type == "RoutingLookup").FirstOrDefault();
if (currentVersion == null)
{
currentVersion = new Models.Version() { Type = "RoutingLookup", LastUpdateAttempt = DateTime.Now, LastUpdateSuccess = DateTime.Parse("01/01/1900") };
context.Versions.Add(currentVersion);
}
else
{
currentVersion.LastUpdateAttempt = DateTime.Now;
}
if (DateTime.Now.Date > currentVersion.LastUpdateSuccess.Date)
{
//HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://www.fededirectory.frb.org/FedACHdir.txt");
HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://www.fededirectory.frb.org/updatesForACH.cfm");
rq.Method = "POST";
rq.ContentType = "application/x-www-form-urlencoded";
byte[] bytedata = Encoding.UTF8.GetBytes("sinceDate=" + currentVersion.LastUpdateSuccess.ToString("MM/dd/yyyy"));
rq.ContentLength = bytedata.Length;
using (var requestStream = rq.GetRequestStream())
{
requestStream.Write(bytedata, 0, bytedata.Length);
requestStream.Close();
}
using (var rs = (HttpWebResponse)rq.GetResponse())
{
using (var stream = rs.GetResponseStream())
{
using (var readStream = new StreamReader(stream, System.Text.Encoding.GetEncoding("utf-8")))
{
var responseBuilder = new StringBuilder();
var bufferSize = 256;
Char[] read = new Char[bufferSize];
int count = readStream.Read(read, 0, bufferSize);
while (count > 0)
{
String str = new String(read, 0, count);
responseBuilder.Append(str);
count = readStream.Read(read, 0, bufferSize);
}
var response = responseBuilder.ToString();
var bankItems = response.Split(new string[] { "\r\n" }, StringSplitOptions.None);
var itemsAdded = 0;
var itemsModified = 0;
foreach (var bankItem in bankItems)
{
if (bankItem.Length >= 9)
{
var updatedBank = context.ParseBank(bankItem);
var existingBank = context.Banks.Find(updatedBank.RoutingNumber);
if (existingBank == null)
{
itemsAdded++;
context.Banks.Add(updatedBank);
}
else
{
itemsModified++;
context.Entry<Bank>(existingBank).CurrentValues.SetValues(updatedBank);
}
}
}
currentVersion.LastUpdateItemsAdded = itemsAdded;
currentVersion.LastUpdateItemsModified = itemsModified;
currentVersion.LastUpdateSuccess = DateTime.Now;
context.SaveChanges();
rs.Close();
readStream.Close();
}
}
}
}
}
