public override ModelBase ColumnMapper(DataTable dt)
{
HeckParameter item = new HeckParameter();
item.ID = Convert.ToInt32(dt.Rows[0][0]);
item.Param_Name = Convert.ToString(dt.Rows[0][1]);
item.Param_Value = Convert.ToString(dt.Rows[0][2]);
item.LastUpdateDate = Convert.ToDateTime(dt.Rows[0][3]);
return(item);
}
public DataResponse GetParamByName(string Name)
{
DataResponse resp = null;
DataTable dt = null;
//create query
string query = string.Format("select * from `heckparameter` where PARAM_NAME = '{0}'", Name);
if (RunQuery(query, out dt))
{
HeckParameter item = ColumnMapper(dt) as HeckParameter;
resp = new DataResponse("Heck Paramter Found", true);
resp.Item = item;
}
else
{
resp = new DataResponse("Heck Paramter not found by Name (" + Name + ").", false);
}
return(resp);
}