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