public string SearchSerialFormat(SerialTypeProperty dataItem)
{
sql = @"SELECT
ID
,SERIAL_FORMAT
,DETAIL
FROM
`serial_type`
WHERE REPLACE(serial_type.SERIAL_FORMAT , ' ' , '') = REPLACE('" + dataItem.SERIAL_FORMAT + "', ' ' , '');";
return(sql);
}
public List <SerialProductTypeProperty> SearchSerialProductType()
{
List <SerialProductTypeProperty> _result = new List <SerialProductTypeProperty>();
try
{
_resultData = _models.SearchProductType();
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
ProductTypeProperty _productType = new ProductTypeProperty
{
ID = _resultData.ResultOnDb.Rows[i]["PRODUCT_TYPE_ID"].ToString(),
PRODUCT_TITLE = _resultData.ResultOnDb.Rows[i]["PRODUCT_TITLE"].ToString()
};
SerialTypeProperty _serialType = new SerialTypeProperty
{
ID = _resultData.ResultOnDb.Rows[i]["SERIAL_TYPE_ID"].ToString(),
SERIAL_FORMAT = _resultData.ResultOnDb.Rows[i]["SERIAL_FORMAT"].ToString(),
DETAIL = _resultData.ResultOnDb.Rows[i]["DETAIL"].ToString()
};
SerialProductTypeProperty _serialProductType = new SerialProductTypeProperty
{
PRODUCT_TYPE = _productType,
SERIAL_TYPE = _serialType
};
_result.Add(_serialProductType);
}
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
public string InsertSerialFormat(SerialTypeProperty dataItem)
{
sql = @"INSERT INTO `serial_type` (
ID
,SERIAL_FORMAT
,DETAIL
)
(
SELECT CASE WHEN COUNT(`ID`) = 0 THEN 1 ELSE MAX(`ID`)+1 END AS `ID`
,'" + dataItem.SERIAL_FORMAT + @"' AS `SERIAL_FORMAT`
,'" + dataItem.DETAIL + @"' AS `DETAIL`
FROM `serial_type`
);";
return(sql);
}
public List <SerialTypeProperty> Search()
{
List <SerialTypeProperty> _result = new List <SerialTypeProperty>();
try
{
_resultData = _models.Search();
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
SerialTypeProperty SerialTypeProperty = new SerialTypeProperty()
{
ID = _resultData.ResultOnDb.Rows[i]["ID"].ToString(),
SERIAL_FORMAT = _resultData.ResultOnDb.Rows[i]["SERIAL_FORMAT"].ToString(),
DETAIL = _resultData.ResultOnDb.Rows[i]["DETAIL"].ToString(),
DESCRIPTION = _resultData.ResultOnDb.Rows[i]["DESCRIPTION"].ToString(),
CREATE_USER = _resultData.ResultOnDb.Rows[i]["CREATE_USER"].ToString(),
LAST_USER = _resultData.ResultOnDb.Rows[i]["LAST_USER"].ToString(),
CREATE_DATE = _resultData.ResultOnDb.Rows[i]["CREATE_DATE"].ToString(),
LAST_DATE = _resultData.ResultOnDb.Rows[i]["LAST_DATE"].ToString(),
};
_result.Add(SerialTypeProperty);
}
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}