private List <SYS_OPTION> MapSYS_OPTION(DataTable dt)
{
List <SYS_OPTION> rs = new List <SYS_OPTION>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SYS_OPTION obj = new SYS_OPTION();
if (dt.Columns.Contains("Option_ID"))
{
obj.Option_ID = (dt.Rows[i]["Option_ID"].ToString());
}
if (dt.Columns.Contains("OptionValue"))
{
obj.OptionValue = (dt.Rows[i]["OptionValue"].ToString());
}
if (dt.Columns.Contains("ValueType"))
{
obj.ValueType = int.Parse(dt.Rows[i]["ValueType"].ToString());
}
if (dt.Columns.Contains("System"))
{
obj.System = bool.Parse(dt.Rows[i]["System"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = (dt.Rows[i]["Description"].ToString());
}
rs.Add(obj);
}
return(rs);
}
public int SYS_OPTION_Insert(SYS_OPTION obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_OPTION_Insert",
obj.Option_ID,
obj.OptionValue,
obj.ValueType,
obj.Description
));
}
catch
{
//throw ex;
return(-1);
}
}
public int SYS_OPTION_Update(SYS_OPTION obj, string Option_ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_LOG_Update",
Option_ID,
obj.OptionValue,
obj.ValueType,
obj.Description
));
}
catch
{
//throw ex;
return(-1);
}
}
