public static SystemModule GetSystemModuleAsObject(DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
try
{
SystemModule o = new SystemModule();
o.Id = Helper.ConvertToInt(row["ID"]);
o.Name = row["NAME"].ToString();
o.Code = row["CODE"].ToString();
o.IsUsed = Helper.ConvertToBoolean(row["IS_USED"]);
o.Notes = row["NOTES"].ToString();
return(o);
}
catch (Exception ex)
{
Log.InsertEntity("SystemModule", "GetSystemModuleAsObject", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
throw ex;
}
}
return(null);
}
public static int Update(SystemModule o)
{
try
{
string query = @"UPDATE ""SYSTEM_MODULE"" SET ""ID"" = @Id, ""NAME"" = @Name, ""CODE"" = @Code, ""IS_USED"" = @IsUsed, ""NOTES"" = @Notes WHERE ""ID"" = @Id ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@Name", DbType.String)
{
Value = o.Name
},
new NpgsqlParameter("@Code", DbType.String)
{
Value = o.Code
},
new NpgsqlParameter("@IsUsed", DbType.Boolean)
{
Value = (object)o.IsUsed ?? DBNull.Value
},
new NpgsqlParameter("@Notes", DbType.String)
{
Value = (object)o.Notes ?? DBNull.Value
},
new NpgsqlParameter("@Id", DbType.Int32)
{
Value = o.Id
}
};
int rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, parameters);
AuditTable.InsertEntity("SystemModule", o.Id.ToString(), 2, DateTime.Now, 1);
return(rowAffected);
}
catch (Exception ex)
{
Log.InsertEntity("SystemModule", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}