public static bool RecursiveDeletePlot(PlotDO plot) { DatastoreRedux dal = plot.DAL; string command = string.Format(@" DELETE FROM LogStock; DELETE FROM TreeCalculatedValues; DELETE FROM Log WHERE EXISTS (SELECT 1 FROM Tree WHERE Tree.Tree_CN = Log.Tree_CN AND Tree.Plot_CN = {0}); DELETE FROM Tree WHERE Plot_CN = {0};", plot.Plot_CN); dal.Execute(command); plot.Delete(); return true; }
public static bool RecursiveDeletePlot(PlotDO plot) { Datastore dal = plot.DAL; string command = string.Format(@" DELETE FROM LogStock; DELETE FROM TreeCalculatedValues; DELETE FROM Log WHERE EXISTS (SELECT 1 FROM Tree WHERE Tree.Tree_CN = Log.Tree_CN AND Tree.Plot_CN = {0}); DELETE FROM Tree WHERE Plot_CN = {0};", plot.Plot_CN); dal.Execute(command); plot.Delete(); return(true); }
public void SetValues(PlotDO obj) { if(obj == null) { return; } Plot_GUID = obj.Plot_GUID; PlotNumber = obj.PlotNumber; IsEmpty = obj.IsEmpty; Slope = obj.Slope; KPI = obj.KPI; Aspect = obj.Aspect; Remarks = obj.Remarks; XCoordinate = obj.XCoordinate; YCoordinate = obj.YCoordinate; ZCoordinate = obj.ZCoordinate; MetaData = obj.MetaData; Blob = obj.Blob; }
public PlotDO(PlotDO obj) : this() { SetValues(obj); }
public Plot3PPNT(PlotDO plot) : base(plot) { }
public PlotVM(PlotDO obj) : base(obj) { }
private long? savePlots(PlotDO curPlot, long? stratumCN, bool first) { PlotDO fsPlot; fsPlot = fsDAL.ReadSingleRow<PlotDO>("Plot", "Where CuttingUnit_CN = ? and Stratum_CN = ? and PlotNumber = ?", curPlot.CuttingUnit_CN, thisStrCN, curPlot.PlotNumber); if (fsPlot == null) { // check if plot already exists (stratumCN, plot number and unit code) fsPlot = new PlotDO(fsDAL); fsPlot.Stratum_CN = thisStrCN; fsPlot.CuttingUnit_CN = curPlot.CuttingUnit_CN; fsPlot.PlotNumber = curPlot.PlotNumber; fsPlot.IsEmpty = curPlot.IsEmpty; fsPlot.Slope = curPlot.Slope; fsPlot.Aspect = curPlot.Aspect; fsPlot.Remarks = curPlot.Remarks; fsPlot.XCoordinate = curPlot.XCoordinate; fsPlot.YCoordinate = curPlot.YCoordinate; fsPlot.ZCoordinate = curPlot.ZCoordinate; fsPlot.MetaData = curPlot.MetaData; fsPlot.Blob = curPlot.Blob; //fsPlot.CreatedBy = curPlot.CreatedBy; //fsPlot.CreatedDate = curPlot.CreatedDate; fsPlot.Save(); } // else // { // fsPlot = fsDAL.ReadSingleRow<PlotDO>("Plot", "Where CuttingUnit_CN = ? and Stratum_CN = ? and PlotNumber = ?", curPlot.CuttingUnit_CN, thisStrCN, curPlot.PlotNumber); // // } return (fsPlot.Plot_CN); }
private long? savePlots(PlotDO curPlot, long? stratumCN, bool first) { PlotDO fsPlot; if (first) { fsPlot = new PlotDO(fsDAL); fsPlot.Stratum_CN = stratumCN; fsPlot.CuttingUnit_CN = curPlot.CuttingUnit_CN; fsPlot.PlotNumber = curPlot.PlotNumber; fsPlot.IsEmpty = curPlot.IsEmpty; fsPlot.Slope = curPlot.Slope; fsPlot.Aspect = curPlot.Aspect; fsPlot.Remarks = curPlot.Remarks; fsPlot.XCoordinate = curPlot.XCoordinate; fsPlot.YCoordinate = curPlot.YCoordinate; fsPlot.ZCoordinate = curPlot.ZCoordinate; fsPlot.MetaData = curPlot.MetaData; fsPlot.Blob = curPlot.Blob; fsPlot.CreatedBy = curPlot.CreatedBy; fsPlot.CreatedDate = curPlot.CreatedDate; fsPlot.Save(); } else { fsPlot = fsDAL.ReadSingleRow<PlotDO>("Plot", "Where CuttingUnit_CN = ? and Stratum_CN = ? and PlotNumber = ?", curPlot.CuttingUnit_CN, stratumCN, curPlot.PlotNumber); } return (fsPlot.Plot_CN); }
//private void _DGV_Plots_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) //{ // var plot = e.Row.DataBoundItem as PlotDO; // if (plot == null) { e.Cancel = true; return; } // e.Cancel = !this.DeletePlot(plot); //} protected bool TryDeletePlot(PlotDO plot) { plot.DAL.BeginTransaction(); try { PlotDO.RecursiveDeletePlot(plot); plot.DAL.CommitTransaction(); TreeDataDirty = true; return true; } catch { plot.DAL.RollbackTransaction(); return false; } }