public async Task <ActionResult <Visiting> > PostVisiting(Visiting visiting) { _context.Visitings.Add(visiting); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetVisiting), new { id = visiting.VisitingID }, visiting)); }
public ActionResult AddVisiting(int id, Visiting visiting) { try { //var str = "01.01.0001 0:00:00"; //DateTime date; //DateTime.TryParse(str, out date); //if (visiting.date == date) //{ // ModelState.AddModelError("classesTotal", "Введите кол-во занятий"); //} visiting.idSeasonTicket = id; if (ModelState.IsValid) { db.Visiting.Add(visiting); db.SaveChanges(); return(RedirectToAction("EditSeasonTicket", new { id })); } else { return(View(visiting)); } } catch (Exception) { return(View()); } }
void Visit(Action <List <Node>, Node> incrementor, Func <Node, bool> nodeSelector, Func <Edge, bool> edgeSelector) { List <Node> _entitiesToVisit = new List <Node>(graph.Roots(nodeSelector, edgeSelector)); while (_entitiesToVisit.Any( )) { Node _current = _entitiesToVisit.First( ); _entitiesToVisit.Remove(_current); if (nodeSelector(_current)) { if (GetTouchCountOf(_current) == 0) { ShowUp.Raise(this, new EventArgs <Node>(_current)); } if (GetTouchCountOf(_current) == 1) { PassOff.Raise(this, new EventArgs <Node>(_current)); } if (GetTouchCountOf(_current) == 0) { incrementor(_entitiesToVisit, _current); } Visiting.Raise(this, new EventArgs <Node>(_current)); } } }
public async Task <IActionResult> PutVisiting(int id, Visiting visiting) { if (id != visiting.VisitingID) { return(BadRequest()); } _context.Entry(visiting).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!VisitingExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void btnAdd_Click(object sender, EventArgs e) { var visitingRepository = new SqlVisitingRepository(frmGymManager.connectionString); var visit = new Visiting(); if (dgvAddVisit.CurrentRow.Cells[0].Value != null && dgvAddVisit.CurrentRow.Cells[1].Value != null) { visit.CardNumber = Convert.ToInt32(dgvAddVisit.CurrentRow.Cells[0].Value); visit.KeyNumber = Convert.ToInt32(dgvAddVisit.CurrentRow.Cells[1].Value); if (visitingRepository.InsertNewVisit(visit) > 0) { MessageBox.Show("Successfull operation", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Try Again", "Allert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Enter data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int Evaluate(Individual individual, bool print = false) { IEnumerable <Visiting> sortedVisitings = individual.Visitings.OrderBy(v => v.Weight); int total = 0; Visiting previousVisit = null; foreach (Visiting currentVisit in sortedVisitings) { if (previousVisit != null) { int v1 = previousVisit.Vertex; int v2 = currentVisit.Vertex; total += this.GetEdge(v1, v2).Weight; } previousVisit = currentVisit; } if (print) { IEnumerable <string> sortedNames = sortedVisitings .Select(visiting => this.NameOf(visiting.Vertex)); Console.WriteLine(String.Join(" => ", sortedNames) + $": {total}"); } return(total); }
/// <summary> /// Visits a single node. /// </summary> /// <param name="node">The node being visited.</param> /// <remarks>This method is in charge of pursuing the visit with the children and references of the given node, as well as raising the <see cref="Visiting"/> event.</remarks> protected virtual void VisitNode([NotNull] IGraphNode node) { if (node == null) { throw new ArgumentNullException(nameof(node)); } visitedNodes.Add(node); if (node != RootNode || !SkipRootNode) { Visiting?.Invoke(node, CurrentPath); } var objectNode = node as IObjectNode; if (objectNode != null) { VisitChildren(objectNode); VisitItemTargets(objectNode); } var memberNode = node as IMemberNode; if (memberNode != null) { VisitMemberTarget(memberNode); } visitedNodes.Remove(node); }
/// <summary> /// Visits a single node. /// </summary> /// <param name="node">The node being visited.</param> /// <param name="currentPath">The path of the node being visited.</param> /// <remarks>This method is in charge of pursuing the visit with the children and references of the given node, as well as raising the <see cref="Visiting"/> event.</remarks> protected virtual void VisitNode(IGraphNode node, GraphNodePath currentPath) { visitedNodes.Add(node); if (node != RootNode || !SkipRootNode) { Visiting?.Invoke(node, currentPath); } VisitChildren(node, currentPath); VisitSingleTarget(node, currentPath); VisitEnumerableTargets(node, currentPath); visitedNodes.Remove(node); }
public async Task <JsonResult> AddVisiting(Visiting Visiting) { int result = 0; if (Visiting.Id > 0) { result = await _service.UpdateVisit(Visiting); } else if (Visiting.Id == 0) { result = await _service.AddVisit(Visiting); } return(Json(result)); }
public async Task<int> AddVisit(Visiting Visiting) { var rowsAffected = 0; try { using (_context) { rowsAffected = await _context.Database.ExecuteSqlInterpolatedAsync($"EXEC SpAddVisiting @Description={Visiting.Description}, @VisitDate={Visiting.VisitDate}, @NotifyByEmail={Visiting.NotifyByEmail}, @CustomerId={Visiting.CustomerId}"); } } catch (Exception e) { throw e; } return rowsAffected; }
/// <summary> /// Insert information about new visit, user identify by his Card Number. /// In Date visit write today date auto. /// </summary> public int InsertNewVisit(Visiting obj) { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = new SqlCommand("spAddNewVisit", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@CardNumber", obj.CardNumber); command.Parameters.AddWithValue("@KeyNumber", obj.KeyNumber); var resultValue = command.Parameters.Add("@Result", SqlDbType.Int); resultValue.Direction = ParameterDirection.ReturnValue; command.ExecuteNonQuery(); return((int)command.Parameters["@Result"].Value); } } }
/// <summary> /// 确定增加来访信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { //来访时间 DateTime dtAccommodationtime = new DateTime(1900, 1, 1); if (txtVisitingTime.Text.Trim() != "") { if (!DateTime.TryParse(txtVisitingTime.Text.Trim(), out dtAccommodationtime)) { CommonFuncs.ShowMsg(this.Page, "来访时间格式不正确,请改正"); txtVisitingTime.Focus(); return; } } //离开时间 DateTime dtleavetime = new DateTime(1900, 1, 1); if (txtLikaiTime.Text.Trim() != "") { if (!DateTime.TryParse(txtLikaiTime.Text.Trim(), out dtleavetime)) { CommonFuncs.ShowMsg(this.Page, "离开时间格式不正确,请改正"); txtLikaiTime.Focus(); return; } } Visiting vi = new Visiting(); vi.dormitoryID = int.Parse(drtxtVist.SelectedItem.Value); vi.VisitingName = txtVisitingName.Text.Trim(); vi.VisitingTime = DateTime.Parse(txtVisitingTime.Text.Trim()); vi.LikaiTime = DateTime.Parse(txtLikaiTime.Text.Trim()); if (new VisitingBLL().InsertVisitingBLL(vi) == 1) { CommonFuncs.ShowMsg(this.Page, "添加来访信息成功"); } else { CommonFuncs.ShowMsg(this.Page, "添加来访信息失败!\\n\\n请检查各个输入是否合法,\\n来访信息ID是否已经存在,\\n或者请管理员查看系统日志。"); } }
public void Edit(Visiting visiting) { if (visiting != null) { using (var transaction = _db.Database.BeginTransaction()) { try { _db.Entry(visiting).State = EntityState.Modified; _db.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw; } } } }
public async Task <IActionResult> MarkVisiting([FromRoute] int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var client = context.Clients.Find(id); if (client == null) { return(NotFound()); } var lastVisiting = client.Visitings.LastOrDefault(); if (lastVisiting != null && lastVisiting.FinishTime == null) { client.Visitings.LastOrDefault().FinishTime = client.Visitings.LastOrDefault().StartTime.Date.AddHours(23); } Visiting visiting = new Visiting { StartTime = DateTime.Now, FinishTime = null }; client.Visitings.Add(visiting); context.Update(client); try { await context.SaveChangesAsync(); } catch (Exception e) { Console.WriteLine(e); } return(Ok()); }
static void Main() { List <CanGreet> greeters = new List <CanGreet>(); greeters.Add(new Teacher("MH", new DateTime(1971, 12, 7), "Programming Languages")); greeters.Add(new Teacher("JY", new DateTime(1975, 9, 21), "Forbidden Archeology")); greeters.Add(new Student("YK", new DateTime(1999, 3, 16), 2051)); greeters.Add(new Student("SH", new DateTime(2000, 10, 5), 4968)); CanGreet Alice = new Visiting("Alice", new DateTime(1995, 7, 14), 9595, new DateTime(2019, 12, 25)); CanGreet Vanessa = new Visiting("Vanessa", new DateTime(1998, 3, 27), 9598, new DateTime(2019, 2, 28)); greeters.Add(Alice); greeters.Add(Vanessa); Console.WriteLine("A few CAU members..."); foreach (CanGreet greeter in greeters) { Console.WriteLine(greeter.Greet()); } Console.WriteLine(); greeters.Sort(new AgeSorter()); Console.WriteLine("Members sorted on age..."); foreach (CanGreet greeter in greeters) { Console.WriteLine(greeter.Greet()); } Console.WriteLine(); greeters.Sort(new ReverseNameSorter()); Console.WriteLine("Members reverse sorted on name..."); foreach (CanGreet greeter in greeters) { Console.WriteLine(greeter.Greet()); } }
/// <summary> /// Get information about visits what use the selected Key. /// </summary> public IEnumerable <Visiting> GetVisitsByKeyNumber(Visiting obj) { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = new SqlCommand("spGetVisitsByKeyNumber", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@KeyNumber", obj.KeyNumber); var visitsList = new List <Visiting>(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { visitsList.Add(new Visiting { CardNumber = reader["CardNumber"] is DBNull ? 0 : (int)reader["CardNumber"], KeyNumber = reader["KeyNumber"] is DBNull ? 0 : (int)reader["KeyNumber"], DateVisit = reader["DateVisit"] is DBNull ? "01/01/1753" : reader["DateVisit"].ToString().Remove(10) }); } } return(visitsList); } } }
public void Add(Visiting visiting) { _db.Visiting.Add(visiting); _db.SaveChanges(); }
public MedRecordOpenViewModel(MedRecord medRecord, Employee employee) { currentMedRecord = medRecord; currentEmployee = employee; DownloadXrays(medRecord); DownloadVisiting(medRecord); Diagnosings = DiagnosisViewModel.DiagnosisTake(); Medicaments = MedicamentViewModel.MedicamentsTake(); EditXrays = new DelegateCommand(() => { editoradd = false; selectedXrays?.BeginEdit(); var w = new XraysEdit(); w.DataContext = this; w.ShowDialog(); }, () => selectedXrays != null); AddXrays = new DelegateCommand(() => { editoradd = true; Xrays xrays = new Xrays(); SelectedXrays = xrays; var w = new XraysEdit(); w.DataContext = this; w.Show(); }); SaveXrays = new DelegateCommand(() => { if (editoradd == true) { selectedXrays.IdMedRecord = currentMedRecord.Id; context.Xrays.Add(selectedXrays); context.SaveChanges(); Photos.Add(SelectedXrays); } else { context.Entry(selectedXrays).State = EntityState.Modified; context.SaveChanges(); } }, () => selectedXrays.Photo != null); RemoveXrays = new DelegateCommand(() => { if (MessageBox.Show("Удалить?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { context.Entry(selectedXrays).State = EntityState.Deleted; Photos.Remove(selectedXrays); context.SaveChanges(); } else { return; } }, () => selectedXrays != null); CanselXrays = new DelegateCommand(() => { if (editoradd == false) { if (selectedXrays == null) { return; } SelectedXrays.CancelEdit(); } else { return; } }); AddImage = new DelegateCommand(() => { OpenFileDialog dlg = new OpenFileDialog(); dlg.InitialDirectory = ""; dlg.Filter = "Image files (*.jpg,*.png,*.bmp)|*.jpg;*.png;*.bmp|All Files (*.*)|*.*"; if (dlg.ShowDialog() == true) { string selectedFileName = dlg.FileName; selectedXrays.Photo = ConvertImageToByteArray(selectedFileName); SaveXrays.RaiseCanExecuteChanged(); } }); #region Visiting EditVisiting = new DelegateCommand(() => { editoradd = false; var w = new VisitingEdit(); w.DataContext = this; w.ShowDialog(); }, () => selectedVisiting != null); AddVisiting = new DelegateCommand(() => { editoradd = true; Visiting visiting = new Visiting(); SelectedVisiting = visiting; var w = new VisitingEdit(); w.DataContext = this; w.Show(); }); SaveVisiting = new DelegateCommand(() => { if (editoradd == true) { selectedVisiting.IDEmployee = currentEmployee.Id; selectedVisiting.IDMedRecord = currentMedRecord.Id; currentMedRecord = context.MedRecord.Find(currentMedRecord.Id); currentEmployee = context.Employee.Find(currentEmployee.Id); currentMedicament = context.Medicament.Find(selectedVisiting.IDMedicament); currentDiagnosis = context.Diagnosis.Find(selectedVisiting.IDDiagnosis); //Diagnosings = DiagnosisViewModel.DiagnosisTake(); //Medicaments = MedicamentViewModel.MedicamentsTake(); context.Visiting.Add(selectedVisiting); context.SaveChanges(); Visitings.Add(SelectedVisiting); } else { currentMedRecord = context.MedRecord.Find(currentMedRecord.Id); currentEmployee = context.Employee.Find(currentEmployee.Id); currentMedicament = context.Medicament.Find(selectedVisiting.IDMedicament); currentDiagnosis = context.Diagnosis.Find(selectedVisiting.IDDiagnosis); context.Entry(selectedVisiting).State = EntityState.Modified; context.SaveChanges(); } }); RemoveVisiting = new DelegateCommand(() => { if (MessageBox.Show("Удалить?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { context.Entry(selectedVisiting).State = EntityState.Deleted; Visitings.Remove(selectedVisiting); context.SaveChanges(); } else { return; } }, () => selectedVisiting != null); CanselVisiting = new DelegateCommand(() => { if (editoradd == false) { if (selectedVisiting == null) { return; } SelectedVisiting.CancelEdit(); } else { return; } }); ExportVisiting = new DelegateCommand(() => { try { Microsoft.Office.Interop.Excel.Application exApp = new Microsoft.Office.Interop.Excel.Application(); Workbook workbook = exApp.Workbooks.Add(Type.Missing); Worksheet workSheet = (Worksheet)exApp.ActiveSheet; workSheet.Cells[1, 1] = "ФИО пациента"; workSheet.Cells[1, 2] = "ФИО врача"; workSheet.Cells[1, 3] = "Дата"; workSheet.Cells[1, 4] = "Жалобы"; workSheet.Cells[1, 5] = "Начало болезни"; workSheet.Cells[1, 6] = "Текущее состояние"; workSheet.Cells[1, 7] = "Дополнительно"; workSheet.Cells[1, 8] = "Медикамент"; workSheet.Cells[1, 9] = "Диагноз"; int rowExcel = 2; foreach (var item in Visitings) { workSheet.Cells[rowExcel, "A"] = item.MedRecord.Surname + item.MedRecord.Name + item.MedRecord.Patronymic; workSheet.Cells[rowExcel, "B"] = item.Employee.Surname + item.Employee.Name + item.Employee.Patronymic; workSheet.Cells[rowExcel, "C"] = item.Date; workSheet.Cells[rowExcel, "D"] = item.Complaints; workSheet.Cells[rowExcel, "E"] = item.StartDisease; workSheet.Cells[rowExcel, "F"] = item.StatePraesens; workSheet.Cells[rowExcel, "G"] = item.Additionally; workSheet.Cells[rowExcel, "H"] = item.Medicament.Name; workSheet.Cells[rowExcel, "I"] = item.Diagnosis.Name; ++rowExcel; } //workbook.Close(); exApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(exApp); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка записи в Excel"); } }); #endregion }
private int TraverseForwardCalculatingPeriodIterative2( DelayGraphVertex startingVertex, out bool foundCycle) { Stack <PeriodTraverseState> stack = new Stack <PeriodTraverseState>(); stack.Push(new PeriodTraverseState(startingVertex)); PeriodTraverseState currentState = null; foundCycle = false; while (stack.Any()) { currentState = stack.Peek(); int alreadyComputedDelay = 0; if (ComputedDelays.TryGetValue(currentState.Vertex, out alreadyComputedDelay)) // put in for reconvergent paths { currentState.DelayReturned = alreadyComputedDelay; stack.Pop(); continue; } if (currentState.StateWaitingOn == null) // this state is used here just to tell if we are coming along here b/c we need to attend to unfinished business where we might have already set 'visited' { if (Visiting.Contains(currentState.Vertex)) // stop recursing if we're going along a loop, but still add up the delays of the loop { currentState.DelayReturned = 0; foundCycle = true; stack.Pop(); continue; } Visiting.Add(currentState.Vertex); } if (currentState.UnfinishedEdges == null) { IEnumerable <DelayGraphEdge> foundOutgoingEdges; if (Graph.TryGetOutEdges(currentState.Vertex, out foundOutgoingEdges)) { currentState.UnfinishedEdges = new Queue <DelayGraphEdge>(foundOutgoingEdges); } } bool done = true; while (currentState.UnfinishedEdges != null && currentState.UnfinishedEdges.Any()) { var outEdge = currentState.UnfinishedEdges.Peek(); int delayOnThisPath; if (Registered(outEdge.Target)) // stop recursing when we hit a register { delayOnThisPath = outEdge.Delay; } else if (Visiting.Contains(outEdge.Target)) { // found a cycle foundCycle = true; delayOnThisPath = outEdge.Delay; } else { if (currentState.StateWaitingOn == null) { currentState.StateWaitingOn = new PeriodTraverseState(outEdge.Target); stack.Push(currentState.StateWaitingOn); done = false; // need to process what we just pushed break; } else { delayOnThisPath = outEdge.Delay + currentState.StateWaitingOn.DelayReturned; currentState.StateWaitingOn = null; } } currentState.UnfinishedEdges.Dequeue(); currentState.MaxAmongOutgoingEdges = Math.Max(currentState.MaxAmongOutgoingEdges, delayOnThisPath); } if (done) { ComputedDelays[currentState.Vertex] = currentState.MaxAmongOutgoingEdges; currentState.DelayReturned = currentState.MaxAmongOutgoingEdges; Visiting.Remove(currentState.Vertex); stack.Pop(); } } return(currentState.DelayReturned); }