public Video Create(CreateVideoCommand command) { var video = new Video(command.Url, command.TvAdditional, command.IdTypeVideo, command.IdTimeVideo, command.IdCompany, command.IdCategoryVideo, command.IdPlan, command.DateEnd, command.DateStart, command.ListVideoEquipment); //Marca todos itens da lista ListVideoEquipment com status Ativo foreach (var videoEquipment in command.ListVideoEquipment) { videoEquipment.Status = EStatusVideoEquipment.Ativo; videoEquipment.DateRegister = DateTime.Now; } video.Create(); _repository.Create(video); Commit(); foreach (var videoEquipment in command.ListVideoEquipment) { var item = _repositoryVideoEquipment.GetById(videoEquipment.IdVideoEquipment); decimal valueByTv = _repositoryBalance.GetValueByVideo(item.IdVideo); var history = new HistoryEquipment(item.IdVideo, item.IdEquipment, item.ControlLoan.IdCompany, item.Video.Plan.Description, EAction.Inclusão, valueByTv); history.Create(); _repositoryHistoryEquipment.Create(history); } if (Commit()) { return(video); } return(null); }
public Video Update(UpdateVideoCommand command) { var video = _repository.GetById(command.IdVideo); video.Update(command); _repository.Update(video); //if(video.Plan.IdPlan != command.IdPlan || video.) Commit(); var videoEquipment = _repositoryVideoEquipment.GetAllByVideo(video.IdVideo); foreach (var item in videoEquipment) { decimal valueByTv = _repositoryBalance.GetValueByVideo(video.IdVideo); var history = new HistoryEquipment(command.IdVideo, item.IdEquipment, item.ControlLoan.IdCompany, video.Plan.Description, EAction.Atualização, valueByTv); history.Create(); _repositoryHistoryEquipment.Create(history); } if (Commit()) { return(video); } return(null); }
public VideoEquipment Create(CreateVideoEquipmentCommand command) { //Insere dados na tabela de histórico var loan = _repositoryLoan.GetById(command.IdControlLoan); decimal valueByTv = _repositoryBalance.GetValueByVideo(command.IdVideo); var video = _repositoryVideo.GetById(command.IdVideo); var history = new HistoryEquipment(command.IdVideo, command.IdEquipment, loan.IdCompany, video.Plan.Description, EAction.Inclusão, valueByTv); history.Create(); _repositoryHistoryEquipment.Create(history); //Caso já exista os mesmos dados na tabela VideoEquipment, o registro é apenas atualizado com status ativo VideoEquipment videoEquipment = null; videoEquipment = _repository.GetById(command.IdEquipment, command.IdVideo, command.IdControlLoan); if (videoEquipment != null) { videoEquipment.Status = EStatusVideoEquipment.Ativo; } else { videoEquipment = new VideoEquipment(command.IdVideo, command.IdEquipment, command.IdControlLoan); videoEquipment.Create(videoEquipment); _repository.Create(videoEquipment); } if (Commit()) { return(videoEquipment); } return(null); }
public HistoryEquipment Create(CreateHistoryEquipmentCommand command) { var history = new HistoryEquipment(command.IdVideo, command.IdEquipment, command.IdCompany, command.Plan, command.Action, command.Value); history.Create(); _repository.Create(history); if (Commit()) { return(history); } return(null); }
public void UpdateStatusListVideo() { VideoEquipment videoEquipment = new VideoEquipment(); var listVideoEquipment = _repository.GetByStatus(EStatusVideoEquipment.Ativo); ICollection <VideoEquipment> listVideoEquipmentUpdate = videoEquipment.UpdateStatusListVideo(listVideoEquipment); foreach (var video in listVideoEquipmentUpdate) { var item = _repositoryVideoEquipment.GetById(videoEquipment.IdVideoEquipment); decimal valueByTv = _repositoryBalance.GetValueByVideo(item.IdVideo); var history = new HistoryEquipment(item.IdVideo, item.IdEquipment, item.ControlLoan.IdCompany, item.Video.Plan.Description, EAction.Exclusão, valueByTv); history.Create(); _repositoryHistoryEquipment.Create(history); } _repository.UpdateStatusListVideo(listVideoEquipmentUpdate); Commit(); }
public VideoEquipment Delete(int idEquipment, int idVideo, int controlLoan) { var loan = _repositoryLoan.GetById(controlLoan); decimal valueByTv = _repositoryBalance.GetValueByVideo(idVideo); var video = _repositoryVideo.GetById(idVideo); var history = new HistoryEquipment(idVideo, idEquipment, loan.IdCompany, video.Plan.Description, EAction.Exclusão, valueByTv); history.Create(); _repositoryHistoryEquipment.Create(history); var videoEquipment = _repository.GetIdVideoEquipment(idEquipment, idVideo); videoEquipment.Delete(videoEquipment); _repository.Delete(videoEquipment); if (Commit()) { return(videoEquipment); } return(null); }
//设备管理功能选择 private void Choice(object sender, RoutedEventArgs e) { TreeViewItem assets = ((sender as TreeView).SelectedItem as TreeViewItem); //MessageBox.Show(assets.Uid.ToString()); string assetsName = assets.Uid.ToString(); if (assetsName == null || "".Equals(assetsName)) { roomGrid.Children.Clear(); } if (roomGrid.Children != null) { roomGrid.Children.Clear(); } // ================================================================================== if (assetsName.Equals("Elist")) { EquipmentList equipment = RoomManagerBean.EquipmentList; RoomClass rc = new RoomClass(); EquipmentBean bean = new EquipmentBean(); DataSet equipmentSet = rc.queryEquipmentList(bean); DataSet typeSet = rc.queryType(); ComboBox box = RoomManagerBean.EquipmentList.type; if (box.HasItems) { box.Items.Clear(); } ComboBoxItem boxItem = new ComboBoxItem(); boxItem.Content = "请选择..."; boxItem.Tag = ""; boxItem.IsSelected = true; box.Items.Add(boxItem); //RoomManagerBean.DeviceClass.selectType.SelectedValuePath = ""; if (typeSet.Tables.Count > 0) { DataRowCollection drc = typeSet.Tables[0].Rows; for (int i = 0; i < drc.Count; i++) { DataRow dr = drc[i]; int typeId = (int)dr["ID"]; string typeName = dr["TYPE_NAME"].ToString(); ComboBoxItem boxItems = new ComboBoxItem(); boxItems.Content = typeName; boxItems.Tag = typeId; box.Items.Add(boxItems); //MessageBox.Show("typeId=" + typeId + " typeName=" + boxItems.Tag); } //MessageBox.Show("===" + equipmentSet.Tables.Count); RoomManagerBean.EquipmentList.page.ShowPages(RoomManagerBean.EquipmentList.equipment, equipmentSet, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(equipment); equipment.SetValue(Grid.RowProperty, 0); equipment.SetValue(Grid.ColumnProperty, 0); } } else if (assetsName.Equals("Report")) { Statement statement = RoomManagerBean.Statement; roomGrid.Children.Add(statement); statement.SetValue(Grid.RowProperty, 0); statement.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("Inventory")) { RoomClass rc = new RoomClass(); DataSet stockSet = rc.queryInventory(); RoomManagerBean.DeviceList.page.ShowPages(RoomManagerBean.DeviceList.stock, stockSet, BaseRequest.PAGE_SIZE); DeviceList deviceList = RoomManagerBean.DeviceList; roomGrid.Children.Add(deviceList); deviceList.SetValue(Grid.RowProperty, 0); deviceList.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("Category")) { DeviceClass deviceClass = RoomManagerBean.DeviceClass; RoomClass room = new RoomClass(); QueryUser query = new QueryUser(); //query.Account = UserManagerBean.AddUser.queryAccount.Text; //query.UserName = UserManagerBean.AddUser.queryName.Text; DataSet set = room.queryType(); RoomManagerBean.DeviceClass.page.ShowPages(RoomManagerBean.DeviceClass.deviceData, set, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(deviceClass); deviceClass.SetValue(Grid.RowProperty, 0); deviceClass.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("HistoryEquipment")) { HistoryEquipment he = RoomManagerBean.HistoryEquipment; RoomClass rc = new RoomClass(); DataSet set = rc.queryHistoryEquipment(); he.page.ShowPages(he.historyEquipment, set, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(he); he.SetValue(Grid.RowProperty, 0); he.SetValue(Grid.ColumnProperty, 0); } }
public void Update(HistoryEquipment history) { _context.Entry <HistoryEquipment>(history).State = EntityState.Modified; }
public void Create(HistoryEquipment history) { _context .HistoryEquipment .Add(history); }