public static UpdateFile GetUpdateFileById(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from f in dc.UpdateFiles where f.Id == id select MapUpdateFile(f)).SingleOrDefault()); } }
public static List <Update> GetAllHotfixUpdatesInSeriesById(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return(dc.UpdateSeries.Where(x => x.Id == id).SelectMany(x => x.Updates.Where(y => y.UpdateType.Equals(UpdateType.Hotfix))).Select(x => MapUpdate(x)).ToList()); } }
public static Update SaveUpdate(Update u) { using (var dc = new UpdateManagerClassesDataContext()) { if (u.Id.Equals(Guid.Empty)) { u.Id = Guid.NewGuid(); u.DateCreated = DateTime.Now; u.DateModified = DateTime.Now; var dbo = new Entities.Update(); Mapper.Map(u, dbo); dc.Updates.InsertOnSubmit(dbo); dc.SubmitChanges(); return(MapUpdate(dbo)); } else { u.DateModified = DateTime.Now; var dbo = dc.Updates.SingleOrDefault(x => x.Id == u.Id); if (dbo != null) { Mapper.Map(u, dbo); dc.SubmitChanges(); } return(MapUpdate(dbo)); } } }
public static List <Update> GetUpdatesBySeriesId(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from u in dc.Updates where u.UpdateSeriesId == id select MapUpdate(u)).ToList()); } }
public static List <Guid> GetFildIdsForUpdate(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from u in dc.UpdateFiles where u.UpdateId == id select u.Id).ToList()); } }
public static UpdateSeries GetUpdateSeriesById(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from us in dc.UpdateSeries where us.Id == id select MapUpdateSeries(us)).SingleOrDefault()); } }
public static List <Version> GetAllVersions() { using (var dc = new UpdateManagerClassesDataContext()) { return((from v in dc.Versions select MapVersion(v)).ToList()); } }
public static List <Version> GetAllVersionsForUpdateSeries(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from v in dc.UpdatesVersions where v.UpdateSeriesId == id select MapVersion(v.Version)).ToList()); } }
public static void SaveUpdateFile(Guid fileId, byte[] b2) { using (var dc = new UpdateManagerClassesDataContext()) { var dbo = dc.UpdateFiles.SingleOrDefault(x => x.Id == fileId); if (dbo != null) { if (dbo.File != null) { var b1 = dbo.File.ToArray(); var concat = new byte[b1.Length + b2.Length]; Buffer.BlockCopy(b1, 0, concat, 0, b1.Length); Buffer.BlockCopy(b2, 0, concat, b1.Length, b2.Length); dbo.File = new Binary(concat); } else { dbo.File = new Binary(b2); } dc.SubmitChanges(); } } }
public static List <Update> GetAllUpdates() { using (var dc = new UpdateManagerClassesDataContext()) { return((from u in dc.Updates select MapUpdate(u)).ToList()); } }
public static void SaveVersion(Version v) { using (var dc = new UpdateManagerClassesDataContext()) { if (v.Id.Equals(Guid.Empty)) { v.Id = Guid.NewGuid(); var dboversion = new Entities.Version(); Mapper.Map(v, dboversion); dc.Versions.InsertOnSubmit(dboversion); dc.SubmitChanges(); } else { var dboversion = dc.Versions.SingleOrDefault(x => x.Id == v.Id); if (dboversion != null) { Mapper.Map(v, dboversion); dc.SubmitChanges(); } } } }
public static void DeleteUpdateSeriesById(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { dc.UpdateSeries.DeleteOnSubmit(dc.UpdateSeries.SingleOrDefault(x => x.Id == id)); dc.SubmitChanges(); } }
public static List <Guid> CheckForUpdates(string version, Guid applicationId) { using (var dc = new UpdateManagerClassesDataContext()) { var completedUpdates = dc.UpdatesApplications.Where(x => x.ApplicationId == applicationId).Select(x => x.UpdateId); return((from u in dc.Updates where !completedUpdates.Contains(u.Id) select u.UpdateSeriesId).Distinct().ToList()); } }
public static void CancelUploads(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { dc.UpdateFiles.DeleteAllOnSubmit(dc.UpdateFiles.Where(x => x.UpdateId == id)); dc.SubmitChanges(); } }
public static List <Version> GetVersionsBySeriesId(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { return((from v in dc.Versions join uv in dc.UpdatesVersions on v.Id equals uv.VersionId where uv.UpdateSeriesId == id select MapVersion(v)).ToList()); } }
public static void CompleteUpdate(Guid applicationid, Guid updateId) { using (var dc = new UpdateManagerClassesDataContext()) { dc.UpdatesApplications.InsertOnSubmit(new UpdatesApplication() { Id = Guid.NewGuid(), ApplicationId = applicationid, UpdateId = updateId }); dc.SubmitChanges(); } }
public static void DeleteUpdateFile(Guid fileId) { using (var dc = new UpdateManagerClassesDataContext()) { var dbo = dc.UpdateFiles.SingleOrDefault(x => x.Id == fileId); if (dbo != null) { dc.UpdateFiles.DeleteOnSubmit(dbo); dc.SubmitChanges(); } } }
public static void DeleteVersionById(Guid id) { using (var dc = new UpdateManagerClassesDataContext()) { var dbo = dc.Versions.SingleOrDefault(x => x.Id == id); if (dbo != null) { dc.UpdatesVersions.DeleteAllOnSubmit((from v in dc.UpdatesVersions where v.VersionId == id select v)); dc.Versions.DeleteOnSubmit(dbo); dc.SubmitChanges(); } } }
public static void FinishUpdateFile(Guid fileId) { using (var dc = new UpdateManagerClassesDataContext()) { var dbo = dc.UpdateFiles.SingleOrDefault(x => x.Id == fileId); if (dbo != null) { dbo.DateFinished = DateTime.Now; dbo.IsComplete = true; dc.SubmitChanges(); } } }
public static UpdateSeries SaveUpdateSeries(UpdateSeries us) { var dbo = new Entities.UpdateSeries(); using (var dc = new UpdateManagerClassesDataContext()) { if (us.Id.Equals(Guid.Empty)) { us.Id = Guid.NewGuid(); us.DateCreated = DateTime.Now; us.DateModified = DateTime.Now; dbo = new Entities.UpdateSeries(); Mapper.Map(us, dbo); dc.UpdateSeries.InsertOnSubmit(dbo); dc.SubmitChanges(); } else { us.DateModified = DateTime.Now; dbo = dc.UpdateSeries.SingleOrDefault(x => x.Id == us.Id); if (dbo != null) { Mapper.Map(us, dbo); dc.SubmitChanges(); } } dc.UpdatesVersions.DeleteAllOnSubmit(dc.UpdatesVersions.Where(x => x.UpdateSeriesId == us.Id)); foreach (var g in us.Versions) { dc.UpdatesVersions.InsertOnSubmit(new UpdatesVersion { Id = Guid.NewGuid(), UpdateSeriesId = us.Id, VersionId = g }); } dc.SubmitChanges(); return(MapUpdateSeries(dbo)); } }
public static Guid CreateUpdateFile(Guid updateId, string fileName, string installPath) { using (var dc = new UpdateManagerClassesDataContext()) { var dbo = new Entities.UpdateFile { Id = Guid.NewGuid(), UpdateId = updateId, DateCreated = DateTime.Now, IsComplete = false, FileName = fileName, InstallPath = installPath }; dc.UpdateFiles.InsertOnSubmit(dbo); dc.SubmitChanges(); return(dbo.Id); } }