private void MyDeviceWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { btSave.IsEnabled = true; if (result.Result) { if (this.mode == EType.WindowMode.ADD_MODE) { if (getDeviceWorker.IsBusy) { getDeviceWorker.CancelAsync(); } else { getDeviceWorker.RunWorkerAsync(); } } else { DTO_Device oldDevice = Repository.lstAllDevices.FirstOrDefault(c => c.Id == myDevice.Id); if (oldDevice != null) { oldDevice = myDevice; } this.DialogResult = true; this.Hide(); } } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void cbConnectDevice_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (mode == EType.WindowMode.ADD_MODE) { DTO_Device selectedDevice = (DTO_Device)cbConnectDevice.SelectedItem; cbConnectSocket.ItemsSource = selectedDevice.Sockets.Where(s => s.IsUse == false); cbConnectSocket.DisplayMemberPath = "Name"; cbConnectSocket.SelectedValuePath = "Id"; cbConnectSocket.SelectedIndex = 0; } else { DTO_Device selectedDevice = (DTO_Device)cbConnectDevice.SelectedItem; cbConnectSocket.ItemsSource = selectedDevice.Sockets; cbConnectSocket.DisplayMemberPath = "Name"; cbConnectSocket.SelectedValuePath = "Id"; if (socket.ConnectedDeviceId == null) { cbConnectSocket.SelectedIndex = 0; } else { cbConnectSocket.SelectedValue = socket.ConnectedDeviceSocketId; } } }
private void cbDevice_SelectionChanged(object sender, SelectionChangedEventArgs e) { DTO_Device selectedDevice = (DTO_Device)cbDevice.SelectedItem; if (selectedDevice != null) { cbDeviceSocket.ItemsSource = selectedDevice.Sockets; cbDeviceSocket.DisplayMemberPath = "Name"; cbDeviceSocket.SelectedValuePath = "Id"; } }
/// <summary> /// Update device information /// </summary> /// <param name="device">The device object want to update</param> /// <returns>Return true if update success, Error if update fail or validate fail</returns> public SQLResult UpdateDevice(DTO_Device device) { if (device == null) { return(new SQLResult(false, "Device can't null")); } if (!device.Validate().Result) { return(new SQLResult(false, device.Validate().Detail)); } return(dal.UpdateDevice(device)); }
private void Window_Loaded(object sender, RoutedEventArgs e) { InitData(); switch (mode) { case EType.WindowMode.ADD_MODE: ResetControl(); myDevice = new DTO_Device(); break; default: BindData(); break; } }
private void DeleteDeviceWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (result.Result) { DTO_Device oldDevice = Repository.lstAllDevices.FirstOrDefault(c => c.Id == myDevice.Id); if (oldDevice != null) { Repository.lstAllDevices.Remove(oldDevice); } this.DialogResult = true; this.Hide(); } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
/// <summary> /// Get all device /// </summary> /// <returns>Return list device or null if error</returns> public List <DTO_Device> GetAllDevice() { List <DTO_Device> lstDevices = new List <DTO_Device>(); DataTable dt = dal.GetAllDevice(); if (dt.Rows.Count < 0) { return(null); } try { foreach (DataRow row in dt.Rows) { FAMode mode = new FAMode(); mode.IsUse = Convert.ToInt16(row["FAMode"].ToString()) == 1 ? true : false; mode.FAHWNumber = Convert.ToInt16(row["FAHW"].ToString()); DTO_Device device = new DTO_Device(); device.Id = row["Id"].ToString(); device.Name = row["Name"].ToString(); device.MAC = row["MAC"].ToString(); device.IP = row["IP"].ToString(); device.Subnet = row["Subnet"].ToString(); device.GateWay = row["GateWay"].ToString(); device.HostIp = row["HostIp"].ToString(); device.FAMode = mode; device.CtrMode = (ControlMode)Convert.ToInt16(row["CtrlMode"].ToString()); device.Description = row["Description"].ToString(); device.Sockets = busSocket.GetSocketByDevice(device.Id); lstDevices.Add(device); } return(lstDevices); } catch (Exception ex) { return(null); } }
/// <summary> /// Update device information in database /// </summary> /// <param name="device"></param> /// <returns></returns> public SQLResult UpdateDevice(DTO_Device device) { DataTable dt = new DataTable(); SQLResult result = new SQLResult(false, ""); try { _conn.Open(); SqlCommand command = new SqlCommand(); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; command.CommandText = "spLDeviceSave"; command.Parameters.AddWithValue("WorkType", "U"); command.Parameters.AddWithValue("Id", device.Id); command.Parameters.AddWithValue("Name", device.Name); command.Parameters.AddWithValue("MAC", device.MAC); if (device.IP == null) { command.Parameters.AddWithValue("IP", DBNull.Value); } else { command.Parameters.AddWithValue("IP", device.IP); } if (device.Subnet == null) { command.Parameters.AddWithValue("Subnet", DBNull.Value); } else { command.Parameters.AddWithValue("Subnet", device.Subnet); } if (device.GateWay == null) { command.Parameters.AddWithValue("Gateway", DBNull.Value); } else { command.Parameters.AddWithValue("Gateway", device.GateWay); } if (device.HostIp == null) { command.Parameters.AddWithValue("HostIP", DBNull.Value); } else { command.Parameters.AddWithValue("HostIP", device.HostIp); } command.Parameters.AddWithValue("FAMode", device.FAMode.IsUse ? 1 : 0); command.Parameters.AddWithValue("FAHW", device.FAMode.FAHWNumber); command.Parameters.AddWithValue("CtrlMode", device.CtrMode); command.Parameters.AddWithValue("Description", device.Description); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(dt); if (dt.Rows[0]["Result"].ToString() == "OK") { result.Result = true; } result.Detail = dt.Rows[0]["Detail"].ToString(); } catch (Exception ex) { result.Detail = ex.Message; } finally { _conn.Close(); } return(result); }
public wdDeviceDetail(EType.WindowMode mode, DTO_Device device) { InitializeComponent(); this.myDevice = device; this.mode = mode; }