/// <summary> /// Deletes surface from database. /// </summary> /// <param name="surfaceData">A WebMech.Web.SurfaceData that specifies /// data object of surface.</param> public void DeleteSurface(SurfaceData surfaceData) { LogIt.Info("DeleteSurface(Id = " + surfaceData.Id.ToString() + ", Name = " + surfaceData.Name + ")"); if (surfaceData != null) { WebMechDataContext db = new WebMechDataContext(); Surface surface = db.Surfaces.Single(s => s.surface_id == surfaceData.Id); db.Surfaces.DeleteOnSubmit(surface); db.SubmitChanges(); } }
/// <summary> /// Uploads sample into database. /// </summary> /// <param name="surfaceData">A WebMech.Web.SurfaceData that specifies /// data object of surface.</param> /// <param name="imageName">A System.String that specifies /// the file name of sample image.</param> /// <param name="imageArray">A System.Byte[] that specifies /// byte array of image file</param> /// <param name="pointsName">A System.String that specifies /// the file name of text file with 3D points.</param> /// <param name="pointsArray">A System.String that specifies /// byte array of text file with 3D points.</param> /// <returns>A WebMech.Web.SampleData that specifies /// data object of sample.</returns> public SampleData UploadSample(SurfaceData surfaceData, string imageName, byte[] imageArray, string pointsName, byte[] pointsArray) { LogIt.Info("UploadSample(Id = " + surfaceData.Id.ToString() + ", Name = " + surfaceData.Name + ", ImageName = " + imageName + ", PointsName = " + pointsName + ")"); WebMechDataContext db = new WebMechDataContext(); StatisticSurface process = new StatisticSurface(surfaceData.Name, imageName, imageArray, pointsName, pointsArray); process.Process(); DateTime date = DateTime.Now; Sample sample = new Sample(); sample.surface_id = surfaceData.Id; sample.sample_date = sample.upload_date = sample.modification_date = date; sample.filename = process.ImageName; db.Samples.InsertOnSubmit(sample); db.SubmitChanges(); sample = db.Samples.Single(s => s.surface_id == surfaceData.Id && s.upload_date == date); Statistic statistic = new Statistic(); statistic.sample_id = sample.sample_id; statistic.x_min = process.XMin; statistic.x_max = process.XMax; statistic.y_min = process.YMin; statistic.y_max = process.YMax; statistic.z_min = process.ZMin; statistic.z_max = process.ZMax; statistic.z_mean = process.ZMean; db.Statistics.InsertOnSubmit(statistic); db.SubmitChanges(); for (int idx = 0; idx < process.VisualizePointList.Count; idx++) { Point point = process.VisualizePointList[idx]; point.sample_id = sample.sample_id; point.order = idx; db.Points.InsertOnSubmit(point); if ((idx % 100) == 0) db.SubmitChanges(); } db.SubmitChanges(); for (int idx = 0; idx < process.ParameterList.Count; idx++) { Parameter parameter = new Parameter { sample_id = sample.sample_id, order = idx, name = process.ParameterList[idx].Name, value = process.ParameterList[idx].Value }; db.Parameters.InsertOnSubmit(parameter); } db.SubmitChanges(); return SampleToData(sample); }
/// <summary> /// Gets information about sample's pagination according to filter. /// </summary> /// <param name="filterData">WebMech.Web.SearchFilterData which specifies /// filter for selection of surfaces.</param> /// <param name="surfaceData">A WebMech.Web.SurfaceData that specifies /// data object of surface.</param> /// <returns>A WebMech.Web.PageInfoData that specifies /// data object of pagination.</returns> public PageInfoData GetSampleListPageInfo(SearchFilterData filterData, SurfaceData surfaceData) { LogIt.Info("GetSampleListPageInfo(Id = " + surfaceData.Id.ToString() + ")"); WebMechDataContext db = new WebMechDataContext(); var totalQuery = from s in db.Samples where s.surface_id == surfaceData.Id orderby s.sample_date descending select s; int total = totalQuery.Count(); bool isNext = (filterData.Start + filterData.Count) <= total; bool isPrev = filterData.Start > filterData.Count; return new PageInfoData { Start = filterData.Start, End = Math.Min(filterData.Start + filterData.Count - 1, total), Total = total, IsNext = isNext, IsPrevious = isPrev }; }
/// <summary> /// Modifies surface name. /// </summary> /// <param name="surfaceData">A WebMech.Web.SurfaceData that specifies /// data object of surface.</param> public void ModifySurface(SurfaceData surfaceData) { LogIt.Info("ModifySurface(Id = " + surfaceData.Id.ToString() + ", Name = " + surfaceData.Name + ")"); if (surfaceData != null) { WebMechDataContext db = new WebMechDataContext(); Surface surface = db.Surfaces.Single(s => s.surface_id == surfaceData.Id); surface.name = surfaceData.Name; surface.modification_date = DateTime.Now; db.SubmitChanges(); } }
/// <summary> /// Gets list of samples according to filter. /// </summary> /// <param name="filterData">WebMech.Web.SearchFilterData which specifies /// filter for selection of surfaces.</param> /// <param name="surfaceData">A WebMech.Web.SurfaceData that specifies /// data object of surface.</param> /// <returns>A System.Collections.Generic.List that specifies /// list of data objects of sample.</returns> public List<SampleData> GetSampleList(SearchFilterData filterData, SurfaceData surfaceData) { LogIt.Info("GetSampleList(Id = " + surfaceData.Id.ToString() + ")"); WebMechDataContext db = new WebMechDataContext(); var samples = (from m in db.Samples where m.surface_id == surfaceData.Id orderby m.sample_date descending select m).Skip(filterData.Start - 1).Take(filterData.Count); List<SampleData> sampleList = new List<SampleData>(); foreach (Sample sample in samples) { SampleData sampleData = SampleToData(sample); var parameters = (from p in db.Parameters where p.sample_id == sample.sample_id orderby p.order select p); sampleData.ParameterList = new List<ParameterData>(); foreach (Parameter parameter in parameters) sampleData.ParameterList.Add(ParameterToData(parameter)); sampleList.Add(sampleData); } return sampleList; }