public static int Insert(DeviceData d)
{
int result = -1;
//p_insert_device
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_insert_device`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_d_name", MySqlDbType.VarChar, 255) { Direction = System.Data.ParameterDirection.Input, Value = d.Name });
cmd.Parameters.Add(new MySqlParameter("@_d_ip", MySqlDbType.VarChar, 30) { Direction = System.Data.ParameterDirection.Input, Value = d.IP });
cmd.Parameters.Add(new MySqlParameter("@_d_type", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value =d.Type });
cmd.Parameters.Add(new MySqlParameter("@_d_pass", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = d.Pass });
cmd.Parameters.Add(new MySqlParameter("@_d_comment", MySqlDbType.Text) { Direction = System.Data.ParameterDirection.Input, Value = d.Comment });
cmd.Parameters.Add(new MySqlParameter("@_d_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Output, Value = 0 });
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
result = Convert.ToInt32(cmd.Parameters["@_d_id"].Value);
};
conn.Close();
};
}
catch (Exception)
{
}
return result;
}
private void LoadGUI(DeviceData d)
{
if (this.Device == null)
{
this.UITitle.Text = "Thêm thiết bị mới";
this.UIName.reset();
this.UIIP.reset();
this.UIType.SelectedIndex =- 1;
UIContent.Height = 445;
}
else
{
this.UIName.Text = d.Name;
this.UIIP.Text = d.IP;
this.UITitle.Text = d.Name;
this.UIType.SelectedItem = d.TypeDevice;
UIContent.Height = 505;
}
}
private void LoadGUI(DeviceData d)
{
if (d.TypeDevice != null && !string.IsNullOrEmpty(d.TypeDevice.Icon))
{
this.UIIcon.Text = d.TypeDevice.Icon;
}
this.UIIP.Text = d.IP;
this.UITitle.Text = d.Name;
this.UITime.Text = d.Time.format();
this.UIType.Text = d.TypeDevice.Name;
if (d.User != null)
this.UIUser.Text = d.User.Full_Name;
else
this.UIUser.Text = string.Empty;
if (d.Status)
{
this.UIStatus.Text = Define.Fonts["fa-unlock"].Code;
}
else
{
this.UIStatus.Text = Define.Fonts["fa-lock"].Code;
}
}
private void UIBtnSave_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
if (string.IsNullOrEmpty(this.UIName.Text))
{
MessageBox.Show("Tên thiết bị không được để trống");
return;
}
if (this.UIType.SelectedIndex == -1)
{
MessageBox.Show("Chon loại thiết bị");
return;
}
if (!this.UIIP.Text.isIP())
{
MessageBox.Show("Địa chỉ IP không đúng định dạng");
return;
}
if (string.IsNullOrEmpty(this.UIPass.Password) && this.Device == null)
{
MessageBox.Show("Mật khẩu không được để trống");
return;
}
if (this.UIPass.Password != this.UIPass_Again.Password)
{
MessageBox.Show("Mật khẩu không khớp. Kiểm tra lại!");
return;
}
if (this.Device != null && this.Device.Pass != this.UIPass_Old.Password.MD5String())
{
MessageBox.Show("Mật khẩu đúng. Vui lòng kiểm tra lại!");
return;
}
if(this.Device== null)
{
DeviceData d = new DeviceData();
d.Name = this.UIName.Text;
d.IP = this.UIIP.Text;
d.Pass = this.UIPass.Password.MD5String();
d.Type = (this.UIType.SelectedItem as TypeDevice).ID;
int result= DeviceData.Insert(d);
if(result <=0)
{
MessageBox.Show("Không thể kết nối CSDL");
return;
}
d.ID = result;
if (this.CloseEvent != null)
{
this.CloseEvent(this, d);
}
}else
{
this.d.Name = this.UIName.Text;
this.d.Type = (this.UIType.SelectedItem as TypeDevice).ID;
this.d.IP = this.UIIP.Text;
if (!string.IsNullOrEmpty(this.UIPass.Password))
{
this.d.Pass = this.UIPass.Password.MD5String();
}
this.d.save();
if (this.CloseEvent != null)
{
this.CloseEvent(this, this.d);
}
}
}
private void Item_CloseEvent(object sender, DeviceData e)
{
if (e != null)
{
bool isEdit = false;
foreach (UIDevice uid in this.list_Box_Item.Items)
{
if (uid.Device.ID == e.ID)
{
isEdit = true;
uid.Device = e;
}
}
if (!isEdit)
{
this.Datas = App.curUser.LoadDevices(this.from, ref this.to, out this.total);
LoadGUI();
}
}
this.UIRoot.Children.Remove(sender as UIDeviceEdit);
}
private void Item_ViewInfoEvent(object sender, DeviceData e)
{
if (e != null)
{
UIDeviceEdit item = new UIDeviceEdit();
item.setLeft(0);
item.setTop(90);
item.Height = 578;
item.Width = 1366;
item.Device = e;
item.CloseEvent += Item_CloseEvent;
this.UIRoot.Children.Add(item);
}
}
private void Item_DeleteEvent(object sender, DeviceData e)
{
if (e != null)
{
MessageBoxResult messageBoxResult = MessageBox.Show("Bạn có muốn xoá thiết bị này không?", "Xoá thiết bị", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
UIDevice uid = (this.list_Box_Item.SelectedItem as UIDevice);
if (this.list_Box_Item.SelectedIndex != 0)
{
this.list_Box_Item.SelectedIndex = 0;
}
else if (this.list_Box_Item.Items.Count > 1)
{
this.list_Box_Item.SelectedIndex = 1;
}
uid.Animation_Opacity_View_Frame(false, () =>
{
this.Datas.Remove(uid.Device);
this.list_Box_Item.Items.Remove(uid);
if (this.to < this.total)
{
this.Datas = App.curUser.LoadDevices(this.from, ref this.to, out this.total);
this.LoadGUI();
}
});
}
}
}
public static List<DeviceData> toDevices(this MySqlDataReader reader)
{
if (reader.HasRows)
{
List<DeviceData> datas = new List<DeviceData>();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
DeviceData d = new DeviceData();
d.ID = reader.GetInt32(Define.device_id);
d.Name = reader.GetString(Define.device_name);
d.Status = reader.GetBoolean(Define.device_status);
d.Time = reader.GetDateTime(Define.device_time);
d.Type = reader.GetInt32(Define.device_type);
d.IP = reader.GetString(Define.device_ip);
d.Pass = reader.GetString(Define.device_pass);
try
{
d.Comment = reader.GetString(Define.device_comment);
}
catch (Exception)
{
}
datas.Add(d);
}
}
return datas;
}
return null;
}
