public string SearchBySystemId(CvSystemProperty dataItem)
{
string sql = @" SELECT * FROM tableName
WHERE ID = 'dataItem.ID'";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.ID", dataItem.ID);
return(sql);
}
private void frmSystemSpecSettingCommon_Load(object sender, EventArgs e)
{
CvSystemProperty CvSystemProperty = _cvSystemController.SearchBySystemId(new CvSystemProperty {
ID = frmSystem.SYSTEM_ID
});
system_name.Text = CvSystemProperty.SYSTEM_NAME;
ip_address_system.Text = CvSystemProperty.IP_ADDRESS_SYSTEM;
_getDetail();
}
public string SearchByIpAddressSystem(CvSystemProperty dataItem)
{
string sql = @" SELECT * FROM tableName
WHERE IP_ADDRESS_SYSTEM = 'dataItem.IP_ADDRESS_SYSTEM'
AND INUSE = 1";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.IP_ADDRESS_SYSTEM", dataItem.IP_ADDRESS_SYSTEM);
return(sql);
}
private void frmSystemSpecSettingSpecific_Load(object sender, EventArgs e)
{
CvSystemProperty CvSystemProperty = _cvSystemController.SearchBySystemId(new CvSystemProperty {
ID = frmSystem.SYSTEM_ID
});
SYSTEM_NAME.Text = CvSystemProperty.SYSTEM_NAME;
IP_ADDRESS_SYSTEM.Text = CvSystemProperty.IP_ADDRESS_SYSTEM;
PURCHASE_NO.Text = frmSystemSpecificPurchase.PURCHASE_NO;
_getDetailKikusuiPowerSupply();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (_checkData() == true)
{
CvSystemProperty dataItem = new CvSystemProperty
{
SYSTEM_NAME = system_name.Text,
IP_ADDRESS_SYSTEM = ip_address_system.Text,
DESCRIPTION = description.Text,
IP_ADDRESS = CommonClassLibraryGlobal.IP,
NAME_ADDRESS = CommonClassLibraryGlobal.HOST_NAME,
CREATE_USER = CommonClassLibraryGlobal.OPERATOR_ID,
};
DialogResult res = MessageBox.Show("ยืนยันการบันทึกข้อมูล ?", "การยืนยัน", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.Cancel)
{
return;
}
CvSystemProperty dataItemCheck = new CvSystemProperty();
dataItemCheck = CvSystemController.SearchByIpAddressSystem(dataItem);
if (dataItemCheck != null)
{
CommonClassLibraryGlobal.showSuccess("ip address system นี้มีข้อมูลอยู่แล้ว");
_clearData();
return;
}
if (CvSystemController.Insert(dataItem))
{
CommonClassLibraryGlobal.showSuccess("เพิ่มข้อมูลสำเร็จ");
this.Close();
return;
}
else
{
CommonClassLibraryGlobal.showSuccess("เพิ่มไม่ข้อมูลสำเร็จ กรุณาลองใหม่อีกครั้ง");
return;
}
}
}
public List <CvSystemProperty> Search()
{
List <CvSystemProperty> listItem = new List <CvSystemProperty>();
try
{
_resultData = _model.Search();
if (_resultData.StatusOnDb == true)
{
foreach (DataRow row in _resultData.ResultOnDb.Rows)
{
CvSystemProperty productProperty = new CvSystemProperty
{
ID = row["ID"].ToString(),
SYSTEM_NAME = row["SYSTEM_NAME"].ToString(),
IP_ADDRESS_SYSTEM = row["IP_ADDRESS_SYSTEM"].ToString(),
INUSE = row["INUSE"].ToString(),
DESCRIPTION = row["DESCRIPTION"].ToString(),
CREATE_USER = row["CREATE_USER"].ToString(),
LAST_USER = row["LAST_USER"].ToString(),
CREATE_DATE = row["CREATE_DATE"].ToString(),
LAST_DATE = row["LAST_DATE"].ToString(),
IP_ADDRESS = row["IP_ADDRESS"].ToString(),
NAME_ADDRESS = row["NAME_ADDRESS"].ToString(),
};
listItem.Add(productProperty);
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(listItem);
}
public bool Insert(CvSystemProperty dataItem)
{
bool result = true;
try
{
_resultData = _model.Insert(dataItem);
if (_resultData.StatusOnDb == false)
{
MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
result = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
result = false;
}
return(result);
}
public string Insert(CvSystemProperty dataItem)
{
string sql = @"INSERT INTO tableName
(
ID
, SYSTEM_NAME
, IP_ADDRESS_SYSTEM
, INUSE
, DESCRIPTION
, CREATE_USER
, IP_ADDRESS
, NAME_ADDRESS
)
(
SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0)
, 'dataItem.SYSTEM_NAME'
, 'dataItem.IP_ADDRESS_SYSTEM'
, 1
, 'dataItem.DESCRIPTION'
, 'dataItem.CREATE_USER'
, 'dataItem.IP_ADDRESS'
, 'dataItem.NAME_ADDRESS'
)";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.SYSTEM_NAME", dataItem.SYSTEM_NAME);
sql = sql.Replace("dataItem.IP_ADDRESS_SYSTEM", dataItem.IP_ADDRESS_SYSTEM);
sql = sql.Replace("dataItem.INUSE", dataItem.INUSE);
sql = sql.Replace("dataItem.DESCRIPTION", dataItem.DESCRIPTION);
sql = sql.Replace("dataItem.CREATE_USER", dataItem.CREATE_USER);
sql = sql.Replace("dataItem.LAST_USER", dataItem.LAST_USER);
sql = sql.Replace("dataItem.CREATE_DATE", dataItem.CREATE_DATE);
sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_DATE);
sql = sql.Replace("dataItem.IP_ADDRESS", dataItem.IP_ADDRESS);
sql = sql.Replace("dataItem.NAME_ADDRESS", dataItem.NAME_ADDRESS);
return(sql);
}
public CvSystemProperty SearchByIpAddressSystem(CvSystemProperty dataItem)
{
CvSystemProperty _property = null;
try
{
_resultData = _model.SearchByIpAddressSystem(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
_property = new CvSystemProperty
{
ID = _resultData.ResultOnDb.Rows[0]["ID"].ToString(),
SYSTEM_NAME = _resultData.ResultOnDb.Rows[0]["SYSTEM_NAME"].ToString(),
IP_ADDRESS_SYSTEM = _resultData.ResultOnDb.Rows[0]["IP_ADDRESS_SYSTEM"].ToString(),
INUSE = _resultData.ResultOnDb.Rows[0]["INUSE"].ToString(),
DESCRIPTION = _resultData.ResultOnDb.Rows[0]["DESCRIPTION"].ToString(),
CREATE_USER = _resultData.ResultOnDb.Rows[0]["CREATE_USER"].ToString(),
LAST_USER = _resultData.ResultOnDb.Rows[0]["LAST_USER"].ToString(),
CREATE_DATE = _resultData.ResultOnDb.Rows[0]["CREATE_DATE"].ToString(),
LAST_DATE = _resultData.ResultOnDb.Rows[0]["LAST_DATE"].ToString(),
IP_ADDRESS = _resultData.ResultOnDb.Rows[0]["IP_ADDRESS"].ToString(),
NAME_ADDRESS = _resultData.ResultOnDb.Rows[0]["NAME_ADDRESS"].ToString(),
};
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_property);
}
public OutputOnDbProperty Update(CvSystemProperty dataItem)
{
_resultData = _service.Update(dataItem);
return(_resultData);
}
public OutputOnDbProperty insert(CvSystemProperty dataItem)
{
_resultData = _service.Search();
return(_resultData);
}
public OutputOnDbProperty SearchBySystemId(CvSystemProperty dataItem)
{
_resultData = _service.SearchBySystemId(dataItem);
return(_resultData);
}
public OutputOnDbProperty Insert(CvSystemProperty dataItem)
{
_resultData = _service.Insert(dataItem);
return(_resultData);
}
