public void ParseAndEvaluateDataUseNorthwindEmployees()
{
Parser parser = new Parser(File.OpenText("DataUseNorthwindEmployees.prg"));
ICommand command = parser.ParseCommandList();
Machine machine = new Machine();
StringWriter writer = new StringWriter();
lock (System.Console.Out)
{
TextWriter originalWriter = System.Console.Out;
System.Console.SetOut(writer);
command.Execute(machine, machine.Environment);
System.Console.SetOut(originalWriter);
}
object result = machine.Environment.GetValue("Employees");
Assert.IsNotNull(result);
Assert.IsInstanceOfType(result, typeof(WorkArea));
WorkArea workarea = (WorkArea)result;
Assert.IsFalse(workarea.MoveNext());
Assert.IsTrue(writer.ToString().Length > 10);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="reader">Index reader</param>
/// <param name="facetHandlers">List of facet handlers</param>
/// <param name="facetHandlerFactories">List of factories to create facet handler instances at runtime.</param>
/// <param name="workArea">A service locator that can be used to inject custom objects.</param>
/// <returns>A new BoboIndexReader instance.</returns>
public static BoboIndexReader GetInstanceAsSubReader(IndexReader reader,
IEnumerable <IFacetHandler> facetHandlers,
IEnumerable <IRuntimeFacetHandlerFactory> facetHandlerFactories,
WorkArea workArea)
{
return(GetInstanceAsSubReader(reader, facetHandlers, facetHandlerFactories, workArea, false));
}
void EditArea()
{
int index = (this.Owner as WorkAreas).lbox.Items.IndexOf(this.update_Area);
int idTable = update_Area.Id;
List <WorkArea> all = ReadFromDatabase.ShowAllAreas(num).ToList();
WorkArea update = all.Where(i => i.Id == idTable).FirstOrDefault();
update.SiteName = name_txt.Text;
update.Login = login_txt.Text;
update.Password = paswd_txt.Text;
update.Phone = Convert.ToInt32(phone_txt.Text);
update.URL = url_txt.Text;
update.Email = email_txt.Text;
update.Coments = coments_txt.Text;
update.DateCreate = DateTime.Now;
string res = EditRecord.EditInfo(update, num);
MessageBox.Show(res, "Result Update");
(this.Owner as WorkAreas).lbox.Items.RemoveAt(index);
(this.Owner as WorkAreas).lbox.Items.Insert(index, update);
this.Close();
}
void AddArea()
{
if (name_txt.Text == null && login_txt.Text == null && paswd_txt.Text == null && email_txt.Text == null &&
phone_txt.Text == null && url_txt.Text == null && coments_txt.Text == null)
{
MessageBox.Show("All fields is empty", "empty", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else if (name_txt.Text == null || login_txt.Text == null || paswd_txt.Text == null || email_txt.Text == null ||
phone_txt.Text == null || url_txt.Text == null || coments_txt.Text == null)
{
MessageBox.Show("Some of field are empty", "empty", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
WorkArea add_wa = new WorkArea
{
SiteName = name_txt.Text,
Login = login_txt.Text,
Password = paswd_txt.Text,
Email = email_txt.Text,
Phone = Convert.ToInt32(phone_txt.Text),
URL = url_txt.Text,
Coments = coments_txt.Text,
};
add_wa.DateCreate = DateTime.Now;
//string query = $"insert into WorkAreas_{num}(SiteName, Email, Login, Password, URL, Phone, Coments, DateCreate) " +
// $"values({add_wa.SiteName},{add_wa.Email},{add_wa.Login}," +
// $"{add_wa.Password},{add_wa.URL},{add_wa.Phone},{add_wa.Coments},'{add_wa.DateCreate}')";
string msg = Insert.AddWorkArea(add_wa, num);
MessageBox.Show(msg);
name_txt.Text = login_txt.Text = paswd_txt.Text = email_txt.Text = url_txt.Text = coments_txt.Text = phone_txt.Text = "";
}
}
public override void Execute(Machine machine, ValueEnvironment environment)
{
string name = EvaluateUtilities.EvaluateAsName(this.nameExpression, environment);
string commandText = null;
if (this.commandExpression != null)
{
commandText = (string)this.commandExpression.Evaluate(environment);
}
Database database = (Database)environment.GetValue(ValueEnvironment.CurrentDatabase);
WorkArea workarea;
if (commandText != null)
{
IDbCommand command = database.ProviderFactory.CreateCommand();
command.CommandText = commandText;
command.Connection = database.GetConnection();
workarea = new WorkArea(name, command, database.ProviderFactory);
}
else
{
workarea = new WorkArea(name, database.GetConnection(), database.ProviderFactory);
}
environment.SetPublicValue(name, workarea);
environment.SetPublicValue(ValueEnvironment.CurrentWorkArea, workarea);
}
public async Task <IResult> DeleteAsync(WorkArea entity)
{
ImageProcessHelper.Delete(entity.Picture);
await _workArea.DeleteAsync(entity);
return(new SuccessResult());
}
public void OleDbReadNext()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;User ID=Admin;Password=;");
WorkArea workarea = new WorkArea("TEST", conn, OleDbFactory.Instance);
Assert.IsTrue(workarea.MoveNext());
}
public async Task <IActionResult> Edit(string id, [Bind("WORKAREAID,DESCRIPTION")] WorkArea workArea)
{
if (id != workArea.WORKAREAID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(workArea);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!WorkAreaExists(workArea.WORKAREAID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(workArea));
}
public void SqlClientReadNext()
{
SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=.\\TestData.mdf;Integrated Security=True");
WorkArea workarea = new WorkArea("TestTable", conn, SqlClientFactory.Instance);
Assert.IsTrue(workarea.MoveNext());
}
void CalculateWorkArea()
{
WorkArea calculatedWorkArea = null;
#region Complicated distance calculation. If successful, returns new work area.
Dictionary <WorkArea, float> areaDstMap = new Dictionary <WorkArea, float>();
foreach (var area in allAreas)
{
areaDstMap.Add(area, (transform.position - area.transform.position).sqrMagnitude);
}
WorkArea[] copy = allAreas.ToArray();
System.Array.Sort(copy, (x, y) => areaDstMap[x].CompareTo(areaDstMap[y]));
// Get closest work area. Regardless if it's interactable or not.
if (copy.Length > 0)
{
calculatedWorkArea = copy[0];
}
#endregion
if (workArea != calculatedWorkArea)
{
if (workArea != null)
{
OnWorkAreaRemoved?.Invoke(workArea);
}
workArea = calculatedWorkArea;
OnWorkAreaChanged?.Invoke(workArea);
}
}
void OnWorkAreaChanged(WorkArea newArea)
{
if (newArea != null)
{
newArea.Highlight(true);
}
}
public static string EditInfo(WorkArea area, int num_tab)
{
string msg = "";
string query =
$"UPDATE WorkAreas_{num_tab} SET SiteName=@SiteName, Email=@Email, Login=@Login, Password=@Password, URL=@URL, Phone=@Phone, Coments=@Coments, DateCreate=@DateCreate WHERE Id={area.Id}";
using (var c = Connection.conn = new System.Data.SqlClient.SqlConnection(Connection.connectstr))
{
c.Open();
using (var cmd = Connection.cmd = new System.Data.SqlClient.SqlCommand(query, c))
{
cmd.Parameters.AddWithValue("@SiteName", area.SiteName);
cmd.Parameters.AddWithValue("@Email", area.Email);
cmd.Parameters.AddWithValue("@Login", area.Login);
cmd.Parameters.AddWithValue("@Password", area.Password);
cmd.Parameters.AddWithValue("@URL", area.URL);
cmd.Parameters.AddWithValue("@Phone", area.Phone);
cmd.Parameters.AddWithValue("@Coments", area.Coments);
cmd.Parameters.AddWithValue("@DateCreate", area.DateCreate = System.DateTime.Now);
int res = cmd.ExecuteNonQuery();
if (res == 1)
{
msg = $"info about - {area.SiteName} was Update successfuly";
}
else if (res == 0)
{
msg = $"info about - {area.SiteName} has NOT update...";
}
}
}
return(msg);
}
private void Initialize()
{
_svgMainFiles = new WorkArea();
_svgMainFiles.PageChanged += OnPageSelectionChanged;
_svgMainFiles.ToolDone += OnToolDone;
_svgMainFiles.ItemsSelected += SvgMainFilesItemsSelected;
_toolBox = new ToolBox {
Size = new Size(113, 165)
};
_toolBox.ToolSelectionChanged += ToolSelectionChanged;
_svgProperties = new WorkSpaceControlBox();
_svgProperties.ZoomChange += OnZoomChanged;
_svgProperties.GridOptionChange += GridOptionChaged;
_svgProperties.WorkAreaOptionChange += SvgPropertiesWorkAreaOptionChange;
_infoFilesMain = _docker.Add(_svgMainFiles, zAllowedDock.Fill, new Guid("a6402b80-2ebd-4fd3-8930-024a6201d001"));
_infoFilesMain.ShowCloseButton = false;
_infoToolbar = _docker.Add(_toolBox, zAllowedDock.All, new Guid("a6402b80-2ebd-4fd3-8930-024a6201d002"));
_infoToolbar.ShowCloseButton = false;
_infoDocumentProperties = _docker.Add(_svgProperties, zAllowedDock.All, new Guid("a6402b80-2ebd-4fd3-8930-024a6201d003"));
_infoDocumentProperties.ShowCloseButton = false;
_shapeProperties = new shapeProperties();
_shapeProperties.PropertyChanged += ShapePropertiesPropertyChanged;
_infoShapeProperties = _docker.Add(_shapeProperties, zAllowedDock.All, new Guid("a6402b80-2ebd-4fd3-8930-024a6201d004"));
_infoShapeProperties.ShowCloseButton = false;
}
/// <summary>
/// Load scheme from stream
/// </summary>
void LoadSchemeExcecuted(object parameter)
{
if (parameter is Stream)
{
WorkArea.Load(parameter as Stream, WorkArea.Scheme.NodeTypes);
}
}
public WorkAreaPage(ObservableCollection <WorkArea> workAreas, WorkArea workArea = null) : this()
{
Repo = new WorkAreaRepo();
Model = workArea ?? new WorkArea();
ModelList = workAreas ?? new ObservableCollection <WorkArea>();
DataContext = Model;
}
private void delete_btn_Click(object sender, RoutedEventArgs e)
{
if (lbox.SelectedItem != null)
{
MessageBoxResult res = MessageBox.Show("Are you realy want to delete this info??", "Delete?", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (res == MessageBoxResult.Yes)
{
WorkArea del = lbox.SelectedItem as WorkArea;
DeleteRecord.DeleteInfo(del);
lbox.Items.Remove(lbox.SelectedItem);
if (lbox.Items.Count == 0)
{
lbox.Items.Add("The table is empty. Try to add new info");
}
}
else
{
return;
}
}
else
{
MessageBox.Show("First you need to sellect any object!", "NOT Selected", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public void SqlClientCreateWorkArea()
{
SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=.\\TestData.mdf;Integrated Security=True");
WorkArea workarea = new WorkArea("TestTable", conn, SqlClientFactory.Instance);
Assert.AreEqual("TestTable", workarea.Name);
}
public void Update(WorkArea workArea)
{
if (workArea != null)
{
_applicationDbContext.WorkAreas.Update(workArea);
_applicationDbContext.SaveChanges();
}
}
//async Task ExecuteProjectDetailCommand(Project parm)
//{
// // await Application.Current.MainPage.DisplayAlert("Selected Peron", project.ProjectName, "Ok", "cancel");
// // await Shell.Current.GoToAsync("projectdetail");
//}
public WorkAreasViewModel(WorkArea parm)
{
WorkArea = parm;
//WorkAreaImages = parm.WorkAreaImages;
// AllProjects = new ObservableCollection<Project>();
// StatrtedProject = new ObservableCollection<Project>();
// ProjectDetailCommand = new Command<Project>(async (Project project) => await ExecuteProjectDetailCommand(project));
}
public void OleDbReadNextUsingCommand()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;User ID=Admin;Password=;");
OleDbCommand cmd = new OleDbCommand("select * from TEST order by CODIGO", conn);
WorkArea workarea = new WorkArea("TEST", cmd, OleDbFactory.Instance);
Assert.IsTrue(workarea.MoveNext());
}
public ActionResult DeleteConfirmed(int id)
{
WorkArea workArea = db.WorkAreas.Find(id);
db.WorkAreas.Remove(workArea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IResult> AddAsync(WorkArea entity, IFormFile file)
{
entity.Picture = Guid.NewGuid() + Path.GetExtension(file.FileName);
await ImageProcessHelper.UploadAsync(entity.Picture, FolderDirectories.WorkareaFolder, file);
await _workArea.AddAsync(entity);
return(new SuccessResult());
}
public void RemoveWorkArea(WorkArea newWorkArea)
{
if (allAreas.Contains(newWorkArea))
{
newWorkArea.OnWorkAreaUpdate -= OnWorkAreaChanged;
newWorkArea.OnCanvasUpdate -= OnCanvasUpdate;
allAreas.Remove(newWorkArea);
}
}
public void TestGetCreate()
{
var entity = new WorkArea();
entity.Id = "testId";
_repository.Create(entity);
Assert.Equal(entity, _repository.GetById("testId"));
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="reader">Index reader</param>
/// <param name="facetHandlers">List of facet handlers</param>
/// <param name="facetHandlerFactories">List of factories to create facet handler instances at runtime.</param>
/// <param name="workArea">A service locator that can be used to inject custom objects.</param>
/// <param name="autoClose">True to close the underlying IndexReader when this instance is closed.</param>
protected BoboIndexReader(IndexReader reader,
IEnumerable <IFacetHandler> facetHandlers,
IEnumerable <IRuntimeFacetHandlerFactory> facetHandlerFactories,
WorkArea workArea,
bool autoClose)
: this(reader, facetHandlers, facetHandlerFactories, workArea, autoClose, true)
{
_srcReader = reader;
_autoClose = autoClose;
}
public ActionResult Edit([Bind(Include = "WorkAreaId,WorkAreaName")] WorkArea workarea)
{
if (ModelState.IsValid)
{
m_DbContext.Entry(workarea).State = EntityState.Modified;
m_DbContext.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(workarea));
}
public void SetWorkArea(WorkArea newWorkArea, Collider collider)
{
if (!allAreas.Contains(newWorkArea))
{
workAreaCollider = collider;
allAreas.Add(newWorkArea);
newWorkArea.OnWorkAreaUpdate += OnWorkAreaChanged;
newWorkArea.OnCanvasUpdate += OnCanvasUpdate;
}
}
private void LoadFacetHandlers(WorkArea workArea)
{
var loaded = new List <string>();
var visited = new List <string>();
foreach (string name in m_facetHandlerMap.Keys)
{
this.LoadFacetHandler(name, loaded, visited, workArea);
}
}
public ActionResult Edit([Bind(Include = "Id,CreateTime,Name,Position,ProjectId,Remark,UpdateTime")] WorkArea workArea)
{
if (ModelState.IsValid)
{
db.Entry(workArea).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProjectId = new SelectList(db.Projects, "Id", "Decription", workArea.ProjectId);
return(View(workArea));
}
public async Task <IActionResult> Create([Bind("WORKAREAID,DESCRIPTION")] WorkArea workArea)
{
if (ModelState.IsValid)
{
_context.Add(workArea);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(workArea));
}
public static void GetWorkArea(AppBarWindow window, out int screen, out DockEdge edge, out WorkArea windowWA, out WorkArea appbarWA)
{
screen = Framework.Settings.Instance.ScreenIndex;
edge = Framework.Settings.Instance.DockEdge;
Monitor _screen = GetMonitorFromIndex(screen);
double _screenX = _screen.ScaleX;
double _screenY = _screen.ScaleY;
double _inverseX = _screen.InverseScaleX;
double _inverseY = _screen.InverseScaleY;
double _uiScale = Framework.Settings.Instance.UIScale;
double _abScaleX = _screenX * _uiScale;
double _abScaleY = _screenY * _uiScale;
if (OS.SupportDPI)
{
window.UpdateScale(_uiScale, _uiScale, false);
}
windowWA = new WorkArea()
{
Left = _screen.WorkArea.Left,
Top = _screen.WorkArea.Top,
Right = _screen.WorkArea.Right,
Bottom = _screen.WorkArea.Bottom
};
if (Framework.Settings.Instance.HighDPISupport)
{
windowWA.Left *= _inverseX;
windowWA.Top *= _inverseY;
windowWA.Right *= _inverseX;
windowWA.Bottom *= _inverseY;
}
double _windowWidth = Framework.Settings.Instance.SidebarWidth * _uiScale;
double _modifyX = 0d;
if (
window.IsAppBar &&
window.Screen == screen &&
window.DockEdge == edge &&
(_screen.WorkArea.Width + window.AppBarWidth) <= _screen.Size.Width
)
{
_modifyX = window.AppBarWidth;
}
switch (edge)
{
case DockEdge.Left:
windowWA.Right = windowWA.Left + _windowWidth - _modifyX;
windowWA.Left -= _modifyX;
break;
case DockEdge.Right:
windowWA.Left = windowWA.Right - _windowWidth + _modifyX;
windowWA.Right += _modifyX;
break;
}
int _offsetX = Framework.Settings.Instance.XOffset;
int _offsetY = Framework.Settings.Instance.YOffset;
windowWA.Left += _offsetX;
windowWA.Top += _offsetY;
windowWA.Right += _offsetX;
windowWA.Bottom += _offsetY;
appbarWA = new WorkArea()
{
Left = windowWA.Left,
Top = windowWA.Top,
Right = windowWA.Right,
Bottom = windowWA.Bottom
};
if (Framework.Settings.Instance.HighDPISupport)
{
double _abWidth = appbarWA.Width * _abScaleX;
switch (edge)
{
case DockEdge.Left:
appbarWA.Right = appbarWA.Left + _abWidth;
break;
case DockEdge.Right:
appbarWA.Left = appbarWA.Right - _abWidth;
break;
}
}
}
