public void Save(T_DeviceSettingRFID value, ref string msg)
{
//T_DeviceSettingRFID valueupdate = new T_DeviceSettingRFID();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_DeviceSettingRFIDs.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Device Name: {1}" + Environment.NewLine + "Port: {2}" + Environment.NewLine + "Baund Rate: {3}" + Environment.NewLine + "Data Bit: {4}" + Environment.NewLine + "Parity: {5}" + Environment.NewLine + "Stop Bit: {6}", SystemProperties.MessageNotification.Saved, value.DeviceName, value.Port, value.BaundRate, value.DataBit, value.Parity, value.StopBit);
}
else
{
//valueupdate = dc.T_DeviceSettingRFIDs.Where(x => x.ID == value.ID).FirstOrDefault();
var valueupdate = dc.T_DeviceSettingRFIDs.FirstOrDefault(x => x.ID == value.ID);
valueupdate.DeviceName = value.DeviceName;
valueupdate.BaundRate = value.BaundRate;
valueupdate.DataBit = value.DataBit;
valueupdate.Parity = value.Parity;;
valueupdate.Port = value.Port;
valueupdate.StopBit = value.StopBit;
valueupdate.Active = value.Active;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Device Name: {1}" + Environment.NewLine + "Port: {2}" + Environment.NewLine + "Baund Rate: {3}" + Environment.NewLine + "Data Bit: {4}" + Environment.NewLine + "Parity: {5}" + Environment.NewLine + "Stop Bit: {6}", SystemProperties.MessageNotification.Updated, value.DeviceName, value.Port, value.BaundRate, value.DataBit, value.Parity, value.StopBit);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
public void Delete(T_DeviceSettingRFID value, ref string msg)
{
//T_DeviceSettingRFID valuedelete = new T_DeviceSettingRFID();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//var valuedelete = dc.T_DeviceSettingRFIDs.Where(x => x.ID == value.ID).FirstOrDefault();
var valuedelete = dc.T_DeviceSettingRFIDs.FirstOrDefault(x => x.ID == value.ID);
dc.T_DeviceSettingRFIDs.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Device Name: {1}" + Environment.NewLine + "Port: {2}" + Environment.NewLine + "Baund Rate: {3}" + Environment.NewLine + "Data Bit: {4}" + Environment.NewLine + "Parity: {5}" + Environment.NewLine + "Stop Bit: {6}", SystemProperties.MessageNotification.Deleted, valuedelete.DeviceName, valuedelete.Port, valuedelete.BaundRate, valuedelete.DataBit, valuedelete.Parity, valuedelete.StopBit);
}
}
public bool Compare(T_DeviceSettingRFID value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//return dc.T_DeviceSettingRFIDs.Where(x => x.Active == value.Active && x.DeviceName.ToLower() == value.DeviceName.ToLower() && x.BaundRate == value.BaundRate && x.DataBit == value.DataBit && x.Parity == value.Parity && x.Port == value.Port && x.StopBit == value.StopBit).FirstOrDefault() == null ? true : false;
return(dc.T_DeviceSettingRFIDs
.Where(x =>
x.Active == value.Active &&
x.DeviceName.ToLower() == value.DeviceName.ToLower() &&
x.BaundRate == value.BaundRate &&
x.DataBit == value.DataBit &&
x.Parity == value.Parity &&
x.Port == value.Port &&
x.StopBit == value.StopBit)
.Any());
}
}
private T_DeviceSettingRFID SetDeviceConfig(bool isDelete)
{
T_DeviceSettingRFID value = new T_DeviceSettingRFID();
value.Active = cbActive.Checked;
value.BaundRate = Convert.ToInt32(txtBaundRate.Text);
value.DataBit = Convert.ToInt32(txtDataBits.Text);
value.Parity = cmbParity.Text;
value.StopBit = cmbStopBits.Text;
value.Port = txtComPort.Text;
value.DeviceName = txtName.Text;
value.ID = isAdd?0:Convert.ToInt64(dgDevice.SelectedRows[0].Cells[0].Value.ToString());
if (isDelete)
{
value.ID = Convert.ToInt64(dgDevice.SelectedRows[0].Cells[0].Value.ToString());
}
return(value);
}