/// <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;
}
